accounts can't login since resetting my MySQL root password

Discussion in 'Installation/Configuration' started by mistr_e, Oct 24, 2011.

  1. mistr_e

    mistr_e New Member

    I am running ISPConfig 3 under CentOS and I had to manually reset my MySQL root account password yesterday. Since resetting the password I haven't been able to login to ISPConfig's web interface with any account including my admin one.

    If I try to login with username: admin and my password I get Error Username or Password wrong.

    I reset my MySQL root password.

    Code:
    mysqladmin -u root -p'oldpass' password 'roottest'
    I logged into MySQL and reset admin password to test.

    Code:
    mysql -u root -p'roottest'
    mysql> use dbispconfig;
    mysql> database changed
    mysql> update sys_user set passwort = md5('admintest') WHERE username = 'admin';
    Query OK, 1 row affected (0.07 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    I changed my mysql_clientdb.conf to the new password.

    Code:
    vi /usr/local/ispconfig/server/lib/mysql_clientdb.conf
    <?php
    $clientdb_host                  = 'localhost';
    $clientdb_user                  = 'root';
    $clientdb_password              = 'roottest';
    ?>
    I couldn't find a way to restart ISPConfig 3 after these changes, or if it's even possible.

    The same error from the ISPConfig login page still shows up when trying to login with u: admin p: admintest.


    Help me ISPConfig community, you're my only hope.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The mysql root password is not used for user authentication in the ispconfig interface. ISPConfig connects to mysql with the user "ispconfig" and not root. The root user is only used to create new client databases. Have you changed the password of the ispconfig mysql user too?

    ispconfig is no daemon, so it has not to be restarted.
     
  3. mistr_e

    mistr_e New Member

    I'm pretty sure I may have at some point.
    Should I change the ispconfig mysql password using
    Code:
     update user set Password=PASSWORD('mynewpassword') WHERE User='ispconfig';
    Do I need to update an ISPConfig file somewhere when I do?
     
    Last edited: Oct 24, 2011
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Thats the wrong way.

    You should set back the password in mysql to the old value as it is stored in many files. You find the original password in the file /usr/local/ispconfig/interface/lib/config.inc.php
     
  5. mistr_e

    mistr_e New Member

    SOLVED

    I updated the MySQL ispconfig user password by connecting to mysql and running the sql to change the password.

    Code:
    mysql -u root mysql
    mysql> update sys_user set passwort = md5('isptest') WHERE username = 'ispconfig';
    Then I typed the same password into an MD5 generator http://www.iwebtool.com/md5.

    I pasted that MD5 password into my config.inc.php file.
    Code:
    vi /usr/local/ispconfig/server/lib/config.inc.php
    $conf['db_password'] = 'PASTEDMD5PASSWORD';
    
    I can now login to ispconfig.
    Thank you for your help.
     
  6. mistr_e

    mistr_e New Member

    OHHH, are you saying that long encrypted looking password on the line
    Code:
    $config['db_password']='LONGPASSWORDSTRING';
    isn't an encrypted password? That it is the plain text password that should set for the ispconfig user?

    So should I update the mysql ispconfig user with this?
    Code:
     update user set Password=PASSWORD('LONGPASSWORDSTRING') WHERE User='ispconfig';
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Thats the plaintext password.
     
  8. mistr_e

    mistr_e New Member

    While my solution worked I used the password already found in that config file instead as you suggested. Thank you again for your help.
     

Share This Page