Hello,
is it possible to connect to a cassandra db on different port of 9042 ?
I'm trying putting ip:port but it seems not working
Thanks
Hey Emanuele,
Cassandra uses TCP port 9042 for client requests by default. Where are you putting the ip:port?
Your issue is likely firewall related. 9042 or 9142 (TLS) must be opened on your Cassandra servers for client communication. See Overview of IP ports.
Port 9142 is used when Cassandra is configured for TLS. If that is the case, you will need to stop DataMiner and configure the db.xml to enable TLS. Below is an example.
<DataBase active="True" local="true" type="CassandraCluster">
<DBServer>1.1.1.1,2.2.2.2</DBServer>
<DB>SLDMADB</DB>
<UID>username</UID>
<PWD>password</PWD>
<TLSEnabled>true</TLSEnabled>
</DataBase>
9142 was just an example. I didn't know it is used for SSL.
I can setup another custom port
I don't believe a custom client port for Cassandra can be used with DataMiner. DataMiner expects 9042 or 9142.
Hi Allen,
i'm not discussing about cassandra.yaml where I know how to use different port.
I'm discussing about Dataminer app and the db configuration in both db.xml and cube. I have a cassandra setup not using default 9042 (it uses 9142) and I'd like to connect Dataminer.
The host:port value I told about is in Cube or in db.xml; if I put the db endpoint in this way (host:port) it seems not working.