percona cluster host not allowed even when unit in allowed_hosts
Bug #1513239 reported by
David Ames
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Percona Cluster Charm |
Fix Released
|
High
|
James Page | ||
percona-cluster (Juju Charms Collection) |
Invalid
|
High
|
David Ames |
Bug Description
Errors relating keystone with percona-cluster
ERROR 1130 (HY000): Host 'juju-thedac-
OperationalError: (OperationalError) (1130, "Host 'juju-thedac-
Keystone getting these errors even when relation-get shows keystone/n in allowed_hosts.
Requires "FLUSH PRIVILEGES;" after GRANT statements.
http://
Related branches
lp://staging/~james-page/charm-helpers/flush-after-grant
- Charles Butler (community): Approve
-
Diff: 24 lines (+8/-0)1 file modifiedcharmhelpers/contrib/database/mysql.py (+8/-0)
affects: | charms → percona-cluster (Juju Charms Collection) |
Changed in percona-cluster (Juju Charms Collection): | |
importance: | Undecided → High |
assignee: | nobody → David Ames (thedac) |
status: | New → In Progress |
tags: | added: oil |
Changed in charm-percona-cluster: | |
assignee: | nobody → David Ames (thedac) |
importance: | Undecided → High |
status: | New → In Progress |
Changed in percona-cluster (Juju Charms Collection): | |
status: | In Progress → Invalid |
Changed in charm-percona-cluster: | |
assignee: | David Ames (thedac) → James Page (james-page) |
milestone: | none → 17.05 |
Changed in charm-percona-cluster: | |
milestone: | 17.05 → 17.08 |
Changed in charm-percona-cluster: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
The issue is percona cluster is not allowing connection via the VIP without a restart of the node with the VIP.
Connections work to all mysql ips. But not to the VIP.
# mysql/0 thedac- machine- 2:~# nc -v 10.5.48.250 3306 35.0dS| ;OYTy%� �Gu8X1- .=)SHOmysql_ native_ password
root@juju-
Connection to 10.5.48.250 3306 port [tcp/mysql] succeeded!
O
5.5.37-
^C
# mysql/1 thedac- machine- 2:~# nc -v 10.5.48.251 3306 35.0Mb# %0b{dc� �Die>Dz\ ?e^'Dmysql_ native_ password
root@juju-
Connection to 10.5.48.251 3306 port [tcp/mysql] succeeded!
O
5.5.37-
^C
# mysql/2 thedac- machine- 2:~# nc -v 10.5.48.252 3306 35.0VRFGq% `83��9dkne1bz` RW@mysql_ native_ password
root@juju-
Connection to 10.5.48.252 3306 port [tcp/mysql] succeeded!
O
5.5.37-
^C
# VIP thedac- machine- 2:~# nc -v 10.5.100.1 3306 machine- 2.openstackloca l' is not allowed to connect to this MySQL serverroot@ juju-thedac- machine- 2:~#
root@juju-
Connection to 10.5.100.1 3306 port [tcp/mysql] succeeded!
]�jHost 'juju-thedac-