The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Remote MSQL Setup Hashing Wrong Remote Root Password

Discussion in 'Database Discussions' started by n0risc, Nov 15, 2013.

  1. n0risc

    n0risc Member

    Joined:
    Sep 24, 2013
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I have cPanel WHM 11.38.2 build 12 trying to remote MYSQL to a freshly installed cPanel WHM 11.40.0 build 19.

    The Remote MySQL Setup retrieves the remote /root/.my.cnf information via SSH, and successfully sets GRANT PRIVILEGES on the remote MySQL Database. But when it goes to login remotely to fails with Access Denied.

    The credentials are being stored on the Remote MySQL Destination, but the hash for the password does not match the hash for root@localhost root@remote.server has a different hash. How is this possible?

    When manually modifying the table with the correct hashed password for root@localhost, I can then successfully remote mysqladmin from the command line from the host server to the remote server.

    Is there a workaround? Obviously I cannot catch in time the table update right before the SETUP retrieval to update the hashed passwords. And everytime to go to repeat the setup process it overwrites or adds more incorrect hashes for root@remote.server.

    Is this a known issue? I'm guessing that the MD5 Key's have changed from cPanel 11.38.2 to 11.40.2 when hashing the mysql passwords?
     
  2. n0risc

    n0risc Member

    Joined:
    Sep 24, 2013
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    This issue was fixed.

    /root/.my.cnf that is generated with 11.40.0 Build 19 after installation supplies "quotes" around parameters specified in the [client] tag.

    The only option under the [client] tag that should have quotes is the pass="password".

    WRONG .my.conf
    CORRECT .my.conf
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please open a bug report for this so we can attempt to reproduce the issue and address it in a future build of cPanel if necessary:

    Submit A Bug Report

    You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page