[sr-dev] Kamailio and SQLSERVER

[Ari Pollack]

Hi Klaus,


in which module exactly is the routing done? does it natively get the routes from a MYSQL DB?
My aim is to keep kamailio using mysql except for the routing which i want it to call SQL SERVER. i have configured the unixodbc already(thanks for the tip). Where should I call my stored proc from in order to return a route?

Thanks a lot for the help. I really appreciate it.
Yehuda


________________________________
From: Klaus Darilion <klaus.mailinglists at pernau.at>
To: sr-dev at lists.sip-router.org
Sent: Tuesday, November 15, 2011 9:30 AM
Subject: Re: [sr-dev] Kamailio and SQLSERVER

Use db_unixodbc modul to connect to MS SQL server. Therefore you also 
have to configure unixodbc.

Then, set the db_url of the other modules to the unixodbc connection. 
Then all the configured modules will talk to the MSSQL server instead of 
mysql (which is the default).

regards
Klaus

On 14.11.2011 12:31, Ari Pollack wrote:
> Hi Klaus,
> I appreciate the help but what i meant is Microsoft SQL SERVER. how can
> i talk to it from a linux environment.
> also where do i define which modules i use and how to i change the
> sqlops module to perform the queries?
> Thanks in advance,
> Yehuda
> ------------------------------------------------------------------------
> *From:* Klaus Darilion <klaus.mailinglists at pernau.at>
> *To:* sr-dev at lists.sip-router.org
> *Sent:* Monday, November 14, 2011 1:08 PM
> *Subject:* Re: [sr-dev] Kamailio and SQLSERVER
>
> No need to change any code. Just use the sqlops module to perform raw
> SQL queries to the database.
>
> regards
> klaus
>
> On 14.11.2011 11:05, Ari Pollack wrote:
>  > Hi All,
>  >
>  > I am a newcomer to kamailio and would like some help. I would like to
>  > use kamailio as my sip proxy but I want to get the routing using my SQL
>  > Server stored procedures. Can anybody tell me which parts of the code I
>  > need to alter in order to do this.
>  >
>  > Any help would be greatly appreciated,
>  > Yehuda
>  >
>  >
>  > _______________________________________________
>  > sr-dev mailing list
>  > sr-dev at lists.sip-router.org <mailto:sr-dev at lists.sip-router.org>
>  > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org <mailto:sr-dev at lists.sip-router.org>
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>
>
>
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

_______________________________________________
sr-dev mailing list
sr-dev at lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20111115/179b098d/attachment.htm>