Spring Boot Connecting database using SSL Certificate

Question

I need to connect to postgresql using SSL Certificate from spring boot application. I have got the certificate and currently i am connecting to db using username and password which i have provided in application.yml file.

Can someone point me to the right tutorial? I could not find anything relevant for spring boot ssl database connection.

Helpful? Chapter 4. Using SSL

LHCHIN
– LHCHIN

2019-10-24 01:28:41 +00:00
Commented Oct 24, 2019 at 1:28 — LHCHIN
– LHCHIN, Commented Oct 24, 2019 at 1:28

Shailesh Chandra · Accepted Answer · 2019-10-24 04:45:02Z

6

you need to append below in URL

&sslmode=verify-full&sslrootcert=/path/to/pemfile

Your URL will look something like

jdbc:postgresql://server:5432/databaseName?currentSchema=dbschema
    &sslmode=verify-full&sslrootcert=/home/certificates/mycert.pem

you can refer below URLs

https://jdbc.postgresql.org/documentation/head/connect.html#ssl

https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL

answered Oct 24, 2019 at 4:45

Shailesh Chandra

2,3402 gold badges20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring Boot Connecting database using SSL Certificate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related