<p>Hello all,</p><p>I see global problem when use sip_trace module. <br>In sip_trace table is apear doble records.<br>One traced_user is empty and otder traced_user=trace_number.</p><p>Opensips: 1.8.1<br>Revision 9342</p><p>
Here is opensips.cfg:</p><p>modparam("siptrace", "db_url", "mysql://user:password@localhost/opensips")<br>modparam("siptrace", "trace_on", 1)<br>modparam("siptrace", "enable_ack_trace", 1)<br>
modparam("siptrace", "traced_user_avp", "$avp(trace_id)")<br>......<br>if (is_method("INVITE")) {<br>..... receive $avp(trace_id) from radius_send_auth .......<br> if ( $avp(trace_id) ) {<br>
xlog("L_ERR", "Trace ON. Trace_id=$avp(trace_id)\n");<br> sip_trace();<br> }<br>.....<br>}</p><p>Here is openlisp log:</p><p>sbin/opensips[2191]: Trace ON. Trace_id=8<br>sbin/opensips[2191]: DBG:core:parse_headers: flags=40<br>
sbin/opensips[2191]: *DBG:siptrace:sip_trace: sip_trace called*<br>sbin/opensips[2191]: DBG:siptrace:save_siptrace: saving siptrace<br>sbin/opensips[2191]: DBG:siptrace:insert_siptrace_flag: storing info 1...<br>sbin/opensips[2191]: DBG:db_mysql:has_stmt_ctx: ctx found for sip_trace<br>
sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x7f277f5fc4b8 (tail=139807617425128) MC=0x7f277f5f9f48<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run<br>
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=905; type=252; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=44; type=254; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=6; type=254; is_null=0<br>
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=0; type=254; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=23; type=254; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=23; type=254; is_null=0<br>
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=40; type=12; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=2; type=254; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (8): len=8; type=254; is_null=0<br>
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (9): len=0; type=254; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...<br>sbin/opensips[2191]: DBG:siptrace:insert_siptrace_avp: int val [8]<br>
sbin/opensips[2191]: DBG:siptrace:insert_siptrace_avp: storing info 14...<br>sbin/opensips[2191]: DBG:db_mysql:has_stmt_ctx: ctx found for sip_trace<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x7f277f5fc4b8 (tail=139807617425128) MC=0x7f277f5f9f48<br>
sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=905; type=252; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=44; type=254; is_null=0<br>
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=6; type=254; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=0; type=254; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=23; type=254; is_null=0<br>
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=23; type=254; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=40; type=12; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=2; type=254; is_null=0<br>
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (8): len=8; type=254; is_null=0<br>sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (9): len=1; type=254; is_null=0</p><p>Best regards,<br>PlayMen<br>
</p>