To ensure that your connection between your application database servers is secure, Sisense uses KeyFiles that you generate.

The contents of the keyfile serves as a shared password for each of the nodes in your replica set. The content of the keyfile must be the same for all members of the replica set.

You can generate a keyfile using any method you choose. The contents of the keyfile must be between 6 and 1024 characters long.

The following operation uses OpenSSL to generate a random character string to use for a keyfile.

To create a KeyFile:

  1. Download OpenSSL and extract the files to your machine.
  2. Open the Command Prompt and navigate to your bin folder of your OpenSSL directory, for example, …/Openssl/bin.
  3. Run the command:
    openssl rand -base64 756 > <path-to-keyfile> 
    For example: openssl rand -base64 756 > c:\openSSL\key
    The file ‘Key’ is created in the path you defined in the command. The location of this file should be referenced in the relevant configuration files. The file should be copied to each node in your replica set.