I am facing a weird issue here. So my EC2 Instance on AWS (Linux 5.10.0-28-cloud-amd64 #1 SMP Debian 5.10.209-2 x86_64) was working fine till yesterday. Today suddenly FTP and ISPconfig stop working. ISPConfig starts showing a white page with 500 Errors. Using SSH, I found the below errors in the apache2 log file. Code: [Wed May 08 10:32:11.242767 2024] [fcgid:warn] [pid 2768221:tid 139896228386560] [client 223.178.209.99:13381] mod_fcgid: stderr: PHP Fatal error: Uncaught Error: Call to a member function queryOneRecord() on bool in /usr/local/ispconfig/interface/lib/app.inc.php:173 [Wed May 08 10:32:11.242799 2024] [fcgid:warn] [pid 2768221:tid 139896228386560] [client 223.178.209.99:13381] mod_fcgid: stderr: #0 /usr/local/ispconfig/interface/lib/app.inc.php(97): app->conf() [Wed May 08 10:32:11.242802 2024] [fcgid:warn] [pid 2768221:tid 139896228386560] [client 223.178.209.99:13381] mod_fcgid: stderr: #1 /usr/local/ispconfig/interface/lib/app.inc.php(411): app->initialize_session() [Wed May 08 10:32:11.242805 2024] [fcgid:warn] [pid 2768221:tid 139896228386560] [client 223.178.209.99:13381] mod_fcgid: stderr: #2 /usr/local/ispconfig/interface/web/login/index.php(430): require_once('/usr/local/ispc...') [Wed May 08 10:32:11.242807 2024] [fcgid:warn] [pid 2768221:tid 139896228386560] [client 223.178.209.99:13381] mod_fcgid: stderr: #3 {main} [Wed May 08 10:32:11.242810 2024] [fcgid:warn] [pid 2768221:tid 139896228386560] [client 223.178.209.99:13381] mod_fcgid: stderr: thrown in /usr/local/ispconfig/interface/lib/app.inc.php on line 173 Then i noticed that ispconfig database is not visible in my phpmyadmin even i was login as root user. But it is accessible from SSH command line. So i get the backup from RDS snapshot and create a new database and link it with ISPConfig (/usr/local/ispconfig/interface/lib/config.inc.php). Now ISPConfig is start working but i am still not able to login. I did tried ispconfig_update.sh and ispconfig_update --force as well but the situation is still the same. Main concerns - Why ISPConfig database is not accessible from phpmyadmin as the root user? - I need to check the TLS issue with an FTP account but not able to get the list of FTP users created from ISPConfig. - Don't know it's affecting anything else.
Run the test script from the 'Read before posting!': https://forum.howtoforge.com/threads/please-read-before-posting.58408/
Here is the test result. Also tried rebooting the server. Code: ##### SERVER ##### IP-address (as per hostname): ***.***.***.*** [WARN] could not determine server's ip address by ifconfig [INFO] OS version is Debian GNU/Linux 11 (bullseye) [INFO] uptime: 05:32:27 up 14:36, 1 user, load average: 15.66, 20.24, 23.99 [INFO] memory: total used free shared buff/cache available Mem: 453Mi 360Mi 7.0Mi 4.0Mi 85Mi 75Mi Swap: 0B 0B 0B [INFO] systemd failed services status: UNIT LOAD ACTIVE SUB DESCRIPTION 0 loaded units listed. [INFO] ISPConfig is installed. ##### ISPCONFIG ##### ISPConfig version is 3.2.11p2 ##### VERSION CHECK ##### [INFO] php (cli) version is 7.4.33 [INFO] php-cgi (used for cgi php in default vhost!) is version 7.4.33 ##### PORT CHECK ##### [WARN] Port 143 (IMAP server) seems NOT to be listening [WARN] Port 993 (IMAP server SSL) seems NOT to be listening [WARN] Port 110 (POP3 server) seems NOT to be listening [WARN] Port 995 (POP3 server SSL) seems NOT to be listening [WARN] Port 25 (SMTP server) seems NOT to be listening [WARN] Port 465 (SMTP server SSL) seems NOT to be listening [WARN] Port 25 (SMTP server) seems NOT to be listening ##### MAIL SERVER CHECK ##### [WARN] I found no "smtp" entry in your postfix master.cf [WARN] I found no "submission" entry in your postfix master.cf [INFO] this is not critical, but if you want to offer port 587 for smtp connections you have to enable this. [WARN] I found no "smtps" entry in your postfix master.cf [INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) connections you have to enable this. ##### RUNNING SERVER PROCESSES ##### [INFO] I found the following web server(s): Apache 2 (PID 1842) [WARN] I could not determine which mail server is running. [WARN] I could not determine which pop3 server is running. [WARN] I could not determine which imap server is running. [INFO] I found the following ftp server(s): PureFTP (PID 2000) ##### LISTENING PORTS ##### (only () Local (Address) [anywhere]:21 (2000/pure-ftpd) [anywhere]:22 (605/sshd:) [localhost]:11211 (553/memcached) *:*:*:*::*:22 (605/sshd:) *:*:*:*::*:443 (1842/apache2) *:*:*:*::*:8080 (1842/apache2) *:*:*:*::*:80 (1842/apache2) *:*:*:*::*:8081 (1842/apache2) ##### IPTABLES ##### Chain INPUT (policy ACCEPT) target prot opt source destination f2b-pure-ftpd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 21 Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination Chain f2b-pure-ftpd (1 references) target prot opt source destination REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable RETURN all -- [anywhere]/0 [anywhere]/0 ##### LET'S ENCRYPT ##### acme.sh is installed in /root/.acme.sh/acme.sh
Can you please elaborate on what's wrong with PHP 7.4? It was working smoothly with ISPConfig previously.
Update: I tried manually assigning the ispconfig database to ispconfig user using the below command. But i still don't know why the database got unlinked from the DB user. GRANT ALL PRIVILEGES ON db_ispconfig.* TO 'user_ispconfig'@'***.***.***.***'; Now I can log in to ISPConfig. but now getting the below error while accessing the "Sites" section. Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
Update: The issue has been resolved. It wasn't related to ISPConfig but rather an update of AWS RDS. Somehow the database got unlinked and permissions got changed for the ispconfig db user. now I assigned permission to the ISPConfig user using the following command, and now ISPConfig is working correctly: Code: GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO 'db_ispconfig '@'***.**.***.**'; I will investigate further to understand why this occurred. Thanks to everyone for their support and understanding.
