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

Mikhail Shitikov January 28, 2017

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.

2 answers

1 vote
Henri Volk _amily_ January 28, 2017

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

 

0 votes
Mikhail Shitikov May 21, 2017

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 May 29, 2017

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  

Like Vladimir Apanyuk likes this

Suggest an answer

Log in or Sign up to answer