/etc/cron.daily/logrotate

On Sun, Dec 02, 2007 at 12:49:20PM +0200, Sebastian Tennant wrote:
> Doh! The postrotate script is in /etc/logrotate.d/mysql-server:
>
> test -x /usr/bin/mysqladmin || exit 0
>
> # If this fails, check debian.conf!
> export HOME=/etc/mysql/my.cnf
> MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
> if [ -z "`$MYADMIN ping 2>/dev/null`" ]; then
> # Really no mysqld or rather a missing debian-sys-maint user?
> # If this occurs and is not a error please report a bug.
> if ps cax | grep -q mysqld; then
> exit 1
> fi
> else
> $MYADMIN flush-logs
> fi
>
> Now what could be causing the error? Hmm....
>

Well, run the script manually one line at a time. First, read
/etc/mysql/debian.cnf to determine under what user you should run
things (I've never used mysql). Also, read the mysqladmin man page.

Doug.

--

Hi all,

Just recently started receiving the following error report every
morning:

/etc/cron.daily/logrotate:
error: error running shared postrotate script for /var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log
run-parts: /etc/cron.daily/logrotate exited with return code 1

/etc/cron.daily/logrotate reads:

#!/bin/sh

test -x /usr/sbin/logrotate || exit 0
/usr/sbin/logrotate /etc/logrotate.conf

and /etc/logrotate.conf reads:

# see "man logrotate" for details
# rotate log files weekly
weekly

# keep 4 weeks worth of backlogs
rotate 4

# create new (empty) log files after rotating old ones
create

# uncomment this if you want your log files compressed
#compress

# packages drop log rotation information into this directory
include /etc/logrotate.d

# no packages own wtmp, or btmp -- we'll rotate them here
/var/log/wtmp {
missingok
monthly
create 0664 root utmp
rotate 1
}

/var/log/btmp {
missingok
monthly
create 0664 root utmp
rotate 1
}

# system-specific logs may be configured here

Any ideas why this error is occuring and how to solve it?

Sebastian

--