Unable to access phpmyadmin on mac

AbsoluGroupe 2020-01-13 20:17:38 UTC #1

Keywords: WordPress + NGINX + SSL - AWS - Technical issue - Connectivity (SSH/FTP)
bnsupport ID: 2511a9d5-ad04-356b-f048-6432c823daf7
Description:
Hi,

I tried to no avail all possible combinations to access phpmyadmin on a mac using https://docs.bitnami.com/aws/apps/wordpress-pro/get-started/access-phpmyadmin/ or https://community.bitnami.com/t/unable-to-access-phpmyadmin/59813/4

I have Varnish installed on server tried on port 81, 443 and then 80.

On port 81

Command line

ssh -N -L888:127.0.0.1:81 -i ~/.ssh/KEYFILE.pem bitnami@SERVER-IP

Browser
http://127.0.0.1:8888/phpmyadmin

Safari Can't Connect to the Server
Safari can't open the page "127.0.0.1:81/phpmyadmin/" because Safari can't connect to the server "127.0.0.1".

On port 443:

Command line

ssh -N -L 8443:127.0.0.1:443 -i ~/.ssh/KEYFILE.pem bitnami@SERVER_IP

Browser
http://localhost:8443/phpmyadmin

400 Bad Request

The plain HTTP request was sent to HTTPS port
nginx/1.16.1

On port 80:

Command line

ssh -N -L888:127.0.0.1:80 -i ~/.ssh/KEYFILE.pem bitnami@SERVER-IP

Browser
http://127.0.0.1:8888/phpmyadmin

Safari Can't Connect to the Server
Safari can't open the page "127.0.0.1:80/phpmyadmin/" because Safari can't connect to the server "127.0.0.1".

Just don't get it.

Bitnami support tool code: 2511a9d5-ad04-356b-f048-6432c823daf7

In the last laps of getting rid of squashing all the bugs.

Please advise on a solution.

Dominique

michiel 2020-01-14 09:29:10 UTC #2

Hi @AbsoluGroupe,

Can you try using port 80 and tell me the output?

ssh -N -L 8888:127.0.0.1:80 -i KEYFILE bitnami@SERVER-IP

And check if the page is accessible?

Regards,
Michiel

AbsoluGroupe 2020-01-14 20:58:51 UTC #3

The authenticity of host 'XX.XXX.XX.XX (XX.XXX.XX.XX)' can't be established.
ECDSA key fingerprint is SHA256:+QqqC5Rl+NHfOqwqcplYDN+Dw/Y5YGJ9BPtm+J5CD6U.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'XX.XXX.XX.XX' (ECDSA) to the list of known hosts.

http://127.0.0.1:8888/phpmyadmin

Safari Can't Connect to the Server
Safari can't open the page "127.0.0.1:81/phpmyadmin/" because Safari can't connect to the server "127.0.0.1".

AbsoluGroupe 2020-01-14 21:24:35 UTC #4

New stack with RDS Aurora, EFS Fixed, Redis Local and Varnish Local and 5 WordPress websites.

15d8efab-02f5-04f2-b28f-2fcbc2c6f90f

If I can finally connect to phpmyadmin I'm done - no more bugs.

tomasp 2020-01-15 10:37:35 UTC #5

Hi @AbsoluGroupe,

I see an option that you haven't tried:

Using port 443 but using HTTPS as protocol:

ssh -N -L 8443:127.0.0.1:443 -i ~/.ssh/KEYFILE.pem bitnami@SERVER_IP

And then browse to https://localhost:8443/phpmyadmin (Note it is using https and not http)

AbsoluGroupe 2020-01-15 16:23:00 UTC #6

ssh -N -L 8443:127.0.0.1:443 -i ~/.ssh/AbsoluGroupe.pem bitnami@XX.XXX.XXX.XX
The authenticity of host 'XX.XXX.XXX.XX (XX.XXX.XXX.XX)' can't be established.
ECDSA key fingerprint is SHA256:CWEDuiH9HtxkGw4e1vSuuGlrjMJAgJUbuOYA4ru4HNQ.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'XX.XXX.XXX.XX' (ECDSA) to the list of known hosts.

Safari put up a warning that the connection wasn't secure.
Clicked on continue

Safari Can't Connect to the Server
Safari can't open the page "https://localhost/phpmyadmin/" because Safari can't connect to the server "localhost".

AbsoluGroupe 2020-01-15 16:25:50 UTC #7

In Google Chrome

Your connection is not private
Attackers might be trying to steal your information from localhost (for example, passwords, messages, or credit cards). Learn more
NET::ERR_CERT_REVOKED

AbsoluGroupe 2020-01-15 16:31:56 UTC #8

Safari:

AbsoluGroupe 2020-01-15 16:34:24 UTC #9

Oups Firefox not Safari.

I clicked on accept the risk and continue.

tomasp 2020-01-16 10:33:32 UTC #10

Hi @AbsoluGroupe,

I think I was able to reproduce the issue. At least for Safari I got the same error.

The problem in my case was that after accepting all the warning messages I was redirected to https://localhost/phpmyadmin instead to https://localhost:8443/phpmyadmin. After adding again the port I was able to access.

AbsoluGroupe 2020-01-16 17:28:38 UTC #11

I noticed also that it defaults back to https://localhost/phpmyadmin and replaced it with https://localhost:8443/phpmyadmin same error message as before. And it puts it back to https://localhost/phpmyadmin

