Cant' connect to Cassandra with cqlsh

Asked May 09 '17 at 07:42

Active May 09 '17 at 07:42

Viewed 1,075 times

When i tried to connect to my cassandra cluster with cqlsh, i had this 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")})

So i go to the cassandra.yaml file but my rpc_adress and listen_address parameters are goods.

There is my listen_adress :

# ipv4. If there is only one address it will be selected regardless of ipv4/ipv6. listen_address: localhost

# listen_interface: eth0

# listen_interface_prefer_ipv6: false

And my rpc_address :

rpc_address: localhost

# port for Thrift to listen for clients on rpc_port: 9160

I also tried to modify the file, but i dont have the right for it.

Thank you in advance

asked May 09 '17 at 07:42

Alexandre S.

http://stackoverflow.com/questions/29121904/cassandra-cqlsh-connection-refused – Ashraful Islam May 09 '17 at 08:21
I already tried this. It didn't work – Alexandre S. May 09 '17 at 08:32
What is the value of `native_transport_port` ? – Ashraful Islam May 09 '17 at 08:36
and `broadcast_rpc_address` ? – Ashraful Islam May 09 '17 at 08:38
`native_transport_port` : 9042 and `broadcast_rpc_address` : 1.2.3.4 – Alexandre S. May 09 '17 at 09:08
Is broadcast_rpc_address commented out ? – Ashraful Islam May 09 '17 at 11:15
No it is commented like this : `# broadcast_rpc_address: 1.2.3.4` – Alexandre S. May 09 '17 at 11:26
Though `broadcast_rpc_address` is disable, `rpc_address` will used for connection. – Ashraful Islam May 09 '17 at 11:36
1

Can you telnet on `localhost 9042` ?? – Ashraful Islam May 09 '17 at 11:37
No I can't. That have no sense, yesterday was working great. `Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused` – Alexandre S. May 09 '17 at 12:28
Try nodetool status – Ashraful Islam May 09 '17 at 13:12
Answer of the nodetool status : `nodetool: Failed to connect to '127.0.0.1:7199' - ConnectException: 'Connexion refusée (Connection refused)'.` – Alexandre S. May 09 '17 at 13:37
Are you sure your cassandra is running ?? I think your cassandra is down – Ashraful Islam May 09 '17 at 13:40
Yes my Cassandra is running. I check the status of the service with this command : `sudo service cassandra status` – Alexandre S. May 09 '17 at 13:58
And i got this answer : `Active: active (exited) since mar. 2017-05-09 13:21:27 CEST; 2h 37min ago` – Alexandre S. May 09 '17 at 14:00
your cassandra is not running. exited. try `ps -aux | grep cassandra` – Ashraful Islam May 09 '17 at 15:04
I had this answer : `sevin 3819 0.0 0.0 14264 988 pts/2 S+ 09:02 0:00 grep --color=auto cassandra` – Alexandre S. May 10 '17 at 07:02
I restart the Cassandra service with `systemctl restart cassandra`. Now it is running but it still didn't work – Alexandre S. May 10 '17 at 07:10
paste your system.log – Ashraful Islam May 10 '17 at 07:10
ERROR [main] 2017-05-10 09:13:30,184 JVMStabilityInspector.java:79 - Exiting due to error while processing commit log during initialization. org.apache.cassandra.db.commitlog.CommitLogReplayer$CommitLogReplayException: Unexpected error deserializing mutation; saved to /tmp/mutation8492466347162558035dat. This may be caused by replaying a mutation against a table with the same name but incompatible schema. Exception follows: java.io.IOError: java.io.EOFException – Alexandre S. May 10 '17 at 07:21
Your cassandra is not starting because of this error – Ashraful Islam May 10 '17 at 07:22
This is the last error. My login attemps are not written in the file, I dont know why – Alexandre S. May 10 '17 at 07:22
This append when i restart Cassandra and trying to use cqlsh – Alexandre S. May 10 '17 at 07:23
So, what im supposed to do to start my Cassandra ? I search and i didn't found solutions – Alexandre S. May 10 '17 at 07:25
Is your commitlog data important ? Commit log saved your unflushed data. If you don't care about the data, removing files from \data\commitlogs should be easiest solution. Then restart cassandra – Ashraful Islam May 10 '17 at 07:26
I did it and now it works great ! And my data are still here. Thank you for your help – Alexandre S. May 10 '17 at 07:43

Cant' connect to Cassandra with cqlsh

0 Answers0