From 4bd79c40e6898444c9e4d13eda341225da0a34c8 Mon Sep 17 00:00:00 2001 From: Jane Sandberg Date: Sun, 17 Sep 2017 13:45:36 -0700 Subject: [PATCH 1/1] Docs reorg: moving SQL from circ manual to command line sysadmin manual Signed-off-by: Jane Sandberg --- docs/admin/staff_from_command_line.adoc | 26 +++++++++++++++++++ .../circulation_patron_records.adoc | 24 ----------------- ...circulation_patron_records_web_client.adoc | 25 ------------------ docs/root_command_line_admin.adoc | 2 ++ 4 files changed, 28 insertions(+), 49 deletions(-) create mode 100644 docs/admin/staff_from_command_line.adoc diff --git a/docs/admin/staff_from_command_line.adoc b/docs/admin/staff_from_command_line.adoc new file mode 100644 index 0000000000..b38f9065d4 --- /dev/null +++ b/docs/admin/staff_from_command_line.adoc @@ -0,0 +1,26 @@ +Managing Staff from the Command Line +==================================== + +Changing passwords +------------------ + +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: + +[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. + +[source, sql] +------------------------------------------------------------------------------ +UPDATE actor.usr SET passwd = WHERE id=; +------------------------------------------------------------------------------ + +The new password will automatically be hashed. + diff --git a/docs/circulation/circulation_patron_records.adoc b/docs/circulation/circulation_patron_records.adoc index 98d45dd167..ad013f6472 100644 --- a/docs/circulation/circulation_patron_records.adoc +++ b/docs/circulation/circulation_patron_records.adoc @@ -318,30 +318,6 @@ 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: - -[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. - -[source, sql] ------------------------------------------------------------------------------- -UPDATE actor.usr SET passwd = WHERE id=; ------------------------------------------------------------------------------- - -The new password will automatically be hashed. - -======================= - Barring a Patron ~~~~~~~~~~~~~~~~ diff --git a/docs/circulation/circulation_patron_records_web_client.adoc b/docs/circulation/circulation_patron_records_web_client.adoc index 0b8a6ade4b..e75c2267be 100644 --- a/docs/circulation/circulation_patron_records_web_client.adoc +++ b/docs/circulation/circulation_patron_records_web_client.adoc @@ -242,31 +242,6 @@ 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: - -[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. - -[source, sql] ------------------------------------------------------------------------------- -UPDATE actor.usr SET passwd = WHERE id=; ------------------------------------------------------------------------------- - -The new password will automatically be hashed. - -======================= - - Barring a Patron ~~~~~~~~~~~~~~~~ diff --git a/docs/root_command_line_admin.adoc b/docs/root_command_line_admin.adoc index 6fea46b490..28e6c48ebb 100644 --- a/docs/root_command_line_admin.adoc +++ b/docs/root_command_line_admin.adoc @@ -95,6 +95,8 @@ Cataloging Staff Interface include::admin/physical_char_wizard_db.adoc[] +include::admin/staff_from_command_line.adoc[] + UX Administration ================= -- 2.43.2