<div dir="ltr">The puppet modules did deploy mysql but we need to manually "yum install galera" and add nodes after that.<div>so now mysql is up and running, galera is installed. However running 'mysql' hits this Access denied error.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jul 16, 2021 at 1:04 PM Laurent Dumont <<a href="mailto:laurentfdumont@gmail.com">laurentfdumont@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">I haven't deployed Openstack with the puppet modules, but I would start looking at the mysql/galera status and if the required user/permissions/allowed connections are set.<br><br>I assume that this should be done by the puppet module for mysql/galera.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jul 16, 2021 at 2:01 AM Pete Zhang <<a href="mailto:peiyong.zhang@salesforce.com" target="_blank">peiyong.zhang@salesforce.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Also when I run "sudo su && mysql", I get this error:<div>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).</div><div><br></div><div>We don't see this error on our controller hosts in other DCs.</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jul 15, 2021 at 10:56 PM Pete Zhang <<a href="mailto:peiyong.zhang@salesforce.com" target="_blank">peiyong.zhang@salesforce.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><ul><li style="margin-left:15px">What version of Openstack? </li><li style="margin-left:15px"> Train</li><li style="margin-left:15px"><br></li><li style="margin-left:15px">How was it deployed? </li><li style="margin-left:15px"> I have a set of Puppet Modules and a local yum repo containing the needed RPMs<br></li><li style="margin-left:15px"><br></li><li style="margin-left:15px">Besides that log, anything else?<br></li><li style="margin-left:15px"> Not much</li><li style="margin-left:15px"><br></li><li style="margin-left:15px">Can you turn up the debug level for the scheduler and see what it says? </li><li style="margin-left:15px"> nova-consoleauth.log </li><li style="margin-left:15px"> DBError: (pymysq.err.InternalError) (1130, u"Host '10.160.5.229' is not allowed to connect to this MariaDB server")</li><li style="margin-left:15px"> the ip addr "10.160.5.229' may vary</li><li style="margin-left:15px"><br></li><li style="margin-left:15px"> nova-scheduler.log</li><li style="margin-left:15px"> DBError: (pymysq.err.InternalError) (1130, u"Host '10.160.6.103' is not allowed to connect to this MariaDB server")</li><li style="margin-left:15px"> "10.160.5.229' may vary</li></ul></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jul 15, 2021 at 8:59 PM Laurent Dumont <<a href="mailto:laurentfdumont@gmail.com" target="_blank">laurentfdumont@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">I think you'll need to provide a bit more context so that we can assist.<div><ul><li>What version of Openstack?<br></li><li>How was it deployed?<br></li><li>Besides that log, anything else?<br></li><li>Can you turn up the debug level for the scheduler and see what it says?</li></ul></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jul 15, 2021 at 10:12 PM Pete Zhang <<a href="mailto:peiyong.zhang@salesforce.com" target="_blank">peiyong.zhang@salesforce.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">We are installing openstack in a new DC and seeing openstack-nova-consoleauth/scheduler failed to start up.<div><br></div><div>Checking log and found this.</div><div>Host 10.160.4.5 is not allowed to connect to this MariaDB server.</div><div><br></div><div>Three controller nodes are installed with MariaDB/Galera Cluster, none of them with this ip. </div><div><br></div><div><br></div><div><br clear="all"><div><br></div>-- <br><div dir="ltr"><br><a href="https://smart.salesforce.com/sig/peiyong.zhang//us_mb/default/link.html" target="_blank"><img border="0" src="https://smart.salesforce.com/sig/peiyong.zhang//us_mb/default/logo.png"></a></div></div></div>
</blockquote></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><br><a href="https://smart.salesforce.com/sig/peiyong.zhang//us_mb/default/link.html" target="_blank"><img border="0" src="https://smart.salesforce.com/sig/peiyong.zhang//us_mb/default/logo.png"></a></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><br><a href="https://smart.salesforce.com/sig/peiyong.zhang//us_mb/default/link.html" target="_blank"><img border="0" src="https://smart.salesforce.com/sig/peiyong.zhang//us_mb/default/logo.png"></a></div>
</blockquote></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><br><a href="https://smart.salesforce.com/sig/peiyong.zhang//us_mb/default/link.html" target="_blank"><img border="0" src="https://smart.salesforce.com/sig/peiyong.zhang//us_mb/default/logo.png"></a></div>