[Koha-devel] Password stored in borrowers

[Chris Cormack]

The password is encrypted with bcrypt,  so you will want to follow Michael's suggestion and call one of the many API available to validate a user's credentials.

But there is no way you can ever get a cleartext version of the password from the database. If you can in any system (library or otherwise) never ever use that system.

Chris

On 4 May 2016 5:02:21 am NZST, yash verma <yash.verma at st.niituniversity.in> wrote:
>Is there any other way to get the userid and password confirmation via
>an
>external script?
>I am trying to get a login done through an Android application
>On 03-May-2016 10:28 PM, "Michael Hafen" <michael.hafen at washk12.org>
>wrote:
>
>> The password column in MySQL borrowers table is a hash.  It can not
>be
>> decrypted.
>>
>> On Tue, May 3, 2016 at 10:48 AM, yash verma <
>> yash.verma at st.niituniversity.in> wrote:
>>
>>> I need to retrieve the data from the borrowers table, but the
>password is
>>> encrypted. How do I decrypt it in MySQL?
>>>
>>> _______________________________________________
>>> 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/
>>>
>>
>>
>>
>> --
>> Michael Hafen
>> Washington County School District Technology Department
>> Systems Analyst
>>
>>
>>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>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/

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160504/f21202ed/attachment-0001.html>