[Koha] Importing encrypted patron passwords

Tomas Cohen Arazi tomascohen at gmail.com
Sun Feb 6 02:42:12 NZDT 2022


You should do all you mention, but instead of creating things, you should
just paste the old db and trigger the upgrade process.

El sáb., 5 feb. 2022 10:31, Mark Alexander <marka at pobox.com> escribió:

>
> I'm in the process of upgrading a library's Debian 7/Koha 3.16 setup.
> This installation is so old that an in-place upgrade can't be done.
> My plan is to first create a test VM with Debian 10 and the latest
> stable koha-common.  Then after manually setting up various admin
> things (library, item types, ccode, loc, patron types), I'll import
> the catalog and the patron list.  Finally, I'll move the resulting
> database to the real (live) server.
>
> The snag here is the patron passwords.  I'll use a report from the SQL
> library to export the patron list from the old installation, but the
> passwords will be encrypted.  My understanding is that when importing
> the patron list, the passwords must be unencrypted.  So I'll need to
> remove the password column from the CSV file, and as a result,
> every patron password will have to be reset manually.
>
> Is there any workaround for this?  I would just like to move the
> encrypted passwords from the old installation to the new one.  I am
> comfortable doing some hand-crafted SQL updates to accomplish this.
> But before I make the attempt, is there any reason why this wouldn't
> work or why it's a bad idea?
>
> --
> Single-handedly, I have fought my way
> into this hopeless mess. --Ashleigh Brilliant
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


More information about the Koha mailing list