Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-04-06 10:19 AM

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!

Labels (4)
Labels
832 Views
0 Likes
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2018-04-09 03:17 PM
Author

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

View solution in original post

832 Views
0 Likes
5 Replies
Anonymous
Not applicable
‎2018-04-08 11:37 PM
Author

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

832 Views
0 Likes
manodwhb
Champion II
Champion II
‎2018-04-09 03:02 AM

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

832 Views
0 Likes
Anonymous
Not applicable
‎2018-04-09 11:15 AM
Author

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.

832 Views
0 Likes
Anonymous
Not applicable
‎2018-04-09 11:19 AM
Author

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.

832 Views
0 Likes
Anonymous
Not applicable
‎2018-04-09 03:17 PM
Author

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
833 Views
0 Likes