Fix vRealize log insight admin password reset

To Reset the passwor you can use the SSH to box with root account and run the password below.

Establish an SSH connection to the vRealize Log Insight virtual appliance and log in as the root user.

Run the script that resets the Admin user password:

li-reset-admin-passwd.sh

If your account is getting locked then you will have to update the DATABASE to unlock the admin account.

The script resets the Admin user password, generates a new password, and displays it on the screen. 

Look up cassandra creds

/usr/lib/loginsight/application/lib/apache-cassandra-*/bin/credentials-look-up

log in to cassandra
/usr/lib/loginsight/application/lib/apache-cassandra-*/bin/cqlsh -u lisuper -p <password_from_first_step> --cqlshrc=/storage/core/loginsight/cidata/cassandra/config/cqlshrc

turn on vertical query results
expand on;

use vRLI DB
use logdb;

find admin user status and id
select id,status from user where user_name='admin' allow filtering;

if status is 2, change it back to 1
update user set status=1 where id=<id_from_previous_step>;

verify change
select id,status from user where user_name='admin' allow filtering;