To use Kerberos authentication to connect to Greenplum, you need to set the required environment variables on the Secure Agent machine.

Run the following commands to set the environment variables:

setenv KRB5CCNAME <Absolute path and file name of the credentials cache file>
setenv KRB5_CONFIG <Absolute path of the Kerberos configuration file>\krb5.conf
setenv JAASCONFIG <Absolute path of the JAAS config file>\<File name>.conf

After you set the environmental variables, you need to restart the Secure Agent.

Alternatively, you can add the

KRB5_CONFIG

and

JAASCONFIG

environment variables when you create a Greenplum connection.

To add the environment variables when you configure a connection with Kerberos authentication, you need to add the

KRB5_CONFIG

and

JAASCONFIG

properties in the

Kerberos Connection Properties

field in a Greenplum connection.

For example, add the properties in the following format:

KRB5_CONFIG=<Absolute path of the Kerberos configuration file>\krb5.conf;JAASCONFIG=<Absolute path of the JAAS config file>\<File name>.conf