Resettare la chiave TOTP in Guacamole: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
|||
| Line 5: | Line 5: | ||
* 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 | ||
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';