Resettare la chiave TOTP in Guacamole - Revision history

Gabriele.vivinetto: /* Manualmente */

2026-01-19T17:27:31Z

Manualmente

← Older revision		Revision as of 17:27, 19 January 2026
Line 5:		Line 5:
	* Lanciare Mysql nel container docker del DB:		* Lanciare Mysql nel container docker del DB:

	docker compose exec ~~guacamole~~-db bash -c '~~mysql~~ -u$~~MYSQL_USER~~ -p$~~MYSQL_PASSWORD~~'		docker compose exec remote.metrica.it-db bash -c 'mariadb -u$MARIADB_USER -p$MARIADB_PASSWORD guacamole_db'
	~~use guacamol_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

Gabriele.vivinetto at 17:04, 30 September 2024

2024-09-30T17:04:11Z

← Older revision		Revision as of 17:04, 30 September 2024
Line 19:		Line 19:

	* [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]

Gabriele.vivinetto at 16:19, 30 September 2024

2024-09-30T16:19:36Z

← Older revision		Revision as of 16:19, 30 September 2024
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:

Gabriele.vivinetto: 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..."

2024-09-30T16:18:00Z

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..."

New page

* 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';

== Riferimenti ==

* [https://forum.cloudron.io/topic/5051/resetting-2fa-for-guacamole?_=1727711714510 Resetting 2FA for Guacamole | Cloudron Forum]