Installing Keystone charm on same host as mysql charm doesn't properly configure the user

Bug #1379687 reported by Eduard Biceri-Matei
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Charm Helpers
Undecided
Unassigned
mysql (Juju Charms Collection)
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-db-relation-changed keystone stop/waiting
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed Traceback (most recent call last):
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed File "/var/lib/juju/agents/unit-keystone-0/charm/hooks/shared-db-relation-changed", line 291, in <module>
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed main()
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed File "/var/lib/juju/agents/unit-keystone-0/charm/hooks/shared-db-relation-changed", line 285, in main
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed hooks.execute(sys.argv)
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed File "/var/lib/juju/agents/unit-keystone-0/charm/hooks/charmhelpers/core/hookenv.py", line 478, in execute
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed self._hooks[hook_name]()
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed File "/var/lib/juju/agents/unit-keystone-0/charm/hooks/charmhelpers/core/host.py", line 232, in wrapped_f
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed f(*args)
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed File "/var/lib/juju/agents/unit-keystone-0/charm/hooks/shared-db-relation-changed", line 139, in db_changed
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed migrate_database()
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed File "/var/lib/juju/agents/unit-keystone-0/charm/hooks/keystone_utils.py", line 266, in migrate_database
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed subprocess.check_output(cmd)
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed File "/usr/lib/python2.7/subprocess.py", line 573, in check_output
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed raise CalledProcessError(retcode, cmd, output=output)
unit-keystone-0: 2014-10-10 07:49:47 INFO shared-db-relation-changed subprocess.CalledProcessError: Command '['sudo', '-u', 'keystone', 'keystone-manage', 'db_sync']' returned non-zero exit status 1
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
Revision history for this message
Mahito OGURA (earthdragon77) wrote :
James Page (james-page)
affects: keystone (Juju Charms Collection) → mysql (Juju Charms Collection)
Seyeong Kim (seyeongkim)
Changed in mysql (Juju Charms Collection):
assignee: nobody → Seyeong Kim (xtrusia)
status: New → In Progress
tags: added: sts
Seyeong Kim (seyeongkim)
affects: mysql (Juju Charms Collection) → charm-helpers
Seyeong Kim (seyeongkim)
Changed in charm-helpers:
assignee: Seyeong Kim (xtrusia) → nobody
status: In Progress → Confirmed
tags: removed: sts
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers