Hi all,
I'm trying to make an sql query through my kamailio script in order to check
for number portability. i have a table with 2 col (phonenumber,prefix). I'm
trying both modules avpops and sqlops but I'm not able to retreive any data.
modparam("avpops",
"db_url","mysql://openser:openserrw@localhost/openser")
avp_db_query("SELECT prefix FROM ported WHERE
phonenumber='$rU'","$avp(s:lnp_prefix)") ;The query run perfectly
in
command line.
The return code is always 1 but when I print $avp(s:lnp_prefix) I get no
result.
I have 2 questions :
1. Which is the best way to check portability in my case
2. What I'm doing wrong and I'm not getting any result from the query.
Thank you ALL
Alex