[Kamailio-Users] avp_db_query

[Bruno Machado]

Hi

I'm using Kamailio v1.5.1 and, I do not know why, the avp value is disappearing. Let me show you what is happening:

#IT DOESN'T WORK
avp_db_query("select count(1) as c from group_endpoint where num_ip='$si'","$avp(i:105)");
log(1,"Before AVP_PRINT\n");
avp_print();
log(1,"After AVP_PRINT\n");
if( avp_check("$avp(i:105)","eq/i:0") )


#Debug
Jun 10 09:57:48 [4326] DBG:avpops:ops_dbquery_avps: query [select count(1) as c from group_endpoint where num_ip='192.168.0.194']
Jun 10 09:57:48 [4326] DBG:core:db_new_result: allocate 28 bytes for result set at 0x8180ea8
Jun 10 09:57:48 [4326] DBG:db_mysql:db_mysql_get_columns: 1 columns returned from the query
Jun 10 09:57:48 [4326] DBG:core:db_allocate_columns: allocate 4 bytes for result names at 0x8180ed0
Jun 10 09:57:48 [4326] DBG:core:db_allocate_columns: allocate 4 bytes for result types at 0x8180ee0
Jun 10 09:57:48 [4326] DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[0] at 0x8180ef0
Jun 10 09:57:48 [4326] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8180ef0)[0]=[c]
Jun 10 09:57:48 [4326] DBG:db_mysql:db_mysql_get_columns: use DB_BIGINT result type
Jun 10 09:57:48 [4326] DBG:core:db_allocate_rows: allocate 8 bytes for rows at 0x8180f00
Jun 10 09:57:48 [4326] DBG:core:db_allocate_row: allocate 20 bytes for row values at 0x8180f10
Jun 10 09:57:48 [4326] DBG:core:db_str2val: converting BIGINT [0]
Jun 10 09:57:48 [4326] DBG:avpops:db_query_avp: rows [1]
Jun 10 09:57:48 [4326] DBG:avpops:db_query_avp: row [0]
Jun 10 09:57:48 [4326] DBG:avpops:db_close_query: close avp query
Jun 10 09:57:48 [4326] DBG:core:db_free_columns: freeing 1 columns
Jun 10 09:57:48 [4326] DBG:core:db_free_columns: freeing RES_NAMES[0] at 0x8180ef0
Jun 10 09:57:48 [4326] DBG:core:db_free_columns: freeing result names at 0x8180ed0
Jun 10 09:57:48 [4326] DBG:core:db_free_columns: freeing result types at 0x8180ee0
Jun 10 09:57:48 [4326] DBG:core:db_free_rows: freeing 1 rows
Jun 10 09:57:48 [4326] DBG:core:db_free_row: freeing row values at 0x8180f10
Jun 10 09:57:48 [4326] DBG:core:db_free_rows: freeing rows at 0x8180f00
Jun 10 09:57:48 [4326] DBG:core:db_free_result: freeing result set at 0x8180ea8
Before AVP_PRINT
After AVP_PRINT
Jun 10 09:57:48 [4326] DBG:avpops:ops_check_avp: no src avp found


No src avp found! There isn't any avp. The avp value returned by mysql server is quickly dropped. So, to avoid this, I changed the query's result into a string. I'm using the mysql concat function. 





#IT WORKS!
avp_db_query("select concat('',count(1)) from group_endpoint where num_ip='$si'","$avp(s:105)");
log(1,"Before AVP_PRINT\n");
avp_print();
log(1,"After AVP_PRINT\n");
if( avp_check("$avp(s:105)","eq/s:0/g") )


#Debug
Jun 10 10:01:37 [4378] DBG:avpops:ops_dbquery_avps: query [select concat('',count(1)) from group_endpoint where num_ip='192.168.0.194']
Jun 10 10:01:37 [4378] DBG:core:db_new_result: allocate 28 bytes for result set at 0x8180ea8
Jun 10 10:01:37 [4378] DBG:db_mysql:db_mysql_get_columns: 1 columns returned from the query
Jun 10 10:01:37 [4378] DBG:core:db_allocate_columns: allocate 4 bytes for result names at 0x8180ed0
Jun 10 10:01:37 [4378] DBG:core:db_allocate_columns: allocate 4 bytes for result types at 0x8180ee0
Jun 10 10:01:37 [4378] DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[0] at 0x8180ef0
Jun 10 10:01:37 [4378] DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8180ef0)[0]=[concat('',count(1))]
Jun 10 10:01:37 [4378] DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
Jun 10 10:01:37 [4378] DBG:core:db_allocate_rows: allocate 8 bytes for rows at 0x8180f00
Jun 10 10:01:37 [4378] DBG:core:db_allocate_row: allocate 20 bytes for row values at 0x8180f10
Jun 10 10:01:37 [4378] DBG:core:db_str2val: converting STRING [0]
Jun 10 10:01:37 [4378] DBG:avpops:db_query_avp: rows [1]
Jun 10 10:01:37 [4378] DBG:avpops:db_query_avp: row [0]
Jun 10 10:01:37 [4378] DBG:avpops:db_close_query: close avp query
Jun 10 10:01:37 [4378] DBG:core:db_free_columns: freeing 1 columns
Jun 10 10:01:37 [4378] DBG:core:db_free_columns: freeing RES_NAMES[0] at 0x8180ef0
Jun 10 10:01:37 [4378] DBG:core:db_free_columns: freeing result names at 0x8180ed0
Jun 10 10:01:37 [4378] DBG:core:db_free_columns: freeing result types at 0x8180ee0
Jun 10 10:01:37 [4378] DBG:core:db_free_rows: freeing 1 rows
Jun 10 10:01:37 [4378] DBG:core:db_free_row: freeing row values at 0x8180f10
Jun 10 10:01:37 [4378] DBG:core:db_free_rows: freeing rows at 0x8180f00
Jun 10 10:01:37 [4378] DBG:core:db_free_result: freeing result set at 0x8180ea8
Before AVP_PRINT
Jun 10 10:01:37 [4378] INFO:avpops:ops_print_avp: p=0xb5d3ef08, flags=0x0003
Jun 10 10:01:37 [4378] INFO:avpops:ops_print_avp:                       name=<105>
Jun 10 10:01:37 [4378] INFO:avpops:ops_print_avp:                       val_str=<0 / 1>
After AVP_PRINT
Jun 10 10:01:37 [4378] DBG:avpops:ops_check_avp: check <0> against <0> as str /16777217


The avp value is there now! Why is it happening? Am I doing something wrong? I think the answer is a perfect 'yes'. Thanks for any advice.
Bruno



      Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090610/e9164a4d/attachment.htm>