[Freeswitch-users] Freeswitch + MSSQL

Tue Mar 26 21:37:52 MSK 2013

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 at verizon.net]
To: FreeSWITCH Users Help [mailto:freeswitch-users at 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.  
    _____  

  From: Ken Rice
Sent: ‎3/‎26/‎2013 2:00 PM
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] Freeswitch + MSSQL

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 at 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 at drkngs.net> 
Sent: 3/26/2013 1:39 PM
To: FreeSWITCH Users Help <mailto:freeswitch-users at 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 at verizon.net]
To: freeswitch-users at lists.freeswitch.org [mailto:freeswitch-users at 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 at freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130326/1ffa2a07/attachment-0001.html 