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

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

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

 

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

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  

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,308 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot