guacamole-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Pollock <jacksonp2...@gmail.com>
Subject Re: password hash in mysql guacamole_user table
Date Mon, 18 Sep 2017 20:11:24 GMT
Thanks, Ive read the docs.  I just want to inserted a hashed password, no
salt.  What is the mechanism to hash? It doesn't work per my example.


Regards,

-Steve

(415) 320-1102 <https://www.google.com/voice/#phones>

<º(((><    <º(((><   <º(((><

On Mon, Sep 18, 2017 at 1:09 PM, richk <rk5devmail@gmail.com> wrote:

> 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/
>

Mime
View raw message