Change the EPIM and EPX Database Password - Precisely_EnterWorks - EnterWorks - 11.0

Overview

Change the database password

If your installation is spread across multiple servers, some files will be located on different servers. Perform the following steps on each server containing any of the affected files.

To set the passwords:

1. Stop all EnterWorks services.
2. Encrypt the new EPIM and EPX passwords using both the EPIM encryption method and the EPX encryption method.
   Warning: The only characters allowed in the database password are alphanumeric, the exclamation point, or the underscore characters.
   1. Use the EPIM encryption script to encrypt the new EPIM and EPX passwords. This will give you the two passwords:

      • <EPIM-password-encrypted-with-EPIM-encryption>

      • <EPX-password-encrypted-with-EPIM-encryption>

   2. Use the EPX encryption script to encrypt the new EPIM and EPX passwords.

      • <EPIM-password-encrypted-with-EPX-encryption>

      • <EPX-password-encrypted-with-EPX-encryption>

3. Update the shared configuration properties to set:

   epim.connection.password=<EPIM-password-encrypted-with-EPIM-encryption>

4. Update the Enterworks.properties files:

   On the server hosting this Service	Location
   EnableServerTomcat	<drive>:\Enterworks\EnableServer\tomcat\enterworks-props\Enterworks.properties
   EnableServerWildflyController	<drive>:\Enterworks\EnableServer\jbossController\standalone\configuration\conf \Enterworks.properties
   EnableServerWildflyWorker<n>	<drive>:\Enterworks\EnableServer\jbossWorkerN\standalone\configuration\conf\Enterworks.properties
   EPX	<drive>:\Enterworks\EPX\bin\conf\Enterworks.properties

   In each Enterworks.properties file, set:

   • epim.db.password=<EPIM-password-encrypted-with-EPX-encryption>
   • epim.db.userPassword=<EPIM-password-encrypted-with-EPIM-encryption>
5. Update the esjdbc.properties file.

   In the file:

   <drive>:\Enterworks\EPX\bin\esjdbc.properties

   set:

   server.<EPXUID>.password=<EPX-password-encrypted-with-EPX-encryption>

6. Update the microservices.
   1. Move to the folder:

      <drive>:\Enterworks\enable2020\services\install

   2. For each of the following files:

      • create-enable-api-go-service.cmd

      • create-enable-channel-readiness-service.cmd

      • create-enable-type-ahead-service.cmd

      change the database password in the dbConn setting:
      1. The dbConn setting is the database connection. Open an editor and create the new dbConn setting value using the new unencrypted EPIM database password:

         server=<hostname>;user id=<unencrypted-EPIM-database-user-name>;password=<unencrypted-EPIM-password>;port=1433;database=<database-name>;encrypt=disable

      2. If -encryptedMode=true, the microservice is encrypted:
         1. Use EnterWorks encryption to encrypt the entire new database connection string. For example:

            enable2020-security.exe enc "server=MyHostName;user id=MyEpimDbUserName;password=MyEpimDbPassword;port=1433;database=NameOfMyDatabase;encrypt=disable"

         2. Set:

            -dbConn="<new-encrypted-connection-string>"

      3. Else, if -encryptedMode=false, the microservice is not encrypted. Set:

         -dbConn="<new-unencrypted-connection-string>"

      4. Use the create-<service>-service.cmd script.
7. Restart all EnterWorks services.