Encrypting theFME FlowDatabase Password

The password for theFME Flow Databaseis stored in thefmeDatabaseConfig.txtconfiguration file.

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

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

    2. powershell.exe

  2. 将目录更改为<FMEFlowDir>\Clients\utilities\
  3. Run encryptConfigSetting.ps1 (Windows) or encryptConfigSetting.sh (Linux), and supply the following parameters:
    • DB_PASSWORD
    • TheDB_PASSWORDvalue. Find this in fmeDatabaseConfig.txt, and ensure it corresponds to your database server type. If yourFME Flowis an Express installation, your database server (DB_TYPE) ispostgresql. If yourFME Flowis a Custom installation, your database server (DB_TYPE) is eitherpostgresql,sqlserver, ororacle.

      • For example:

      .\encryptConfigSetting.ps1 DB_PASSWORD fmeserver

  4. Copy the encrypted password that is generated from the command prompt output and paste it over the unencryptedDB_PASSWORDvalue in fmeDatabaseConfig.txt.
  5. Save fmeDatabaseConfig.txt, andrestartFME Flow.
Warning  "> WarningAny change toSystem Encryption,包括基因rating a new custom encryption key, or reverting to default encryption, also affects theFME FlowDatabase password. To ensure this password is based on the current key, you must perform these steps again following any changes performed in System Encryption.