25 Jul
2003
25 Jul
'03
6:52 p.m.
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(a)iptel.org>
To: "Director General: NEFACOMP" <dg(a)nefacomp.net>
Cc: "Juan J. Sierralta P." <juanjo(a)atmlab.utfsm.cl>cl>;
<serusers(a)lists.iptel.org>
Sent: Friday, July 25, 2003 01:05
Subject: Re: [Serusers] Voicemail implementation
On 25-07 00:03, Director General: NEFACOMP
wrote:
account,
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:
1) load acc module
2) 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 simply call:
setflag(1);
That's it.
Jan.