[OpenSIPS-Users] OpenSIPS and Asterisk integration versions

[Nabeel]

Hi Bogdan,

I just added the column to the view by adding "NULL AS `callbackextension`"
to the SQL view definition. I haven't linked the column to the subscriber
column, so this may not be the correct definition. However, it got rid of
the error.

About the voicemail.conf file, when I attempted to leave a voicemail to a
number in subscriber table, I got an error telling me that the user/mailbox
does not exist in voicemail.conf file. After adding that number manually to
the file, voicemail was working for that number. I think this may also mean
that the integration is not working correctly in my current setup.

Nabeel
On 4 Jul 2016 8:48 a.m., "Bogdan-Andrei Iancu" <bogdan at opensips.org> wrote:

> Hi,
>
> What is the definition you used for this new column ?
>
> Best regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>
> On 02.07.2016 05:29, Nabeel wrote:
>
> In the last error message,* '**callbackextension = ?' *suggested that
> this column is missing from the sipusers mysql view. So I added this column
> to the view and now that error has been resolved. Only the following error
> remains now:
>
> [Jul  2 03:25:48] WARNING[19330][C-00000005]: app.c:1633
>> __ast_play_and_record: No audio available on SIP/domain.com-00000005??
>
>
>
>
>
>
> On 2 July 2016 at 02:36, Nabeel <nabeelshikder at gmail.com> wrote:
>
>> The issue in my last Email has solved the error about missing extension.
>> Now the following errors remain:
>>
>> [Jul  2 02:29:18] WARNING[18226][C-00000001]: res_config_odbc.c:117
>>> custom_prepare: SQL Prepare failed![SELECT * FROM sipusers WHERE host = ?
>>> AND callbackextension = ? AND port = ?]
>>> [Jul  2 02:29:22] WARNING[18269][C-00000000]: app.c:1633
>>> __ast_play_and_record: No audio available on SIP/domain.com-00000000??
>>
>>
>>
>> On 2 July 2016 at 02:23, Nabeel <nabeelshikder at gmail.com> wrote:
>>
>>> The tutorial contains a mistake where the priority ordering in
>>> extensions.conf should start with 1, not n:
>>>
>>> ; Voicemail
>>>> exten => _VMR_.,1,Ringing
>>>> exten => _VMR_.,n,Wait(1)
>>>> exten => _VMR_.,n,Answer
>>>> exten => _VMR_.,n,Wait(1)
>>>> exten => _VMR_.,n,Voicemail(${EXTEN:4}|u)
>>>> exten => _VMR_.,n,Hangup
>>>
>>> ; Allow users to call their Voicemail directly
>>>> exten => VM_pickup,1,Ringing
>>>> exten => VM_pickup,n,wait(1)
>>>> exten => VM_pickup,n,VoicemailMain(${CALLERIDNUM}|s)
>>>> exten => VM_pickup,n,Hangup
>>>
>>>
>>>
>>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160704/1e0c6794/attachment.htm>