[Kamailio-Users] load_credentials problem

[Dubravko Caric]

Hi all,

i have a problem when using AVPs which are loaded on client registration by the "load_credentials".

in the "subscriber" table i have "rpid" column (value 12345), "email address" (bob at example.com) and "acl" (value 3). when client registers, these three AVPs are loaded as you can see in debug. But when i want to use these AVPs it seems that they are empty.

i don't understand if they are ready for use or do i need to load them and how? i'm not doing any actions on AVPs so i could by mistake delete or replace the original ones...

version of kamailio is 1.5.1


Thanks

Dubravko


modparam("auth_db", "load_credentials", "$avp(i:66)=rpid;email_address;$avp(i:67)=acl")


DBG:db_mysql:db_mysql_get_columns: allocate 16 bytes for RES_NAMES[0] at 0x783400
DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x783400)[0]=[password]
DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
DBG:db_mysql:db_mysql_get_columns: allocate 16 bytes for RES_NAMES[1] at 0x783420
DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x783420)[1]=[acl]
DBG:db_mysql:db_mysql_get_columns: use DB_INT result type
DBG:db_mysql:db_mysql_get_columns: allocate 16 bytes for RES_NAMES[2] at 0x783440
DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x783440)[2]=[email_address]
DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
DBG:db_mysql:db_mysql_get_columns: allocate 16 bytes for RES_NAMES[3] at 0x783460
DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x783460)[3]=[rpid]
DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
DBG:core:db_allocate_rows: allocate 16 bytes for rows at 0x783480
DBG:core:db_allocate_row: allocate 128 bytes for row values at 0x7834a0
DBG:core:db_str2val: converting STRING [1234]
DBG:core:db_str2val: converting INT [3]
DBG:core:db_str2val: converting STRING [bob at example.com]
DBG:core:db_str2val: converting STRING [12345]
DBG:auth_db:get_ha1: HA1 string calculated: 649766733fe475191f6c32d338aae51d
DBG:auth:check_response: our result = 'f929dd9729d3c9447c4a4d632a762c85'
DBG:auth:check_response: authorization is OK
DBG:auth:post_auth: nonce index= 0
DBG:auth_db:generate_avps: set int AVP ""/67 = 3
DBG:auth_db:generate_avps: set string AVP "email_address"/0 = "bob at example.com"
DBG:auth_db:generate_avps: set string AVP ""/66 = "12345"
DBG:core:db_free_columns: freeing 4 columns

#################

if (is_method("INVITE")) {
    xlog("L_INFO", "RPID AVP VALUE $avp(i:66)\n");
    xlog("L_INFO", "EMAIL AVP VALUE $avp(s:email_address)\n");
    xlog("L_INFO", "ACL AVP VALUE $avp(i:67)\n");
}

./kamailio[21687]:  PRID AVP VALUE <null>
./kamailio[21687]:  EMAIL AVP VALUE <null>
./kamailio[21687]:  ACL AVP VALUE <null>