Resettare la chiave TOTP in Guacamole: Difference between revisions
Jump to navigation
Jump to search
Created page with "* Lanciare Mysql nel container docker del DB: docker compose exec guacamole-db bash -c 'mysql -u$MYSQL_USER -p$MYSQL_PASSWORD' use guacamol_db; * Identificare l'ID dello username da modificare: SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = 'guacadmin'; * Identificato l'ID, resettare il flag guac-totp-key-confirmed per quello user_id UPDATE guacamole_user_attr..." |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Con Script == | |||
* C'è uno script: [https://iriarte.it/index.php/2021/11/02/resetting-guacamole-otp-for-an-user/ Resetting Guacamole OTP for an user | Doing the blog thing] | |||
== Manualmente == | |||
* Lanciare Mysql nel container docker del DB: | * Lanciare Mysql nel container docker del DB: | ||
docker compose exec | docker compose exec remote.metrica.it-db bash -c 'mariadb -u$MARIADB_USER -p$MARIADB_PASSWORD guacamole_db' | ||
* Identificare l'ID dello username da modificare: | * Identificare l'ID dello username da modificare: | ||
SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = 'guacadmin'; | SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = 'guacadmin'; | ||
+---------+| user_id |+---------+| 1 |+---------+ | |||
* Identificato l'ID, resettare il flag guac-totp-key-confirmed per quello user_id | * Identificato l'ID, resettare il flag guac-totp-key-confirmed per quello user_id | ||
| Line 15: | Line 18: | ||
* [https://forum.cloudron.io/topic/5051/resetting-2fa-for-guacamole?_=1727711714510 Resetting 2FA for Guacamole | Cloudron Forum] | * [https://forum.cloudron.io/topic/5051/resetting-2fa-for-guacamole?_=1727711714510 Resetting 2FA for Guacamole | Cloudron Forum] | ||
* [https://www.mogilowski.net/2020/05/06/two-factor-authentication-with-guacamole-1-1-0-part-4/ Two-factor authentication with Guacamole 1.1.0 (Part 4) – Sebastian Mogilowski's Blog] | |||
Latest revision as of 17:27, 19 January 2026
Con Script
- C'è uno script: Resetting Guacamole OTP for an user | Doing the blog thing
Manualmente
- Lanciare Mysql nel container docker del DB:
docker compose exec remote.metrica.it-db bash -c 'mariadb -u$MARIADB_USER -p$MARIADB_PASSWORD guacamole_db'
- Identificare l'ID dello username da modificare:
SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = 'guacadmin';
+---------+| user_id |+---------+| 1 |+---------+
- Identificato l'ID, resettare il flag guac-totp-key-confirmed per quello user_id
UPDATE guacamole_user_attribute SET attribute_value='false' WHERE attribute_name = 'guac-totp-key-confirmed' and user_id = '1';