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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users