FME Flow: 2024.2

Encrypting the FME Flow Database Password

The password for the FME Flow Database is stored in the fmeDatabaseConfig.txt configuration file.

By default, the password is encrypted. The password may be unencrypted if it was manually updated after installation. To encrypt the FME Flow Database password, follow these steps:

  1. From all machines on which the FME Flow Core is installed, open a command prompt and start a PowerShell session. For example, on Windows, the command is:

    2. powershell.exe

  2. Change the directory to <FMEFlowDir>\Clients\utilities\
  3. Run encryptConfigSetting.ps1 (Windows) or encryptConfigSetting.sh (Linux), and supply the following parameters:
    • DB_PASSWORD
    • The DB_PASSWORD value, enclosed in single quotes ('). Find this in fmeDatabaseConfig.txt, and ensure it corresponds to your database server type. If your FME Flow is an Express installation, your database server (DB_TYPE) is postgresql. If your FME Flow is a Custom installation, your database server (DB_TYPE) is either postgresql, sqlserver, or oracle.

      • For example:

      .\encryptConfigSetting.ps1 DB_PASSWORD 'fmeflow'

  4. Copy the encrypted password that is generated from the command prompt output and paste it over the unencrypted DB_PASSWORD value in fmeDatabaseConfig.txt.
  5. Save fmeDatabaseConfig.txt, and restart FME Flow.
Warning  Any change to System Encryption, including generating a new custom encryption key, or reverting to default encryption, also affects the FME Flow Database password. To ensure this password is based on the current key, you must perform these steps again following any changes performed in System Encryption.