Hi Ha, The problem is the "time_stamp(str)" field - is is not compatible (the definition) with the data type internally used (DB_DATETIME) by siptrace module.
Try changing the field to (int) type. Regards, Bogdan ha do wrote: > Hi admin > > i do config to use the siptrace module write the log to text file but > i got the error: > > from the debug=9, log_facility=LOG_LOCAL7: > Dec 7 15:14:37 Opensips Cucku[2168]: > DBG:siptrace:trace_sl_onreply_out: dest [udp:192.168.237.1:7226] > Dec 7 15:14:37 Opensips Cucku[2168]: > DBG:siptrace:trace_sl_onreply_out: storing info... > Dec 7 15:14:37 Opensips Cucku[2168]: DBG:db_text:dbt_db_get_table: > cache or mtime succeeded for [sip_trace] > Dec 7 15:14:37 Opensips Cucku[2168]: ERROR:db_text:dbt_insert: > incompatible types v[6] - c[1]! > Dec 7 15:14:37 Opensips Cucku[2168]: > ERROR:siptrace:trace_sl_onreply_out: error storing trace > Dec 7 15:14:37 Opensips Cucku[2168]: DBG:core:destroy_avp_list: > destroying list (nil) > Dec 7 15:14:37 Opensips Cucku[2168]: DBG:core:receive_msg: cleaning up > > from the tail -f /var/log/message : > Dec 7 15:14:37 Opensips Cucku[2168]: ERROR:db_text:dbt_insert: > incompatible types v[6] - c[1]! > Dec 7 15:14:37 Opensips Cucku[2168]: ERROR:siptrace:sip_trace: error > storing trace > Dec 7 15:14:37 Opensips Cucku[2168]: ERROR:db_text:dbt_insert: > incompatible types v[6] - c[1]! > Dec 7 15:14:37 Opensips Cucku[2168]: > ERROR:siptrace:trace_sl_onreply_out: error storing trace > > the config: > loadmodule "siptrace.so <http://siptrace.so>" > #modparam("siptrace", > "db_url","mysql://opensips:opensip...@localhost/opensips") > modparam("siptrace", "db_url","text:///tmp/opensipsdb") > modparam("siptrace", "enable_ack_trace", 1) > modparam("siptrace", "trace_on", 0) > modparam("siptrace", "trace_flag",2) > > > but i am successfull when i write the log to mysql > > i create the file name : sip_trace in the directory : /tmp/opensipsdb > the structure of the sip_trace file : > id(int) time_stamp(str) callid(str) traced_user(str) msg(str) > method(str) status(str) fromip(str) toip(str) fromtag(str) direction(str) > > > please help me to create a right format sip_trace file > > Thank you > Ha` > > > ------------------------------------------------------------------------ > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- Bogdan-Andrei Iancu www.voice-system.ro _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
