Re: [Users] avp_db_load

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