Hi Lucas, Thanks for your response. So I checked the system.log and I found the following error at the end which I think is causing the problem.
Fatal exception during initialization org.apache.cassandra.exceptions.ConfigurationException: Found system keyspace files, but they couldn't be loaded! It could be due to removing some of the data. I ran the following command to remove some data. sudo rm -rf /var/lib/cassandra/* I am new to Cassandra and I think I made a mistake. So I had only one node which was working fine with my tables that I had. I wanted to add a second node and start using the real power of Cassandra. So I follow one of post that I found, there were some changes in cassandra.yaml file and afterwards I had to remove the files and that's why I run the remove command. So right now neither of CQLSH and nodetool works. Please let me know if you need any other information. Here is a screenshot of the system.log. Thanks a lot for your help. Best, Amir [image: Inline image 1] On Tue, Aug 29, 2017 at 7:17 AM, Lucas Benevides < lu...@maurobenevides.com.br> wrote: > Hello Amir, > > You should see the log. If it was installed by the apt-get tool, it should > be in /var/log/cassandra/system.log. > It can occur when the schema of the node you are trying to connect is out > of date with the cluster. > How many nodes are there in you cluster? > What is the output of "nodetool describecluster"? > > Best regards, > Lucas Benevides > > 2017-08-28 19:45 GMT-03:00 Amir Shahinpour <a...@holisticlabs.net>: > >> Hi, >> >> I am getting an error connecting to cqlsh. I am getting the following >> error. >> >> Connection error: ('Unable to connect to any servers', {'127.0.0.1': >> error(111, "Tried connecting to [('127.0.0.1', 9042)]. Last error: >> Connection refused")}) >> >> I change the Cassandra.yaml file setting for rpc_address to my ip address >> and listen_address to localhost. >> >> >> listen_address: localhost >> rpc_address: my_IP >> >> I also tried to change the cassandra-env.sh to add my IP address but >> still same error. >> >> JVM_OPTS="$JVM_OPTS -Djava.rmi.server.hostname=my_IP" >> >> Any suggestion? >> >> >> >> >