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

This widget could not be displayed.

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

 

This widget could not be displayed.

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 Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

216 views 3 0
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