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 <[email protected]>
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 <[email protected]>
---
.../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.
