The DSN is only for freeswitch internal data, and some of the apps. There is no native options in freeswitch to use a database for users, call routing etc...
Setting up a DSN will work just fine to move the internal SQLite data into MSSQL, but that really won't buy you much for the other applications.
If you want to replace config (Directlry, Dialplan, other config...) you have a few options.
Use mod_xml_curl, and do it real time w/ HTTP and an external app.
Use one of the scriptiong languages that allow you to configure a script to run to generate the XML on the fly.
Or on winodws a very easy method (if you can code in C# or VB) would be to write a plugin that can be loaded by MOD_MANAGED to convert stuff in your database to real-time configuraton. (in C# this could be done in as few as 10 lines of code) This would allow you to connect to any DB for anything.
Since two of the things that are very easy in C#, reading databases, and generating XML, and the ease of converting a database record to XML in a single line of code (LINQ syntax) this is a very easy option to get started.
--Dave
From: Andre Demattia [mailto:andretodd@verizon.net]
To: FreeSWITCH Users Help [mailto:freeswitch-users@lists.freeswitch.org]
Sent: Tue, 26 Mar 2013 11:13:24 -0700
Subject: Re: [Freeswitch-users] Freeswitch + MSSQL
I'm using windows. Will that still work?
I also want to use the manage lib in c# but I can't find anything worth wile for examples.
I see a post that has <param name= "core-dbtype" value ="mdsql">
Not sure the steps for setting it up and where the SQL goes.
The configurations in the books should show ODBC configurations, the UnixODBC configuration is just that the ODBC configuration for *nix platforms, once you have your DSN setup for MSSQL you just tell FS ODBC://DSN:user:pass where it asks for DSNs in the config. For users/routing you’ll have you either write something to handle that or use one of the existing XML via http formats... See the wiki for how mod_xml_curl works
On 3/26/13 12:54 PM, "Andre Demattia" <andretodd@verizon.net> wrote:
User databases, call routing etc. I am not sure what the steps are. The book I have only shows Linux configuration not odbc to mssql.
From: Dave R. Kompel <mailto:drk@drkngs.net>
Sent: 3/26/2013 1:39 PM
To: FreeSWITCH Users Help <mailto:freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Freeswitch + MSSQL
Connect it how? Use it for the internal database, or do other things with it, such as User databases, call routing etc...?
--Dave
From: Andre Demattia [mailto:andretodd@verizon.net]
To: freeswitch-users@lists.freeswitch.org [mailto:freeswitch-users@lists.freeswitch.org]
Sent: Tue, 26 Mar 2013 08:49:25 -0700
Subject: Re: [Freeswitch-users] Freeswitch + MSSQL
HI, I'm new to Freeswitch and need to know how to connect my Windows Freeswitch to MSSQL.
Can you share your example and step by step instructions ?
I assume I need a Mod?
Thanks
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
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
--
Ken
http://www.FreeSWITCH.org
http://www.ClueCon.com
http://www.OSTAG.org
irc.freenode.net #freeswitch