sqlalchemy-teradata icon indicating copy to clipboard operation
sqlalchemy-teradata copied to clipboard

LDAP not working on Mac OSX

Open doronator-pge opened this issue 5 years ago • 0 comments
trafficstars

Using python 3.7, with sqlalchemy and teradatasqlalchemy installed as well, the following code does not produce an LDAP encrypted request. The connection is rejected with the following error:

sqlalchemy.exc.DatabaseError: (teradata.api.DatabaseError) (210, '[28000] [Teradata][ODBC Teradata Driver][Teradata Database] (210) The UserId, Password or Account is invalid. FailCode = -8017') (Background on this error at: http://sqlalche.me/e/4xp6)

From my DB administrator, I know that my connection attempts are registering as authentication=TD2, rather than authentication=LDAP

from sqlalchemy import create_engine

connection_str = 'teradatasql://{username}:{password}@{hostname}/authentication=LDAP'.format(
        hostname=hostname,
        username=username,
        password=password)

td_engine = create_engine(connection_str)

doronator-pge avatar Jun 04 '20 17:06 doronator-pge