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>