any other help to make accounting work ..
At 03:52 AM 4/28/2005, Leon Sun wrote:
For me, 0.8.12 was same.
From: Edgardo O. Gonzales II [mailto:edgardo.g@pacific.net.ph] Sent: April 27, 2005 12:12 PM To: Leon Sun; 'Barry Murphy'; 'Kofi Obiri-Yeboah' Cc: serusers@lists.iptel.org Subject: RE: [Serusers] ACC into mysql
Im also using 0.8.14 version of ser .. any other good suggestion .. have you tried using other ver of ser ..
At 03:10 AM 4/28/2005, Leon Sun wrote:
Edgardo,
Whats your SER version?
Me either.
I even couldnt put modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser") into ser.cfg. It showed error in file.
It seemed 0.8.14 doesnt like it.
From: serusers-bounces@iptel.org [ mailto:serusers-bounces@lists.iptel.org] On Behalf Of Edgardo O. Gonzales II Sent: April 27, 2005 11:17 AM To: Barry Murphy; Kofi Obiri-Yeboah Cc: serusers@lists.iptel.org Subject: Re: [Serusers] ACC into mysql
Hi!
my accounting is still not working though im not receiving any error message during my startup. Its nto logging my transaction on my db.
Can you please check my ser.cfg file below .. Please put your comments ..
thanks, ed
======================
debug=7 #fork=no #log_stderror=yes
check_via=no dns=no rev_dns=no port=5060 #children=4 fifo="/tmp/ser_fifo"
# ------------------ module loading ----------------------------------
loadmodule "/usr/local/ser/lib/ser/modules/mysql.so" loadmodule "/usr/local/ser/lib/ser/modules/sl.so" loadmodule "/usr/local/ser/lib/ser/modules/tm.so" loadmodule "/usr/local/ser/lib/ser/modules/rr.so" loadmodule "/usr/local/ser/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/ser/lib/ser/modules/usrloc.so" loadmodule "/usr/local/ser/lib/ser/modules/registrar.so" loadmodule "/usr/local/ser/lib/ser/modules/auth.so" loadmodule "/usr/local/ser/lib/ser/modules/auth_db.so" loadmodule "/usr/local/ser/lib/ser/modules/acc.so"
# ----------------- setting module-specific parameters ---------------
# -- usrloc params --
modparam("usrloc", "db_mode", 1) modparam("usrloc", "db_url","mysql://ser:heslo@localhost/ser")
# -- auth params --
modparam("auth_db", "calculate_ha1", yes) modparam("auth_db", "password_column", "password")
# -- rr params --
modparam("rr", "enable_full_lr", 1)
# -- acc params --
modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1) modparam("acc", "log_missed_flag", 3) modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser") modparam("acc", "db_flag", 2) modparam("acc", "failed_transactions", 1)
# ------------------------- request routing logic -------------------
alias=test.com
# main routing logic
route{ if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); break; }; if ( msg:len > max_len ) { sl_send_reply("513", "Message too big"); break; };
record_route(); if (loose_route()) { t_relay(); break; }; if (uri=~"test.com") { if (method=="REGISTER") { setflag(1); setflag(2); if (!www_authorize("test.com", "subscriber")) { www_challenge("test.com", "0"); break; }; save("location"); break; }; lookup("aliases"); if (!lookup("location")) { sl_send_reply("404", "Not Found"); break; }; }; if (!t_relay()) { sl_reply_error(); };
}
======================================
At 02:47 PM 4/26/2005, Barry Murphy wrote:
Mine works, just I dont get the BYE into mysql, even though I see it in ngrep.
Secondly if i call my PBX (Asterisk) via ser and the asterisk hangs up after giving the time, the call doesnt end on SER it remains connected.
Stupid stupid thing :(
Barry
----- Original Message ----- From: mailto:edgardo.g@pacific.net.phEdgardo O. Gonzales II To: mailto:kofi@radiocomplex.comKofi Obiri-Yeboah Cc: mailto:serusers@lists.iptel.orgserusers@lists.iptel.org Sent: Tuesday, April 26, 2005 6:29 PM Subject: RE: [Serusers] ACC into mysql
Thanks again for your help .. Here's my running ser.cfg Hope you can help me make my accounting work.. thanks, ed ================================================================ # ----------- global configuration parameters ------------------------ #debug=3 #fork=yes #log_stderror=no #debug=7 #fork=no #log_stderror=yes check_via=no dns=no rev_dns=no #port=5060 #children=4 fifo="/tmp/ser_fifo" # ------------------ module loading ---------------------------------- loadmodule "/usr/local/ser/lib/ser/modules/mysql.so" loadmodule "/usr/local/ser/lib/ser/modules/sl.so" loadmodule "/usr/local/ser/lib/ser/modules/tm.so" loadmodule "/usr/local/ser/lib/ser/modules/rr.so" loadmodule "/usr/local/ser/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/ser/lib/ser/modules/usrloc.so" loadmodule "/usr/local/ser/lib/ser/modules/registrar.so" loadmodule "/usr/local/ser/lib/ser/modules/auth.so" loadmodule "/usr/local/ser/lib/ser/modules/auth_db.so" loadmodule "/usr/local/ser/lib/ser/modules/acc.so" # ----------------- setting module-specific parameters --------------- # -- usrloc params -- modparam("usrloc", "db_mode", 1) modparam("usrloc", "db_url","mysql://ser:heslo@localhost/ser") # -- auth params -- modparam("auth_db", "calculate_ha1", yes) modparam("auth_db", "password_column", "password") # -- rr params -- modparam("rr", "enable_full_lr", 1) # -- acc params -- modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1) modparam("acc", "log_missed_flag", 3) # ------------------------- request routing logic ------------------- alias=abc.com.ph # main routing logic route{ if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); break; }; if ( msg:len > max_len ) { sl_send_reply("513", "Message too big"); break; }; record_route(); if (loose_route()) { t_relay(); break; }; if (uri=~"abc.com.ph") { if (method=="REGISTER") { if (!www_authorize("abc.com.ph", "subscriber")) { www_challenge("abc.com.ph", "0"); break; }; save("location"); break; }; lookup("aliases"); if (!lookup("location")) { sl_send_reply("404", "Not Found"); break; }; }; if (!t_relay()) { sl_reply_error(); }; }