The documentation for the odbc module: http://www.opensips.org/html/docs/modules/devel/db_unixodbc.html
looks like you should set it to unixodbc
On 9 May 2014 15:14, Matt Broad <matt@inveroak.com>
wrote:
Hi Andrew,
thanks for your response :)
I have got the connection to the server working and tested (isql dnsname username password), and this works fine. The part that I am missing is how to then set Opensips to use this connection rather than a MySql connection.
In the opensipsctlrc file, the DBENGINE is set to MYSQL, but I'm guessing it should be changed to something like UNIXODBC or FREETDS (both tried and a few other alternatives), but these are not recognised. I have seen in some forums that people have it working off of MS SQL, but sadly no examples :(
thanks
Matt
On 09/05/2014 12:54, Andrew Cassidy wrote:
You first need to set up the TDS connection in /etc/freetds/freetds.conf
Then set up the DSN in /etc/odbc.ini (and possibly /etc/odbcinst.ini)
examples (Debian Whezy):
/etc/freetds/freetds.conf
[global]text size = 64512
[<arbitrary label>]host = <hostname or ip address>port = 1433tds version = 7.2
/etc/odbc.ini
[ODBC Data Sources]
[<dsn name>]Servername = <label from freetds.conf>Database = <database name>Driver = FreeTDS
/etc/odbcinst.ini
[FreeTDS]Description = TDS driver (Sybase/MS SQL)Driver = libtdsodbc.soSetup = libtdsS.soCPTimeout =CPReuse =
On 9 May 2014 09:58, Matt Broad <matt@inveroak.com> wrote:
Hi,
not strictly a Freeswitch question, so apologies, but just wanted to
know if anyone has any experience using opensips and connecting to a
microsoft sql database instead of MySql?
I can see that there is an odbc module, which I assume using freetds and
unixodbc, should be able to do the job. But I can't find any examples
of people who aren't using Mysql.
Any pointers would be very much appreciated :)
thanks
Matt
_________________________________________________________________________
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
--
Andrew Cassidy BSc (Hons) MBCS SSCAManaging Director
_________________________________________________________________________ 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
_________________________________________________________________________
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
Andrew Cassidy BSc (Hons) MBCS SSCA
Managing Director
_________________________________________________________________________ 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