Thanks. In the instruction, it state that "A separate database should be used for each, including each type of SIP (external, internal and nat are typical examples). Therefore, the odbc.ini in /etc, should include an entry for each database used". Why is that? Can I use one database for all? Gary ----- Original Message ----- From: Michael Jerris To: freeswitch-users@lists.freeswitch.org Sent: Wednesday, November 12, 2008 4:39 PM Subject: Re: [Freeswitch-users] How to make FS to use ODBC instead of SQLITE? http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core You can configure odbc as normal on the box to setup the dsn's then follow the instructions at that link. FreeSWITCH will create the tables it needs for you. Mike On Nov 12, 2008, at 3:54 PM, gary wrote: I am tring to configure FS to use ODBC with mysql instead of sqlite to store all the SIP registration information. The UnixODBC and mysql all work fine. I also find the doc on the web regarding install SpiderMonkey ODBC. It seems that this one is for using javascript to access ODBC db. What is the procedure to enable ODBC support for FS core system? I guess I also need to create database schema for FS to use. Where can I find it? I compile FS with following steps: 1) uncomment the languages/mod_spidermonkey_odbc line within the build/modules.conf file. 2) ./configure --enable-core-odbc-support 3) make all install What else do I need to do to make FS using ODBC instead of sqlite? database name? table structure? user name? password? etc ------------------------------------------------------------------------------ _______________________________________________ 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

Thanks. I will use one DB. ----- Original Message ----- From: Michael Jerris To: freeswitch-users@lists.freeswitch.org Sent: Thursday, November 13, 2008 10:16 AM Subject: Re: [Freeswitch-users] How to make FS to use ODBC instead of SQLITE? I don't agree with that statement on the wiki. On Nov 13, 2008, at 8:12 AM, gary wrote: Thanks. In the instruction, it state that "A separate database should be used for each, including each type of SIP (external, internal and nat are typical examples). Therefore, the odbc.ini in /etc, should include an entry for each database used". Why is that? Can I use one database for all? Gary ------------------------------------------------------------------------------ _______________________________________________ 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