Summary
When running the sstableloader a connection error is seen, due to the cassandra.yaml file not being found
Symptoms
The following error was seen
Streaming session ID: ae993c90-c175-11e4-8b9e-fd87c74bdff7
ERROR 07:19:56,466 [Stream #ae993c90-c175-11e4-8b9e-fd87c74bdff7] Streaming error occurred
java.net.ConnectException: Connection refused
at sun.nio.ch.Net.connect0(Native Method)
at sun.nio.ch.Net.connect(Net.java:465)
at sun.nio.ch.Net.connect(Net.java:457)
at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:670)
at java.nio.channels.SocketChannel.open(SocketChannel.java:184)
at org.apache.cassandra.tools.BulkLoadConnectionFactory.createConnection(BulkLoadConnectionFactory.java:62)
at org.apache.cassandra.streaming.StreamSession.createConnection(StreamSession.java:235)
at org.apache.cassandra.streaming.ConnectionHandler.initiate(ConnectionHandler.java:77)
at org.apache.cassandra.streaming.StreamSession$1.run(StreamSession.java:221)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Cause
The sstableloader was not picking up the cassandra.yaml file
Solution
Use the -f switch with the sstableloader to point it to the location of the cassandra.yaml file:
sudo sstableloader -v -d 127.0.0.1 -u cassandra -pw cassandra /var/lib/cassandra/data/Keyspace1/Standard1 -f /etc/dse/cassandra/cassandra.yaml