Troubleshooting password encryption - 7.1

Talend Real-time Big Data Platform Studio User Guide

Version
7.1
Language
English (United States)
Product
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development

If the Job fails, you may see error information like the following on the Run console:

Exception in component tDBInput_1 (EncryptPasswordWithR0T13Demo)
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
This error indicates that you have failed the authentication when trying to connect to the database. Check that:
  • You have the right user name/password for the database connection before encrypting the password using ROT13.
  • You have transformed the right encryption string from your real password using a custom routine.
  • You have correctly configured the database component to call the custom routine function.