[Serusers] avp_db_load fails with avp as source

[brett-ser-list]

I keep coming back to that. However, a user can be a member of multiple calling scopes. for 
example 1)Houston 2)LongDistance 3)Information

And I can't figure out how to do it nicely that way.. seems like maybe I'd have to create a 
seperate column for each callscope? Surely there sure be a different way.. I simply want to 
load a *list* of avps based on login credentials.. seems simple enough, right?

-Brett

---------- Original Message ----------------------------------
From: "Greger V. Teigre" <greger at teigre.com>
Date:  Fri, 4 Nov 2005 08:10:04 +0100

>Brett,
>I have never used avpairs with sql (I use radius), but I believe the 
>avp_db_load statement should be removed alltogether.  The avps_column_str 
>instructs the auth module to load the value in the callscope column ON 
>SUCCESSFUL AUTHENTICATION, i.e. when the user is authenticated, the avp is 
>already loaded and ready to be used.
>g-)
>
>----- Original Message ----- 
>From: "brett-ser-list" <brett-ser-list at worldcall.net>
>To: <serusers at lists.iptel.org>
>Sent: Friday, November 04, 2005 2:30 AM
>Subject: [Serusers] avp_db_load fails with avp as source
>
>
>> Hello All,
>> I'm trying (desperately) to use avp_db_load with an avp:
>> version: ser 0.9.3 (i386/linux)
>> flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, 
>> DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
>> ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, 
>> MAX_URI_SIZE 1024, BUF_SIZE 65535
>> @(#) $Id: main.c,v 1.197 2004/12/03 19:09:31 andrei Exp $
>> main.c compiled on 12:28:21 Aug 16 2005 with gcc 3.3
>>
>> modparam("auth_db","avps_column_str","callscope")
>> modparam("avpops","avp_aliases","callgroups=i:200")
>> modparam("avpops","avp_aliases","callscope=i:500")
>> avp_db_load("$callscope","$callgroups/avps") ;
>>
>> In watching the debug, I see the avp loaded just fine from the database 
>> from the auth_db parameter:
>> 3(1735) DEBUG:avpops:print_avp: p=0xf51c20d8, flags=3
>> 3(1735) DEBUG:                 name=<callscope>
>> 3(1735) DEBUG:                 val_str=<200>
>>
>> but the above avp_db_load line is resulting in:
>> 3(1735) DEBUG:avpops:get_val_as_str: no avp found
>> 3(1735) ERROR:avpops:load_avps: failed to get uuid
>>
>> I also notice that it doesn't even bother to hit the database after the 
>> auth_db hit. So unless the avp table has been cached (Which I have no idea 
>> if it has..) how would it know?
>>
>> Seems like error #1: no avp found? Seems like it doesn't like my syntax 
>> but according to the avpops documentation, it should be right:
>> source = (sip_uri|avp_alias|str_value) 
>> ['/'('username'|'domain'|'uri'|'uuid')]
>>
>>
>> note:
>> avp_db_load("$callscope/uuid","$callgroups/avps") ;
>> gives me:
>> 0(0) ERROR:avpops:fixup_db_avp: source/flags "callscope" unknown!
>>
>> Look, what I really want to do is use the authentication credentials to 
>> load an avp. Isn't that was avp is for? I don't want the FROM or the TO or 
>> the [R]URI, but the actual AUTHentication username. Any ideas??
>>
>> Thanks!!
>> BTW, I've tried the newest SER DEVEL CVS, and OPENSER 1.0 with basically 
>> the same results. Some custom modules I have would also make me want to 
>> stick with 0.9.0.
>>
>> -Brett
>>
>> _______________________________________________
>> Serusers mailing list
>> serusers at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>
>> 
>
>