Using external network for MysqlNetwork results in deployment failure

[Alex Schultz]

Description of problem:
Setting MysqlNetwork: external caused deployment to fail at overcloud.AllNodesDeploySteps.ControllerDeployment_Step1

How reproducible:
network-environment.yaml
~~~
parameter_defaults:
(...)
  ServiceNetMap:
    MysqlNetwork: external
(...)
~~~

Expected results:
successful deployment

Additional info:
It works with
~~~
ServiceNetMap:
    MysqlNetwork: ctlplane
~~~

Actual results:
~~~
 heat deployment-show 26755014-9289-49bf-afeb-bdb00c70d21e | sed 's/\\n/\n/g'
(...)
at http://mariadb.org/jira\u001b[0m
\u001b[1;31mError: /Stage[main]/Mysql::Server::Installdb/Mysql_datadir[/var/lib/mysql]/ensure: change from absent to present failed: Execution of '/usr/bin/mysql_install_db --defaults-extra-file=/etc/my.cnf.d/galera.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql' returned 1: Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
170610 18:56:19 [ERROR] /usr/libexec/mysqld: option '--bind-address' requires an argument
170610 18:56:19 [ERROR] Aborting

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/473884
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=426de202880c890360bd446907aca44ca1e73a03
Submitter: Jenkins
Branch: master

commit 426de202880c890360bd446907aca44ca1e73a03
Author: Alex Schultz <email address hidden>
Date: Tue Jun 13 09:39:11 2017 -0600

    Add fqdn_external

    In newton, we used to construct the fqdn_$NETWORK in puppet-tripleo for
    external, internal_api, storage, storage_mgmt, tenant, management, and
    ctrlplane. When this was moved into THT, we accidently dropped external
    which leads to deployment failures if a service is moved to the external
    network and the configuration consumes the fqdn_external hiera key.
    Specifically this is reproduced if the MysqlNetwork is switch to to
    exernal, then the deployment fails because the bind address which is set
    to use fqdn_external is blank.

    Change-Id: I01ad0c14cb3dc38aad7528345c928b86628433c1
    Closes-Bug: #1697722

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/ocata
Review: https://review.openstack.org/474196

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/474196
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=cd7b49795daa36f95ccf966a134af6dd696ab67b
Submitter: Jenkins
Branch: stable/ocata

commit cd7b49795daa36f95ccf966a134af6dd696ab67b
Author: Alex Schultz <email address hidden>
Date: Tue Jun 13 09:39:11 2017 -0600

    Add fqdn_external

    In newton, we used to construct the fqdn_$NETWORK in puppet-tripleo for
    external, internal_api, storage, storage_mgmt, tenant, management, and
    ctrlplane. When this was moved into THT, we accidently dropped external
    which leads to deployment failures if a service is moved to the external
    network and the configuration consumes the fqdn_external hiera key.
    Specifically this is reproduced if the MysqlNetwork is switch to to
    exernal, then the deployment fails because the bind address which is set
    to use fqdn_external is blank.

    Change-Id: I01ad0c14cb3dc38aad7528345c928b86628433c1
    Closes-Bug: #1697722
    (cherry picked from commit 426de202880c890360bd446907aca44ca1e73a03)

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tripleo-heat-templates 7.0.0.0b3 development milestone.