Running the Cluster Database Replication and Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)
search cancel

Running the Cluster Database Replication and Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)

book

Article ID: 10901

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

Customer is running the Cluster Database Replication and getting denied on repluser therefore not able to continue with the configurations.

Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)

This error happen during the configuration, it the cluster setup ran more the once on the machine, it cold be the right for repluser was not laid down correctly.

The repluser was created under a different Hostname or used and IP address instead of Hostname and vice versa.

 

[root@ssg91 bin]# ./create_slave.sh
--> For verbose output run with -v

Enter hostname or IP for the MASTER: 192.168.yyy.zzz
Enter replication user: [repluser]
Enter replication password: [replpass]
Enter MySQL root user: [root]
Enter MySQL root password: []
Do you want to clone a database from 192.168.yyy.zzz (yes or no)? [no]

==> Error getting master status

Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)

Environment

This fix will work with all version of Gateway as long as they are using MYSQL has the Database.

Resolution

Commands that need to be ran (in order on both nodes) from within the MySQL Database:

# DELETE FROM mysql.user WHERE user = "repluser";

# FLUSH PRIVILEGES;

 

Then run the following script:

# /opt/SecureSpan/Appliance/bin/add_slave_user.sh

 

You can follow the instructions states in the documentation

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-1/install-configure-upgrade/configure-a-gateway-cluster/configuring-cluster-database-replication.html