Activity log for bug #1379687

Date Who What changed Old value New value Message
2014-10-10 08:03:44 Eduard Biceri-Matei bug added bug
2014-10-10 08:04:06 Eduard Biceri-Matei description Installing juju charms mysql and keystone, 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. 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.
2014-10-10 08:27:45 Edward Hope-Morley tags openstack
2014-11-24 10:37:40 James Page affects keystone (Juju Charms Collection) mysql (Juju Charms Collection)
2015-10-23 08:50:33 Seyeong Kim mysql (Juju Charms Collection): assignee Seyeong Kim (xtrusia)
2015-10-23 08:50:35 Seyeong Kim mysql (Juju Charms Collection): status New In Progress
2015-10-23 08:50:39 Seyeong Kim tags openstack openstack sts
2015-11-03 03:06:05 Seyeong Kim affects mysql (Juju Charms Collection) charm-helpers
2015-11-03 03:06:31 Seyeong Kim branch linked lp:~xtrusia/charm-helpers/additional-grant-on-mysql
2015-11-03 10:06:49 Edward Hope-Morley bug task added mysql (Juju Charms Collection)
2017-02-20 05:41:27 Seyeong Kim charm-helpers: assignee Seyeong Kim (xtrusia)
2017-02-20 05:41:36 Seyeong Kim charm-helpers: status In Progress Confirmed
2017-02-20 05:41:45 Seyeong Kim branch unlinked lp:~xtrusia/charm-helpers/additional-grant-on-mysql
2017-02-20 05:41:56 Seyeong Kim tags openstack sts openstack