[Kamailio-Users] ACC with mysql

Uriel Rozenbaum uriel.rozenbaum at gmail.com
Thu Feb 19 22:16:21 CET 2009


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 <miconda at gmail.com
> wrote:

>
>
> 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 at gmail.com <mailto:uriel.rozenbaum at gmail.com>> wrote:
>>
>>    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 at 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20090219/1a8da831/attachment.htm 


More information about the Users mailing list