Hi,
We have 2 DMAs with 2 external Cassandra node each. All server OS is Windows Server 2019 Standard. Dataminer version is DataMiner (10.1.12.0-11129). In the DMAs Dataminer and Cassandra is installed but Cassandra service is disable. In Cassandra external nodes is only Cassandra is installed. We want to use the Standalone Cassandra Backup Tool but it return the following error: ConnectException: 'Connection timed out: connect'.
In the Cassandra nodes registry was configured as per documentation:
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Apache Software Foundation\Procrun 2.0\cassandra\Parameters\Java
Open the options key and add the following options:
-Dcassandra.jmx.remote.port=7199
-Dcom.sun.management.jmxremote.rmi.port=7199
-Djava.rmi.server.hostname=IpOfTheCassandraNode
Port 7199 is open. It was tested from both DMAs to both Cassandra external nodes with the same ok results:
PS C:\Program Files\Cassandra\bin> Test-NetConnection CassandraNodeIP -port 7199
ComputerName : CassandraNodeIP
RemoteAddress : CassandraNodeIP
RemotePort : 7199
InterfaceAlias : Ethernet0
SourceAddress : DMAIP
TcpTestSucceeded : True
PS C:\Program Files\Cassandra\bin>
The backup tool return the error:
The port is open but the same error is observed when the nodetool is run remotely:
Do you have ideas regarding why this could be failing?. Have anyone experienced the same issue?.
Hi Jens,
Yes, all servers are running Windows Server 2019, the 2 DMAs, the 2 external Cassandra nodes and the ElasticSearch server.
I tried with credentials but I got the same error:
c:Skyline DataMinerTools>StandaloneCassandraBackup.exe listsnapshot -h 1.1.1.1 -u user –pw password
|Executing command: -h 1.1.1.1 -u user -pw password listsnapshots
|ExitCode: 1. ErrorOutput: nodetool: Failed to connect to ‘1.1.1.1:7199’ – ConnectException: ‘Connection timed out: connect’.
|Listing snapshots failed with reason: Unexpected error from nodetool..
Hey Elbano,
If you run nodetool locally on the server are you able to run the commands, or does the nodetool give another error?
If you run nodetool -h -p 7199 listsnapshots, does it then manage to connect?
Our current recommendation for cassandra cluster is to install Casssandra 4.0 but this is only running on Linux
Can you confirm if it might be possible to move the cassandra nodes to a Linux platform, upgrade to 4.0 (normally this does not require any down time between 3.7 & 4.0) and follow the instructions from the following page:
https://docs.dataminer.services/user-guide/Reference/DataMiner_Tools/Standalone_Cassandra_Backup_Tool.html
This will likely solve the problem, if not don't hesitate to contact techsupport@skyline.be for a further look at the system
Hi Elbano,
Are the remote Cassandra nodes also running on a Windows server?
I also notice you’re not supplying a username or password to the standalone backup tool. I’m not sure if authentication is active but if it is, try with the credentials.