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 <[email protected]> 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 >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
