[OpenSIPS-Users] ACC module Opensips 2.1.1 and MySql

[Vincent DOCQUOIS]

Hello all,

I have installed Opensips 2.1.1 on Debian 8.2 and migrated a configuration that was working on Opensips 1.11. All is fine except that the ACC module seems no longer to write CDR in mysql database.
Just to be sure, I have replaced my opensips.cfg by the trunking sample and I have the same issue : ACC data are written in syslog file but never in mysql DB although the "db_url" parameter is set.

Note that I get no error at start and that the mysql DB is working well with the other modules especially the dialog module. It was also working without any problem in Opensips 1.11.

Here is my "acc" config based on the trunking sample config :

#### ACCounting module
loadmodule "acc.so"
/* what special events should be accounted ? */
modparam("acc", "early_media", 0)
modparam("acc", "report_cancels", 0)
/* by default we do not adjust the direct of the sequential requests.
   if you enable this parameter, be sure the enable "append_fromtag"
   in "rr" module */
modparam("acc", "detect_direction", 0)
modparam("acc", "failed_transaction_flag", "ACC_FAILED")
/* account triggers (flags) */
modparam("acc", "log_level", 1)
modparam("acc", "log_flag", "ACC_DO")
modparam("acc", "log_missed_flag", "ACC_MISSED")
modparam("acc", "db_url","mysql://opensips:password@localhost/opensips") 

Here is a syslog extract I get after a call :

Nov  2 10:19:10 nvopensips03 /usr/local/opensips/sbin/opensips[1880]: Do accounting
Nov  2 10:19:10 nvopensips03 /usr/local/opensips/sbin/opensips[1863]: ACC: transaction answered: timestamp=1446455950;method=INVITE;from_tag=6997206237350283298;to_tag=a02d8118-4701e60a-13c4-55022-38886-30eed03f-38886;call_id=6997206237350283298-1446455950-1032;code=200;reason=OK
Nov  2 10:19:20 nvopensips03 /usr/local/opensips/sbin/opensips[1857]: ACC: transaction answered: timestamp=1446455960;method=BYE;from_tag=6997206237350283298;to_tag=a02d8118-4701e60a-13c4-55022-38886-30eed03f-38886;call_id=6997206237350283298-1446455950-1032;code=200;reason=OK


Have I missed something ? 
Thanks in advanced for any help.

Vincent D.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20151102/548fcde5/attachment.htm>