Could not connect to Database in Talend Data preparation

[Anonymous]

Dear folks,

Present I am working on Talend Data preparation  6.4.1 enterprise version.

I connected successfully to talend data preparation and import the local files successfully.

But at the time of connecting mysql, oracle databases I am facing connection error issue. I tried so many times but doesn't work. I am trying to connect my mysql server from my local machine through talend data preparation. The error shows like below

Kindly suggest how to resolve this issue.

Regards,

Rupesh.M

[Anonymous]

Hi Rupesh,

Few questions to start with:

• Can you confirm that the server on which Data Preparation is installed can resolve the hostname on which the DB is installed? Can you also confirm that your network rules allow connections from the Data Preparation server to the port 3306 on this host?
• Can you perform another test and attach the following log files:
  • app.log in dataprep/data/logs
  • components-service.log in dataprep/services/tcomp/logs

Thank you,

Gwendal

[Anonymous]

Hi gvaznunes,

Thanks for your reply.

As per your reply I am connecting MySQL successfully from my talend studio. But in talend data preparation it couldn't connect.

I am new in data preparation, please guide me how to connect databases from talend data preparation.

Talend data preparation was installed in my server machine and I am trying to connect database from my client machine. Is there any ports needed for open, please suggest me.

Please find my app.log file attachment.

app.log

[Anonymous]

Hi,

Talend Data Preparation (on your server machine) needs to access the database (on your client machine). So, can you try to open port 3306 (*) on your client machine and try again?

Thanks.

(*) Assuming you're running MySQL on default port.

[Anonymous]

Hi Sir,

3306 port is already opened in my client machine. Already connect to mysql successfully from talend studio at that time connection is established successfully. But in talend data preparation connection is not established. Please help me on this issue.

Regards,

Rupesh.M

[Anonymous]

Hi,

I think your MySQL is configured to allow only access from localhost (it doesn't allow connection from server machine *to* your client machine). See https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html (the part with "Host ... is not allowed to connect to this MySQL server").

You need to update / create a user allowed to connect from the server machine. See https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-my... for instance on how to create such a user.

[Anonymous]

Hi fhuaulme,

As per your instructions, I am trying to connect the localhost instead of ip address connection was successful.

But i am trying to connect MySql server with server IP address it shows connection refused error.

Please suggest me if any port is opened to connect mysql server or not.

Regards,

Rupesh. M