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@focuzinfotech.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 https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Joy Nelson President, Koha Division ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>