[Freeswitch-users] Opensips using ODBC

[Andrew Cassidy]

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> 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> 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
>> 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
>>
>
>
>
>  --
> *Andrew Cassidy BSc (Hons) MBCS SSCA*
> Managing Director
>
>
> *T <info at cassidywebservices.co.uk> *03300 100 960  *F
> <info at cassidywebservices.co.uk> *03300 100 961
> *E <info at cassidywebservices.co.uk> *andrew at cassidywebservices.co.uk
> *W <info at cassidywebservices.co.uk> *www.cassidywebservices.co.uk
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>
>
>
> _________________________________________________________________________
> 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
>
>


-- 
*Andrew Cassidy BSc (Hons) MBCS SSCA*
Managing Director


*T <info at cassidywebservices.co.uk> *03300 100 960  *F
<info at cassidywebservices.co.uk> *03300 100 961
*E <info at cassidywebservices.co.uk> *andrew at cassidywebservices.co.uk
*W <info at cassidywebservices.co.uk> *www.cassidywebservices.co.uk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140509/63cf6e6a/attachment.html