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