Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

521 views 1 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you