[Serusers] SER Accounting with MYSQL

Vitaly Nikolaev vitaly at switchgate.com
Fri Aug 27 15:20:17 CEST 2004


You have to mark transaction that you want to have in acc:

if( (method=="INVITE") || (method=="ACK") || (method=="BYE")) {
                setflag(1);     
}


And just in case:
############ ACC
loadmodule "/usr/local/lib/ser/modules/acc.so"
modparam("acc", "db_url", "sql://ser:XXX@localhost/ser")
modparam("acc", "db_flag", 1)
modparam("acc", "db_missed_flag", 1)
modparam("acc", "failed_transactions", 1)
############


> -----Original Message-----
> From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org]
On
> Behalf Of Razvan Nemesiu
> Sent: Friday, August 27, 2004 7:03 AM
> To: serusers at lists.iptel.org
> Subject: [Serusers] SER Accounting with MYSQL
> 
> 
> Sorry for posting this message again but I had problems with the
> subscription
> 
> 
> Hi ..I have a problem with the ser accounting..I installed
> ser-0.8.12_src.tar.gz with acc and mysql modules by editing the acc
> makefile to enable SQL accounting and by editing the ser makefile to
> include mysql module.I installed mysql server and client and I ran
> ser_mysql.sh to create my ser database.I configured ser.cfg to connect
to
> the ser mysql database and I configured ser_mysql.sh ( I changed the
> password ). Everything is fine ..Ser starts with no errors and
realisezes
> user authentication.I have also added db_flag to ser.cfg.I can place
calls
> but the MAIN PROBLEM is that I can't see any accounting information in
> MySQL ser database....Can anyone help me ?..Thanks
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers





More information about the sr-users mailing list