Not able to create different project type

Question

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

nitin_sethi · Answer

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.

Andy Heinzer · Answer

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: * Stop Jira * on MySQL run the command:GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on .* TO ''@'' IDENTIFIED BY ''; flush privileges; * 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 · Answer

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