Using tools with TDE-encrypted SSTables
This topic explains the steps to get tools working with SSTables that are encrypted with Transparent Data Encryption (TDE
).
You may need to set one or more values, most likely by exporting environment variables in the shell from which you run the tools like sstabledump
, sstablerepairedset
, and sstableloader
.
Steps to get tools working with TDE-encrypted SSTables
If TDE
is configured, the two options to manage encryption keys are either:
-
locally storing the keys in the cluster itself (that is, local storage)
-
or using a
KMIP
server
When local storage is used, the tool needs to query the cluster itself in order to retrieve the necessary encryption key or keys to work with the encrypted SSTable file or files on local disk.
Because most of the DSE SSTable tools require stopping the local DSE process on the node before using a tool, the tool needs to connect to a different node in the cluster.
You must provide the IP address of that different node.
Do this by exporting a value for HCD_HOST
environment variable.
Example:
export HCD_HOST=12.34.56.789
If |
Set authentication credentials
In addition to TDE
, you may also configure authentication.
If TDE
local storage is in use, and username/password authentication is in use, supply those credentials in addition to the HCD_HOST
value.
DSE internal authentication and LDAP are two scenarios where username/password may be required, depending on your requirements.
Using Kerberos is an example of authentication not requiring username/password credentials.
If username/password are required, provide the values via the HCD_USERNAME
and HCD_PASSWORD
environment variables.
Example:
export HCD_USERNAME=myusername
export HCD_PASSWORD=mysupersecretpassword
Alternatively, DSE retrieves the username and password values from the .dserc
file, if present.
Additional considerations
When TDE
local storage is in place, and the tool being used encounters an encrypted SSTable file, the tool uses the HCD Java driver to make a connection to a remote HCD node in the cluster, and submit a CQL
query to retrieve the necessary encryption key.
The tool (such as sstabledump
, sstablerepairedset
, sstableloader
), must connect to a remote node because in most cases the local HCD process needs to be stopped before using any of the SSTable-related tools.
These connection credentials are needed because the tool essentially becomes a client, via the driver, to the cluster.
HCD converts the three environment variables mentioned above by hcd.in.sh
shell script to Java system properties:
-
HCD_HOST
becomes-Dhcd.replicatedkeyprovider.client
-
HCD_USERNAME
becomes-Dhcd.replicatedkeyprovider.username
-
HCD_PASSWORD
becomes-Dhcd.replicatedkeyprovider.password
ReplicatedKeyProvider
is the HCD Java class that consumes these values and handles retrieving the encryption key(s) from the cluster.
HCD implements a log statement in this class that is helpful for debugging.
It is logged at INFO level and available in the system.log
file.
Example log entry format:
"Checking for 'dse.replicatedkeyprovider' system properties, found hostname: %s; username: %s; [no|non-null] password"