From alexandre.abreu@redt.com.br Wed Mar 23 14:37:06 2011
From: Alexandre Abreu <alexandre.abreu@redt.com.br>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] RES:  event_route and acc_db_request().
Date: Wed, 23 Mar 2011 10:36:57 -0300
Message-ID: <00ad01cbe95f$63811540$2a833fc0$@redt.com.br>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0261756402=="

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

Hello Daniel.

The module being used is 'mi_xmlrpc.so' 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



--===============0261756402==--


From miconda@gmail.com Wed Mar 23 15:09:53 2011
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject: Re: [SR-Users] RES:  event_route and acc_db_request().
Date: Wed, 23 Mar 2011 15:09:44 +0100
Message-ID: <4D89FF28.80601@gmail.com>
In-Reply-To: <00ad01cbe95f$63811540$2a833fc0$@redt.com.br>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1515729768=="

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

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



--===============1515729768==--


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="===============1960016693=="

--===============1960016693==
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



--===============1960016693==--


From miconda@gmail.com Thu Mar 24 07:51:03 2011
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject: Re: [SR-Users] RES: RES:  event_route and acc_db_request().
Date: Thu, 24 Mar 2011 07:50:54 +0100
Message-ID: <4D8AE9CE.5020605@gmail.com>
In-Reply-To: <012101cbe96f$4f696520$ee3c2f60$@redt.com.br>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1566224453=="

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

Hello,

the method name is 'mi' then the first parameter is dlg_terminate_dlg 
and the next parameters are the ones required by the dlg_terminate_dlg.

The XMLRPC command 'mi' is to execute commands from the old control 
interface that we named MI:

http://kamailio.org/docs/modules/stable/modules/mi_rpc.html#id2945832

Cheers,
Daniel

On 3/23/11 4:30 PM, Alexandre Abreu wrote:
> 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
>

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



--===============1566224453==--