[OpenSER-Users] avp_db_load() with avp aliases

[Daniel-Constantin Mierla]

Hello George,

just to give more details, before closing the thread, so that new 
readers can get to final conclusion quickly.

Even if you use aliases in the script, in database must be used the 
names of avps. The avp aliases are used in openser script only.

Cheers,
Daniel


On 10/02/07 13:30, Papadopoulos Georgios wrote:
> 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
>>>   
>>>       
>
>