Cassandra Authentication Issue

Question

cassandra version: apache-cassandra-2.1.8

I recently configured a 2 node cluster with Authenticator installed on PasswordAuthenticator . When one of the node is disabled, I can not enter Cqlsh and it gets lower than the error

 Connection error: ('Unable to connect to any servers', {'192.168.0.45': AuthenticationFailed(u'Failed to authenticate to 192.168.0.45: code=0100 [Bad credentials] message="org.apache.cassandra.exceptions.UnavailableException: Cannot achieve consistency level QUORUM"',)}) 

System_auth RF is set to 2 since I have 2 nodes.

 C:\apache-cassandra-2.1.8-bin\apache-cassandra-2.1.8\bin>nodetool status Starting NodeTool Datacenter: DC1 ================ Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns Host ID Rack UN 192.168.0.45 327.87 KB 256 ? 66a97a0a-d69c-4daf-b0f5-55cb8442d728 RAC1 UN 192.168.0.46 234.28 KB 256 ? 432031fc-eea3-4b02-8d79-f877bbd8afaf RAC1 KeySpace RF cassandra@cqlsh > select * from system.schema_keyspaces; keyspace_name | durable_writes | strategy_class | strategy_options ---------------+----------------+---------------------------------------------+---------------------------- system_auth | True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"2"} system | True | org.apache.cassandra.locator.LocalStrategy | {} system_traces | True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"2"} (3 rows) 

I added the Cassandra file, the cassandra.yaml file and cassandra-topology.properties

Answer 1

This may have something to do with this:

"For most system_auth requests, Cassandra uses the LOCAL_ONE consistency level and uses QUORUM for the standard cassandrasuperuser;"

Are you trying to connect as a cassandra user? If so, that is probably why he is trying to use a quorum of level of consistency. Since you have only two nodes, the quorum will be a node at the same time.

Try creating another user as instructed here .