How to import certificates for monitoring Postgres Server with SSL authentication?
Before adding a PostgreSQL server that requires SSL authentication, you must import the server's SSL certificates into the Applications Manager trust store (cacerts) to establish a secure connection. Attempting to add without import might give connection attempt failed error.
Solution:
To import certificates, login as admin user and follow the steps given below:
- Navigate to Settings tab --> under Tools section --> choose Manage Certificates.
- Click on the "Trust Certificates" sub tab. Here you have 3 options to import certificates into trusted sources.
- Choose the Certificate option --> Under Choose truststore, Select cacerts and upload required Server Certificate files.
Note:
- For CA-Signed Certificates: You only need to import the Server certificate only.
- For Self-Signed Certificates: You must import both the Server certificate and the Root certificate.
- Applications Manager supports .cer, .crt, and .der certificate file formats.
New to ADSelfService Plus?
Related Articles
How to import certificates for monitoring DB2 Server with SSL authentication?
By default, if you want to use self-signed certificates for SSL connection then the certificate generated by the DB2 server will be db2server.arm. But our AppManager doesn't support arm files. So it has to be renamed as the db2server.cer and then ...How to import certificates for monitoring Oracle database with SSL authentication?
For users using Applications Manager version 14250 and below: One-way SSL: (Client authentication disabled) 1. Open the command prompt using 'Run as administrator' option and navigate to the Applications Manager installation directory. 2. Import your ...Import Certificates for MariaDB/MySQL Monitoring with SSL
Secure connections between Applications Manager and MySQL/MariaDB servers require SSL/TLS certificates to encrypt communication and optionally verify the server and client identities. By following this guide, users will learn how to generate, ...How to import certificates for monitoring MariaDB/MySQL DB Server with SSL authentication?
For MariaDB Server Go to AppManager UI --> Settings --> Manage Certificates --> Trust Certificates --> Keystore/Truststore --> Select cacerts Restart Applications Manager to verify SSL connectivity while using the MariaDB monitor. For MySQL DB Server ...How to import certificates for monitoring Websphere Application Server with SSL authentication?
For users using Applications Manager version 14250 and below: Client certificate in .cer format 1. Open the command prompt using 'Run as administrator' option and navigate to the Applications Manager installation directory. 2. Import your trusted CA ...