Unable to connect to internal Cassandra database with cqlsh-no-pass

Products

• VMware Aria Suite

Issue/Introduction

After upgrading to Aria Operations for Logs 8.18.3, you are unable to connect to the Cassandra database using the cqlsh-no-pass command, although there are no issues with the Cassandra cluster itself.

While running the cqlsh-no-pass command to connect to the Cassandra database, the following error is displayed:

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

Environment

Aria Operations for logs 8.18.3

Resolution

1. Log in to the node as root via SSH or vSphere Console
   
   
2. Update the cqlshrc configuration file
   
   

   sed -i 's/validate = true/validate = false/' /storage/core/loginsight/cidata/cassandra/config/cqlshrc

3. Connect to the internal Cassandra database
   
   

   cqlsh-no-pass

Additional Information

This behavior will be fixed in a future version of VMware Aria Operations for Logs.