topic Access Denied for Access Database when using built job in Talend Studio

Access Denied for Access Database when using built job

ghensan — Sat, 16 Nov 2024 01:41:49 GMT

Hello everyone, i have a pickle here when using talend data integration

i use Talend 7.3.1 and MySQL 8

when i built the Job and run it on server via Jenkins, it always said

Exception in component tDBOutput_3 (********)

java.sql.SQLException: Access denied for user '******'@'********' (using password: YES)

the funny thing is, i of course try it first on my local machine

test connection always return OK, and also when i test run it, it always work just fine, and it also write and read from DB just fine

it just Error when i try to run the built Job

anyone have clue why and how to fix it ?

Re: Access Denied for Access Database when using built job

JohnRMK — Wed, 12 Aug 2020 08:31:09 GMT

Hello,

I believe it is an SSL or TLS issue. I am not sure of the exact terms but it is related to security. Otherwise it can come from user rights. If in Jenkins you use the user windows known from the DBMS and in talend you use a named user. You can search in stackoverflow, I have already seen this error

Re: Access Denied for Access Database when using built job

Anonymous — Wed, 12 Aug 2020 08:35:41 GMT

Go to check if your Mysql server allows remote access.

Regards

Shong