<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Salut Dragomir,<br>
<br>
This is because you set the user id AVP for tracing. If you look
into DB, you will see that one record is without trace_user and
one with trace_user.<br>
<br>
If you do not set the trace_user AVP, you will get a single
record.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 10/19/2012 12:10 AM, Dragomir Haralambiev wrote:
<blockquote
cite="mid:CADzurOJDGU7gBitJ779F53L5idemYuPb6fmJvpnvnVMc7qSobQ@mail.gmail.com"
type="cite">
<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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>