[Koha-devel] DB-QUESTION: Encrypt/decrypt password field in the table BORROWERS

[Anders Gunnare]

Is there any option to store the password non-encrypted in the db, for testing purpose of course ?!

Regards

Anders Gunnare

IT-service
Luleå tekniska universitet, 971 87 Luleå
0920 - 49 14 50
(070 306 40 37)
anders.gunnare at ltu.se
www.ltu.se

From: Chris Cormack [mailto:chris at bigballofwax.co.nz]
Sent: den 29 juni 2015 11:15
To: Anders Gunnare
Cc: koha-devel at lists.koha-community.org
Subject: Re: [Koha-devel] DB-QUESTION: Encrypt/decrypt password field in the table BORROWERS



On 29 June 2015 at 20:40, Anders Gunnare <anders.gunnare at ltu.se<mailto:anders.gunnare at ltu.se>> wrote:
Hello Word ☺

Which encryption method is used to encrypt/decrypt the password field in the database for the table borrowers ?

I need to create users “by hand” with core insert ☺
In my case I have a password (not encrypted) which I would like to store in the table and column for the password.

But how shall I do that ?!


There is no way to decrypt (well no computationally feasible way) we use bcrypt from this module
http://search.cpan.org/~zefram/Crypt-Eksblowfish-0.009/lib/Crypt/Eksblowfish/Bcrypt.pm
If you look at Koha::AuthUtils you can see the Koha function to encrypt

http://perldoc.koha-community.org/Koha/AuthUtils.html
Chris

Regards

Anders Gunnare

IT-service
Luleå tekniska universitet, 971 87 Luleå
0920 - 49 14 50
(070 306 40 37)
anders.gunnare at ltu.se<mailto:anders.gunnare at ltu.se>
www.ltu.se<http://www.ltu.se>


_______________________________________________
Koha-devel mailing list
Koha-devel at lists.koha-community.org<mailto:Koha-devel at lists.koha-community.org>
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20150629/890321cf/attachment.html>