An update, I removed the rpid=$re from db_extra parameter and now calls are flowing fine. Can that be the whole issue?<br><br><div class="gmail_quote">On Thu, Feb 19, 2009 at 3:09 PM, Uriel Rozenbaum <span dir="ltr"><<a href="mailto:uriel.rozenbaum@gmail.com">uriel.rozenbaum@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hey guys,<br><br>I'm using kamailio-1.4.3-notls with ACC module on mysql.<br><br>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:<br>
<br>Feb 19 08:48:57 ops3 /usr/local/sbin/kamailio[4895]: INFO:core:handle_sigs: child process 4899 exited by a signal 11<br>Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4895]: INFO:core:handle_sigs: core was generated<br>
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4895]: INFO:core:handle_sigs: terminating due to SIGCHLD<br>Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4902]: INFO:core:sig_usr: signal 15 received<br>Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4903]: INFO:core:sig_usr: signal 15 received<br>
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4901]: INFO:core:sig_usr: signal 15 received<br>Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4897]: INFO:core:sig_usr: signal 15 received<br>Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4904]: INFO:core:sig_usr: signal 15 received<br>
Feb 19 08:48:58 ops3 /usr/local/sbin/kamailio[4898]: INFO:core:sig_usr: signal 15 received<br><br>This issue only happens when i account messages using the following lines:<br>if (is_method("INVITE|BYE|CANCEL"))<br>
{<br> setflag(1);<br> setflag(2);<br> }<br><br>and the configuration for the modules are ass follows:<br># ----- acc params -----<br> /* what sepcial events should be accounted ? */<br>
modparam("acc", "early_media", 1)<br>modparam("acc", "report_ack", 1)<br>modparam("acc", "report_cancels", 1)<br> /* by default ww do not adjust the direct of the sequential requests.<br>
if you enable this parameter, be sure the enable "append_fromtag"<br> in "rr" module */<br>modparam("acc", "detect_direction", 0)<br> /* account triggers (flags) */<br>modparam("acc", "failed_transaction_flag", 3)<br>
modparam("acc", "log_flag", 1)<br>modparam("acc", "log_missed_flag", 2)<br> /* uncomment the following lines to enable DB accounting also */<br>modparam("acc", "db_flag", 1)<br>
modparam("acc", "db_missed_flag", 2)<br> # Descomentar para guardar parametros adicionales<br> # modparam("acc", "log_extra", "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd")<br>
modparam("acc", "db_table_acc", "acc")<br>modparam("acc", "db_table_missed_calls", "missed_calls")<br>modparam("acc", "db_url",<br> "mysql://kamailio:kamailiorw@localhost/kamailio")<br>
modparam("acc", "acc_method_column", "method")<br>modparam("acc", "acc_from_tag_column", "from_tag")<br>modparam("acc", "acc_to_tag_column", "to_tag")<br>
modparam("acc", "acc_callid_column", "callid")<br>modparam("acc", "acc_sip_code_column", "sip_code")<br>modparam("acc", "acc_sip_reason_column", "sip_reason")<br>
modparam("acc", "acc_time_column", "time")<br>modparam("acc", "db_extra",<br>"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")<br>
<br>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?<br><br>Thanks in advance!<br><font color="#888888">Uriel<br>
</font></blockquote></div><br>