New subject: [OpenSER-Users] avp_db_load() with avp aliases

2 Oct 2007

Hello Daniel,

I added a debug statement in mysql/dbase.c/db_mysql_submit_query() and
here is the output. 

 1(1950) Checking pkt for caller sip:demo2@altecnet.gr
 1(2318) submit_query(): select value,attribute,type from
usr_preferences where username='demo2' AND domain='altecnet.gr' AND
attribute='111' 
 1(1950) close avp query
 1(1950) DEBUG:avpops:load_avps: loaded avps = 0

My config looks like
        avp_aliases="pkt=i:111"
        ...
        xlog("L_ERR","Checking pkt for caller $avp(caller)\n");
        if (is_avp_set("$avp(caller)") &&
            avp_db_load("$avp(caller)/uri", "$avp(pkt)")) {
                xlog("L_ERR", "Use large pkt=$avp(pkt) for caller
$avp(caller)\n");
		...
         }

I see now what is happening. So I am guessing that avp_db_load() cannot
be used this way unless I rename my records in DB from 'pkt' to '111'
which does not make much sense. Second alternative would be to use some
custom db_scheme. 

best regards

George

...
  -----Original Message-----
 From: Daniel-Constantin Mierla [mailto:daniel@voice-system.ro] 
 Sent: Tuesday, October 02, 2007 12:14 PM
 To: Papadopoulos Georgios
 Cc: users(a)openser.org
 Subject: Re: [OpenSER-Users] avp_db_load() with avp aliases

 Hello,

 can you get the debug messages with debug=7 and the sql query 
 sent to the mysql server?

 Cheers,
 Daniel

 On 10/01/07 10:09, Papadopoulos Georgios wrote:
  Hello all,

 Recently I changed all my avps from string names to   aliases. I noticed 
  that all my avp_db_load() calls are failing. From
the tests that I 
 did, I conclude that it fails when the 2nd argument to the   function is 
  an avp with an alias:

 avp_aliases="caller = i:100;
                     pkt = i:111"
 avp_db_load("$avp(s:caller)/uri", "$avp(s:pkt)")     works ok
 avp_db_load("$avp(caller)/uri", "$avp(s:pkt)")        works ok
 avp_db_load("$avp(caller)/uri", "$avp(pkt)")           fails
 What am I doing wrong? My version is 1.2 from svn (rev. 2826)

 thank you for any help

 George

   Disclaimer

 The information in this e-mail and any attachments is   confidential. It 
  is intended solely for the attention and use of
the named 
 addressee(s). If you are not the intended recipient, or person 
 responsible for delivering this information to the intended   recipient, 
  please notify the sender immediately. Unless you
are the intended 
 recipient or his/her representative you are not authorized to, and 
 must not, read, copy, distribute, use or retain this message or any 
 part of it. E-mail transmission cannot be guaranteed to be   secure or 
  error-free as information could be intercepted,
corrupted, lost, 
 destroyed, arrive late or incomplete, or contain viruses.

   ----------------------------------------------------------------------
  --

 _______________________________________________
 Users mailing list
 Users(a)openser.org
 http://openser.org/cgi-bin/mailman/listinfo/users

RE: [OpenSER-Users] avp_db_load() with avp aliases