Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[Freeswitch-users] ODBC in place of db/core.db


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
ajlong at worldlink.net
Guest





PostPosted: Mon Jan 19, 2009 12:57 pm    Post subject: [Freeswitch-users] ODBC in place of db/core.db Reply with quote

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!
Back to top
anthony.minessale at g...
Guest





PostPosted: Mon Jan 19, 2009 1:06 pm    Post subject: [Freeswitch-users] ODBC in place of db/core.db Reply with quote

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:
Quote:

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
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 ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400
Back to top
ajlong at worldlink.net
Guest





PostPosted: Mon Jan 19, 2009 1:33 pm    Post subject: [Freeswitch-users] ODBC in place of db/core.db Reply with quote

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 (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
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 ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400
Back to top
mike at jerris.com
Guest





PostPosted: Mon Jan 19, 2009 1:43 pm    Post subject: [Freeswitch-users] ODBC in place of db/core.db Reply with quote

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 (anthony.minessale@gmail.com)> wrote:



Quote:
it's not possible, the core is only sqlite.


On Mon, Jan 19, 2009 at 11:51 AM, Adam Long <[url=mailto:ajlong@worldlink.net]ajlong@worldlink.net (ajlong@worldlink.net)[/url]> wrote:
Quote:

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
[url=mailto:Freeswitch-users@lists.freeswitch.org]Freeswitch-users@lists.freeswitch.org (Freeswitch-users@lists.freeswitch.org)[/url]
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:[url=mailto:anthony_minessale@hotmail.com]anthony_minessale@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])[/url]
GTALK/JABBER/PAYPAL:[url=mailto:anthony.minessale@gmail.com]anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])[/url]
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:[url=mailto:888@conference.freeswitch.org]888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])[/url]
guest@conference.freeswitch.org (guest@conference.freeswitch.org)/888
googletalk:[url=mailto:conf+888@conference.freeswitch.org]conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])[/url]
pstn:213-799-1400

_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (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

Back to top
krice at suspicious.org
Guest





PostPosted: Tue Jan 20, 2009 12:46 am    Post subject: [Freeswitch-users] ODBC in place of db/core.db Reply with quote

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>
Quote:
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:

Quote:
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) ajlong@worldlink.net> wrote:
Quote:
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) 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> ([email]MSN%3Aanthony_minessale@hotmail.com[/email]) anthony_minessale@hotmail.com
GTALK/JABBER/PAYPAL: <mailto:PAYPAL%3Aanthony.minessale@gmail.com> ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email]) anthony.minessale@gmail.com
IRC: irc.freenode.net <http://irc.freenode.net> #freeswitch

FreeSWITCH Developer Conference
sip: <mailto:sip%3A888@conference.freeswitch.org> ([email]sip%3A888@conference.freeswitch.org[/email]) 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> ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email]) conf+888@conference.freeswitch.org
pstn:213-799-1400
Quote:
_______________________________________________
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
Back to top
josephbajin at gmail.com
Guest





PostPosted: Tue Jan 20, 2009 12:49 am    Post subject: [Freeswitch-users] ODBC in place of db/core.db Reply with quote

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 (mike@jerris.com)>
Quote:
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 (anthony.minessale@gmail.com)> wrote:






Quote:
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 (ajlong@worldlink.net)> wrote:
Quote:

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 (Freeswitch-users@lists.freeswitch.org)
[/url][url=http://lists.freeswitch.org/mailman/listinfo/freeswitch-users]http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:[/url][url=http://lists.freeswitch.org/mailman/options/freeswitch-users]http://lists.freeswitch.org/mailman/options/freeswitch-users
[/url][url=http://www.freeswitch.org]http://www.freeswitch.org




--
Anthony Minessale II

FreeSWITCH [/url][url=http://www.freeswitch.org/]http://www.freeswitch.org/
ClueCon [/url][url=http://www.cluecon.com/]http://www.cluecon.com/

AIM: anthm
MSN: ([email]MSN%3Aanthony_minessale@hotmail.com[/email])anthony_minessale@hotmail.com (anthony_minessale@hotmail.com)
GTALK/JABBER/PAYPAL: ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])anthony.minessale@gmail.com (anthony.minessale@gmail.com)
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip: ([email]sip%3A888@conference.freeswitch.org[/email])888@conference.freeswitch.org (888@conference.freeswitch.org)
guest@conference.freeswitch.org (guest@conference.freeswitch.org)/888
googletalk: ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])conf+888@conference.freeswitch.org ([email]conf+888@conference.freeswitch.org[/email])
pstn:213-799-1400

_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@lists.freeswitch.org)
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:[/url][url=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 (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)
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services