[OpenSER-Users] db_extra: the avp value does not correspond to the real value

Bruno Machado bsmufu at yahoo.com.br
Mon May 19 18:18:42 CEST 2008


Hi friends.

OK. People... I'm almost getting crazy. I don't understand what is happening.
I already looked for an answer, but I didn't find nothing yet. I am recording 8 extra 
values in ACC, but the SQL command is using a weird value for one of them. So, 
I removed 6 of them to facilitate the analyze. Look at the code:

.
.
modparam("acc", "db_extra", "valueA=$avp(i:15); valueB=$avp(i:16)")
.
.
.
avp_write("i:15","$avp(i:15)");
avp_write("i:16","$avp(i:16)");

if(!t_relay())
{
    sl_reply_error();
    exit;
};

avp_print();
exit;



OK.  Looking at these lines, I would say: "the sql INSERT command will use the value
15 for avp:15 and 16 for avp:16". Now, look at the result of "avp_print":


 2(11112) INFO:avpops:print_avp: p=0xb3b4a900, flags=0x0000
 2(11112) INFO:                 id=<16>
 2(11112) INFO:                 val_int=<16>
 2(11112) INFO:avpops:print_avp: p=0xb3b4a8e8, flags=0x0000
 2(11112) INFO:                 id=<15>
 2(11112) INFO:                 val_int=<15>

Nice. AVP 15 has the value 15 and the AVP 16 has 16. 
But something is happening.... It is the insert command:

insert into acc (from_uri,to_uri,sip_method...............valueA,valueB,time) values
.........,'16','16','2008-05-19 12:48:38').

16 twice!! Why? This question is running in loop inside my head. It should be  "....'15','16','2008-05-19 12:48:38'.....". 


The openser code above is executed just once by the INVITE. 

I can bet this error is the like when we sum "2 and 3" and the result is "6". 
You look at the equation, but you don't see it at all. And, when you ask your
younger brother to see, he says: "you are stupid... 2+3=5". 

I never had this problem. I use several avps to log in the database and it is the
first time that it happens. You can see that I'M NOT CHANGING the values 
of the avps.

Am I doing a stupid thing? Or, maybe, am I being blind? 

By the way, I'm using version 1.1.1. 

Tks people.




OK. Apparently, there's nothing wrong. 


      Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento!
http://br.mail.yahoo.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080519/d75d4d12/attachment.htm>


More information about the sr-users mailing list