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

[Mikhail Shitikov]

Hello.

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';
CREATE ROLE
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;
CREATE DATABASE
--------------- 

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.

Thanx

LOGS:

/var/atlassian/application-data/jira/log/atlassian-jira.log

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 10.101.1.8 /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 10.101.1.8 /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 10.101.1.8 /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 10.101.1.8 /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 10.101.1.8 /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 10.101.1.8 /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 10.101.1.8 /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 10.101.1.8 /secure/SetupLicense.jspa [c.a.jira.application.ApplicationConfigurationHelper] There are no writable directories to create the default group for the new license.

[Henri Volk [amily]]

Hi,

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

 Cheers

Henri

[Mikhail Shitikov]

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

Question:

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

Thanx

[Charles Pham]

Hi,

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