28 Nov
2005
28 Nov
'05
11:12 a.m.
Hi Douglas,
I haven't got it right first time. Yes, setting avp_table parameter is
mandatory, it is the default table to be used when scheme is not used
or when the name of the table is not given explicitely to the
avp_db_load(). See also:
http://voice-system.ro/docs/avpops/ar01s05.html#avp_table.
Bye,
Ramona
Douglas Garstang wrote:
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@voice-system.ro]
Sent: Sun 11/27/2005 4:26 PM
To: Douglas Garstang
Cc: users(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users