[OpenSIPS-Users] OpenSIPS and Asterisk integration versions

[Bogdan-Andrei Iancu]

Hi Nabeel,

1) that limit should not be necessary, as you should have in DB a single 
record for each subscriber. If multiple records are returned, it means 
your data is not correct.

2) in those lines, the "asterisk" and "asteriskcfg" are the names of the 
odbc connection - I pasted an example which was not correlated with the 
tutorial - just be sure you have the name like in /etc/odbc.ini and 
/etc/asterisk/res_odbc.conf

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 04.07.2016 12:54, Nabeel wrote:
>
> 0.  The line block was in the default OpenSIPS config, but I agree 
> that it is not in the tutorial so should be removed (for voicemail).
>
> 1. I think there is a misunderstanding here.  'limit' is not a column; 
> I am referring to the mysql LIMIT clause:
>
> https://dev.mysql.com/doc/refman/5.5/en/select.html
>
> 2. In the tutorial, the following is added to extconfig.cfg:
>
> sipusers => odbc,asterisk,sipusers sippeers => odbc,asterisk,sipusers 
> voicemail => odbc,asterisk,vmusers meetme => odbc,asterisk,meetme
>
> However, this is different to the config in your last Email with 
> 'asteriskcfg'. Please clarify.
>
> For the phone number +447479189410 in the subscriber table, I had to 
> add the following line to voicemail.conf for it to work (notice the " 
> |u " ):
>
> +447479189410|u => 1234,Example Mailbox,root at localhost
>
> Asterisk seems to look for the " |u " suffix in addition to the  phone 
> number, instead of just the phone number which is in the subscriber 
> table.
>
> Nabeel
>