You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Installing form
https://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-software-8.13.1.tar.gz
In a debian 10
with MySQL 8 and java driver 8.0.22
and getting Cannot add user, all the user directories are read-only.
Any idea ?
Hi JP,
this is strange for a fresh install as the message suggests you are trying to write to an external directory which is read-only as for example LDAP or Active Directory.
Could you please provide a probably present error message from application logs (atlassian-jira.log - probably also those from catalina.out)?
The reason for such a fundamental error should be logged into logged files.
Cheers,
Daniel
I am doing a fresh install ... following all the steps mention in
hitting this error:
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT COUNT(U.ID) FROM cwd_user U (Table 'jiradb.cwd_user' doesn't exist)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCountByAnd(DefaultOfBizDelegator.java:386)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCountByAnd(DefaultOfBizDelegator.java:376)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCount(DefaultOfBizDelegator.java:370)
at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.getCount(WrappingOfBizDelegator.java:224)
at com.atlassian.jira.startup.JiraSystemInfo.obtainDatabaseStatistics(JiraSystemInfo.java:338)
at com.atlassian.jira.startup.JiraStartupLogger.printStartedMessage(JiraStartupLogger.java:126)
at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.printJIRAStartupMessage(ConsistencyCheckerImpl.java:200)
at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.initialise(ConsistencyCheckerImpl.java:184)
at com.atlassian.jira.startup.DefaultJiraLauncher.postDBActivated(DefaultJiraLauncher.java:166)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:146)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:301)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:196)
at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:137)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:104)
at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31)
at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:102)
at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:154)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT COUNT(U.ID) FROM cwd_user U (Table 'jiradb.cwd_user' doesn't exist)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533)
at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:881)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:861)
at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:799)
at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:779)
at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:1095)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCountByAnd(DefaultOfBizDelegator.java:382)
... 17 more
Caused by: java.sql.SQLSyntaxErrorException: Table 'jiradb.cwd_user' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:42)
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeQuery$5(DiagnosticPreparedStatement.java:59)
at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:69)
at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55)
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeQuery(DiagnosticPreparedStatement.java:59)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:527)
Then in browser I get
Referer URL: Unknown
java.lang.RuntimeException: java.nio.file.NoSuchFileException: /opt/atlassian-jira-software-8.13.1-standalone/atlassian-jira/import/startupdatabase.xml
java.lang.RuntimeException: java.nio.file.NoSuchFileException: /opt/atlassian-jira-software-8.13.1-standalone/atlassian-jira/import/startupdatabase.xml at com.atlassian.jira.startup.DatabaseInitialImporter.copyStartupXmlIntoHome(DatabaseInitialImporter.java:107) [classes/:?] at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:54) [classes/:?]
....
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.
For some reason tables in the database seem missing.
Table 'jiradb.cwd_user' doesn't exist
I came across a different thread here in Community where a user has trouble installing on a MySQL 8.
In case you are not missing permission in the database which could prevent creating the table in question it might be more a general thing going on.
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.
If this is a realistic option for you, I'd recommend it - to be honest.
The other user has his Jira up and running since he neglected the MySQL approach and installed on PostgreSQL.
This does not mean that this would be a "fix". Basically, MySQL should work and I have seen several instances in production lately running 5.7. Why there are reports around 8.0 is such a hassle while there is documentation about it and it is reported to work ("supported") is a riddle to me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thank you Daniel for your support ...
yeah ... I will try PostgreSQL.
Too many errors .. I just moved
startupdatabase.xml
to the expected location ... and I got a new generic error ... no log in the catalina.out .. so I am giving up with MySQL
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.