MYSQL connection error

Anonymous — Fri, 06 Apr 2018 14:19:19 GMT

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!

Re: MYSQL connection error

Anonymous — Mon, 09 Apr 2018 03:37:22 GMT

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

Re: MYSQL connection error

manodwhb — Mon, 09 Apr 2018 07:02:53 GMT

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

Re: MYSQL connection error

Anonymous — Mon, 09 Apr 2018 15:15:00 GMT

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.

Re: MYSQL connection error

Anonymous — Mon, 09 Apr 2018 15:19:40 GMT

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.

Re: MYSQL connection error

Anonymous — Mon, 09 Apr 2018 19:17:24 GMT

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.

erro talend senha mysql.png

topic Re: MYSQL connection error in Talend Studio

MYSQL connection error

Re: MYSQL connection error

Re: MYSQL connection error

Re: MYSQL connection error

Re: MYSQL connection error

Re: MYSQL connection error