SV: [Serusers] problem with acc module settings

[Andy Thomas]

Yep, I agree.

I had to edit the Makefile in the /modules/acc directory to enable it to use
a MySQL database.

Once I recompiled it worked fine.

 

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!

 

The one thing which really lets Ser down to non-programmers like myself, is
the lack of, or very outdated documentation. 

Lets hope that the imminent new release has some up to date documents!

 

Andy T

 

  _____  

From: sip [mailto:sip at arcdiv.com] 
Sent: 20 August 2006 16:23
To: Roger Lewau; 'Alberto Cruz'; 'Andy Thomas'
Cc: serusers-bounces at lists.iptel.org; serusers at lists.iptel.org
Subject: Re: SV: [Serusers] problem with acc module settings

 

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. 

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). 

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. 

Bit of a pain, but not too bad, really. 

N. 




On Sun, 20 Aug 2006 12:00:01 +0200, Roger Lewau wrote 
> 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: 
>   
> sip1# ser -c 
>  0(68102) set_mod_param_regex: parameter <db_url> not found in module
<acc> 
>  0(68102) parse error (49,20-21): Can't set module parameter 
>  0(68102) set_mod_param_regex: parameter <db_flag> not found in module
<acc> 
>  0(68102) parse error (76,19-20): Can't set module parameter 
>  0(68102) set_mod_param_regex: parameter <db_missed_flag> not found in
module <acc> 
>  0(68102) parse error (77,19-20): Can't set module parameter 
> ERROR: bad config file (3 errors) 
> 
> 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. 
>   
> Any one who had his issue and solved it?. 
>   
> Thanks in advance. 
> Roger 
>   
> 
> 

  _____  

Från: serusers-bounces at lists.iptel.org
[mailto:serusers-bounces at lists.iptel.org] För Alberto Cruz 
> Skickat: den 27 juni 2006 04:27 
> Till: Andy Thomas 
> Kopia: serusers at lists.iptel.org 
> Ämne: Re: [Serusers] problem with acc module settings 
> Prioritet: Hög 
> 
> 
> You should remove the following line: 
> loadmodule "/usr/lib/ser/modules/acc.so" 
> 
> And you need to add the following: 
> loadmodule "/usr/lib/ser/modules/acc_db.so" 
> 
> Andy Thomas wrote: 
> 


> 
> Hi, 
> 
> I cant start Ser 0.9.6 
> 
> I get the following error when I start it up 
> 0(4628) set_mod_param_regex: parameter <db_url> not found in module <acc> 
>  0(4628) parse error (87,20-21): Can't set module parameter 
>  0(4628) set_mod_param_regex: parameter <db_missed_flag> not found in
module <acc> 
>  0(4628) parse error (92,19-20): Can't set module parameter 
>  0(4628) set_mod_param_regex: parameter <db_flag> not found in module
<acc> 
>  0(4628) parse error (93,19-20): Can't set module parameter 
> ERROR: bad config file (3 errors) 
> 
> Here’s my settings for the acc module – can anyone see whats wrong with
it?? 
> 
> modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser") 
> modparam("acc", "log_level", 1) 
> modparam("acc", "log_flag", 1) 
> modparam("acc", "log_missed_flag", 2) 
> modparam("acc", "log_fmt", "fimos") 
> modparam("acc", "db_missed_flag", 2) 
> modparam("acc", "db_flag", 1) 
> 
> 

 





  _____  



 
_______________________________________________
Serusers mailing list
Serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
  





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20060820/813866f0/attachment.htm>