By default, DataMiner installs Cassandra with the PasswordAuthenticator enabled. Cassandra comes installed with a default cassandra user. When DataMiner installs Cassandra (e.g. during migration or installation), an extra superuser named root is created.
Configuring strong passwords for the default users
We highly recommend that you configure more secure passwords for the default user. Preferably, these passwords should be randomly generated and stored in a password vault.
You can do so by executing the following queries (using DevCenter, the DataMiner Cube Query Executor, or your preferred query tool):
ALTER USER cassandra WITH PASSWORD '<NEW PASSWORD>'
ALTER USER root WITH PASSWORD '<NEW PASSWORD>'
To easily change the password for the Cassandra database, execute the change-cassandra-password-script script. This will allow you to change the credentials without a DataMiner restart.
Creating a new superuser and removing the default user
We also recommend that you create a new superuser and disable the default cassandra user. To do so:
Log in with the cassandra user and execute the following query:
CREATE ROLE <new_super_user> WITH PASSWORD = "<STRONG PASSWORD>" AND SUPERUSER = true AND LOGIN = true;
Switch to your new_super_user and execute the following query:
ALTER ROLE cassandra WITH SUPERUSER = false AND LOGIN = false;
Applying the principle of separation of privileges, we recommend that you also create a dedicated user for DataMiner:
CREATE ROLE dataminer WITH PASSWORD '<STRONG PASSWORD>' AND LOGIN = true;
Set the new credentials in DataMiner Cube. For more information, see Configuring the database settings in Cube.
Delete the root user from Cassandra:
DROP ROLE IF EXISTS root;
Restart DataMiner for the changes to take effect.
You can also configure Cassandra to use an LDAP server for authentication. However, this is beyond the scope of this guide.