splunk DB connect - SSL error

[vijaysri]

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.

[vijaysri · Accepted solution]

Hi,

If above method is not working, just add the lines ?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
along with jdbcurl while creating connection.

[vijaysri]

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

[vijaysri]

Hi,

If above method is not working, just add the lines ?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
along with jdbcurl while creating connection.