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 <[email protected]> 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 > *[email protected] <[email protected]>* > > *Please contact [email protected] <[email protected]> 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 <[email protected]> > 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 > > [email protected] > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > 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/> _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
