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 _______________________________________________ --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