[MDEV-12521] SET slow_query_log_file Permission denied Created: 2017-04-18  Updated: 2017-05-18  Resolved: 2017-05-18

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.1.22
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: dic (Inactive) Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

CentOS Linux release 7.3.1611 (Core)


 Description   

MariaDB [(none)]> set global slow_query_log_file = '/var/log/mysql/slow.log';
ERROR 29 (HY000): File '/var/log/mysql/slow.log' not found (Errcode: 13 "Permission denied")

 Comments   
Comment by Daniel Black [ 2017-04-18 ]

Is /var/log/mysql owned my the mysql user with a selinux type of mysqld_log_t?

To fix the selinux type read https://mariadb.com/kb/en/mariadb/what-to-do-if-mariadb-doesnt-start/#selinux-and-mariadb-path-changes

Generated at Thu Feb 08 07:58:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.