Hi,
I have PHPmyAdmin (PMA) installed on most of my servers in a specific Virtual Host. All my Virtualmin servers have an additional layer of protection with a 2nd factor of authentication (OTP) for logging into Virtualmin, I was wondering if anybody did successfully add OTP to PHPmyAdmin (installed via Virtualmin).
I found Two-factor authentication — phpMyAdmin 5.1.4 documentation which is leveraging Composer to install OTP on a Composer installed PHPmyAdmin (well this is my guess).
I would be interested to know if anybody did it, and how of course
Thanks !
Pierre
PS: I didn’t describe my servers, most of them are Debian 11/12 with the latest Virtualmin and Webmin but I’m not sure this changes anything to my question.
Hello,
Ok I finally succeeded … I installed PMA in a separate virtual host using Composer and then OTP again with Composer. Main difficulty was creating the config storage for more than one user, I had to create a “phpmyadmin” database and giving access to that db to each user in the need of OTP so the config was saved for that user. Without this, OTP capability is just saved for the session duration … Pretty complicated to do especially if you want activation for a lot of users … my case was to protect 2 specific server/users, so it’s good. And do not forget to remove the Virtualmin-installed PMA !
