Layer7 API Management

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.141
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.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 SLAVE
Enter hostname or IP for the SLAVE: 192.168.181.141
Enter 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=1
Do you want to continue? [Y] y
Granting slave permissions to repluser@192.168.181.141
Done.

Note: ssg version: 9.1 and prior to running above scripts i have created an database with name ssg.

Thanks

Hello, 

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  

Hi There,

I managed to setup replication between two ssg nodes.thanks

Popleys

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.

Hi

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.

Thanks

Abs

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