Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

SQLState - 08001 org.postgresql.util.PSQLException: The connection attempt failed.

SQLState - 08001
org.postgresql.util.PSQLException: The connection attempt failed.

when we were installing confluence, we found the issue. 

i'm using the postgres paas service on Azure cloud.  

there is no problem for my jira, bitbucket jira service desk to connect the postgres. 

 

1 answer

0 votes
Daniel Ebers Community Leader Dec 28, 2020

Hi @adam_zhou_vanguard_com_cn

the error message is quite generic but from your explanation I only could guess the connection is not possible as for a problem with firewalling, user credentials, user permissions or some other setting preventing Confluence to onboard.

When you say other services just connect fine could you please compare what is different with them?

There must be a difference why the connection is not possible.

Please be advised that the database from the looks is not supported as per this Suggestion:
https://jira.atlassian.com/browse/CONFSERVER-55123

In case this is the database type you are using (managed PostgreSQL on Azure) it might be the source why it is not working. If it is working and that type applies to your installation it would mean the installation is unsupported (not receiving support from Atlassian).

On the other hand this might probably not apply at all because throughout the internet installation guides are to be found how Confluence can be installed on a Azure PostgreSQL hosting.

Please in first step compare settings.

Cheers,
Daniel

is this the correct answer?

 

https://community.atlassian.com/t5/Confluence-questions/postgresql-setup-connection-error/qaq-p/845498

 

i'm asking Azure support team to change the settings for us.

Daniel Ebers Community Leader Dec 28, 2020

These are mostly the settings for PostgreSQL. Here is some documentation on PostgreSQL setup for Jira:

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

we have no problem on installing jira connected to own db. 

we have problem on installing confluence connected to Azure postgres sql paas service.

Daniel Ebers Community Leader Dec 29, 2020

The link was intended as "further reading" or an extended reference on configuration - to work out from there but I understand this did not help.

Without having all the details of the configuration you see on Azure it will nearly be impossible to state from the outside what the problem might be.
I see you posted in the Suggestion which is good.

Apart from that I found information for Confluence Data Center which references PostgreSQL in Azure as backend - so the information seem to be contradict each other at the moment.
https://confluence.atlassian.com/enterprise/running-confluence-on-an-azure-cluster-969535580.html

In case you have a support entitlement, which is basically a valid Confluence license, you could ask support what the exactly state is.
https://support.atlassian.com/

This is because the current state is not clearly - there are contrary assumptions as to this DB type.

We checked with team experts, Azure experts...no result...it's your product bug! we fixed it by a wild guess... you'd better pay for our effort to fix the issue ... //cry     

Daniel Ebers Community Leader Dec 29, 2020

Glad you fixed it. In case you would like to share what you found out this would surely help others users facing the same issue.

Thanks in advance!

replace java postgres jdbc driver.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.8.3
TAGS
Community showcase
Published in Confluence Cloud

Get to know the Confluence team!

Go “behind the screen” to meet some of the Confluence Cloud team. In this video series, we tackle some of the hard-hitting questions you never knew you wanted the answer to!  Meet some of the ...

236 views 0 10
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you