You have to enable database support in acc (uncomment line #DEFS+=-DSQL_ACC) in sip_router/modules/acc/Makefile and recompile and reinstall the module.
Jan.
On 25-07 16:22, Director General: NEFACOMP wrote:
Trying to use ACC with MySQL stops SER and restarts X.
The message found in the log file (/var/log/messages) is:
ser: set_mod_param_regex: parameter <db_url> not found in module <acc> ser: parse error (65, 58-59): Can't set module parameter ser: set_mod_param_regex: parameter <db_flag> not found in module <acc> ser: parse error (65, 58-59): Can't set module parameter ser: set_mod_param_regex: parameter <db_missed_flag> not found in module
<acc> ser: parse error (65, 58-59): Can't set module parameter .... =====
The parameters db_url, db_flag, dg_missed_flag cannot be found in ACC module.
Will this get solved please? Do you know anyone who uses acc with MySQL and it works??
Thanks Emery ----- Original Message ----- From: "Jan Janak" jan@iptel.org To: "Director General: NEFACOMP" dg@nefacomp.net Cc: "Juan J. Sierralta P." juanjo@atmlab.utfsm.cl; serusers@lists.iptel.org Sent: Friday, July 25, 2003 01:05 Subject: Re: [Serusers] Voicemail implementation
On 25-07 00:03, Director General: NEFACOMP wrote:
A file like this one is needed for aliases and accounting to MySQL. (I mean a complete ser.cfg file)
I don't have a simple config file showing aliases and accounting. Aliases are easy, simply put lookup("aliases"); into your script, it is good to enclose it into something like this:
if (uri==myself) { ... lookup("aliases"); ... };
The condition ensures that the proxy will use the aliases only if the request is targeted to your proxy.
And then you, of course, need to create some aliases (for example using serctl utility).
Regarding accounting, that one is easy too:
- load acc module
- put the following into modparam section of your file: modparam("acc", "report_ack", 1) modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1 ) modparam("acc", "db_flag", 1 ) modparam("acc", "log_missed_flag", 3 ) modparam("acc", "db_missed_flag", 3 ) # report to syslog: From, i-uri, status, digest id modparam("acc", "log_fmt", "fisu" )
And then, when your script is processing a request that you want to
account,
simply call:
setflag(1);
That's it.
Jan.