As part of Stage 5 of the excercise, completed the following steps as described in the documentation to connect Fisheye to the Database:
1. Click Edit and enter the following details:
2. Type: PostgreSQL
Driver Location: Bundled URL: jdbc:postgresql://localhost:5432/fisheye – Note that this value is different from the default value.
User Name: fishuser – This is the user you created in step 2 (above).
Password – Enter the password you defined in step 2 (above).
Click Test Connection to verify that FishEye/Crucible can log in to the database.
Click Save & Migrate.
On clicking Save and Migrate, the following error messages is displayed:
Creating table definitions...
Database must be in NO_TABLES state, currently NO_DB
Database migration failed: java.lang.IllegalStateException: Database must be in NO_TABLES state, currently NO_DB
How do we get over this problem? Please advise.
Could you please verify if you're using a fisheye supported version of PostgreSQL acording to this documentation https://confluence.atlassian.com/display/FISHEYE/Supported+Platforms
Also could you please redo your steps by using document below:
Could you please make sure that the database 'fisheye' really exists, if it's an empty database, and if the PosgreSQL driver can be found at FISHEYE_INST/lib directory?
If the database does not exist, could you please try to create it following the Stage 5, Step 2?
If the driver cannot be found at FISHEYE_INST/lib, please copy it from FISHEYE_INST/lib/dbdrivers/postgresql to FISHEYE_INST/lib.
Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot