Hi All, I have an issue with the ODBC voicemail storage option with asterisk. All appears to work fine, however, I get several sql execute warnings. I was wondering if anyone out there could help me get to the bottom of what is causing this and how I could possibly go about rectifying it.
The warning message we are getting is as follows: WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] This warning occurs whenever a user leaves a message for an extension. It also occurs when someone dials in to listen to their messages when they hang up. These messages do actually exist within the database, and asterisk does extract them from the database when playing back or recording messages. Here is an example when someone leaves a message for someone: ---------------------------------------------------------------------------- --------------------------------------------------------------------------- -- Executing [EMAIL PROTECTED]:1] AGI("SIP/bruce.mcalister-09051118", "agi://10.7.0.136:4573?app=getvoicemailexten") in new stack -- AGI Script agi://10.7.0.136:4573?app=getvoicemailexten completed, returning 0 -- Executing [EMAIL PROTECTED]:2] NoOp("SIP/bruce.mcalister-09051118", "Caller VoiceMail Extension = 3031") in new stack -- Executing [EMAIL PROTECTED]:3] VoiceMail("SIP/bruce.mcalister-09051118", "[EMAIL PROTECTED]") in new stack -- <SIP/bruce.mcalister-09051118> Playing '/usr/local/asterisk/var/spool/voicemail/users/3031/temp' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-intro' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'beep' (language 'en') -- Recording the message -- x=0, open writing: /usr/local/asterisk/var/spool/voicemail/users/3031/tmp/hGkNG0 format: wav49, 0x90539c8 -- User ended message by pressing # -- <SIP/bruce.mcalister-09051118> Playing 'auth-thankyou' (language 'en') [Apr 30 23:56:03] WARNING[30123]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3031/INBOX/msg0002.txt': Found Length is 20600 -- Executing [EMAIL PROTECTED]:4] Hangup("SIP/bruce.mcalister-09051118", "") in new stack == Spawn extension (base-out, 170, 4) exited non-zero on 'SIP/bruce.mcalister-09051118' ---------------------------------------------------------------------------- --------------------------------------------------------------------------- Here is an example when someone listens to their voicemail messages without deleting any: ---------------------------------------------------------------------------- --------------------------------------------------------------------------- -- Executing [EMAIL PROTECTED]:1] AGI("SIP/bruce.mcalister-09051118", "agi://10.7.0.136:4573?app=getvoicemailexten") in new stack -- AGI Script agi://10.7.0.136:4573?app=getvoicemailexten completed, returning 0 -- Executing [EMAIL PROTECTED]:2] NoOp("SIP/bruce.mcalister-09051118", "voicemail extension=3031") in new stack -- Executing [EMAIL PROTECTED]:3] VoiceMailMain("SIP/bruce.mcalister-09051118", "[EMAIL PROTECTED]") in new stack -- <SIP/bruce.mcalister-09051118> Playing 'vm-password' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-youhave' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/19' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-INBOX' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-and' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/20' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-Old' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-messages' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-onefor' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-INBOX' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-messages' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-first' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-message' (language 'en') == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0000.txt': Found -- <SIP/bruce.mcalister-09051118> Playing 'vm-unknown-caller' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0000' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-message' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/2' (language 'en') == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0001.txt': Found -- <SIP/bruce.mcalister-09051118> Playing 'vm-from-phonenumber' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/2' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/0' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/8' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/9' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/2' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/2' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/5' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/5' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0001' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-prev' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-message' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/3' (language 'en') == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0002.txt': Found -- <SIP/bruce.mcalister-09051118> Playing 'vm-from-phonenumber' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/1' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/2' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/3' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/5' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/5' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/7' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/7' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0002' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-prev' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-message' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0003.txt': Found -- <SIP/bruce.mcalister-09051118> Playing 'vm-from-phonenumber' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/1' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/6' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/0' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/3' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/4' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/0' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/0' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/0' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0003' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-prev' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-advopts' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-repeat' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-message' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/5' (language 'en') == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0004.txt': Found -- <SIP/bruce.mcalister-09051118> Playing 'vm-unknown-caller' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0004' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-prev' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-message' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/6' (language 'en') == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0005.txt': Found -- <SIP/bruce.mcalister-09051118> Playing 'vm-unknown-caller' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0005' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-prev' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-advopts' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-repeat' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-next' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-delete' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-message' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'digits/7' (language 'en') == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0006.txt': Found -- <SIP/bruce.mcalister-09051118> Playing 'vm-unknown-caller' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0006' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-prev' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-advopts' (language 'en') -- <SIP/bruce.mcalister-09051118> Playing 'vm-goodbye' (language 'en') [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] [Apr 30 23:44:25] WARNING[30115]: app_voicemail.c:1280 delete_file: SQL Execute error! [DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?] -- Executing [EMAIL PROTECTED]:4] Hangup("SIP/bruce.mcalister-09051118", "") in new stack == Spawn extension (base-out, 171, 4) exited non-zero on 'SIP/bruce.mcalister-09051118' ---------------------------------------------------------------------------- --------------------------------------------------------------------------- Our environment is as follows: Asterisk Server: CentOS Linux 4.4 32bit UnixODBC 1.2.12 PostgreSQL ODBC driver version 08.01.0200 Asterisk 1.4.4 Database Server Solaris 10 Update 3 PostgreSQL 8.2.4 If you need me to enable anything or require any further details, please don't hesitate to ask. PS: Any and all comments/suggestions/criticisms are most welcome :) Thanks Bruce _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users