SYSTEM WARNING: 'file_get_contents(https://www.clearos.com/?rendertype=json&get=header): failed to open stream: Connection refused' in '/var/www/virtual/newwrapper/cf_topmenu.inc' line 5

Anonymous | Login

2024-12-22 05:15 MST

Project: All Projects ClearCenter ClearOS

Main | My View | View Issues | Change Log | Roadmap | Repositories

View Issue Details [ Jump to Notes ]				[ Issue History ] [ Print ]
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.
Tags	No tags attached.
Attached Files

Relationships

Relationships

Notes
(0000836) NickH (developer) 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 (developer) 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 (developer) 2019-03-12 04:21	Migrated to: https://gitlab.com/clearos/clearfoundation/app-mariadb/issues/1 [^]

Notes

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

Issue History