Con Script
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';
Riferimenti