[asterisk-users] Asterisk 1.4.4 VoiceMail ODBC Storage Help

Bruce McAlister bruce.mcalister at blueface.ie
Tue May 1 09:12:41 MST 2007


Hi All,

I tried to send this email this morning, but I think it has been moderated
due to size issue's, so I'll resend it again in 3 parts:

PART 1

Hi All,

Just an update, after looking a little further into this, it appears that *
tries to delete a record that does not exist before inserting it into the
table, but the number of times it does that does not match up with the
number of warnings displayed on the asterisk console. 

I have attached the console output, database trace and the actual database
definition as text file attachments for readability as well as put it in
this email message.

Could another pair of eyes please go over this to see if I'm missing
anything.

Again, if you need any more details from me then please don't hesitate to
ask.

Asterisk Console Output (verbose 99/debug 99)

-- Executing [171 at base-out:1] AGI("SIP/bruce.mcalister-096da288",
"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 [171 at base-out:2] NoOp("SIP/bruce.mcalister-096da288",
"voicemail extension=3031") in new stack
    -- Executing [171 at base-out:3]
VoiceMailMain("SIP/bruce.mcalister-096da288", "3204 at users") in new stack
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-password' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-youhave' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/8' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-INBOX' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-and' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/30' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/1' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-Old' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-messages' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-onefor' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-INBOX' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-messages' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-opts' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-first' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-message' (language 'en')
  == Parsing
'/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0000.txt':
Found
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-unknown-caller' (language
'en')
    -- <SIP/bruce.mcalister-096da288> Playing
'/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0000' (language
'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-advopts' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-repeat' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-next' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-message' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/2' (language 'en')
  == Parsing
'/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0001.txt':
Found
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-unknown-caller' (language
'en')
    -- <SIP/bruce.mcalister-096da288> Playing
'/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0001' (language
'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-prev' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-advopts' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-repeat' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-next' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-message' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/3' (language 'en')
  == Parsing
'/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0002.txt':
Found
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-unknown-caller' (language
'en')
    -- <SIP/bruce.mcalister-096da288> Playing
'/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0002' (language
'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-prev' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-advopts' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-repeat' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-next' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-delete' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-toforward' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-savemessage' (language
'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-helpexit' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-goodbye' (language 'en')
[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL
Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL
Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL
Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL
Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL
Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

    -- Executing [171 at base-out:4] Hangup("SIP/bruce.mcalister-096da288", "")
in new stack
  == Spawn extension (base-out, 171, 4) exited non-zero on
'SIP/bruce.mcalister-096da288'

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

Thanks
Bruce

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Bruce
McAlister
Sent: 01 May 2007 00:06
To: asterisk-users at lists.digium.com
Subject: [asterisk-users] Asterisk 1.4.4 VoiceMail ODBC Storage Help
Importance: High

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 [170 at base-out: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 [170 at base-out:2] NoOp("SIP/bruce.mcalister-09051118", "Caller
VoiceMail Extension = 3031") in new stack
-- Executing [170 at base-out:3] VoiceMail("SIP/bruce.mcalister-09051118",
"3031 at users") 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 [170 at base-out: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 [171 at base-out: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 [171 at base-out:2] NoOp("SIP/bruce.mcalister-09051118",
"voicemail extension=3031") in new stack
    -- Executing [171 at base-out:3]
VoiceMailMain("SIP/bruce.mcalister-09051118", "3204 at users") 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 [171 at base-out: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
-------------- next part --------------
-- Executing [171 at base-out:1] AGI("SIP/bruce.mcalister-096da288", "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 [171 at base-out:2] NoOp("SIP/bruce.mcalister-096da288", "voicemail extension=3031") in new stack
    -- Executing [171 at base-out:3] VoiceMailMain("SIP/bruce.mcalister-096da288", "3204 at users") in new stack
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-password' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-youhave' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/8' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-INBOX' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-and' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/30' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/1' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-Old' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-messages' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-onefor' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-INBOX' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-messages' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-opts' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-first' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-message' (language 'en')
  == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0000.txt': Found
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-unknown-caller' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0000' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-advopts' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-repeat' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-next' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-message' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/2' (language 'en')
  == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0001.txt': Found
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-unknown-caller' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0001' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-prev' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-advopts' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-repeat' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-next' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-message' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'digits/3' (language 'en')
  == Parsing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0002.txt': Found
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-unknown-caller' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing '/usr/local/asterisk/var/spool/voicemail/users/3204/INBOX/msg0002' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-prev' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-advopts' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-repeat' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-next' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-delete' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-toforward' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-savemessage' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-helpexit' (language 'en')
    -- <SIP/bruce.mcalister-096da288> Playing 'vm-goodbye' (language 'en')
[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

[May  1 07:50:47] WARNING[30791]: app_voicemail.c:1280 delete_file: SQL Execute error!
[DELETE FROM voicemailmessages WHERE dir=? AND msgnum=?]

    -- Executing [171 at base-out:4] Hangup("SIP/bruce.mcalister-096da288", "") in new stack
  == Spawn extension (base-out, 171, 4) exited non-zero on 'SIP/bruce.mcalister-096da288'


More information about the asterisk-users mailing list