I’m new to Cassandra and trying to deploy an application using Cassandra. I created a keyspace in my Cassandra DB but when I create my keyspace account I get an error like below
I have tried many ways like create user and create roles but it doesn’t work. The version I am using is 3.11.13
CREATE ROLE etl WITH PASSWORD = 'xxxxxx' AND LOGIN = true;
InvalidRequest: Error from server: code=2200 [Invalid query]
message="org.apache.cassandra.auth.CassandraRoleManager doesn't support PASSWORD"
CREATE ROLE
CREATE USER
>Solution :
The error indicates that you haven’t enabled authentication in your cluster.
The PASSWORD option is only supported if you have configured PasswordAuthenticator. By default, authentication is disabled in cassandra.yaml with:
authenticator: AllowAllAuthenticator
You need to configure the nodes with the password authenticator to enable authentication:
authenticator: PasswordAuthenticator
For details, see Enabling Password Authentication in Cassandra 3.11. Cheers!