I’ve been using mysql, via odbc,
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.
[mailto:email@example.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
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.
Take care and have fun, Mike Diehl.
I went and checked; my database has the recording field defined as a longblob.
Any other ideas would be most appreciated.
“Danny Nicholas” wrote: