Sunday, January 28, 2024

ScyllaDB error: You have to be logged in and not anonymous to perform this request

 

Sometimes  you encountered a error in scylladb - "You have to be logged in and not anonymous to perform this request"


cassandra@cqlsh> GRANT SELECT ON myKeybase.test TO testuser;

Unauthorized: Error from server: code=2100 [Unauthorized] message="You have to be logged in and not anonymous to perform this request"

cassandra@cqlsh>


1 Find and open 'cassandra.yaml' file on your computer.


2 Find and delete 'authenticator: AllowAllAuthenticator' in the file.


3 Replace it with 'authenticator: PasswordAuthenticator'


4 Also, add this line : 'authorizer: CassandraAuthorizer '


Restart Cassandra.