SYSTEM WARNING: 'file_get_contents(): SSL: Connection reset by peer' in '/var/www/virtual/newwrapper/cf_topmenu.inc' line 5

SYSTEM WARNING: 'file_get_contents(): Failed to enable crypto' in '/var/www/virtual/newwrapper/cf_topmenu.inc' line 5

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

ClearOS Bug Tracker


View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000225ClearOSapp-mysql - MySQL Databasepublic2011-02-06 07:522019-03-12 04:21
ReporterNickH 
Assigned To 
PrioritynormalSeveritytweakReproducibilityhave not tried
StatusclosedResolutionsuspended 
PlatformOSOS Version
Product Version5.2-SP1 
Target VersionFixed in Version 
Summary0000225: MySQL log does not rotate
DescriptionI 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.
TagsNo tags attached.
Attached Files

- 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 [^]

- 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

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