Hello Jackson
Use this:
------------------------------------------
-- Generate salt
SET @salt = UNHEX(SHA2(UUID(), 256));
-- Update user and hash password with salt
UPDATE guacamole_user
SET
password_salt = @salt,
password_hash = UNHEX(SHA2(CONCAT('mypassword', HEX(@salt)), 256))
WHERE
username = 'myuser';
-------------------------------------------------------------------------
Gonçalo Rosa
W: www.v2s.us Skype: goncalo_rosa
-----Original Message-----
From: jacksonp [mailto:[email protected]]
Sent: Monday, September 18, 2017 14:59
To: [email protected]
Subject: password hash in mysql guacamole_user table
trying to manually set a password via mysql guacamole_user table. Not concerned
about security, not salting, just want to enter any kind of password that will
work.
Documentation says if password_salt is null, it just ignores.
I tried hashing with sha256 which is how I read the doc.
mkpasswd -m sha-256
Password:
$5$AlqeE/FaJQ.BC$oB5w9sisUTuFjLCQMknBS6XVFSEWH5cAs/84ajS.dO5
But that won't work in a binary(32) field.
Anyone know how to do this correctly?
Thanks!
--
Sent from: http://apache-guacamole-incubating-users.2363388.n4.nabble.com/
