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 <rk5devm...@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/ >