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; } } }

Upgrading JIRA 7.8 to 7.13.0 Jira won't start "Jira Access problem"

Jason Ferris

Ran Jira 7.13.0 Core installation for Windows for my upgrade. Everything went fine for upgrade. When I launched Jira for the 1st time I received a window saying

Jira encountered the following problems during startup. You need to fix any errors before you start Jira again.

Database: Update the JDBC URL - We've shipped a new driver for your database. You'll need to run the JIRA config tool (bin/config.bat or config.sh) and click Save. It will make the necessary changes for you. | I tried this but it just says:

No JRE_HOME or JAVA_HOME environment variable is set - attempting to just run 'j
ava' command
*******************************************************************************
******* Wrong JVM version! JIRA requires at least 1.8 to run. *******
*******************************************************************************

I do not have JRE installed on this server. Is this something I need to install now or from what I read it was supposed to install with my install? I am looking at this page

https://confluence.atlassian.com/jirakb/update-the-microsoft-sql-server-jdbc-url-in-jira-server-934718842.html

Or do I need to change the URL and Driver-class lines to match format of this? I am running Microsoft SQL DB 2012.

This is in my test env so i'm thankful i'm testing this out! Can someone please help me? I'm stuck and not sure what else to do other than restart my upgrade.

Thank you!

Accepted answers

Moses Thomas_08kyb0

@Jason Ferris

From the logs it states that there is a problem with with Database connection, there could be something wrong with the user and password that connects Jira to database or dbconfig.xml is corrupted , i suggest you make a copy of the file somewhere else, and then remove this file in the JIRA home folder.
Default is C:\Program Files\Atlassian\Application Data\JIRA (on Windows)
Try to restart JIRA again, enter the right user and password to connect to Db, the dbconfig.xml should be regenerated again.
NOTE: the user and password should be in this file if you don't remember
And the user running Jira should have permission to this file (read, and execute )

Best regards,

Moses

All comments

Kian Stack Mumo Systems

Jason,

You don't need to install java in order to run Jira as it comes bundled with the installer. However, it appears that the bat file is expecting a certain java version but your machine doesn't have those variables set. One option would be to set them following the instructions found here (you should be able to find java within the Jira files).

Otherwise, you should be able to just update your file manually to the format expected and perform a restart.

Jason Ferris

I found JRE/JAVA in C:\Program Files\Atlassian\JIRA\jre\bin. Is this the correct directory? I added the environment variable pointing to this and the Variable name is JRE_HOME. Still receiving same error when launching but now getting this. I did reboot as well.

JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "/XXXDB" requested by the login. The login failed. ClientConnectionId:14a5bc9f-9ec7-466d-8089-f59db0852aa9

This could be because:
- Your database isn't running
- The configuration of your dbconfig.xml file is incorrect (user, password, or database URL etc.)
- There is a network issue between JIRA and your database (e.g. firewall, database doesn't allow remote access etc.)

After the upgrade I did change my dbconfig.xml to the updated information for URL and driver-class

<url>jdbc:sqlserver://server:1433;databaseName=/XXXDB</url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

should I change this back to what it was before? which was

<url>jdbc:jtds:sqlserver://server:1433/XXXDB</url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

Moses Thomas_08kyb0

@Jason Ferris

From the logs it states that there is a problem with with Database connection, there could be something wrong with the user and password that connects Jira to database or dbconfig.xml is corrupted , i suggest you make a copy of the file somewhere else, and then remove this file in the JIRA home folder.
Default is C:\Program Files\Atlassian\Application Data\JIRA (on Windows)
Try to restart JIRA again, enter the right user and password to connect to Db, the dbconfig.xml should be regenerated again.
NOTE: the user and password should be in this file if you don't remember
And the user running Jira should have permission to this file (read, and execute )

Best regards,

Moses

Kian Stack Mumo Systems

Both of the two that you have set up look correct.

Sometimes you have too pass it the scheme. According to the documentation, try this:

<url>jdbc:sqlserver://sqlserver_hostname\instance_name;databaseName=jiradb</url>

Kian Stack Mumo Systems

@Moses ThomasOne thing to keep in mind is that Jira won't let you establish an initial connection to a database if there is already content in there. If you remove the dbconfig file and perform a restart, Jira will think it is a fresh installation. Then it won't let you connect back to that database.

Moses Thomas_08kyb0

@Kian Stack Mumo Systems Yes you right! but he cannot connect to db, I would establish a connection first to a fresh db, then export old db to fresh db but he would need to know how to do this.

Jason Ferris

@Kian Stack Mumo Systems Hello. I am just getting back to this as I put this ticket in Friday and am back at work today. The adjustment you are suggesting to that URL line, what should be in the "instance_name" part? I am not using a clustered environment and I don't think this is a "named instance" DB. I think the command below tells me it's a default instance?

when opening command prompt and typing sqlcmd -S <myjiraserver> it comes back with a prompt of

Jason Ferris

@Moses Thomas @Kian Stack Mumo Systems If I use the username and password in my dbconfig file and open SSMS I can connect to the DB just fine. The login works without issue. Is there another way I should test to make sure it works or should I try copying my dbconfig.xml file out and letting JIRA recreate one? Maybe it's corrupted and not the login?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jira-core