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@inveroak.com <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto:info@cassidywebservices.co.uk> *03300 100 960 <tel:03300%20100%20960> *F <mailto:info@cassidywebservices.co.uk> *03300 100 961 <tel:03300%20100%20961> *E <mailto:info@cassidywebservices.co.uk> *andrew@cassidywebservices.co.uk <mailto:andrew@cassidywebservices.co.uk> *W <mailto:info@cassidywebservices.co.uk> *www.cassidywebservices.co.uk <http://www.cassidywebservices.co.uk>
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto:info@cassidywebservices.co.uk> *03300 100 960 *F <mailto:info@cassidywebservices.co.uk> *03300 100 961 *E <mailto:info@cassidywebservices.co.uk> *andrew@cassidywebservices.co.uk <mailto:andrew@cassidywebservices.co.uk> *W <mailto:info@cassidywebservices.co.uk> *www.cassidywebservices.co.uk <http://www.cassidywebservices.co.uk>
_________________________________________________________________________ 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