where mysql db information in ispconfig3

Discussion in 'Installation/Configuration' started by netmastan, Jun 6, 2009.

  1. netmastan

    netmastan New Member

    Hi Guys,

    We forgot the root password of mysql datbase. So, we reset the password.
    Now, isp config login is not working
    Code:
    Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73
    
    

    can someone tell me why the config.inc.php file is empty? Where ISP config keeps the datbase login and password. Even it tried manually typed password in db_mysql_inc.php file(Changed classes private variable) and change password in the database from phpmyadmin.. it didn't work.

    We had debain-maint user login issue but managed to fix it by copying password from /etc/mysql/debian.cnf and put it in the mysql user database.


    Regards
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    You did not reset the root password, according to the error message you reset the password for the ispconfig user. This wa a very bad idea because this password is used in many config files all over the operating system. Take a look at the files in /etc/postfix, /etc/courier, /etc/pam.d/, /usr/local/ispconfig/server/lib/config.inc.php and /usr/local/ispconfig/interface/lib/config.inc.php
     
  3. netmastan

    netmastan New Member

    Thanks for the information. I managed get it fixed by copying the old password from php file and run sql query on the database.
     
  4. m4l41k4t

    m4l41k4t Member

    hi,
    I need help.
    The problem is I forgot the root password for my mysql ISPConfig.
    I check the file:
    / usr / local / ISPConfig / server / lib / config.inc.php and
    / usr / local / ISPConfig / interface / lib / config.inc.php
    but password enscript, how can I find out the password?

    The following contents :

    //** Database
    $conf['db_type'] = 'mysql';
    $conf['db_host'] = 'localhost';
    $conf['db_database'] = 'dbispconfig';
    $conf['db_user'] = 'ispconfig';
    $conf['db_password'] = '55a1975966384afad53c2bb8f188b9bb';

    My system :
    OS : CentOS 6.4 64bit
    ISPConfig Version : 3.0.5.3
     

Share This Page