[OpenSER-Users] AVPOPS Issue

[Ali Jawad]

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080609/970e4372/attachment.htm