<div dir="ltr">Hi<div><br></div><div>Im my case</div><div><br></div><div><br></div><div>modparam("sqlops","sqlcon","ca=>mysql://root:pass@IP/kamailio")<br></div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-04-28 12:13 GMT+02:00 Shahid Mehmood <span dir="ltr"><<a href="mailto:shahid.ge4@gmail.com" target="_blank">shahid.ge4@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span style="font-size:12.8px">Dear All,</span><br style="font-size:12.8px"><span style="font-size:12.8px">            i am getting error when i trying to fetch data from mysql data base using kamailio.</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px">i have following code into kamailio.cfg file</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px">loadmodule "db_mysql.so"</span><br style="font-size:12.8px"><span style="font-size:12.8px">loadmodule "sqlops.so"</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px">..............................</span><span style="font-size:12.8px">..</span><br style="font-size:12.8px"><span style="font-size:12.8px">modparam("sqlops","sqlcon","</span><span style="font-size:12.8px">ca=>mysql://root:123456@</span><span style="font-size:12.8px">localhost/kamailio")</span><br style="font-size:12.8px"><span style="font-size:12.8px">..............................</span><span style="font-size:12.8px">.</span><br style="font-size:12.8px"><span style="font-size:12.8px">..............................</span><span style="font-size:12.8px">.</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px"> sql_query("ca", "select * from ext", "ra");</span><br style="font-size:12.8px"><span style="font-size:12.8px">                 sql_result_free("ra");</span><br style="font-size:12.8px"><br style="font-size:12.8px"><br style="font-size:12.8px"><br style="font-size:12.8px"><br style="font-size:12.8px"><b style="font-size:12.8px">Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: INFO: rr [rr_mod.c:160]: mod_init(): outbound module not available<br>Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: INFO: usrloc [hslot.c:53]: ul_init_locks(): locks array size 1024<br><span style="color:rgb(255,0,0)">Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: ERROR: sqlops [sqlops.c:276]: fixup_sql_query(): invalid connection [ca]<br>Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: ERROR: <core> [route.c:1189]: fix_actions(): fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:514</span><br>Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: ERROR: <core> [route.c:1189]: fix_actions(): fixing failed (code=-1) at cfg://etc/kamailio/kamailio.cfg:534</b><div style="margin:2px 0px 0px;font-size:12.8px"><div><img src="https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif"></div></div><span class="HOEnZb"><font color="#888888"><div><br></div>-- <br><div>Shahid Mehmood</div>
</font></span></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>