KERBEROS_CONFIG_CHECK
Tests the Kerberos configuration of a Vertica cluster. The function succeeds if it can kinit with both the keytab file and the current user's credential, and reports errors otherwise.
Syntax
KERBEROS_CONFIG_CHECK( )
Parameters
This function has no parameters.
Privileges
This function does not require privileges.
Examples
The following example shows the results when the Kerberos configuration is valid.
=> SELECT KERBEROS_CONFIG_CHECK(); kerberos_config_check ----------------------------------------------------------------------------- ok: krb5 exists at [/etc/krb5.conf] ok: Vertica Keytab file is set to [/etc/vertica.keytab] ok: Vertica Keytab file exists at [/etc/vertica.keytab] [INFO] KerberosCredentialCache [/tmp/vertica_D4/vertica450676899262134963.cc] Kerberos configuration parameters set in the database KerberosServiceName : [vertica] KerberosHostname : [data.hadoop.com] KerberosRealm : [EXAMPLE.COM] KerberosKeytabFile : [/etc/vertica.keytab] Vertica Principal: [vertica/data.hadoop.com@EXAMPLE.COM] [OK] Vertica can kinit using keytab file [OK] User [bob] has valid client authentication for kerberos principal [bob@EXAMPLE.COM]] (1 row)