Forum Discussion
NimbostratusPostgreSQL Monitor - but I need to connect with SSL
Hello,
I'm trying to setup an monitor on an 11.5 system, but its mandated that the connection has to be SSL enabled. I've taken packet captures and looked at the logs on the PostgreSQL node and can see the connection coming in, unfortunately they don't use SSL. Having hunted around the UI and 'Google' I thought I'd post a question here to the community?
Your help is much appreciated.
2 Replies
rob_carrCirrocumulus
You have an impasse: you must use SSL in your monitor (by policy), but the host to be monitored doesn't implement SSL. You can either go for a policy variance or reconfigure the postgreSQL host.
Christian_Herr_In the monitor configuration, add "?ssl=true" to the end of the database field:
Database: postgres?ssl=true
If it's self-signed:
Database: postgres?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
