Gabriele.vivinetto at 17:44, 30 September 2024

2024-09-30T17:44:27Z

← Older revision		Revision as of 17:44, 30 September 2024
Line 21:		Line 21:
	WHERE		WHERE
	username = @username;		username = @username;
	</pre>~~Riferimenti~~		</pre>

			== Riferimenti ==
	* [https://sourceforge.net/p/guacamole/discussion/1110834/thread/43a5f262/ Apache Guacamole / Discussion / Help: Reset username passwords from MySQL database.]		* [https://sourceforge.net/p/guacamole/discussion/1110834/thread/43a5f262/ Apache Guacamole / Discussion / Help: Reset username passwords from MySQL database.]

Gabriele.vivinetto: Created page with " {{Stub}} * VERIFICARE TUTTO * Lanciare Mysql nel container docker del DB: docker compose exec guacamole-db bash -c 'mysql -u$MYSQL_USER -p$MYSQL_PASSWORD'

 SET @username= 'myuser';  SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = '@username';  -- Update user and hash password with salt SET @salt = UNHEX(SHA2(UUID(), 256)); USE guacamole_db; UPDATE guacamole_u..."

2024-09-30T17:44:14Z

Created page with " {{Stub}} * VERIFICARE TUTTO * Lanciare Mysql nel container docker del DB: docker compose exec guacamole-db bash -c 'mysql -u$MYSQL_USER -p$MYSQL_PASSWORD' <pre> SET @username= 'myuser'; SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = '@username'; -- Update user and hash password with salt SET @salt = UNHEX(SHA2(UUID(), 256)); USE guacamole_db; UPDATE guacamole_u..."

New page

{{Stub}}

* VERIFICARE TUTTO
* Lanciare Mysql nel container docker del DB:

docker compose exec guacamole-db bash -c 'mysql -u$MYSQL_USER -p$MYSQL_PASSWORD'

<pre>
SET @username= 'myuser';

SELECT user_id FROM guacamole_user INNER JOIN guacamole_entity ON guacamole_entity.entity_id = guacamole_user.entity_id WHERE guacamole_entity.name = '@username';

-- Update user and hash password with salt
SET @salt = UNHEX(SHA2(UUID(), 256));
USE guacamole_db;
UPDATE guacamole_user
SET
password_salt = @salt,
password_hash = UNHEX(SHA2(CONCAT('mypassword', HEX(@salt)), 256))
WHERE
username = @username;
</pre>Riferimenti

* [https://sourceforge.net/p/guacamole/discussion/1110834/thread/43a5f262/ Apache Guacamole / Discussion / Help: Reset username passwords from MySQL database.]

Resettare la password di un utente Guacamole - Revision history

Gabriele.vivinetto at 17:44, 30 September 2024