All Apps and Add-ons

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

moseisleydk
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

moseisleydk
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
Get Updates on the Splunk Community!

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Combine Multiline Logs into a Single Event with SOCK: a Step-by-Step Guide for ...

Combine multiline logs into a single event with SOCK - a step-by-step guide for newbies Olga Malita The ...