Hello, Those tables are empty by default, except system_auth.roles table which contains one entry(by default): the cassandra user/role. CassandraRoleManager creates it on startup if it does not exist.
Those tables will be populated once you start adding new users/roles and use authorization. What do you mean by "I tried removing the system_auth folder from data but the keyspace isn’t removed. "? Is the folder deleted? Did you restart and the folder was recreated or not? Did you get errors when it restarted and Cassandra tried to recreate the system_auth keyspace? Regards, Horia On tis, 2018-07-17 at 10:02 +0200, Thomas Lété wrote: > Hi everyone, > > Due to a crash, we lost the system_auth keyspace. It was not > important at that time because this was a closed system, not > communicating outside the structure so we used AllowAllAuthorizer. > Now it is changing and we would like to recover that keyspace (re- > create it from scratch). > > Unfortunately, Cassandra isn’t able to populate the tables, they just > stay empty… > I tried removing the system_auth folder from data but the keyspace > isn’t removed. > > Do you know a procedure that can be used to re-generate that keyspace > without reinstalling Cassandra from scratch ? > > Thanks for your help :-) > > Thomas > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org >
