Long Voicemails Not Being Stored In Database

Home » Asterisk Users » Long Voicemails Not Being Stored In Database

2 thoughts on - Long Voicemails Not Being Stored In Database

  • 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@lists.digium.com
    [mailto:asterisk-users-bounces@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.

  • I went and checked; my database has the recording field defined as a longblob.

    Any other ideas would be most appreciated.

    Mike Diehl.

    “Danny Nicholas” wrote: