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@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] För Alberto Cruz

Skickat: den 27 juni 2006 04:27 Till: Andy Thomas Kopia: serusers@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 listSerusers@lists.iptel.orghttp://lists.iptel.org/mailman/listinfo/serusers

Yep had to go into the source and activate the DB logging for acc manually. Recompiled acc and now it works properly.

Thank you for your help.

Kind regards Roger

_____

Från: sip [mailto:sip@arcdiv.com] Skickat: den 20 augusti 2006 17:23 Till: Roger Lewau; 'Alberto Cruz'; 'Andy Thomas' Kopia: serusers-bounces@lists.iptel.org; serusers@lists.iptel.org Ämne: 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@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] För Alberto Cruz

Skickat: den 27 juni 2006 04:27 Till: Andy Thomas Kopia: serusers@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@lists.iptel.org

http://lists.iptel.org/mailman/listinfo/serusers