<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><a href="http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core">http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core</a><div><br></div><div>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.</div><div><br></div><div>Mike</div><div><br><div><div>On Nov 12, 2008, at 3:54 PM, gary wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div bgcolor="#ffffff"><div><font face="Arial" size="2">I am tring to configure FS to use ODBC with mysql instead of sqlite to store all the SIP registration information.</font></div><div><font face="Arial" size="2">The UnixODBC and mysql all work fine. I also find the doc on the web regarding install<span class="Apple-converted-space"> </span><font face="Times New Roman">SpiderMonkey ODBC. It seems that this one is for using javascript to access ODBC db.</font></font></div><div><font size="2">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?</font></div><div><font size="2">I compile FS with following steps:</font></div><div><font size="2">1) uncomment the<span class="Apple-converted-space"> </span><code>languages/mod_spidermonkey_odbc</code><span class="Apple-converted-space"> </span>line within the<span class="Apple-converted-space"> </span><code>build/modules.conf</code><span class="Apple-converted-space"> </span>file.</font></div><div><font size="2">2) ./configure --enable-core-odbc-support<br>3) make all install</font></div><div><font size="2"></font> </div><div><font size="2"><font face="Arial">What else do I need to do to make FS using ODBC instead of sqlite? </font></font></div><div><font size="2"><font face="Arial">database name? table structure? user name? password? etc<br></font></font></div><font size="2"><div><font face="Arial"></font></div></font></div></span></blockquote></div></div></body></html>