1 Jun
2006
1 Jun
'06
4:15 a.m.
Hi Franz,
the problem is you do not have a complete avp specification. You have
just "i:" instead of "i:id". When you use a schema, there is no column
with the avp name/id (as it is in the user_preferences table), so you
have to define from scrip the avp name/id to load the info into.
Doing:
avp_db_load("$auth-user","i:13/$P-assoc");
will fix the problem. The info will be available in i:13 AVP.
regards,
bogdan
Franz Edler wrote:
Hi,
again I need some help from AVPops-experts.
I have created a table for P-Associated-URI - parameter (addressed via
uuid).
CREATE TABLE associated_uris (
auth_user varchar(64) NOT NULL default '',
id varchar(32) NOT NULL default '',
uri varchar(128) NOT NULL default '',
type integer NOT NULL default '0',
modified timestamp(14) NOT NULL,
PRIMARY KEY (auth_user, id)
) TYPE=MyISAM;
I also have created the following db-scheme:
modparam("avpops","db_scheme","P-assoc:uuid_col=auth_user;value_col=id;value
_type=string;table=associated_uris")
When I access the table with
avp_db_load("$auth-user","i:/$P-assoc");
I get the error:
0(0) ERROR:avpops:parse_avp_db: inconsistent usage of DB scheme
without complet specification of AVP name
0(0) ERROR:avpops:fixup_db_avp: parse failed
Any help appreciated.
Franz
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users