Unable to login or reset the 'admin' password in Aria Operations for Logs.

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• After running through How to reset and unlock the local admin account in Aria Operations for Logs (Formerly vRealize Log Insight), to check the admin status using the command:

 root@hostname [ ~ ]# /usr/lib/loginsight/application/sbin/li-reset-admin-passwd.sh --checkAdminStatus
FAILED: Unable to get user data. Possible cassandra is down

• You receive this error when trying to access the Cassandra database on the Aria Operations for Logs node using this command 

root@hostname [ ~ ]# /usr/lib/loginsight/application/sbin/../lib/apache-cassandra-4.1.3/bin/cqlsh-no-pass

Connection error: ('Unable to connect to any servers', {'loopback:9042': PermissionError(1, "Tried connecting to [('loopback', 9042)]. Last error: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self-signed certificate (_ssl.c:1007)")})

Environment

Aria Operations for Logs 8.18.x

Resolution

The issue can be fixed by following steps from this KB Error when trying to check the status of admin account password in Aria Operations for Logs: FAILED: Unable to get user data. Possible Cassandra is down.