[OpenSIPS-Users] OpenSIPS and Asterisk integration versions

[Nabeel]

Hi,

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?

Now the following errors remain:

[Jun 30 01:07:53] NOTICE[17067][C-00000000] chan_sip.c: Call from '
> +447867958678' (162.248.6.216:12351 <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_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.


I am using OpenSIPS 2.2, not 2.3 as stated earlier.

Nabeel

On 30 June 2016 at 10:18, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:

> 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 Developerhttp://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) 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>
> 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 Developerhttp://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 listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160701/e126975b/attachment.htm>