MySQL host address is not set properly for all .my.cnf files

Bug #1487353 reported by Jesse Pretorius
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
OpenStack-Ansible
Fix Released
Low
Jesse Pretorius
Kilo
Fix Released
Low
Jesse Pretorius
Trunk
Fix Released
Low
Jesse Pretorius

Bug Description

Wherever the .my.cnf file is dropped on a host or container the host address is set to 127.0.0.1 instead of the internal lb up address.

Changed in openstack-ansible:
status: New → In Progress
Revision history for this message
Jesse Pretorius (jesse-pretorius) wrote :
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to os-ansible-deployment (master)

Reviewed: https://review.openstack.org/207939
Committed: https://git.openstack.org/cgit/stackforge/os-ansible-deployment/commit/?id=93f89e25ce92b5e51f79e6a01ba24f2daacb8aa2
Submitter: Jenkins
Branch: master

commit 93f89e25ce92b5e51f79e6a01ba24f2daacb8aa2
Author: Jesse Pretorius <email address hidden>
Date: Fri Jul 31 15:51:06 2015 +0100

    Add galera_address to all playbooks installing galera_client

    This patch includes the galera_address var for each playbook
    that deploys a role depending on galera_client and thereby
    dropping a .my.cnf onto the target.

    Prior to this patch the .my.cnf would be dropped with the
    galera_client's role default of 127.0.0.1 as the host address.

    The address of 127.0.0.1 is intentionally left to deploy on
    the galera servers so that the .my.cnf will be configured to
    interact with the local database.

    Change-Id: Ife33c68d825ecf1e6cdb6784802e9a099eb54289
    Closes-Bug: #1487353

Changed in openstack-ansible:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to os-ansible-deployment (kilo)

Fix proposed to branch: kilo
Review: https://review.openstack.org/221301

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to os-ansible-deployment (kilo)

Reviewed: https://review.openstack.org/221301
Committed: https://git.openstack.org/cgit/stackforge/os-ansible-deployment/commit/?id=f810da863fee563b35fa3421b86000c2288b3e55
Submitter: Jenkins
Branch: kilo

commit f810da863fee563b35fa3421b86000c2288b3e55
Author: Jesse Pretorius <email address hidden>
Date: Fri Jul 31 15:51:06 2015 +0100

    Add galera_address to all playbooks installing galera_client

    This patch includes the galera_address var for each playbook
    that deploys a role depending on galera_client and thereby
    dropping a .my.cnf onto the target.

    Prior to this patch the .my.cnf would be dropped with the
    galera_client's role default of 127.0.0.1 as the host address.

    The address of 127.0.0.1 is intentionally left to deploy on
    the galera servers so that the .my.cnf will be configured to
    interact with the local database.

    Change-Id: Ife33c68d825ecf1e6cdb6784802e9a099eb54289
    Closes-Bug: #1487353
    (cherry picked from commit 93f89e25ce92b5e51f79e6a01ba24f2daacb8aa2)

Revision history for this message
Davanum Srinivas (DIMS) (dims-v) wrote : Fix included in openstack/openstack-ansible 11.2.11

This issue was fixed in the openstack/openstack-ansible 11.2.11 release.

Revision history for this message
Doug Hellmann (doug-hellmann) wrote : Fix included in openstack/openstack-ansible 11.2.12

This issue was fixed in the openstack/openstack-ansible 11.2.12 release.

Revision history for this message
Davanum Srinivas (DIMS) (dims-v) wrote : Fix included in openstack/openstack-ansible 11.2.14

This issue was fixed in the openstack/openstack-ansible 11.2.14 release.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.