<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="Open WebMail 2.20 20031014" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<p>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.
<br /></p>
<p>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).
<br /></p>
<p>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.
<br /></p>
<p>Bit of a pain, but not too bad, really.
<br /></p>
<p>N.
<br /></p>
<font size="2"><b>
<br />
<br />
<br />On Sun, 20 Aug 2006 12:00:01 +0200, Roger Lewau wrote</b>
<br />> <span class="984154909-20082006"><font size="2" face="Arial" color="#0000ff">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:</font></span>
<br />> <span class="984154909-20082006"></span>
<br />> <span class="984154909-20082006"><font size="2" face="Arial" color="#0000ff">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 />> </font></span>
<br />> <span class="984154909-20082006"><font size="2" face="Arial" color="#0000ff">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.</font></span>
<br />> <span class="984154909-20082006"></span>
<br />> <span class="984154909-20082006"><font size="2" face="Arial" color="#0000ff">Any one who had his issue and solved
it?.</font></span>
<br />> <span class="984154909-20082006"></span>
<br />> <span class="984154909-20082006"><font size="2" face="Arial" color="#0000ff">Thanks in advance.</font></span>
<br />> <span class="984154909-20082006"><font size="2" face="Arial" color="#0000ff">Roger</font></span>
<br />> <span class="984154909-20082006"> </span>
<br />>
<br />>
<hr tabindex="-1" />
<font size="2" face="Tahoma"><b>Från:</b> serusers-bounces@lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org] <b>För </b>Alberto
Cruz
<br />> <b>Skickat:</b> den 27 juni 2006 04:27
<br />> <b>Till:</b> Andy
Thomas
<br />> <b>Kopia:</b> serusers@lists.iptel.org
<br />> <b>Ämne:</b> Re: [Serusers]
problem with acc module settings
<br />> <b>Prioritet:</b> Hög
<br />> </font>
<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 />>
<blockquote type="cite" cite="mid000001c6977c$c7db1340$0b0a000a@andyhome">
<!-- 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 />>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Hi,<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">I cant start Ser
0.9.6<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">I get the following error when I
start it up<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">0(4628) set_mod_param_regex:
parameter <db_url> not found in module
<acc><o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> 0(4628) parse error
(87,20-21): Can't set module parameter<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> 0(4628) set_mod_param_regex:
parameter <db_missed_flag> not found in module
<acc><o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> 0(4628) parse error
(92,19-20): Can't set module parameter<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> 0(4628) set_mod_param_regex:
parameter <db_flag> not found in module
<acc><o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"> 0(4628) parse error
(93,19-20): Can't set module parameter<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">ERROR: bad config file (3
errors)<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">Here’s my settings for the acc
module – can anyone see whats wrong with it??<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modparam("acc", "db_url",
"mysql://ser:heslo@localhost/ser")<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modparam("acc", "log_level",
1)<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modparam("acc", "log_flag",
1)<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modparam("acc", "log_missed_flag",
2)<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modparam("acc", "log_fmt",
"fimos")<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modparam("acc", "db_missed_flag",
2)<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;">modparam("acc", "db_flag",
1)<o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p /></span></font>
<br />> <font size="2" face="Arial"><span style="font-size: 10pt; font-family: arial;"><o:p /></span></font>
<pre wrap="">
<hr width="90%" size="4" />
_______________________________________________
Serusers mailing list
<a href="mailto:Serusers@lists.iptel.org" class="moz-txt-link-abbreviated">Serusers@lists.iptel.org</a>
<a href="http://lists.iptel.org/mailman/listinfo/serusers" class="moz-txt-link-freetext">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre></blockquote>
<br />
<br />
<br />
</font>
</BODY>
</HTML>