[Koha-bugs] [Bug 29924] Introduce password expiration to patron categories

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29924

--- Comment #3 from Nick Clemens <nick at bywatersolutions.com> ---
Created attachment 129707
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=129707&action=edit
Bug 29924: Add password expiration feature

This patch adds the ability to define password_expiry_days for a patron
category.

When defined a patron's password will expire after X days and they will be
required to
reset their password. If OPAC resets are enabled for the catgeory they may do
so on their
own, otherwise they will need to contact the library

To test:
 1 - Apply patch, updatedatabase
 2 - Set 'Password expiration' for a patron category
    Home->Administration->Patron categories->Edit
 3 - Create a new patron in this category with a userid/password set, and an
email
 4 - Confirm their password_expiration field is set
    SELECT password_expiration FROM borrowers WHERE borrowernumber=51;
 5 - Create a new patron, do not set a password
 6 - Confirm their password_expiration field is NULL
 7 - Update the patron with an expiration to be expired
    UPDATE borrowers SET password_expiration='2022-01-01' WHERE
borrowernumber=51;
 8 - Give the borrower catalogue permission
 9 - Attempt to log in to Straff interface
10 - Confirm you are signed out and notified that password must be reset
11 - Attempt to sign in to OPAC
12 - Confirm you are signed out and notified password must be reset
13 - Enable password reset for the patron's category and perform a password
reset
     Note: you will have to find the link in the message_queue unless you have
emails
     setup on your test environment
     SELECT * FROM message_queue WHERE borrowernumber=51;
14 - Confirm that you cna now sign in and password_expiration field is set 10
days in the future
15 - Expire the patron's password again
16 - Chaneg the patron's password via the staff interface
17 - Confirm they can sign in and the expiration is updated

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.