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 | +----------+--------+-------------------------------------------------+-----------+--------------+----------------+------------+----------+-------------+----------------+------+------+ 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? But I don't hear anything. Any ideas? Asterisk version 10.6.1 Also, on a side note, ODBC storage and video voicemail aren't going to work together, right? -- Take care and have fun, Mike Diehl. -- Mike Diehl. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120728/b0b7c842/attachment.htm>
Matthew Jordan
2012-Jul-28 15:19 UTC
[asterisk-users] No audio playing back voicemail from odbc
----- 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
Matthew Jordan
2012-Jul-30 02:28 UTC
[asterisk-users] No audio playing back voicemail from odbc
----- Original Message -----> From: "Mike Diehl" <mdiehl at dominion.diehlnet.com> > To: asterisk-users at lists.digium.com > Cc: "Matthew Jordan" <mjordan at digium.com> > Sent: Sunday, July 29, 2012 3:39:05 PM > Subject: Re: [asterisk-users] No audio playing back voicemail from odbc > > On Saturday 28 July 2012 6:45:15 pm Matthew Jordan wrote: > > An alternative might be to store time offsets from start of call in > the > database. Then the playback routines would simply have to play the > media "in > order." Do you see a flaw in this design?Not really a flaw, but there'd be a lot more to it then that. You'd have to modify Playback (or some other application) to interleave the frames properly from two files that have different formats. That kind of mechanism doesn't currently exist. Not impossible, but certainly more then just knowing which media file started when. The nice thing about a media container is that it should have an API that helps you with those kinds of things. -- 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
Well, it gets even stranger.... I've installed version 10.2.1, instead of 10.7.1, and copied the configuration files from another identical server that is running 10.2.1 is working correctly. I STILL can't get voicemail to play back. I can hear the password prompts Theses are, what I think to be, the relevant settings in voicemail.conf: ;minmessage=3 maxsilence=10 silencethreshold=128 When I set silencethresholdo either 500 or 64, I still didn't hear anything. (But I did hear several seconds of actual silence. The .wav file contains nothing but silence. So, fiddling with the silencethreshold in both directions, doesn't seem to change the symptoms. Where else should I look? TIA Mike. On Saturday 28 July 2012 3:43:55 am Support wrote:> 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,mailbox > user,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 | > > +----------+--------+-------------------------------------------------+---- > -------+--------------+----------------+------------+----------+----------- > --+----------------+------+------+ > > 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? > > But I don't hear anything. Any ideas? Asterisk version 10.6.1 > > Also, on a side note, ODBC storage and video voicemail aren't going to work > together, right?-- Take care and have fun, Mike Diehl. -- Mike Diehl.