PHPMyadmin just won’t load. When trying to access the phpmyadmin page, it gives a took too long to respond error on multiple browsers. I’ve changed PHP versions to see if this would be the cause of it, however it isn’t so.
It is on a fresh install of HestiaCP, so not sure why it would fail.
It is not proxied on CloudFlare either. It does have a letsencrypt SSL generated on the backend though.
You need to change the owner of the phpMyAdmin files. I’m sure someone will be able to tell you the commands you need. I can’t remember what changes I needed.
Disabling Letsencrypt seems to have fixed it, after which I ran into the Existing configuration file (/etc/phpmyadmin/config.inc.php) is not readable. and I fixed that by running chown -R root:www-data /etc/phpmyadmin/
How do I now get Phpmyadmin to work with Letsencrypt enabled? The templates are all default, nothing special has been done, it’s a fresh install.
I thought it would be CloudFlare proxying, however it wasn’t being proxied so I ruled that out.
I even tried doing a strict SSL on a custom rule configuration for the hostname, but that didn’t work either.
I pinged the hostname and it was timing out, so I assumed some ports were closed. The port 80 was open, however 443 (SSL) and 21 (FTP) was closed. I totally mixed up 465 SMTP with 443 SSL. so I assumed that all the necessary ports were opened.
I also checked https://letsdebug.net/ and ran an http-01 test against the hostname and it was giving me connectivity errors which. This helped me to see if the LetsEncrypt SSL was generated properly.
sudo iptables -I INPUT 6 -m state --state NEW -p tcp --dport 21 -j ACCEPT
sudo iptables -I INPUT 6 -m state --state NEW -p tcp --dport 80 -j ACCEPT
sudo iptables -I INPUT 6 -m state --state NEW -p tcp --dport 443 -j ACCEPT
sudo netfilter-persistent save
Because the server is deployed on Oracle Cloud, I added an Ingress Rule (Virtual Cloud Network > My Server’s VCN > Default Security List) for ports 21, 80 and 443 with the following details:
Source CIDR: 0.0.0.0/0
IP Protocol: TCP
Source Port Range: All
Destination Port Range: 443
Source CIDR: 0.0.0.0/0
IP Protocol: TCP
Source Port Range: All
Destination Port Range: 80
Source CIDR: 0.0.0.0/0
IP Protocol: TCP
Source Port Range: All
Destination Port Range: 21