guacamole-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Goncalo Rosa <goncalo.r...@v2s.us>
Subject RE: password hash in mysql guacamole_user table
Date Mon, 18 Sep 2017 20:09:20 GMT
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:jacksonp2008@gmail.com] 
Sent: Monday, September 18, 2017 14:59
To: user@guacamole.incubator.apache.org
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/

Mime
View raw message