Hi Dojo team,
Checking the steps for Cassandra installation (DataMiner Docs), we noticed that we only configure extra permissions on the 'cassandra' user. This user is created as part of the installation. However, we were not able to find extra steps to create a user that can be used to connect to the Linux OS via SSH for troubleshooting purposes.
Please could you confirm if it is required to have SSH access to the Linux OS where the nodes are running for further troubleshooting? And if so, please could you let us know what will be restrictions for this user? For example, in case this user has sudo access, what specific commands should this user be allowed to execute? What specific folder(s) should this user be allowed to access? We could potentially use the same user to configure an element using the connector 'Linux Platform SSH' so we can monitor the Linux node from DataMiner.
Hi Miguel,
There are different ways to validate that the Cassandra Cluster is still running fine. The main goal would be to use the Apache Cassandra Cluster Monitor connector. This connector makes use of CQL only ATM, so no need for SSH there. If you want to get more information on the health of the Cassandra DB, you can also use the Linux Platform SSH connector to get general server KPIs.
So for monitoring, you could be perfectly fine without SSH credentials. There are still some things that we can't access through CQL. For example the Cassandra logs, so it might be handy to have SSH credentials at hand to do manual checks. We are looking more and more to remove the need for SSH credentials. For example, support getting logs through CQL:
https://issues.apache.org/jira/browse/CASSANDRA-17948
When making changes to the configuration or doing the installation of Cassandra will require still SSH credentials and the user will need to be able to run sudo commands.