[OpenSER-Users] avp_db_load() with avp aliases

[Papadopoulos Georgios]

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 at 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 at voice-system.ro] 
> Sent: Tuesday, October 02, 2007 12:14 PM
> To: Papadopoulos Georgios
> Cc: users at 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 at openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >   
>