13 Sep
2005
13 Sep
'05
10:18 p.m.
OK,
If someone is interested... here my solution. Thanks for your help!!!
# ------------- avp parameters
modparam("avpops", "avp_url",
"postgres://admin:xxxxxxxx@localhost/AAA")
modparam("avpops", "avp_table", "subscriber")
modparam("avpops","db_scheme",
"scheme1:uuid_col=username;value_col=caller_id;value_type=string;table=subsc
riber")
[...]
avp_db_load("$from/username", "s:caller_id/$scheme1");
uac_replace_from("", "$avp(s:caller_id)");
I'm downloading ser-0.9.4 at this moment... hoping that the
uac_replace_module supports pseudo-variables. If not, you can imagine my
next question ;-)
Sebastian
----- Original Message -----
From: "Greger V. Teigre" <greger(a)teigre.com>
To: "Sebastian Kühner" <skuehner(a)veraza.com>om>;
<serusers(a)lists.iptel.org>
Sent: Tuesday, September 13, 2005 3:38 PM
Subject: Re: [Serusers] avpops
Sebestian,
The just recently released issue 5 of the Getting Started doc at onsip.org
uses avpops to implement call forwarding etc. You can probably get some
help
there :-)
g-)
Sebastian Kühner wrote:
Hi!
Thanks! The problem is that there are examples for every command. But
how do I connect them? I've problems to understand them...
Well, I guess (please help me with my "idea"):
To get a value from the database (Table: subscriber - column:
caller_id) for the calling user, I have to make:
modparam("avpops", "avp_table", "subscriber")
modparam("avpops", "uuid_column", "id")
modparam("avpops", "username_column", "username")
modparam("avpops", "domain_column", "domain")
modparam("avpops", "value_column", "caller_id")
avp_db_load("$uuid", "s:$uri");
Thanks for your help!
Sebastian
----- Original Message -----
From: "Andreas Granig" <andreas.granig(a)inode.info>
To: "Sebastian Kühner" <skuehner(a)veraza.com>
Cc: <serusers(a)lists.iptel.org>
Sent: Tuesday, September 13, 2005 10:33 AM
Subject: Re: [Serusers] avpops
Sebastian Kühner wrote:
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers Can anyone of you give me an example how to get
data from a
database with the avpops-module? I want to get a value from a
special table and a special column...
I didn't find any examples in the internet and the commands only
don't help me very much...
http://www.voice-system.ro/docs/avpops/0.9.0/ has some examples.
Andy