Not able to create different project type

[nitin.sethi]

Prob:- I have Jira server starter license. I was trying to install it on cloud server but after several attempts, i successfully installed it one instance-1. Initially, when i installed on instance-1 it had some issue and I generated the license for that instance-1 with server ID- XXXX-YYYY-ZZZZ-AAAA but later I destroyed that instance-1 and created the new instance-2 whereas the server ID has been changed to BBBB-CCCC-DDDD-EEEE but the license key is still same. When i used the same license key , i am unable to get full access of JIRA for example:- i am not able to create different project type like agile or etc. It is just giving me business type project creation access. 

Please guide me how do i resolve this issue.

Thanks

[Andy Heinzer]

The Server ID does not have to match your license key.   It's only when you first generate the license key do you need to enter in a server ID.  After that you can apply that license key to a server with a different server ID if need be.   It's a common misconception that the server ID is required to match that specifically generated license key.

So there must be something else going wrong here.  I looked up your account and I found that you have a Jira Software starter license.  With this applied you should be able to create both Jira Software and Jira Core projects. 

However, if you do not see the ability to create an agile project, one that would have a scrum or kanban board, then it is possible that your Jira Software plugin did not start when Jira started, or is not installed.

Try going to the Cog Icon -> Applications -> Versions & Licenses.    This will tell us what product licenses are installed here, AND which applications your Jira site has installed.    If you see for Jira Software a warning message that states something along the lines of, "You have a license for Jira  Software, but Jira Software is not installed"  Then this would explain this behavior and there should be a button there to download/install that application to your site.

If you are not seeing that error and your license is activated there, then the plugin likely did not start up for some reason, in which case I would want to take a closer look at your $JIRAHOME/log/atlassian-jira.log file to better understand why that happened.

Maybe grab a screenshot of that versions & licenses page to help us better understand your site right now.

[nitin.sethi]

Hi Andrew, 

First of all many thanks for your response.

I am still unable to fix the issue and as requested by you, I am attaching some of the supporting images and links so you can get more insights on the issue.

Versions & licenses page :-  https://imgur.com/a/Vaa3ueR 

Log analyzer:-  https://imgur.com/a/56mU7gT

Log Zip Link :- https://www.dropbox.com/s/ytc2dm89qzzicjg/JIRA_support_2018-06-02-09-49-27.zip?dl=0

If you still need more information pls do let me know so i can fix this issue.

Thanks

Nitin

[Andy Heinzer]

I can see the problem now.   You're using a MySQL 5.7.22 database version with Jira.  As a result this database version is using a slightly different setup than MySQL versions before 5.7.6.   In that version of that database MySQL implemented a different permission needed in order to create foreign key constraints.    Your logs are showing this kind of error repeatedly:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: REFERENCES command denied to user 'jirauser'@'localhost' for table 'AO_5FB9D7_AOHIP_CHAT_LINK'

This means that when Jira starts, it can't create any of the foreign key constraints needed to function correctly.

This error is explained in the KB https://confluence.atlassian.com/jirakb/com-mysql-jdbc-exceptions-jdbc4-mysqlsyntaxerrorexception-references-command-denied-to-user-872266070.html

As for how to best correct this issue, you might be able to:

1. Stop Jira
2. on MySQL run the command:

   GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
   flush privileges; 

3. Start Jira again

This might fix everything when Jira starts.  But if this does not fix the problem, and this is a new Jira install, it might just be better to drop this database, and create a new database by closely following the exact instructions in Connecting Jira to Mysql

Please let me know the results.

[nitin.sethi]

Hi Andrew,

Thanks for your kind support and response.

I have tried to resolve the error using above query but unfortunately, it did not work. Thus, i have re-installed using another method and it worked out.

I am going to record a video and steps for other community members since i did not find a detail and single line of solution available on the internet. 

I wish this will help other users as well for better understanding of installation on a cloud.