I am trying to setup Cassandra DB(single node) on a separate EC2 instance in AWS. Both Dataminer(as well as CUBE) and Cassandra separate DB instance are setup and seem to work properly in same private subnet. I am able to confirm that security groups from Dataminer to Cassandra DB is open for port 9042. Cassandra EC2 also have ports open for ports 7000, 7001, 7199 in security group. Network test on port 9042 from Dataminer (power shell) to Cassandra is successful (pls see image).
I also configured (via CUBE) on the System Center->Database with Cassandra Cluster(pls see image).
User (dataminer) is configured on cassandra system (pls see image).
I am getting "no connection error to CassandraCluster" alarm on dataminer and not able to connect to the cassandra DB instance(pls see image)
Can someone please help with troubleshooting this error?
I have yet to install OpenSearch in separate EC2 instance, wanted to get this to work before I get on it next.