<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 class="" style="margin:2px 0px 0px;font-size:12.8px"><div id=":32u" class="" tabindex="0"><img class="" src="https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif"></div></div><div><br></div>-- <br><div class="gmail_signature">Shahid Mehmood</div>
</div>