Hi All
I have added a column called status to the subscriber table. I want to
check that column in the route() function and act according to it's
value.
In the global settings I put
# ----- AVP params --------
modparam("avpops", "avp_url",
"mysql://openser:ccccc@cccccc/openser")
modparam("avpops","avp_table","subscriber")
modparam("avpops","db_scheme",
"scheme1:username_col=username;value_col=status;value_type=string;table=
subscriber")
And In the route statement I put
if (avp_db_load("$ru","$avp(s:disabled)/$scheme1"))
{
xlog("L_INFO", "This did match");
}
I am getting this error in the log file
Jun 9 09:12:51 [15789] ERROR:avpops:ops_dbload_avps: incomplet uri
<sip:xx.xx.xx.xx> "Where xx.xx.xx.xx is my correct IP"
And the IF statement is matching everytime.
Thanks for any suggestions.