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@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=XXXXXXXsip:XX@XXXXXXXX.XXX;tag=bb025f6b, i-uri=sip:XXXXXX@XXXXXX.XXX, method=INVITE, o-uri=sip:XX@XXXXXXXX.XXX:10003;line=7lr13il5, fromtag=bb025f6b, code=200, to=sip:XX@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@XXXXXXXX.XXX;tag=bb025f6b, i-uri=sip:XXXXX@XXXXXXXXXX:10003;line=7lr13il5, method=BYE, o-uri=sip:XXXXX@XXXXXXXXXX:10003;line=7lr13il5, fromtag=bb025f6b, code=200, to=sip:XXXXXXX@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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers