[Home]

Summary:ASTERISK-05247: Voicemail ODBC is not reading envelop information from database
Reporter:Leo Burd (leoburd)Labels:
Date Opened:2005-10-05 13:34:19Date Closed:2008-01-15 15:51:04.000-0600
Priority:MinorRegression?No
Status:Closed/CompleteComponents:Applications/app_voicemail
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:Whenever I go to the voicemail's advanced options menu and ask it to read me the envelop information for a certain message nothing happens and I get the following message on the console: "Oct  5 14:15:40 WARNING[21894]: app_voicemail.c:6337 advanced_options: No message attribute file?!!".  

I believe voicemail app is trying to read the envelop info from a file when in fact the info is stored in the database...
Comments:By: Kevin P. Fleming (kpfleming) 2005-10-13 20:13:58

Fixed in CVS HEAD.
By: Leo Burd (leoburd) 2005-10-16 17:14:44

Hello there,

I'm still getting errors when I try to access my voicemail using ODBC.  Now, my INBOX messages get deleted when I listen to them.  

Moreover, if I try to check the envelope information for a message that had just been played, the system reads me the date and the caller id, and then generates the following error messages:

Oct 16 17:45:23 WARNING[5993]: file.c:508 ast_openstream_full: File /var/spool/asterisk/voicemail/default/6201/INBOX/msg0000 does not exist in any format
Oct 16 17:45:23 WARNING[5993]: file.c:820 ast_streamfile: Unable to open /var/spool/asterisk/voicemail/default/6201/INBOX/msg0000 (format gsm): No such file or directory


Finally, when I disconnect from voicemail, the system generates the following warning messages:

Oct 16 17:45:41 WARNING[5993]: res_odbc.c:112 odbc_smart_execute: SQL Execute error! Attempting a reconnect...
Oct 16 17:45:41 WARNING[5993]: res_odbc.c:433 odbc_obj_disconnect: res_odbc: disconnected 0 from asterisk [asterisk]
Oct 16 17:45:41 NOTICE[5993]: res_odbc.c:490 odbc_obj_connect: Connecting asterisk
Oct 16 17:45:41 NOTICE[5993]: res_odbc.c:505 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Oct 16 17:45:41 WARNING[5993]: app_voicemail.c:1128 copy_file: SQL Execute error!
[INSERT INTO voicemail_messages (dir, msgnum, context, macrocontext, callerid, origtime, duration, recording, mailboxuser, mailboxcontext) SELECT ?,?,context,macrocontext,callerid,origtime,duration,recording,?,? FROM voicemail_messages WHERE dir=? AND msgn] (You probably don't have MySQL 4.1 or later installed)

Oct 16 17:45:41 WARNING[5993]: res_odbc.c:112 odbc_smart_execute: SQL Execute error! Attempting a reconnect...
Oct 16 17:45:41 WARNING[5993]: res_odbc.c:433 odbc_obj_disconnect: res_odbc: disconnected 0 from asterisk [asterisk]
Oct 16 17:45:41 NOTICE[5993]: res_odbc.c:490 odbc_obj_connect: Connecting asterisk
Oct 16 17:45:41 NOTICE[5993]: res_odbc.c:505 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Oct 16 17:45:41 WARNING[5993]: app_voicemail.c:1128 copy_file: SQL Execute error!
[INSERT INTO voicemail_messages (dir, msgnum, context, macrocontext, callerid, origtime, duration, recording, mailboxuser, mailboxcontext) SELECT ?,?,context,macrocontext,callerid,origtime,duration,recording,?,? FROM voicemail_messages WHERE dir=? AND msgn] (You probably don't have MySQL 4.1 or later installed)


Any idea of what is going on?  I do have MySQL 4.1.12 installed and it seems to be working fine for the part that adds messages to the database...

Thanks so much for your support,

Leo Burd
By: Leo Burd (leoburd) 2005-10-16 17:17:54

BTW, here's the complete debug/verbose report that I got for the session described in my previous note:

----------------------------------------
   -- Executing VoiceMailMain("SIP/xlite1-5f9c", "s6201@default") in new stack
   -- Playing 'vm-youhave' (language 'en')
   -- Playing 'digits/2' (language 'en')
   -- Playing 'vm-INBOX' (language 'en')
   -- Playing 'vm-messages' (language 'en')
   -- Playing 'vm-onefor' (language 'en')
   -- Playing 'vm-INBOX' (language 'en')
   -- Playing 'vm-messages' (language 'en')
   -- Playing 'vm-opts' (language 'en')
   -- Playing 'vm-first' (language 'en')
   -- Playing 'vm-message' (language 'en')
   -- Playing '/var/spool/asterisk/voicemail/default/6201/INBOX/msg0000' (language 'en')
   -- Playing 'vm-advopts' (language 'en')
   -- Playing 'vm-repeat' (language 'en')
   -- Playing 'vm-next' (language 'en')
   -- Playing 'vm-delete' (language 'en')
   -- Playing 'vm-first' (language 'en')
   -- Playing 'vm-message' (language 'en')
   -- Playing '/var/spool/asterisk/voicemail/default/6201/INBOX/msg0000' (language 'en')
   -- Playing 'vm-advopts' (language 'en')
   -- Playing 'vm-repeat' (language 'en')
   -- Playing 'vm-next' (language 'en')
REGISTER attempt 1 to 633993@fwd.pulver.com
   -- Playing 'vm-last' (language 'en')
   -- Playing 'vm-message' (language 'en')
   -- Playing '/var/spool/asterisk/voicemail/default/6201/INBOX/msg0001' (language 'en')
   -- Playing 'vm-prev' (language 'en')
   -- Playing 'vm-advopts' (language 'en')
   -- Playing 'vm-repeat' (language 'en')
   -- Playing 'vm-delete' (language 'en')
   -- Playing 'vm-toforward' (language 'en')
   -- Playing 'vm-last' (language 'en')
   -- Playing 'vm-message' (language 'en')
   -- Playing '/var/spool/asterisk/voicemail/default/6201/INBOX/msg0001' (language 'en')
   -- Playing 'vm-prev' (language 'en')
   -- Playing 'vm-advopts' (language 'en')
   -- Playing 'vm-first' (language 'en')
   -- Playing 'vm-message' (language 'en')
   -- Playing '/var/spool/asterisk/voicemail/default/6201/INBOX/msg0000' (language 'en')
   -- Playing 'vm-advopts' (language 'en')
   -- Playing 'vm-repeat' (language 'en')
   -- Playing 'vm-next' (language 'en')
   -- Playing 'vm-toreply' (language 'en')
   -- Playing 'vm-tohearenv' (language 'en')
   -- Playing 'vm-starmain' (language 'en')
   -- Playing 'vm-received' (language 'en')
   -- Playing 'digits/at' (language 'en')
   -- Playing 'digits/5' (language 'en')
   -- Playing 'digits/30' (language 'en')
   -- Playing 'digits/3' (language 'en')
   -- Playing 'digits/p-m' (language 'en')
   -- Playing 'vm-from-phonenumber' (language 'en')
   -- Playing 'digits/1' (language 'en')
Oct 16 17:45:23 WARNING[5993]: file.c:508 ast_openstream_full: File /var/spool/asterisk/voicemail/default/6201/INBOX/msg0000 does not exist in any format
Oct 16 17:45:23 WARNING[5993]: file.c:820 ast_streamfile: Unable to open /var/spool/asterisk/voicemail/default/6201/INBOX/msg0000 (format gsm): No such file or directory
   -- Playing 'vm-advopts' (language 'en')
   -- Playing 'vm-repeat' (language 'en')
   -- Playing 'vm-next' (language 'en')
   -- Playing 'vm-delete' (language 'en')
   -- Playing 'vm-toforward' (language 'en')
   -- Playing 'vm-savemessage' (language 'en')
   -- Playing 'vm-helpexit' (language 'en')
   -- Playing 'vm-goodbye' (language 'en')
Oct 16 17:45:41 WARNING[5993]: res_odbc.c:112 odbc_smart_execute: SQL Execute error! Attempting a reconnect...
Oct 16 17:45:41 WARNING[5993]: res_odbc.c:433 odbc_obj_disconnect: res_odbc: disconnected 0 from asterisk [asterisk]
Oct 16 17:45:41 NOTICE[5993]: res_odbc.c:490 odbc_obj_connect: Connecting asterisk
Oct 16 17:45:41 NOTICE[5993]: res_odbc.c:505 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Oct 16 17:45:41 WARNING[5993]: app_voicemail.c:1128 copy_file: SQL Execute error!
[INSERT INTO voicemail_messages (dir, msgnum, context, macrocontext, callerid, origtime, duration, recording, mailboxuser, mailboxcontext) SELECT ?,?,context,macrocontext,callerid,origtime,duration,recording,?,? FROM voicemail_messages WHERE dir=? AND msgn] (You probably don't have MySQL 4.1 or later installed)

Oct 16 17:45:41 WARNING[5993]: res_odbc.c:112 odbc_smart_execute: SQL Execute error! Attempting a reconnect...
Oct 16 17:45:41 WARNING[5993]: res_odbc.c:433 odbc_obj_disconnect: res_odbc: disconnected 0 from asterisk [asterisk]
Oct 16 17:45:41 NOTICE[5993]: res_odbc.c:490 odbc_obj_connect: Connecting asterisk
Oct 16 17:45:41 NOTICE[5993]: res_odbc.c:505 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Oct 16 17:45:41 WARNING[5993]: app_voicemail.c:1128 copy_file: SQL Execute error!
[INSERT INTO voicemail_messages (dir, msgnum, context, macrocontext, callerid, origtime, duration, recording, mailboxuser, mailboxcontext) SELECT ?,?,context,macrocontext,callerid,origtime,duration,recording,?,? FROM voicemail_messages WHERE dir=? AND msgn] (You probably don't have MySQL 4.1 or later installed)

   -- Executing Goto("SIP/xlite1-5f9c", "s|restart") in new stack
----------------------------------------
By: Kevin P. Fleming (kpfleming) 2005-11-07 23:30:33.000-0600

You are having some other sort of error (the INSERT statements are failing to execute). Please verify that your database tables match the schema required for CVS HEAD ODBC voicemail storage, and if needed try to capture the actual INSERT statement that is being generated so someone can figure out what is going. All of that should be put into a new bug if necessary, since it's a separate issue from this one.
By: Digium Subversion (svnbot) 2008-01-15 15:51:04.000-0600

Repository: asterisk
Revision: 6783

U   trunk/apps/app_voicemail.c

------------------------------------------------------------------------
r6783 | kpfleming | 2008-01-15 15:51:04 -0600 (Tue, 15 Jan 2008) | 2 lines

ensure that message envelopes are retrieved from ODBC storage when advanced options menu is used (issue ASTERISK-5247)

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=6783