Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

[Solved] Installation Problem with 8.7.1

Stephen Chrzanowski
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 24, 2020

Following the instructions to install Confluence from here: https://www.youtube.com/watch?v=oMhkNDnhfTY&list=WL&index=41&t=0s

I successfully installed Confluence.  Thinking its the same process for Jira, using the same host, I followed the same instructions in PSQL (I didn't repeat the already performed instructions, like, creating directories or installing postgres), but, changed anything relevant from Confluence to Jira.  So, the Schema is jira, the database is jiradb, etc.

I've done this twice now, with deleting the /opt/atlassian/jira directory, as well as the /var/atlassian/application-data/jira directory prior to reinstalling, dropping the schema, user and database (In whatever order it required) and repeated the create process and I get the same error.

Right after the 'fresh' install, I go to http://{hostIP}:8080 and I'm presented with the options to which DB I want to use, I select Postges, enter the info as required, I SUCCESSFULLY test the connection, but then when I tell it to go, it fails with an error 500.

Technical details

Log's referral number: f818410e-964d-4904-8aa2-b53cef3c8fc8

Cause

Referer URL: http://{hostIP}:8080/secure/SetupDatabase!default.jspa

com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM jira.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "jira.propertyentry" does not exist
  Position: 68)

Can I run something to create the database?

 

[SOLVED]

So, I'm not sure which is wrong, but either Confluence instructions are wrong, or, Jira installation is wrong based on what the Confluence steps in the YouTube vid states.

When I installed Jira, I told it to use the Jira schema, however, it appears that was the wrong step.  I reinstalled (4th time) and now have it running when I entered public as the schema.  The installation went smoothly after that.

0 answers

Suggest an answer

Log in or Sign up to answer