<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><br><br>--- On <b>Fri, 12/11/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: Friday, December 11, 2009, 11:18 AM<br><br><div class="plainMail">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 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 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) toip(string) <BR>> fromtag(string) direction(string)<BR>><BR>> step 2 : start opensips with sip_trace enable : /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) 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) 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) toip(string) <BR>> fromtag(string) direction(string)<BR>> 39:1260518390:MGRjYzNhYzQ0YTc2YTU0MWQyYzI4MTEyY2Q5NjcwYjI.::SIP/2.0 <BR>> 200 OK\r\nVia\: SIP/2.0/UDP <BR>> 192.168.237.1\:5592;received=192.168.237.1;branch=z9hG4bK-d8754z-5d41606f451fca7c-1---d8754z-;rport=5592\r\nContact\: <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>> 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 /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 exists, and<BR>> you start opensips fresh, then no error appears in the log 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 log and<BR>> the sip_trace file is not written to with new transactions? 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 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> </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>