Troubleshooting password encryption - 7.1

Talend Big Data Studio User Guide

Version
7.1
Language
English (United States)
Product
Talend Big Data
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.