<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
On 3/17/11 5:45 PM, Alexandre Abreu wrote:
<blockquote cite="mid:014401cbe4c2$adcc8040$096580c0$@redt.com.br"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";
        mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EstiloDeEmail17
        {mso-style-type:personal-compose;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri","sans-serif";
        mso-fareast-language:EN-US;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hello.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Why acc_db_request()
doesn’t work on event_route?</span></p>
</div>
</blockquote>
<br>
I will take a look.<br>
<br>
Is the BYE generated by dialog timeout or you trigger it by
kamctl/xmlrpc?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<blockquote cite="mid:014401cbe4c2$adcc8040$096580c0$@redt.com.br"
type="cite">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Mar 17 13:15:44 devel
kamailio[25209]: INFO: <script>: Routing locally
generated BYE to <a class="moz-txt-link-rfc2396E" href="sip:2000000@192.168.200.114:9297"><sip:2000000@192.168.200.114:9297></a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Mar 17 13:15:44 devel
kamailio[25209]: ERROR: <core> [db.c:421]: invalid
parameter value<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Mar 17 13:15:44 devel
kamailio[25209]: ERROR: acc [acc.c:391]: error in use_table<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Mar 17 13:15:44 devel
kamailio[25209]: INFO: <script>: Routing locally
generated BYE to <a class="moz-txt-link-rfc2396E" href="sip:2000001@192.168.200.149:7335"><sip:2000001@192.168.200.149:7335></a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Mar 17 13:15:44 devel
kamailio[25209]: ERROR: <core> [db.c:421]: invalid
parameter value<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Mar 17 13:15:44 devel
kamailio[25209]: ERROR: acc [acc.c:391]: error in use_table<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">event_route[tm:local-request]
{<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> xlog("L_INFO",
"Routing locally generated $rm to <$ru>\n");<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> if
(is_method("BYE"))<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">
acc_db_request("rtp-timeout", “acc”);<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">}<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">If I change
acc_db_request() to acc_log_request() everything works fine,
but this BYE should go to database for accounting purposes.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I am using GIT version
from Kamailio branch 3.1.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">From 2008 there is a
thread that also demonstrate this problem: <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><a class="moz-txt-link-freetext" href="http://www.mail-archive.com/users@lists.kamailio.org/msg01411.html">http://www.mail-archive.com/users@lists.kamailio.org/msg01411.html</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Unfortunately, in the
archives, there’s no solution for that.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Alexandre<o:p></o:p></span></p>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>