MySQL logs don't go to syslog are not in the diagnostic logs snapshot

[Bogdan Dobrelya]

MySQL logs are not in the diagnostic logs snapshot because syslog is not configured for MySQL deployment. The command "rgrep syslog /etc/mysql/" gives no results for nodes.

Example CI job https://ci.fuel-infra.org/job/master.fuel-library.pkgs.ubuntu.neutron_vlan_ha/8815/

UX is critical, we have found many bugs to mysql, and troubleshooting is impossible w/o logs

[Timur Nurlygayanov (tnurlygayanov)]

Should we assign 9.0 milestone to the issue?

[Bogdan Dobrelya (bogdando)]

This should be a regression after we switched to mysql-puppet, which was in the 9.0, IIRC. So, yes - we should

[Alex Schultz (alex-schultz)]

The configuration for syslog is still there for 9 and 10.

https://github.com/openstack/fuel-library/blob/stable/mitaka/deployment/puppet/osnailyfacter/manifests/database/database.pp#L145-L156

Please clarify this bug as I also have an environment with syslog configuration. The bug seems to indicate logs not sent to syslog are not captured which is different than the syslog configuration.

[mysqld_safe]
nice = 0
socket = /var/run/mysqld/mysqld.sock
syslog

[Peter Zhurba (pzhurba)]

As I can see there are 3 files on live environment

   nailgun:/var/log/remote/node-1.test.domain.local/mysqld.log
   nailgun:/var/log/remote/node-1.test.domain.local/mysqld_safe.log

and

 node-1:/var/log/mysqld.log

and there is nothing in snapshot

[Alex Schultz (alex-schultz)]

I'm not sure this was a regression as the configuration has been inconsistent for a long time. Rsyslog puts the logs in /var/log/mysqld{_safe}.log due to:

https://github.com/openstack/fuel-library/blob/master/deployment/puppet/openstack/templates/04-mysql.conf.erb

The shotgun capture only gets /var/log/mysql/ due to:

https://github.com/openstack/fuel-web/blob/master/nailgun/nailgun/settings.yaml#L899-L900

The mysql logs weren't even attempted to be captured prior to 9.0 until bug 1550984. I'll be marking this as a dupe of 1550984 and reopening because it was not properly implemented.