Using SAS/ACCESS® Interface to Greenplum to connect to an SSL-enabled Greenplum database might result in an intermittent connection failure, similar to this:
libname mygp greenplm server="greenplum.server.com" port=5432 database="test" user="gpuser" password=XXXX
schema=public conopts="EncryptionMethod=1;ValidateServerCertificate=0";
ERROR: CLI error trying to establish connection: [SAS][ODBC Greenplum Wire Protocol driver]SSL Handshake
Failure reason [Unknown SSL Error].
ERROR: Error in the LIBNAME statement.
When the SSL handshake is performed, a lack of entropy might exist, causing the handshake to be delayed. That delay, in turn, causes the error.
To prevent this issue, do one of the following:
- Add the following statement in the CONOPTS= option in your LIBNAME statement:
libname mygp greenplm server="greenplum.server.com" port=5432 database="test" user="gpuser" password=XXXX schema=public
conopts="EncryptionMethod=1;ValidateServerCertificate=0;SeedBeforeConnect=1";
- In Linux and UNIX operating environments, add the following to your data source name (DSN) entry in the odbc.ini file:
[Greenplum_DB]
Driver=/sasinstall/AccessClients/9.4/Greenplum/lib/S0gplm27.so
Description=SAS ACCESS to Greenplum
...
SeedBeforeConnect=1
- Under Windows, modify your ODBC data source to look like this: