Re: [asterisk-users] Record() Cmd and My SQL
Sorry . Week end I was away . Another reason for storing in the database is to , enable some other apps to access the recording at some point of time . Regards Mahesh -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of ext Don Kelly Sent: Friday, September 24, 2010 11:49 PM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: Re: [asterisk-users] Record() Cmd and My SQL I hadn't considered writing to the db real-time; was actually planning on recording locally and moving it to the db. Thanks for the suggestions. --Don -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of David Backeberg Sent: Friday, September 24, 2010 12:56 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Record() Cmd and My SQL On Fri, Sep 24, 2010 at 1:32 PM, Don Kelly d...@donkelly.biz wrote: Don sez: I don't know how to make Outlook indent. I usually top-post, but I don't like getting yelled at. Why do you say Don't do that? Is there a real reason that it would be bad? Performance is a real reason. Multiple simultaneous write streams into a database sounds like a disaster. While trying to read from the db and use it to listen to recordings sounds like a bigger disaster. /path/to/the/recording is a short varchar string the actual recording is a massive, usually multi-megabyte, potentially multi-gigabyte blob. http://en.wikipedia.org/wiki/Blob_(computing) If you're not actually taking advantage of the recording being in the database, doing computing that is easier because of the database, such as nearest neighbor searches, indexing, and the like, you're just slowing down your ability to store and retrieve recordings. I'd like to put the recordings in a database so they are available to another application that has no other relationship to the Asterisk server. Sounds like a filesystem. I can store my pdf file with my web browser, and read it on another computer after I store it to my shared filesystem. The application uses the database to determine if the recording has been listened to, by whom and if it needs additional attention. Database can maintain metadata (as can a filesystem, owner, creation date, access date), but you could still just store a pointer to the actual file in the db. If you were paranoid about the filesystem and db getting out of step you could do referential integrity checks in the application. If you want to do something wholesale to all the recordings, like carve off the first five seconds, it's quite straightforward with a batched sox call against the filesystem. If you want to do that in a db, it's a select, write output to a file, convert the file, and replace on the value to store it back into the db. -- _ -- _ -- 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 -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
Why not write the file to /tmp using MixMonitor, then use the command option to trigger an AGI script that will move the data into your database then delete the original file? John On 24 September 2010 04:23, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: The reason is when doing a load balancing , We cannot confine the recording to a particular asterisk machine ( If we have more than one asterisk machine in the topology ). So a centralized mechanism might be better . So that any machine can access the recording . Regards Mahesh -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of ext David Backeberg Sent: Thursday, September 23, 2010 9:51 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Record() Cmd and My SQL On Thu, Sep 23, 2010 at 2:21 AM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: HI , Is there Any way is there so that I can store my recordings directly to a database rather storing the same to a file . Please, please, please tell us why you would want to do that. -- _ -- 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 -- _ -- 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 -- JA Taylor MA VetMB MRCVS Mansion Hill Veterinary Practice 133-137 Main Road Middleton Cheney OX17 2PP 01295 712110 -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
Thanks , I was not knowing about Mix Monitor . Whether MixMonitor is faster than record ? Both uses same mechanism to write to the file . Regards Mahesh -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of ext John Taylor Sent: Friday, September 24, 2010 1:24 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Record() Cmd and My SQL Why not write the file to /tmp using MixMonitor, then use the command option to trigger an AGI script that will move the data into your database then delete the original file? John On 24 September 2010 04:23, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: The reason is when doing a load balancing , We cannot confine the recording to a particular asterisk machine ( If we have more than one asterisk machine in the topology ). So a centralized mechanism might be better . So that any machine can access the recording . Regards Mahesh -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of ext David Backeberg Sent: Thursday, September 23, 2010 9:51 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Record() Cmd and My SQL On Thu, Sep 23, 2010 at 2:21 AM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: HI , Is there Any way is there so that I can store my recordings directly to a database rather storing the same to a file . Please, please, please tell us why you would want to do that. -- _ -- 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 -- _ -- 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 -- JA Taylor MA VetMB MRCVS Mansion Hill Veterinary Practice 133-137 Main Road Middleton Cheney OX17 2PP 01295 712110 -- _ -- 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 -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
On Thu, Sep 23, 2010 at 11:23 PM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: The reason is when doing a load balancing , We cannot confine the recording to a particular asterisk machine ( If we have more than one asterisk machine in the topology ). Yes you can. You can record the file wherever the call takes place. In fact, you can make the recording on any network segment the packet traverses as well. So a centralized mechanism might be better . So that any machine can access the recording . Regards Mahesh Recordings are formatted data, typically stored as files. You can put them into a database, but you haven't provided a reason why that would be a good idea. There are these things called shared filesystems. You should take a look at them. They work well. Options include NFS, iscsi, sans, etc. Or you can record the file in-place, and when the recording completes, copy it off to your shared filesystem. That's what I do. Or you can take a look at something like OrecX, which let's you do network spanning on your entire subnet, and it doesn't matter where your call takes place because all RTP streams get written to disk. None of what you've explained would be a good reason to put your recordings into a database. Don't do that. -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
-Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of David Backeberg Sent: Friday, September 24, 2010 11:28 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Record() Cmd and My SQL On Thu, Sep 23, 2010 at 11:23 PM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: The reason is when doing a load balancing , We cannot confine the recording to a particular asterisk machine ( If we have more than one asterisk machine in the topology ). Yes you can. You can record the file wherever the call takes place. In fact, you can make the recording on any network segment the packet traverses as well. So a centralized mechanism might be better . So that any machine can access the recording . Regards Mahesh Recordings are formatted data, typically stored as files. You can put them into a database, but you haven't provided a reason why that would be a good idea. There are these things called shared filesystems. You should take a look at them. They work well. Options include NFS, iscsi, sans, etc. Or you can record the file in-place, and when the recording completes, copy it off to your shared filesystem. That's what I do. Or you can take a look at something like OrecX, which let's you do network spanning on your entire subnet, and it doesn't matter where your call takes place because all RTP streams get written to disk. None of what you've explained would be a good reason to put your recordings into a database. Don't do that. Don sez: I don't know how to make Outlook indent. I usually top-post, but I don't like getting yelled at. Why do you say Don't do that? Is there a real reason that it would be bad? I'd like to put the recordings in a database so they are available to another application that has no other relationship to the Asterisk server. The application uses the database to determine if the recording has been listened to, by whom and if it needs additional attention. --Don -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
On Fri, Sep 24, 2010 at 1:32 PM, Don Kelly d...@donkelly.biz wrote: Don sez: I don't know how to make Outlook indent. I usually top-post, but I don't like getting yelled at. Why do you say Don't do that? Is there a real reason that it would be bad? Performance is a real reason. Multiple simultaneous write streams into a database sounds like a disaster. While trying to read from the db and use it to listen to recordings sounds like a bigger disaster. /path/to/the/recording is a short varchar string the actual recording is a massive, usually multi-megabyte, potentially multi-gigabyte blob. http://en.wikipedia.org/wiki/Blob_(computing) If you're not actually taking advantage of the recording being in the database, doing computing that is easier because of the database, such as nearest neighbor searches, indexing, and the like, you're just slowing down your ability to store and retrieve recordings. I'd like to put the recordings in a database so they are available to another application that has no other relationship to the Asterisk server. Sounds like a filesystem. I can store my pdf file with my web browser, and read it on another computer after I store it to my shared filesystem. The application uses the database to determine if the recording has been listened to, by whom and if it needs additional attention. Database can maintain metadata (as can a filesystem, owner, creation date, access date), but you could still just store a pointer to the actual file in the db. If you were paranoid about the filesystem and db getting out of step you could do referential integrity checks in the application. If you want to do something wholesale to all the recordings, like carve off the first five seconds, it's quite straightforward with a batched sox call against the filesystem. If you want to do that in a db, it's a select, write output to a file, convert the file, and replace on the value to store it back into the db. -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
snip To add to this laundry list #1. It is much simpler to get a path from a database and load that file than to try and process a MYSQL BLOB of any size. #2. If you should eventually leave MYSQL, blobs don't always play nicely (no pun intended) with other DB's like PostgreSQL. #3. You can always use SOX to make a file into a smaller format - good luck doing that with a BLOB. -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
I hadn't considered writing to the db real-time; was actually planning on recording locally and moving it to the db. Thanks for the suggestions. --Don -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of David Backeberg Sent: Friday, September 24, 2010 12:56 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Record() Cmd and My SQL On Fri, Sep 24, 2010 at 1:32 PM, Don Kelly d...@donkelly.biz wrote: Don sez: I don't know how to make Outlook indent. I usually top-post, but I don't like getting yelled at. Why do you say Don't do that? Is there a real reason that it would be bad? Performance is a real reason. Multiple simultaneous write streams into a database sounds like a disaster. While trying to read from the db and use it to listen to recordings sounds like a bigger disaster. /path/to/the/recording is a short varchar string the actual recording is a massive, usually multi-megabyte, potentially multi-gigabyte blob. http://en.wikipedia.org/wiki/Blob_(computing) If you're not actually taking advantage of the recording being in the database, doing computing that is easier because of the database, such as nearest neighbor searches, indexing, and the like, you're just slowing down your ability to store and retrieve recordings. I'd like to put the recordings in a database so they are available to another application that has no other relationship to the Asterisk server. Sounds like a filesystem. I can store my pdf file with my web browser, and read it on another computer after I store it to my shared filesystem. The application uses the database to determine if the recording has been listened to, by whom and if it needs additional attention. Database can maintain metadata (as can a filesystem, owner, creation date, access date), but you could still just store a pointer to the actual file in the db. If you were paranoid about the filesystem and db getting out of step you could do referential integrity checks in the application. If you want to do something wholesale to all the recordings, like carve off the first five seconds, it's quite straightforward with a batched sox call against the filesystem. If you want to do that in a db, it's a select, write output to a file, convert the file, and replace on the value to store it back into the db. -- _ -- _ -- 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
[asterisk-users] Record() Cmd and My SQL
HI , Is there Any way is there so that I can store my recordings directly to a database rather storing the same to a file . Thanks in advance . Regards Mahesh -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
I hope it cant be done using dialplan but it can be done through AGI scripting...you can use your favorite programming language PHP / Perl and try to record the call with record application and point to the database instead of a folder path. Asterisk Users your feedback also welcome on this.. On Thu, Sep 23, 2010 at 11:51 AM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: HI , Is there Any way is there so that I can store my recordings directly to a database rather storing the same to a file . Thanks in advance . Regards Mahesh -- _ -- 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 -- Thank you with regards, Gopalakrishnan A.N, -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
Thanks , Do you have some sample for that . Regards Mahesh From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of ext Gopalakrishnan A.N Sent: Thursday, September 23, 2010 5:46 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Record() Cmd and My SQL I hope it cant be done using dialplan but it can be done through AGI scripting...you can use your favorite programming language PHP / Perl and try to record the call with record application and point to the database instead of a folder path. Asterisk Users your feedback also welcome on this.. On Thu, Sep 23, 2010 at 11:51 AM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: HI , Is there Any way is there so that I can store my recordings directly to a database rather storing the same to a file . Thanks in advance . Regards Mahesh -- _ -- 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 -- Thank you with regards, Gopalakrishnan A.N, -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
sorry I dont have samples, but you can find lots of php agi scripts by googling.. On Thu, Sep 23, 2010 at 7:07 PM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: Thanks , Do you have some sample for that . Regards Mahesh *From:* asterisk-users-boun...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *On Behalf Of *ext Gopalakrishnan A.N *Sent:* Thursday, September 23, 2010 5:46 PM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] Record() Cmd and My SQL I hope it cant be done using dialplan but it can be done through AGI scripting...you can use your favorite programming language PHP / Perl and try to record the call with record application and point to the database instead of a folder path. Asterisk Users your feedback also welcome on this.. On Thu, Sep 23, 2010 at 11:51 AM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: HI , Is there Any way is there so that I can store my recordings directly to a database rather storing the same to a file . Thanks in advance . Regards Mahesh -- _ -- 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 -- Thank you with regards, Gopalakrishnan A.N, -- _ -- 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 -- Thank you with regards, Gopalakrishnan A.N, -- _ -- 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
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? -- _ -- 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
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 From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@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? -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@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-boun...@lists.digium.com [mailto:asterisk-users-boun...@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 -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
On Thu, Sep 23, 2010 at 2:21 AM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: HI , Is there Any way is there so that I can store my recordings directly to a database rather storing the same to a file . Please, please, please tell us why you would want to do that. -- _ -- 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
Re: [asterisk-users] Record() Cmd and My SQL
The reason is when doing a load balancing , We cannot confine the recording to a particular asterisk machine ( If we have more than one asterisk machine in the topology ). So a centralized mechanism might be better . So that any machine can access the recording . Regards Mahesh -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of ext David Backeberg Sent: Thursday, September 23, 2010 9:51 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Record() Cmd and My SQL On Thu, Sep 23, 2010 at 2:21 AM, Govind, Mahesh (NSN - IN/Bangalore) mahesh.gov...@nsn.com wrote: HI , Is there Any way is there so that I can store my recordings directly to a database rather storing the same to a file . Please, please, please tell us why you would want to do that. -- _ -- 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 -- _ -- 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