Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread Alberto Sagredo
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

Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread 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 -> ; +--

Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread 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 : > Dear All, > i am getting error when i trying to fetch da

Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread Alberto Sagredo
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¿

Re: [SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread Alberto Sagredo
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

[SR-Users] fetch data from Mysql Using Kamailio

2016-04-28 Thread 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 loadmodule "db_mysql.so" loadmodule "sqlops.so" modparam("sqlops","sqlcon","ca=>mysql://root:123456@localhost/ka

[SR-Users] fetch data from Mysql Using Kamailio

2016-04-27 Thread 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 loadmodule "db_mysql.so" loadmodule "sqlops.so" modparam("sqlops","sqlcon","ca=>mysql://root:123456@localhost/ka