[Users] AVPops trouble

[Martin Kjeldsen]

Ahh, that did it.
I am using the 0.9.5 version, so I mixed up by using the Dev procedure.
Just needed to write the From to a AVP, and then load it.

Great help.

Regards
Martin


Daniel-Constantin Mierla wrote:

> Hello,
>
> what version of openser do you use? If you use 0.9.x, the you must 
> first write the From uri in an AVP and then do the load based on it:
>
> modparam("avpops", "avp_aliases", "fromuri=i:10")
>
> avp_write("$from", "$fromuri");
> avp_db_load("$fromuri","s:pai/$scheme0");
> avp_pushto("$P-Asserted-Identity","s:pai");
>
> If you are using the development version, then you can try:
> avp_db_load("$from/uuid","s:pai/$scheme0");
> avp_pushto("$P-Asserted-Identity","s:pai");
>
> Anyhow, you should get some query in mysql log. If not, then something 
> else is wrong. Please check the syslog for error messages from openser.
>
> Daniel
>
>
> On 08/30/05 13:22, Martin Kjeldsen wrote:
>
>> Hi
>>
>> I've been fiddeling with the AVPops module for some time now and 
>> havn't really gotten it to work as intended. I was hoping that 
>> someone out there might be able to explain the basics of the module, 
>> cause apparently I'm misunderstanding it... I think :-)
>>
>> I having trouble with pulling data from my openser DB with a scheme, 
>> and then pushing (pushto) it into a request header.
>>
>> The thing is I cant quite figure out, if I need to store the data I 
>> get from my scheme or if I can use it directly in a pushto!
>>
>> I have tried using a scheme:
>>
>>    modparam("avpops", "db_scheme",         
>> "scheme0:uuid_col=contact;value_col=username;value_type=string;table=aliases") 
>>
>>
>>
>> and then loading and pushing it with:
>>
>>        avp_db_load("$from","s:pai/$scheme0");
>>        avp_pushto("$P-Asserted-Identity","s:pai");
>>
>> But this leaves me with no new field in the header, and nothing to 
>> show for in my MySQL log!
>>
>> I'm using these additional params for the AVPops:
>>
>> modparam("avpops","avp_url","mysql://openser:heslo@localhost/openser")
>> modparam("avpops","avp_table","avptable")
>> modparam("avpops","use_domain",1)
>>
>> The avptable is one I've created, since I wasn't sure if it needed to 
>> be there or not.
>>
>>
>> Any and all help will be greatly appreciated, cause I'm really 
>> getting stuck here.
>>
>>
>> Regards
>> Martin
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
>>
>