Hi.
Try something like this
$var(valor)=0;
$var(valor) = $dbr(ra=>[0,0]);
Use $var(valor) for that purpose.
I will check address table if you plan to use some ip authentication or
similar.
Its more powerful if you are looking for that
BR
2016-04-28 16:19 GMT+02:00 Shahid Mehmood <shahid....@gmail.com>:
> 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.sagr...@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.sagr...@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....@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
>>
>>
>
>
> --
> 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
