MYSQL connection error

Six Stars

MYSQL connection error

Hi, everyone!
I got a talend 6.4.1 project that I colleague built it. So, I did the importation to my machine of his database and talend project, changed all the database settings, but then when I run the main job, it gives me a MYSQL connection error. So, the thing is, my colleague's mysql connection has password and mine didn't, so I decieded to create a user with password to see if the project would run, but still the same problem.

And it's funny that it gives me the same error, even thought i put a password.

Did anyone ever come accross this same problem?

Error:

Starting job JB_00_Main at 10:06 06/04/2018.
[statistics] connecting to socket on port 3867
[statistics] connected
Exception in component tMysqlOutput_1 (stg_01_ordens)
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at mop_veracel.stg_01_ordens_0_1.stg_01_ordens.tFileInputExcel_1Process(stg_01_ordens.java:758)
	at mop_veracel.stg_01_ordens_0_1.stg_01_ordens.runJobInTOS(stg_01_ordens.java:1873)
	at mop_veracel.stg_01_ordens_0_1.stg_01_ordens.runJob(stg_01_ordens.java:1735)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.tRunJob_1Process(JB_02_STAGE.java:1834)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJobInTOS(JB_02_STAGE.java:3786)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJob(JB_02_STAGE.java:3648)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.tRunJob_1Process(JB_00_Main.java:412)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.runJobInTOS(JB_00_Main.java:884)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.main(JB_00_Main.java:733)
Exception in component tRunJob_1 (JB_02_STAGE)
java.lang.RuntimeException: Child job running failed.
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at mop_veracel.stg_01_ordens_0_1.stg_01_ordens.tFileInputExcel_1Process(stg_01_ordens.java:758)
	at mop_veracel.stg_01_ordens_0_1.stg_01_ordens.runJobInTOS(stg_01_ordens.java:1873)
	at mop_veracel.stg_01_ordens_0_1.stg_01_ordens.runJob(stg_01_ordens.java:1735)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.tRunJob_1Process(JB_02_STAGE.java:1834)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJobInTOS(JB_02_STAGE.java:3786)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJob(JB_02_STAGE.java:3648)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.tRunJob_1Process(JB_00_Main.java:412)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.runJobInTOS(JB_00_Main.java:884)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.main(JB_00_Main.java:733)

	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.tRunJob_1Process(JB_02_STAGE.java:1851)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJobInTOS(JB_02_STAGE.java:3786)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJob(JB_02_STAGE.java:3648)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.tRunJob_1Process(JB_00_Main.java:412)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.runJobInTOS(JB_00_Main.java:884)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.main(JB_00_Main.java:733)
Exception in component tRunJob_1 (JB_00_Main)
java.lang.RuntimeException: Child job running failed.
java.lang.RuntimeException: Child job running failed.
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[statistics] disconnected
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at mop_veracel.stg_01_ordens_0_1.stg_01_ordens.tFileInputExcel_1Process(stg_01_ordens.java:758)
	at mop_veracel.stg_01_ordens_0_1.stg_01_ordens.runJobInTOS(stg_01_ordens.java:1873)
	at mop_veracel.stg_01_ordens_0_1.stg_01_ordens.runJob(stg_01_ordens.java:1735)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.tRunJob_1Process(JB_02_STAGE.java:1834)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJobInTOS(JB_02_STAGE.java:3786)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJob(JB_02_STAGE.java:3648)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.tRunJob_1Process(JB_00_Main.java:412)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.runJobInTOS(JB_00_Main.java:884)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.main(JB_00_Main.java:733)

	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.tRunJob_1Process(JB_02_STAGE.java:1851)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJobInTOS(JB_02_STAGE.java:3786)
	at mop_veracel.jb_02_stage_0_1.JB_02_STAGE.runJob(JB_02_STAGE.java:3648)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.tRunJob_1Process(JB_00_Main.java:412)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.runJobInTOS(JB_00_Main.java:884)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.main(JB_00_Main.java:733)

	at mop_veracel.jb_00_main_0_1.JB_00_Main.tRunJob_1Process(JB_00_Main.java:434)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.runJobInTOS(JB_00_Main.java:884)
	at mop_veracel.jb_00_main_0_1.JB_00_Main.main(JB_00_Main.java:733)

Thank you!


Accepted Solutions
Six Stars

Re: MYSQL connection error

Hi! I managed to fix the problem. So, aparently, when I edited the DB conection settings, Talend didn't propagate the information,specifically, my password, since the other information are the same as my colleague's. 

So, basically, I had to change all the DB conection settings of all the inputs and outputs from my DB.

As in the atacched png.


All Replies
Moderator

Re: MYSQL connection error

Hello,

Do your database passwords contain any period (.)? Are you able to connect your DB connection successsfully through client without using talend tool?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Forteen Stars

Re: MYSQL connection error

@isadoralmeida06,Could you please check the credentials and DB is up and running?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: MYSQL connection error

Hi @xdshi No, my passoword only conatins letters, numbers and special character ($,@, etc). Yes, I can access my database "mopveracel" without a problem in my localhst.
Also, when I go to edit connection in Talend and hit the check button, it says conection succed, it does not show any error.

Six Stars

Re: MYSQL connection error

Hi @manodwhb! So all the credentials are right, I can access my database through PHPMYADMIN and MYSQL workbench normally. When I check the DB connection in talend, it gives me the "success" message.
But when I run the job, it gives me the "using password: yes" error message.

Six Stars

Re: MYSQL connection error

Hi! I managed to fix the problem. So, aparently, when I edited the DB conection settings, Talend didn't propagate the information,specifically, my password, since the other information are the same as my colleague's. 

So, basically, I had to change all the DB conection settings of all the inputs and outputs from my DB.

As in the atacched png.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch