[asterisk-users] Voice mail with ODBC

[ProNek]

Hi,

The issue is solved . I created voicemessages table in MySQL according to
Asterisk book. Just replace 'label' column with 'msg_id' in 'voicemessages'
table. Thank you.

Regards,
Thet Tun


On Thu, May 29, 2014 at 9:09 AM, ProNek <pronek at gmail.com> wrote:

> Hi All,
>
> I have an issue on voice mail with odbc in asterisk 11.7 box. Voice
> message can be received through Google mail but it doesn't show in phone.
> The error messages is as follow and let me get your kind advice.
>
> -- <SIP/0015-00000007> Playing 'auth-thankyou.g722' (language 'en')
> [2014-05-28 14:55:13] DEBUG[12260][C-00000006]: app_voicemail.c:3824
> last_message_index: Directory
> '/var/spool/asterisk/voicemail/default/701/INBOX' has no messages and
> therefore no index was retrieved.
>   == Parsing
> '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found
> [2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4086
> insert_data_cb: SQL Direct Execute failed!
> [2014-05-28 14:55:13] WARNING[12260][C-00000006]: res_odbc.c:608
> ast_odbc_direct_execute: SQL Execute error! Verifying connection to
> asterisk [asterisk-connector]...
> [2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4086
> insert_data_cb: SQL Direct Execute failed!
> [2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4202
> store_file: SQL Execute error!
> [INSERT INTO voicemessages
> (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag,msg_id)
> VALUES (?,?,?,?,?,?,?,?,?,?,?,?)]
>
>   == Parsing
> '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found
>   == Parsing
> '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found
>     -- Auto fallthrough, channel 'SIP/0015-00000007' status is 'NOANSWER'
>
> Any advice is appreciated much.
>
> Best Regards,
> Thet Tun
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140530/353b9919/attachment.html>