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.

cpbackup changes MySQL passwords.

Discussion in 'Data Protection' started by eskhosting.com, Feb 10, 2009.

  1. eskhosting.com

    Joined:
    Oct 18, 2006
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Hi, All!

    I have three users who after everyone backup have problems with access to mysql.

    Their passwords vary so:

    Before: *1172D84CC0CBDF7FD2D9BA2116AFA64CC7656945
    After: -5496567CC46AFA6112AB9D2DF7FDBC0CC48D2711


    It is similar to operation of a script /scripts/suspendmysqlusers
    But why? These accounts are active and are not suspended.
     
  2. eskhosting.com

    Joined:
    Oct 18, 2006
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    BUG found in /scripts/suspendmysqlusers !

    Request:

    "SELECT User, Password from mysql.user WHERE user = '$user' OR user LIKE '$user\_%'"

    ...gets any usernames, like user*

    ANY!

    And suspend him all...
    I.e. user, user1, user2 user3_123 gets inverted passwords when "user" are really suspended.

    Request should be like this:

    "SELECT User, Password from mysql.user WHERE user = '$user' OR user LIKE $user\\_%'");

    Ticket ID: 377857
     
    #2 eskhosting.com, Feb 11, 2009
    Last edited: Feb 11, 2009
  3. Nick

    Nick Member

    Joined:
    Dec 27, 2001
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    thanks very much
    I had the same problem
     
Loading...

Share This Page