Ran into an issue with resetting 2FA for a user... the instructions for Guacamole seem to be editing the database as follows but I am having difficulty translating this to the Cloudron install... would someone be able to provide instructions that would work for this?
mysql -u root -p
use guacamoldb;
SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = 'guacadmin';
Now you get the userid of the user guacadmin which should be #1.
Reset totp for user with id #1.
UPDATE guacamole_user_attribute SET attribute_value='false' WHERE attribute_name = 'guac-totp-key-confirmed' and user_id = '1';
quit;