gripfastistech commented on pull request #495: URL: https://github.com/apache/guacamole-client/pull/495#issuecomment-771293738
> editing the MySql backend and setting "guac-totp-key-confirmed" to false for the needed user I needed to do that after I accidentally deleted the profile from my phone app by mistake. Didn't have any mysql login working in the terminal or otherwise (localhost denied for all users, etc...) so that was annoying. I installed on Ubuntu 20.04, but with guac itself installed under tomcat9, from this: [script](https://github.com/MysticRyuujin/guac-install) from MysticRyuujin. I was really wary to force a mysql password change directly since I had just entered in a few client connections and they were working on a complicated internal network. So I installed Adminer and PHP in the OS, manually edited the mysql.cf file, under mysqld heading inside to include "--skip-grant-tables" and restarted the mysql service to gain mysql login via Adminer. This was a temp action. User (missing the QR) had id of "2", set flag to "false" as Red suggested, commented the appended line in the mysql.cf file, restarted mysql, restarted ufw and was able login with the user in question via Guacamole admin. The QR code prompt appeared instantly after password login as expected for the user. Scanned the QR, entered into phone app, logged into Guacamole like a champ, with no risk to the initial mysql setup. thanks @red-erik ! I hope this helps someone in the future...at least until the feature is considered for inclusion as a feature request. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
