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
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
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
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)
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.
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.
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!
You can not login when mysql is not working. check your linux syslog file to find out why mysql fails.
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]
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.
root@vps:~# mysql -h localhost -u ispconfig -pmypassword ERROR 1045 (28000): Access denied for user 'ispconfig'@'localhost' (using password: YES) root@vps:~# I just tried it, grabbed the password out of the config.inc.php and tried to log into mysql from the shell.
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.
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
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?
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
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.
