(Ubuntu only) mysql syslog logs are missing on the master node

[Vladimir Kuklin]

deploy an HA environment with Ubuntu. Look into logs on the master node. There are no mysql logs. This needs to be fixed.

[Sergii Golovatiuk (sgolovatiuk)]

This affects Ubuntu only. Centos based environments have logs on master nodes.

[Bogdan Dobrelya (bogdando)]

No issues with mysql logs from centos nodes, renaming

[Bogdan Dobrelya (bogdando)]

The root cause is conflicting configuration artifacts shipped with mysql5.6 packages.
Once I deleted /etc/mysql/conf.d/{my5.6.cnf,mysqld_safe_syslog.cnf} and /etc/mysql/my.cnf and restarted mysql service, the logs appeared in syslog.
Redirecting to OSCI team, because of the issue is packaging related.

[OSCI Robot (oscirobot)]

Package MySQL-wsrep has been built from changeset: http://gerrit.mirantis.com/20239
DEB Repository URL: http://osci-obs.vm.mirantis.net:82/ubuntu-fuel-5.1-stable-20239/ubuntu
You can build an ISO with this package:
make iso EXTRA_DEB_REPOS="http://osci-obs.vm.mirantis.net:82/ubuntu-fuel-5.1-stable-20239/ubuntu /"

[OSCI Robot (oscirobot)]

Package MySQL-wsrep has been built from changeset: http://gerrit.mirantis.com/20239
DEB Repository URL: http://osci-obs.vm.mirantis.net:82/ubuntu-fuel-5.1-stable/ubuntu
You can build an ISO with this package:
make iso EXTRA_DEB_REPOS="http://osci-obs.vm.mirantis.net:82/ubuntu-fuel-5.1-stable/ubuntu /"

[Vitaly Parakhin (vparakhin)]

fix is on mirrors

[Bogdan Dobrelya (bogdando)]

Reopened due to unfinished fix - etc/mysql/my.cnf must be absent at Ubuntu as well

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/114911

[Bogdan Dobrelya (bogdando)]

OSCI team, please make sure there is no /etc/mysql/my.cnf file installed from mysql-common as well:
For now we have:

rgrep 'my.cnf' /var/lib/dpkg/info/mysql*
/var/lib/dpkg/info/mysql-common.conffiles:/etc/mysql/my.cnf
/var/lib/dpkg/info/mysql-common.list:/etc/mysql/my.cnf

dpkg -L mysql-common | grep cnf
/etc/mysql/my.cnf

But according to https://bugs.launchpad.net/fuel/+bug/1349601/comments/3 this file should not be installed from any packages...

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/114911
Committed: https://git.openstack.org/cgit/stackforge/fuel-library/commit/?id=b5d69c3031257e82ace36f8242422b0cdc7d203f
Submitter: Jenkins
Branch: master

commit b5d69c3031257e82ace36f8242422b0cdc7d203f
Author: Bogdan Dobrelya <email address hidden>
Date: Mon Aug 18 11:52:14 2014 +0300

    Fix conflicting my.cnf for Ubuntu

    In order to enable mysql syslog logging for Ubuntu,
    ensure mysql conf file path is /etc/my.cnf instead
    of /etc/mysql/my.cnf default.

    Closes-bug: #1349601

    Change-Id: I31757e622a412623e5e4624008aaaf9be4280636
    Signed-off-by: Bogdan Dobrelya <email address hidden>

[Bogdan Dobrelya (bogdando)]

Ok, the next step - and perhaps the last one - is to make Puppet ensure /etc/mysql/my.cnf will be absent. Looks like we should not do it by changing the mysql-common package.

[Roman Vyalov (r0mikiam)]

very bad idea delete config in packages . please remove config in puppet manifest

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/115282

[Bogdan Dobrelya (bogdando)]

https://review.openstack.org/115282 fixes HA case for Ubuntu mysql syslogging and also allows mysql in simple deployments to be configured in usual for ubuntu manner. But logging to syslog is still broken for simple case.

[Bogdan Dobrelya (bogdando)]

https://bugs.launchpad.net/fuel/+bug/1359205 related bug for simple deployments

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/115282
Committed: https://git.openstack.org/cgit/stackforge/fuel-library/commit/?id=7507eb0b0fe2a673fefdb55f0e4b3c3509245ed8
Submitter: Jenkins
Branch: master

commit 7507eb0b0fe2a673fefdb55f0e4b3c3509245ed8
Author: Bogdan Dobrelya <email address hidden>
Date: Tue Aug 19 16:19:23 2014 +0300

    Ensure /etc/mysql/my.cnf removal

    Additional fix to conflicting mysql config files
    in order to fix mysql syslog logging in Ubuntu.
    For simple deployment (custom_setup_class undef):
    * /etc/mysql/my.conf should be used in Ubuntu
    For HA case for Centos/Ubuntu:
    * /etc/mysql/my.conf should be absent
    * /etc/my.cnf should be used
    (Note that changes are Fuel OSCI packaging specific)

    Closes-bug: #1349601

    Change-Id: I56c1b5ebca2553d341fe0498451075294f3e651f
    Signed-off-by: Bogdan Dobrelya <email address hidden>