relation with mysql fail when mysql and glance are deployed on the same node
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql (Juju Charms Collection) |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
I m deploying havanna in a sandbox.
Full deployment guide is available here:
http://
README.txt describe all the installation process
openstack.yaml is the juju openstack.yaml file used to deploy things.
There s a controller node where several charms are located, among them, mysql and glance:
controller.
When setting a relation between mysql and glance, glance ends up with an error:
agent-state-info: 'hook failed: "shared-
In juju debug-logs:
unit-glance-0: 2014-04-10 08:07:01 INFO shared-
If i log as root in the mysql db, i see there s only 1 entry for the glance user, and it is not associated with the ip of the controller node, but only with the loopback address.
mysql> select Host,User,Password from user where User='glance';
+------
| Host | User | Password |
+------
| 127.0.0.1 | glance | *0107778671E896
+------
1 row in set (0.00 sec)
The controller nodes resolve controller.
# Added by cloud-init on Wed, 09 Apr 2014 14:37:59 +0000
127.0.1.1 controller.
It looks to me the entry in the mysql database for the glance user should not have been the loopback address but 192.168.101.10
ubuntu@maas:~$ cat charms/
311
ubuntu@maas:~$ cat charms/
148
I see the same behavior when setting up a relation between mysql & keystone.
If I run mysql & keystone on two separate machines, the add-relation works fine.
If done on the same machine, it fails with the following :
unit-keystone-0: 2014-04-10 09:47:57 ERROR juju.worker.uniter uniter.go:475 hook failed: exit status 1 db-relation- changed 2014-04-10 11:55:17.096 10512 CRITICAL keystone [-] (OperationalError) (1 db-relation- changed Traceback (most recent call last): db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/shared- db-relati db-relation- changed utils.do_ hooks(hooks) db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/lib/ utils.py" , l db-relation- changed hook_func() db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/shared- db-relati db-relation- changed ensure_ initial_ admin(config) db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/keystone_ utils.p initial_ admin db-relation- changed create_ tenant( "admin" ) db-relation- changed File "/var/lib/ juju/agents/ unit-keystone- 0/charm/ hooks/keystone_ utils.p db-relation- changed tenants = [t._info for t in manager. api.tenants. list()] db-relation- changed File "/usr/lib/ python2. 7/dist- packages/ keystoneclient/ v2_0/tenants. py", db-relation- changed tenant_list = self._list( "/tenants% s" % query, "tenants") db-relation- changed File "/usr/lib/ python2. 7/dist- packages/ keystoneclient/ base.py" , line 90 db-relation- changed resp, body = self.api.get(url) db-relation- changed File "/usr/lib/ python2. 7/dist- packages/ keystoneclient/ httpclient. py", l db-relation- changed return self._cs_ request( url, 'GET', **kwargs) db-relation- changed File "/usr/lib/ python2. 7/dist- packages/ keys...
unit-keystone-0: 2014-04-10 09:55:07 INFO juju-log shared-db:6: db_host or password not set. Peer not ready, exit 0
unit-keystone-0: 2014-04-10 09:55:16 INFO juju-log shared-db:6: Cluster leader, performing db-sync
unit-keystone-0: 2014-04-10 09:55:17 INFO shared-
130, "Host '192.168.122.154' is not allowed to connect to this MySQL server") None None
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
on-changed", line 570, in <module>
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
ine 28, in do_hooks
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
on-changed", line 180, in db_changed
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
y", line 337, in ensure_
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
y", line 231, in create_tenant
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
line 117, in list
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
, in _list
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
ine 654, in get
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-
unit-keystone-0: 2014-04-10 09:55:22 INFO shared-