<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Yep, I agree.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I had to edit the Makefile in the
/modules/acc directory to enable it to use a MySQL database.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Once I recompiled it worked fine.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>This should be documented properly –
there is plenty of information about using Ser with MySQL and how to setup the
module, but very little about this!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The one thing which really lets Ser down to
non-programmers like myself, is the lack of, or very outdated documentation. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Lets hope that the imminent new release
has some up to date documents!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Andy T<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> sip
[mailto:sip@arcdiv.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> 20 August 2006 16:23<br>
<b><span style='font-weight:bold'>To:</span></b> Roger Lewau; 'Alberto Cruz';
'Andy Thomas'<br>
<b><span style='font-weight:bold'>Cc:</span></b> serusers-bounces@lists.iptel.org;
<st1:PersonName w:st="on">serusers@lists.iptel.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: SV: [Serusers]
problem with acc module settings</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Sounds to
me like the acc module you have wasn't compiled with the db code active.
When you compile the 0.9.x acc module, there's an option in the makefile to
uncomment a flag to activate mysql accounting and another option to uncomment
the flag to enable radius accounting. <o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>If your
acc module was compiled with the defaults, none of the acc db-related functions
will be available (this it NOT related to acc_db which is actually now a
separate module). <o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>If you're
using a package, you may need to download the source for 0.9.6, go into the
modules/acc section, edit the Makefile, and look for the commented db flag
(it's near the beginning), uncomment it, and then recompile just that module
from the main src tree. Once the module has compiled, you can replace the
module you currently have with the new one compiled to have the db functions
enabled and start SER. <o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Bit of a
pain, but not too bad, really. <o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>N. <o:p></o:p></span></font></p>
<p class=MsoNormal><b><font size=2 face="Times New Roman"><span
style='font-size:10.0pt;font-weight:bold'><br>
<br>
<br>
On Sun, 20 Aug 2006 12:00:01 +0200, Roger Lewau wrote</span></font></b><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I have just set up a new SER server using
SER 0.9.6 on FreeBSD 6.1. I then copied my working config file from my SER
0.9.3 installation and run ser -c to verify the config file and get the
following errors:</span></font><font size=2><span style='font-size:10.0pt'> <br>
> <br>
> </span></font><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>sip1# ser -c <br>
> 0(68102) set_mod_param_regex: parameter <db_url> not found in
module <acc> <br>
> 0(68102) parse error (49,20-21): Can't set module parameter <br>
> 0(68102) set_mod_param_regex: parameter <db_flag> not found in
module <acc> <br>
> 0(68102) parse error (76,19-20): Can't set module parameter <br>
> 0(68102) set_mod_param_regex: parameter <db_missed_flag> not
found in module <acc> <br>
> 0(68102) parse error (77,19-20): Can't set module parameter <br>
> ERROR: bad config file (3 errors) <br>
> </span></font><font size=2><span style='font-size:10.0pt'><br>
> </span></font><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>When I search this news list for answers I
found the conversation below. But I found that there is no acc_db.so module
anywhere. Not in source and not in /usr/local/lib/ser/modules. I looked in
FreeBSD package, ports and even in released source code on iptel but no such
module is to be found anywhere. I studied the realese documents but there is
nothing said about changes in the acc module.</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> <br>
> </span></font><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Any one who had his issue and solved it?.</span></font><font
size=2><span style='font-size:10.0pt'> <br>
> <br>
> </span></font><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Thanks in advance.</span></font><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Roger</span></font><font size=2><span
style='font-size:10.0pt'> <br>
> <br>
> <br>
> <o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=2
face="Times New Roman"><span style='font-size:10.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>Från:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> serusers-bounces@lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org] <b><span style='font-weight:bold'>För
</span></b>Alberto Cruz <br>
> <b><span style='font-weight:bold'>Skickat:</span></b> den 27 juni 2006
04:27 <br>
> <b><span style='font-weight:bold'>Till:</span></b> Andy Thomas <br>
> <b><span style='font-weight:bold'>Kopia:</span></b> <st1:PersonName w:st="on">serusers@lists.iptel.org</st1:PersonName>
<br>
> <b><span style='font-weight:bold'>Ämne:</span></b> Re: [Serusers] problem
with acc module settings <br>
> <b><span style='font-weight:bold'>Prioritet:</span></b> Hög <br>
> </span></font><font size=2><span style='font-size:10.0pt'><br>
> <br>
> You should remove the following line: <br>
> loadmodule "/usr/lib/ser/modules/acc.so" <br>
> <br>
> And you need to add the following: <br>
> loadmodule "/usr/lib/ser/modules/acc_db.so" <br>
> <br>
> Andy Thomas wrote: <br>
> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Times New Roman"><span style='font-size:
10.0pt'><br>
<!-- style begin
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
style end -->>
<br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi,<u1:p/></span></font><font size=2><span style='font-size:
10.0pt'> <br>
> <br>
<u1:p/>> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I cant start Ser 0.9.6<u1:p/></span></font><font size=2><span
style='font-size:10.0pt'> <br>
> <br>
<u1:p/>> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I get the following error when I start it up<u1:p/></span></font><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>0(4628) set_mod_param_regex: parameter <db_url> not
found in module <acc><u1:p/></span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> 0(4628) parse error (87,20-21): Can't set module
parameter<u1:p/></span></font><font size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> 0(4628) set_mod_param_regex: parameter
<db_missed_flag> not found in module <acc><u1:p/></span></font><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> 0(4628) parse error (92,19-20): Can't set module
parameter<u1:p/></span></font><font size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> 0(4628) set_mod_param_regex: parameter <db_flag>
not found in module <acc><u1:p/></span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> 0(4628) parse error (93,19-20): Can't set module
parameter<u1:p/></span></font><font size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>ERROR: bad config file (3 errors)<u1:p/></span></font><font
size=2><span style='font-size:10.0pt'> <br>
> <br>
<u1:p/>> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Here’s my settings for the acc module – can
anyone see whats wrong with it??<u1:p/></span></font><font size=2><span
style='font-size:10.0pt'> <br>
> <br>
<u1:p/>> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>modparam("acc", "db_url",
"mysql://ser:heslo@localhost/ser")<u1:p/></span></font><font size=2><span
style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>modparam("acc", "log_level", 1)<u1:p/></span></font><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>modparam("acc", "log_flag", 1)<u1:p/></span></font><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>modparam("acc", "log_missed_flag", 2)<u1:p/></span></font><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>modparam("acc", "log_fmt",
"fimos")<u1:p/></span></font><font size=2><span style='font-size:
10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>modparam("acc", "db_missed_flag", 2)<u1:p/></span></font><font
size=2><span style='font-size:10.0pt'> <br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>modparam("acc", "db_flag", 1)<u1:p/></span></font><font
size=2><span style='font-size:10.0pt'> <br>
> <br>
<u1:p/>> <o:p></o:p></span></font></p>
<u1:p/><pre><font size=2 face="Courier New"><span style='font-size:10.0pt'><o:p> </o:p></span></font></pre><pre
style='text-align:center'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>
<hr size=4 width="90%" align=center>
</span></font></pre><pre><font size=2 face="Courier New"><span
style='font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>_______________________________________________<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>Serusers mailing list<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'><a
href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a><o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'><a
href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a><o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> <o:p></o:p></span></font></pre>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2
face="Times New Roman"><span style='font-size:10.0pt'><br>
<br>
</span></font><o:p></o:p></p>
</div>
</body>
</html>