Hello,
On 12/06/14 13:11, Tim Chubb wrote:
Hi
Im just getting started with kamailio with a view of evaluating it for production use.
Is it possible to do the following:
1)I would like to use ODBC/FreeTDS to connect to an existing ms sql server cluster and use it for all DB related activity relating to kamailio, is this possible as we would be running kamailio in a HA configuration in production and I really don’t want to have to support another DB cluster?
using odbc should work fine, there are many people using it for various db systems (e.g., i know few using it for oracle).
2)Looking at the kamdbctl scripts it seems that currently every popular db but sql server is supported which is a bit of a shame, however am I right in saying that if I was to port the sql files to SQL server, and implemented a script similar to kamdbctl.pgsql to wrap around the freetds TSQL executable that would be all that I would need to do add support for SQL server?
Yes, you can port the scripts to your database system then you can even run them manually. Practically you need to create the database with needed tables and one user to access it.
3)Is there any particular reason why there isn’t an ODBC option for the kamdbctl script?
I am not a odbc user, so I am not familiar with the tools coming around it for interrogating database from command line. If anyone adds support for it to kamctl and kamdbctl, the we will include it in the official repository.
Cheers, Daniel
Hi Daniel
Thanks for the response,
I actually took it upon myself to dig in and have a go over the weekend, I have ported the db schema to work with TSQL syntax, and have managed to update the kamdbctl and kamctl scripts to work as intended (for creation duties only actions requiring table dumps are not really feasible with sql server as there isn’t an equivalent to pg_dump/mysqldump I could find may have to write it one day, although in my case we backup at server/cluster level not application so would be of limited use for me). I have tested the schema against SQL Server 2008/2012 & SQL Azure, unsure about SQL Server 2005 compatibility…
I would be happy to contribute the ported schema to the project, and will attempt to tidy up my extensions to kamdbctl to be less ‘hacky’ ;-), how does one go about contributing to the project?
Regards, Tim.
From: sr-dev-bounces@lists.sip-router.org [mailto:sr-dev-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla Sent: 17 June 2014 10:08 To: Kamailio (SER) - Users Mailing List; sr-dev@lists.sip-router.org Subject: Re: [sr-dev] [SR-Users] How to use unixodbc/freetds for kamailio backend
Hello, On 12/06/14 13:11, Tim Chubb wrote: Hi
Im just getting started with kamailio with a view of evaluating it for production use.
Is it possible to do the following:
1) I would like to use ODBC/FreeTDS to connect to an existing ms sql server cluster and use it for all DB related activity relating to kamailio, is this possible as we would be running kamailio in a HA configuration in production and I really don’t want to have to support another DB cluster? using odbc should work fine, there are many people using it for various db systems (e.g., i know few using it for oracle).
2) Looking at the kamdbctl scripts it seems that currently every popular db but sql server is supported which is a bit of a shame, however am I right in saying that if I was to port the sql files to SQL server, and implemented a script similar to kamdbctl.pgsql to wrap around the freetds TSQL executable that would be all that I would need to do add support for SQL server? Yes, you can port the scripts to your database system then you can even run them manually. Practically you need to create the database with needed tables and one user to access it.
3) Is there any particular reason why there isn’t an ODBC option for the kamdbctl script?
I am not a odbc user, so I am not familiar with the tools coming around it for interrogating database from command line. If anyone adds support for it to kamctl and kamdbctl, the we will include it in the official repository.
Cheers, Daniel
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
-
Daniel-Constantin Mierla -
Tim Chubb