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.

[Dnyaneshwar_Borase]

Hi,

We are getting same error after Database setup. We are using SQL 20116 SP2 database with JIRA 8.6.1 version. 

Please let me know how this problem shoud be fixed?

Thanks in advance

Regards,

Dnyaneshwar Borase

[Sven-Peter Barth]

Hi Dnyaneshwar Borase

i just installt a Backup from the Time befor the Problem and that fixt the Problem for me.

Regards Sven

[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>

<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]

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>

[JP _AC Bielefeld Leader_]

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

Best

JP

[Sven-Peter Barth]

DNS is working

[JP _AC Bielefeld Leader_]

Hi,

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

Best

JP

[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

[Sven-Peter Barth]

i run a MS SQL 2017 on Windows 2016 and Jira on Windows 2016

it will be the production instance when its up and running.