28 Apr
2016
28 Apr
'16
1:13 p.m.
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
28 Apr
28 Apr
2:33 p.m.
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(a)gmail.com>om>:
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
2:36 p.m.
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(a)avanzada7.com>om>:
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(a)gmail.com>om>:
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
5:19 p.m.
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(a)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(a)avanzada7.com>
:
--
Shahid Mehmood
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(a)gmail.com>om>:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
5:49 p.m.
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.ge4(a)gmail.com>om>:
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(a)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(a)avanzada7.com
--
Shahid Mehmood
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
:
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(a)gmail.com>om>:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
3130
days inactive
3130
days old
4 comments
2 participants
participants (2)
-
Alberto Sagredo -
Shahid Mehmood