Connection Issue with RDS MySql --Talend Job Running in Docker Container

jvineethunterai — Wed, 31 Jan 2024 16:44:30 GMT

Hello Talend Community,

I hope this message finds you well. I am currently facing an issue while running a Talend job inside a Docker container. The job connects to an RDS MySQL database, and it's working fine on EC2 Linux, but encounters issues when executed within a Docker container on the same EC2 machine.

The Dockerfile includes the following steps:

```Dockerfile
FROM ubuntu:latest

RUN apt-get update
RUN apt-get install openjdk-17-jdk -y

COPY Job_L4_Invoice_load_mysql_0.1.zip /usr/src/app/
COPY MySQLConnectionTest-0.0.1-SNAPSHOT-jar-with-dependencies.jar /usr/src/app/

WORKDIR /usr/src/app

RUN apt-get install -y coreutils unzip
RUN unzip /usr/src/app/Job_L4_Invoice_load_mysql_0.1.zip -d /usr/src/app/
RUN rm -rf /usr/src/app/Job_L4_Invoice_load_mysql_0.1.zip

CMD ["sh", "./Job_L4_Invoice_load_mysql/Job_L4_Invoice_load_mysql_run.sh"]

---------

However, when the job runs, it throws the following error related to MySQL connection:

java.sql.SQLException: Access denied for user 'vineet'@'172.31.18.166' (using password: YES)
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

=======================

I've confirmed that manually connecting from the Docker container to the RDS MySQL host works fine. Could you please assist me in resolving this issue? Are there any specific configurations or considerations I should take into account when running Talend jobs in Docker containers?

topic Connection Issue with RDS MySql --Talend Job Running in Docker Container in Talend Studio

Connection Issue with RDS MySql --Talend Job Running in Docker Container