Hi Nabeel,
The "sipusers" mysql view (as per
http://www.opensips.org/Documentation/Tutorials-OpenSIPSAsteriskIntegration-1-8#toc7
) has both the name and host fields - not sure why that query may fail.....
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 30.06.2016 07:19, Nabeel wrote:
Hi Bogdan,
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:
[Jun 30 01:07:53] NOTICE[17067][C-00000000] chan_sip.c: Call from
'+447867958678' (162.249.6.206:12221 <http://162.249.6.206:12221>)
to extension 'VMR_+447479189410' rejected because extension not
found in context 'default'.
[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
[Jun 30 01:07:53] WARNING[17112] res_config_odbc.c: SQL Prepare
failed![SELECT * FROM sipusers WHERE name = ? AND host = ?]
[Jun 30 01:07:53] WARNING[17112] res_odbc.c: Connection is down
attempting to reconnect...
Also I had to change 'nat=yes' to 'nat=force_rport,comedia' as it is
deprecated.
Nabeel
On 14 June 2016 at 11:08, Bogdan-Andrei Iancu <bog...@opensips.org
<mailto:bog...@opensips.org>> wrote:
Hi Nabeel,
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.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 12.06.2016 10:18, Nabeel wrote:
Hi,
I will be following this tutorial to integrate OpenSIPS and Asterisk:
http://www.opensips.org/Documentation/Tutorials-OpenSIPSAsteriskIntegration-1-8
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?
Nabeel
_______________________________________________
Users mailing list
Users@lists.opensips.org <mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
