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..." |
(No difference)
|
Revision as of 16:18, 30 September 2024
- 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_attribute SET attribute_value='false' WHERE attribute_name = 'guac-totp-key-confirmed' and user_id = '1';