[SR-Users] fetch data from Mysql Using Kamailio

[Alberto Sagredo]

Just a point . Its not needed to resend same email every day. Will try to
do the best with mailing list, but sometimes we are ill, occupied.. or just
do not know what to answer..

BR

2016-04-27 16:18 GMT+02:00 Shahid Mehmood <shahid.ge4 at gmail.com>:

> 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
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160428/4266e4fc/attachment.html>