[OpenSIPS-Users] Problem with sip_trace

[Dragomir Haralambiev]

Hello all,

I see global problem when use sip_trace module.
In sip_trace table is apear doble records.
One traced_user is empty and otder traced_user=trace_number.

Opensips: 1.8.1
Revision 9342

Here is opensips.cfg:

modparam("siptrace", "db_url", "mysql://user:password@localhost/opensips")
modparam("siptrace", "trace_on", 1)
modparam("siptrace", "enable_ack_trace", 1)
modparam("siptrace", "traced_user_avp", "$avp(trace_id)")
......
if (is_method("INVITE")) {
..... receive $avp(trace_id) from radius_send_auth .......
   if ( $avp(trace_id) ) {
        xlog("L_ERR", "Trace ON. Trace_id=$avp(trace_id)\n");
        sip_trace();
    }
.....
}

Here is openlisp log:

sbin/opensips[2191]: Trace ON. Trace_id=8
sbin/opensips[2191]: DBG:core:parse_headers: flags=40
sbin/opensips[2191]: *DBG:siptrace:sip_trace: sip_trace called*
sbin/opensips[2191]: DBG:siptrace:save_siptrace: saving siptrace
sbin/opensips[2191]: DBG:siptrace:insert_siptrace_flag: storing info 1...
sbin/opensips[2191]: DBG:db_mysql:has_stmt_ctx: ctx found for sip_trace
sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query:
conn=0x7f277f5fc4b8 (tail=139807617425128) MC=0x7f277f5f9f48
sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: set values
for the statement run
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (0):
len=905; type=252; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=44;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=6;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=0;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=23;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=23;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=40;
type=12; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=2;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (8): len=8;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (9): len=0;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: doing
BIND_PARAM in...
sbin/opensips[2191]: DBG:siptrace:insert_siptrace_avp: int val [8]
sbin/opensips[2191]: DBG:siptrace:insert_siptrace_avp: storing info 14...
sbin/opensips[2191]: DBG:db_mysql:has_stmt_ctx: ctx found for sip_trace
sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query:
conn=0x7f277f5fc4b8 (tail=139807617425128) MC=0x7f277f5f9f48
sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: set values
for the statement run
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (0):
len=905; type=252; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=44;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=6;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=0;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=23;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=23;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=40;
type=12; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=2;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (8): len=8;
type=254; is_null=0
sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (9): len=1;
type=254; is_null=0

Best regards,
PlayMen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121018/055dbd74/attachment.htm>