This article is half-done without your Comment! *** Please share your thoughts via Comment ***
Last week, I was creating my first database User and Role, but I got the below error in Cassandra – InvalidRequest: code=2200 [Invalid query] message=”org.apache.cassandra.auth.CassandraRoleManager doesn’t support PASSWORD”.
For me, this is very important to resolve this problem because the application requires different database users for each process.
I tried many options to solve this error and I have found that cassandra.yaml file require to edit.
It has an authenticator parameter which has by default allow all types of authentication.
You can find this parameter and can change as mentioned below steps.
Old value:
|
1 |
authenticator: AllowAllAuthenticator |
Change with this new value:
|
1 |
authenticator: PasswordAuthenticator |
Restart your Cassandra service:
|
1 |
$ sudo service cassandra restart |
Login with default admin Cassandra user:
|
1 |
$ cqlsh -u cassandra -p cassandra |
Additionally, you can also check role manager parameter is exists or not. If below mention parameter does not exist in cassandra.yaml, you can add it.
|
1 |
role_manager: CassandraRoleManager |
