Bugzilla – Attachment 144325 Details for
Bug 30649
Vendor EDI account passwords should be encrypted in the database
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 30649: (QA follow-up) Switch password field to mediumtext
Bug30649-QA-follow-up-Switch-password-field-to-med.patch (text/plain), 1.79 KB, created by
Kyle M Hall (khall)
on 2022-11-29 14:31:07 UTC
(
hide
)
Description:
Bug 30649: (QA follow-up) Switch password field to mediumtext
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2022-11-29 14:31:07 UTC
Size:
1.79 KB
patch
obsolete
>From 4f303c4e1f06be5df9a32e137dd227c1759c0d11 Mon Sep 17 00:00:00 2001 >From: Kyle Hall <kyle@bywatersolutions.com> >Date: Tue, 29 Nov 2022 09:29:45 -0500 >Subject: [PATCH] =?UTF-8?q?Bug=C2=A030649:=20(QA=20follow-up)=20Switch=20p?= > =?UTF-8?q?assword=20field=20to=20mediumtext?= >MIME-Version: 1.0 >Content-Type: text/plain; charset=UTF-8 >Content-Transfer-Encoding: 8bit > >--- > installer/data/mysql/atomicupdate/bug_30649.pl | 2 +- > installer/data/mysql/kohastructure.sql | 2 +- > 2 files changed, 2 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_30649.pl b/installer/data/mysql/atomicupdate/bug_30649.pl >index 68c4e2df4e..ad933e316e 100755 >--- a/installer/data/mysql/atomicupdate/bug_30649.pl >+++ b/installer/data/mysql/atomicupdate/bug_30649.pl >@@ -7,7 +7,7 @@ return { > my ($args) = @_; > my ( $dbh, $out ) = @$args{qw(dbh out)}; > $dbh->do(q{ >- ALTER TABLE vendor_edi_accounts CHANGE COLUMN `password` `password` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL >+ ALTER TABLE vendor_edi_accounts CHANGE COLUMN `password` `password` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL > }); > > require Koha::Encryption; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 0c5e561233..9ae0f55ebc 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -5850,7 +5850,7 @@ CREATE TABLE `vendor_edi_accounts` ( > `description` mediumtext NOT NULL, > `host` varchar(40) DEFAULT NULL, > `username` varchar(40) DEFAULT NULL, >- `password` varchar(256) DEFAULT NULL, >+ `password` mediumtext DEFAULT NULL, > `last_activity` date DEFAULT NULL, > `vendor_id` int(11) DEFAULT NULL, > `download_directory` mediumtext DEFAULT NULL, >-- >2.30.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 30649
:
134298
|
134300
|
134301
|
134302
|
142056
|
142057
|
142820
|
142989
|
144323
|
144324
| 144325 |
152097