Chapter 9. Resetting Patron’s Password

A patron’s password may be reset from the OPAC or through the staff client. To reset the password from the staff client, retrieve the patron record as described in the section Searching Patrons.

Open the patron record in edit mode as described in the section Updating Patron Information.

Select the Reset Password button next to the Password field.

circulation_patron_records 15

Note

The existing password is not displayed in patron records for security reasons.

A new number will populate the Password and Verify Password text boxes. Make note of the new password and Save the patron record. The screen will refresh and the new password will be suppressed from view.

Tip

If you need to change a patron or staff account password without using the staff client, here is how you can reset it with SQL.

Connect to your Evergreen database using psql or similar tool, and retreive and verify your admin username:

psql -U <user-name> -h <hostname> -d <database>

SELECT id, usrname, passwd from actor.usr where usrname = 'admin';

If you do not remember the username that you set, search for it in the actor.usr table, and then reset the password.

UPDATE actor.usr SET passwd = <password> WHERE id=<id of row to be updated>;

The new password will automatically be hashed.