This is very strange behavior if Cassandra won't recreate the cassandra user when you delete the folder. So just to make sure, you are stopping Cassandra on all nodes and deleting the data directory?
-- SIMON FONTANA OSCARSSON Software Developer Ericsson Ölandsgatan 1 37133 Karlskrona, Sweden simon.fontana.oscars...@ericsson.com www.ericsson.com On tis, 2018-07-17 at 16:01 +0200, Thomas Lété wrote: > It’s empty... > > > > > Le 17 juil. 2018 à 15:59, Horia Mocioi <horia.moc...@ericsson.com> a écrit : > > > > Could you also send the output of "select * from system_auth.roles"? > > (you will need to change authenticator to AllowAllAuthenticator and > > authorizer to AllowAllAuthorizer) > > > > On tis, 2018-07-17 at 15:43 +0200, Thomas Lété wrote: > > > > > > Ok I tried that, nothing better (I already tried dropping the entire > > > system_auth folder that way, same result) > > > > > > When I open the log, I found nothing about « Password » and when I > > > search for « roles », I only find that : > > > > > > DEBUG [main] 2018-07-17 15:37:39,420 > > > CompactionStrategyManager.java:380 - Recreating compaction strategy - > > > disk boundaries are out of date for system_auth.roles. > > > DEBUG [main] 2018-07-17 15:37:39,420 DiskBoundaryManager.java:53 - > > > Refreshing disk boundary cache for system_auth.roles > > > DEBUG [main] 2018-07-17 15:37:39,422 DiskBoundaryManager.java:56 - > > > Updating boundaries from > > > DiskBoundaries{directories=[DataDirectory{location=/home/cassandra/da > > > ta}], positions=[max(9223372036854775807)], ringVersion=3, > > > directoriesVersion=0} to > > > DiskBoundaries{directories=[DataDirectory{location=/home/cassandra/da > > > ta}], positions=[max(9223372036854775807)], ringVersion=16, > > > directoriesVersion=0} for system_auth.roles > > > > > > The configuration I use for Auth is the following : > > > > > > authorizer: CassandraAuthorizer > > > permissions_validity_in_ms: 2000 > > > permissions_update_interval_in_ms: 2000 > > > authenticator: PasswordAuthenticator > > > credentials_validity_in_ms: 2000 > > > credentials_update_interval_in_ms: 2000 > > > > > > > > > > > Le 17 juil. 2018 à 15:26, Simon Fontana Oscarsson <simon.fontana.os > > > > cars...@ericsson.com> a écrit : > > > > > > > > Could you try the following steps? > > > > > > > > Stop Cassandra. > > > > Change authenticator in yaml to PasswordAuthenticator if not > > > > already done. > > > > Remove data directory with `rm -rf data/system_auth/roles-*` > > > > Start Cassandra. > > > > Login with `cqlsh -u cassandra -p cassandra` > > > > > > > > Works for me. > > > >
smime.p7s
Description: S/MIME cryptographic signature