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.