DB-QUESTION: Encrypt/decrypt password field in the table BORROWERS
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 ?! Regards Anders Gunnare IT-service Luleå tekniska universitet, 971 87 Luleå 0920 - 49 14 50 (070 306 40 37) anders.gunnare@ltu.se www.ltu.se
On 29 June 2015 at 20:40, Anders Gunnare <anders.gunnare@ltu.se> wrote:
Hello Word J
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 J 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... 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@ltu.se
www.ltu.se
_______________________________________________ Koha-devel mailing list Koha-devel@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/
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@ltu.se www.ltu.se From: Chris Cormack [mailto:chris@bigballofwax.co.nz] Sent: den 29 juni 2015 11:15 To: Anders Gunnare Cc: koha-devel@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@ltu.se<mailto:anders.gunnare@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... 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@ltu.se<mailto:anders.gunnare@ltu.se> www.ltu.se<http://www.ltu.se> _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org<mailto:Koha-devel@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/
On 29 June 2015 at 22:07, Anders Gunnare <anders.gunnare@ltu.se> wrote:
Is there any option to store the password non-encrypted in the db, for testing purpose of course ?!
No, whenever a password is compared to one in the databse it is encrypted first. The easiest thing to do is to just write a quick script to encrypt your passwords. Chris
participants (2)
-
Anders Gunnare -
Chris Cormack