7 thoughts on “vRealize Log Insight – How to reset and unlock the local admin password

  1. Just running this for the status output the commands that were required for myself were below:
    expand on;
    use logdb;
    select id,status from user where user_name=’admin’ allow filtering;

    #this will give you the id. if status=2 then run the below
    update user set status=1 where id=;
    select id,status from user where user_name=’admin’ allow filtering;

    I found using the commands SELECT * FROM user; returned the message:

    InvalidRequest: Error from server: code=2200 [Invalid query] message=”No keyspace has been specified. USE a keyspace, or explicitly specify keyspace.tablename”

    Hope this helps

  2. This worked like a charm for me, EXCEPT the procedure left out that you need to do a
    USE logdb;
    before you attempt to SELECT * FROM user;

  3. Hi, I followed above steps but Im getting error message saying that the username or password are incorrect.

    root@logt01 [ ~ ]# /usr/lib/loginsight/application/lib/apache-cassandra-*/bin/credentials-look-up

    root@logt01 [ ~ ]#
    root@logt01 [ ~ ]# /usr/lib/loginsight/application/lib/apache-cassandra-3.11.11/bin/cqlsh -u lisuper -p tdzgsad8$H –cqlshrc=/storage/core/loginsight/cidata/cassandra/config/cqlshrc
    Connection error: (‘Unable to connect to any servers’, {‘127.0.0.1’: AuthenticationFailed(‘Failed to authenticate to 127.0.0.1: Error from server: code=0100 [Bad credentials] message=”Provided username lisuper and/or password are incorrect”‘)})

    What could be the problem…?

    1. Hi, I am unsure on this one, I would recommend calling VMware Support for an accurate answer, as this might be highlighting more issues in your vRLI setup.

    2. try running the command with -p option it will prompt for the password. It should work, similar issue seen just today only.

      /usr/lib/loginsight/application/lib/apache-cassandra-3.11.11/bin/cqlsh -u lisuper –cqlshrc=/storage/core/loginsight/cidata/cassandra/config/cqlshrc

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.