FYI, this only works on newer syslogs, eg the one found in RedHat 6.0
khera@stripped wrote:
>
> >Description:
> install the RPM of 3.22.26a. This is the third release I've used
> which continues to exhibit this error. I have reported it each time.
> Are you not going to fix it or should I just stop submitting
> bug reports about it?
>
> >How-To-Repeat:
> on nightly run, if logging is off, logrotate reports error of missing file
> >Fix:
> add "missingok" to the definition:
>
> *** #mysql~ Wed Sep 22 10:06:37 1999
> --- mysql Wed Sep 22 10:06:37 1999
> ***************
> *** 1,4 ****
> --- 1,5 ----
> /var/lib/mysql/mysql.log {
> + missingok
> rotate 3
> daily
> compress
>
> >Submitter-Id: <submitter ID>
> >Originator:
> >Organization:
>
> >MySQL support: extended email support
> >Synopsis: logrotate file missing "missingok" line
> >Severity: serious
> >Priority: high
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.22.26a (Source distribution) - RPM!!!
> >Server: /usr/bin/mysqladmin Ver 7.11 Distrib 3.22.26a, for pc-linux-gnu on i686
> TCX Datakonsult AB, by Monty
>
> Server version 3.22.26a
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /var/lib/mysql/mysql.sock
> Uptime: 16 hours 46 min 20 sec
>
> Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 2
> >Environment:
>
> System: Linux truffula.kciLink.com 2.2.10 #16 Tue Sep 21 16:18:46 EDT 1999 i686
> unknown
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs'
> CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions
> -fno-rtti -mpentium' LDFLAGS=''
> Configure command: ./configure --enable-shared --enable-assembler --disable-shared
> --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
> --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
> --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
> --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include
> --mandir=/usr/man
> Perl: This is perl, version 5.005_03 built for i386-linux
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread13931@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
--
Magnus Stenman mailto:stone@stripped http://www.hkust.se
...all in all, it's just another rule in the firewall. /Ping Flood