[Openstack] HAProxy -MySQL Galera not connecting to keystone
Janki Chhatbar
jankihchhatbar at gmail.com
Thu May 7 12:55:17 UTC 2015
Hi
I have 2 nodes with HAProxy, MySQL-Galera and keystone each.
node1: IP1 = HAproxy, Galera and keystone
node2: IP2 = HAproxy, Galera and keystone
1 VIP
I have created keystone users, endpoints, tenants. These are updated in
keystone DB as well. Galera cluster is also working fine.
Keystone user-list
gives error. The error is at http://paste.openstack.org/show/216095/
Mysql users:
mysql> select user,host from mysql.user;
+------------------+--------------+ | user | host
| +------------------+--------------+ | keystone | %
| | root | % | | keystone | IP1 | |
keystone | IP2 | | keystone | VIP | | root
| 127.0.0.1 | | root | ::1 | |
debian-sys-maint | localhost | | keystone | localhost |
| root | localhost |
+------------------+--------------+ 10 rows in set (0.00 sec)
Telnet to MYSQL:
root at server2:/var/log/keystone# telnet VIP 3308 Trying 10.107.0.180...
Connected to 10.107.0.180. Escape character is '^]'.
R 5.6.23-1trustyZ#v'[wcjl#�#tMb%/\c^,^vYmysql_native_passwordConnection
closed by foreign host.
I have installed mysql-galera wsrep-5.6 from its official site. After
installing MySQL didnot start. I had to manually start with command
mysqld --console
What could be the possible error and its solution? I have tried reinstalled
and yet I get the same error.
Janki Chhatbar
M.Tech (Embedded Systems)
Nirma University
(+91) 9409239106
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20150507/20983932/attachment.html>
More information about the Openstack
mailing list