Keyspace system_auth does not exist?

I wanted to execute the following command:

alter KEYSPACE system_auth 
WITH replication =  
       { 'class' : 'SimpleStrategy', 
         'replication_factor' : 2 };

Is it normal that system_auth does not appear as a keyspace?


Basically the following error occurs:

Bad Request: Unknown keyspace system_auth


Also, how do I even browse existing keyspaces? Is it possible to view them even in cqlsh?

+4
source share
2 answers

This key database is not created when used authenticator: AllowAllAuthenticator (by default). So configure authenticator, reboot node and you will be fine

+5
source

system_auth cassandra. , cassandra.yaml, "authenticator: PasswordAuthenticator" "authorizer: CassandraAuthorizer".

cql "desc keyspaces" "select * from system.schema_keyspaces;".

0

Source: https://habr.com/ru/post/1530369/


All Articles