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.

I assume that this should be done by the puppet module for mysql/galera.

On Fri, Jul 16, 2021 at 2:01 AM Pete Zhang <peiyong.zhang@salesforce.com> wrote:
Also when I run "sudo su && mysql", I get this error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).

We don't see this error on our controller hosts in other DCs.


On Thu, Jul 15, 2021 at 10:56 PM Pete Zhang <peiyong.zhang@salesforce.com> wrote:
  • What version of Openstack?    
  •          Train

  • How was it deployed?              
  •           I have a set of Puppet Modules and a local yum repo containing the needed RPMs

  • Besides that log, anything else?
  •         Not much

  • Can you turn up the debug level for the scheduler and see what it says?  
  •         nova-consoleauth.log   
  •                      DBError: (pymysq.err.InternalError) (1130, u"Host '10.160.5.229' is not allowed to connect to this MariaDB server")
  •                      the ip addr "10.160.5.229' may vary

  •        nova-scheduler.log
  •                      DBError: (pymysq.err.InternalError) (1130, u"Host '10.160.6.103' is not allowed to connect to this MariaDB server")
  •                     "10.160.5.229' may vary

On Thu, Jul 15, 2021 at 8:59 PM Laurent Dumont <laurentfdumont@gmail.com> wrote:
I think you'll need to provide a bit more context so that we can assist.
  • What version of Openstack?
  • How was it deployed?
  • Besides that log, anything else?
  • Can you turn up the debug level for the scheduler and see what it says?

On Thu, Jul 15, 2021 at 10:12 PM Pete Zhang <peiyong.zhang@salesforce.com> wrote:
We are installing openstack in a new DC and seeing openstack-nova-consoleauth/scheduler failed to start up.

Checking log and found this.
Host 10.160.4.5 is not allowed to connect to this MariaDB server.

Three controller nodes are installed with MariaDB/Galera Cluster, none of them with this ip. 




--



--



--