<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi Bogdan<br><br>i use the Checked out revision 6439.<br>it is still issue when the sip_trace has content<br><br>do you have a plan to make enhancement of sip_trace that logs all message without stop/start opensips <br>how to admin opensips without log :((<br><br>Thank you<br>Ha`<br><br>--- On <b>Mon, 12/14/09, Bogdan-Andrei Iancu <i><bogdan@voice-system.ro></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Bogdan-Andrei Iancu <bogdan@voice-system.ro><br>Subject: Re: [OpenSIPS-Users] Help with sip trace errors please<br>To: "OpenSIPS users mailling list" <users@lists.opensips.org><br>Date: Monday, December 14, 2009, 5:38 AM<br><br><div class="plainMail">Hi Ha,<br><br>found the bug - there was an issue when loading the sip_trace file with <br>content (some columns being
NULL).<br><br>I fixed the problem on SVN, so if you do an update and re-compile, you <br>should not need to delete the file during restarts.<br><br>Thanks and regards,<br>Bogdan<br><br>ha do wrote:<br>> HI Bogdan<br>><br>> it is clear now :)<br>><br>> f the file has content (aside the first line), the siptrace module <br>> does not start ?<br>> no, the sip_trace module starts fine, i only need to replace new <br>> sip_trace file then the error is gone :)<br>><br>> is there a module with the same function as sip_trace but no need to <br>> shutdown opensips<br>><br>><br>> Thank you<br>> Ha`<br>><br>> --- On *Fri, 12/11/09, Bogdan-Andrei Iancu /<<a ymailto="mailto:bogdan@voice-system.ro" href="/mc/compose?to=bogdan@voice-system.ro">bogdan@voice-system.ro</a>>/* <br>> wrote:<br>><br>><br>> From: Bogdan-Andrei Iancu <<a ymailto="mailto:bogdan@voice-system.ro"
href="/mc/compose?to=bogdan@voice-system.ro">bogdan@voice-system.ro</a>><br>> Subject: Re: [OpenSIPS-Users] Help with sip trace errors please<br>> To: "OpenSIPS users mailling list" <<a ymailto="mailto:users@lists.opensips.org" href="/mc/compose?to=users@lists.opensips.org">users@lists.opensips.org</a>><br>> Date: Friday, December 11, 2009, 11:18 AM<br>><br>> Hi Ha,<br>><br>> Note that the DB content is updated only at shutdown.<br>><br>> So, to synthesize - if the file has content (aside the first<br>> line), the<br>> siptrace module does not start ?<br>><br>> Regards,<br>> Bogdan<br>><br>> ha do wrote:<br>>
> HI Brian<br>> ><br>> > [root@localhost opensipsdb]# ls -ld /tmp/opensipsdb/<br>> > drwxr-xr-x 2 root root 4096 Dec 11 14:56 /tmp/opensipsdb/<br>> > [root@localhost opensipsdb]# ls -ld /tmp/opensipsdb/sip_trace<br>> > -rw-r--r-- 1 root root 168 Dec 11 14:56 /tmp/opensipsdb/sip_trace<br>> > [root@localhost opensipsdb]# ps axu | grep opensips<br>> > root 2014 0.0 1.1 38072 2928 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2016 0.0 0.3 38072 824 ? S
14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2017 0.0 0.3 38072 796 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2018 0.0 0.3 38072 796 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2019 0.0 0.3 38072 796 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2020 0.0 0.6 38072 1712
? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2021 0.0 0.6 38072 1696 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2022 0.0 0.6 38072 1724 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2023 0.0 0.6 38072 1588 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2024 0.0 0.2
38072 632 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2025 0.0 0.3 38072 948 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2026 0.0 0.3 38076 824 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2027 0.0 0.3 38072 892 ? R 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> >
root 2028 0.0 0.3 38072 892 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2029 0.0 0.3 38072 892 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2030 0.0 0.3 38072 892 ? S 14:56 0:00<br>> > /usr/local/sbin/opensips<br>> > root 2031 0.0 0.3 38072 880 ? S 14:56 0:00<br>> >
/usr/local/sbin/opensips<br>> > root 2044 0.0 0.2 3904 672 pts/0 R+ 15:00 0:00<br>> grep<br>> > opensips<br>> ><br>> > let me describe my steps:<br>> > step1 : create file sip_trace then insert with 1 line :<br>> > id(int,auto) time_stamp(int) callid(string) traced_user(string)<br>> > msg(string) method(string) status(string) fromip(string)<br>> toip(string)<br>> > fromtag(string) direction(string)<br>> ><br>> > step 2 : start opensips with sip_trace enable :<br>>
/etc/init.d/opensips<br>> > start<br>> ><br>> > step 3 : use xlite softphone(2000) + eyebeam(8000) register and<br>> > register successfull<br>> ><br>> > step 4 : make call from 2000 to 8000 then connected fine then hangup<br>> ><br>> > step5 : check the /tmp/opensipsdb/sip_trace : cat<br>> > /tmp/opensipsdb/sip_trace and result<br>> > [root@localhost opensipsdb]# cat /tmp/opensipsdb/sip_trace<br>> > id(int,auto) time_stamp(int) callid(string) traced_user(string)<br>> > msg(string) method(string) status(string) fromip(string)<br>>
toip(string)<br>> > fromtag(string) direction(string)<br>> ><br>> > step 6: wait about 3 mins<br>> ><br>> > step 7: check the sip_trace file :<br>> > [root@localhost opensipsdb]# cat /tmp/opensipsdb/sip_trace<br>> > id(int,auto) time_stamp(int) callid(string) traced_user(string)<br>> > msg(string) method(string) status(string) fromip(string)<br>> toip(string)<br>> > fromtag(string) direction(string)<br>> ><br>> ><br>> > step 8 : stop opensips : /etc/init.d/opensips stop<br>> ><br>> > step 9: check
the sip_trace file : at this time all logs are now in<br>> > the /tmp/opensipsdb/sip_trace<br>> > [root@localhost opensipsdb]# cat /tmp/opensipsdb/sip_trace<br>> > id(int,auto) time_stamp(int) callid(string) traced_user(string)<br>> > msg(string) method(string) status(string) fromip(string)<br>> toip(string)<br>> > fromtag(string) direction(string)<br>> > 39:1260518390:MGRjYzNhYzQ0YTc2YTU0MWQyYzI4MTEyY2Q5NjcwYjI.::SIP/2.0<br>> > 200 OK\r\nVia\: SIP/2.0/UDP<br>> ><br>> 192.168.237.1\:5592;received=192.168.237.1;branch=z9hG4bK-d8754z-5d41606f451fca7c-1---d8754z-;rport=5592\r\nContact\:<br>><br>> >
<sip\:8000@192.168.237.1\:19032>\r\nTo\:<br>> > <sip\:8000@192.168.237.131>;tag=5378ee52\r\nFrom\:<br>> > "2000"<sip\:2000@192.168.237.131>;tag=aa323d0e\r\nCall-ID\:<br>> > MGRjYzNhYzQ0YTc2YTU0MWQyYzI4MTEyY2Q5NjcwYjI.\r\nCSeq\: 2<br>> > BYE\r\nUser-Agent\: eyeBeam release 1004p stamp<br>> > 31962\r\nContent-Length\:<br>> ><br>> 0\r\n\r\n:BYE:200:udp\:192.168.237.131\:5060:udp\:192.168.237.1\:5592:aa323d0e:out<br>> ><br>> > step 10 : start opensips again : /etc/initd/opensips start - start<br>> > successfull without problem<br>> ><br>> > step 11 : register 2000 + 8000
again<br>> ><br>> > step 12: get error from debug :<br>> > Dec 11 15:03:49 localhost /usr/local/sbin/opensips[2120]:<br>> > ERROR:db_text:dbt_insert: table does not exist!<br>> > Dec 11 15:03:49 localhost /usr/local/sbin/opensips[2120]:<br>> > ERROR:siptrace:sip_trace: error storing trace<br>> ><br>> ><br>> > what happen in your lab, Brian<br>> > does the log of sip_trace write down to<br>> /tmp/opensipsdb/sip_trace file<br>> > right away or you need to wait some times<br>> ><br>> ><br>> > Thank you<br>>
> Ha<br>> ><br>> > Are you saying that when no /tmp/opensipsdb/sip_trace<br>> exists, and<br>> > you start opensips fresh, then no error appears in the log<br>> and the<br>> > sip_trace file is created normally?<br>> ><br>> > And are you saying that when a /tmp/opensipsdb/sip_trace exists,<br>> > and you start opensips fresh, then a error appears in the<br>> log and<br>> > the sip_trace file is not written to with new transactions?<br>>
Please<br>> > show the errors in the log file if this is the case.<br>> ><br>> > Also, please tell us the results of:<br>> ><br>> > [root@localhost ~]# ls -ld /tmp/opensipsdb<br>> > [root@localhost ~]# ls -ld /tmp/opensipsdb/sip_trace<br>> > [root@localhost ~]# ps aux | grep opensips<br>> ><br>> > ...in order to determine if you have a permissions problem<br>> easily<br>> > solved in the opensips.cfg.<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>> </mc/compose?to=<a ymailto="mailto:Users@lists.opensips.org" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a>><br>> </mc/compose?to=<a ymailto="mailto:Users@lists.opensips.org" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a><br>>
</mc/compose?to=<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>> ><br>> ><br>> ><br>> ------------------------------------------------------------------------<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> </mc/compose?to=<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>> > <br>><br>><br>> -- <br>> Bogdan-Andrei Iancu<br>> www.voice-system.ro<br>><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> </mc/compose?to=<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>><br>><br>> ------------------------------------------------------------------------<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>> <br><br><br>-- <br>Bogdan-Andrei Iancu<br>www.voice-system.ro<br><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>