[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