Hashes over 65535 in length triggers database error

[rixvet]

The ./hashcat/tools/luks2hashcat.py tooling (can) produce hashes which are over 65535 in length. Which are to be used together with LUKS hash algoritm 29521 (new in hashcat 6.2.6). When trying to insert into this into hashtopolis it triggers an database error:

PHP Fatal error:  Uncaught PDOException: 
SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column 'hash' (max = 65535); use BLOB or TEXT instead in /var/www/hashtopolis/inc/Util.class.php:1301\nStack trace:\n#0
/var/www/hashtopolis/inc/Util.class.php(1301): PDO->query('ALTER TABLE
Has...')\n#1 /var/www/hashtopolis/inc/utils/ConfigUtils.class.php(88): 
Util::setMaxHashLength(264000)\n#2
/var/www/hashtopolis/inc/handlers/ConfigHandler.class.php(13): 
ConfigUtils::updateConfig(Array)\n#3
/var/www/hashtopolis/config.php(22): 
ConfigHandler->handle('updateConfig')\n#4 {main}\n  thrown in
/var/www/hashtopolis/inc/Util.class.php on line 1301

Unable to insert long hashes has been reported a while ago in #184 and #324 how-ever both tickets are closed, allowing me to make a fresh one, since IMHO the issue still persist.

One suggestion would be to use a different way of storing large hashes in the database e.g.:

diff --git a/src/install/hashtopolis.sql b/src/install/hashtopolis.sql
index 1b357b35..c3faff58 100644
--- a/src/install/hashtopolis.sql
+++ b/src/install/hashtopolis.sql
@@ -237,7 +237,7 @@ CREATE TABLE `FileDelete` (
 CREATE TABLE `Hash` (
   `hashId`      INT(11)      NOT NULL,
   `hashlistId`  INT(11)      NOT NULL,
-  `hash`        TEXT         NOT NULL,
+  `hash`        MEDIUMTEXT   NOT NULL,
   `salt`        VARCHAR(256) DEFAULT NULL,
   `plaintext`   VARCHAR(256) DEFAULT NULL,
   `timeCracked` BIGINT       DEFAULT NULL,

How-ever I am not sure whether this has unwanted side-effects.

[zyronix]

Note for self: Double check how indexing of mysql is dealing with this.