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.
Log's referral number: f818410e-964d-4904-8aa2-b53cef3c8fc8
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.