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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] > Sent: Tuesday, October 02, 2007 12:14 PM > To: Papadopoulos Georgios > Cc: users@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@openser.org > > http://openser.org/cgi-bin/mailman/listinfo/users > > > _______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users