NetWorker: NWUI-dashboard mislykkes med 'Kunne ikke hente seneste optællinger'

NWUI-dashboardet viser følgende fejl:

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

Meddelelsen C:\Program Files\EMC NetWorker\nsr\authc-server\tomcat\logs\nwui.log viser en forbindelsesafvist fejl fra overvågningstjenesten:

...
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
...

Meddelelsen C:\Program Files\EMC NetWorker\nwui\monitoring\app\logs\monitoring-app.log Viser, at overvågningstjenesten ikke kan hente databaseadgangskoden fra Keystore:

...
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!/:?]
...

Notering af NWUI-nøglelageret viser kun 2 poster i stedet for de forventede 3. Meddelelsen monitoringdbpasswordalias Posten 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 korrekt konfigureret nøglelager viser 3 poster, herunder: 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ågningstjenesten kræver, at monitoringdbpasswordalias alias i NWUI-nøglelageret (nwui.keystore). Dette alias gemmer databaseadgangskoden, der bruges til at godkende til NWUI-overvågningsdatabasen.

Meddelelsen monitoringdbpasswordalias Aliasset er blevet fjernet fra Keystore. Årsagen til fjernelsen er ukendt. Uden aliasset kan overvågningstjenesten ikke hente databaseadgangskoden. Tjenesten starter ikke, og dashboardet kan ikke vise data.

Genskab monitoringdbpasswordalias alias i NWUI-nøglelageret. Denne procedure kræver adgangskoden til NWUI-nøglelageret. Udskiftet <password> med NWUI keystore-adgangskoden i nedenstående trin.
 

1. Åbn et kommandopromptvindue med indstillingen "Kør som administrator".
2. oprettelse af en kopi af 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. Åbn . pg_hba.conf Fil med et tekstredigeringsprogram:

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

• Skift METODEN fra "md5" til "tillid" for alle de ukommenterede brugere nederst i filen
• Gem ændringerne. pg_hba.conf

4. Stop "NetWorker WebUI Database" og "NetWorker Web Management UI Server" services: net stop nwui
5. Start tjenesterne "NetWorker WebUI Database" og "NetWorker Web Management UI Server": net start nwui
6. Opret forbindelse til NWUI-databasen med psql:

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

• Skift adgangskoden "nwuiruser" til adgangskoden til NWUI keystore: ALTER USER nwuiuser WITH PASSWORD 'password';
• Afslut psql Forbindelse quit
• Stop servicerne "NetWorker WebUI Database" og "NetWorker Web Management UI Server": net stop nwui
• Opret en ny fil nwuidb.conf:

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

• Indtast Base64-koden for NWUI-adgangskoden til nøglelageradgangskoden <> i den nye nwuidb.conf Fil: https://www.base64encode.org/
• Gem ændringen i den nye nwuidb.conf Filer:

9. Vend tilbage 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 tjenesterne "NetWorker WebUI Database" og "NetWorker Web Management UI Server": net start nwui
11. Bekræft monitoringdbpasswordalias blev oprettet i NWUI keystore:

"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.  Bekræft, at symptomet ikke længere forekommer i NWUI.