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..." |
mNo edit summary |
||
| 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: | ||
Revision as of 16:19, 30 September 2024
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 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';