10 Feb
2005
10 Feb
'05
6:17 p.m.
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=XXXXXXX<sip: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.