From 7b334998116316d1772b1ce1395818d755308bf0 Mon Sep 17 00:00:00 2001 From: Nikat Date: Thu, 20 May 2021 14:32:50 +0300 Subject: MySQL Backend Patch for scram-sha512 (#3582) * Update mysql.new.sql scram-sha512 does not work, because serverkey is longer, then that array. All passwords was unhashed. * Update mysql.sql --- sql/mysql.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql/mysql.sql') diff --git a/sql/mysql.sql b/sql/mysql.sql index 33ef98d3..7feaf5d0 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -19,8 +19,8 @@ CREATE TABLE users ( username varchar(191) PRIMARY KEY, password text NOT NULL, - serverkey varchar(64) NOT NULL DEFAULT '', - salt varchar(64) NOT NULL DEFAULT '', + serverkey varchar(128) NOT NULL DEFAULT '', + salt varchar(128) NOT NULL DEFAULT '', iterationcount integer NOT NULL DEFAULT 0, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -- cgit v1.2.3