[asterisk-users] Asterisk 1.4.4 VoiceMail ODBC Storage Help

[Remco Post]

Bruce McAlister wrote:
> 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:

It looks like the * database user doesn't have permission to delete
records from the voicemailmessages table. Make sure it has the propper
permissions on that table.

-- 

Remco Post

"I didn't write all this code, and I can't even pretend that all of it
makes sense." -- Glen Hattrup