[Users] avp_db_load

[Brandon Armstead]

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> 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
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>



-- 
Brandon Armstead
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070124/75266036/attachment.htm>