Error while creating first project after fresh install

Question

We did a fresh install of Jira Service Desk Server. Mysql Database. Install worked properly. Loging in as admin, when creating our first Project we get an error.

Hmm... we couldn't create your project due to an unknown error. Try refreshing the page to start again.

Using MySQL. Anyone can help ? Thanks!

kris · Answer

Try this:

https://confluence.atlassian.com/jirakb/com-mysql-jdbc-exceptions-jdbc4-mysqlsyntaxerrorexception-references-command-denied-to-user-872266070.html

Marc-André Lanciault · Answer

Thanks Kristopher !

I see 2 interesting errors:

1- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: REFERENCES command denied to user 'jiradbuser'@'10.128.107.139' for table 'AO_5FB9D7_AOHIP_CHAT_LINK'

So the REFERENCES privilege would be missing ?

2- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jiradb.AO_2C4E5C_MAILCHANNEL' doesn't exist

And a table is missing ? How can it be fixed ?

Thanks!!

kris · Answer

Best place to start is to tail the logs while you're creating the project to see what the error is on the backend.  You can do this by using the command:

tail -f /opt/atlassian/jira/logs/catalina.out

or

tail -f /var/atlassian/application-data/jira/log/atlassian-jira.log

Above path is assuming you've used the standard directories in your installation.

Here is a KB of usual culprits for this error:

https://confluence.atlassian.com/jirakb/hmm-we-couldn-t-create-your-project-due-to-an-unknown-error-818580338.html