[Koha] Bulk patron password updates

[Joy Nelson]

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 at 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 at york.edu <jcoehoorn at york.edu>*
>
> *Please contact helpdesk at york.edu <helpdesk at 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 at 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 at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at 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/>