NetWorker: NWUI-dashbordet mislykkes med «kunne ikke hente de siste tellingene»

NWUI-instrumentbordet viser følgende feil:

Failed to fetch latest counts for Dashboard
Error is fetching count of activities based on status from Monitoring Service

Meldingen C:\Program Files\EMC NetWorker\nsr\authc-server\tomcat\logs\nwui.log viser en tilkoblingsfeil nektet fra overvåkingstjenesten:

...
HH:MM:SS [https-jsse-nio-9090-exec-6] INFO  c.e.n.c.n.impl.GlobalApi - Authenticating user Administrator on authentication server Emcbkp01p.berlitz.com.co.
HH:MM:SS [https-jsse-nio-9090-exec-6] INFO  c.e.n.c.n.impl.GlobalApi - Testing server details for nw calls.
HH:MM:SS [https-jsse-nio-9090-exec-8] ERROR c.e.n.c.n.i.MonitoringApi - Error in fetching count of activities based on status from Monitoring Service. java.net.ConnectException: Connection refused: connect
...

Meldingen C:\Program Files\EMC NetWorker\nwui\monitoring\app\logs\monitoring-app.log Viser overvåkingstjenesten kan ikke hente databasepassordet fra nøkkellageret:

...
YYYY-MM-DD HH:MM:SS [TomcatWebServer] [main] INFO  org.springframework.boot.web.embedded.tomcat.TomcatWebServer - Tomcat initialized with port(s): 9095 (https)
YYYY-MM-DD HH:MM:SS [DirectJDKLog] [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["https-jsse-nio-9095"]
YYYY-MM-DD HH:MM:SS [DirectJDKLog] [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
YYYY-MM-DD HH:MM:SS [DirectJDKLog] [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
YYYY-MM-DD HH:MM:SS [DirectJDKLog] [main] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/monitoring] - Initializing Spring embedded WebApplicationContext
YYYY-MM-DD HH:MM:SS [ServletWebServerApplicationContext] [main] INFO  org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3092 ms
YYYY-MM-DD HH:MM:SS [DataSourceConfig] [main] INFO  monitoring - DB password file not present.
YYYY-MM-DD HH:MM:SS [DataSourceConfig] [main] ERROR monitoring - Unable to retrieve the database password from Keystore
java.lang.NullPointerException: null
	at com.dell.emc.nw.monitoring.utils.DataSourceConfig.getDBPasswordFromKeystore(DataSourceConfig.java:75) ~[classes!/:?]
	at com.dell.emc.nw.monitoring.utils.DataSourceConfig.getDataSource(DataSourceConfig.java:64) ~[classes!/:?]
	at com.dell.emc.nw.monitoring.utils.DataSourceConfig$$EnhancerBySpringCGLIB$$c434748a.CGLIB$getDataSource$0(<generated>) ~[classes!/:?]
...

Oppføring av NWUI-nøkkellageret viser bare 2 oppføringer i stedet for forventet 3. Meldingen monitoringdbpasswordalias Oppføring mangler:

C:\>"C:\Program Files\NRE\java\jre1.8.0_321\bin\keytool.exe" -list -keystore  "C:\Program Files\EMC NetWorker\nwui\monitoring\app\conf\nwui.keystore"
Enter keystore password:
Keystore type: PKCS12
Keystore provider: SunJSSE
Your keystore contains 2 entries
emcauthctomcat, MONTH DD, YYYY, PrivateKeyEntry,
Certificate fingerprint (SHA-256): B2:D3:E1:8D:65:12:8D:51:3F:EA:CA:41:9C:A9:93:C2:21:8D:A7:A7:25:F8:CE:69:F9:21:90:55:37:43:6E:4E
emcauthcsaml, MONTH DD, YYYY, PrivateKeyEntry,
Certificate fingerprint (SHA-256): 5B:9D:23:57:5F:A7:A0:0F:83:D5:AE:61:C2:06:AF:60:0C:60:19:F8:7B:4F:6E:D2:BC:18:DD:96:6E:A1:A5:FB

Et riktig konfigurert nøkkellager viser 3 oppføringer, inkludert: monitoringdbpasswordalias:

C:\>"C:\Program Files\NRE\java\jre1.8.0_321\bin\keytool.exe" -list -keystore  "C:\Program Files\EMC NetWorker\nwui\monitoring\app\conf\nwui.keystore"
Enter keystore password:
Keystore type: PKCS12
Keystore provider: SunJSSE
Your keystore contains 3 entries
emcauthctomcat, MONTH DD, YYYY, PrivateKeyEntry,
Certificate fingerprint (SHA-256): B2:D3:E1:8D:65:12:8D:51:3F:EA:CA:41:9C:A9:93:C2:21:8D:A7:A7:25:F8:CE:69:F9:21:90:55:37:43:6E:4E
emcauthcsaml, MONTH DD, YYYY, PrivateKeyEntry,
Certificate fingerprint (SHA-256): 5B:9D:23:57:5F:A7:A0:0F:83:D5:AE:61:C2:06:AF:60:0C:60:19:F8:7B:4F:6E:D2:BC:18:DD:96:6E:A1:A5:FB
monitoringdbpasswordalias, MONTH DD, YYYY SecretKeyEntry,

Overvåkingstjenesten krever monitoringdbpasswordalias aliaset i NWUI-nøkkellageret (nwui.keystore). Dette aliaset lagrer databasepassordet som brukes til å godkjenne til NWUI-overvåkingsdatabasen.

Meldingen monitoringdbpasswordalias Aliaset er fjernet fra nøkkellageret. Årsaken til fjerningen er ukjent. Uten aliaset kan ikke overvåkingstjenesten hente databasepassordet. Tjenesten starter ikke, og instrumentbordet kan ikke vise data.

Gjenskap monitoringdbpasswordalias aliaset i NWUI-nøkkellageret. NWUI-nøkkellagerpassordet kreves for denne prosedyren. Erstattet <password> med NWUI-nøkkellagerpassordet i trinnene nedenfor.
 

1. Åpne et ledetekstvindu med alternativet "Kjør som administrator".
2. for å opprette en kopi av databasen. pg_hba.conf:

copy "C:\Program Files\EMC NetWorker\nwui\monitoring\nwuidb\pgdata\pg_hba.conf" "C:\Program Files\EMC NetWorker\nwui\monitoring\nwuidb\pgdata\pg_hba.conf_original"

3. Åpne . pg_hba.conf Fil med et tekstredigeringsprogram:

notepad "C:\Program Files\EMC NetWorker\nwui\monitoring\nwuidb\pgdata\pg_hba.conf"

• Endre METHOD fra "md5" til "trust" for alle ikke-kommenterte brukere nederst i filen
• Lagre endringene. pg_hba.conf

4. Stopp «NetWorker WebUI Database» og «NetWorker Web Management UI Server» services: net stop nwui
5. Start tjenestene for NetWorker WebUI Database og NetWorker Web Management UI Server: net start nwui
6. Koble til NWUI-databasen med psql:

"C:\Program Files\EMC NetWorker\nwui\monitoring\postgres\12\bin\psql" -U nwuiuser -d nwui -p 5435

• Endre "nwuiruser" passord til NWUI keystore passord: ALTER USER nwuiuser WITH PASSWORD 'password';
• Avslutt psql Tilkobling quit
• Stopp tjenestene for NetWorker WebUI Database og NetWorker Web Management UI Server : net stop nwui
• Opprett en ny fil nwuidb.conf:

notepad "C:\Program Files\EMC NetWorker\nwui\monitoring\nwuidb\pgdata\nwuidb.conf"

• Skriv inn Base64-koden til NWUI-passordet for nøkkellagerpassordet <> i det nye nwuidb.conf Fil: https://www.base64encode.org/
• Lagre endringen til den nye nwuidb.conf Filer:

9. Tilbakestill pg_hba.conf:

 copy "C:\Program Files\EMC NetWorker\nwui\monitoring\nwuidb\pgdata\pg_hba.conf_original" "C:\Program Files\EMC NetWorker\nwui\monitoring\nwuidb\pgdata\pg_hba.conf"

10. Start tjenestene for NetWorker WebUI Database og NetWorker Web Management UI Server: net start nwui
11. Bekreft monitoringdbpasswordalias ble opprettet i NWUI-nøkkellageret:

"C:\Program Files\NRE\java\jre1.8.0_321\bin\keytool.exe" -list -keystore  "C:\Program Files\EMC NetWorker\nwui\monitoring\app\conf\nwui.keystore"

12.  Valider at symptomet ikke lenger oppstår i NWUI.