[Koha] Bulk patron password updates

[Dixson Rodriges]

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 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 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 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
> > 
> >