Scylla Getting Started Cassandra Query Language (CQL) Security Enable and Disable Authentication Without Downtime

Enable and Disable Authentication Without Downtime¶

Authentication is the process where login accounts and their passwords are verified, and the user is allowed access into the database. Authentication is done internally within Scylla and is not done with a third party. Users and passwords are created with roles using a CREATE ROLE statement. This procedure enables Authentication on the Scylla servers using a transit state, allowing clients to work with or without Authentication at the same time. In this state, you can update the clients (application using Scylla/Apache Cassandra drivers) one at the time. Once all the clients are using Authentication, you can enforce Authentication on all Scylla nodes as well. If you would rather perform a faster authentication procedure where all clients (application using Scylla/Apache Cassandra drivers) will stop working until they are updated to work with Authentication, refer to Enable Authentication.

Enable Authentication Without Downtime¶

This procedure allows you to enable authentication on a live Scylla cluster without downtime.

Prerequisites¶

Set the system_auth keyspace replication factor to the number of nodes in the datacenter and set the class to NetworkTopologyStrategy (required in production environments):

For example:

Single DC (NetworkTopologyStrategy)

ALTER KEYSPACE system_auth WITH REPLICATION =
  { 'class' : 'NetworkTopologyStrategy', '<name of DC>' : <new RF> };

Multi - DC (NetworkTopologyStrategy)

ALTER KEYSPACE system_auth WITH REPLICATION =
   {'class' : 'NetworkTopologyStrategy', '<name of DC 1>' : <new RF>, '<name of DC 2>' : <new RF>};

The names of the DCs must match the datacenter names specified in the rack & DC configuration file: /etc/scylla/cassandra-rackdc.properties.

Procedure¶

Update the authenticator parameter in scylla.yaml for all the nodes in the cluster: Change authenticator: AllowAllAuthenticator to authenticator: com.scylladb.auth.TransitionalAuthenticator.
```
authenticator:  com.scylladb.auth.TransitionalAuthenticator
```
Run the nodetool drain command (Scylla stops listening to its connections from the client and other nodes).
Restart the nodes one by one to apply the effect.
sudo systemctl restart scylla-server
sudo service scylla-server restart
docker exec -it some-scylla supervisorctl restart scylla
(without restarting some-scylla container)

For example:

cqlsh -ucassandra -pcassandra

cassandra@cqlsh> CREATE ROLE scylla WITH PASSWORD = '123456' AND LOGIN = true AND SUPERUSER = true;
cassandra@cqlsh> LIST ROLES;

name      |super
----------+-------
cassandra |True
scylla    |True

Optionally, assign the role to your user. For example:

cassandra@cqlsh> GRANT scylla TO myuser

cqlsh -u scylla -p 123456

scylla@cqlsh> DROP ROLE cassandra;

scylla@cqlsh> LIST ROLES;

name      |super
----------+-------
scylla    |True

Update the authenticator parameter in scylla.yaml for all the nodes in the cluster: Change authenticator: com.scylladb.auth.TransitionalAuthenticator to authenticator: PasswordAuthenticator.
authenticator: PasswordAuthenticator
Restart the nodes one by one to apply the effect.
sudo systemctl restart scylla-server
sudo service scylla-server restart
docker exec -it some-scylla supervisorctl restart scylla
(without restarting some-scylla container)
Run repair on the system_auth keyspace, one node at a time on all the nodes in the cluster.

For example:
```
nodetool repair system_auth
```
Verify that all the client applications are working correctly with authentication enabled.

Disable Authentication Without Downtime¶

This procedure allows you to disable authentication on a live Scylla cluster without downtime. Once disabled, you will have to re-enable authentication where required.

Procedure¶

Update the authenticator parameter in scylla.yaml for all the nodes in the cluster: Change authenticator: PasswordAuthenticator to authenticator: com.scylladb.auth.TransitionalAuthenticator.
authenticator: com.scylladb.auth.TransitionalAuthenticator
Restart the nodes one by one to apply the effect.
```
sudo systemctl restart scylla-server
```
Update the authenticator parameter in scylla.yaml for all the nodes in the cluster: Change authenticator: com.scylladb.auth.TransitionalAuthenticator to authenticator: AllowAllAuthenticator.
```
authenticator: AllowAllAuthenticator
```
Restart the nodes one by one to apply the effect.
sudo systemctl restart scylla-server
sudo service scylla-server restart
docker exec -it some-scylla supervisorctl restart scylla
(without restarting some-scylla container)
Run repair on the system_auth keyspace, one node at a time on all the nodes in the cluster.

For example:
```
nodetool repair system_auth
```
Verify that all the client applications are working correctly with authentication disabled.