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(a)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(a)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(a)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>