New subject: Fwd: acc_cdrs empty

30 Mar 2016


      Hello,
I am not able to set up cdr.
I see acc table is updated with 2 new entries after each call (INVITE and
BYE) but acc_cdrs is empty.
There are errors in the log.
I think that I set up everything but is not working,
- load the module, set module params and set the flag? Am I missing
something, should I use a store procedure or something?
------------------------------------------------------------------------------------------------------------
loadmodule "acc.so"
modparam("acc", "early_media", 0)
modparam("acc", "report_ack", 0)
modparam("acc", "report_cancels", 0)
modparam("acc", "detect_direction", 1)
modparam("acc", "db_flag", FLT_ACC)
modparam("acc", "db_missed_flag", FLT_ACCMISSED)
modparam("acc", "db_url", DBURL)
modparam("acc", "cdr_enable", 1)
modparam("acc", "cdr_start_on_confirmed", 1)
modparam("acc", "cdrs_table", "acc_cdrs")
modparam("acc", "cdr_start_id", "start_time")
modparam("acc", "cdr_end_id", "end_time")
modparam("acc", "cdr_duration_id", "duration")
if (is_method("INVITE")) {
        setflag(FLT_ACC); # do accounting
    }
route[WITHINDLG] {
    if (has_totag()) {
        if (loose_route()) {
            route(DLGURI);
            if (is_method("BYE")) {
CREATE TABLE `acc_cdrs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `start_time` varchar(32) NOT NULL DEFAULT '',
  `end_time` varchar(32) NOT NULL DEFAULT '',
  `duration` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `start_time_idx` (`start_time`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1$$
Thank you.