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

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

Unale to setup bitbucket server with Postgres Edited

Hi,

I am trying to setup Bitbucket with PostGres.

Unfortunately, I have a connection error at the beginning

"""

The configuration entered is not valid. A database connection could not be established. Please check your configuration and try again.
	com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:217)
	com.atlassian.stash.internal.db.DefaultDatabaseManager.prepareDatabase(DefaultDatabaseManager.java:183)
	com.atlassian.stash.internal.maintenance.SpringMaintenanceTaskFactory.setupTask(SpringMaintenanceTaskFactory.java:151)
	...
Failed to obtain JDBC Connection; nested exception is org.postgresql.util.PSQLException: Connection to 192.168.1.29:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
	com.atlassian.stash.internal.db.DefaultDatabaseValidator.validate(DefaultDatabaseValidator.java:43)
	com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:214)
	...
Connection to 192.168.1.29:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	org.postgresql.Driver$ConnectThread.getResult(Driver.java:405)
	org.postgresql.Driver.connect(Driver.java:263)
	java.sql.DriverManager.getConnection(DriverManager.java:664)
"""

I am installing Bitbucket Server (7.3) (via Docker) under MacOs.
I have followed the step for PostGres installation. PostGres is fine (I can manage it with pgAdmin)
I am new to PostGres and Docker.
Thanks for your help

1 answer

1 accepted

2 votes
Answer accepted
Alexis Robert Community Leader Jun 09, 2020

Hi @MARTIN_Régis , 

 

the error is because of connectivity issues to your database : 

Connection to 192.168.1.29:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

There is probably a setting to change in pg_hba.conf as explained here in the paragraph Create the Bitbucket Server database : https://confluence.atlassian.com/bitbucketserver/connecting-bitbucket-server-to-postgresql-776640389.html

This specific KB explains what to do : https://confluence.atlassian.com/bitbucketserverkb/bitbucket-is-unable-to-connect-to-postgresql-due-to-unconfigured-pg_hba-conf-file-969533185.html

 

Let me know if this helps, 

 

--Alexis

Thanks for your help.

It is indeed, a connectivity issue, which is solved by using host.docker.internal a hostname.

See https://stackoverflow.com/questions/24319662/from-inside-of-a-docker-container-how-do-i-connect-to-the-localhost-of-the-mach 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Posted in Bitbucket

Share your use cases: How do you use the Bitbucket-Jira integration? How does it help your team?

Hey everyone, over the past year, we've added several new features to how you can use Bitbucket and Jira together. We'd love to know how you'll are using the integration and how it's helping your tea...

44 views 0 1
Join discussion

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