MySQL Forums
Forum List  »  NDB clusters

NDB stored user not being synced
Posted by: Richard Cruise
Date: May 06, 2020 09:52AM

Hi all,

I'm setting up a MySQL cluster and I'm having some trouble with syncing user credentials using the NDB_STORED_USER.

Description of cluster
3 Nodes, each runs as a management, data and MySQL API node
Node1 - 192.168.16.33
Node2 - 192.168.16.34
Node3 - 192.168.16.35

On Node 1:
mysql> create user 'joe'@'localhost' identified by 'Welcome1!';
Query OK, 0 rows affected (0.01 sec)

mysql> grant ndb_stored_user on *.* to 'joe'@'localhost';
Query OK, 0 rows affected (0.16 sec)

mysql>

On Node 3, I see the following error in the mysqld.log
2020-05-06T15:42:41.942878Z 2 [ERROR] [MY-010865] [Server] NDB: Query 'CREATE USER IF NOT EXISTS 'joe'@'localhost'' failed, error: 1819: Your password does not satisfy the current policy requirements
2020-05-06T15:42:41.943846Z 2 [ERROR] [MY-010865] [Server] NDB: Query 'ALTER USER 'joe'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '$A$005$^%C`L\r@2h\ZFuV1lUXU1mtzH0KFo5Jrk8CaW7JO2liID19K9EbW7jTmjW8' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT' failed, error: 1396: Operation ALTER USER failed for 'joe'@'localhost'
2020-05-06T15:42:41.944499Z 2 [ERROR] [MY-010865] [Server] NDB: Query 'GRANT USAGE ON *.* TO `joe`@`localhost`' failed, error: 1410: You are not allowed to create a user with GRANT
2020-05-06T15:42:41.945250Z 2 [ERROR] [MY-010865] [Server] NDB: Query 'GRANT NDB_STORED_USER ON *.* TO `joe`@`localhost`' failed, error: 1410: You are not allowed to create a user with GRANT

The password requirements match across all 3 MySQL nodes and if I use the same password to setup the user on Node 3 it succeeds.

It seems that the NDB_STORED_USER privilege is failing due to some issue regarding password requirements:

MySQL Cluster version
[root@mysql-cluster-mn03 ~]# rpm -qa | grep mysql
mysql-cluster-community-server-8.0.19-1.el7.x86_64
mysql-cluster-community-client-8.0.19-1.el7.x86_64
mysql-cluster-community-libs-compat-8.0.19-1.el7.x86_64
mysql-cluster-community-libs-8.0.19-1.el7.x86_64
mysql-cluster-community-management-server-8.0.19-1.el7.x86_64
mysql-cluster-community-common-8.0.19-1.el7.x86_64
mysql-cluster-community-data-node-8.0.19-1.el7.x86_64
[root@mysql-cluster-mn03 ~]#

MySQL cluster config:
[root@mysql-cluster-mn03 ~]# cat /var/lib/mysql-cluster/config.ini
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=3 # Number of replicas

[ndb_mgmd]
# Management process options:
HostName=192.168.16.33 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files
NodeId=1
[ndb_mgmd]
# Management process options:
HostName=192.168.16.34 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files
NodeId=2
[ndb_mgmd]
# Management process options:
HostName=192.168.16.35 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files
NodeId=3


[ndbd]
# Options for data node "A":
# # (one [ndbd] section per data node)
HostName=192.168.16.33 # Hostname or IP address
NodeId=16 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files

[ndbd]
# Options for data node "B":
HostName=192.168.16.34 # Hostname or IP address
NodeId=17 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files

[ndbd]
# Options for data node "C":
HostName=192.168.16.35 # Hostname or IP address
NodeId=18 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files

[mysqld]
# SQL node options:
HostName=192.168.16.33 # Hostname or IP address
NodeId=32 # Node ID for this api node

[mysqld]
# SQL node options:
HostName=192.168.16.34 # Hostname or IP address
NodeId=33 # Node ID for this api node

[mysqld]
# SQL node options:
HostName=192.168.16.35 # Hostname or IP address
NodeId=34 # Node ID for this api node
[root@mysql-cluster-mn03 ~]#

Options: ReplyQuote


Subject
Views
Written By
Posted
NDB stored user not being synced
60
May 06, 2020 09:52AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.