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

[gary]

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 at 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 at lists.freeswitch.org
  http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
  UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
  http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20081113/72c457a5/attachment-0002.html