Encrypting the FME Server Database Password

The password for the FME Server 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 Server Database password, follow these steps:

1. From all machines on which the FME Server Core is installed, open a command prompt and run encryptConfigSetting.ps1 (Windows) or encryptConfigSetting.sh (Linux), located in <FMEServerDir>\Clients\utilities\. When you run the script, supply the following parameters:
   • DB_PASSWORD
   • The DB_PASSWORD value, as provided in fmeDatabaseConfig.txt, and corresponding to the database server type (DB_TYPE) you installed. (If your FME Server is an Express installation, your database server (DB_TYPE) is postgresql. If your FME Server is a Custom installation, your database server (DB_TYPE) is either postgresql, sqlserver, or oracle.)

   For example:

   encryptConfigSetting.ps1 DB_PASSWORD fmeserver

2. Copy the encrypted password that is generated from the command prompt output and paste it over the unencrypted DB_PASSWORD value in fmeDatabaseConfig.txt.
3. Save fmeDatabaseConfig.txt, and restart FME Server.

WARNING: Any change to System Encryption, including generating a new custom encryption key, or reverting to default encryption, also affects the FME Server 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.