-
Title
How to import certificates when getting a connection error that there are no certificates -
Description
If we monitor the database in SSL mode, we must import the certificate of the database server into the keystore,
What are the steps required to import certificates for the following monitored platforms?
- Sybase
- DB2
- SQL Server
- Azure SQL
- WinRM/VMWare
- Oracle
-
Resolution
Monitored platforms
For steps to add import certificates for monitoring the following platforms, please refer to the following KB articles:
Sybase 326649
DB2 326650
SQL Server 326651
Oracle 326652
Azure SQL 326653
WinRM/VMWare 326654
SQL Server PI Repository
Steps to add a certificate for importing a certificate for a Foglight Agent Manager to connect to a SQL Server PI repository are detailed in KB 326655
Instructions: Embedded certificate in the Foglight database
The fogdb store has built-in some common root CA certificates, it comes from the JAVA default Keystore (cacerts) and AWS (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html). With these built-in certificates, when we monitor some databases (Azure DB, Managed Instance, RDS, on-premise databases with CA certificates) we no longer need to import certificates.
-
Defect ID
FOM-182