Bug#622119: [debian-mysql] Bug#622119: mysql-server: logrotatescript fails, nothing to do

2013-05-22 Thread Bjoern Boschman
Hi,

the problem comes from mysqladmin flush-logs

that logs have the wrong owner
this is somehow done wrong by the safe_mysqld script
this script reads my.cnf, identifies error_log and creates it as user root

solution:
chown them as user mysql

Cheers
B

Am 21.05.2013 18:01, schrieb Fabián Bonetti:
 Package: mysql-server-core-5.5
 Version: 5.5.31+dfsg-0+wheezy1
 Followup-For: Bug #622119
 
 /etc/cron.daily/logrotate:
 ^G/usr/bin/mysqladmin: refresh failed; error: 'Unknown error'
 error: error running shared postrotate script for '/var/log/mysql.log 
 /var/log/mysql/log-slow-queries.log '
 run-parts: /etc/cron.daily/logrotate exited with return code 1
 
 
 -- System Information:
 Debian Release: 7.0
   APT prefers stable-updates
   APT policy: (500, 'stable-updates'), (500, 'stable')
 Architecture: i386 (i686)
 
 Kernel: Linux 3.2.0-4-686-pae (SMP w/2 CPU cores)
 Locale: LANG=es_AR.UTF-8, LC_CTYPE=es_AR.UTF-8 (charmap=UTF-8)
 Shell: /bin/sh linked to /bin/dash
 
 Versions of packages mysql-server-core-5.5 depends on:
 ii  libaio1 0.3.109-3
 ii  libc6   2.13-38
 ii  libgcc1 1:4.7.2-5
 ii  libstdc++6  4.7.2-5
 ii  libwrap07.6.q-24
 ii  zlib1g  1:1.2.7.dfsg-13
 
 mysql-server-core-5.5 recommends no packages.
 
 mysql-server-core-5.5 suggests no packages.
 
 -- no debconf information
 
 ___
 pkg-mysql-maint mailing list
 pkg-mysql-ma...@lists.alioth.debian.org
 http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint
 


-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org



Bug#622119: [debian-mysql] Bug#622119: mysql-server: logrotatescript fails, nothing to do

2013-05-22 Thread Fabián Bonetti
Solved:

nano /etc/logrotate.d/mysql-server


/var/log/mysql.log /var/log/mysql/log-slow-queries.log {
su #new line work
daily
rotate 7


test 1: 

sudo /etc/cron.daily/logrotate

test 2:

#mysql_upgrade --force -u root -p

link: 
http://archives.gentoo.org/gentoo-user/msg_07889658c3c50f7a844b3739e364.xml

-- 
BSS Servicio :. $telnet bayresmail.com.ar 2323
MamaLibre Reader :. http://mamalibre.com.ar/reader/
Buscador del Sur :. http://buscar.mamalibre.com.ar/
Voip Mumble :. http://mumble.com.ar
Web Hosting :. http://mamalibre.com.ar
Red Social :. http://legadolibre.com.ar
Jabber/XMPP :. http://mamalibre.com.ar/xmpp/
MamaLibre, Casa en Lincoln, Ituzaingo 1085 CP6070, Buenos Aires, Argentina


pgpr8hVv9BZ2B.pgp
Description: PGP signature