<!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=265102417-08072005><FONT face=Arial color=#0000ff size=2>you
need to edit modules/acc/Makefile and enable sql accounting if you want
it.</FONT></SPAN></DIV>
<DIV><SPAN class=265102417-08072005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=265102417-08072005><FONT face=Arial color=#0000ff size=2>Btw,
.8.12 is pretty old, you should upgrade to .8.14 if you want to use the 8.x
series. Or upgrade to 9.3, though doing so will probably break stuff, its
not fully compatible.</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> serusers-bounces@lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org]<B>On Behalf Of </B>Yiannis
Martis<BR><B>Sent:</B> Friday, July 08, 2005 9:54 AM<BR><B>To:</B>
serusers@lists.iptel.org<BR><B>Subject:</B> [Serusers] MySQL accounting does not
work in ser 0.8.12<BR><BR></FONT></DIV>
<DIV>
<DIV class=RTE>
<P><BR>Ca anyone help me with ser 0.8.12 accounting?</P>
<P>I have installed rpm distro of ser 0.8.12 but mysql accounting does not
work. Ser will not start!</P>
<P>Can anyone please help me? Here's my ser.cfg part specific to
accounting</P>
<P> </P>
<P># -------------------GLOBAL CONFIGURATION PARAMETERS
------------------------#<BR>#############################################################################</P>
<P>debug=3 # debug level (cmd line:
-dddddddddd)<BR>fork=yes<BR>log_stderror=no # (cmd line: -E)</P>
<P>listen=XX.XX.XX.XX <BR>listen=127.0.0.1</P>
<P>alias=XXXXXXXXXXXXX.com<BR>alias=xx.xx.xx.xx.xx<BR>alias=xxxxxxxxxxxxx.com<BR>alias=xxxxxxxxxxxxxl.com</P>
<P>/* Uncomment these lines to enter debugging mode
<BR>#debug=7<BR>#fork=no<BR>#log_stderror=yes<BR>*/</P>
<P>dns=no # (cmd.
line: -r)<BR>rev_dns=no # (cmd. line: -R)</P>
<P>port=5060<BR>children=4</P>
<P>check_via=yes # (cmd. line: -v)</P>
<P>syn_branch=yes</P>
<P>sip_warning=yes</P>
<P>fifo="/tmp/ser_fifo"<BR>fifo_mode=0666</P>
<P>server_signature=yes</P>
<P>reply_to_via=no</P>
<P>#uid="nobody"</P>
<P>#gid="nobody"</P>
<P>#mhomed=0</P>
<P><BR># -----------------MODULE LOADING
----------------------------------#<BR>#####################################################################</P>
<P># Uncomment this if you want to use SQL database<BR>loadmodule
"/usr/lib/ser/modules/mysql.so"</P>
<P>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"</P>
<P># 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"</P>
<P>loadmodule "/usr/lib/ser/modules/acc.so"<BR>loadmodule
"/usr/lib/ser/modules/exec.so"<BR>loadmodule
"/usr/lib/ser/modules/group.so"<BR>loadmodule
"/usr/lib/ser/modules/print.so"<BR>loadmodule
"/usr/lib/ser/modules/textops.so"<BR>loadmodule
"/usr/lib/ser/modules/uri.so"</P>
<P># ----------------- SETTING MODULE-SPECIFIC PARAMETERS
------------------#<BR>##########################################################################</P>
<P># ------------- tm params -------------------------</P>
<P>modparam("tm", "fr_timer", 12)<BR>modparam("tm", "fr_inv_timer", 24)</P>
<P># -------------- rr params ------------------------</P>
<P># add value to ;lr param to make some broken UAs happy<BR>modparam("rr",
"enable_full_lr", 1)</P>
<P># -------------- accounting params ----------------<BR>modparam("acc",
"log_missed_flag", 3)<BR>modparam("acc", "log_level", 1)<BR>modparam("acc",
"log_flag", 1)<BR>#modparam("acc", "db_url",
"sql://ser:XXXXXXXXX@localhost/ser")<BR>#modparam("acc", "db_flag",
1)<BR>#modparam("acc", "failed_transactions", 1)<BR># -------------- usrloc
params --------------------</P>
<P>#modparam("usrloc", "db_mode", 0)</P>
<P># Uncomment this if you want to use SQL database <BR># for persistent
storage and comment the previous line<BR>modparam("usrloc", "db_mode", 2)</P>
<P>#database location<BR>modparam("usrloc", "db_url",
"sql://ser:XXXXXXXX6@localhost/ser")</P>
<P># -------------- auth params ----------------------</P>
<P>#database location<BR>modparam("auth_db", "db_url",
"sql://ser:XXXXXXXXXXX@localhost/ser")</P>
<P># 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><BR></P></DIV></DIV><BR clear=all>
<HR>
Don't just search. Find. <A href="http://g.msn.com/8HMAEN/2746??PS=47575"
target=_top>MSN Search</A> Check out the new MSN Search!
</BLOCKQUOTE></BODY></HTML>