Installing Keystone charm on same host as mysql charm doesn't properly configure the user
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Charm Helpers |
Confirmed
|
Undecided
|
Unassigned | ||
mysql (Juju Charms Collection) |
New
|
Undecided
|
Unassigned |
Bug Description
Installing juju charms mysql and keystone ON THE SAME HOST/VM, adding relation keystone mysql fails:
unit-keystone-0: 2014-10-10 07:49:47 INFO juju-log shared-db:3: Migrating the keystone database.
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-
unit-keystone-0: 2014-10-10 07:49:47 ERROR juju.worker.uniter uniter.go:486 hook failed: exit status 1
On the host itself:
(keystone): 2014-10-10 10:49:47,813 CRITICAL OperationalError: (OperationalError) (1130, "Host '10.130.10.151' is not allowed to connect to this MySQL server") None None
On the mysql server: (table User, columns: Host, User)
| 127.0.0.1 | keystone |
This looks like the mysql charm is adding an user with ip=127.0.0.1 and the keystone charm is configuring the "private-address" to connect.
description: | updated |
tags: | added: openstack |
affects: | keystone (Juju Charms Collection) → mysql (Juju Charms Collection) |
Changed in mysql (Juju Charms Collection): | |
assignee: | nobody → Seyeong Kim (xtrusia) |
status: | New → In Progress |
tags: | added: sts |
affects: | mysql (Juju Charms Collection) → charm-helpers |
Changed in charm-helpers: | |
assignee: | Seyeong Kim (xtrusia) → nobody |
status: | In Progress → Confirmed |
tags: | removed: sts |
I propesing PR now. /github. com/charms/ mysql/pull/ 1
https:/