[Kamailio-Users] ACC with mysql

[Uriel Rozenbaum]

Hey guys,

I'm using kamailio-1.4.3-notls with ACC module on mysql.

I'm trying to benchmark it installed on a virtual server (Xen on CentOS) and
I have everything going OK for my basic configuration but when I turn on ACC
(by flagging transactions) I get the following lines on the log:

Feb 19 08:48:57 ops3 /usr/local/sbin/kamailio[4895]: INFO:core:handle_sigs:
child process 4899 exited by a signal 11
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4895]: INFO:core:handle_sigs:
core was generated
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4895]: INFO:core:handle_sigs:
terminating due to SIGCHLD
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4902]: INFO:core:sig_usr:
signal 15 received
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4903]: INFO:core:sig_usr:
signal 15 received
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4901]: INFO:core:sig_usr:
signal 15 received
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4897]: INFO:core:sig_usr:
signal 15 received
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4904]: INFO:core:sig_usr:
signal 15 received
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4898]: INFO:core:sig_usr:
signal 15 received

This issue only happens when i account messages using the following lines:
if (is_method("INVITE|BYE|CANCEL"))
        {
                setflag(1);
                setflag(2);
        }

and the configuration for the modules are ass follows:
# ----- acc params -----
 /* what sepcial events should be accounted ? */
modparam("acc", "early_media", 1)
modparam("acc", "report_ack", 1)
modparam("acc", "report_cancels", 1)
 /* by default ww 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)
 /* account triggers (flags) */
modparam("acc", "failed_transaction_flag", 3)
modparam("acc", "log_flag", 1)
modparam("acc", "log_missed_flag", 2)
 /* uncomment the following lines to enable DB accounting also */
modparam("acc", "db_flag", 1)
modparam("acc", "db_missed_flag", 2)
 # Descomentar para guardar parametros adicionales
 # modparam("acc", "log_extra",
"src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd")
modparam("acc", "db_table_acc", "acc")
modparam("acc", "db_table_missed_calls", "missed_calls")
modparam("acc", "db_url",
        "mysql://kamailio:kamailiorw@localhost/kamailio")
modparam("acc", "acc_method_column", "method")
modparam("acc", "acc_from_tag_column", "from_tag")
modparam("acc", "acc_to_tag_column", "to_tag")
modparam("acc", "acc_callid_column", "callid")
modparam("acc", "acc_sip_code_column", "sip_code")
modparam("acc", "acc_sip_reason_column", "sip_reason")
modparam("acc", "acc_time_column", "time")
modparam("acc", "db_extra",
"cseq=$cs;privacy=$dip;reason=$dir;from_uri=$fu;from_username=$fU;from_displayname=$fn;from_domain=$fd;req_username=$rU;req_domain=$rd;rpid=$re;source_ip_addr=$si;source_port=$sp;to_uri=$tu;to_username=$tU;to_displayname=$tn;to_domain=$td;original_uri=$ou;original_uri_username=$oU;original_uri_domain=$od;unix_timestamp=$Ts")

Do you think there is something I'm missing on the configuration? I tried to
modify parameters on mysql but get the same errors all the time?

Thanks in advance!
Uriel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20090219/9b222282/attachment.htm