VoIP Mailing List Archives

[gang.chen at insightbb...]

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

Gary

[mike at jerris.com]

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:

[gang.chen at insightbb...]

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

[gang.chen at insightbb...]

Thanks. I will use one DB.

[mike at jerris.com]

I don't agree with that statement on the wiki.


On Nov 13, 2008, at 8:12 AM, gary wrote: