4.3 Creating a Connect Database

IMPORTANT: Ensure your DBA has properly setup the Connect database table spaces before proceeding.

Execute these steps to create and populate a new Connect database schema. To upgrade an existing Connect schema, go to the next section (Section 4.3).

If Connect is installed in /opt/connect/kc, go to the install subdirectory (i.e. /opt/connect/kc/install).

Run installdb.sh (sh installdb.sh)
Run seeddb.sh (sh seeddb.sh)

Note: The installdb and seeddb scripts require the database.connect property in the database.properties file to be unencrypted.

Troubleshooting

Installdb 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.