Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can't connect to Database connection pool server from application server

Raw Main
Contributor
March 11, 2020

We are using confluence Data Center edition now. Using database connection pool for PostgreSQL, named pgBouncer. It's running on a dedicated server.

  • Node1: confluence Data Center Application server
  • Node2: PostgreSQL connection pool - pgBouncer server
  • Node3: PostgreSQL Server

On Node2

The configuration for pbBouncer is:

pgbouncer.ini

[databases]
confluence = host=[Node3 IP] port=5432 dbname=confluence

[pgbouncer]
listen_port = 6432
listen_addr = 127.0.0.1, ::1
auth_type = md5
auth_file = userlist.txt
logfile = pgbouncer.log
pidfile = pgbouncer.pid
admin_users = someuser

userlist.txt

"someuser" "somepassword"

It can be connected on the server itself:

psql -p 6432 -h localhost -U postgres confluence

On Node1

{confluence_HOME}/confluence.cfg.xml

<property name="hibernate.connection.password">somepassword</property>
<property name="hibernate.connection.url">jdbc:postgresql://[Node2 IP]:6432/confluence</property>
<property name="hibernate.connection.username">someuser</property>

Can't connect to Node2's pgbouncer server. So can't connect to database. Both netstat checking on Node2 and telnet checking on Node1, and iptables checking didn't find any problem.
If connect to Node3 directly, it will work.

Is it something JDBC's issue? Or what's reason for that?

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, ai strategies, team productivity, teamwork collection, modern tech stack, ai for teams, collaboration tools, atlassian learning, workplace AI, team automation, leadership in tech, digital teamwork

The modern tech leader’s playbook for AI-powered teamwork

Join us to see how leading engineering teams are transforming workflows, accelerating delivery, and gaining a competitive edge with Teamwork Collection. Link to your Atlassian Community Event or Community Forums post

Register now
AUG Leaders

Upcoming Confluence Events