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, adding relation keystone mysql fails:
unit-keystone-0: 2014-10-10 07:49:47 INFO juju-log shared-db:3: Migrating the keystone database. db-relation- changed keystone stop/waiting db-relation- changed Traceback (most recent call last): db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/shared- db-relation- changed" , line 291, in <module> db-relation- changed main() db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/shared- db-relation- changed" , line 285, in main db-relation- changed hooks.execute( sys.argv) db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/charmhelp ers/core/ hookenv. py", line 478, in execute db-relation- changed self._hooks[ hook_name] () db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/charmhelp ers/core/ host.py" , line 232, in wrapped_f db-relation- changed f(*args) db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/shared- db-relation- changed" , line 139, in db_changed db-relation- changed migrate_database() db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/keystone_ utils.py" , line 266, in migrate_database db-relation- changed subprocess. check_output( cmd) db-relation- changed File "/usr/lib/ python2. 7/subprocess. py", line 573, in check_output db-relation- changed raise CalledProcessEr ror(retcode, cmd, output=output) db-relation- changed subprocess. CalledProcessEr ror: Command '['sudo', '-u', 'keystone', 'keystone-manage', 'db_sync']' returned non-zero exit status 1
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.