[Users] Avpops Module

[Douglas Garstang]

Elena,
 
My parameters to avp_db_load, as requested, are:
 
modparam("avpops","avp_url","mysql://openser:openserrw@localhost/openser")
...
modparam("avpops","db_scheme",
        "scheme1:uuid_col=uuid;value_col=phone;value_type=string;table=subscriber")
 
The columns uuid, and phone are valid columns from the subscriber table.
 
This causes the following to be logged to syslog on openser startup:
Nov 27 23:53:08 ser1 openser[2085]: Maxfwd module- initializing 
Nov 27 23:53:08 ser1 openser[2085]: AVPops - initializing 
Nov 27 23:53:08 ser1 openser[2085]: ERROR:avpops_init: "AVP_DB" present but "AVP_TABLE" found empty 
Nov 27 23:53:08 ser1 openser[2085]: init_mod(): Error while initializing module avpops 

I did base it on the example from the avpops tutorial. I don't understand why this error is generated. I thought the whole point of using db_scheme was that you didn't have to call modparam on the table name (as well as the uuid, attribute columns etc).
 
I could really do with a little help!
 
Thanks.
Douglas.
 

	-----Original Message----- 
	From: Elena Ramona Modroiu [mailto:ramona at voice-system.ro] 
	Sent: Sun 11/27/2005 4:26 PM 
	To: Douglas Garstang 
	Cc: users at openser.org 
	Subject: Re: [Users] Avpops Module
	
	

	Hi,
	
	Douglas Garstang wrote:
	
	>I swear, getting OpenSER to do anything is worse than pulling teeth.
	> 
	>
	:)
	
	>
	>The avpops module documentation at:
	>http://www.openser.org/docs/modules/1.0.x/avpops.html#AEN165
	>
	>has the following example under the db_scheme command:
	>...
	>modparam("avpops","db_scheme",
	>"scheme1:table=subscriber;uuid_column=uuid;value_column=first_name")
	>...
	>
	>which causes the following error to be reported in syslog.conf:
	>Nov 27 14:24:52 ser1 openser: ERROR:avpops:parse_avp_sb_scheme: unknown attribute <uuid_column>
	>Nov 27 14:24:52 ser1 openser: ERROR:avpops:avp_add_db_scheme: falied to parse scheme
	>Nov 27 14:24:52 ser1 openser: parse error (102,3-4): Can't set module parameter
	>
	>Why?
	> 
	>
	Thanks for reporting this, docs will be updated.
	
	>
	>The example at the 'alleged' tutorial at:
	>http://www.voice-system.ro/docs/avpops/
	>
	>which is just the docs at openser.org cut and pasted mostly has this example:
	>...
	>modparam("avpops","db_scheme",
	>"scheme1:uuid_col=uid;value_col=job;value_type=string;table=emp")
	>...
	>
	>which does not generate any errors in syslog.
	>HOWEVER, when avp_db_load() is called, the following is logged to syslog.conf:
	>
	>Nov 27 14:21:42 ser1 openser[2424]: ERROR:avpops_init: "AVP_DB" present but "AVP_TABLE" found empty
	>Nov 27 14:21:42 ser1 openser[2424]: init_mod(): Error while initializing module avpops
	>
	>Why??? The docs say I can use dbscheme to use a non standard AVP table, which is what I am trying to do, namely the subscriber table. If I can use dbscheme to define the columns from another table, why is OpenSER complaining that I haven't called modparam("avpops","avp_table","avptable")?????
	> 
	>
	What are the parameters of avp_db_load() in your case? Maybe this
	example (also from avpops tutorial) helps you:
	
	modparam("avpops","db_scheme",
	        "scheme1:uuid_col=uid;value_col=job;value_type=string;table=emp")
	       
	avp_db_load("$uuid","s:jobs/*$scheme1*");
	- load from table 'emp', using 'uid' column as uuid and 
	  'job' column as string value into AVP name 'jobs'
	
	
	Bye,
	Ramona
	
	>Doug.
	>
	>
	>
	>
	>
	>
	>
	> 
	>
	>------------------------------------------------------------------------
	>
	>_______________________________________________
	>Users mailing list
	>Users at openser.org
	>http://openser.org/cgi-bin/mailman/listinfo/users
	> 
	>