topic user access denied error in mysql connection in Talend Studio

user access denied error in mysql connection

Anonymous — Thu, 28 Jul 2016 07:59:41 GMT

Hi

I'm facing very bad situation in Mysql 5.7
I'm having username--> pop and password --> pop with database name "Home"
When I connect from workbench..its works fine.
When I connect through tmysqlinputconnection (adding manually credentials in component) it works.
Problem is, when I try to connect the tmysqlinputconnection with conext parameters where values are coming from file
Shows error like this-----> Access denied for user 'pop'@'localhost' (using password: YES)
May I know please from where its coming ...?
Thanks in advance !!

Re: user access denied error in mysql connection

Anonymous — Thu, 28 Jul 2016 08:09:45 GMT

If it works with hard-coded credentials but it does not work with context variables, then your context variables are not getting set correctly.
I'd try dumping them just before the MySQL connection, to see what is going on.
tContextDump->tLogRow
There are some instances where context does not get synchronized correctly, so it may be worth trying to call context.synchronizeContext() after loading your context to see if this makes a difference; but I'd try dumping the context first.

Re: user access denied error in mysql connection

Anonymous — Thu, 28 Jul 2016 08:30:20 GMT

I've just used that, all values are coming correctly through tcontextdump.
Any other suggestion please ?

Re: user access denied error in mysql connection

Anonymous — Thu, 28 Jul 2016 08:55:30 GMT

Did you try the synchronize?
Post some screenshots of your context dump and tMySQLConnection

Re: user access denied error in mysql connection

Anonymous — Thu, 28 Jul 2016 09:37:33 GMT

tfileinputdelimited(context parameter file)------>tcontextload
|
on sub job ok
|
tmysqlconnection

When I print variables, it comes perfectly ..

could you please tell me how to use context.synchronize()?

Re: user access denied error in mysql connection

Anonymous — Thu, 28 Jul 2016 11:09:48 GMT

Add a tJava before tMySQLConnection and insert the statement

Re: user access denied error in mysql connection

Anonymous — Thu, 28 Jul 2016 11:38:36 GMT

tfileinputdelimited(context parameter file)------>tcontextload
|
on sub job ok
|
tjava (context.synchronizeContext(); )
|
on sub job ok
|
tmysqlconnection

still same erro....

Re: user access denied error in mysql connection

Anonymous — Fri, 29 Jul 2016 07:02:55 GMT

I think you need to post the screenshots that I suggested

Re: user access denied error in mysql connection

jay6 — Fri, 17 Feb 2017 14:06:10 GMT

Hi,

I seem to be having the same issue as ashish123. I'm using Talend 6.2. I have a very similair job setup but without context parameters and am trying to connect to a remote DB.
Did anyone find a solution to the issue?

Thanks
Jay

Re: user access denied error in mysql connection

vapukov — Fri, 17 Feb 2017 23:16:02 GMT

jay_m wrote:
Hi,

I seem to be having the same issue as ashish123. I'm using Talend 6.2. I have a very similair job setup but without context parameters and am trying to connect to a remote DB.
Did anyone find a solution to the issue?

Thanks
Jay

There no errors - all work perfect
so the question sam as for ashish123 - please share pictures (and settings and error)

Re: user access denied error in mysql connection

jay6 — Mon, 20 Feb 2017 09:54:51 GMT

The only component in my job right now is tMyssqlConnection. No sense me completing the whole job not knowing it's going to work. Would be wasting my time.
For security reasons I've removed the user name and password in the error message.

Here is the error message. This is a remote connection to a remote DB on a different domain. I've also pasted a snapshot of the settings.
Starting job BSD_Test at 09:48 20/02/2017.

[statistics] connecting to socket on port 4050
[statistics] connected
Exception in component tMysqlConnection_1
java.sql.SQLException: Access denied for user 'user name and IP Address here' (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(NativeConstructorAccessorImpl.java:62)
[FATAL]: local.bsd_test_0_1.BSD_Test - tMysqlConnection_1 Access denied for user 'User name and IP Address' (using password: YES)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
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(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at local.bsd_test_0_1.BSD_Test.tMysqlConnection_1Process(BSD_Test.java:429)
at local.bsd_test_0_1.BSD_Test.runJobInTOS(BSD_Test.java:758)
at local.bsd_test_0_1.BSD_Test.main(BSD_Test.java:561)
2567 milliseconds
[statistics] disconnected
Job BSD_Test ended at 09:48 20/02/2017. [exit code=1]