guacamole-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Goncalo Rosa <>
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
    password_salt = @salt,
    password_hash = UNHEX(SHA2(CONCAT('mypassword', HEX(@salt)), 256))
    username = 'myuser';


Gonçalo Rosa

W:                   Skype: goncalo_rosa

-----Original Message-----
From: jacksonp [] 
Sent: Monday, September 18, 2017 14:59
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

But that won't work in a binary(32) field.

Anyone know how to do this correctly?


Sent from:

View raw message