[Serusers] SER Accounting to MYSQL - NO newbee-question

Marian Dumitru marian.dumitru at voice-sistem.ro
Thu Feb 10 19:53:03 CET 2005


Hi Michael,

just add in your script, in module parameter section:

  modparam("acc", "db_missed_flag", 3)
  modparam("acc", "db_flag", 1)

of course, you can use different flags for setting syslog logging or DB 
logging.

Best regards,
Marian


Michael Treiber wrote:
> Hi!
> 
> using ser 0.8.14 at gentoo + serweb for several months.
> want to enable accounting to mysql so i can see transactions in serweb.
> 
> i can see the INVITE / BYE - logging in log-file:
> 
> Feb 10 10:32:41 [/usr/sbin/ser] ACC: transaction answered:
> call_id=20007e1d3f0e277f, totag=ezzzyno2cs,
> from=XXXXXXX<sip:XX at XXXXXXXX.XXX>;tag=bb025f6b, 
> i-uri=sip:XXXXXX at XXXXXX.XXX,
> method=INVITE, o-uri=sip:XX at XXXXXXXX.XXX:10003;line=7lr13il5,
> fromtag=bb025f6b, code=200, to=<sip:XX at XXXXXXXX.XXX>;tag=ezzzyno2cs,
> uid=n/a, userpart=mtreiber_
> 
> Feb 10 10:32:49 [/usr/sbin/ser] ACC: transaction answered:
> call_id=20007e1d3f0e277f, totag=ezzzyno2cs,
> from="YYY"<sip:XX at XXXXXXXX.XXX>;tag=bb025f6b,
> i-uri=sip:XXXXX at XXXXXXXXXX:10003;line=7lr13il5, method=BYE,
> o-uri=sip:XXXXX at XXXXXXXXXX:10003;line=7lr13il5, fromtag=bb025f6b,
> code=200, to=<sip:XXXXXXX at XXXXX.XXX>;tag=ezzzyno2cs, uid=n/a,
> userpart=mtreiber_
> 
> 
> BUT SER is NOT logging to MySQL.. :(
> theres no attempt from ser to write accounting-data to mysql.
> 
> all other mysql-request (register,userlookups, etc.. ) are ok.
> 
> 
> i set "DEFS+=-DSQL_ACC" in acc-module at compile.
> 
> modules are loaded:
> 
> accounting-loadmodule "/usr/lib/ser/modules/mysql.so"
> loadmodule "/usr/lib/ser/modules/sl.so"
> loadmodule "/usr/lib/ser/modules/tm.so"
> loadmodule "/usr/lib/ser/modules/rr.so"
> loadmodule "/usr/lib/ser/modules/maxfwd.so"
> loadmodule "/usr/lib/ser/modules/usrloc.so"
> loadmodule "/usr/lib/ser/modules/registrar.so"
> loadmodule "/usr/lib/ser/modules/auth.so"
> loadmodule "/usr/lib/ser/modules/auth_db.so"
> loadmodule "/usr/lib/ser/modules/acc.so"
> loadmodule "/usr/lib/ser/modules/exec.so"
> loadmodule "/usr/lib/ser/modules/group.so"
> loadmodule "/usr/lib/ser/modules/print.so"
> loadmodule "/usr/lib/ser/modules/textops.so"
> loadmodule "/usr/lib/ser/modules/uri.so"
> 
> modparam are set:
> 
> modparam("acc", "log_missed_flag", 3)
> modparam("acc", "log_level", 1)
> modparam("acc", "log_flag", 1)
> modparam("acc", "db_url", "sql://ser:heslo@localhost/ser")
> modparam("acc", "report_cancels", 0)
> modparam("acc", "report_ack", 0)
> modparam("acc", "log_fmt", "cdfimorstup")
> modparam("acc", "failed_transactions", 1)
> 
> 
> flags are set correct:
> 
> if(method=="INVITE"  || (method=="ACK") || method=="BYE" ){
>                 setflag(1);
>         };
> 
> 
> if you have ANY idea please let me know...
> 
> regards,
> Michael.
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
> 

-- 
Voice System
http://www.voice-system.ro




More information about the sr-users mailing list