Connection errors seen when running sstableloader

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