I guess you have to load acc_db module and configure it to point to the appropriate mysql server.
Samuel. 2006/7/27, Ricardo Carvalho rcarvalho@iric.up.pt:
Hi,
I'm trying to enable accounting and missed calls to be written to MySQL tables. I edited my ser.cfg file as suggested in the URL: http://www.iptel.org/ser/doc/seruser/seruser.html#AEN892, but It still doesn't write anything in the DB. What else do I need to do? any clues? Next I'll show my ser.cfg file where in bold is shown the changes I made to try to enable accounting.
Regards,
Ricardo Carvalho.
# my ser.cfg script: debug=4 fork=no log_stderror=yes
listen=192.168.10.91 # put your server IP address here port=5060 children=4 alias=my.site.com dns=yes rev_dns=no fifo="/tmp/ser_fifo" fifo_db_url="mysql://ser:heslo@localhost/ser"
loadmodule "/usr/local/lib/ser/modules/mysql.so" loadmodule "/usr/local/lib/ser/modules/sl.so" loadmodule "/usr/local/lib/ser/modules/tm.so" loadmodule "/usr/local/lib/ser/modules/rr.so" loadmodule "/usr/local/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/lib/ser/modules/usrloc.so" loadmodule "/usr/local/lib/ser/modules/registrar.so" loadmodule "/usr/local/lib/ser/modules/uri_db.so" loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so" loadmodule "/usr/local/lib/ser/modules/acc.so"
modparam("auth_db|uri_db|usrloc", "db_url", "mysql://ser:heslo@localhost/ser") modparam("auth_db", "calculate_ha1", 1) modparam("auth_db", "password_column", "password") modparam("usrloc", "db_mode", 3) modparam("rr", "enable_full_lr", 1)
# set the reporting log level modparam("acc", "log_level", 1) # number of flag, which will be used for accounting; if a message is # labeled with this flag, its completion status will be reported modparam("acc", "log_flag", 1 )
route {
#
# Sanity Check Section #
if (!mf_process_maxfwd_header("10")) { sl_send_reply("483", "Too Many Hops"); break; }; if (msg:len > max_len) { sl_send_reply("513", "Message Overflow"); break; }; #
# Record Route Section #
if (method!="REGISTER") { record_route(); }; #
# Loose Route Section #
if (loose_route()) { route(1); break; }; # labeled all transaction for accounting: setflag(1); #
# Call Type Processing Section #
if (uri!=myself) { route(1); break; }; if (method=="ACK") { route(1); break; } else if (method=="INVITE") { route(3); break; } else if (method=="REGISTER") { route(2); break; }; lookup("aliases"); if (uri!=myself) { route(1); break; }; if (!lookup("location")) { sl_send_reply("404", "User Not Found"); break; }; route(1);}
route[1] {
#
# Default Message Handler #
if (!t_relay()) { sl_reply_error(); };}
route[2] {
#
# REGISTER Message Handler #
sl_send_reply("100", "Trying"); if (!www_authorize("","subscriber")) { www_challenge("","0"); break; }; if (!check_to()) { sl_send_reply("401", "Unauthorized"); break; }; consume_credentials(); if (!save("location")) { sl_reply_error(); };}
route[3] { #
# INVITE Message Handler #
if (!proxy_authorize("","subscriber")) { proxy_challenge("","0"); break; } else if (!check_from()) { sl_send_reply("403", "Use From=ID"); break; }; consume_credentials(); lookup("aliases"); if (uri!=myself) { route(1); break; }; if (!lookup("location")) { sl_send_reply("404", "User Not Found"); break; }; route(1);}
Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers