SAP Knowledge Base Article - Preview

2758294 - LDAP Authentication using ODBC - Error "[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;10 authentication failed"

Symptom

  • Testing an HANA ODBC connection with an LDAP user fails with the following error: 
KBA-LDAPpic.png
  • The validation of LDAP provider is successful: VALIDATE LDAP PROVIDER <provider_name> CHECK USER * PASSWORD 
  • The indexserver trace shows the following:
7404]{-1}[-1/-1] 2019-01-11 12:37:15.043297 d Authentication ManagerAcceptor.cpp(00361) : Method is applicable: SCRAMSHA256
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.043305 d Authentication ManagerAcceptor.cpp(00370) : evaluate was not successful for method: SCRAMSHA256
[57404]{-1}[50/-1] 2019-01-11 12:37:15.043662 d Authentication AuthenticationInfo.cpp(00039) : ENTER getAuthenticationInfo (userName=xxxxxxx)
[57404]{-1}[50/-1] 2019-01-11 12:37:15.043760 d Authentication Connection.cc(03178) : [AUTHENTICATION] logon name: xxxxxxx, external name: isldapenabled: 1
[57404]{-1}[50/-1] 2019-01-11 12:37:15.043769 d Authentication Connection.cc(04042) : [PRE AUTHENTICATION] logon name: xxxxxxx
[57404]{-1}[51/-1] 2019-01-11 12:37:15.045915 e Authentication catalog_authmgr.cc(00503) : Unexpected exception occurs in CatalogAuthMgr::invalidConnect: authentication failed
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.046038 d Authentication Connection.cc(03246) : exception during authentication: ERROR [SQL-10] authentication failed at ptime/query/catalog/catalog_authmgr.cc:927
exception 1: no.71000010 (ptime/query/catalog/catalog_authmgr.cc:927)
ptime::PtimeException
NO exception throw location recorded. Stack generation suppressed.
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414749 d Authentication ManagerAcceptor.cpp(00044) : Prepare authentication: adding available methods
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414767 d Authentication Manager.cpp(00115) : getMechs: provided mechanism=SPNEGO
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414769 d Authentication Manager.cpp(00115) : getMechs: provided mechanism=Kerberos 5
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414781 d Authentication ManagerAcceptor.cpp(00051) : Prepare authentication: added method GSS
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414787 d Authentication ManagerAcceptor.cpp(00051) : Prepare authentication: added method SAML
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414791 d Authentication ManagerAcceptor.cpp(00051) : Prepare authentication: added method SAPLogon
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414795 d Authentication ManagerAcceptor.cpp(00051) : Prepare authentication: added method JWT


Read more...

Environment

  • SAP HANA 1.0 
  • SAP HANA 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

LDAP Authentication using ODBC, LDAP, ODBC, CommonCryptoLib , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.