topic Re: Could not connect to Database in Talend Data preparation in Data Quality

Could not connect to Database in Talend Data preparation

Anonymous — Sat, 16 Nov 2024 08:07:40 GMT

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

Re: Could not connect to Database in Talend Data preparation

Anonymous — Mon, 11 Jun 2018 08:13:18 GMT

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

Re: Could not connect to Database in Talend Data preparation

Anonymous — Mon, 11 Jun 2018 10:41:06 GMT

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

Re: Could not connect to Database in Talend Data preparation

Anonymous — Mon, 11 Jun 2018 10:45:29 GMT

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.

Re: Could not connect to Database in Talend Data preparation

Anonymous — Mon, 11 Jun 2018 11:24:23 GMT

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

Re: Could not connect to Database in Talend Data preparation

Anonymous — Mon, 11 Jun 2018 12:33:25 GMT

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-mysql-server for instance on how to create such a user.

Re: Could not connect to Database in Talend Data preparation

Anonymous — Wed, 13 Jun 2018 05:50:22 GMT

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