[Bug 35898] New: Database update for encrypting vendor_edi_account passwords can be run twice
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35898 Bug ID: 35898 Summary: Database update for encrypting vendor_edi_account passwords can be run twice Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: wizzyrea@gmail.com QA Contact: testopia@bugs.koha-community.org Bug 30649 introduced encrypted edi vendor account passwords, and was backported into 22.11.07. If a library upgraded through 22.11.07 (i.e. got the database update), and eventually upgraded through to 23.05.07, it is very possible this database update will be run twice, re-encrypting the already encrypted passwords. These were the affected db revisions: installer/data/mysql/db_revs/221106001.pl => installer/data/mysql/db_revs/221200041.pl  This bug is meant to document this phenomenon.      -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35898 Liz Rea <wizzyrea@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wizzyrea@gmail.com --- Comment #1 from Liz Rea <wizzyrea@gmail.com> --- There are two solutions: Procure the original passwords from the EDI vendor Restore the passwords from a recent backup - don't try to replace them, update the passwords with update statements. You'll want the encrypted string from the password field in the vendors_edi_accounts table. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org