CODEWITHSUNDEEP
cassandracqlsh
ealfonso
ealfonso

Reputation: 7292

InvalidRequest: code=2200 [Invalid query] message="unconfigured table credentials"

I'm trying to reset the cassandra user's password as suggested here:

UPDATE system_auth.credentials SET salted_hash = '$2a$10$H46haNkcbxlbamyj0OYZr.v4e5L08WTiQ1scrTs9Q3NYy.6B..x4O' WHERE username='cassandra';

I'm getting the following error:

InvalidRequest: code=2200 [Invalid query] message="unconfigured table credentials"

My client is cqlsh 5.0.1.

How can I reset the cassandra password?

Cassandra was installed from datastax-ddc-3.7.0-1.noarch.rpm

Cassandra version is 3.7.0

Upvotes: 0

Views: 4099

Answers (2)

user1967356
user1967356

Reputation: 1

To change your password use this command:

ALTER USER <user_name> WITH PASSWORD <enter_new_password>

see http://docs.datastax.com/en/cql/3.1/cql/cql_reference/alter_user_r.html

Upvotes: 0

Ashraful Islam
Ashraful Islam

Reputation: 12830

In Cassandra 2.2 table name changed
Check the Cassandra Release News

New table is roles 

CREATE TABLE system_auth.roles (
    role text PRIMARY KEY,
    can_login boolean,
    is_superuser boolean,
    member_of set<text>,
    salted_hash text
);

Use the below query : 

UPDATE system_auth.roles SET salted_hash = '$2a$10$1PzCxcMNKgsBEcI1lf.ndut24xyO0N2LzRdRF1tzaMaSH9KFLz/0u' WHERE role = 'cassandra';

Upvotes: 1

Related Questions