Hi There, Am getting the below exception while creating slave,the error is highlighted below. please advice.
[root@ssg91 bin]# ./create_slave.sh--> For verbose output run with -v
Enter hostname or IP for the MASTER: 192.168.181.141Enter 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.181.141 (yes or no)? [no]
==> Error getting master status
Message: ERROR 1045 (28000): Access denied for user 'repluser'@'192.168.181.136' (using password: YES)
Prior to running above create slave, i have ran the below:
[root@ssg91 bin]# ./add_slave_user.sh--> For verbose output run with -v
Gathering information for SLAVE user
You must enter a SLAVEEnter hostname or IP for the SLAVE: 192.168.181.141Enter replication user: [repluser]Enter replication password: [replpass]Enter MySQL root user: [root]Enter MySQL root password: 
Checking configuration of running MySQL...MySQL appears to be properly configured with server_id=1Do you want to continue? [Y] yGranting slave permissions to firstname.lastname@example.orgDone.
Note: ssg version: 9.1 and prior to running above scripts i have created an database with name ssg.
When you created the database ssg, did you go through the main menu to create the database or did you create the DB from the mysql command line?
Also, did you run the add_slave_user.sh script on both nodes before running the create slave?
more information on configuring replication can be found here: Cluster Database Replication - CA API Gateway - 9.1 - CA Technologies Documentation
I managed to setup replication between two ssg nodes.thanks
I am also getting similar error. I am trying to set up replication in a cluster of 4 nodes, using one DB node as primary and another one as secondary.
Please let me know if the answer I provide you found helpful, if so, can you please kindly make this answer correct on communities site, I would highly appreciate it.
Run the following command
This will delete the user so you can recreate with the correct rights and will be able to proceed with the configuration