[Ubuntu-BR] Duvidas com logrotate

Pedro Oliveira pedroprt em gmail.com
Segunda Novembro 16 14:18:34 UTC 2009


Ola pessoal

ativei o log do mysql e estou tentando criar um log vazio sempre que atingir
2M

o meu arquivo conf está assim:
inicio ******************************
************************************************
/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log {
        daily
        rotate 7
        missingok
        create 640 mysql adm
        size 2M
#       compress
        sharedscripts
        postrotate
                test -x /usr/bin/mysqladmin || exit 0
                MYADMIN="/usr/bin/mysqladmin
--defaults-file=/etc/mysql/debian.cnf"
                if [ -z "`$MYADMIN ping 2>/dev/null`" ]; then
                  if ps cax | grep -q mysqld; then
                    exit 1
                  fi
                else
                  $MYADMIN flush-logs
                fi
        endscript
}
fim
****************************************************************************

mas quando executo :

sudo logrotate -df /etc/logrotate.d/mysql-server, apesar de dar a mensagem
que rodou e criou um novo log, nada acontece

inicio
*******************************************************************************

root em xxxcnn000:/etc/logrotate.d# sudo logrotate -df
/etc/logrotate.d/mysql-server
sudo: unable to resolve host xxxcnn0000.hospedagemdesites.ws xxxcnn0000
reading config file /etc/logrotate.d/mysql-server
reading config info for /var/log/mysql/mysql.log
/var/log/mysql/mysql-slow.log

Handling 1 logs

rotating pattern: /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log
forced from command line (7 rotations)
empty log files are rotated, old logs are removed
considering log /var/log/mysql/mysql.log
  log needs rotating
considering log /var/log/mysql/mysql-slow.log
  log needs rotating
rotating log /var/log/mysql/mysql.log, log->rotateCount is 7
renaming /var/log/mysql/mysql.log.7 to /var/log/mysql/mysql.log.8
(rotatecount 7, logstart 1, i 7),
renaming /var/log/mysql/mysql.log.6 to /var/log/mysql/mysql.log.7
(rotatecount 7, logstart 1, i 6),
renaming /var/log/mysql/mysql.log.5 to /var/log/mysql/mysql.log.6
(rotatecount 7, logstart 1, i 5),
renaming /var/log/mysql/mysql.log.4 to /var/log/mysql/mysql.log.5
(rotatecount 7, logstart 1, i 4),
renaming /var/log/mysql/mysql.log.3 to /var/log/mysql/mysql.log.4
(rotatecount 7, logstart 1, i 3),
renaming /var/log/mysql/mysql.log.2 to /var/log/mysql/mysql.log.3
(rotatecount 7, logstart 1, i 2),
renaming /var/log/mysql/mysql.log.1 to /var/log/mysql/mysql.log.2
(rotatecount 7, logstart 1, i 1),
renaming /var/log/mysql/mysql.log.0 to /var/log/mysql/mysql.log.1
(rotatecount 7, logstart 1, i 0),
renaming /var/log/mysql/mysql.log to /var/log/mysql/mysql.log.1
creating new log mode = 0640 uid = 107 gid = 4
removing old log /var/log/mysql/mysql.log.8
rotating log /var/log/mysql/mysql-slow.log, log->rotateCount is 7
renaming /var/log/mysql/mysql-slow.log.7 to /var/log/mysql/mysql-slow.log.8
(rotatecount 7, logstart 1, i 7),
renaming /var/log/mysql/mysql-slow.log.6 to /var/log/mysql/mysql-slow.log.7
(rotatecount 7, logstart 1, i 6),
renaming /var/log/mysql/mysql-slow.log.5 to /var/log/mysql/mysql-slow.log.6
(rotatecount 7, logstart 1, i 5),
renaming /var/log/mysql/mysql-slow.log.4 to /var/log/mysql/mysql-slow.log.5
(rotatecount 7, logstart 1, i 4),
renaming /var/log/mysql/mysql-slow.log.3 to /var/log/mysql/mysql-slow.log.4
(rotatecount 7, logstart 1, i 3),
renaming /var/log/mysql/mysql-slow.log.2 to /var/log/mysql/mysql-slow.log.3
(rotatecount 7, logstart 1, i 2),
renaming /var/log/mysql/mysql-slow.log.1 to /var/log/mysql/mysql-slow.log.2
(rotatecount 7, logstart 1, i 1),
renaming /var/log/mysql/mysql-slow.log.0 to /var/log/mysql/mysql-slow.log.1
(rotatecount 7, logstart 1, i 0),
renaming /var/log/mysql/mysql-slow.log to /var/log/mysql/mysql-slow.log.1
creating new log mode = 0640 uid = 107 gid = 4
removing old log /var/log/mysql/mysql-slow.log.8
running shared postrotate script
running script with arg /var/log/mysql/mysql.log
/var/log/mysql/mysql-slow.log : "
                test -x /usr/bin/mysqladmin || exit 0

                # If this fails, check debian.conf!
                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
"
fim
*************************************************************************************************************


dá um monte de mensagens que está renomeando os arquivos :

renaming /var/log/mysql/mysql.log.7 to /var/log/mysql/mysql.log.8
(rotatecount 7, logstart 1, i 7),

mas esses arquivos nem existem ... e o arquivo que eu queria 'rodar'
(mysql.log) continua lá com mais de 6M


alguém sabe como fazer o logrotate funcionar direito ?


obrigado


[]s Pedro Oliveira



More information about the ubuntu-br mailing list