From 2760e95d2658fb4594f35b78e6b559f987e51a63 Mon Sep 17 00:00:00 2001 From: Benjamin Date: Mon, 31 Mar 2014 16:29:11 -0400 Subject: [PATCH] LP#1300267 Documentation: Reset Staff Client Password (e.g. Admin) Signed-off-by: Benjamin Signed-off-by: Yamil Suarez --- docs/circulation/circulation_patron_records.txt | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) diff --git a/docs/circulation/circulation_patron_records.txt b/docs/circulation/circulation_patron_records.txt index f532528765..cfbd3cf965 100644 --- a/docs/circulation/circulation_patron_records.txt +++ b/docs/circulation/circulation_patron_records.txt @@ -291,6 +291,23 @@ 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 a similar tool, and retreive and verify your admin username: + +psql -U -h -d + +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 = WHERE id=; + +The new password will automatically be hashed. + + Barring a Patron ~~~~~~~~~~~~~~~~ -- 2.43.2