[OpenSIPS-Users] OpenSIPS and Asterisk integration versions

Bogdan-Andrei Iancu bogdan at opensips.org
Thu Jun 30 11:18:37 CEST 2016


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 <bogdan at opensips.org 
> <mailto:bogdan at 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 at lists.opensips.org <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160630/a31b9980/attachment.htm>


More information about the Users mailing list