I need to retrieve the data from the borrowers table, but the password is encrypted. How do I decrypt it in MySQL?
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@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@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
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@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@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@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
You could try looking at svc/authentication Looks like you can transmit POST messages to it with a username and password, and get an XML response with 'ok' or something else, and a session cookie. Someday the REST api will be able to handle that too I suppose. On Tue, May 3, 2016 at 11:02 AM, yash verma <yash.verma@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@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@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@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
-- Michael Hafen Washington County School District Technology Department Systems Analyst
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@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@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@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@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@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.
participants (3)
-
Chris Cormack -
Michael Hafen -
yash verma