R: R: [Users] using AVPs to write into database

[D'Addelfio Davide]

Thanks, I've looked into but it works only with 1.1.x version...!!!

What's the different with avp_db_store command, may I use it to store something in my SQL DB? I'll try to do but I have some problems, he doesn't register...

I have another question: I need to work over sdp messages, is possible to do a parsing, always using the scripts language...?

Any thought?
Thanks
Davide 

-----Messaggio originale-----
Da: Daniel-Constantin Mierla [mailto:daniel at voice-system.ro] 
Inviato: mercoledì 5 aprile 2006 19.15
A: D'Addelfio Davide
Cc: Jayesh Nambiar; Bogdan-Andrei Iancu; openser
Oggetto: Re: R: [Users] using AVPs to write into database

Hello,

On 04/05/06 18:01, D'Addelfio Davide wrote:
>
> 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?
>
if you are using openser development version, then take a look at 
avp_db_query() in avpops module
http://openser.org/docs/modules/1.1.x/avpops.html#AEN239

Cheers,
Daniel

> Thanks for reply
>
> Davide
>
> ------------------------------------------------------------------------
>
> *Da:* users-bounces at openser.org [mailto:users-bounces at 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 at 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 at voice-system.ro>/* wrote:
>
>     Hi,
>
>     you need two steps:
>     1) write the ruri (after strip) into an AVP - use avp_write()
>     2) write the avp into the db - use avp_db_store()
>
>     regards,
>     bogdan
>
>     Jayesh Nambiar wrote:
>
>     > Hi all,
>     > I am trying to implement the call forwarding feature in openser. The
>     > forwarding part is fine. But I have the follwing scenario:
>     > Whenever a user needs to change his forwarding number, he should be
>     > able to do so from his end device only.
>     > For eg: He first presses 86 and then the 10 digit number to be
>     > forwarded. Here the 86 has to be stripped and the 10 digit number
>     > should be inserted into the call forward value column of the
>     > preferences table.
>     > Also if he wants to remove the forwarded number, he can do so by
>     > pressing say for eg: 87. on receiving this number openser should
>     > delete that value from the
>     > table.
>     > Is this possible. I tried to do the following, but somehow it
>     does not
>     > change the
>     > value.
>     > if(uri=~"^sip:86[0-9]*@") {
>     > if(avp_db_load("$from/username", "s:callfwd")) { #check
>     > if call-fwd feature is enabled for the user
>     > log(1,"AVP condition returned true");
>     > strip(2);
>     > avp_write("$ruri", "s:callfwd");
>     > avp_print();
>     > log(1,"AVP written");
>     > sl_send_reply("200", "OK");
>     > exit;
>     > };
>     > };
>     > Is avp_write the proper method or I guess avp_db_store can also help
>     > me. The avp_print() function also does not show me anything in the
>     > log. Are there any
>     > logical mistakes or I have mis-interpreted the syntax of avpops
>     functions.
>     > Please help me in thsi regard.
>     > Thanks a lot in advance.
>     > Jayesh.
>     >
>     > ------------------------------------------------------------------------
>     > Jiyo cricket on Yahoo! India cricket
>     >
>     > Yahoo! Messenger Mobile
>     >
>     > Stay in touch with your buddies all the time.
>     >
>     >------------------------------------------------------------------------
>     >
>     >_______________________________________________
>     >Users mailing list
>     >Users at openser.org
>     >http://openser.org/cgi-bin/mailman/listinfo/users
>     >
>     >
>
> ------------------------------------------------------------------------
>
> Jiyo cricket on Yahoo! India cricket 
> <http://us.rd.yahoo.com/mail/in/mailcricket/*http:/in.sports.yahoo.com/cricket/>
> Yahoo! Messenger Mobile 
> <http://us.rd.yahoo.com/mail/in/mailmobilemessenger/*http:/in.mobile.yahoo.com/new/messenger/> 
> Stay in touch with your buddies all the time.
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>