Oracle Connector with Kerberos authentication fails

[morpheus]

Hi there,

does anyone have experience with the combination of Kerberos authentication and the oracle connector node?

The login to Kerberos is successful but enabling Kerberos authentication in the connector node returns the failure “ERROR Oracle Connector 3:21 Execute failed: ORA-01017: invalid username/password; logon denied”.

Are there specific settings in the Oracle Connector Node necessary?

Many thanks for any helpful reply.

BR
Hermann

[tobias.koetter]

Hi Hermann,
we haven’t tested this but according to the Oracle documentation it should work when you select Kerberos as authentication method in the Oracle connector node:

In addition you also need specify the following parameter in the JDBC Parameters tab:
oracle.net.authentication_services with value (KERBEROS5)

Once you have obtained a Kerberos ticket KNIME uses the Kerberos user in a doAs method to establish the connection as described in the connectWithSpecificUser() method in the Oracle documentation.

If you have problems obtaining a Kerberos ticket you can also enable the Kerberos logging in KNIME via the Kerberos preferences page:

Bye
Tobias

[morpheus]

Hi Tobias,
many thank for your reply. I test it immediately after return from my trip.

BR
Hermann

[morpheus]

Hi Tobias,

setting the JDBC Parameter solve the problem.
I never would be able to solve this issue by my own and I’m sure i am not alone.
I recommend to spend on the Community Mainpage a separate topic with examples for the various connection settings.

Many thanks and best regards.
Hermann

[tobias.koetter]

Hello Hermann,
I’m glad that it now works. I will add the information to the database documentation.
Bye
Tobias