<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi Nabeel,<br>
<br>
The "sipusers" mysql view (as per
<a class="moz-txt-link-freetext" href="http://www.opensips.org/Documentation/Tutorials-OpenSIPSAsteriskIntegration-1-8#toc7">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>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 30.06.2016 07:19, Nabeel wrote:<br>
</div>
<blockquote
cite="mid:CA+vx6KKoXR+YdAMud=gVo1hapoJtvY_OJaaGouBFy4L3QVdj2g@mail.gmail.com"
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
'+447867958678' (<a moz-do-not-send="true"
href="http://162.249.6.206:12221">162.249.6.206:12221</a>)
to extension 'VMR_+447479189410' 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
moz-do-not-send="true" href="mailto:bogdan@opensips.org"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:bogdan@opensips.org">bogdan@opensips.org</a></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 moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>
<div class="h5">
<div>On 12.06.2016 10:18, Nabeel wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<p dir="ltr">Hi, </p>
<p dir="ltr">I will be following this tutorial to
integrate OpenSIPS and Asterisk:</p>
<p dir="ltr"><a moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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>
</body>
</html>