New subject: Re : RES: event_route and acc_db_request().

24 Mar 2011

Hi Daniel,

Using 'xmlrpc' and 'mi' it works. When I finish this project, I will write
a
small text explaining the steps I did to make this work. Maybe this will
benefit more people from the community. 

Thank you.
Alexandre

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

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@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@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@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() doesnt 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@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@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@lists.kamailio.org/msg01411.html

 Unfortunately, in the archives, theres 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