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 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', 'dc1' : <new_rf> };

Multi - DC (NetworkTopologyStrategy)

ALTER KEYSPACE system_auth WITH REPLICATION =
   {'class' : 'NetworkTopologyStrategy', 'dc1' : <new_rf>, 'dc2' : <new_rf>};

Procedure¶

Update the scylla.yaml authenticator parameter 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 scylla.yaml authenticator parameter for all the nodes in the cluster.
- Change the 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 scylla.yaml authenticator parameter for all the nodes in the cluster.
- Change the 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 scylla.yaml authenticator parameter 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.