Hi
Im my case
modparam("sqlops","sqlcon","ca=>mysql://root:pass@IP/kamailio")
2016-04-28 12:13 GMT+02:00 Shahid Mehmood <shahid....@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@lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
