[asterisk-users] No audio playing back voicemail from odbc

[Matthew Jordan]

----- Original Message ----- 

> From: "Support" <mdiehl at diehlnet.com>
> To: asterisk-users at lists.digium.com
> Sent: Saturday, July 28, 2012 4:43:55 AM
> Subject: [asterisk-users] No audio playing back voicemail from odbc

> Hi all,

> I'm trying to get my voicemail messages stored in a mysql database
> via odbc. Most of it is working, except, when I play my
> voicemail messages, I don't hear anything.

> I can confirm that the messages are getting stored in the database:

> select
> uniqueid,msgnum,dir,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag,`read`
> from voicemessages;
> +----------+--------+-------------------------------------------------+-----------+--------------+----------------+------------+----------+-------------+----------------+------+------+
> | uniqueid | msgnum | dir | context | macrocontext | callerid |
> | origtime | duration | mailboxuser | mailboxcontext | flag | read |
> +----------+--------+-------------------------------------------------+-----------+--------------+----------------+------------+----------+-------------+----------------+------+------+
> | 7 | 0 | /var/spool/asterisk/voicemail/diehlnet/7001/Old | customers
> | | | FFFF17442025-1 | 1343462922 | 0 | 7001 | diehlnet | | 0 |
> +----------+--------+-------------------------------------------------+-----------+--------------+----------------+------------+----------+-------------+----------------+------+------+

Your message has a duration of 0.  So while a file was created, it does
not apparently have an audio length.

What is your voicemail.conf configuration?  Do you have a minduration
set?

> select length(recording) from voicemessages;
> +-------------------+
> | length(recording) |
> +-------------------+
> | 52204 |
> +-------------------+

> This is what the console displays during message playback:

> [Jul 28 02:28:35] == Parsing
> '/var/spool/asterisk/voicemail/diehlnet/7001/Old/msg0000.txt': [Jul
> 28 02:28:35] == Found
> [Jul 28 02:28:35] -- <SIP/FFFF17442025-1-0000000d> Playing
> 'vm-message.ulaw' (language 'en')
> [Jul 28 02:28:36] -- <SIP/FFFF17442025-1-0000000d> Playing
> 'vm-unknown-caller.ulaw' (language 'en')
> [Jul 28 02:28:38] -- <SIP/FFFF17442025-1-0000000d> Playing
> '/var/spool/asterisk/voicemail/diehlnet/7001/Old/msg0000.slin'
> (language 'en')

> Of course mg0000.txt and msg0000.slin don't exist. I'm assuming
> Asterisk creates them and deletes them?

When Asterisk plays a message from a non-file message storage backend,
it extracts from the backend and stores it locally on the file system.
It then plays the file from there.

When it has finished, it does delete it.  So yes, the log messages
are correct - it is playing the file from that location.

> Also, on a side note, ODBC storage and video voicemail aren't going
> to work together, right?

Asterisk stores video voicemail messages as both a video file and an
audio file.  Since the ODBC/IMAP backends only store a single file
format, you will either end up storing only the video, or only the
audio, which is probably not what you want.

File storage is the only mechanism to have video voicemail (with audio)
at this time.


--
Matthew Jordan
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at: http://digium.com & http://asterisk.org