phyMyAdmin installed from Web App Installer protected directory

Virtualmin
1
SYSTEM INFORMATION
OS type and version Rocky Linux 10.1
Webmin version 2.630
Usermin version 2.530
Virtualmin version 8.1.0 Professional
Theme version 26.30
Apache version 2.4.63
Package updates All installed packages are up to date

Created sub server databases.mainwebsite.com
Installed phpMyAdmin from Web Apps and set it for system default with protected directory I still get 502 error

If I uninstall and reinstall phpMyAdmin and set as system default without protected directory the button in edit database works fine and can log into phpMyAdmin

Is there still an issue with using phpMyAdmin as system default with protected directory?

I asked back in February https://forum.virtualmin.com/t/virtualmin-8-phpmyadmin-global/136566

If it does work maybe it is my VPS :frowning:

2

What exactly isn’t working though? Do you get a basic auth username and password prompt? Are there any error messages?

3

@Ilia
Yes when I click the phpMyAdmin button in manage database it will open new tab in browser, navigate to the correct sub server and I get a basic auth pop up. I enter server owner user pass and that is when I get the error.

4

What kind of error do you get exactly? And are you using Apache or Nginx?

5

@Ilia
I get same error that is picture attached in link first post

I’m on Apache web server

Thanks

6

Oh dang, can’t believe I missed that! It was still a bug, but it’s fixed now for good.

The issue was that when phpMyAdmin runs behind basic auth, Apache and Nginx both consume the authorization header and only send AUTH_TYPE and REMOTE_USER to PHP-FPM, so the password never got passed along.

Apply this patch and let me know if it fixes the issue:

webmin patch https://github.com/virtualmin/virtualmin-gpl/commit/c18f880
7

@Ilia

Yes! working great now :grin:
Thanks for the work and assistance