<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hi Klaus,<br></span></div><div><br></div><div>in which module exactly is the routing done? does it natively get the routes from a MYSQL DB?</div><div>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?</div><div><br></div><div>Thanks a lot for the help. I really appreciate it.</div><div>Yehuda<br></div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Klaus Darilion <klaus.mailinglists@pernau.at><br><b><span style="font-weight:
bold;">To:</span></b> sr-dev@lists.sip-router.org<br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, November 15, 2011 9:30 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [sr-dev] Kamailio and SQLSERVER<br></font><br>
Use db_unixodbc modul to connect to MS SQL server. Therefore you also <br>have to configure unixodbc.<br><br>Then, set the db_url of the other modules to the unixodbc connection. <br>Then all the configured modules will talk to the MSSQL server instead of <br>mysql (which is the default).<br><br>regards<br>Klaus<br><br>On 14.11.2011 12:31, Ari Pollack wrote:<br>> Hi Klaus,<br>> I appreciate the help but what i meant is Microsoft SQL SERVER. how can<br>> i talk to it from a linux environment.<br>> also where do i define which modules i use and how to i change the<br>> sqlops module to perform the queries?<br>> Thanks in advance,<br>> Yehuda<br>> ------------------------------------------------------------------------<br>> *From:* Klaus Darilion <<a ymailto="mailto:klaus.mailinglists@pernau.at" href="mailto:klaus.mailinglists@pernau.at">klaus.mailinglists@pernau.at</a>><br>> *To:* <a
ymailto="mailto:sr-dev@lists.sip-router.org" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a><br>> *Sent:* Monday, November 14, 2011 1:08 PM<br>> *Subject:* Re: [sr-dev] Kamailio and SQLSERVER<br>><br>> No need to change any code. Just use the sqlops module to perform raw<br>> SQL queries to the database.<br>><br>> regards<br>> klaus<br>><br>> On 14.11.2011 11:05, Ari Pollack wrote:<br>> > Hi All,<br>> ><br>> > I am a newcomer to kamailio and would like some help. I would like to<br>> > use kamailio as my sip proxy but I want to get the routing using my SQL<br>> > Server stored procedures. Can anybody tell me which parts of the code I<br>> > need to alter in order to do this.<br>> ><br>> > Any help would be greatly appreciated,<br>> > Yehuda<br>> ><br>> ><br>>
> _______________________________________________<br>> > sr-dev mailing list<br>> > <a ymailto="mailto:sr-dev@lists.sip-router.org" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a> <mailto:<a ymailto="mailto:sr-dev@lists.sip-router.org" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a>><br>> > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev<br>><br>> _______________________________________________<br>> sr-dev mailing list<br>> <a ymailto="mailto:sr-dev@lists.sip-router.org" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a> <mailto:<a ymailto="mailto:sr-dev@lists.sip-router.org" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a>><br>> <a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev"
target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><br>><br>><br>><br>><br>> _______________________________________________<br>> sr-dev mailing list<br>> <a ymailto="mailto:sr-dev@lists.sip-router.org" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a><br>> <a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><br><br>_______________________________________________<br>sr-dev mailing list<br><a ymailto="mailto:sr-dev@lists.sip-router.org" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a><br><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><br><br><br></div></div></div></body></html>