This document is under revision.
Summary
Question
We are attempting to use the LDAP_LINK_DRYRUN_CONNECT function to test LDAP connectivity to a second LDAP server that is going to be temporarily required. We are first testing usability of the function using known working parameters from our existing LDAP connection, and the function fails with error:
SQL Error [9345] [0A000]: [Vertica][VJDBC](9345) ERROR: Dry Run Connect Failed!
No other reasons given. We are using the following function call. Server and password are masked, otherwise all is accurate. Again, these parameters are exactly what is specified for our LDAP Authentication setup which works without issue. Can you let us know if we are using the function correctly? Putting urgency as high for now as this is needed for a critical project due next week. Thank you.
SELECT LDAP_LINK_DRYRUN_CONNECT('ldaps://server.company.com','CN=svc3usigusername,OU=3 Batch Service Accounts,OU=Batch Service Accounts,OU=MFG_Applications,DC=na,DC=mmfg,DC=net','xxxxxxxx',1,'allow','/etc/pki/tls/certs/ca-bundle.crt');
.
SQL Error [9345] [0A000]: [Vertica][VJDBC](9345) ERROR: Dry Run Connect Failed!
Answer