<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi Brian<br><br>i follow your suggestion and it is successfully writing the log to text file sip_trace<br><br>the opensips.cfg<br><br>loadmodule "db_text.so"<br>modparam("siptrace", "trace_flag", 22)<br>modparam("siptrace", "db_url", "text:///tmp/opensipsdb")<br>modparam("siptrace", "trace_on", 1)<br>modparam("siptrace", "enable_ack_trace", 1)<br>modparam("siptrace", "table", "sip_trace")<br><br>but when you enable debug=9 in the opensips.cfg<br><br>it say the error:<br>Dec 10 23:53:44 localhost /usr/local/sbin/opensips[1923]: INFO:db_text:dbt_init: using database at: /tmp/opensipsdb<br><br>Dec 10 23:54:01 localhost /usr/local/sbin/opensips[1915]: ERROR:db_text:dbt_insert: table does not exist!<br>Dec 10 23:54:01 localhost /usr/local/sbin/opensips[1915]: ERROR:siptrace:sip_trace: error storing trace<br>Dec 10 23:54:01 localhost /usr/local/sbin/opensips[1915]:
ERROR:db_text:dbt_insert: table does not exist!<br>Dec 10 23:54:01 localhost /usr/local/sbin/opensips[1915]: ERROR:siptrace:trace_onreply_out: error storing trace<br>Dec 10 23:54:01 localhost /usr/local/sbin/opensips[1915]: ERROR:db_text:dbt_insert: table does not exist!<br>Dec 10 23:54:01 localhost /usr/local/sbin/opensips[1915]: ERROR:siptrace:sip_trace: error storing trace<br><br><br>[root@localhost ~]# cat /tmp/opensipsdb/sip_trace<br>id(int,auto) time_stamp(int) callid(string) traced_user(string) msg(string) method(string) status(string) fromip(string) toip(string) fromtag(string) direction(string)<br>36:1260463989:YzJhOTE1OWFiNWVkMzM1ZTJlM2E5ZjI1NTc2NWQyM2Y.::SIP/2.0 200 OK\r\nVia\: SIP/2.0/UDP 192.168.237.1\:53352;received=192.168.237.1;branch=z9hG4bK-d87543-a60eba2316543c40-1--d87543-;rport=53352\r\nContact\: <sip\:2000@192.168.237.1\:62174;rinstance=2fcc01b2c5d4bac7>\r\nTo\: "2000"<sip\:2000@192.168.237.131>;tag=6e5a5b08\r\nFrom\:
<sip\:8000@192.168.237.131>;tag=415aae68\r\nCall-ID\: YzJhOTE1OWFiNWVkMzM1ZTJlM2E5ZjI1NTc2NWQyM2Y.\r\nCSeq\: 2 BYE\r\nUser-Agent\: X-Lite release 1103k stamp 53621\r\nContent-Length\: 0\r\n\r\n:BYE:200:udp\:192.168.237.131\:5060:udp\:192.168.237.1\:53352:415aae68:out<br>35:1260463989:YzJhOTE1OWFiNWVkMzM1ZTJlM2E5ZjI1NTc2NWQyM2Y.::SIP/2.0 200 OK\r\nVia\: SIP/2.0/UDP 192.168.237.131;branch=z9hG4bKde3e.722ffa76.0\r\nVia\: SIP/2.0/UDP 192.168.237.1\:53352;received=192.168.237.1;branch=z9hG4bK-d87543-a60eba2316543c40-1--d87543-;rport=53352\r\nContact\: <sip\:2000@192.168.237.1\:62174;rinstance=2fcc01b2c5d4bac7>\r\nTo\: "2000"<sip\:2000@192.168.237.131>;tag=6e5a5b08\r\nFrom\: <sip\:8000@192.168.237.131>;tag=415aae68\r\nCall-ID\: YzJhOTE1OWFiNWVkMzM1ZTJlM2E5ZjI1NTc2NWQyM2Y.\r\nCSeq\: 2 BYE\r\nUser-Agent\: X-Lite release 1103k stamp 53621\r\nContent-Length\:
0\r\n\r\n:BYE:200:udp\:192.168.237.1\:62174:udp\:192.168.237.131\:5060:415aae68:in<br><br><br>--- On <b>Wed, 12/9/09, opensipslist@encambio.com <i><opensipslist@encambio.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: opensipslist@encambio.com <opensipslist@encambio.com><br>Subject: Re: [OpenSIPS-Users] Help with sip trace errors please<br>To: users@lists.opensips.org<br>Date: Wednesday, December 9, 2009, 11:16 AM<br><br><div class="plainMail"><br>Hello Bogdan,<br><br>On wed., dec 09, 2009, Bogdan-Andrei Iancu wrote:<br>>Field 0 is the "msg" field (used as DB_BLOB by siptrace) should be<br>>"STR" to work, but I already see it is set at string in your table<br>>definition... so I looked for a bug and found one in the db_text<br>>module - if you update from SVN, it should be ok.<br>><br>That is great news, but sadly I might have been able to find
and<br>correct the problem myself if the variable naming was not so cryptic.<br><br>But thanks to you indeed, the problem is solved. I've tested your<br>revision 6382:<br><br>Index: modules/db_text/dbt_lib.c<br>diff -Nau modules/db_text/dbt_lib.c.orig modules/db_text/dbt_lib.c<br>--- modules/db_text/dbt_lib.c.orig 2009-10-16 02:35:15.000000000 +0200<br>+++ modules/db_text/dbt_lib.c 2009-12-09 18:14:52.707887067 +0100<br>@@ -446,7 +446,7 @@<br> if(_t0==DB_STRING || _t0==DB_BLOB)<br> return 0;<br> case DB_BLOB:<br>- if(_t0==DB_STR)<br>+ if(_t0==DB_STR || _t0==DB_STRING)<br> return 0;<br> case DB_BITMAP:<br>
if (_t0==DB_INT)<br><br>...and it works.<br><br>Regards,<br>Brian<br><br>_______________________________________________<br>Users mailing list<br><a ymailto="mailto:Users@lists.opensips.org" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></div></blockquote></td></tr></table><br>