[Koha] MD5 hash password encryption

Galen Charlton gmc at esilibrary.com
Tue Feb 18 06:31:54 NZDT 2014


On Mon, Feb 17, 2014 at 9:19 AM, geromoselle <geromoselle at yahoo.com> wrote:
> I am doing bulk uploading for our library patrons for the first time. I set a
> default password for all my patrons to be 1234 which they can change on
> their own at the OPAC page. Please, I will like to know exact MD5 hash
> conversation for this number or precisely how I can decode md5 hash
> encryption.

What version of Koha are you using?  Note that starting with 3.14,
Crypt::Eksblowfish::Bcrypt rather than Digest::MD5 is used to hash the

If you load the patron records using the built-in patron import tool,
you can supply the password in plaintext in the CSV file or as a
default value and it will hash it appropriately.

If you are using a version of Koha prior to 3.14 and are inserting the
patron records directly into the database, the following one-liner
will calculate the hash for you:

perl -MDigest::MD5 -e 'print Digest::MD5::md5_base64("THEPASSWORD"), "\n"'

For Koha 3.14 or later, this will do it:

perl -MKoha::AuthUtils -e 'print
Koha::AuthUtils::hash_password("THEPASSWORD"), "\n"'

Note that this way of calling hash_password() will generate a new
random salt each time it is used.


Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &

More information about the Koha mailing list