I have never been so furious over an issue... and I am an Assembly/C/C++ developer. My current project has been a full time planning/development/marketing preparation/etc for 6 years. It is now finished and my business is about to launch. So I like to think I have a bit of patience. But I am quiet literally seeing my vision flash out of anger because of this situation. I am being serious, and not exaggerating in the slightest.
I have installed everything except the plugins. Turns out JIRA Core (or Software, I cannot remember) was not setup to use MSSQL. I cannot answer why, as I made sure the other products requiring it, such as Confluence, were setup perfectly fine with it. I've been trying to get it all installed for over a week - while balancing preparation for the launch. So I truly can't remember what happened at that time. I uninstalled and reinstalled JIRA Core/Software a few times, because of errors I had on my new Windows 2019 server - but I fixed them. Everything seemed peachy.
Please, take note. It has now taken me DAYS to properly go through all of this - while also managing every preparation for our official launch (happening in a matter of weeks). I am very aware that I have put this all on myself for the timing. I blame no one but myself to take all of this on at this time. (Note I was NOT looking for a "silver bullet" or any other such "classic" development mistake. Rather, I was wishing us to start learning about the system, and slowly making it the only thing we used over the proper amount of time).
That is the end of my bitching. Thank you for making it through that!
****************************************************************************
******* Wrong JVM version! JIRA requires 1.8 or 11 to run. *******
****************************************************************************
Yeah. This same issue. I went through virtually every solution I could find online and around here. The last ~36 hours have been dedicated to this alone. I have downloaded EVERY single version of JAVA available to me which this says it will accept. But it doesn't matter, it finds it all unacceptable.
I linked it to:
C:\Program Files\Java\server-jre-8u231\jdk1.8.0_231\jre
C:\Program Files\Java\server-jre-8u231\jdk1.8.0_231
C:\Program Files\Java\jdk-11.0.5
C:\Program Files\Java\jdk-11.0.5\bin
And downloaded and uninstalled them multiple times. Trying anything different I could find (those + the latest v13 are the only ones which still exist on my server. There were more than that as I tried to work through this).
Finally, I saw a post from someone saying JIRA shipped with its own! HURRAY! THERE IS NO WAY THE ISSUE COULD STILL OCCUR! So I set my JAVA_HOME and JRE_HOME to:
C:\Program Files\Atlassian\JIRA\jre
And I tried once more with config.bat, JUST SO I COULD CHANGE THE DATABASE! AGAIN! EVERYTHING IS INSTALLED!
And... It then told me this:
Microsoft Windows [Version 10.0.17763.864]
(c) 2018 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>cd C:\Program Files\Atlassian\JIRA\bin
C:\Program Files\Atlassian\JIRA\bin>config.bat
'find' is not recognized as an internal or external command,
operable program or batch file.
'find' is not recognized as an internal or external command,
operable program or batch file.
'find' is not recognized as an internal or external command,
operable program or batch file.
****************************************************************************
******* Wrong JVM version! JIRA requires 1.8 or 11 to run. *******
****************************************************************************
***
*** Output of java -version command is:
openjdk version "1.8.0_202"
OpenJDK Runtime Environment (AdoptOpenJDK)(build 1.8.0_202-b08)
OpenJDK 64-Bit Server VM (AdoptOpenJDK)(build 25.202-b08, mixed mode)
*** (End of output) ***
C:\Program Files\Atlassian\JIRA\bin>
I need help. And soon. Please. I am not one to give up. But I need to finish the struggle with this leviathan so I can get back to finishing up the software with everyone else - knowing this is all done 100% properly. So I can get back to making sure the launch goes as perfectly as possible.
I absolutely LOVE the community here, and I know for a fact Atlassian sells the ABSOLUTE BEST products out there (I spent several weeks researching every single solution available on the market). And not only that, they give startups like my own the greatest possible help with pricing. I am truly in awe of Atlassian, what it is doing, what it has done, and what they believe in. I love everything I have seen here. Please do not let what I have said above make you think otherwise. I just am at my witts end with all of this.
Anyone who has ANY idea how to fix this. Please, speak up! I feel as if I must have messed up a single character in my code, and I have made it horribly over-complicated and spent the last month trying to find the bug and fix it lol.
Wow - I really feel your frustration. I think that root cause problem is that you are trying too hard to "whack moles". Jira usually installs nice and easily on Windows. If you are chasing down individual errors, this is usually an indication that you have not installed it correctly. You should not have to run configure.bat (or any other .bat files) to get Jira running. The service will run the right files for you when it starts up.
How does your statement that "Turns out JIRA Core (or Software, I cannot remember) was not setup to use MSSQL." figure into the problems that you are having? Are you trying to migrate the current Jira from something else to MSSQL or to set up a new instance or what?
It was originally installed without using MSSQL. And yeah, once I sorted the issues out on the server everything went far better after that.
Unfortunately, I now need to change JIRA from using the "example" database to using MSSQL.
I finally got everything installed 100%. Then this popped up when I signed in, saying it was a health risk, or wasn't at ideal health, I can't remember it precisely. So I would just be... So irked if I had to uninstall all of it to reinstall that one thing. But well... Argh. I would have saved time I'm sure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You shouldn't have to uninstall. Most health problems are reasonably easily fixed. Let me know if I can be of any help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How precisely do I change the H2 database in an installed and configured JIRA instance on a Windows Server 2019, to Microsoft SQL Server 2017 (or 2019 - as I have both)?
Without using the config.bat file, which was giving me so many issues?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You don't "change" the database. You need to migrate the data from one database to the other. There is a good description of the steps in this article: https://community.atlassian.com/t5/Confluence-questions/migrate-h2-to-sql-server/qaq-p/218724
Summarizing:
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.