| PAGE CONTENTS |
| Problem Statement |
| Products Supported |
| Step-by-Step Guide |
Problem Statement : Too many failed login attempts of admin account to on-prem vRealize Log Insight Instance leads to account getting disabled & locked status.
Products Supported : vRealize Log Insight 8.3.0 or above
Step-by-Step Guide to Unlock & Enable the “Admin” account of vRealize Log Insight on-prem instance
- Login to vRLI console via SSH using root account
- Execute this command to reset the admin password
li-reset-admin-passwd.sh
- Now we have successfully reset the ‘admin’ account password.
- Try logging into your vRLI environment using above admin account and password “CbR7RC*c” : If you are able to login, then you may not need to follow further steps from here.
- f you still receive the same error as above “Login Error” then perform below steps to unlock/enable the admin account.
- We need to login into the Cassandra Database and update the DB ‘logdb’ manually.
- Execute the following command to find the credentials to login to “logdb”
/usr/lib/loginsight/application/lib/apache-cassandra-3.11.11/bin/credentials-look-up
8. If you still receive the same error as above “Login Error” then perform below steps to unlock/enable the admin account.
9. Execute following command
usr/lib/loginsight/application/lib/apache-cassandra-3.11.11/bin/cqlsh -u lisuper -p kkoqtwp2=S --cqlshrc=/storage/core/loginsight/cidata/cassandra/config/cqlshrc
[Note : You will need to replace the username and password in above command found in step number 7. ]
10. You can note that you’re successfully connected to the cassandra.
11. Now turn on query results to be displayed vertically. : expand on;
lisuper@cqlsh> expand on; Now Expanded output is Enabled
12 .We need to use vRLI database to update the enable/unlock value, execute following command : use logdb;
13. We need find the admin user account status and ID. If Status is ‘1’ then the account is not locked or disabled. If the Status is ‘2’ then we will have to update the database.
14. Execute the following command
select id,status from user where user_name='admin' allow filtering;
15. You can note that the status is ‘2’. We need to update this value to ‘1’. Execute following command :
update user set status=1 where id=869329ea-8659-49df-bd5a-2dcb6731a851;
[Note : You will need to copy the ‘id’ value from step no 13 query results as show above and place it in your query]
16 . Now execute the same query in step no 13, to find the status.
17. You can see the pre and post query results. The status value has been updated to “1″ .
18. Now may login to vRealize LogInsight on-premise web console using admin account.