Getting “LDAP authentication failed” when connecting to Vertica via JDBC
I'm trying to connect to a Vertica 7.1.1 database using DBeaver. I've downloaded the 7.1.2 JDBC driver (I couldn't find a 7.1.1 driver available for download) and configured DBeaver to use it.
When I try to connect via DBeaver I get this:
FATAL: LDAP authentication failed for user "my_username"
If I try connecting with an invalid username, I get a different error message:
FATAL: Invalid username or password
This confirms that I am reaching Vertica fine, but something is going wrong when I try to authenticate with my correct username.
I am able to connect to Vertica from the same host via vsql without issue.
I came across this post, which suggested that a Vertica setting may be the issue. However, we already have TLS_REQCERT allow set, as that post recommended.
What could be the issue here? Why would vsql work, but DBeaver not work from the same host?
(FYI: I originally asked this question on Stack Exchange.)