[SR-Users] fetch data from Mysql Using Kamailio

[Shahid Mehmood]

Dear All,
            i am getting error when i trying to fetch data from mysql data
base using kamailio.

i have following code into kamailio.cfg file

loadmodule "db_mysql.so"
loadmodule "sqlops.so"

................................
modparam("sqlops","sqlcon","ca=>mysql://root:123456@localhost/kamailio")
...............................
...............................

 sql_query("ca", "select * from ext", "ra");
                 sql_result_free("ra");








*Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: INFO: rr [rr_mod.c:160]:
mod_init(): outbound module not availableApr 24 06:30:31 kamalio
/usr/sbin/kamailio[1385]: INFO: usrloc [hslot.c:53]: ul_init_locks(): locks
array size 1024Apr 24 06:30:31 kamalio /usr/sbin/kamailio[1385]: ERROR:
sqlops [sqlops.c:276]: fixup_sql_query(): invalid connection [ca]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:514Apr 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*

-- 
Shahid Mehmood
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160428/9a957ad4/attachment.html>