[Users] avp_db_load

[Daniel-Constantin Mierla]

Hello Brandon,

I have tested locally and seem to work. What version of openser do you 
use? Could you update to latest CVS version of your release and try 
again? I tested with 1.1.1 and devel version. Here Is what I have:

    if(is_method("INVITE"))
    {
        avp_db_load("$ru/username", "$avp(s:e911)");
        xlog("avp -- $avp(s:e911) \n");
    }


 0(10251) DEBUG:avpops:load_avps: loaded avps = 1
 0(10251) avp -- 12345

+------+----------+-------------+-----------+------+-------+---------------------+
| uuid | username | domain      | attribute | type | value | 
modified            |
+------+----------+-------------+-----------+------+-------+---------------------+
|      | user     | openser.org | e911      |    0 | 12345 | 2007-01-25 
10:53:20 |
+------+----------+-------------+-----------+------+-------+---------------------+

Cheers,
Daniel

On 01/24/07 16:57, Brandon at voipo.com wrote:
> Hello daniel,
>
>     The value would be 0.
> Sent via BlackBerry from T-Mobile  
>
> -----Original Message-----
> From: Daniel-Constantin Mierla <daniel at voice-system.ro>
> Date: Wed, 24 Jan 2007 16:49:52 
> To:Brandon Armstead <brandon.armstead at gmail.com>
> Cc:users at openser.org
> Subject: Re: [Users] avp_db_load
>
> Hello Brandon,
>
> what is the value you have in the column 'type' for this record?
>
> Cheers,
> Daniel
>
> On 01/24/07 14:03, Brandon Armstead wrote:
>   
>> Hello Daniel,
>>
>>     I just tryed exactly this:
>>
>>         if(avp_db_load("$ru/username", "$avp(s:e911)"))
>>         {
>>                 avp_pushto("$ru", "$avp(s:e911)");
>>         }
>>
>>         I even tried printing out the AVP after it should have been 
>> loaded, once again NULL.  There is a row in usr_preferences, I have it 
>> working with avp_db_query, however for the life of me can not get 
>> avp_db_load to work?  I have a column 'username', a column 'domain', a 
>> column 'attribute', a column 'type', and a column 'value'.  The 
>> attribute is e911, the value is set, and the username is set, as well 
>> as domain, although domain in this case should not matter.  I just 
>> can't get it working..... any help is appreciated, thanks!
>>
>>
>> On 1/24/07, *Daniel-Constantin Mierla* <daniel at voice-system.ro 
>> <mailto:daniel at voice-system.ro>> wrote:
>>
>>     Hello,
>>
>>     did you get any error messages in syslog. Try:
>>     avp_db_load("$ru/username", "$avp(s:e911)");
>>
>>     $rU is username, and $ru is R-URI from where to get the
>>     username  (first
>>     version should fire errors).
>>
>>     Cheers,
>>     Daniel
>>
>>     On 01/23/07 19:59, Brandon Armstead wrote:
>>     > Hello everyone,
>>     >
>>     >     I'm trying to load an avp from the database, now from my
>>     > understanding I simply use the avp_db_load() function.  Now I
>>     > previously setup my avp_table to be usr_preferences, now I'm
>>     doing the
>>     > following:
>>     >
>>     > route[5]
>>     > {
>>     >         xlog("L_INFO", "time [$Tf] method <$rm> r-uri <$ru> 2nd via
>>     > <$hdr(via[1])>\n");
>>     >
>>     >         avp_db_load("$rU/username", "$avp(s:e911)");
>>     >
>>     >         xlog("L_INFO", "CURRENT AVP VALUE: $avp(s:e911)");
>>     >
>>     >         if(is_avp_set("$avp(s:e911)"))
>>     >         {
>>     >                 xlog("L_INFO", "CURRENT \$ru: $ru");
>>     >                 avp_pushto("$ru", "$avp(s:e911)");
>>     >                 xlog("L_INFO", "AFTER \$ru: $ru");
>>     >         }
>>     >
>>     >         route(1);
>>     > }
>>     >
>>     > For route 5, and I have a AVP row for 'e911' in the database,
>>     with the
>>     > username, domain, and the attribute set, the attribute ofcourse
>>     being
>>     > e911, type 0, and a value set.  However, I keep getting NULL
>>     back for
>>     > the AVP I'm trying to pull, does anyone care to explain what I'm
>>     doing
>>     > wrong?  Thanks.
>>     >
>>     > --
>>     > Brandon Armstead
>>     >
>>     ------------------------------------------------------------------------
>>     >
>>     > _______________________________________________
>>     > Users mailing list
>>     > Users at openser.org <mailto:Users at openser.org>
>>     > http://openser.org/cgi-bin/mailman/listinfo/users
>>     >
>>
>>
>>
>>
>> -- 
>> Brandon Armstead 
>>     
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>