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

[Chris Cormack]

On 29 June 2015 at 20:40, Anders Gunnare <anders.gunnare at 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/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
>
> www.ltu.se
>
>
>
> _______________________________________________
> Koha-devel mailing list
> 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/4a1f39c7/attachment-0001.html>