[OpenSIPS-Users] Need help on sip_trace module write the log to a file

[ha do]

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"
#modparam("siptrace", "db_url","mysql://opensips:opensipsrw@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`



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20091206/d3c9b2a6/attachment.htm