You can use the /usr/share/koha/bin/admin/set_password.pl script to make your own batch script.
It needs you to know the patron id (borrowernumber) and can set whatever you pass it with the --password parameter: $ koha-shell instance k$ /usr/share/koha/bin/admin/set_password.pl --patron_id 234 --password Apassw0rD! if you don't pass the --password switch it will generate a random one. Regards El lun., 17 jun. 2019 a las 11:22, Joy Nelson (<j...@bywatersolutions.com>) escribió: > 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 <jcoeho...@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 > > *jcoeho...@york.edu <jcoeho...@york.edu>* > > > > *Please contact helpd...@york.edu <helpd...@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 < > dix...@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/> > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha