asterisk users - Nov 2012 - Long voicemails not being stored in database

Hi all,

I've been using mysql, via odbc,? to store voicemails for some time now.?
However, we've recently noticed that when someone leave a message of about
45 seconds or loinger, the message doesn't get stored in the database.? We
do, however, receive the email notification with attachment intact.

My server is pretty busy, so I'm not really able to get a console output,
untill much later tonight, perhaps.

I'm thinking it's a tuning parameter on the mysql database that sets the
size of a blob, but I don't know.

Any help would be appreciated.

Mike Diehl.
--

Take care and have fun,
Mike Diehl.

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20121106/184082c2/attachment.htm>

IIRC blobs are normally set to a limit of 65 Kb.  You may need to redefine
as medium blob (16Mb) or long blob (4 Gb).  28 seconds at 44 Khz takes up
around 2.5 Mb.

 

From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Mike Diehl
Sent: Tuesday, November 06, 2012 3:16 PM
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
Subject: [asterisk-users] Long voicemails not being stored in database

 

Hi all,

I've been using mysql, via odbc,  to store voicemails for some time now.
However, we've recently noticed that when someone leave a message of about
45 seconds or loinger, the message doesn't get stored in the database.  We
do, however, receive the email notification with attachment intact.

My server is pretty busy, so I'm not really able to get a console output,
untill much later tonight, perhaps.

I'm thinking it's a tuning parameter on the mysql database that sets the
size of a blob, but I don't know.

Any help would be appreciated.

Mike Diehl.

  _____  


Take care and have fun,
Mike Diehl. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20121106/2651fead/attachment.htm>