When running the cluster database replication received the following error:
Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)
[root@localhost bin]# ./create_slave.sh
--> For verbose output run with -v
Enter hostname or IP for the MASTER: primary_host
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 primary_host (yes or no)? [no]
==> Error getting master status
Message: ERROR 1045 (28000): Access denied for user 'repluser'@'Your_Machine_Name' (using password: YES)
This fix will work with all version of Gateway as long as they are using MYSQL has the Database.
The repluser was created under a different Hostname or used an IP address instead of a Hostname and vice versa.
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