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?

----- Original Message -----

From: Michael Jerris

Sent: Wednesday, November 12, 2008 4:39 PM

Subject: Re: [Freeswitch-users] How to make FS to use ODBC instead of SQLITE?

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.

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