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