[SR-Users] fetch data from Mysql Using Kamailio

[Shahid Mehmood]

Thanx ur kind reply

sql_query("cb", "select ip from ext where ext='$rU'", "ra");
$var(a)= sql_result_free("ra");

i have an other question . how i get data return from sql query. i get 1
from  sql_result_free("ra"); i need ip address like below

mysql> select ip from ext where ext=202
    -> ;
+----------------+
| ip             |
+----------------+
| 192.168.55.157 |
+----------------+
1 row in set (0.00 sec)



On Thu, Apr 28, 2016 at 4:36 PM, Alberto Sagredo <
alberto.sagredo at avanzada7.com> wrote:

> Ups Sorry
>
> #!ifdef WITH_MYSQL
> loadmodule "db_mysql.so"
> #!endif
>
> modparam("sqlops","sqlcon","cb=>mysql://root:pass@IP/kamailio")
>
> if($rU=~"^1[0-9][0-9]$")
> {
> sql_query("cb", "select asterisk from x where extension='$rU'","valora");
> sql_result_free("valora");
>
> }
>
> With no issues..
>
> Any error on mysql¿
>
> BR
>
>
>
> 2016-04-28 13:33 GMT+02:00 Alberto Sagredo <alberto.sagredo at avanzada7.com>
> :
>
>> Hi
>>
>> Im my case
>>
>>
>> modparam("sqlops","sqlcon","ca=>mysql://root:pass@IP/kamailio")
>>
>>
>>
>>
>>
>> 2016-04-28 12:13 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
>>>
>>>
>>
>
> _______________________________________________
> 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
>
>


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