(Note: Question was edited as I was able to solve a side issue.)
I'm setting up Confluence (via web interface on localhost:8090) and I'm stuck at the step "Set up your database" which returns the following error:
Problem connecting to your database
SQLState - 28000
org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "confluence"
Here's how the database was set up:
[root@linuxbox ~]# postgresql-setup initdb
[root@linuxbox ~]# systemctl start postgresql
[root@linuxbox ~]# systemctl enable postgresql
[root@linuxbox ~]# passwd postgres
[root@linuxbox ~]# useradd confluence
[root@linuxbox ~]# su - postgres
[postgres@linuxbox ~]# psql -U postgres
postgres=# CREATE ROLE confluence WITH LOGIN;
postgres=# \password confluence
postgres=# \q
[root@linuxbox ~]# createdb -E utf8 -l C -T template0 confluencedb -O confluence
[root@linuxbox ~]# su - postgres
[postgres@linuxbox ~]# psql -U postgres
postgres=# GRANT ALL PRIVILEGES ON database confluencedb TO confluence;
The user "confluence" is able to connect to PostgreSQL by command line.
What's wrong? Thanks in advance if you can shed some light on this.
@[deleted]:D good that you are able to get confluence running!
Best!.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@[deleted]Please see documentation https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html on connecting confluence to Postgres, it should work if you are doing the right thing
Best!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, I've already read the documentation -- that's usually what I do before installing things. ;)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.