<div dir="ltr"><div><div><div><div><div><div><div>Hi<br><br></div>I have 2 nodes with HAProxy, MySQL-Galera and keystone each.<br><br></div>node1: IP1 = HAproxy, Galera and keystone<br>node2: IP2 = HAproxy, Galera and keystone<br></div>1 VIP<br><br></div>I have created keystone users, endpoints, tenants. These are updated in keystone DB as well. Galera cluster is also working fine. <br><br></div>Keystone user-list <br></div>gives error. The error is at <a href="http://paste.openstack.org/show/216095/">http://paste.openstack.org/show/216095/</a><br><br></div>Mysql users:<br clear="all"><div><pre class=""><code><span class="">mysql</span><span class="">></span><span class=""> </span><span class="">select</span><span class=""> user</span><span class="">,</span><span class="">host </span><span class="">from</span><span class=""> mysql</span><span class="">.</span><span class="">user</span><span class="">;</span><span class="">
</span><span class="">+------------------+--------------+</span><span class="">
</span><span class="">|</span><span class=""> user </span><span class="">|</span><span class=""> host </span><span class="">|</span><span class="">
</span><span class="">+------------------+--------------+</span><span class="">
</span><span class="">|</span><span class=""> keystone </span><span class="">|</span><span class=""> </span><span class="">%</span><span class=""> </span><span class="">|</span><span class="">
</span><span class="">|</span><span class=""> root </span><span class="">|</span><span class=""> </span><span class="">%</span><span class=""> </span><span class="">|</span><span class="">
</span><span class="">|</span><span class=""> keystone </span><span class="">|</span><span class=""> IP1 </span><span class="">|</span><span class="">
</span><span class="">|</span><span class=""> keystone </span><span class="">|</span><span class=""> IP2 </span><span class="">|</span><span class="">
</span><span class="">|</span><span class=""> keystone </span><span class="">|</span><span class=""> VIP </span><span class="">|</span><span class="">
</span><span class="">|</span><span class=""> root </span><span class="">|</span><span class=""> </span><span class="">127.0</span><span class="">.</span><span class="">0.1</span><span class=""> </span><span class="">|</span><span class="">
</span><span class="">|</span><span class=""> root </span><span class="">|</span><span class=""> </span><span class="">::</span><span class="">1</span><span class=""> </span><span class="">|</span><span class="">
</span><span class="">|</span><span class=""> debian</span><span class="">-</span><span class="">sys</span><span class="">-</span><span class="">maint </span><span class="">|</span><span class=""> localhost </span><span class="">|</span><span class="">
</span><span class="">|</span><span class=""> keystone </span><span class="">|</span><span class=""> localhost </span><span class="">|</span><span class="">
</span><span class="">|</span><span class=""> root </span><span class="">|</span><span class=""> localhost </span><span class="">|</span><span class="">
</span><span class="">+------------------+--------------+</span><span class="">
</span><span class="">10</span><span class=""> rows </span><span class="">in</span><span class=""> </span><span class="">set</span><span class=""> </span><span class="">(</span><span class="">0.00</span><span class=""> sec</span><span class="">)<br><br></span></code></pre><pre class=""><code><span class="">Telnet to MYSQL:<br><br></span></code><code><span class="">root@server2</span><span class="">:</span><span class="">/var/</span><span class="">log</span><span class="">/</span><span class="">keystone</span><span class=""># telnet VIP 3308 </span><span class="">
</span><span class="">Trying</span><span class=""> </span><span class="">10.107</span><span class="">.</span><span class="">0.180</span><span class="">...</span><span class="">
</span><span class="">Connected</span><span class=""> to </span><span class="">10.107</span><span class="">.</span><span class="">0.180</span><span class="">.</span><span class="">
</span><span class="">Escape</span><span class=""> character </span><span class="">is</span><span class=""> </span><span class="">'^]'</span><span class="">.</span><span class="">
R
</span><span class="">5.6</span><span class="">.</span><span class="">23</span><span class="">-</span><span class="">1trustyZ</span><span class="">#v'[wcjl#�#tMb%/\c^,^vYmysql_native_passwordConnection closed by foreign host.</span></code><br></pre><div><div><div><div><div><div><div><div><div><div><div><div class="gmail_signature"><div dir="ltr"><div><div><div><br><p>I have installed mysql-galera wsrep-5.6 from its official site. After
installing MySQL didnot start. I had to manually start with command</p> <pre class=""><code><span class="">mysqld </span><span class="">--</span><span class="">console</span></code></pre><font face="courier new,monospace">What could be the possible error and its solution? I have tried reinstalled and yet I get the same error.<br></font></div><div><font face="courier new,monospace"><br>Janki Chhatbar<br></font></div><font face="courier new,monospace">M.Tech (Embedded Systems)<br></font></div><font face="courier new,monospace">Nirma University<br></font></div><font face="courier new,monospace">(+91) 9409239106<br></font></div></div></div>
</div></div></div></div></div></div></div></div></div></div></div></div>