OpenStack DBaaS (Trove)

Mysql instance create failed when enable skip-name-resolve in config.template

Bug #1729225 reported by chengyang
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
Fix Released
Medium
chengyang

Bug Description

In the guestagent code, it create os_admin user only grant privileges on host:localhost, but use host:127.0.0.1 to connect to mysql. If add skip-name-resolve in config.template, will create failed because error: Access denied for user 'os_admin'@'127.0.0.1' (using password: YES）

chengyang (chengyang)
Changed in trove:
assignee: nobody → chengyang (chengyang)
summary: - Instance create failed when enable skip-name-resolve in config.template
+ Mysql Instance create failed when enable skip-name-resolve in
+ config.template
summary: - Mysql Instance create failed when enable skip-name-resolve in
+ Mysql instance create failed when enable skip-name-resolve in
config.template
Manoj Kumar (manojnkumar)
Changed in trove:
importance: Undecided → Medium
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (master)

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to trove (master)

Reviewed: https://review.openstack.org/517340
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=43c545ac84f29908a2e5396d07bd3de38e3a1101
Submitter: Zuul
Branch: master

commit 43c545ac84f29908a2e5396d07bd3de38e3a1101
Author: chengyang <email address hidden>
Date: Thu Nov 2 22:41:08 2017 +0800

    Fix mysql instance create failed when enable skip-name-resolve

    In the guestagent code, it create os_admin user only grant
    privileges on host:localhost, but use host:127.0.0.1 to
    connect to mysql. Modify host privileges grant on to 127.0.0.1
    to avoid create instance failed when enable skip-name-resolve
    in config file.

    Change-Id: Ifa69461c8a55464f88aec001d067450eedccf172
    Closes-bug: #1729225

Changed in trove:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (stable/pike)

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/trove 9.0.0.0b3

This issue was fixed in the openstack/trove 9.0.0.0b3 development milestone.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to trove (stable/pike)

Reviewed: https://review.openstack.org/518642
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=d45716a9fe1662f250b000864f03452e25a7ac76
Submitter: Zuul
Branch: stable/pike

commit d45716a9fe1662f250b000864f03452e25a7ac76
Author: chengyang <email address hidden>
Date: Thu Nov 2 22:41:08 2017 +0800

    Fix mysql instance create failed when enable skip-name-resolve

    In the guestagent code, it create os_admin user only grant
    privileges on host:localhost, but use host:127.0.0.1 to
    connect to mysql. Modify host privileges grant on to 127.0.0.1
    to avoid create instance failed when enable skip-name-resolve
    in config file.

    Change-Id: Ifa69461c8a55464f88aec001d067450eedccf172
    Closes-bug: #1729225
    (cherry picked from commit 43c545ac84f29908a2e5396d07bd3de38e3a1101)

tags: added: in-stable-pike
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/trove 8.0.1

This issue was fixed in the openstack/trove 8.0.1 release.

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

Other bug subscribers

Remote bug watches

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