[asterisk-users] Record() Cmd and My SQL

[Danny Nicholas]

>From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of ext Danny
Nicholas
>Sent: Thursday, September 23, 2010 7:27 PM
>To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
>Subject: Re: [asterisk-users] Record() Cmd and My SQL

 

>Just my .02 - 

>#1 - voip-info.org is a good resource for finding this kind of script

>#2 - I think you are asking for trouble doing a direct recording using the
PHP/MySQL combination; Personally I would do C/MySQL but the exposure you
face depends on the length of your recording(s).

>#3 - since you are going to need to go the AGI route anyway, why not do a
MixMonitor/AGI combination so you get the speed/reliability of a disk
write-to-file?

>>From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Govind, Mahesh
(NSN - IN/Bangalore)
>>Sent: Thursday, September 23, 2010 9:49 AM
>>To: Asterisk Users Mailing List - Non-Commercial Discussion
>>Subject: Re: [asterisk-users] Record() Cmd and My SQL

 

>>Thanks .

>>I checked in voip info but I was not able to find a script which records
directly to database . All scripts were recording directly to files .

 

>>About #2 and  #3 can you please provide some more information .

 

>>Regards

>>Mahesh

 

Okay, I did some googling and according to this link

http://www.voip-info.org/wiki/view/Asterisk+AGI

 

You can't record directly to a database.

 

If these are "short" recordings (less than 60 seconds), I would do something
like this:

 

Exten => 1234,1,playback(intromessage)

Exten => 1234,2,record("/tmp/filex.gsm")

Exten => 1234,3,MYSQL( write /tmp/filex as a blob into a record)

 

Refer to this link also

http://www.bigresource.com/MYSQL-Audio-Files-in-BLOB-egyxueFP.html

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100923/e9262a6e/attachment.htm