Hi guys, I have a similar problem, maybe
easier. I’m new in openser so I’d like to have some help.
I’d like openser create a table in
MySQL db when receive an INVITE, a row with from uri, method and something else,
I’ve look into modules docs but I’ve not understanding at all…could
you help me, please?
Thanks for reply
Davide
Da:
users-bounces@openser.org [mailto:users-bounces@openser.org] Per conto di Jayesh Nambiar
Inviato: mercoledė 5 aprile 2006
15.53
A: Bogdan-Andrei Iancu
Cc: openser
Oggetto: Re: [Users] using AVPs to
write into database
Hi Bogdan,
Thanks for the reply and sorry for sending the earlier mail 4 times as
yahoo was not responding peoperly.
When I do an avp_write(), why does the avp name get stored in the uuid
column?
I am not using any uuid as of now. I also tried to add the username of
the person who is calling but it again creates two rows, one with the value as
username and other row with the value as forwarded number.
I thought if there is a way to insert the username also, it wud be
easier to check, if the incoming call for that user is to be forwarded or not.
I get the following in my usr_preferences table after I dial 86
followed by any number.
+-----------+----------+--------+-----------+------+-----------------------------+---------------------+
| uuid | username | domain | attribute | type |
value
| modified |
+-----------+----------+--------+-----------+------+-----------------------------+---------------------+
| s:callfwd |
| | callfwd
| 0 | sip:5515551478@202.80.61.10 | 2006-04-05 19:10:49 |
+-----------+----------+--------+-----------+------+-----------------------------+---------------------+
The script snippet is as follows:
if(uri=~"^sip:86[0-9]*@") {
strip(2);
avp_write("$ruri", "s:callfwd");
#avp_write("$from/username", "i:999");
#avp_db_store("i:999", "i:/usr_preferences");
avp_db_store("s:callfwd", "s:callfwd/usr_preferences");
sl_send_reply("200", "OK");
exit;
};
Bogdan-Andrei Iancu
<bogdan@voice-system.ro> wrote: