Keyspace system_auth does not exist?

Question

I wanted to do the following command:

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

Is it normal that system_auth is not shown as a keyspace?

Basically the following error occurs:

Bad Request: Unknown keyspace system_auth

Also, how do I even view the keyspaces that exist? Is viewing them even possible in cqlsh?

http://stackoverflow.com/questions/16612463/is-there-a-clear-equivalent-of-show-keyspaces-in-cqlsh-2 — MeBigFatGuy, Mar 06 '14 at 06:04

score 5 · Answer 1 · answered Mar 06 '14 at 07:12

5

That keyspase is not created when you use authenticator: AllowAllAuthenticator (which is by default). So, setup your authenticator, restart your node, and you'll be fine

answered Mar 06 '14 at 07:12

Mikhail Stepura

3,374
20
16

I am using ccm and do what you indicate but still the system_auth keyspace is not available – ftrujillo Apr 29 '14 at 08:48

score 0 · Answer 2 · answered May 06 '14 at 05:42

The system_auth keyspace does not exist in a fresh cassandra installation . This will automatically be created when authentication is enable by changing the two properties in cassandra.yaml i.e. "authenticator: PasswordAuthenticator" and "authorizer: CassandraAuthorizer" .

To view the keyspaces use the cql command "desc keyspaces" or "select * from system.schema_keyspaces;".

Keyspace system_auth does not exist?

2 Answers2