[Freeswitch-users] Opensips using ODBC

[Matt Broad]

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 = 1433
> tds 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.so
> Setup           = libtdsS.so
> CPTimeout       =
> CPReuse         =
>
>
>
>
>
> On 9 May 2014 09:58, Matt Broad <matt at inveroak.com 
> <mailto:matt at 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 at freeswitch.org <mailto: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
>     <mailto: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
>
>
>
>
> -- 
> *Andrew Cassidy BSc (Hons) MBCS SSCA*
> Managing Director
>
>
> *T <mailto:info at cassidywebservices.co.uk> *03300 100 960 *F 
> <mailto:info at cassidywebservices.co.uk> *03300 100 961
> *E <mailto:info at cassidywebservices.co.uk> 
> *andrew at cassidywebservices.co.uk <mailto:andrew at cassidywebservices.co.uk>
> *W <mailto:info at cassidywebservices.co.uk> 
> *www.cassidywebservices.co.uk <http://www.cassidywebservices.co.uk>
>
>
> _________________________________________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140509/130a7321/attachment-0001.html