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

[Bogdan-Andrei Iancu]

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: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`
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro