[asterisk-users] Voice mail with ODBC

ProNek pronek at gmail.com
Thu May 29 00:09:40 CDT 2014


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/20140529/53352d8b/attachment.html>


More information about the asterisk-users mailing list