SOLVED Resetting 2FA for Guacamole

[alexdimarco]

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;

[girish]

@alexdimarco sure, open the app's web terminal. Then on the top, you see the MySQL button. If you click it, it will paste the CLI command to access mysql. Just press enter and it will give you the mysql prompt. After that, you can try the SELECT and UPDATE commands.

[alexdimarco]

@girish Thanks! - should have figured that out - didn't see the button