All Apps and Add-ons
Highlighted

com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: FATAL: no pg_hba.conf

Path Finder

I have Splunk DB Connect set up for postgress, but upon validate I get:

Error: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: FATAL: no pg_hba.conf entry for host "77.243.XX.YYY", user "musicbrainz", database "musicbrainz", SSL off

77.243.XX.YYY is the IP for the splunk server (single server) - and It seems Validate just ignores the value in "Host" and takes the IP for the localhost.....

The RPC is working and the driver located....

0 Karma
Highlighted

Re: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: FATAL: no pg_hba.conf

Path Finder

I misread the Error, the problem was that the Postgres did not allow connections. Changing pg_hba.conf solved it:

IPv4 local connections:

host all all 0.0.0.0/0 md5

0 Karma