JIRA: Cannot add user, all the user directories are read-only.


I have installed JIRA Service Desk 7.3 on Centos 7, and I have External DB PostgreSQL 9.6, and on last step, where I choice name of Administrator, password (details for the administrator account for the installation. The account will be granted the JIRA system administrator permission.) and click next, I've got error: Cannot add user, all the user directories are read-only.

User name for DB: jiradbuser
DB name: jiradb

postgres=# CREATE USER jiradbuser WITH password 'password';
postgres=# CREATE DATABASE "jira"
postgres-# WITH OWNER = jiradb
postgres-# ENCODING = 'UTF8'
postgres-# TEMPLATE = 'template0'
postgres-# TABLESPACE = pg_default
postgres-# LC_COLLATE = 'ru_RU.UTF-8'
postgres-# LC_CTYPE = 'ru_RU.UTF-8'
postgres-# CONNECTION LIMIT = -1;

PostgreSQL 9.6 DB is configured with default configuration, like Confluence.

I did try make privileges for jiradbuser via pgAdmin, I gave superuser for this user and made restart of db, no way, I've got this error again, please help me, where and how to make this privileges.





Position: 407

 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)

 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)

 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)

 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)

 at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:4125)

 at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)

 at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)

 at net.java.ao.DatabaseProvider.getIndexes(DatabaseProvider.java:506)

 at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getUniqueFields(DatabaseMetaDataReaderImpl.java:178)

 ... 277 more

2017-01-28 23:43:53,193 http-nio-8080-exec-7 WARN anonymous 1423x7x1 e5z4dg /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Unknown import type for build number: 70100

2017-01-28 23:43:53,197 http-nio-8080-exec-7 WARN anonymous 1423x7x1 e5z4dg /secure/SetupDatabase!default.jspa [c.a.j.p.d.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !!

2017-01-28 23:43:53,200 http-nio-8080-exec-7 INFO anonymous 1423x7x1 e5z4dg /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.

2017-01-28 23:43:53,200 http-nio-8080-exec-7 ERROR anonymous 1423x7x1 e5z4dg /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter] 

2017-01-28 23:43:53,201 http-nio-8080-exec-7 ERROR anonymous 1423x7x1 e5z4dg /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter] Ошибка при импорте данных: java.lang.RuntimeException: Could not get unique fields for table 'AO_21D670_WHITELIST_RULES'

2017-01-28 23:43:59,348 http-nio-8080-exec-10 INFO anonymous 1423x10x1 e5z4dg /secure/SetupApplicationProperties.jspa [c.a.j.w.action.setup.SetupApplicationProperties] Re-indexing is 100% complete. Current index: 

2017-01-28 23:43:59,354 http-nio-8080-exec-10 INFO anonymous 1423x10x1 e5z4dg /secure/SetupApplicationProperties.jspa [c.a.j.issue.index.DefaultIndexManager] ReindexAll in foreground: {indexIssues=true, indexChangeHistory=true, indexComments=true, indexWorklogs=true, forceReloadFromDatabase=false}

2017-01-28 23:44:08,754 http-nio-8080-exec-14 WARN anonymous 1424x14x1 e5z4dg /secure/SetupLicense.jspa [c.a.jira.application.ApplicationConfigurationHelper] There are no writable directories to create the default group for the new license.

2 answers


I don't think 9.6 is a supported version and the issue is related to that, e.g. https://jira.atlassian.com/browse/CONF-44216 And https://jira.atlassian.com/browse/JRA-63696




Okay, in this case I want choose another kind of Set Up Jira app. After choosed method: My own database, I want change the way of configuration due failure DB compatibility PostgreSQL 9.6. But I can't going back to a first main menu where I could make new choice, without external DB or with another kind of DB (for example MySQL).

Everytime when I try open http://jira.my-company-domain.com:8080/ browser redirecting me to a page with continued configuration, which has been choiced in previous method http://jira.my-company-domain.com:8080/secure/SetupApplicationProperties!default.jspa


How to reset this tune and get first main menu, as default, like in a first once?



Take the following steps:

1) stop JIRA (if it's currently running)

2) Delete JIRA app directory

3) Delete JIRA home directory

4) Relaunch the JIRA installer  

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Wednesday in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

244 views 0 6
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you