nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Which PostgreSQL username and password should be used to setup Service Desk?

Jason Freeman

We just purchased Service Desk, and we are now at the point of running through the beginning database-setup wizard (SetupDatabase.jspa).

We installed and setup PostgreSQL 9.6 according to this:

https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-postgresql-938846851.html

To create the user, I typed:

su - postgres
psql
CREATE USER jiradbuser;

To create the database:

CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;

To grant privileges:

GRANT ALL PRIVILEGES ON DATABASE jiradb TO jiradbuser;

I'm now at the database setup page. It's asking me for the following, and here is what I typed:

Database Type: PostgreSQL

Hostname: localhost

Port: 5432

Database: jiradb

Username: jiradbuser

Password: I've tried our root password and no password at all.

Schema: public

I always get the following error message:

FATAL: Ident authentication failed for user "jiradbuser"

The directions on that page made no mention of a password being set, so I don't even know which password I should be using.

Just for kicks, I then set a password on jiradbuser using this command:

ALTER USER jiradbuser WITH PASSWORD 'thepassword';

I then typed that new password in the database-setup wizard, and I still got the same error message:

FATAL: Ident authentication failed for user "jiradbuser"

Accepted answers

Thomas Deiler_db00h3

Dear @Jason Freeman,

you have to modify the postgreSQL configuration on the server.

Locate the file "pg_hba.conf" on localhost
change the line "host all all 127.0.0.1/32 ident" to

host all all 127.0.0.1/32 md5

save
restart postgreSQL
retry in JSD

So long

Thomas

All comments

Thomas Deiler_db00h3

Dear @Jason Freeman,

you have to modify the postgreSQL configuration on the server.

Locate the file "pg_hba.conf" on localhost
change the line "host all all 127.0.0.1/32 ident" to

host all all 127.0.0.1/32 md5

save
restart postgreSQL
retry in JSD

So long

Thomas

Jason Freeman

Thanks. That seems to have worked.

Is there any way the documentation could be updated? Specifically:

1. jiradbuser does need to have a password set. The documentation says nothing about setting a password. Yes, one could infer that a user needs a password, but I was trying to strictly follow the directions. I didn't know if there was something special happening where I did not need a password to be set on this account. Like with the other steps in the tutorial, I would even put a sample command

CREATE USER jiradbuser WITH PASSWORD 'yourPassword';

2. When you use the beginning setup wizard, the username and password that you use are the jiradbuser and its associated password that you set -- not a Linux or other user account.

3. The above change that you mentioned in pg_hba.conf needs to be done.

I think putting the above three items in the documentation would help people in the future who are setting up JIRA Service Desk or other JIRA product who are completely new to Atlassian products.

Thomas Deiler_db00h3

Dear @Jason Freeman,

am glad to here, that it worked. As I am a volunteer (like most of the Community Champions) and not working for Atlassian, I will forward your feedback to the right channel. But I cannot promise, that the article will be updated.

Btw: It is possible to configure PostgreSQL accepting users without passwords - but this is a little bit risky.

Please mark my reply as "Accept as solution", so that other readers can learn from this.

Many Thanks

Thomas

Jason Freeman

Thanks for the reply. Yours is accepted.

Yeah, I know that PostgreSQL can be setup without passwords, but will it still work with JIRA that way? The JIRA setup wizard requires a password.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-service-desk

database

error

install