[sr-dev] [SR-Users] How to use unixodbc/freetds for kamailio backend

[Daniel-Constantin Mierla]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20140617/c676fc98/attachment.html>