Issue

Description of problem: The /etc/logrotate.d/mysqld configuration file has the following content: For the mysqladmin commands below to work, root account password is required. Use mysql_config_editor(1) to store authentication credentials in the encrypted login path file ~/.mylogin.cnf # Example usage: # mysql_config_editor set --login-path=client --user=root --host=localhost --password # When these actions has been done, un-comment the following to enable rotation of mysqld's log error. However, on RHEL 9 logrotate no longer runs under cron but rather under systemd. As such there is no $HOME variable for the logrotate process, which causes in turn for mysql_config_editor to have no $HOME variable. This has the effect of making /root/.mylogin.cnf to never be read so only this gets printed in the logs: logrotate[179140]: error: 'Access denied for user 'root'@'localhost' (using password: NO)' logrotate[179136]: error: error running non-shared postrotate script for /var/log/mysql/mysqld.log of '/var/log/mysql/mysqld.log ' The workaround for this is to specify the HOME variable before both mysqladmin commands thus: if test -x /usr/bin/mysqladmin && \ HOME=/root /usr/bin/mysqladmin ping &>/dev/null then HOME=/root /usr/bin/mysqladmin flush-logs fi Version-Release number of selected component (if applicable): mysql-server-8.0.32-1.el9_2.x86_64 How reproducible: Every time Steps to Reproduce: 1. Uncomment the /var/log/mysql/mysqld.log entry from /etc/logrotate.d/mysqld. 2. Run the following command as advised in the logrotate configuration file: mysql_config_editor set --login-path=client --user=root --host=localhost --password 3. Wait for logrotate to run Actual results: mysqld log does not rotate properly. Expected results: mysqld log should rotate properly. Additional info: This was not an issue in RHEL 7/8 as logrotate ran under cron and, while cron does have a very limited environment, the $HOME variable was being passed to logrotate. Also note, the package is mysql-server but for some reason it is not present in the component list.

Release Notes

No. of Comments

Resolution

Done-Errata