chmod 2750 on /var/log/mysql
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.7 (Ubuntu) |
New
|
Medium
|
Unassigned |
Bug Description
The /var/log/mysql from ubuntu 1604 has now the 755 permission with mysql:adm. When we set up the slow log query inside the /var/log/
Then, the users inside the adm group cannot check inside the log without using root privileges.
Are there any reasons why this has been removed in 1604 : chmod 2750 /var/log/mysql ?
In ubuntu 1404:
flebel@
mysql-server-
mysql-server-
mysql-server-
mysql-server-
mysql-server-
mysql-server-
mysql-server-
mysql-server-
root@a649df1b27
drwxr-s--- 2 mysql adm 4 Jan 19 18:35 mysql/
-rw-rw---- 1 mysql adm 7541 Jan 19 18:35 mysql/error.log
-rw-rw---- 1 mysql adm 182 Jan 19 18:35 mysql/slow.log
root@a649df1b27
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 14.04.3 LTS
Release: 14.04
Codename: trusty
In ubuntu 1604:
flebel@
mysql-server-
mysql-server-
mysql-server-
mysql-server-
mysql-server-
mysql-server-
root@0c341d710c
drwxr-x--- 2 mysql adm 4 Jan 19 18:36 mysql/
-rw-r----- 1 mysql adm 4271 Jan 19 18:36 mysql/error.log
-rw-r----- 1 mysql mysql 182 Jan 19 18:36 mysql/slow.log
root@0c341d710c
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.1 LTS
Release: 16.04
Codename: xenial
Changed in mysql-5.7 (Ubuntu): | |
importance: | Undecided → Medium |
Hi,
thank you for your report and your help to make Ubuntu better.
I came by trying to triage this bug, but since this more or less starts with a question on the reasoning of changes to mysql packaging "Are there any reasons why this has been removed in 1604 : chmod 2750 /var/log/mysql ?" I subscribed a few people who should know better than me and hopefully can provide an answer.