Cannot login through Admin Panel

Discussion in 'General' started by madelves, Dec 16, 2013.

  1. madelves

    madelves New Member

    Hi,

    I have a problem with an already running ispconfig 3.

    I cannot login through the login panel now. I can open PHP my admin but it always says error mysql 1045. however I can login using mysql -u 'username' -p

    I have looked at various log it seems the problem is about connecting to the database. I changed the config.inc.php in both /usr/local/ispconfig/interface/lib and /usr/local/ispconfig/server/lib to reflect the current mysql password.

    FYI : my server was just ddos'ed by another person and this happens

    Tried all kinds of stuff but at a loss right now.

    Please help.

    Regards,
    Ray
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Do not change the mysql password of the ispconfig user in these files manually. If you want to set a password in mysql,take the password that is inserted into the files by the ispconfig installer and set this password in mysql. So the other way round as you did it. The password is used in many more files and if you alter it manually, most parts of the system will start to fail.

    After you restored the files, we can strt to search for your original problem:

    post the output of:

    nestat -tap | grep mysql
     
  3. madelves

    madelves New Member

    How do I do that manually? I am using ispconfig 3.0.3.2

    netstat shows :

    tcp 0 0 localhost.localdo:mysql *:* LISTEN 27716/mysqld
     
  4. madelves

    madelves New Member

    I tried and cannot do anything. It still shows cannot connect.

    How do I reset my main user/password for mysql for ispconfig? Is there a script I can use?

    I can't even do an install script for upgrading because it somehow cannot connect to mysql.

    php -q update.php shows :

    Code:
      | | \ `--.| |_/ / | /  \/ ___  _ __ | |_ _  __ _    _/ /
      | |  `--. \  __/  | |    / _ \| '_ \|  _| |/ _` |  |_ |
     _| |_/\__/ / |     | \__/\ (_) | | | | | | | (_| | ___\ \
     \___/\____/\_|      \____/\___/|_| |_|_| |_|\__, | \____/
                                                  __/ |
                                                 |___/ 
    --------------------------------------------------------------------------------
    
    
    >> Update  
    
    Operating System: Debian 6.0 (Squeeze/Sid) or compatible
    
    This application will update ISPConfig 3 on your server.
    
    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: 
    
    Creating backup of "/usr/local/ispconfig" directory...
    Creating backup of "/etc" directory...
    Unable to connect to mysql server Access denied for user 'root'@'localhost' (using password: NO)
    MySQL root password [1234567]: 1234567
    
    Unable to connect to mysql server Access denied for user 'root'@'localhost' (using password: NO)
    MySQL root password [1234567]: 
    PS : I use 1234567 for security's sake
     
  5. madelves

    madelves New Member

    Found out what's wrong.

    It turns out the mysql safe mode is messing around with ispconfig.
    I've been hardening the server and turning it off makes it ok for me to log in.
    Can I do PHP safe mode with ispconfig?
     
  6. nababan

    nababan New Member

    Hi... I got this error persist
    After follow tutorial from https://www.howtoforge.com/tutorial...-stretch-apache-bind-dovecot-ispconfig-3-1/3/ every step, I cannot login into fresh install of ISPConfig.3
    Here is my netstat -tap
    Code:
    [email protected]:/usr/local/ispconfig/interface# netstat -tap
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name   
    tcp        0      0 0.0.0.0:imap2           0.0.0.0:*               LISTEN      930/dovecot         
    tcp        0      0 0.0.0.0:urd             0.0.0.0:*               LISTEN      1357/master         
    tcp        0      0 0.0.0.0:ftp             0.0.0.0:*               LISTEN      1383/pure-ftpd (SER
    tcp        0      0 10.130.88.163:domain    0.0.0.0:*               LISTEN      787/named           
    tcp        0      0 10.15.0.6:domain        0.0.0.0:*               LISTEN      787/named           
    tcp        0      0 srv001-sg.srv.in:domain 0.0.0.0:*               LISTEN      787/named           
    tcp        0      0 localhost:domain        0.0.0.0:*               LISTEN      787/named           
    tcp        0      0 0.0.0.0:ssh             0.0.0.0:*               LISTEN      870/sshd           
    tcp        0      0 0.0.0.0:smtp            0.0.0.0:*               LISTEN      1357/master         
    tcp        0      0 localhost:953           0.0.0.0:*               LISTEN      787/named           
    tcp        0      0 0.0.0.0:imaps           0.0.0.0:*               LISTEN      930/dovecot         
    tcp        0      0 0.0.0.0:pop3s           0.0.0.0:*               LISTEN      930/dovecot         
    tcp        0      0 localhost:10023         0.0.0.0:*               LISTEN      1040/postgrey --pid
    tcp        0      0 localhost:10024         0.0.0.0:*               LISTEN      1366/amavisd-new (m
    tcp        0      0 localhost:10025         0.0.0.0:*               LISTEN      1357/master         
    tcp        0      0 localhost:10026         0.0.0.0:*               LISTEN      1366/amavisd-new (m
    tcp        0      0 localhost:10027         0.0.0.0:*               LISTEN      1357/master         
    tcp        0      0 0.0.0.0:submission      0.0.0.0:*               LISTEN      1357/master         
    tcp        0      0 localhost:11211         0.0.0.0:*               LISTEN      834/memcached       
    tcp        0      0 0.0.0.0:pop3            0.0.0.0:*               LISTEN      930/dovecot         
    tcp        0      0 localhost:44902         localhost:imap2         TIME_WAIT   -                   
    tcp        0      0 srv001-sg.srv.indod:ssh mx-ll-180.183.139:41986 ESTABLISHED 2617/sshd: goltogel
    tcp        0      0 localhost:39030         localhost:mysql         ESTABLISHED 2514/sshd: goltogel
    tcp        0      0 srv001-sg.srv.indod:ssh mx-ll-180.183.139:51778 ESTABLISHED 2498/sshd: goltogel
    tcp        0      0 localhost:39086         localhost:mysql         ESTABLISHED 3469/amavisd-new (c
    tcp        0      0 localhost:52628         localhost:ftp           TIME_WAIT   -                   
    tcp        0   4652 srv001-sg.srv.indod:ssh mx-ll-180.183.139:52098 ESTABLISHED 3424/sshd: goltogel
    tcp       61      0 localhost:54822         localhost:10025         CLOSE_WAIT  3469/amavisd-new (c
    tcp        0    848 srv001-sg.srv.indod:ssh cognize.co:57486        ESTABLISHED 6955/sshd: [accepte
    tcp6       0      0 [::]:imap2              [::]:*                  LISTEN      930/dovecot         
    tcp6       0      0 [::]:http               [::]:*                  LISTEN      1033/apache2       
    tcp6       0      0 [::]:http-alt           [::]:*                  LISTEN      1033/apache2       
    tcp6       0      0 [::]:urd                [::]:*                  LISTEN      1357/master         
    tcp6       0      0 [::]:tproxy             [::]:*                  LISTEN      1033/apache2       
    tcp6       0      0 [::]:ftp                [::]:*                  LISTEN      1383/pure-ftpd (SER
    tcp6       0      0 [::]:domain             [::]:*                  LISTEN      787/named           
    tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      870/sshd           
    tcp6       0      0 [::]:smtp               [::]:*                  LISTEN      1357/master         
    tcp6       0      0 ip6-localhost:953       [::]:*                  LISTEN      787/named           
    tcp6       0      0 [::]:https              [::]:*                  LISTEN      1033/apache2       
    tcp6       0      0 [::]:imaps              [::]:*                  LISTEN      930/dovecot         
    tcp6       0      0 [::]:pop3s              [::]:*                  LISTEN      930/dovecot         
    tcp6       0      0 ip6-localhost:10024     [::]:*                  LISTEN      1366/amavisd-new (m
    tcp6       0      0 ip6-localhost:10026     [::]:*                  LISTEN      1366/amavisd-new (m
    tcp6       0      0 [::]:mysql              [::]:*                  LISTEN      1234/mysqld         
    tcp6       0      0 [::]:submission         [::]:*                  LISTEN      1357/master         
    tcp6       0      0 [::]:pop3               [::]:*                  LISTEN      930/dovecot         
    tcp6       0      0 localhost:mysql         localhost:39030         ESTABLISHED 1234/mysqld         
    tcp6       0      0 localhost:mysql         localhost:39086         ESTABLISHED 1234/mysqld       
     
  7. Taleman

    Taleman Active Member HowtoForge Supporter

Share This Page