<div dir="ltr">Hi,<div><br></div><div>Adding 'limit 1' or 'limit 5' to the supusers mysql view resolves part of the error, but I don't understand why that is and whether this is correct for the setup. Maybe something to do with connection pooling?</div><div><br></div><div>Now the following errors remain:</div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><span style="font-size:12.8px">[Jun 30 01:07:53] NOTICE[17067][C-00000000] chan_sip.c: Call from '</span><a href="tel:%2B447867958678" value="+447867958678" target="_blank" style="font-size:12.8px">+447867958678</a><span style="font-size:12.8px">' (</span><a href="http://162.249.6.206:12221/" target="_blank" style="font-size:12.8px">162.248.6.216:12351</a><span style="font-size:12.8px">) to extension 'VMR_</span><a href="tel:%2B447479189410" value="+447479189410" target="_blank" style="font-size:12.8px">+447479189410</a><span style="font-size:12.8px">' rejected because extension not found in context 'default'.<br></span><span style="font-size:12.8px">[Jun 30 01:07:53] WARNING[17112] res_config_odbc.c: SQL Prepare failed![SELECT * FROM sipusers WHERE name = ? AND host = ?]<br></span><span style="font-size:12.8px">[Jun 30 01:07:53] WARNING[17112] res_odbc.c: Connection is down attempting to reconnect.</span></blockquote><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">I am using OpenSIPS 2.2, not 2.3 as stated earlier.</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Nabeel</span></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 30 June 2016 at 10:18, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<tt>Hi Nabeel,<br>
<br>
The "sipusers" mysql view (as per
<a href="http://www.opensips.org/Documentation/Tutorials-OpenSIPSAsteriskIntegration-1-8#toc7" target="_blank">http://www.opensips.org/Documentation/Tutorials-OpenSIPSAsteriskIntegration-1-8#toc7</a>
) has both the name and host fields - not sure why that query may
fail.....<br>
<br>
Regards,<br>
</tt><span class="">
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
</span><div><div class="h5"><div>On 30.06.2016 07:19, Nabeel wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Hi Bogdan,</div>
<div><br>
</div>
<div>I was able to install the latest versions of Asterisk
(13.1) and Opensips (2.3) according to the tutorial, but when
attempting to leave a voicemail I get the following errors:</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">[Jun
30 01:07:53] NOTICE[17067][C-00000000] chan_sip.c: Call from
'<a href="tel:%2B447867958678" value="+447867958678" target="_blank">+447867958678</a>' (<a href="http://162.249.6.206:12221" target="_blank">162.249.6.206:12221</a>)
to extension 'VMR_<a href="tel:%2B447479189410" value="+447479189410" target="_blank">+447479189410</a>' rejected because extension
not found in context 'default'.<br>
[Jun 30 01:07:53] WARNING[17112] res_odbc.c: SetConnectAttr
(Txn isolation) returned an error: HY000: [MySQL][ODBC 5.2(w)
Driver]You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right
syntax to use near '7' at line 1<br>
[Jun 30 01:07:53] WARNING[17112] res_config_odbc.c: SQL
Prepare failed![SELECT * FROM sipusers WHERE name = ? AND host
= ?]<br>
[Jun 30 01:07:53] WARNING[17112] res_odbc.c: Connection is
down attempting to reconnect...<br>
</blockquote>
<div><br>
</div>
<div><br>
</div>
<div>Also I had to change 'nat=yes' to 'nat=force_rport,comedia'
as it is deprecated.<br>
</div>
<div><br>
</div>
<div>Nabeel</div>
<div><br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 14 June 2016 at 11:08,
Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank"></a><a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> <tt>Hi Nabeel,<br>
<br>
We will update the tutorial for 2.2, but it should
still match. Give it a try and if you hit issues, just
let me know.<br>
<br>
Regards,<br>
</tt>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>
<div>
<div>On 12.06.2016 10:18, Nabeel wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>
<p dir="ltr">Hi, </p>
<p dir="ltr">I will be following this tutorial to
integrate OpenSIPS and Asterisk:</p>
<p dir="ltr"><a href="http://www.opensips.org/Documentation/Tutorials-OpenSIPSAsteriskIntegration-1-8" target="_blank">http://www.opensips.org/Documentation/Tutorials-OpenSIPSAsteriskIntegration-1-8</a></p>
<p dir="ltr">The tutorial mentions the use of
OpenSIPS version 1.8 and Asterisk version 1.8. I
would like to know if I can use the latest
versions of OpenSIPS and Asterisk instead? Have
there been changes to database structure which
can cause problems? </p>
<p dir="ltr">Nabeel</p>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br></div>