17 Jun
2014
17 Jun
'14
11:08 a.m.
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