Hi Horia, Thanks for your reply :-) As the keyspace was corrupt, Cassandra didn’t boot… So as we were in a hurry and not needed that keyspace, we dropped the files and put AllowAllAuthorizer.
Now even the roles table is empty. When I enable PasswordAuthenticator, I’m not able to authenticate, cassandra user doesn’t exist… Is there a way to insert the default user in the roles table ? Yes the folder were recreated but without any data in the tables. I didn’t see any error in the logs. > Le 17 juil. 2018 à 11:26, Horia Mocioi <horia.moc...@ericsson.com> a écrit : > > 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 >> > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org
