i'm stuck at application setup step during JIRA configuration

[Wajahat Gul]

i have installed jira server 7.13 it successfully installed and database test connection was successful when i submit the form it took so long and then it stopped after refereshing of page it move to application setup wizard but i'm stuck there because i'm not able to move to next step  here is the exception in jira log:

2019-01-02 09:50:58,024 http-nio-8089-exec-23 ERROR anonymous 580x200x1 w7mgh7 0:0:0:0:0:0:0:1 /secure/SetupDatabase.jspa [c.a.jira.startup.JiraStartupLogger] Cannnot obtain JIRA system information
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT COUNT(P.ID) FROM project P (Table 'jiradb.project' doesn't exist)
    at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCountByAnd(DefaultOfBizDelegator.java:379)
    at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCount(DefaultOfBizDelegator.java:368)
    at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.getCount(WrappingOfBizDelegator.java:224)
    at com.atlassian.jira.startup.JiraSystemInfo.obtainDatabaseStatistics(JiraSystemInfo.java:334)
    at com.atlassian.jira.startup.JiraStartupLogger.printStartedMessage(JiraStartupLogger.java:128)
    at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.printJIRAStartupMessage(ConsistencyCheckerImpl.java:200)
    at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.initialise(ConsistencyCheckerImpl.java:185)
    at com.atlassian.jira.startup.DefaultJiraLauncher.postDBActivated(DefaultJiraLauncher.java:164)
    at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:144)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.runPostDbSetupRunnables(DatabaseConfigurationManagerImpl.java:286)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:279)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:243)
    at com.atlassian.jira.web.action.setup.SetupDatabase.doExecute(SetupDatabase.java:207)
    ... 1 filtered
    at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
    ... 7 filtered
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    ... 45 filtered
    at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
    ... 1 filtered
    at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
    ... 31 filtered
    at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
    ... 24 filtered
    at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
    ... 24 filtered
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT COUNT(P.ID) FROM project P (Table 'jiradb.project' doesn't exist)
    at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533)
    at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:877)
    at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:857)
    at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:795)
    at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:775)
    at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:1091)
    at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCountByAnd(DefaultOfBizDelegator.java:375)
    ... 155 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jiradb.project' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
    at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:527)
    ... 162 more

[Nic Brough -Adaptavist- · Accepted solution]

It looks to me like the database user either did not have the rights to create all the tables it needed during setup, or it does not have the rights to see the data in the database.

I would read the logs from when you ran setup to see what errors are in there, and check that your database user has all the right privileges in the database (i.e. try logging in with a command line tool and check the tables exist and are visible to that user)

[Wajahat Gul]

jiradbuser have all the privileges for jiradb and there are multiple exception for creating table and selecting records from table in log file

[Wajahat Gul]

0

11

14:10:24

CREATE TABLE project1 (ID DECIMAL(18,0) NOT NULL, pname VARCHAR(255), URL VARCHAR(255), LEAD VARCHAR(255), DESCRIPTION TEXT, pkey VARCHAR(255), pcounter DECIMAL(18,0), ASSIGNEETYPE DECIMAL(18,0), AVATAR DECIMAL(18,0), ORIGINALKEY VARCHAR(255), PROJECTTYPE VARCHAR(255), CONSTRAINT PK_project PRIMARY KEY (ID))

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEAD VARCHAR(255), DESCRIPTION TEXT, pkey VARCHAR(255), pcounter DECIMAL(18,0), ' at line 1

0.000 sec

above table shows the output that i get after testing on of the query from log that shown exception

[Nic Brough -Adaptavist-]

Ok, so the setup failed because of something wrong in the database connection.

What database driver are you using, and is the version of MySQL right for Jira 7.13?

[Wajahat Gul]

Mysql workbench 8.0

Driver mysql-java 8.0.13

[Nic Brough -Adaptavist-]

But what version of MySQL is it?  (Workbench is a client, not a server)

[Wajahat Gul]

Server version: 8.0.13 mysql community server gpl

[Nic Brough -Adaptavist-]

Ok, that answers it - that version is not supported by Jira 7.13.  Try installing it on a supported database - see https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html