jacksonp wrote
> 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/
Did you try this from the docs without the salt part?
-- Generate salt
SET @salt = UNHEX(SHA2(UUID(), 256));
-- Create user and hash password with salt
INSERT INTO guacamole_user (username, password_salt, password_hash)
VALUES ('myuser', @salt, UNHEX(SHA2(CONCAT('mypassword', HEX(@salt)),
256)));
Ref:
https://guacamole.incubator.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-restrict
--
Sent from: http://apache-guacamole-incubating-users.2363388.n4.nabble.com/
