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 :
> Tha
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
-> ;
+--
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 :
> Dear All,
> i am getting error when i trying to fetch da
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¿
Hi
Im my case
modparam("sqlops","sqlcon","ca=>mysql://root:pass@IP/kamailio")
2016-04-28 12:13 GMT+02:00 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
>
> loa
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/ka
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/ka