<html>
<body>
<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>
<blockquote type=cite class=cite cite="">
<font face="arial" size=2 color="#000080">Edgardo,<br>
<br>
What’s your SER version?<br>
<br>
Me either.<br>
<br>
I even couldn’t put </font>modparam("acc", "db_url",
"mysql://ser:heslo@localhost/ser") into ser.cfg. It showed
error in file. <br>
<font face="Times New Roman, Times"> <br>
It seemed 0.8.14 doesn’t like it. <br>
</font><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><font face="Times New Roman, Times"> <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><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>
<font face="Times New Roman, Times">----- 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>
<br>
================================================================<br>
At 10:55 AM 4/26/2005, Kofi Obiri-Yeboah wrote:<br><br>
</font><font face="arial" size=2 color="#0000FF">I am assuming your
question is if the record_route() function is a parameter for accounting?
If that was your question then the answer is no. Generally you invoke
record_route() to ensure acl acceptance on a gateway (i.e. all calls
through that gateway)</font> <br>
<font face="tahoma" size=2>-----Original Message----- <br>
From: Edgardo O. Gonzales II [
<a href="mailto:edgardo.g@pacific.net.ph" eudora="autourl">
mailto:edgardo.g@pacific.net.ph</a>] <br>
Sent: Monday, April 25, 2005 6:22 PM <br>
To: Kofi Obiri-Yeboah <br>
Cc: serusers@lists.iptel.org <br>
Subject: RE: [Serusers] ACC into mysql<br>
</font><font face="Times New Roman, Times">Hi Kofi!<br>
got it.. thanks for immediate feedback .. however my accounting is not
working. <br>
any parameters to be added to make it work..<br>
I have the following info already on my ser.cfg<br>
modparam("acc", "log_level", 1) <br>
modparam("acc", "log_flag", 1) <br>
modparam("acc", "log_missed_flag", 3)<br>
record_route(); -> its this a parameter for accounting<br>
thanks, <br>
ed<br>
At 08:32 AM 4/26/2005, Kofi Obiri-Yeboah wrote:<br>
</font><font face="arial" size=2 color="#0000FF">I think the correct
modparam statement should read as follows:</font> <br>
<font face="Times New Roman, Times">modparam("acc",
"db_url", "mysql://ser:heslo@localhost/ser")<br>
<br>
</font><font face="arial" size=2>please note that "my" is
required in front of sql</font> <br>
<font face="Times New Roman, Times"> <br>
</font><font face="arial" size=2>and not: <br>
modparam("acc", "db_url",
"sql://ser:heslo@localhost/ser")</font> <br>
<font face="tahoma" size=2>-----Original Message----- <br>
From: serusers-bounces@lists.iptel.org [
<a href="mailto:serusers-bounces@lists.iptel.org%5DOn" eudora="autourl">
mailto:serusers-bounces@lists.iptel.org]On</a> Behalf Of Edgardo O. Gonzales II
<br>
Sent: Monday, April 25, 2005 5:20 PM <br>
To: serusers@lists.iptel.org <br>
Subject: Re: [Serusers] ACC into mysql<br>
</font><font face="Times New Roman, Times">Hi all! <br>
Im also receiving this error message. <br>
Can somebody help us on how to make accounting work using mysql. <br>
thanks, <br>
ed <br>
At 06:01 AM 4/26/2005, Leon Sun wrote: <br>
</font><font face="arial" size=2>Hi, <br>
I am using 0.8.12 in Fedora 3. I tried to log account info into Mysql
followed instruction from manual. I found, first,
modparam("acc", "db_url",
"sql://ser:heslo@localhost/ser") coudnlt work at all in
ser.cfg. If I enabled in cfg file, it showed Starting ser: ERROR:
bad config file (1 errors) <br>
If I disabled it, SER worked fine but I couldnt see any record in acc
table. <br>
Would anyone suggest how to put call records into Mysql? <br>
Thank you.<br>
# ----------- global configuration parameters ------------------------
<br>
#debug=3 # debug level
(cmd line: -dddddddddd) <br>
#fork=yes <br>
#log_stderror=no # (cmd line:
-E) <br>
/* Uncomment these lines to enter debugging mode <br>
debug=7 <br>
fork=no <br>
log_stderror=yes <br>
*/ <br>
check_via=no # (cmd. line: -v) <br>
dns=no #
(cmd. line: -r) <br>
rev_dns=no # (cmd. line: -R) <br>
#port=5060 <br>
#children=4 <br>
fifo="/tmp/ser_fifo" <br>
# ------------------ module loading ----------------------------------
<br>
# Uncomment this if you want to use SQL database <br>
loadmodule "/usr/lib/ser/modules/mysql.so" <br>
loadmodule "/usr/lib/ser/modules/acc.so" <br>
loadmodule "/usr/lib/ser/modules/sl.so" <br>
loadmodule "/usr/lib/ser/modules/tm.so" <br>
loadmodule "/usr/lib/ser/modules/rr.so" <br>
loadmodule "/usr/lib/ser/modules/maxfwd.so" <br>
loadmodule "/usr/lib/ser/modules/usrloc.so" <br>
loadmodule "/usr/lib/ser/modules/registrar.so" <br>
# Uncomment this if you want digest authentication <br>
# mysql.so must be loaded ! <br>
loadmodule "/usr/lib/ser/modules/auth.so" <br>
loadmodule "/usr/lib/ser/modules/auth_db.so" <br>
# ----------------- setting module-specific parameters ---------------
<br>
#modparam("acc", "db_url",
"sql://ser:heslo@localhost/ser") <br>
# -- usrloc params -- <br>
#modparam("usrloc", "db_mode", 0) <br>
# Uncomment this if you want to use SQL database <br>
# for persistent storage and comment the previous line <br>
modparam("usrloc", "db_mode", 2) <br>
# -- auth params -- <br>
# Uncomment if you are using auth module <br>
# <br>
modparam("auth_db", "calculate_ha1", yes) <br>
# <br>
# If you set "calculate_ha1" parameter to yes (which true in
this config), <br>
# uncomment also the following parameter) <br>
# <br>
modparam("auth_db", "password_column",
"password") <br>
# -- rr params -- <br>
# add value to ;lr param to make some broken UAs happy <br>
modparam("rr", "enable_full_lr", 1)<br>
modparam("acc","log_level",1) <br>
modparam("acc","log_flag",1) <br>
# ------------------------- request routing logic
------------------- <br>
# main routing logic <br>
route{ <br>
# initial sanity checks --
messages with <br>
# max_forwards==0, or
excessively long requests <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>
# we record-route all messages
-- to make sure that <br>
# subsequent messages will go
through our proxy; that's <br>
# particularly good if
upstream and downstream entities <br>
# use different transport
protocol <br>
record_route(); <br>
# loose-route processing <br>
if (loose_route()) { <br>
if (method=="BYE") { <br>
setflag(1); <br>
setflag(2); <br>
} <br>
t_relay(); <br>
break; <br>
}; <br>
#labeled all transaction for
accounting <br>
setflag(1); <br>
setflag(2); <br>
if
(method=="CANCEL"){ <br>
t_relay(); <br>
}; <br>
# (in case, it does not work,
use the following command <br>
# with proper names and
addresses in it)<br>
if (uri==myself) { <br>
# This for PSTN destination <br>
if (uri=~"^sip:1") <br>
{
rewritehost("10.10.10.10"); <br>
forward(10.10.10.10,5060); <br>
break; <br>
} <br>
if (method=="REGISTER") { <br>
# Uncomment this if you want to use digest authentication <br>
if (!www_authorize("sip.mycommunications.com",
"subscriber")) { <br>
www_challenge("sip.mycommunications.com", "0"); <br>
break; <br>
}; <br>
save("location"); <br>
break; <br>
}; <br>
# native SIP destinations are handled using our USRLOC DB <br>
if (!lookup("location")) { <br>
sl_send_reply("404", "Not Found"); <br>
break; <br>
}; <br>
}; <br>
# forward to current uri now;
use stateful forwarding; that <br>
# works reliably even if we
forward from TCP to UDP <br>
if (!t_relay()) { <br>
sl_reply_error(); <br>
}; <br>
}</font> <br>
<font face="Times New Roman, Times">
_______________________________________________ <br>
Serusers mailing list <br>
serusers@lists.iptel.org <br>
<a href="http://lists.iptel.org/mailman/listinfo/serusers" eudora="autourl">
http://lists.iptel.org/mailman/listinfo/serusers</a><br>
<br>
<hr>
<div align="center"></div>
_______________________________________________<br>
Serusers mailing list<br>
serusers@lists.iptel.org<br>
<a href="http://lists.iptel.org/mailman/listinfo/serusers" eudora="autourl">
http://lists.iptel.org/mailman/listinfo/serusers</a></font></blockquote>
</body>
</html>