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@pernau.at To: sr-dev@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

_______________________________________________ sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

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@pernau.at To: sr-dev@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@pernau.at *To:* sr-dev@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@lists.sip-router.org mailto:sr-dev@lists.sip-router.org   > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

---

sr-dev mailing list sr-dev@lists.sip-router.org mailto:sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

---

sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

_______________________________________________ sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev