Validate Server Certificate
- Last Updated: May 21, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Greenplum 8.0
- Documentation
Validate Server Certificate
Attribute
ValidateServerCertificate (VSC)
Purpose
Determines whether the driver validates the certificate that is sent by the
database server when SSL encryption is enabled (EncryptionMethod=1). When
using SSL server authentication, any certificate sent by the server must be issued by a
trusted Certificate Authority (CA). Allowing the driver to trust any certificate returned
from the server even if the issuer is not a trusted CA is useful in test environments
because it eliminates the need to specify truststore information on each client in the test
environment.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the driver validates the
certificate that is sent by the database server. Any certificate from the server must be
issued by a trusted CA in the truststore file. If the Host Name In Certificate option is
specified, the driver also validates the certificate using a host name. The Host Name In
Certificate (HostNameInCertificate) option provides additional security against
man-in-the-middle (MITM) attacks by ensuring that the server the driver is connecting to is
the server that was requested.
If set to 0 (Disabled), the driver does not
validate the certificate that is sent by the database server. The driver ignores any
truststore information specified by the Trust Store and Trust Store Password options.
Notes
- Truststore information is specified using the Trust Store (Truststore) and Truststore Password (TruststorePassword) options.
Default
1 (Enabled)