[OpenSER-Users] AVPOPS Issue

[Iñaki Baz Castillo]

El Monday 09 June 2008 11:06:09 Ali Jawad escribió:
> 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")

You use "username" column (that just stores the USERNAME without @domain)...



> And In the route statement I put
>
>
>
> if (avp_db_load("$ru","$avp(s:disabled)/$scheme1"))

...but here you look for the entire Request-URI ($ru). Maybe you mean $rU ?



BTW, I think is much better using "group" module for the purpose you want.


-- 
Iñaki Baz Castillo
ibc at in.ilimit.es