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@lists.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: Edgardo O. Gonzales
II
To: Kofi Obiri-Yeboah
Cc: serusers@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();
};
}