Mariadb container reported as unhealthy in non HA scenario

[Martin André]

In non HA case, mariadb check runs `mysql -e 'select 1'` as the mysql user but fails with:

ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NO)

We need to read the user/password values from the configuration files and pass them to the command line.

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/508504
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=3a9cfaa992e92423461d64f84d701336322bdd10
Submitter: Jenkins
Branch: master

commit 3a9cfaa992e92423461d64f84d701336322bdd10
Author: Martin Mágr <email address hidden>
Date: Fri Sep 29 14:07:46 2017 +0200

    Create mysql user for non-ha deployments

    Currently health check for mysql container reports unhealthy container
    because there is no 'mysql' user created. This patch creates the user
    during mysql_bootstrap without any permission, just to allow health
    check to connect to DB and run 'select 1'.

    Change-Id: Iab26da0d30939b219189d4e7beb2a61d456ab7c3
    Closes-Bug: #1718944

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/pike
Review: https://review.openstack.org/510550

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/510550
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=48157625981848fae97e24dc01da213ea7e3fb4a
Submitter: Jenkins
Branch: stable/pike

commit 48157625981848fae97e24dc01da213ea7e3fb4a
Author: Martin Mágr <email address hidden>
Date: Fri Sep 29 14:07:46 2017 +0200

    Create mysql user for non-ha deployments

    Currently health check for mysql container reports unhealthy container
    because there is no 'mysql' user created. This patch creates the user
    during mysql_bootstrap without any permission, just to allow health
    check to connect to DB and run 'select 1'.

    Change-Id: Iab26da0d30939b219189d4e7beb2a61d456ab7c3
    Closes-Bug: #1718944
    (cherry picked from commit 3a9cfaa992e92423461d64f84d701336322bdd10)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tripleo-heat-templates 7.0.2 release.

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tripleo-heat-templates 8.0.0.0b1 development milestone.