hi,
I have a the following cluster setup for my database:
HAproxy-> PGBouncer -> Postgresql.
db configuration in fusionauth.properties
database.url=jdbc:postgresql://10.10.1.1:4242/fusionauth
Error logs:
*2021-01-22 9:20:50.476 PM INFO com.inversoft.jdbc.hikari.DataSourceProvider - Connecting to PostgreSQL database at [jdbc:postgresql://10.10.1.1:4242/fusionauth]
2021-01-22 9:20:50.479 PM WARN com.zaxxer.hikari.HikariConfig - HikariPool-1 - idleTimeout has been set but has no effect because the pool is operating as a fixed size pool.
2021-01-22 9:20:50.480 PM INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
2021-01-22 9:20:50.512 PM ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
org.postgresql.util.PSQLException: The connection attempt failed.
Caused by: java.io.EOFException: null
at org.postgresql.core.PGStream.receiveChar(PGStream.java:372)
at org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:416)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:140)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:197)
... 298 common frames omitted*
Has someone managed to connect fusionauth through HAproxy?
Thank you!