Please complete the following steps to change the passwords for the 

Change

...

in Database Server

PostgreSQL

1. If you have not done so already, switch to the Postgres user and launch psql:
   
   

   Code Block
   sudo su - postgres psql

2. For each database, change the default password, where trifacta and trifacta-activiti correspond to the default roles of the two databases, respectively. Default usernames are listed for each database. Please modify the command if you are using different roles and insert a more secure password for <new_pwd>:
   
   

   Code Block
   ALTER ROLE trifacta WITH PASSWORD '<new_pwd>'; ALTER ROLE trifacta-activiti WITH PASSWORD '<new_pwd>'; ALTER ROLE trifactatimebasedtriggerservice with PASSWORD '<new_pwd>'; ALTER ROLE trifactaschedulingservice with PASSWORD '<new_pwd>';

3. Exit psql:
   
   

   Code Block
   \q exit

MySQL

1. If you have not done so already, switch to the MySQL user and launch:
   
   

   Code Block
   sudo su - mysql mysql

2. For each database, change the default password. Default usernames are listed for each database. Please modify the command if you are using different roles and insert a more secure password for <new_pwd>:
   
   

   Info
   NOTE: In MySQL, the dash is a forbidden character in usernames. Please use underscores instead.

   Code Block
   ALTER ROLEUSER 'trifacta'@'localhost' WITHIDENTIFIED PASSWORDBY '<new_pwd>'; ALTER ROLEUSER 'trifacta-activiti WITH PASSWORD'@'localhost' IDENTIFIED BY '<new_pwd>'; ALTER USER 'trifactatimebasedtriggerservice'@'localhost' IDENTIFIED BY '<new_pwd>'; ALTER USER 'trifactaschedulingservice'@'localhost' IDENTIFIED BY '<new_pwd>';

3. Exit psql:

   Code Block
   \q exit

Change

...

in 

D s item
item configuration

...

1. Below are the username and password properties for each database.

   D s config

    Please review and update as needed: 

   1. D s item
      item database

      : 

      Code Block
      "webapp.db.username" = "<user>", "webapp.db.password" = "<pwd>",

   2. Jobs database: 

      Code Block
      "batch-job-runner.db.username" = "<user>", "batch-job-runner.db.password" = "<pwd>",

   3. Scheduling database: 

      Code Block
      "scheduling-service.database.user" = "<user>", "scheduling-service.password.password" = "<pwd>",

   4. Time-based trigger database: 

      Code Block
      "time-based-trigger-service.database.user" = "<user>", "time-based-trigger-service.database.password" = "<pwd>",

2. Save your changes and restart the platform.

...