How to save voicemail msgs to a db
Hi, I'm wondering if there's a way to save voicemail messages to a (possibly remote) database. If so, how can that be achieved? Thanks.
Hi, If you are using odbc to connect to your database, http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core Then tell mod_voicemail about the DB via this param in autoload_configs/voicemail.conf.xml: <param name="odbc-dsn" value="dsn:user:pass"/> Regards, Robert -----Original Message----- From: Yungwei Chen [mailto:yungwei@resolvity.com] Sent: Friday, August 26, 2011 1:30 PM To: FreeSWITCH Users Help Subject: [Freeswitch-users] How to save voicemail msgs to a db Hi, I'm wondering if there's a way to save voicemail messages to a (possibly remote) database. If so, how can that be achieved? Thanks.
Thanks for your feedback. Can the voicemail msgs (*.wav) be saved to the db as well? -----Original Message----- From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Robert Hadley Sent: Friday, August 26, 2011 6:42 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] How to save voicemail msgs to a db Hi, If you are using odbc to connect to your database, http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core Then tell mod_voicemail about the DB via this param in autoload_configs/voicemail.conf.xml: <param name="odbc-dsn" value="dsn:user:pass"/> Regards, Robert -----Original Message----- From: Yungwei Chen Sent: Friday, August 26, 2011 1:30 PM To: FreeSWITCH Users Help Subject: [Freeswitch-users] How to save voicemail msgs to a db Hi, I'm wondering if there's a way to save voicemail messages to a (possibly remote) database. If so, how can that be achieved? Thanks. FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
No, the path to the file is saved in the DB, but the file is stored in a folder. There is a default storage folder or you can customize it via this parameter: <!--<param name="storage-dir" value="/tmp"/>--> Robert -----Original Message----- From: Yungwei Chen [mailto:yungwei@resolvity.com] Sent: Monday, August 29, 2011 6:54 AM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] How to save voicemail msgs to a db Thanks for your feedback. Can the voicemail msgs (*.wav) be saved to the db as well? -----Original Message----- From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Robert Hadley Sent: Friday, August 26, 2011 6:42 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] How to save voicemail msgs to a db Hi, If you are using odbc to connect to your database, http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core Then tell mod_voicemail about the DB via this param in autoload_configs/voicemail.conf.xml: <param name="odbc-dsn" value="dsn:user:pass"/> Regards, Robert -----Original Message----- From: Yungwei Chen Sent: Friday, August 26, 2011 1:30 PM To: FreeSWITCH Users Help Subject: [Freeswitch-users] How to save voicemail msgs to a db Hi, I'm wondering if there's a way to save voicemail messages to a (possibly remote) database. If so, how can that be achieved? Thanks. FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
On Mon, Aug 29, 2011 at 7:36 PM, Robert Hadley <robert.hadley@teotech.com> wrote:
Can the voicemail msgs (*.wav) be saved to the db as well?
No, the path to the file is saved in the DB, but the file is stored in a folder. There is a default storage folder or you can customize it via this parameter: <!--<param name="storage-dir" value="/tmp"/>-->
For the record. We intercept the storage-dir with a small FUSE driver so we can store voicemails in a MongoDB/GridFS collection. Cheers. -- Isaac Jurado Internet Busines Solutions eConcept
I would love to see a mongodb/gridfs driver for FS instead.. :-) Maybe someday I will make it happen Regards, João Mesquita On Mon, Aug 29, 2011 at 6:35 PM, Isaac Jurado <ijurado@econcept.es> wrote:
On Mon, Aug 29, 2011 at 7:36 PM, Robert Hadley <robert.hadley@teotech.com> wrote:
Can the voicemail msgs (*.wav) be saved to the db as well?
No, the path to the file is saved in the DB, but the file is stored in a folder. There is a default storage folder or you can customize it via this parameter: <!--<param name="storage-dir" value="/tmp"/>-->
For the record. We intercept the storage-dir with a small FUSE driver so we can store voicemails in a MongoDB/GridFS collection.
Cheers.
-- Isaac Jurado Internet Busines Solutions eConcept
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
On Aug 29, 2011, at 2:35 PM, Isaac Jurado wrote:
For the record. We intercept the storage-dir with a small FUSE driver so we can store voicemails in a MongoDB/GridFS collection.
how reliable have you found FUSE to be? i'm considering doing a Lua-based FUSE binding to CouchDB for the same purpose, but i've had concerns that the approach wouldn't be as stable a a 'normal' filesystem; what's your experience been? chad
If you really want to do this, the most stable would be incorporating the DB / odbc writing directly into the voicemail mod and add it as an option. The fuse setup seems to be a hack. -Avi On Tue, Aug 30, 2011 at 6:17 PM, Chad Phillips -- Apartment Lines < chad@apartmentlines.com> wrote:
On Aug 29, 2011, at 2:35 PM, Isaac Jurado wrote:
For the record. We intercept the storage-dir with a small FUSE driver so we can store voicemails in a MongoDB/GridFS collection.
how reliable have you found FUSE to be? i'm considering doing a Lua-based FUSE binding to CouchDB for the same purpose, but i've had concerns that the approach wouldn't be as stable a a 'normal' filesystem; what's your experience been?
chad
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
On Tue, Aug 30, 2011 at 5:27 PM, Avi Marcus <avi@avimarcus.net> wrote:
If you really want to do this, the most stable would be incorporating the DB / odbc writing directly into the voicemail mod and add it as an option. The fuse setup seems to be a hack.
No doubt it is a hackish solution. But in the GridFS case, the filesystem semantics are a bit different. File truncation to a >0 size, for example, is an extremely expensive operation. The mod_voicemail makes a fairly extensive use of such operation. Sounds like a lot of work. Cheers. -- Isaac Jurado Internet Busines Solutions eConcept
On Tue, Aug 30, 2011 at 5:17 PM, Chad Phillips -- Apartment Lines <chad@apartmentlines.com> wrote:
On Aug 29, 2011, at 2:35 PM, Isaac Jurado wrote:
For the record. We intercept the storage-dir with a small FUSE driver so we can store voicemails in a MongoDB/GridFS collection.
how reliable have you found FUSE to be? i'm considering doing a Lua-based FUSE binding to CouchDB for the same purpose, but i've had concerns that the approach wouldn't be as stable a a 'normal' filesystem; what's your experience been?
Well, we don't have load enough to find bottlenecks. Neither we have time to prepare a stress test. Our implementation is a single python script that uses python-fuse and pymongo. Altogether, they seem to work concurrently (with threads) and cooperate nicely. Although everything is mostly IO bound, eventually we may hit the GIL wall, in such case we will have to reconsider our solution. You may have better luck with Lua, in case you do threading, by using a different interpreter instance per-thread (just like mod_wsgi does with Python). Cheers. -- Isaac Jurado Internet Busines Solutions eConcept
participants (6)
-
Avi Marcus
-
Chad Phillips -- Apartment Lines
-
Isaac Jurado
-
João Mesquita
-
Robert Hadley
-
Yungwei Chen