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)
Hi,
here are a few possible things you could verify:
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.