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