Can't get into ISPconfig dashboard

Discussion in 'Installation/Configuration' started by tmpinsnty, Mar 2, 2018.

  1. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    I have debian wheezy with ISPconfig 3.1.1
    I have apache and dovecot
    here is my htf file

    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    IP-address(es) (as per ifconfig): ***.***.***.***, ***.***.***.***
    [INFO] ISPConfig is installed.

    ##### ISPCONFIG #####
    ISPConfig version is 3.1.11


    ##### VERSION CHECK #####

    [INFO] php (cli) version is 5.4.45-0+deb7u12
    [INFO] php-cgi (used for cgi php in default vhost!) is version 5.4.45-0+deb7u12

    ##### PORT CHECK #####


    ##### MAIL SERVER CHECK #####


    ##### RUNNING SERVER PROCESSES #####

    [INFO] I found the following web server(s):
    Apache 2 (PID 16045)
    [INFO] I found the following mail server(s):
    Postfix (PID 5821)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 6981)
    [INFO] I found the following imap server(s):
    Dovecot (PID 6981)
    [INFO] I found the following ftp server(s):
    PureFTP (PID 7059)

    ##### LISTENING PORTS #####
    (only ()
    Local (Address)
    [localhost]:953 (7087/named)
    [anywhere]:25 (5821/master)
    [anywhere]:993 (6981/dovecot)
    [anywhere]:995 (6981/dovecot)
    [localhost]:10024 (5845/amavisd-new)
    [localhost]:10025 (5821/master)
    [localhost]:10026 (5845/amavisd-new)
    [anywhere]:3306 (3111/mysqld)
    [localhost]:10027 (5821/master)
    [anywhere]:587 (5821/master)
    [localhost]:11211 (2539/memcached)
    [anywhere]:110 (6981/dovecot)
    [anywhere]:143 (6981/dovecot)
    [localhost]:783 (2673/spamd.pid)
    [anywhere]:465 (5821/master)
    ***.***.***.***:53 (7087/named)
    ***.***.***.***:53 (7087/named)
    [localhost]:53 (7087/named)
    [anywhere]:21 (7059/pure-ftpd)
    [anywhere]:22 (2598/sshd)
    *:*:*:*::*:953 (7087/named)
    *:*:*:*::*:25 (5821/master)
    *:*:*:*::*:443 (16045/apache2)
    *:*:*:*::*:993 (6981/dovecot)
    *:*:*:*::*:995 (6981/dovecot)
    *:*:*:*::*:587 (5821/master)
    [localhost]10 (6981/dovecot)
    [localhost]43 (6981/dovecot)
    *:*:*:*::*:8080 (16045/apache2)
    *:*:*:*::*:80 (16045/apache2)
    *:*:*:*::*:8081 (16045/apache2)
    *:*:*:*::*:465 (5821/master)
    *:*:*:*::*:53 (7087/named)
    *:*:*:*::*:21 (7059/pure-ftpd)
    *:*:*:*::*:22 (2598/sshd)




    ##### IPTABLES #####
    Chain INPUT (policy DROP)
    target prot opt source destination
    fail2ban-dovecot-pop3imap tcp -- [anywhere]/0 [anywhere]/0 multiport dports 110,995,143,993
    fail2ban-pureftpd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 21
    fail2ban-sasl tcp -- [anywhere]/0 [anywhere]/0 multiport dports 25
    fail2ban-ssh tcp -- [anywhere]/0 [anywhere]/0 multiport dports 22
    DROP tcp -- [anywhere]/0 ***.***.***.***/8
    ACCEPT all -- [anywhere]/0 [anywhere]/0 state RELATED,ESTABLISHED
    ACCEPT all -- [anywhere]/0 [anywhere]/0
    DROP all -- ***.***.***.***/4 [anywhere]/0
    PUB_IN all -- [anywhere]/0 [anywhere]/0
    PUB_IN all -- [anywhere]/0 [anywhere]/0
    PUB_IN all -- [anywhere]/0 [anywhere]/0
    PUB_IN all -- [anywhere]/0 [anywhere]/0
    PUB_IN all -- [anywhere]/0 [anywhere]/0
    PUB_IN all -- [anywhere]/0 [anywhere]/0
    DROP all -- [anywhere]/0 [anywhere]/0

    Chain FORWARD (policy DROP)
    target prot opt source destination
    ACCEPT all -- [anywhere]/0 [anywhere]/0 state RELATED,ESTABLISHED
    DROP all -- [anywhere]/0 [anywhere]/0

    Chain OUTPUT (policy ACCEPT)
    target prot opt source destination
    PUB_OUT all -- [anywhere]/0 [anywhere]/0
    PUB_OUT all -- [anywhere]/0 [anywhere]/0
    PUB_OUT all -- [anywhere]/0 [anywhere]/0
    PUB_OUT all -- [anywhere]/0 [anywhere]/0
    PUB_OUT all -- [anywhere]/0 [anywhere]/0
    PUB_OUT all -- [anywhere]/0 [anywhere]/0

    Chain INT_IN (0 references)
    target prot opt source destination
    ACCEPT icmp -- [anywhere]/0 [anywhere]/0
    DROP all -- [anywhere]/0 [anywhere]/0

    Chain INT_OUT (0 references)
    target prot opt source destination
    ACCEPT icmp -- [anywhere]/0 [anywhere]/0
    ACCEPT all -- [anywhere]/0 [anywhere]/0

    Chain PAROLE (17 references)
    target prot opt source destination
    ACCEPT all -- [anywhere]/0 [anywhere]/0

    Chain PUB_IN (6 references)
    target prot opt source destination
    ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 3
    ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 0
    ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 11
    ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 8
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:20
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:21
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:22
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:25
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:53
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:80
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:110
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:143
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:443
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:587
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:993
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:995
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:3306
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:8080
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:8081
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:10000
    PAROLE tcp -- [anywhere]/0 [anywhere]/0 tcp dpts:40100:40210
    ACCEPT udp -- [anywhere]/0 [anywhere]/0 udp dpt:53
    ACCEPT udp -- [anywhere]/0 [anywhere]/0 udp dpt:3306
    DROP icmp -- [anywhere]/0 [anywhere]/0
    DROP all -- [anywhere]/0 [anywhere]/0

    Chain PUB_OUT (6 references)
    target prot opt source destination
    ACCEPT all -- [anywhere]/0 [anywhere]/0

    Chain fail2ban-dovecot-pop3imap (1 references)
    target prot opt source destination
    RETURN all -- [anywhere]/0 [anywhere]/0

    Chain fail2ban-pureftpd (1 references)
    target prot opt source destination
    RETURN all -- [anywhere]/0 [anywhere]/0

    Chain fail2ban-sasl (1 references)
    target prot opt source destination
    RETURN all -- [anywhere]/0 [anywhere]/0

    Chain fail2ban-ssh (1 references)
    target prot opt source destination
    RETURN all -- [anywhere]/0 [anywhere]/0
     
  2. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    here is some of my mail.log
    Mar 2 11:35:41 vps dovecot: auth-worker(17755): Error: mysql: Query timed out (no free connections for 60 secs): SELECT email as user, password, maildir as userdb_home, CONCAT( maildir_format, ':', maildir, '/', IF(maildir_format='maildir','Maildir',maildir_format)) as userdb_mail, uid as userdb_uid, gid as userdb_gid, CONCAT('*:storage=', quota, 'B') AS userdb_quota_rule, CONCAT(maildir, '/.sieve') as userdb_sieve FROM mail_user WHERE (login = 'scanner' OR email = 'scanner') AND `disablesmtp` = 'n' AND server_id = '1'
    Mar 2 11:35:41 vps dovecot: auth-worker(17755): Error: sql(scanner,91.234.99.213): Password query failed: Not connected to database
    Mar 2 11:35:41 vps dovecot: auth-worker(17909): Error: mysql(localhost): Connect failed to database (dbispconfig): Access denied for user 'ispconfig'@'localhost' (using password: YES) - waiting for 1 seconds before retry
    Mar 2 11:35:41 vps dovecot: auth-worker(17909): Error: mysql(localhost): Connect failed to database (dbispconfig): Access denied for user 'ispconfig'@'localhost' (using password: YES) - waiting for 1 seconds before retry
    Mar 2 11:35:42 vps dovecot: auth-worker(17909): Error: mysql(localhost): Connect failed to database (dbispconfig): Access denied for user 'ispconfig'@'localhost' (using password: YES) - waiting for 5 seconds before retry
    Mar 2 11:35:42 vps dovecot: auth-worker(17909): Error: mysql(localhost): Connect failed to database (dbispconfig): Access denied for user 'ispconfig'@'localhost' (using password: YES) - waiting for 5 seconds before retry
    Mar 2 11:35:47 vps dovecot: auth-worker(17909): Error: mysql(localhost): Connect failed to database (dbispconfig): Access denied for user 'ispconfig'@'localhost' (using password: YES) - waiting for 25 seconds before retry
    Mar 2 11:35:47 vps dovecot: auth-worker(17909): Error: mysql(localhost): Connect failed to database (dbispconfig): Access denied for user 'ispconfig'@'localhost' (using password: YES) - waiting for 25 seconds before retry
     
  3. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    here is some of my apache error log
    [Fri Mar 02 11:29:18 2018] [warn] [client 173.8.96.194] mod_fcgid: stderr: onnect(): (28000/1045): Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 246, referer: https://vps.foreverpets.com:8080/login/index.php
    [Fri Mar 02 11:29:18 2018] [warn] [client 173.8.96.194] mod_fcgid: stderr: PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 244, referer: https://vps.foreverpets.com:8080/login/index.php
    [Fri Mar 02 11:29:18 2018] [warn] [client 173.8.96.194] mod_fcgid: stderr: PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 246, referer: https://vps.foreverpets.com:8080/login/index.php
    [Fri Mar 02 11:29:18 2018] [warn] [client 173.8.96.194] mod_fcgid: stderr: PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 244, referer: https://vps.foreverpets.com:8080/login/index.php
    [Fri Mar 02 11:29:18 2018] [warn] [client 173.8.96.194] mod_fcgid: stderr: PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 246, referer: https://vps.foreverpets.com:8080/login/index.php
    [Fri Mar 02 11:29:18 2018] [error] [client 173.8.96.194] File does not exist: /var/www/ispconfig/login/dashboard, referer: https://vps.foreverpets.com:8080/login/index.php
     
  4. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    I've be working on this for the last 14 hours. I am at my wits end and I need at least email back up if possible. I had a big uh-oh and had to rebuild the server, re-install ispconfig, and upload my backup files. I have a snapshot of before I uploaded my database dump if there is something that will help with rolling back to before that.
    Any suggestions?
    Thanks for the help (if this is bigger than the forum let me know)
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    So you have just a MySQL login problem, as it seems You can find the cleartext password of the mysql user 'ispconfig' in the config.inc.php file from ISPconfig. Use that cleartext password to set the password of the MySQL user again with e.g. phpmyadmin. And ensure that you did not use skip-networking in your MySQL config files somewhere as this would cause login from localhost to fail.
     
  6. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    Is there anything I need to do once I save and upload that file?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    I did not talked about uploading a file. I suggested that you login to phpmyadmin and set the password of the ispconfig user based on the content of the file /usr/local/ispconfig/interface/lib/config.inc.php that exists on your server.
     
  8. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    Ok I did that and I'm still getting errors in my apache2 error.log file.
    tried restart mysql but is won't let me:
    Stopping MySQL database server: mysqld failed!
     
  9. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    And my mail logs still show password failures
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    You can not login when mysql is not working. check your linux syslog file to find out why mysql fails.
     
  11. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    same thing still, the password isn't working
    Mar 2 19:47:28 vps postfix/trivial-rewrite[3642]: warning: virtual_mailbox_domains lookup failure
    Mar 2 19:47:28 vps postfix/smtpd[4523]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Mar 2 19:47:28 vps postfix/smtpd[4523]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
    Mar 2 19:47:28 vps postfix/smtpd[4523]: NOQUEUE: reject: RCPT from mailx1-2.csloxinfo.com[58.137.249.81]: 451 4.3.5 <mailx1-2.csloxinfo.com[58.137.249.81]>: Client host rejected: Server configuration error; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mailx1-2.csloxinfo.com>
    Mar 2 19:47:31 vps postfix/smtpd[4703]: connect from mail5897.yankeecandle.mkt6496.com[74.121.49.218]
    Mar 2 19:47:31 vps postfix/smtpd[4703]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Mar 2 19:47:31 vps postfix/smtpd[4703]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
    Mar 2 19:47:31 vps postfix/smtpd[4703]: NOQUEUE: reject: RCPT from mail5897.yankeecandle.mkt6496.com[74.121.49.218]: 451 4.3.5 <mail5897.yankeecandle.mkt6496.com[74.121.49.218]>: Client host rejected: Server configuration error; from=<[email protected]1917.com> to=<[email protected]> proto=ESMTP helo=<mail5897.yankeecandle.mkt6496.com>
    Mar 2 19:47:31 vps postfix/smtpd[4703]: disconnect from mail5897.yankeecandle.mkt6496.com[74.121.49.218]
    Mar 2 19:47:33 vps postfix/smtpd[4523]: disconnect from mailx1-2.csloxinfo.com[58.137.249.81]
    Mar 2 19:47:37 vps postfix/smtpd[4577]: warning: hostname 2-195-93-172.reverse-dns does not resolve to address 172.93.195.2: Name or service not known
    Mar 2 19:47:37 vps postfix/smtpd[4577]: connect from unknown[172.93.195.2]
    Mar 2 19:47:37 vps postfix/trivial-rewrite[3642]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
    Mar 2 19:47:37 vps postfix/trivial-rewrite[3642]: warning: virtual_mailbox_domains lookup failure
    Mar 2 19:47:37 vps postfix/smtpd[4577]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
    Mar 2 19:47:37 vps postfix/smtpd[4577]: NOQUEUE: reject: RCPT from unknown[172.93.195.2]: 451 4.3.5 <unknown[172.93.195.2]>: Client host rejected: Server configuration error; from=<dr-seuss-birthday-club-sue=[email protected]> to=<[email protected]> proto=ESMTP helo=<mail.womanleadcow.bid>
    Mar 2 19:47:37 vps postfix/smtpd[4577]: disconnect from unknown[172.93.195.2]
    Mar 2 19:47:37 vps postfix/smtpd[3742]: connect from dq178.mta.exacttarget.com[13.111.14.178]
    Mar 2 19:47:37 vps postfix/trivial-rewrite[3642]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
    Mar 2 19:47:37 vps postfix/trivial-rewrite[3642]: warning: virtual_mailbox_domains lookup failure
    Mar 2 19:47:37 vps postfix/trivial-rewrite[3642]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
    Mar 2 19:47:37 vps postfix/trivial-rewrite[3642]: warning: virtual_mailbox_domains lookup failure
    Mar 2 19:47:37 vps postfix/smtpd[3742]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)
    Mar 2 19:47:37 vps postfix/smtpd[3742]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
    Mar 2 19:47:37 vps postfix/smtpd[3742]: NOQUEUE: reject: RCPT from dq178.mta.exacttarget.com[13.111.14.178]: 451 4.3.5 <dq178.mta.exacttarget.com[13.111.14.178]>: Client host rejected: Server configuration error; from=<[email protected]7.exacttarget.com> to=<[email protected]> proto=ESMTP helo=<dq178.mta.exacttarget.com>
    Mar 2 19:47:37 vps postfix/smtpd[3742]: disconnect from dq178.mta.exacttarget.com[13.111.14.178]
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    You must get the password working in MySQL, use phpmyadmin for that. when the password works, then ispconfig will start working again. and of course, mysql must start first as you can not use a database system that is not started.

    You can test the mysql login on the shell as well:

    mysql -h localhost -u ispconfig -p

    and then neter the password that you can find in the config.inc.php file. If this mysql logn is working again, then ispconfig will start working too. Your whole problem seems not to be an ispconfig issue, its solely amysql problem.
     
  13. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    [email protected]:~# mysql -h localhost -u ispconfig -pmypassword
    ERROR 1045 (28000): Access denied for user 'ispconfig'@'localhost' (using password: YES)
    [email protected]:~#
    I just tried it, grabbed the password out of the config.inc.php and tried to log into mysql from the shell.
     
  14. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    I was able to log in via the root password and run a query so it's working
     
  15. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, then you have not set the password with phpmyadmin correctly yet. so login to phpmyadmin as root, set the password for the ispconfig user and flush privileges or restart mysql.
     
  16. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    done and I still can't log in in the shell with that password for ispconfig. I ran the query in phpmyadmin and flush privileges. no good and mysqld fails to stop when I attempt to restart mysql with service mysql restart
     
  17. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    Is there a reason my when i run netstat -tap | grep mysql i get this:

    tcp 0 0 *:mysql *:* LISTEN 3089/mysqld
    isn't the port supposed to be 3306?
     
  18. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    So I had some success:
    debian-sys-maint was changed in mysql also.
    I used these instructions to change it and the ispconfig password through the shell
    https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html -
    B.5.3.2.2 Resetting the Root Password: Unix and Unix-Like Systems
    So I can get into ISPconfig now...but still need to get everything up and running again...starting with the mail
     
  19. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    Would it be feasible to assume I need to re-install of my ssl's?
     
  20. tmpinsnty

    tmpinsnty Member HowtoForge Supporter

    so I ran the debug server.sh script and it still says ispconfig can't login
    PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!PHP Warning: mysqli_ping() expects para meter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
    but I tried right after this and I can log into mysql with the password saved in config.inc.php. I am also able to login to phpymyadmin with these credentials.

    I did do a tools->resync but it's just been sitting there for the last hour or more.
    upload_2018-3-2_17-48-53.png
     

Share This Page