After I recovered the the Cassandra role, after someone change the super user password I'm getting this error msg.
Error from server: code=0000 [Server error] message="java.lang.RuntimeException: Invalid metadata has been detected for role cassandra"',)})
Any thoughts on it? I'm a bit lost ...
Thanks
EDIT - I'm using DSE version 6.8. I did.
Step 1 - On all nodes, disable authentication and authorisation by setting the following properties in cassandra.yaml (requires a rolling DSE restart):
authenticator: AllowAllAuthenticator authorizer: AllowAllAuthorizer
Step 2 - Reset the password:
cqlsh> UPDATE system_auth.roles SET salted_hash = '$2a$10$1gMPBy9zSkDzKxdbU2v/gOslcMRPDcXVqmwQYBmi8MVgYvNdRZw/.' WHERE role = 'cassandra';
Step 3 - Re-enable authentication
Here is the table contents:
cqlsh> SELECT * FROM system_auth.roles WHERE role = 'cassandra'; role | can_login | is_superuser | member_of | salted_hash -----------+-----------+--------------+-----------+-------------------------------------------------------------- cassandra | null | null | null | $2a$10$1gMPBy9zSkDzKxdbU2v/gOslcMRPDcXVqmwQYBmi8MVgYvNdRZw/.
After I enabled the authentication back.
[cassandra]# [cassandra]# cqlsh 10.30.50.4 -u cassandra -p cassandra Connection error: ('Unable to connect to any servers', {'10.30.50.4:9042': error(111, "Tried connecting to [('10.30.50.4', 9042)]. Last error: Connection refused")}) [cassandra] cassandra]# cqlsh 10.30.50.4 -u cassandra -p cassandra --connect-timeout 30 Connection error: ('Unable to connect to any servers', {'10.30.50.4:9042': AuthenticationFailed('Failed to authenticate to 10.30.50.4:9042: Error from server: code=0000 [Server error] message="java.lang.RuntimeException: Invalid metadata has been detected for role cassandra"',)})