Symptoms

Upon upgrading Crowd, users that used to be automatically approved  are presented with the following:

Diagnosis

This will only affect instances that use the HSQL database for CrowdID (even if you're using another database for Crowd itself). To confirm if you are using the an HSQL database, look for a database/ directory in your installation directory.

Cause

When upgrading Crowd, you download a new installation directory and point it at your old home directory. Unfortunately, the OpenID Server's database is stored in the installation directory, so it needs to be manually copied across otherwise all of the CrowdID server's data is lost.

Resolution

Copy the database/ directory from your old installation folder to your new one. This will allow your CrowdID server to find the missing data.

Having done so, please migrate your CrowdID data to a production database to resolve this problem permanently.

1. To do so, you'll need to first connect CrowdID to a production database.
2. Next, migrate from HSQLDB to MySQL, or any other production database of your choosing. (Note: although this guide is for Confluence, it will also work with CrowdID's HSQL database).