Elena,
My parameters to avp_db_load, as requested, are:
modparam("avpops","avp_url","mysql://openser:[EMAIL PROTECTED]/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:[EMAIL PROTECTED] Sent: Sun 11/27/2005 4:26 PM
To: Douglas Garstang Cc: [email protected] 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
>[email protected]
>http://openser.org/cgi-bin/mailman/listinfo/users
> >
------------------------------------------------------------------------
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
