<HTML>
<HEAD>
<TITLE>Re: [Freeswitch-users] ODBC in place of db/core.db</TITLE>
</HEAD>
<BODY>
<FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Even if you could put the core DB into an external RDBMS that still wouldn’t get you failover... The core DB is not really where the call states are tracked that’s just there to make things like getting status outputs easier to keep from having to lock memory everytime someone does a show channels or show calls or whatever<BR>
<BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"><B>From: </B>Joseph Bajin <josephbajin@gmail.com><BR>
<B>Reply-To: </B><freeswitch-users@lists.freeswitch.org><BR>
<B>Date: </B>Tue, 20 Jan 2009 00:33:45 -0500<BR>
<B>To: </B><freeswitch-users@lists.freeswitch.org><BR>
<B>Subject: </B>Re: [Freeswitch-users] ODBC in place of db/core.db<BR>
<BR>
But that won't accomplish setting up any sort of Failover right? You'll have access to the db, but it would do no good correct...<BR>
<BR>
<BR>
<BR>
2009/1/19 Michael Jerris <mike@jerris.com><BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>You can disable the core db using -nosql or if you want to remotely have access to an odbc db of calls you can make an event socket listener to make your own db.<BR>
<BR>
Mike<BR>
<BR>
<BR>
On Jan 19, 2009, at 1:04 PM, "Anthony Minessale" <anthony.minessale@gmail.com> wrote:<BR>
<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>it's not possible, the core is only sqlite.<BR>
<BR>
<BR>
On Mon, Jan 19, 2009 at 11:51 AM, Adam Long < <a href="mailto:ajlong@worldlink.net"><mailto:ajlong@worldlink.net></a> ajlong@worldlink.net> wrote:<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Hi Guys,<BR>
<BR>
<BR>
<BR>
I have read the documentation on the wiki and have successfully compiled FreeSwtich with odbc core support.<BR>
<BR>
I am able to get my SIP Profiles and Voicemail databases to load, create, and utilize the ODBC database tables successfully.<BR>
<BR>
<BR>
<BR>
However, I cannot seem to figure out how to make FreeSwitch use the ODBC database instead of the SQL Lite db/core.db<BR>
<BR>
<BR>
<BR>
I'm sure it's just a matter of properly placing the following line in one of the configs…<BR>
<BR>
<param name="odbc-dsn" value="dns-name:user:password"/><BR>
<BR>
<BR>
<BR>
If anyone can point me in the right direction I would greatly appreciate it.<BR>
<BR>
<BR>
<BR>
Thank you!<BR>
<BR>
_______________________________________________<BR>
Freeswitch-users mailing list<BR>
<a href="mailto:Freeswitch-users@lists.freeswitch.org"><mailto:Freeswitch-users@lists.freeswitch.org></a> Freeswitch-users@lists.freeswitch.org<BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"><http://lists.freeswitch.org/mailman/listinfo/freeswitch-users></a> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE: <a href="http://lists.freeswitch.org/mailman/options/freeswitch-users"><http://lists.freeswitch.org/mailman/options/freeswitch-users></a> <a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org"><http://www.freeswitch.org></a> <a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<BR>
<BR>
<BR>
<BR>
-- <BR>
Anthony Minessale II<BR>
<BR>
FreeSWITCH <a href="http://www.freeswitch.org/"><http://www.freeswitch.org/></a> <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><BR>
ClueCon <a href="http://www.cluecon.com/"><http://www.cluecon.com/></a> <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><BR>
<BR>
AIM: anthm<BR>
MSN: <a href="mailto:MSN%3Aanthony_minessale@hotmail.com"><mailto:MSN%3Aanthony_minessale@hotmail.com></a> anthony_minessale@hotmail.com<BR>
GTALK/JABBER/PAYPAL: <a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com"><mailto:PAYPAL%3Aanthony.minessale@gmail.com></a> anthony.minessale@gmail.com<BR>
IRC: irc.freenode.net <a href="http://irc.freenode.net"><http://irc.freenode.net></a> #freeswitch<BR>
<BR>
FreeSWITCH Developer Conference<BR>
sip: <a href="mailto:sip%3A888@conference.freeswitch.org"><mailto:sip%3A888@conference.freeswitch.org></a> 888@conference.freeswitch.org<BR>
iax: <a href="http://iax:guest@conference.freeswitch.org/888"><http://iax:guest@conference.freeswitch.org/888></a> guest@conference.freeswitch.org/888<BR>
googletalk: <a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org"><mailto:googletalk%3Aconf%2B888@conference.freeswitch.org></a> conf+888@conference.freeswitch.org<BR>
pstn:213-799-1400<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>_______________________________________________<BR>
Freeswitch-users mailing list<BR>
Freeswitch-users@lists.freeswitch.org<BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE: <a href="http://lists.freeswitch.org/mailman/options/freeswitch-users"><http://lists.freeswitch.org/mailman/options/freeswitch-users></a> <a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<BR>
_______________________________________________<BR>
Freeswitch-users mailing list<BR>
Freeswitch-users@lists.freeswitch.org<BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<BR>
<BR>
<BR>
<BR>
-- <BR>
--Joe<BR>
<BR>
"Success is easy if you think of it like Rust: It's inevitable if you keep at it. Guys claim there are magic moments, but that's just bullshit." --Fred Franzia (The famous wine guy)<BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT></FONT></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE><FONT SIZE="4"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_______________________________________________<BR>
Freeswitch-users mailing list<BR>
Freeswitch-users@lists.freeswitch.org<BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
</SPAN></FONT></FONT>
</BODY>
</HTML>