Troubleshooting password encryption - 7.2

Talend ESB Studio User Guide

EnrichVersion
7.2
EnrichProdName
Talend ESB
EnrichPlatform
Talend Studio
task
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.