How to access phpmyadmin on DDEV Windows 10 pro localhost with SSL record too long error

1
votes

I am using DDEv and Docker with Windows 10 pro to set up a localhost install of drupal 8.8 using Composer. I have set up and configured the local drupal installation (it is a fresh install) and it appears to be running correctly, but in the admin section of the drupal site I receive a warning to change write permissions of sites/default/settings.php.

I tried to change settings using Filezilla, but it appears that local files in Filezilla do not provide access to write permissions? When I right-click the file in Filezilla, no permissions option appears.

Following troubleshooting tips from ddev, I tried to access phpmyadmin at https://mysitename.ddev.site:8036

Instead of loading phpmyadmin, I got the following error message:

Secure Connection Failed

An error occurred during a connection to dmckimep.ddev.site:8036. SSL received a record that exceeded the maximum permissible length.

Error code: SSL_ERROR_RX_RECORD_TOO_LONG

The page you are trying to view cannot be shown because the authenticity of the received data could not be verified. 

Please contact the website owners to inform them of this problem.

I've been searching around for a couple of hours now and do not find a solution to this. I ran ddev describe and all seems fine with the installation. The drupal site in the container seems to run okay. There are no port conflicts present so far as I have found, so I am not sure why I cannot get access to phpmyadmin.

I am a relative newbie in terms of skills, but have successfully maintained drupal 4-7 on localhost with XAMPP and my web host. Now I am wrestling with the move to drupal 8/composer/docker/ddev. Any suggestions would be much appreciated.

Thank you!

1
dockerssldrupalphpmyadminddev
Hi and welcome to ddev! ddev doesn't support https for phpmyadmin. I'm not sure why, haven't explored that, and it's probably possible to do. But ddev describe doesn't offer you an https URL. Can you say more about why you want https for phpmyadmin? Note that there isn't really a security impact, because the communication with phpmyadmin is just on your machine. - rfay
That did the trick! Thanks! I did not intentionally specify https: just pasted the :8036 at the end of the top level URL. I will have to be careful about checking such details. I have successfully opened phpmyadmin now. Thanks again! - femrich
Hmmm... Hope I am not being rude--tried to find a way to "accept" or up-vote your solution, but don't find it yet. Will keep looking... - femrich
@femrich We appreciate you trying to be a contentious Stack Overflow user. The reason you can't accept this is because it's posted as a "comment." Only "answers" can be accepted. If rfay wishes to post the comment as an answer, you'll be able to accept it then. I'm glad you were able to solve the problem. - Isaac Bennetch
You're not being rude - you're finding your way around! Per @Isaac Bennetch I added a formal answer, you can now mark that as the accepted answer. When answering someone on Stack Overflow it's often best to start out the conversation with a comment IMO, to make sure that the question is fully understood. - rfay

1 Answers

3
votes

ddev's PHPMyAdmin connection doesn't support https, just http. You can find the links for both PHPMyAdmin and MailHog using ddev describe; both are http-only, as in your example, http://mysitename.ddev.site:8036. It would be possible to provide https URLs for PHPMyAdmin and MailHog, but nobody has ever asked for them, and there's no security reason to do so.

Note that the key reason for https on the actual project URL is because real projects run behind https and people need to see problems like mixed content during the development phase. But there's no such need for PHPMyAdmin. However, I'm sure if people ever want it, we'll do it, it's not hard to do.