From 4d40cf71a7aed9551a770dccc33ec26e6f91210c Mon Sep 17 00:00:00 2001 From: Benjamin Date: Mon, 31 Mar 2014 16:37:06 -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 | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-) diff --git a/docs/circulation/circulation_patron_records.txt b/docs/circulation/circulation_patron_records.txt index cfbd3cf965..375c858987 100644 --- a/docs/circulation/circulation_patron_records.txt +++ b/docs/circulation/circulation_patron_records.txt @@ -291,22 +291,30 @@ 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] +[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: +Connect to your Evergreen database using _psql_ or similar tool, and retreive and verify your admin username: +[source, sql] +------------------------------------------------------------------------------ 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. +If you do not remember the username that you set, search for it in the _actor.usr_ table, and then reset the password. +[source, sql] +------------------------------------------------------------------------------ UPDATE actor.usr SET passwd = WHERE id=; +------------------------------------------------------------------------------ The new password will automatically be hashed. +======================= Barring a Patron ~~~~~~~~~~~~~~~~ -- 2.43.2