<html><head></head><body>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.<br>
<br>
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.<br>
<br>
Chris<br><br><div class="gmail_quote">On 4 May 2016 5:02:21 am NZST, yash verma <yash.verma@st.niituniversity.in> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<p dir="ltr">Is there any other way to get the userid and password confirmation via an external script?<br />
I am trying to get a login done through an Android application<br />
</p>
<div class="gmail_quote">On 03-May-2016 10:28 PM, "Michael Hafen" <<a href="mailto:michael.hafen@washk12.org">michael.hafen@washk12.org</a>> wrote:<br type="attribution" /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">The password column in MySQL borrowers table is a hash. It can not be decrypted.<br /></div><div class="gmail_extra"><br /><div class="gmail_quote">On Tue, May 3, 2016 at 10:48 AM, yash verma <span dir="ltr"><<a href="mailto:yash.verma@st.niituniversity.in" target="_blank">yash.verma@st.niituniversity.in</a>></span> wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">I need to retrieve the data from the borrowers table, but the password is encrypted. How do I decrypt it in MySQL?</p>
<br />_______________________________________________<br />
Koha-devel mailing list<br />
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br />
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br />
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br />
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br />
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a><br /></blockquote></div><br /><br clear="all" /><br />-- <br /><div><div dir="ltr"><div><div>Michael Hafen<br /></div>Washington County School District Technology Department<br /></div>Systems Analyst<br /><div><br /><img src="http://logos.washk12.org/100year.png" /><br /></div></div></div>
</div>
</blockquote></div>
<p style="margin-top: 2.5em; margin-bottom: 1em; border-bottom: 1px solid #000"></p><pre class="k9mail"><hr /><br />Koha-devel mailing list<br />Koha-devel@lists.koha-community.org<br /><a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br />website : <a href="http://www.koha-community.org">http://www.koha-community.org</a>/<br />git : <a href="http://git.koha-community.org">http://git.koha-community.org</a>/<br />bugs : <a href="http://bugs.koha-community.org/">http://bugs.koha-community.org/</a></pre></blockquote></div><br>
-- <br>
Sent from my Android device with K-9 Mail. Please excuse my brevity.</body></html>