I’m reading in the release notes of [1.4.3] the enabling of phpMyAdmin Single Sign On support. That is great! But how exactly can the user or admin use it?
I’ve searched the docs for SSO and Single Sign On, but there seems to only explain the command line v-add-sys-pma-sso.
In GitHub I found @eris#1460 explaining the technical stuff. I understand that to use SSO, the first step would be to run v-add-sys-pma-sso on the command line. So I did and I got the output: PMA Hestia-SSO plugin has been succesfully installed (mind the small error in the word successfully which is missing an “s” )
After that I logged in the Web UI, clicked on the DB tab and I saw a new icon next to the edit button (pencil). Hovering this icon (which BTW has a wrong tooltip) I see that the URL, that will be visited if clicked, is as @eris described ( //hestia-sso.php?database=[user-db]&user=[user]&exp=[numbers]&hestia_token=[alphanumeric] ). The problem is that when clicking on that icon, the PMA page opens the Login screen. I would expect it to go directly to the DB inside PMA.
I noticed the double // before hestia-sso.php in the URL so I also tried with one / but that had the same effect. Just went to the login screen.
What is your setup? Nginx + apache2. The only thing that might be an issue is that that there is an difference between the ip you have on “hestia-nginx” and when you visit “phpmyadmin”
The web server replied with status code 302 and then provide another URL for the browser to connect to. This explains why I’m seeing the login screen. But I have no idea why the web server replied like this. I need to dig more into it.
EDIT: I just edited this post to remove the actual client IP address and replace with placeholder text [client_IP_here].