From alexandre.abreu@redt.com.br Wed Mar 23 16:31:05 2011
From: Alexandre Abreu <alexandre.abreu@redt.com.br>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] RES: RES:  event_route and acc_db_request().
Date: Wed, 23 Mar 2011 12:30:54 -0300
Message-ID: <012101cbe96f$4f696520$ee3c2f60$@redt.com.br>
In-Reply-To: <4D89FF28.80601@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1850131262=="

--===============1850131262==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

Hi Daniel,

Look the request/reply.

<...>
<?xml version="1.0" encoding="UTF-8"?>.
<methodCall>.
<methodName>mi dlg_terminate_dlg</methodName>.
<params>.
<param><value><string>065fa668d8485f33</string></value></param>.
</params>.
</methodCall>.

<...>
<?xml version="1.0"?>
<methodResponse>
<fault>
<value>
<struct>
<member>
<name>faultCode</name>
<value><int>500</int></value>
</member>
<member>
<name>faultString</name>
<value><string>Method Not Found</string></value>
</member>
</struct>
</value>
</fault>
</methodResponse>

This is module xmlrpc handling the POST at route[XMLRPC]. I am not sure if I
understand correctly how you suggested the use of 'mi dlg_terminate_dlg'
command.

Thanks,
Alexandre

-----Mensagem original-----
De: Daniel-Constantin Mierla [mailto:miconda(a)gmail.com] 
Enviada em: quarta-feira, 23 de março de 2011 11:10
Para: Alexandre Abreu
Cc: 'SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users
Mailing List'
Assunto: Re: RES: [SR-Users] event_route and acc_db_request().

Hello,

On 3/23/11 2:36 PM, Alexandre Abreu wrote:
> Hello Daniel.
>
> The module being used is 'mi_xmlrpc.so'
ok, this one creates a new process for handling xmlrpc requests. It is
pretty much clear that is very likely what I suspected first time.

If you have time, try load instead xmlrpc module and use the command 'mi
dlg_terminate_dlg ...".

Cheers,
Daniel

>   I am using the Carsten's rtpproxy
> patch. RTPPROXY detects the media timeout and send a notification 
> through XMLRPC lib with 'dlg_terminate_dlg callid' to Kamailio. After 
> that, I configured the event_route to catch the local generated 
> requests for accounting these BYEs.
>
> Thanks,
> Alexandre
>
> -----Mensagem original-----
> De: Daniel-Constantin Mierla [mailto:miconda(a)gmail.com] Enviada em: 
> quarta-feira, 23 de março de 2011 10:17
> Para: Alexandre Abreu
> Cc: 'SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - 
> Users Mailing List'
> Assunto: Re: RES: [SR-Users] event_route and acc_db_request().
>
> Hello,
>
> On 3/23/11 1:44 PM, Alexandre Abreu wrote:
>> Hello Daniel.
>>
>> The BYE is generated by kamctl/xmlrpc (dlg_terminate_dlg).
> is xmlrpc via mi_xmlrpc or via xmlrpc module?
>
> I have to double check, but looks very likely to be the fact that acc 
> db connection was not initialized for MI/RPC children processes.
>
> Thanks,
> Daniel
>
>> Alexandre
>>
>> De: Daniel-Constantin Mierla [mailto:miconda(a)gmail.com] Enviada em:
>> quarta-feira, 23 de março de 2011 04:55
>> Para: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - 
>> Users Mailing List
>> Cc: Alexandre Abreu
>> Assunto: Re: [SR-Users] event_route and acc_db_request().
>>
>> Hello,
>>
>> On 3/17/11 5:45 PM, Alexandre Abreu wrote:
>> Hello.
>>
>> Why acc_db_request() doesn’t work on event_route?
>>
>> I will take a look.
>>
>> Is the BYE generated by dialog timeout or you trigger it by
kamctl/xmlrpc?
>>
>> Cheers,
>> Daniel
>>
>>
>>
>> Mar 17 13:15:44 devel kamailio[25209]: INFO:<script>: Routing locally 
>> generated BYE to<sip:2000000(a)192.168.200.114:9297>
>> Mar 17 13:15:44 devel kamailio[25209]: ERROR:<core>   [db.c:421]:
>> invalid parameter value Mar 17 13:15:44 devel kamailio[25209]: ERROR:
>> acc [acc.c:391]: error in use_table Mar 17 13:15:44 devel
>> kamailio[25209]: INFO:<script>: Routing locally generated BYE 
>> to<sip:2000001(a)192.168.200.149:7335>
>> Mar 17 13:15:44 devel kamailio[25209]: ERROR:<core>   [db.c:421]:
>> invalid parameter value Mar 17 13:15:44 devel kamailio[25209]: ERROR:
>> acc [acc.c:391]: error in use_table
>>
>> event_route[tm:local-request] {
>>
>>           xlog("L_INFO", "Routing locally generated $rm to<$ru>\n");
>>
>>           if (is_method("BYE"))
>>                   acc_db_request("rtp-timeout", “acc”); }
>>
>> If I change acc_db_request() to acc_log_request() everything works 
>> fine, but this BYE should go to database for accounting purposes.
>>
>> I am using GIT version from Kamailio branch 3.1.
>>
>>   From 2008 there is a thread that also demonstrate this problem:
>>
>> http://www.mail-archive.com/users(a)lists.kamailio.org/msg01411.html
>>
>> Unfortunately, in the archives, there’s no solution for that.
>>
>> Regards,
>> Alexandre
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing 
>> list sr-users(a)lists.sip-router.org 
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
> --
> Daniel-Constantin Mierla
> http://www.asipto.com
>

--
Daniel-Constantin Mierla
http://www.asipto.com



--===============1850131262==--