Re: [Kamailio-Users] ACC with mysql

Sure, but I'll need some guidance on obtaining it; I'm just checking with the syslog messages with debugging level in 3. Can you show me how to do it? Thanks, Uriel On Thu, Feb 19, 2009 at 6:38 PM, Daniel-Constantin Mierla &lt;miconda(a)gmail.com > > > On 02/19/2009 10:01 PM, Uriel Rozenbaum wrote: > >> An update, I removed the rpid=$re from db_extra parameter and now calls >> are flowing fine. Can that be the whole issue? >> > There were some similar issues in the past, but they should have been fixed > long time ago. I see you got a core dump, can you send the backtrace, it > will help to troubleshoot. > > Thanks, > Daniel > > >> On Thu, Feb 19, 2009 at 3:09 PM, Uriel Rozenbaum < >> uriel.rozenbaum(a)gmail.com <mailto:uriel.rozenbaum@gmail.com>>> >> 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 >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Kamailio (OpenSER) - Users mailing list >> Users(a)lists.kamailio.org >> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users >> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users >> > > -- > Daniel-Constantin Mierla > http://www.asipto.com > >