abesnier
commented
1 year ago Indeed, I believe schemas are not compatible between PG versions. I should mention it, and add a paragraph in the updated method about that.
That being said, here's what should work (provided you have access to the machine without Guacamole!)
Enter the docker conainer:
docker exec -it guacamole bash
Connect to the database:
psql -U guacamole guacamole_db
Find the user id of the user:
SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = 'your user name';
This should return something like:
user_id
---------
2
(1 row)
Run the following command:
UPDATE guacamole_user_attribute SET attribute_value='false' WHERE attribute_name = 'guac-totp-key-confirmed' and user_id = 'the id you found in the previous step';
quit;Exit the container, and try to login again to guacamole. You should be prompted with the MFA registration again (qr code, etc...)
EDIT: one-liner should be something like: docker exec -it guacamole bash -c "psql -U guacamole guacamole_db -c \"UPDATE guacamole_user_attribute SET attribute_value='false' WHERE attribute_name = 'guac-totp-key-confirmed' and user_id = (SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = 'your username');\""
q20
Hey there
After following the guide to upgrade PostgreSQL to v14, my docker instance now successfully starts and I can log in with my stored username and password, only the 2FA fails:
My clocks are all synced, so I have no idea what next to try. Is there a way to reinitiate the setup of 2FA for a given user from the CLI?