Bug 904061

Summary:	missing logrotate script
Product:	Red Hat Enterprise Linux 6	Reporter:	Karel Volný <kvolny>
Component:	mysql	Assignee:	Honza Horak <hhorak>
Status:	CLOSED ERRATA	QA Contact:	qe-baseos-daemons
Severity:	medium	Docs Contact:
Priority:	high
Version:	6.4	CC:	azelinka, byte, hhorak, lnovich, ovasik, prabhakar_pujeri, praiskup, thomas_chenault
Target Milestone:	rc
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	mysql-5.1.71-1.el6	Doc Type:	Bug Fix
Doc Text:	Cause: Logrotate script was missing in mysql-server Consequence: Logs rotation had to be configured manually Fix: mysql-server provides logrotate script now Result: users can use logrotate to log their mysqld.log file after un-commenting lines in the logrotate script	Story Points:	---
Clone Of:	904059	Environment:
Last Closed:	2013-11-21 20:41:09 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	904059
Bug Blocks:	960054

Description Karel Volný 2013-01-25 11:56:00 UTC

+++ This bug was initially created as a clone of Bug #904059 +++

Description of problem:
Mysql packages do not provide logrotate configuration file.
Looking at bug #647223 comment #16 I understand that as it should be included after the problem with rotating logs gets fixed. The problem got fixed already but we still do not provide /etc/logrotate.d/mysqld

Version-Release number of selected component (if applicable):
mysql-5.0.95-5.el5_9

How reproducible:
always

Steps to Reproduce:
1. yum install mysql-server
2. uncomment the configuration in /etc/logrotate.d/mysqld
3. logrotate -f /etc/logrotate.d/mysqld

Actual results:
2. no file to edit
3. error: cannot stat /etc/logrotate.d/mysqld: No such file or directory

Expected results:
no error; once the server runs and writes logfile, logs get rotated after logrotate call

Additional info:

Comment 2 Tom Lane 2013-01-25 14:53:29 UTC

It looks like we fixed this in Fedora and RHEL5, but the fix never made it into the RHEL6 branch ... which makes this a regression from RHEL5 to RHEL6.  Oops.

Comment 12 Honza Horak 2013-08-09 08:23:24 UTC

How to reproduce:
1) (uncomment related lines in /etc/logrotate.d/mysqld)
2) # logrotate /etc/logrotate.d/mysqld -f
3) # echo $?
4) # ls -l /var/log/mysqld.log*

Actual results:
error: cannot stat /etc/logrotate.d/mysqld: No such file or directory
1
-rw-r-----. 1 mysql mysql 25910 Aug  9 10:07 /var/log/mysqld.log

Expected results:
0
-rw-r-----. 1 mysql mysql    0 Aug  9 10:14 /var/log/mysqld.log
-rw-r-----. 1 mysql mysql 2546 Aug  9 10:14 /var/log/mysqld.log.1.gz

Comment 14 errata-xmlrpc 2013-11-21 20:41:09 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHBA-2013-1647.html