N
N
Nikolay Baranenko2018-04-01 22:03:30
Python
Nikolay Baranenko, 2018-04-01 22:03:30

What parameter is responsible for changing the Login mechanism (internal User and LDAP user)?

Hello.
wrote a Python client to connect to Teradata

import jaydebeapi

USERNAME="user01"
PASSWORD="password01"
URL_CONNECTION="jdbc:teradata://server01/"
jars=['E:\\jdbc\\tdgssconfig.jar','E:\\jdbc\\terajdbc4.jar']

conn = jaydebeapi.connect('com.teradata.jdbc.TeraDriver', URL_CONNECTION,[USERNAME,PASSWORD], jars)

Everything works great if I use internal users, but if I try an LDAP user, an error is returned
jpype._jexception.SQLExceptionPyRaisable: java.sql.SQLException: [Teradata Database] [TeraJDBC 16.10.00.07] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.

How to change the Login mechanism for LDAP users?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
gp_by, 2018-08-26
@gp_by

To use LDAP authentication, specify in the connection string
To return to using the internal mechanism, specify

URL_CONNECTION="jdbc:teradata://server01/LOGMECH=TD2"

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question