I was wondering, nowhere in the guide https://docs.bitnami.com/aws/apps/wordpress-pro/get-started/access-phpmyadmin/ does it refer to opening ports in the security group for that specific IP or specific port is it ASS U ME D that everyone will do it?

This is my security group settings for the instance:

I am using a NLB Network Load Balancer that has a HTTP listener on port 443 as each WordPress install takes care of TLS/SSL

Please advise

Dominique

tomasp 2020-01-17 12:13:52 UTC #12

Hi @AbsoluGroupe,

In order to run a SSH tunnel you only need to open the SSH port (22) so it should be a matter of firewalls. Also, the Bitnami documentation doesn't mention anything about this because the SSH port is already opened.

I am going to forward this issue to another team, maybe they have other ideas about what could be the issue.
Something that comes to my mind is that maybe you have a redirection cached in the browser, I would try cleaning the Browser cache or trying on an incognito window.

AbsoluGroupe 2020-01-17 14:51:49 UTC #13

I have enabled on Safari the hidden "Develop" menu and use "empty caches" like a addict and use private window(s) like there was an unlimited supply of them - and there are

So far it seems that I'm dicking around to be able to replace the admin email only on the initial installation of WordPress from the Bitnami stack so if god forbids WordPress crashes usually because of a plugin I can get the link to access WordPress in recovery mode. How come I can't get the email from WordPress to confirm new email on the Bitnami WordPress install? Actually come to think of it it's a All in one WP migration kind of WordPress install.

Please advise

Dominique

AbsoluGroupe 2020-01-22 05:51:34 UTC #14

It's been 5 days

I would really like to access phpmyadmin...

jsalmeron 2020-01-22 15:15:53 UTC #15

Hi,

We'll need to check what is wrong with nginx. For the time being, could you try executing the command like this?

sudo ssh -L 80:127.0.0.1:80 -i PATH_TO_YOUR_KEY bitnami@IP-ADDRESS

Then access 127.0.0.1/phpmyadmin

Hope it helps.

Best regards,

Javier J. Salmerón

Was my answer helpful? Click on

AbsoluGroupe 2020-01-23 04:56:33 UTC #16

Hi,

The only difference that I got is that I'm getting a password request.

Screen output for command line:

sudo ssh -L 80:127.0.0.1:80 -i ~/.ssh/AbsoluGroupe.pem bitnami@XX.XXX.XXX.XXX
Password:
The authenticity of host 'XX.XXX.XXX.XXX (XX.XXX.XXX.XXX)' can't be established.
ECDSA key fingerprint is SHA256:S2Lj7rcQsgNZV3JvE4DHu6CVe9z6VIrFPJ5lcXNmPjc.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'XX.XXX.XXX.XXX' (ECDSA) to the list of known hosts.
Welcome to Ubuntu 18.04.3 LTS (GNU/Linux 4.15.0-1057-aws x86_64)

System information as of Thu Jan 23 04:45:31 UTC 2020

System load: 0.09 Processes: 108
Usage of /: 53.7% of 9.63GB Users logged in: 0
Memory usage: 28% IP address for ens5: 10.0.1.167
Swap usage: 48%

Canonical Livepatch is available for installation.
- Reduce system reboots and improve kernel security. Activate at:
  https://ubuntu.com/livepatch

  | _ |_) |_ _ _  __ _ _ __ (_)
  | _ \ |  _| ' \/ _` | '  \| |
  |___/_|\__|_|_|\__,_|_|_|_|_|

*** Welcome to the Bitnami WordPress with NGINX and SSL 5.3.2-1 ***
*** Documentation: https://docs.bitnami.com/aws/apps/wordpress-pro/ ***
*** https://docs.bitnami.com/aws/ ***
*** Bitnami Forums: https://community.bitnami.com/ ***

For frequently used commands, please run:

sudo /opt/bitnami/bnhelper-tool

Last login: Thu Jan 23 04:41:41 2020 from XX.XXX.XXX.XXX
To run a command as administrator (user "root"), use "sudo ".
See "man sudo_root" for details.

I then opened a new private window and cleared all the caches for Safari.

Still can't connect.

jsalmeron 2020-01-23 09:51:14 UTC #17

Hi,

Then try in two separate terminal tabs this

Tab 1

sudo ssh -L 80:127.0.0.1:80 -i ~/.ssh/AbsoluGroupe.pem bitnami@XX.XXX.XXX.XXX

Tab 2

sudo ssh -L 81:127.0.0.1:81 -i ~/.ssh/AbsoluGroupe.pem bitnami@XX.XXX.XXX.XXX

Best regards,

Javier J. Salmerón

Was my answer helpful? Click on

AbsoluGroupe 2020-01-23 21:21:02 UTC #18

It's cerveza time!

THANK YOU

Dominique

AbsoluGroupe 2020-01-23 22:11:28 UTC #19

Hi,

I put the username and password that I use in all my wp-config.php and it didn't work.

Keep in mind that this is to access the RDS Aurora database,

In related documentation it says Log in to phpMyAdmin with the username root and the randomly-generated password generated when the server was deployed https://docs.bitnami.com/aws/how-to/get-started-wordpress-aws-marketplace-beginner/ That instance and associated logs is long gone and in any case if my WordPress installations can access the database with the username and password that I entered I should theoretically be able to login to phpMyAdmin with the same credentials.

Please advise

Dominique

AbsoluGroupe 2020-01-23 23:42:23 UTC #20

Found the answer in https://docs.bitnami.com/aws/how-to/migrate-database-rds/#using-phpmyadmin-1

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!