search

hassio-addons / addon-phpmyadmin

phpMyAdmin - Home Assistant Community Add-ons
https://addons.community
MIT License
28 stars 6 forks source link

After enabling 2fa on phpmyadmin login UI, I can no longer login #193

Closed charlestephen closed 10 months ago

charlestephen commented 10 months ago

Problem/Motivation

After installing hardware token 2fa on the phpmyadmin login webpage, I can no longer access the underlying application because it claims I don't have the correct PHP plugins installed. This occurs only in Chrome; in Safari, no 2fa webauthn prompt occurs while in Firefox, it doesn't recognize the built in hardware token of the laptop. I can't edit the underlying SQL tables to drop the 2fa requirement and I cannot login via the web or desktop applications.

Expected behavior

For 2fa to work properly even in an ingress situation (or at least be advised not to tweak it so that this doesn't happen).

Actual behavior

Prevented from logging in.

Steps to reproduce

Enable 2fa on the phpmyadmin app using either a passkey or the hardware token of a laptop/phone for webauthn. Restart Home-Assistant. Try to login via different browsers to no avail.

Proposed changes

(If you have a proposed change, workaround or fix, describe the rationale behind it)

charlestephen commented 10 months ago

Removing both MariaDB and PHPMyAdmin then reinstalling corrected the issue