From b3ad20c6c66036bae57c635d82947b2bb1001e74 Mon Sep 17 00:00:00 2001 From: Jake Deery Date: Tue, 3 Dec 2024 09:25:43 +0000 Subject: [PATCH] Bug 35761: (follow-up) Increase length of password I was finding that the password was getting truncated way too soon. I've lengthened this field to accomodate longer (encrypted) passwords. --- .../mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl | 2 +- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl b/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl index 5d78d98c278..38ba00e7213 100755 --- a/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl +++ b/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl @@ -26,7 +26,7 @@ return { `transport` enum('ftp','sftp') NOT NULL DEFAULT 'sftp', `passiv` tinyint(1) NOT NULL DEFAULT 1, `user_name` varchar(80) DEFAULT NULL, - `password` varchar(80) DEFAULT NULL, + `password` varchar(256) DEFAULT NULL, `key_file` varchar(4096) DEFAULT NULL, `auth_mode` enum('password','key_file','noauth') NOT NULL DEFAULT 'password', `debug` tinyint(1) NOT NULL DEFAULT 0, diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 82ed7e2f642..795806b9e9b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -5937,7 +5937,7 @@ CREATE TABLE `sftp_servers` ( `transport` enum('ftp','sftp') NOT NULL DEFAULT 'sftp', `passiv` tinyint(1) NOT NULL DEFAULT 1, `user_name` varchar(80) DEFAULT NULL, - `password` varchar(80) DEFAULT NULL, + `password` varchar(256) DEFAULT NULL, `key_file` varchar(4096) DEFAULT NULL, `auth_mode` enum('password','key_file','noauth') NOT NULL DEFAULT 'password', `debug` tinyint(1) NOT NULL DEFAULT 0, -- 2.43.0