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?
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
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/>
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@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@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@lists.katipo.co.nz
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
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 (<joy@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 <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/> _______________________________________________ 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
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:12, Dixson Rodriges (< dixson@focuzinfotech.com>) escribió:
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
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
participants (4)
-
Coehoorn, Joel -
Dixson Rodriges -
Joy Nelson -
Tomas Cohen Arazi