Layer 7 API Management

Expand all | Collapse all

create slave access denied error.

Jump to Best Answer
  • 1.  create slave access denied error.

    Posted 08-30-2017 09:43 PM

    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



  • 2.  Re: create slave access denied error.

    Posted 08-31-2017 12:09 PM

    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  



  • 3.  Re: create slave access denied error.
    Best Answer

    Posted 08-31-2017 08:52 PM

    Hi There,

    I managed to setup replication between two ssg nodes.thanks



  • 4.  Re: create slave access denied error.

    Posted 12-27-2017 08:56 PM

    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.



  • 5.  Re: create slave access denied error.

    Posted 01-12-2018 12:00 PM

    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



  • 6.  Re: create slave access denied error.

    Posted 12-28-2017 09:53 AM

    Run the following command 

    Commands that need to be ran (in order on both nodes):
    #DELETE FROM mysql.user WHERE user = "repluser";
    #FLUSH PRIVILEGES;
    # /opt/SecureSpan/Appliance/bin/add_slave_user.sh

    This will delete the user so you can recreate with the correct rights and will be able to proceed with the configuration