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

[Eduard Biceri-Matei]

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.

[Mahito OGURA (earthdragon77)]

I propesing PR now.
https://github.com/charms/mysql/pull/1