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(a)pernau.at> To: sr-dev(a)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: _______________________________________________ sr-dev mailing list sr-dev(a)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(a)pernau.at> To: sr-dev(a)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: _______________________________________________ sr-dev mailing list sr-dev(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev