Hi Team,
Tried to pull postgresql data into splunk db connect --> Customer has enabled SSL at their end --> If they disable the SSL it is working --> But customer wants SSL to be enabled .
We have an option in Splunk DB connect --> Enable SSL (if I check this box) --> While trying to create Input (it is showing Invalid database connection)
What Should I do to enable SSL from splunk DB connect.
Hi,
If above method is not working, just add the lines ?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
along with jdbcurl while creating connection.
Hi,
If above method is not working, just add the lines ?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
along with jdbcurl while creating connection.
This is for postgreSQL.
Tried the below:
In dbx/local/database_types.conf
placed
[postgresqlssl]
displayName = PostgreSQL with SSL
jdbcDriverClass = org.postgresql.Driver
defaultPort = 5432
connectionUrlFormat = jdbc:postgresql://{0}:{1}/{2}?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
testQuery = SELECT 1 AS test
defaultCatalogName = postgres
defaultSchema = public
but it didn't work
Hi,
If above method is not working, just add the lines ?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
along with jdbcurl while creating connection.
Hi,
I was got this issue also, direct access is able to connect but with splunk invalid error, even after add pg_hba.conf
FATAL: no pg_hba.conf entry for host "10.24.154.215", user "AMDSPLUNK", database "IOU", SSL on
Actually the issue it was because drivers compatibility, in this case we can try bellow drivers :
1. Splunk DBX Add-on for Postgres JDBC | Splunkbase -> Add on, works for me
2. About the JDBC Driver for Postgres - Splunk Documentation -> With .jar file, not works, but in other environment its work.
You can try it, hopefully will help