[Freeswitch-users] Opensips using ODBC

Wed May 21 17:18:18 MSD 2014

Hi Andrew,

sorry for the delay in coming back to you.  You are correct in that the 
odbc module should be used :)
The only issue I have is that you seemingly cannot create the tables 
directly to mssql, but have to amend the mysql files .

thanks
Matt

On 09/05/2014 16:48, Andrew Cassidy wrote:
> 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 at inveroak.com 
> <mailto:matt at 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 = 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
>>     <tel:03300%20100%20960> *F <mailto:info at cassidywebservices.co.uk>
>>     *03300 100 961 <tel:03300%20100%20961>
>>     *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  <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
>
>
>     _________________________________________________________________________
>     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/20140521/91b3e8d2/attachment-0001.html 