Hello all, I finally got accounting on db to work. I added a few extra fields and its all fine. But i have some questions: I added: modparam("acc", "db_extra", "from_uri=$fu ; to_uri=$tu ; from_user=$fU; source_ip=$si") to me config, and all the info gets loaded. BUT, source_ip is not always the ip from which the request was received, either that, or INVITES are not getting logged! well, that's really 2 questions in one... ;) here's my config: # # sample config file to be used with nathelper/rtpproxy # # start RTPProxy with: rtpproxy -l your_public_ip -s udp:localhost:8899 # # ----------- global configuration parameters ------------------------ debug=2 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes # (cmd line: -E) # Uncomment these lines to enter debugging mode #fork=no #log_stderror=yes check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=20 disable_dns_blacklist=true # # --- module loading mpath="/usr/lib/openser/modules/" loadmodule "mysql.so" loadmodule "sl.so" loadmodule "tm.so" loadmodule "rr.so" loadmodule "maxfwd.so" loadmodule "usrloc.so" loadmodule "registrar.so" loadmodule "textops.so" loadmodule "nathelper.so" loadmodule "auth.so" loadmodule "auth_db.so" loadmodule "mi_fifo.so" loadmodule "dispatcher.so" #loadmodule "domain.so" loadmodule "xlog.so" loadmodule "/usr/lib/openser/modules/acc.so" modparam("acc", "early_media", 1) modparam("acc", "report_cancels", 1) modparam("acc", "db_flag", 2) modparam("acc", "db_url", "mysql://openser:password@localhost/openser") modparam("acc", "report_ack", 0) modparam("acc", "db_missed_flag", 3) modparam("acc", "failed_transaction_flag", 4) modparam("acc", "db_extra", "from_uri=$fu ; to_uri=$tu ; from_user=$fU; source_ip=$si") # # CONSTANTS # # --- setting module parameters #modparam("domain","db_url","mysql://openser:password@localhost/openser") #modparam("domain", "db_mode", 1) #modparam("domain", "domain_table", "domain") #modparam("domain", "domain_col", "domain") modparam("xlog", "buf_size", 8192) # --- setting module parameters modparam("dispatcher", "list_file", "/etc/openser/dispatcher.list") # -- mi_fifo params -- modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo") modparam("usrloc|auth_db","db_url","mysql://openser:password@localhost /openser") # -- usrloc params -- modparam("usrloc", "db_mode", 1) modparam("usrloc", "nat_bflag", 6) #modparam("usrloc", "use_domain", 0) # -- registrar params -- modparam("registrar|nathelper", "received_avp", "$avp(i:42)") # -- auth params -- modparam("auth_db", "calculate_ha1", yes) modparam("auth_db", "password_column", "password") #modparam("auth_db", "use_domain", 0) # -- rr params -- #modparam("rr", "enable_full_lr", 1) # -- nathelper modparam("nathelper", "rtpproxy_sock", "udp:1.2.3.4:8899") modparam("nathelper", "natping_interval", 30) modparam("nathelper", "ping_nated_only", 1) modparam("nathelper", "sipping_bflag", 7) modparam("nathelper", "sipping_from", "sip:pinger@sip.whatever.com") #modparam("registrar", "max_contacts", 1) # --- main routing logic route{ if (method=="INVITE") { xlog("L_NOTICE", "INVITE MESSAGE RECEIVED - START ACC\n"); setflag(2); setflag(3); setflag(4); }; if (method=="BYE") { xlog ("L_NOTICE", "BYE - STOP ACCOUNTING\n"); setflag(2); setflag(3); setflag(4); }; if (method=="CANCEL") { xlog ("L_NOTICE", "CANCEL - STOP ACCOUNTING\n"); setflag(2); setflag(3); setflag(4); }; if (method=="REGISTER") { setflag(2); setflag(3); setflag(4); }; if (!mf_process_maxfwd_header("100")) { sl_send_reply("483","Too Many Hops"); exit; }; #if (msg:len >= 2048 ) { # sl_send_reply("513", "Message too big"); # exit; #}; # NAT detection route(2); if (!method=="REGISTER") record_route(); if (loose_route()) { append_hf("P-hint: rr-enforced\r\n"); route(1); }; if (!uri==myself) { # if (!is_uri_host_local() ) { append_hf("P-hint: outbound\r\n"); route(1); }; if (uri==myself) { if (method=="REGISTER") { xlog("L_NOTICE", "\nNew Registration\n"); if (!www_authorize("sip.whatever.com", "subscriber")) { xlog("L_NOTICE", "\nRegistration FAILED! CLIENT: $au\n"); www_challenge("sip.whatever.com", "0"); exit; }; if (isflagset(5)) { xlog("L_NOTICE", "\nRegistration OK\n"); setbflag(6); # if you want OPTIONS natpings uncomment next # setbflag(7); }; save("location"); exit; }; }; route(1); } route[1] { xlog("L_NOTICE", "\n**************IN ROUTE 1************\n"); if (subst_uri('/(sip:.*);nat=yes/\1/')){ setbflag(6); }; if (isflagset(5)||isbflagset(6)) { route(3); } if (!t_relay()) { sl_reply_error(); }; exit; } route[2]{ force_rport(); if (nat_uac_test("19")) { if (method=="REGISTER") { fix_nated_register(); } else { fix_nated_contact(); }; setflag(5); }; } route[3] { if (is_method("BYE|CANCEL")) { unforce_rtp_proxy(); } else if (is_method("INVITE")){ force_rtp_proxy(); t_on_failure("1"); }; if (isflagset(5)) search_append('Contact:.*sip:[^>[:cntrl:]]*', ';nat=yes'); t_on_reply("1"); } failure_route[1] { if (isbflagset(6) || isflagset(5)) { unforce_rtp_proxy(); } } onreply_route[1] { if ((isflagset(5) || isbflagset(6)) && status=~"(183)|(2[0-9][0-9])") { force_rtp_proxy(); } search_append('Contact:.*sip:[^>[:cntrl:]]*', ';nat=yes'); if (isbflagset(6)) { fix_nated_contact(); } exit; } #======================================= Thanks in advance! Any other comment to make this cfg better, i'm all ears!! David