GUACAMOLE-263: Change user creation to use hash values used by other modules.
Project: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/commit/b4d2f876 Tree: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/tree/b4d2f876 Diff: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/diff/b4d2f876 Branch: refs/heads/master Commit: b4d2f8761aa5f49c13aa857a4370cfbf8a171679 Parents: 5ef7d11 Author: Nick Couchman <[email protected]> Authored: Wed Sep 27 09:38:43 2017 -0400 Committer: Nick Couchman <[email protected]> Committed: Thu Sep 28 07:00:52 2017 -0400 ---------------------------------------------------------------------- .../schema/002-create-admin-user.sql | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/blob/b4d2f876/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/002-create-admin-user.sql ---------------------------------------------------------------------- diff --git a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/002-create-admin-user.sql b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/002-create-admin-user.sql index d348b61..15944a2 100644 --- a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/002-create-admin-user.sql +++ b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/002-create-admin-user.sql @@ -20,8 +20,11 @@ /** * Create the default admin user account and set up full privileges. */ -INSERT INTO [guacamole_user] (username, password_hash, password_date) -VALUES ('guacadmin', HASHBYTES('SHA2_256', 'guacadmin'), getdate()); +INSERT INTO [guacamole_user] (username, password_hash, password_salt, password_date) +VALUES ('guacadmin', + 0xCA458A7D494E3BE824F5E1E175A1556C0F8EEF2C2D7DF3633BEC4A29C4411960, + 0xFE24ADC5E11E2B25288D1704ABE67A79E342ECC26064CE69C5B3177795A82264, + getdate()); INSERT INTO [guacamole_user_permission] SELECT [guacamole_user].[user_id], [affected].[user_id], permission
