<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Ok Liviu.</p>
<p><br>
</p>
<p>Thank you!</p>
<p><br>
</p>
<p>I will check more details.</p>
<p><br>
</p>
<p>Br,<br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>De:</b> users-bounces@lists.opensips.org <users-bounces@lists.opensips.org> em nome de Liviu Chircu <liviu@opensips.org><br>
<b>Enviado:</b> quinta-feira, 17 de março de 2016 09:30<br>
<b>Para:</b> users@lists.opensips.org<br>
<b>Assunto:</b> Re: [OpenSIPS-Users] AOR is Removed from DBMar. What is this issue? OpenSIPS 2.2.</font>
<div> </div>
</div>
<div><tt>Hi Rodrigo,<br>
<br>
You have an xlog with a missing newline "\n", and the error log from DB SQLite ("Mar 16 18:09:17...") gets appended to your previous xlog debugging.<br>
<br>
Notice you are trying to t_relay() to a private IP, 192.168.110.118:53803, and this fails for some reason. Make sure you are properly handling NAT, if you indeed have such clients.<br>
</tt>
<pre class="moz-signature" cols="72">Liviu Chircu
OpenSIPS Developer
<a id="LPlnk746934" class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;" id="LPBorder_GT_14582267578190.6520010575709714">
<table style="width: 90%; background-color: rgb(255, 255, 255); position: relative; overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, 200);" id="LPContainer_14582267578120.5910518413781013" cellspacing="0">
<tbody>
<tr style="border-spacing: 0px;" valign="top">
<td colspan="1" style="width: 250px; position: relative; display: table-cell; padding-right: 20px;" id="ImageCell_14582267578140.43490980272184976">
<div style="background-color: rgb(255, 255, 255); height: 38px; position: relative; margin: auto; display: table; width: 116px;" id="LPImageContainer_14582267578140.5149845571815098">
<a target="_blank" href="http://www.opensips-solutions.com/" style="display: table-cell; text-align: center;" id="LPImageAnchor_14582267578160.1645998143839542"><img aria-label="Imagem de visualização com link selecionado. Toque duas vezes para abrir o link." style="display: inline-block; margin-left: auto; margin-right: auto; max-width: 250px; max-height: 250px; height: 38px; width: 116px; border-width: 0px; vertical-align: bottom;" height="38" width="116" src="http://www.opensips-solutions.com/imgs/opensips-solutions-logo.gif"></a></div>
</td>
<td colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;" id="TextCell_14582267578160.04358363097245854">
<div id="LPRemovePreviewContainer_14582267578160.26097434948086096"></div>
<div style="top: 0px; color: rgb(0, 120, 215); font-weight: 400; font-size: 21px; font-family: "wf_segoe-ui_light","Segoe UI Light","Segoe WP Light","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; line-height: 21px;" id="LPTitle_14582267578160.21844587076104593">
<a target="_blank" href="http://www.opensips-solutions.com/" style="text-decoration: none;" id="LPUrlAnchor_14582267578180.4411610627607071">Home — OpenSIPS Solutions</a></div>
<div style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: 400; font-family: "wf_segoe-ui_normal","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size: 14px; line-height: 14px;" id="LPMetadata_14582267578180.06259533039673626">
www.opensips-solutions.com</div>
<div style="display: block; color: rgb(102, 102, 102); font-weight: 400; font-family: "wf_segoe-ui_normal","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size: 14px; line-height: 20px; max-height: 100px; overflow: hidden;" id="LPDescription_14582267578190.4005933505813881">
OpenSIPS is a mature Open Source implementation of a SIP server. OpenSIPS is more than a SIP proxy/router as it includes application-level functionalities.</div>
</td>
</tr>
</tbody>
</table>
</div>
<div class="moz-cite-prefix">On 16.03.2016 21:02, Rodrigo Pimenta Carvalho wrote:<br>
</div>
<blockquote type="cite">
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
<span style="color:rgb(0,111,201)"></span>
<p>Hi.</p>
<p><br>
</p>
<p>I'm using OpenSIPS 2.2 and testing calls between callers and callees. Everything was working well until the log shows the "AOR is Removed from DBMar..." message.</p>
<p><br>
</p>
<p>The log says:</p>
<p><br>
</p>
<p><i>Mar 16 18:09:17 colibri-imx6 opensips[12698]: Mar 16 18:09:17 [12707] ERROR:core:tcpconn_async_connect: poll error: flags 1c<br>
Mar 16 18:09:17 colibri-imx6 opensips[12698]: Mar 16 18:09:17 [12707] ERROR:core:tcpconn_async_connect: failed to retrieve SO_ERROR [server=192.168.100.118:53803] (111) Connection refused<br>
Mar 16 18:09:17 colibri-imx6 opensips[12698]: Mar 16 18:09:17 [12707] ERROR:core:proto_tcp_send: async TCP connect failed<br>
Mar 16 18:09:17 colibri-imx6 opensips[12698]: Mar 16 18:09:17 [12707] ERROR:tm:msg_send: send() for proto 2 failed<br>
Mar 16 18:09:17 colibri-imx6 opensips[12698]: Mar 16 18:09:17 [12707] ERROR:tm:t_forward_nonack: sending request failed<br>
Mar 16 18:09:17 colibri-imx6 opensips[12698]: <b>AOR of crdphmacl_7UyWRH444yVH is Removed from DBMar 16 18:09:17 [12707] ERROR:db_sqlite:db_sqlite_free_result: invalid parameter val</b></i></p>
<p><i><b><br>
</b></i></p>
<p>Now, the client that has username equals to " <i><b>crdphmacl_7UyWRH444yVH</b></i>" cannot receive calls any more. But he still can make (start) calls. I still didn't reset such client.</p>
<p>I can't understand this issue, because the AOR still remains in the location table. See:</p>
<p><br>
</p>
<p>AOR:: crdphmacl_7UyWRH444yVH<br>
Contact:: <a class="moz-txt-link-abbreviated" href="mailto:sip:crdphmacl_7UyWRH444yVH@192.168.100.118:53803;transport=TCP;ob">
sip:crdphmacl_7UyWRH444yVH@192.168.100.118:53803;transport=TCP;ob</a> Q=<br>
Expires:: 268<br>
Callid:: 152917ae-5a51-48ac-97da-99d8318bf702<br>
Cseq:: 8900<br>
User-agent:: n/a<br>
State:: CS_SYNC<br>
Flags:: 0<br>
Cflags:: <br>
Socket:: tcp:192.168.100.166:5060<br>
Methods:: 8063<br>
Attr:: in_same_network<br>
SIP_instance:: <urn:uuid:00000000-0000-0000-0000-0000b891c0f5><br>
</p>
<p><br>
</p>
<p>So, what is the problem here?<br>
</p>
<p>Any hint will be very helpful!</p>
<p>Best regards.<br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset> <br>
<pre>_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</body>
</html>