Hi All, I got the solution right now. Thank you for your concerns . Regards,DixsonOn Mon, 2019-06-17 at 09:21 -0500, Joy Nelson wrote:
I agree with Joel. From a security perspective, updating all patron passwords to one password is not a great idea. Secondly, the password field in the database is not plain text, but is hashed. You need to insert the hashed values in order to make this work.
A better solution would be to reimport you patrons and set the password in the import file. You could set the password to something such as lastname or last few digits of their cardnumber. When imported their password would be set.
-joy
On Mon, Jun 17, 2019 at 9:14 AM Coehoorn, Joel <jcoehoorn@york.edu> wrote:
As someone who does IT and security for a living, the sql isn't hard to
write, but this idea seems incredibly, insanely, horribly awful. What are
you really trying to accomplish? Maybe I can suggest a safer way to do this.
Joel Coehoorn
Director of Information Technology
402.363.5603
*jcoehoorn@york.edu <jcoehoorn@york.edu>*
*Please contact helpdesk@york.edu <helpdesk@york.edu> for technical
assistance.*
The mission of York College is to transform lives through
Christ-centered education and to equip students for lifelong service to
God, family, and society
On Mon, Jun 17, 2019 at 9:11 AM Dixson Rodriges <dixson@focuzinfote ch.com>
wrote:
Hi,
Is are any mysql query for updating the common password for all
patrons.
I tried with following mysql query. but didn't worked out. I think it
should be in encrypted format.
update borrowers set password='test123' where cardnumber='1001';
Regards,
Dixson
--
Best Regards,
Dixson Rodrigues
Manager - Support & Service
FocuzInfotech
(A Division of focuz Innovation Pvt Ltd)
Ph: +91 484 2535390 Mob:09249500540
Save Paper - Do you really need to print this e-mail?
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz