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@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@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@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>