<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16735" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"
bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks.</FONT></DIV>
<DIV><FONT face=Arial size=2>In the instruction, it state that <FONT
face="Times New Roman" size=3>"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?</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Gary</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=mike@jerris.com href="mailto:mike@jerris.com">Michael Jerris</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeswitch-users@lists.freeswitch.org
href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, November 12, 2008 4:39
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Freeswitch-users] How to
make FS to use ODBC instead of SQLITE?</DIV>
<DIV><BR></DIV><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="WORD-SPACING: 0px; FONT: 12px Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; orphans: 2; widows: 2; -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>
<P>
<HR>
<P></P>_______________________________________________<BR>Freeswitch-users
mailing
list<BR>Freeswitch-users@lists.freeswitch.org<BR>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<BR>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<BR>http://www.freeswitch.org<BR></BLOCKQUOTE></BODY></HTML>