[Asterisk-bugs] [Asterisk 0010194]: Voicemail does not attach audio file to email when sending to multiple voicemail boxes with ODBC storage

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=10194 
====================================================================== 
Reported By:                blitzrage
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   10194
Category:                   Applications/app_voicemail
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     ready for testing
Asterisk Version:            1.4.6 
SVN Branch (only for SVN checkouts, not tarball releases): N/A  
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             07-12-2007 15:20 CDT
Last Modified:              07-18-2007 11:49 CDT
====================================================================== 
Summary:                    Voicemail does not attach audio file to email when
sending to multiple voicemail boxes with ODBC storage
Description: 
When using something like Voicemail(100 at default&101 at default&102 at default)
the extra voicemail boxes do not get the audio file attached to the email
because the system does not pull out the audio file from the database so
sendmail can grab the file from the file system.
====================================================================== 

---------------------------------------------------------------------- 
 blitzrage - 07-18-07 11:49  
---------------------------------------------------------------------- 
Sorry... did not work :(

    -- Executing [reject at sub-route:9]
VoiceMail("SIP/ss1tampa.mixnetworks.com-088ab680",
"107 at telcel&103 at telcel&201 at telcel|s") in new stack
    -- <SIP/ss1tampa.mixnetworks.com-088ab680> Playing 'beep' (language
'en')
    -- Recording the message
    -- x=0, open writing: 
/var/spool/asterisk/voicemail/telcel/107/tmp/nW1ALK format: wav, 0x88bcbf0
    -- User hung up
[Jul 18 13:02:13] NOTICE[16279]: app_voicemail.c:2623 copy_message:
Copying message from 107 at telcel to 103 at telcel
[Jul 18 13:02:13] WARNING[16279]: app_voicemail.c:1282 delete_file: SQL
Execute error!
[DELETE FROM voicemessages WHERE dir=? AND msgnum=?]

[Jul 18 13:02:13] WARNING[16279]: app_voicemail.c:1702 base_encode: Failed
to open log file:
/var/spool/asterisk/voicemail/telcel/103/INBOX/msg0005.wav: No such file or
directory
[Jul 18 13:02:13] NOTICE[16279]: app_voicemail.c:2623 copy_message:
Copying message from 107 at telcel to 201 at telcel
[Jul 18 13:02:13] WARNING[16279]: app_voicemail.c:1282 delete_file: SQL
Execute error!
[DELETE FROM voicemessages WHERE dir=? AND msgnum=?]

[Jul 18 13:02:13] WARNING[16279]: app_voicemail.c:1702 base_encode: Failed
to open log file:
/var/spool/asterisk/voicemail/telcel/201/INBOX/msg0001.wav: No such file or
directory
[Jul 18 13:02:13] WARNING[16279]: app_voicemail.c:1282 delete_file: SQL
Execute error!
[DELETE FROM voicemessages WHERE dir=? AND msgnum=?]

  == Parsing '/var/spool/asterisk/voicemail/telcel/107/INBOX/msg0006.txt':
Found
[Jul 18 13:02:13] WARNING[16279]: app_voicemail.c:1093 retrieve_file: SQL
Get Data error!
[SELECT * FROM voicemessages WHERE dir=? AND msgnum=?]

  == Spawn extension (sub-route, reject, 9) exited non-zero on
'SIP/ss1tampa.mixnetworks.com-088ab680' 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
07-18-07 11:49  blitzrage      Note Added: 0067528                          
======================================================================