[nifi] branch main updated: NIFI-9077 Added Registry H2 DB password change instructions

[ex...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

exceptionfactory pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/nifi.git


The following commit(s) were added to refs/heads/main by this push:
     new 1ae6dbd  NIFI-9077 Added Registry H2 DB password change instructions
1ae6dbd is described below

commit 1ae6dbdfb62fe51cc1743150b27080d3e5e5ccf9
Author: wiktor2200 <wi...@users.noreply.github.com>
AuthorDate: Mon Aug 23 17:25:37 2021 +0200

    NIFI-9077 Added Registry H2 DB password change instructions
    
    This closes #5328
    
    Signed-off-by: David Handermann <ex...@apache.org>
---
 .../src/main/asciidoc/administration-guide.adoc    | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

diff --git a/nifi-registry/nifi-registry-core/nifi-registry-docs/src/main/asciidoc/administration-guide.adoc b/nifi-registry/nifi-registry-core/nifi-registry-docs/src/main/asciidoc/administration-guide.adoc
index 5e960d9..7609c40 100644
--- a/nifi-registry/nifi-registry-core/nifi-registry-docs/src/main/asciidoc/administration-guide.adoc
+++ b/nifi-registry/nifi-registry-core/nifi-registry-docs/src/main/asciidoc/administration-guide.adoc
@@ -1147,6 +1147,28 @@ For NiFi Registry 0.2.0 and forward, the location of the H2 database is specifie
 
 `nifi.registry.db.url=jdbc:h2:./database/nifi-registry-primary;`
 
+==== Changing password in existing H2 database
+
+1. Download H2 driver from official repository https://www.h2database.com/html/download.html and place it somewhere accessible to NiFi Registry user
+
+2. Run H2 database shell
+
+  java -cp h2*.jar org.h2.tools.Shell
+
+3. Connect to database
+
+  Welcome to H2 Shell 1.4.200 (2019-10-14)
+  Exit with Ctrl+C
+  URL       jdbc:h2:./database/nifi-registry-primary
+  Driver    org.h2.Driver
+  User      nifireg
+  Password  
+  Connected
+
+4. Change password
+
+  ALTER USER nifireg SET PASSWORD 'NEW_PASSWORD';
+
 === Postgres
 
 Postgres provides the option to use an externally located database that also supports high availability.