Skip to main content

LDAP authentication failed while connecting thru Squirrel (querying tool)

  • June 8, 2016
  • 0 replies
  • 8 views

arathnas

 

Hello - Last week we have encounter a power outage issue and vertica cluster has been abnormally went down. We have restarted vertica .. now every thing is looks normal.. up and running.. however some of user are encounter LDAP authentication failed while connecting thru Squirrel (querying tool). here is the error following is the error msg.
 
 
Environment - 
Vertica - Vertica Analytic Database v7.1.2-7
running on Linux - Linux 2.6.32-573.22.1.el6.x86_64 x86_64
 
Error msg -
 

I get java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLInvalidAuthorizationSpecException: [Vertica][VJDBC](3846) FATAL: LDAP authentication failed for user "skaraiva"
  at java.util.concurrent.FutureTask.report(FutureTask.java:122)
  at java.util.concurrent.FutureTask.get(FutureTask.java:202)
  at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
  at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
  at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
  at java.util.concurrent.FutureTask.run(FutureTask.java:262)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: java.sql.SQLInvalidAuthorizationSpecException: [Vertica][VJDBC](3846) FATAL: LDAP authentication failed for user "skaraiva"

 

 

 

Much appreciate early response. 

 

Regards,

Arathnas