All Apps and Add-ons

splunk DB connect - SSL error

VijaySrrie
Builder

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.

0 Karma
1 Solution

VijaySrrie
Builder

Hi,

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

View solution in original post

0 Karma

VijaySrrie
Builder

Hi,

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

0 Karma

VijaySrrie
Builder

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

0 Karma

VijaySrrie
Builder

Hi,

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

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

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

Get More Out of Your Security Practice With a SIEM

Get More Out of Your Security Practice With a SIEMWednesday, July 31, 2024  |  11AM PT / 2PM ETREGISTER ...