nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

security error after DB setup

Sven-Peter Barth

when setting up Jira I can test the database connection and get an OK, if I then click on next, the tables are also created in the database and then I get the empty website http: //localhost/secure/errors.jsp.

2020-02-19 15:43:31,388+0100 localhost-startStop-1 INFO [c.a.jira.startup.JiraHomeStartupCheck] The jira.home directory 'e:\Atlassian\Application Data\Jira' is validated and locked for exclusive use by this instance.
2020-02-19 15:43:31,450+0100 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger]

*[c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is configured. Now running Post database-configuration launchers
2020-02-19 15:43:35,013+0100 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from E:\Atlassian\Application Data\JIRA\dbconfig.xml
2020-02-19 15:43:35,013+0100 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigHandler] Trying to get encrypted password from xml and decrypt it
2020-02-19 15:43:35,013+0100 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigHandler] Database password decryption not performed.
2020-02-19 15:43:35,497+0100 JIRA-Bootstrap INFO [c.a.jira.i18n.CachingI18nFactory] [i18n-caching-factory] Created
2020-02-19 15:43:36,028+0100 JIRA-Bootstrap ERROR [c.a.jira.startup.ComponentContainerLauncher] A fatal error occurred during initialisation. JIRA has been locked.

Accepted answers

All comments

Daniel Ebers

Hi Sven-Peter,

did Jira run on the host you are referring to already in the past or is this a new setup?

Is this a test environment or a production instance of Jira?

There might be set a lock (.jira-home.lock) which can occur if your application crashes. In that case you should get to the bottom of the case and find out why the crash happened.

If this is a test environment which has never been online I suspect the database to be not ready or not configured exactly.

Without knowlege of the specific system it is quite hard to tell. Maybe you got some hints where to start from here.

Cheers,
Daniel

JP _AC Bielefeld Leader_

Hi,

what database server are you using? Is the database server a supported platform?

Best

JP _AC Bielefeld Leader_

Is your DNS working on the Jira server? Check, if the database JDBC-URl is correct.

Best

Sven-Peter Barth

I have an MS SQL 2017 on an Windows 2016 Server on the Server runs the Confluence DB with no problems. I made a new DB for Jira in the sam Instanz.

the Jira Server is am Windows 2016 with Jira 8.6.0

the DB is supported https://confluence.atlassian.com/adminjiraserver086/supported-platforms-990552766.html

this is the dbconfig.xml

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>jira</schema-name>
<jdbc-datasource>
<url>jdbc:sqlserver://;serverName=******l;portNumber=******;databaseName=jiradb</url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<username>jiradbuser</username>
<password>****************</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>

<pool-test-while-idle>true</pool-test-while-idle>
<pool-test-on-borrow>false</pool-test-on-borrow>
</jdbc-datasource>
</jira-database-config>

Sven-Peter Barth

the DB is a MS SQL 2017 on Window 2016 Server on the same DB instanz runs a Confuence DB with out problems.

Jira Server is a Windows 2016 with Jira 8.6.0

DNS works.

This is the dbconfig.xml

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>jira</schema-name>
<jdbc-datasource>
<url>jdbc:sqlserver://;serverName=*********portNumber=********;databaseName=jiradb</url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<username>jiradbuser</username>
<password>***************</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>