Rsyslog doesn't have write permission to /var/log/mysql/ directory
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Fuel for OpenStack |
Fix Released
|
High
|
Maksim Malchuk | ||
Mitaka |
Fix Released
|
High
|
Maksim Malchuk |
Bug Description
Detailed bug description:
In Mirantis OpenStack 9.0 Rsyslog does not have write permission to /var/log/mysql/ directory. User 'syslog' belongs to 'adm' group, but /var/log/mysql/ directory has only r.x attributes for this group.
Therefore Rsyslog cannot create MySQL log files.
This bug appeared in the process of solving next bug: https:/
Steps to reproduce:
Check existence of MySQL log file /var/log/
Expected results:
MySQL logs should be in log file /var/log/
Actual result:
Log file /var/log/
Reproducibility:
Reproduced on several MOS 9 environments
Workaround:
# chmod 770 /var/log/mysql/
Impact:
Currently we don’t have any MySQL logs in all deployments (apart from the error.log because it was created at the time of deployment and does not contain any useful info).
This is critical bug because it makes difficult to analyze MySQL issues.
This bug also found on customer environment
Description of the environment:
Operation system: Ubuntu 14.04
Versions of components: MOS 9.0
Additional information:
-------
[root@fuel ~]# cat /etc/fuel_build_id
495
[root@fuel ~]# cat /etc/fuel_release
9.0
[root@fuel ~]# cat /etc/fuel_
mitaka-9.0
-------
root@node-1:~# id syslog
uid=101(syslog) gid=104(syslog) groups=
-------
root@node-1:~# ll /var/log/mysql/
total 16
drwxr-x--- 2 mysql adm 4096 Aug 22 11:50 ./
drwxrwxr-x 27 root syslog 4096 Aug 22 10:49 ../
-rw-r----- 1 mysql adm 6758 Aug 20 20:06 error.log
-------
root@node-1:~# cat /etc/rsyslog.
# This file is managed by Puppet, changes may be overwritten
# managed by puppet
### collect mysql* logs of all levels in /var/log/mysqld.log
if ($programname == 'mysql' \
or $programname == 'mysqld' \
or $programname == 'mysqld_safe' \
or $programname == 'mysql_slow' \
or $programname == 'mysql-wss') \
then -/var/log/
### stop further processing for the matched entries
& ~
-------
Rsyslog debug info:
0835.920442032:
0835.920443874:
0835.920445619:
0835.920447393:
0835.920449600:
0835.920452931:
0835.920458135:
0835.920467866:
0835.920472950:
tags: | added: customer-found |
summary: |
- Rsyslog doesn't has write permission to /var/log/mysql/ directory + Rsyslog doesn't have write permission to /var/log/mysql/ directory |
tags: | added: area-library |
tags: | added: ct2 support |
description: | updated |
no longer affects: | fuel/newton |
Changed in fuel: | |
status: | New → Confirmed |
Fix proposed to branch: master /review. openstack. org/359438
Review: https:/