<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=768021803-26042005><FONT face=Arial color=#0000ff
size=2>ed</FONT></SPAN></DIV>
<DIV><SPAN class=768021803-26042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=768021803-26042005><FONT face=Arial color=#0000ff size=2>please
send me the complete text of your ser.cfg file. As you may be aware, modules
need to be called in a particular sequence, then after that, the appropriate
parameters need to be passed to the modules. I may be able to help if I could
read through the top portion of your script</FONT></SPAN></DIV>
<DIV><SPAN class=768021803-26042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=768021803-26042005><FONT face=Arial color=#0000ff
size=2>Kofi</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Edgardo O. Gonzales II
[mailto:edgardo.g@pacific.net.ph]<BR><B>Sent:</B> Monday, April 25, 2005 6:22
PM<BR><B>To:</B> Kofi Obiri-Yeboah<BR><B>Cc:</B>
serusers@lists.iptel.org<BR><B>Subject:</B> RE: [Serusers] ACC into
mysql<BR><BR></FONT></DIV><BR>Hi Kofi!<BR><BR>got it.. thanks for immediate
feedback .. however my accounting is not working.<BR>any parameters to be
added to make it work..<BR><BR>I have the following info already on my
ser.cfg<BR><BR>modparam("acc", "log_level", 1)<BR>modparam("acc", "log_flag",
1)<BR>modparam("acc", "log_missed_flag", 3)<BR><BR><BR>record_route(); ->
its this a parameter for accounting<BR><BR>thanks,<BR>ed<BR><BR><BR>At 08:32
AM 4/26/2005, Kofi Obiri-Yeboah wrote:<BR>
<BLOCKQUOTE class=cite cite="" type="cite"><FONT face=arial color=#0000ff
size=2>I think the correct modparam statement should read as
follows:<BR></FONT><FONT face=arial size=2><B>modparam("acc", "db_url",
"mysql://ser:heslo@localhost/ser")<BR></B></FONT> <BR><FONT face=arial
size=2><B>please note that "my" is required in front of
sql<BR></B></FONT> <BR><FONT face=arial size=2><B>and
not:<BR>modparam("acc", "db_url",
"sql://ser:heslo@localhost/ser")</B></FONT> <FONT face=arial color=#0000ff
size=2><BR><BR></FONT>
<DL>
<DD><FONT face=tahoma size=2>-----Original Message-----<BR>
<DD>From:</B> serusers-bounces@lists.iptel.org [<A
href="mailto:serusers-bounces@lists.iptel.org" eudora="autourl">
mailto:serusers-bounces@lists.iptel.org</A>]On Behalf Of </B>Edgardo O. Gonzales
II<BR>
<DD>Sent:</B> Monday, April 25, 2005 5:20 PM<BR>
<DD>To:</B> serusers@lists.iptel.org<BR>
<DD>Subject:</B> Re: [Serusers] ACC into mysql<BR><BR></FONT><BR>
<DD>Hi all!<BR><BR>
<DD>Im also receiving this error message.<BR><BR>
<DD>Can somebody help us on how to make accounting work using
mysql.<BR><BR>
<DD>thanks,<BR>
<DD>ed<BR><BR>
<DD>At 06:01 AM 4/26/2005, Leon Sun wrote:<BR>
<BLOCKQUOTE class=cite cite="" type="cite">
<DD><FONT face=arial size=2>Hi, <BR>
<DD>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>
<DD><BR>
<DD>If I disabled it, SER worked fine but I couldnt see any record in
acc table. <BR>
<DD><BR>
<DD>Would anyone suggest how to put call records into Mysql? <BR></B>
<DD><BR>
<DD>Thank you.<BR>
<DD><BR>
<DD><BR>
<DD><BR>
<DD># ----------- global configuration parameters
------------------------<BR>
<DD><BR>
<DD>#debug=3 # debug
level (cmd line: -dddddddddd)<BR>
<DD>#fork=yes<BR>
<DD>#log_stderror=no # (cmd
line: -E)<BR>
<DD><BR>
<DD>/* Uncomment these lines to enter debugging mode<BR>
<DD>debug=7<BR>
<DD>fork=no<BR>
<DD>log_stderror=yes<BR>
<DD>*/<BR>
<DD><BR>
<DD>check_via=no # (cmd. line: -v)<BR>
<DD>dns=no #
(cmd. line: -r)<BR>
<DD>rev_dns=no # (cmd. line: -R)<BR>
<DD>#port=5060<BR>
<DD>#children=4<BR>
<DD>fifo="/tmp/ser_fifo"<BR>
<DD><BR>
<DD># ------------------ module loading
----------------------------------<BR>
<DD><BR>
<DD># Uncomment this if you want to use SQL database<BR>
<DD>loadmodule "/usr/lib/ser/modules/mysql.so"<BR>
<DD><BR>
<DD>loadmodule "/usr/lib/ser/modules/acc.so"<BR>
<DD>loadmodule "/usr/lib/ser/modules/sl.so"<BR>
<DD>loadmodule "/usr/lib/ser/modules/tm.so"<BR>
<DD>loadmodule "/usr/lib/ser/modules/rr.so"<BR>
<DD>loadmodule "/usr/lib/ser/modules/maxfwd.so"<BR>
<DD>loadmodule "/usr/lib/ser/modules/usrloc.so"<BR>
<DD>loadmodule "/usr/lib/ser/modules/registrar.so"<BR>
<DD><BR>
<DD># Uncomment this if you want digest authentication<BR>
<DD># mysql.so must be loaded !<BR>
<DD>loadmodule "/usr/lib/ser/modules/auth.so"<BR>
<DD>loadmodule "/usr/lib/ser/modules/auth_db.so"<BR>
<DD><BR>
<DD># ----------------- setting module-specific parameters
---------------<BR>
<DD><BR>
<DD>#modparam("acc", "db_url", "sql://ser:heslo@localhost/ser")<BR></B>
<DD><BR>
<DD># -- usrloc params --<BR>
<DD><BR>
<DD>#modparam("usrloc", "db_mode", 0)<BR>
<DD><BR>
<DD># Uncomment this if you want to use SQL database<BR>
<DD># for persistent storage and comment the previous line<BR>
<DD>modparam("usrloc", "db_mode", 2)<BR>
<DD><BR>
<DD># -- auth params --<BR>
<DD># Uncomment if you are using auth module<BR>
<DD>#<BR>
<DD>modparam("auth_db", "calculate_ha1", yes)<BR>
<DD>#<BR>
<DD># If you set "calculate_ha1" parameter to yes (which true in this
config),<BR>
<DD># uncomment also the following parameter)<BR>
<DD>#<BR>
<DD>modparam("auth_db", "password_column", "password")<BR>
<DD><BR>
<DD># -- rr params --<BR>
<DD># add value to ;lr param to make some broken UAs happy<BR>
<DD>modparam("rr", "enable_full_lr", 1)<BR>
<DD><BR>
<DD><BR>
<DD>modparam("acc","log_level",1)<BR>
<DD>modparam("acc","log_flag",1)<BR>
<DD># ------------------------- request routing logic
-------------------<BR>
<DD><BR>
<DD># main routing logic<BR>
<DD><BR>
<DD>route{<BR>
<DD><BR>
<DD> # initial sanity checks
-- messages with<BR>
<DD> # max_forwards==0, or
excessively long requests<BR>
<DD> if
(!mf_process_maxfwd_header("10")) {<BR>
<DD>
sl_send_reply("483","Too Many Hops");<BR>
<DD>
break;<BR>
<DD> };<BR>
<DD> if ( msg:len > max_len
) {<BR>
<DD>
sl_send_reply("513", "Message too big");<BR>
<DD>
break;<BR>
<DD> };<BR>
<DD><BR>
<DD> # we record-route all
messages -- to make sure that<BR>
<DD> # subsequent messages
will go through our proxy; that's<BR>
<DD> # particularly good if
upstream and downstream entities<BR>
<DD> # use different transport
protocol<BR>
<DD> record_route();<BR>
<DD> # loose-route
processing<BR>
<DD> if (loose_route()) {<BR>
<DD>
if (method=="BYE") {<BR>
<DD>
setflag(1);<BR>
<DD>
setflag(2);<BR>
<DD>
}<BR>
<DD><BR>
<DD>
t_relay();<BR>
<DD><BR>
<DD>
break;<BR>
<DD> };<BR>
<DD><BR>
<DD> #labeled all transaction
for accounting<BR>
<DD> setflag(1);<BR>
<DD> setflag(2);<BR>
<DD><BR>
<DD> if
(method=="CANCEL"){<BR>
<DD>
t_relay();<BR>
<DD>
};<BR>
<DD><BR>
<DD> # (in case, it does not
work, use the following command<BR>
<DD> # with proper names and
addresses in it)<BR>
<DD><BR>
<DD><BR>
<DD> if (uri==myself) {<BR>
<DD><BR>
<DD>
# This for PSTN destination<BR>
<DD><BR>
<DD>
if (uri=~"^sip:1")<BR>
<DD><BR>
<DD>
{ rewritehost("10.10.10.10");<BR>
<DD>
forward(10.10.10.10,5060);<BR>
<DD>
break;<BR>
<DD>
}<BR>
<DD>
if (method=="REGISTER") {<BR>
<DD><BR>
<DD>
# Uncomment this if you want to use digest authentication<BR>
<DD>
if (!www_authorize("sip.mycommunications.com", "subscriber")) {<BR>
<DD>
www_challenge("sip.mycommunications.com", "0");<BR>
<DD>
break;<BR>
<DD>
};<BR>
<DD><BR>
<DD>
save("location");<BR>
<DD>
break;<BR>
<DD>
};<BR>
<DD><BR>
<DD>
# native SIP destinations are handled using our USRLOC DB<BR>
<DD>
if (!lookup("location")) {<BR>
<DD>
sl_send_reply("404", "Not Found");<BR>
<DD>
break;<BR>
<DD>
};<BR>
<DD> };<BR>
<DD> # forward to current uri
now; use stateful forwarding; that<BR>
<DD> # works reliably even if
we forward from TCP to UDP<BR>
<DD> if (!t_relay()) {<BR>
<DD>
sl_reply_error();<BR>
<DD> };<BR>
<DD><BR>
<DD>}<BR></FONT>
<DD>_______________________________________________<BR>
<DD>Serusers mailing list<BR>
<DD>serusers@lists.iptel.org<BR>
<DD><A href="http://lists.iptel.org/mailman/listinfo/serusers"
eudora="autourl">http://lists.iptel.org/mailman/listinfo/serusers</A></DD></BLOCKQUOTE></DD></DL></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>