Keywords: WordPress - AWS - Technical issue - Connectivity (SSH/FTP) bnsupport ID: 4a2908ef-0a4b-db46-6751-35d64c6b521a Description:
Start Bitnami WordPress instance in AWS Lightsail.
Connect to WordPress instance using browser.
Ensure that correct Key Pair is being used for instance.
Generate .ppk file for PUTTY
Create new PUTTY session using said credentials. (Can provide credentials upon request).
Start PUTTY session.
Attempt to connect to phpmyadmin (localhost) via browser.
Connect fails / browser timesout.
Error : Forwarded connection refused by remote: Connect failed [Name or service not known].
Would it be possible for assistance to determine why the tunnel is not working.
What are the security implications of the changes made to the apache configuration file?, ie, no longer using ssh tunnel.
Allowing remote connections to phpMyAdmin allows other users (or bots) to run brute force attacks against your phpMyAdmin login form, which will give them access to your database in case they succeed. That’s why we recommend using the SSH tunnel instead. These attacks can be mitigated, but the most secure way of accessing phpMyAdmin is with SSH tunnels.
Can you try the SSH tunnel again and set PuTTY in debug mode sharing with us a screenshot of the error logs you get? Can you also start the tunnel and run the next commands from your local computer? They are similar to the ones that Jota shared previously, but for the tunnel port
What if I need to connect to phpmyadmin from a different location with different IP address etc?
I understand you configured public access to your public IP address only, is that correct? That’s a mitigation of the bots attack as well, however you can be affected if your public IP address changes or you move to a different IP address (i.e. when you are trying to access from any other place).
I also understand your SSH connection works fine, so you should be able to SSH connect to your instance, allow access to your new source IP address and get to phpMyAdmin, but that requires additional steps. I think trying to debug SSH tunnel a little bit more is the better option here. It is weird the tunnel isn’t working because you can SSH to the server.
I have no recollection of login info for phpmyadmin (username and password), how do I find the credentials?
The default database password can be found in the /home/bitnami/bitnami_credentials file, unless you have already updated the password for the root user in MySQL.
We have installed “WordPress Certified by Bitnami and Automattic” over AWS instance
Description: Unable to connect to phpmyadmin (localhost) via browser
Configured SSH, defined Tunnel.
over SSH log captured:
2021-07-28 14:42:22 Opening connection to locahost:80 for forwarding from 127.0.0.1:65314
2021-07-28 14:42:22 Forwarded connection refused by remote: Connect failed [Name or service not known]
Ran bnsupport-tool, it created and uploadedsupport bundle with Id: a8258454-d7eb-7064-ff59-dc743084e88c
As per bnsupport-tool:
Server ports 22, 80 and/or 443 are not publicly accessible.
Port 80 is accessible over Security-Group.