Kamailio 3.3.0 CDR logging call "duration" - sr-users

15 Oct 2012

Hello

Kamailio 3.3.0
All default "extra fields" created in database. I create in Database new
field "duration" and trying write in this field variable $DLG_lifetime
(from dialog module) , but can't do this. What i'm doing wrong?

installed modules: ACC, DIALOG
# ----- acc params -----
/* what special events should be accounted ? */
modparam("acc", "early_media", 0)
modparam("acc", "report_ack", 0)
modparam("acc", "report_cancels", 0)
modparam("acc", "detect_direction", 0)
/* account triggers (flags) */
modparam("acc", "log_level", 1)
modparam("acc", "log_flag", FLT_ACC)
modparam("acc", "log_missed_flag", FLT_ACCMISSED)
modparam("acc", "log_extra",
        "src_user=$fU;src_domain=$fd;src_ip=$si;"
        "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd;"
        "duration=$DLG_lifetime")
modparam("acc", "failed_transaction_flag", FLT_ACCFAILED)
/* enhanced DB accounting */
modparam("acc", "db_flag", FLT_ACC)
modparam("acc", "db_missed_flag", FLT_ACCMISSED)
modparam("acc", "db_url", DBURL)
modparam("acc", "db_extra",
        "src_user=$fU;src_domain=$fd;src_ip=$si;"      /* extra fields
created in DataBase */
        "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd;"
        "duration=$DLG_lifetime")
modparam("acc", "cdr_enable", 1)
modparam("acc", "cdr_start_on_confirmed", 0)
modparam("acc", "cdr_facility", "LOG_DAEMON")

# ----- dialog params -----
modparam("dialog", "enable_stats", 1)
modparam("dialog", "hash_size", 4096)
modparam("dialog", "rr_param", "did")
modparam("dialog", "dlg_flag", DLG_FLAG)  /* DLG_FLAG=4 */
modparam("dialog", "default_timeout", 21600)
modparam("dialog", "timeout_avp", "$avp(i:10)")
modparam("dialog", "dlg_match_mode", 0)
modparam("dialog", "detect_spirals", 1)
modparam("dialog", "db_url", DBURL)
modparam("dialog", "db_mode", 1)
modparam("dialog", "db_fetch_rows", 500)

########Routing Logic########

route[RELAY] {

        # enable additional event routes for forwarded requests
        # - serial forking, RTP relaying handling, a.s.o.
        if (is_method("INVITE|SUBSCRIBE")) {
                t_on_branch("MANAGE_BRANCH");
                t_on_reply("MANAGE_REPLY");
        }
        if (is_method("INVITE")) {
                t_on_failure("MANAGE_FAILURE");
        }
        setflag(DLG_FLAG); # flag 4 duration
        setflag(FLT_ACC); # do accounting ...
        setflag(FLT_ACCFAILED); # ... even if the transaction fails
        if (!t_relay()) {
                sl_reply_error();
        }
        exit;
}