It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JIRA 8.6 and PostGRESQL 10

Hello Experts!  This is a new install onto a CentOS 7 on-prem box which is also running PostGRESQL 10.  JIRA running in the foreground starts and runs as far as letting me configure a database, and the last thing it logs is this:

2020-01-04 01:00:41,314-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.j.config.database.SystemDatabaseConfigurationLoader] Storing database configuration in /home/atlassian/application-data/jira/dbconfig.xml
2020-01-04 01:00:41,676-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /home/atlassian/application-data/jira/dbconfig.xml
2020-01-04 01:00:41,680-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.j.config.database.DatabaseConfigHandler] Trying to get encrypted password from xml and decrypt it
2020-01-04 01:00:41,683-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.j.config.database.DatabaseConfigHandler] Database password decryption not performed.
2020-01-04 01:00:42,138-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.

The database check passes, but when proceeding onto what I hoped would be LDAP config, I get a 500 error that suggests I contact Support with this info:

Technical details
Log's referral number: 1f3564ae-a30a-4f8a-b771-2f2943f660bc

Cause
Referer URL: http://192.168.1.2: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)
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)

1 answer

1 accepted

Hi,

here are a few possible things you could verify:

  • are you using the correct PostgreSQL JDBC driver?
  • did you create the database with correct collation and gave sufficient permissions to the db user?

Jira Server 8.6 - Supported platforms

Connecting Jira applications to PostgreSQL

Nailed it!  Apparently installing postgresql-jdbc isn't enough; you have to add it to /atlassian-jira/WEB-INF/lib just like the docs say.  Thank you for reading!

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you