ClearFoundation Tracker - ClearOS |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0000225 | ClearOS | app-mysql - MySQL Database | public | 2011-02-06 07:52 | 2019-03-12 04:21 |
|
| Reporter | NickH | |
| Assigned To | | |
| Priority | normal | Severity | tweak | Reproducibility | have not tried |
| Status | closed | Resolution | suspended | |
| Platform | | OS | | OS Version | |
| Product Version | 5.2-SP1 | |
| Target Version | | Fixed in Version | | |
|
| Summary | 0000225: MySQL log does not rotate |
| Description | I recently noticed in 07/2009 mysqld.log ceased to rotate. This was probably in the transition from CC4.3 to CC5.0.
There is no entry in logrotate.conf or /etc/logrotate.d to force log rotation. It is the same on both my production server and my play VM. |
| Steps To Reproduce | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2011-02-06 07:52 | NickH | New Issue | |
| 2011-02-07 20:34 | user2 | Status | new => acknowledged |
| 2013-02-02 09:42 | user2 | Target Version | => 6.4.0 Beta 2 |
| 2013-02-21 20:00 | user2 | Target Version | 6.4.0 Beta 2 => 6.4.0 |
| 2013-03-14 11:56 | user2 | Target Version | 6.4.0 => 6.4.0 Updates |
| 2013-04-30 14:29 | user2 | Issue cloned: 0001129 | |
| 2013-05-01 05:07 | NickH | Note Added: 0000836 | |
| 2013-05-01 05:08 | NickH | Note Added: 0000838 | |
| 2013-07-29 13:58 | user2 | Target Version | 6.4.0 Updates => 6 Future |
| 2014-02-10 08:03 | user2 | Note Added: 0001143 | |
| 2014-02-10 08:04 | user2 | Target Version | 6 Future => 6.5.0 Updates |
| 2014-02-10 08:05 | user2 | Target Version | 6.5.0 Updates => 6.6.0 Beta 1 |
| 2014-05-08 08:09 | user2 | Target Version | 6.6.0 Beta 1 => 6.6.0 Beta 2 |
| 2014-05-28 20:04 | user2 | Note Added: 0001187 | |
| 2014-05-30 13:46 | user2 | Severity | trivial => tweak |
| 2014-06-23 10:34 | user2 | Target Version | 6.6.0 Beta 2 => 6.6.0 Beta 3 |
| 2014-08-27 14:23 | user2 | Target Version | 6.6.0 Beta 3 => 7.0.0 Alpha 2 |
| 2014-10-21 15:28 | user2 | Target Version | 7.0.0 Alpha 2 => 7.1.0 Beta 2 |
| 2015-01-29 12:47 | user2 | Note Added: 0001357 | |
| 2015-01-29 12:47 | user2 | Target Version | 7.1.0 Beta 2 => |
| 2019-03-12 04:21 | NickH | Note Added: 0010911 | |
| 2019-03-12 04:21 | NickH | Status | acknowledged => closed |
| 2019-03-12 04:21 | NickH | Resolution | open => suspended |
|
Notes |
|
|
(0000836)
|
|
NickH
|
|
2013-05-01 05:07
|
|
system-mysql.log used to rotate in 5.2 but with a logrotate function a bit different from normal logrotate functions:
/var/log/system-mysql/mysqld.log {
missingok
create 0640 system-mysql system-mysql
prerotate
[ -e /var/lock/subsys/system-mysqld ] && /bin/kill -HUP `cat /var/run/system-mysqld/system-mysqld.pid 2> /dev/null ` || /bin/true
endscript
postrotate
[ -e /var/lock/subsys/system-mysqld ] && /bin/kill -HUP `cat /var/run/system-mysqld/system-mysqld.pid 2> /dev/null ` || /bin/true
endscript
} |
|
|
|
(0000838)
|
|
NickH
|
|
2013-05-01 05:08
|
|
|
Sorry. Comment added to wrong bug |
|
|
|
(0001143)
|
|
user2
|
|
2014-02-10 08:03
|
|
This was semi-resolved in a recent upstream update. See "Details" section in upstream errata report:
https://rhn.redhat.com/errata/RHBA-2013-1647.html [^]
The script to rotate the logs is included, but disabled. We'll add a little hook in the ClearOS MySQL app to enable/disable the script from the GUI. |
|
|
|
(0001187)
|
|
user2
|
|
2014-05-28 20:04
|
|
The upstream logrotate configlet is below. As you can see, the script requires the database root password to be stored in /root/.my.cnf. That's messy. Instead of requiring the password, a full MySQL restart could be done instead? That's not ideal either.
// Begin configlet
# This logname can be set in /etc/my.cnf
# by setting the variable "err-log"
# in the [safe_mysqld] section as follows:
#
# [safe_mysqld]
# err-log=/var/log/mysqld.log
#
# If the root user has a password you have to create a
# /root/.my.cnf configuration file with the following
# content:
#
# [mysqladmin]
# password = <secret>
# user= root
#
# where "<secret>" is the password.
#
# ATTENTION: This /root/.my.cnf should be readable ONLY
# for root !
# Then, un-comment the following lines to enable rotation of mysql's log file:
#/var/log/mysqld.log {
# create 640 mysql mysql
# notifempty
# daily
# rotate 3
# missingok
# compress
# postrotate
# # just if mysqld is really running
# if test -x /usr/bin/mysqladmin && \
# /usr/bin/mysqladmin ping &>/dev/null
# then
# /usr/bin/mysqladmin flush-logs
# fi
# endscript
#} |
|
|
|
(0001357)
|
|
user2
|
|
2015-01-29 12:47
|
|
|
Due to the added complexity, we're bumping this request to a later release. |
|
|
|
(0010911)
|
|
NickH
|
|
2019-03-12 04:21
|
|
|