4.4 Upgrading a Connect Database

Execute these steps to upgrade an existing Connect database schema.

If Connect is installed in /opt/connect/kc, go to the install subdirectory (i.e. /opt/connect/kc/install).
  1. Run updatedb.sh (sh updatedb.sh)
  2. Run seeddb.sh (sh seeddb.sh)
Note: The updatedb and seeddb scripts require the database.connect property in the database.properties file to be unencrypted.

Troubleshooting

Updatedb will write a log file in /opt/connect/kc/initdb/logs.

Seeddb will write a log file in /opt/connect/kc/logs.

Encrypting and Re-Encrypting Database Passwords

If you have configured a non-default encryption provider, you must convert the user passwords in the database to the new encryption scheme. To do this, run the cryptoutil utility:
cd /opt/connect/kc/install
sh cryptoutil.sh -migrate    
                
This will re-encrypt each user password using the new encryption scheme.