Hello all, is it possible, to record calls directly as BLOB into a MySQL database? Best regards Stefan -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120831/abada24a/attachment.htm>
Probably "possible" but not recommendable. You have no idea how long your call will or will not be. It would be better to record the call into a wav or gsm file, then put that into the blob. From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Stefan at WPF Sent: Friday, August 31, 2012 10:22 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] Record calls as BLOB into MySQL? Hello all, is it possible, to record calls directly as BLOB into a MySQL database? Best regards Stefan -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120831/a246aea6/attachment.htm>
Thanks Danny, do you mean better put the filename into the database? 2012/8/31 Danny Nicholas <danny at debsinc.com>> Probably ?possible? but not recommendable. You have no idea how long your > call will or will not be. It would be better to record the call into a wav > or gsm file, then put that into the blob.**** > > ** ** > > *From:* asterisk-users-bounces at lists.digium.com [mailto: > asterisk-users-bounces at lists.digium.com] *On Behalf Of *Stefan at WPF > *Sent:* Friday, August 31, 2012 10:22 AM > *To:* Asterisk Users Mailing List - Non-Commercial Discussion > *Subject:* [asterisk-users] Record calls as BLOB into MySQL?**** > > ** ** > > Hello all, > > is it possible, to record calls directly as BLOB into a MySQL database? > > > Best regards > Stefan**** > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120831/b839d386/attachment-0001.htm>
On Friday 31 August 2012, Stefan at WPF wrote:> Hello all, > > is it possible, to record calls directly as BLOB into a MySQL database? > > > Best regards > StefanYes, it's possible, with some heavy hacking (and it ends up creating an unredistributable binary -- you can't comply with all the provisions of all the licences involved, and the only thing allowing you to use it at all is the fair dealing provision of copyright law); but the real question is, *why* would you want to do it? Unix already provides a perfectly good filesystem for storing files. Just record your call to a file as normal, and stick the filename and whatever metadata you like in the database. Job's a good 'un! -- AJS Answers come *after* questions.
In article <CADBM-wiAgu9ALX1rqf1e_3Di3piPznYhiLT5huYC851spzHjsA at mail.gmail.com>, Stefan at WPF <stefan.at.wpf at googlemail.com> wrote:> > Thanks Danny, > > do you mean better put the filename into the database?I would normally just put the filename into the database. However, if you had a good reason for storing the actual content in a BLOB field, you could use the LOAD_FILE() function to copy from the file to the field. See http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_load-file You would need to make sure your MySQL configuration had a suitable value for max_allowed_packet, as mentioned in the above section. Cheers Tony> 2012/8/31 Danny Nicholas <danny at debsinc.com> > > > Probably ?possible? but not recommendable. You have no idea how long your > > call will or will not be. It would be better to record the call into a wav > > or gsm file, then put that into the blob.**** > > > > ** ** > > > > *From:* asterisk-users-bounces at lists.digium.com [mailto: > > asterisk-users-bounces at lists.digium.com] *On Behalf Of *Stefan at WPF > > *Sent:* Friday, August 31, 2012 10:22 AM > > *To:* Asterisk Users Mailing List - Non-Commercial Discussion > > *Subject:* [asterisk-users] Record calls as BLOB into MySQL?**** > > > > ** ** > > > > Hello all, > > > > is it possible, to record calls directly as BLOB into a MySQL database? > > > > > > Best regards > > Stefan**** > > > > -- > > _____________________________________________________________________ > > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > New to Asterisk? Join us for a live introductory webinar every Thurs: > > http://www.asterisk.org/hello > > > > asterisk-users mailing list > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > -=-=-=-=-=- > [Alternative: text/html] > -=-=-=-=-=- > -=-=-=-=-=- > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > -=-=-=-=-=--- Tony Mountifield Work: tony at softins.co.uk - http://www.softins.co.uk Play: tony at mountifield.org - http://tony.mountifield.org
Why not use use voicemail odbc storage engine and it will store your voicemail files is MySQL as BLOBs Sent from my iPhone On Aug 31, 2012, at 7:00 PM, asterisk-users-request at lists.digium.com wrote:> [asterisk-users] Record calls as BLOB into MySQL?