Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Jira 8.13.1 - Cannot add user, all the user directories are read-only.


Installing form

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 ? 


2 answers

0 votes
Daniel Ebers Community Leader Nov 15, 2020

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.


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(
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCountByAnd(
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCount(
at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.getCount(
at com.atlassian.jira.startup.JiraSystemInfo.obtainDatabaseStatistics(
at com.atlassian.jira.startup.JiraStartupLogger.printStartedMessage(
at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.printJIRAStartupMessage(
at com.atlassian.jira.upgrade.ConsistencyCheckerImpl.initialise(
at com.atlassian.jira.startup.DefaultJiraLauncher.postDBActivated(
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(
at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(
at com.atlassian.jira.startup.DefaultJiraLauncher.start(
at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(
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(
at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(
at org.ofbiz.core.entity.GenericDAO.selectByCondition(
at org.ofbiz.core.entity.GenericDAO.selectByCondition(
at org.ofbiz.core.entity.GenericDelegator.findByCondition(
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.getCountByAnd(
... 17 more
Caused by: java.sql.SQLSyntaxErrorException: Table 'jiradb.cwd_user' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(
at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeQuery(
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeQuery$5(
at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(
at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(
at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeQuery(
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(


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( [classes/:?]
 at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData( [classes/:?]



errors are hard to follow ... 


Daniel Ebers Community Leader Nov 17, 2020

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.

I guess I am going to try PostgreSQL ... 

Daniel Ebers Community Leader Nov 17, 2020

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.

thank you Daniel for your support ... 

yeah ... I will try PostgreSQL. 


Too many errors .. I just moved 


to the expected location ... and I got a new generic error ... no log in the catalina.out .. so I am giving up with MySQL 


not resolved

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events