ODBC in place of db/core.db
Hi Guys, I have read the documentation on the wiki and have successfully compiled FreeSwtich with odbc core support. I am able to get my SIP Profiles and Voicemail databases to load, create, and utilize the ODBC database tables successfully. However, I cannot seem to figure out how to make FreeSwitch use the ODBC database instead of the SQL Lite db/core.db I'm sure it's just a matter of properly placing the following line in one of the configs. <param name="odbc-dsn" value="dns-name:user:password"/> If anyone can point me in the right direction I would greatly appreciate it. Thank you!
it's not possible, the core is only sqlite. On Mon, Jan 19, 2009 at 11:51 AM, Adam Long <ajlong@worldlink.net> wrote:
Hi Guys,
I have read the documentation on the wiki and have successfully compiled FreeSwtich with odbc core support.
I am able to get my SIP Profiles and Voicemail databases to load, create, and utilize the ODBC database tables successfully.
However, I cannot seem to figure out how to make FreeSwitch use the ODBC database instead of the SQL Lite db/core.db
I'm sure it's just a matter of properly placing the following line in one of the configs…
<param name="odbc-dsn" value="dns-name:user:password"/>
If anyone can point me in the right direction I would greatly appreciate it.
Thank you!
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
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. Mike On Jan 19, 2009, at 1:04 PM, "Anthony Minessale" <anthony.minessale@gmail.com
wrote:
it's not possible, the core is only sqlite.
On Mon, Jan 19, 2009 at 11:51 AM, Adam Long <ajlong@worldlink.net> wrote: Hi Guys,
I have read the documentation on the wiki and have successfully compiled FreeSwtich with odbc core support.
I am able to get my SIP Profiles and Voicemail databases to load, create, and utilize the ODBC database tables successfully.
However, I cannot seem to figure out how to make FreeSwitch use the ODBC database instead of the SQL Lite db/core.db
I'm sure it's just a matter of properly placing the following line in one of the configs…
<param name="odbc-dsn" value="dns-name:user:password"/>
If anyone can point me in the right direction I would greatly appreciate it.
Thank you!
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org pstn:213-799-1400 _______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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... 2009/1/19 Michael Jerris <mike@jerris.com>
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.
Mike
On Jan 19, 2009, at 1:04 PM, "Anthony Minessale" < anthony.minessale@gmail.com> wrote:
it's not possible, the core is only sqlite.
On Mon, Jan 19, 2009 at 11:51 AM, Adam Long < <ajlong@worldlink.net> ajlong@worldlink.net> wrote:
Hi Guys,
I have read the documentation on the wiki and have successfully compiled FreeSwtich with odbc core support.
I am able to get my SIP Profiles and Voicemail databases to load, create, and utilize the ODBC database tables successfully.
However, I cannot seem to figure out how to make FreeSwitch use the ODBC database instead of the SQL Lite db/core.db
I'm sure it's just a matter of properly placing the following line in one of the configs…
<param name="odbc-dsn" value="dns-name:user:password"/>
If anyone can point me in the right direction I would greatly appreciate it.
Thank you!
_______________________________________________ Freeswitch-users mailing list <Freeswitch-users@lists.freeswitch.org> Freeswitch-users@lists.freeswitch.org <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users> http://lists.freeswitch.org/mailman/options/freeswitch-users <http://www.freeswitch.org>http://www.freeswitch.org
-- Anthony Minessale II
FreeSWITCH <http://www.freeswitch.org/>http://www.freeswitch.org/ ClueCon <http://www.cluecon.com/>http://www.cluecon.com/
AIM: anthm MSN: <MSN%3Aanthony_minessale@hotmail.com>anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL: <PAYPAL%3Aanthony.minessale@gmail.com> anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip: <sip%3A888@conference.freeswitch.org>888@conference.freeswitch.org iax: <http://iax:guest@conference.freeswitch.org/888> guest@conference.freeswitch.org/888 googletalk: <googletalk%3Aconf%2B888@conference.freeswitch.org> conf+888@conference.freeswitch.org pstn:213-799-1400
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:<http://lists.freeswitch.org/mailman/options/freeswitch-users> http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- --Joe "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)
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 From: Joseph Bajin <josephbajin@gmail.com> Reply-To: <freeswitch-users@lists.freeswitch.org> Date: Tue, 20 Jan 2009 00:33:45 -0500 To: <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] ODBC in place of db/core.db 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... 2009/1/19 Michael Jerris <mike@jerris.com>
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.
Mike
On Jan 19, 2009, at 1:04 PM, "Anthony Minessale" <anthony.minessale@gmail.com> wrote:
it's not possible, the core is only sqlite.
On Mon, Jan 19, 2009 at 11:51 AM, Adam Long < <mailto:ajlong@worldlink.net> ajlong@worldlink.net> wrote:
Hi Guys,
I have read the documentation on the wiki and have successfully compiled FreeSwtich with odbc core support.
I am able to get my SIP Profiles and Voicemail databases to load, create, and utilize the ODBC database tables successfully.
However, I cannot seem to figure out how to make FreeSwitch use the ODBC database instead of the SQL Lite db/core.db
I'm sure it's just a matter of properly placing the following line in one of the configs
<param name="odbc-dsn" value="dns-name:user:password"/>
If anyone can point me in the right direction I would greatly appreciate it.
Thank you!
_______________________________________________ Freeswitch-users mailing list <mailto:Freeswitch-users@lists.freeswitch.org> Freeswitch-users@lists.freeswitch.org <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://lists.freeswitch.org/mailman/options/freeswitch-users <http://www.freeswitch.org> http://www.freeswitch.org
-- Anthony Minessale II
FreeSWITCH <http://www.freeswitch.org/> http://www.freeswitch.org/ ClueCon <http://www.cluecon.com/> http://www.cluecon.com/
AIM: anthm MSN: <mailto:MSN%3Aanthony_minessale@hotmail.com> anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL: <mailto:PAYPAL%3Aanthony.minessale@gmail.com> anthony.minessale@gmail.com IRC: irc.freenode.net <http://irc.freenode.net> #freeswitch
FreeSWITCH Developer Conference sip: <mailto:sip%3A888@conference.freeswitch.org> 888@conference.freeswitch.org iax: <http://iax:guest@conference.freeswitch.org/888> guest@conference.freeswitch.org/888 googletalk: <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> conf+888@conference.freeswitch.org pstn:213-799-1400
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- --Joe
"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)
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
OK, thanks for the heads up.. Reason I had asked in the first place, I was planning on tinkering with an auto-failover setup that would be capable of maintaining state and not dropping calls during failover. Has anyone had any success with this that you know of, or is it just not possible yet? From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Anthony Minessale Sent: Monday, January 19, 2009 1:04 PM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] ODBC in place of db/core.db it's not possible, the core is only sqlite. On Mon, Jan 19, 2009 at 11:51 AM, Adam Long <ajlong@worldlink.net> wrote: Hi Guys, I have read the documentation on the wiki and have successfully compiled FreeSwtich with odbc core support. I am able to get my SIP Profiles and Voicemail databases to load, create, and utilize the ODBC database tables successfully. However, I cannot seem to figure out how to make FreeSwitch use the ODBC database instead of the SQL Lite db/core.db I'm sure it's just a matter of properly placing the following line in one of the configs. <param name="odbc-dsn" value="dns-name:user:password"/> If anyone can point me in the right direction I would greatly appreciate it. Thank you! _______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org -- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <mailto:MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com <mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <mailto:sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
participants (5)
-
Adam Long
-
Anthony Minessale
-
Joseph Bajin
-
Ken Rice
-
Michael Jerris