tMySqlIput not able to connect to MySql server database

Six Stars

tMySqlIput not able to connect to MySql server database

 Hi,

 

We have mysql server on amazon EC2 and we are trying to run a job from another EC2 instance, when we try execute the job it is givng access denied issue. Can you please let me know what can be the possible cause. The job is taking all parameter for connectivity from context file. The issue is the job is taking the server context variable as localhost ip address instead of server. 

E.g. server host is aws-a0042-use1-1a-d-rds-xxx-xxxx-.xxx.us-east-1.rds.amazonaws.com

and I am executing the job from 10.2xx.x.x, then the job log shows

Exception in component tMysqlOutput_1 (JB_GENERATE_SRD_OUTPUT_FILE)
java.sql.SQLException: Access denied for user 'xxxxx'@'10.2xx.xx.xxx' 

In this log i see it is taking ip address of system from where we are executing instead of server ip address. 

 

I have tried modifying the values. Is there any setting on the system or mysql server or in talend job i am missing. Appreciate your quick help.


Accepted Solutions
Six Stars

Re: tMySqlIput not able to connect to MySql server database

Hi, 

Thanks for the reply. It was issue with the access for the user.


All Replies
Eight Stars

Re: tMySqlIput not able to connect to MySql server database

Can you post your (redacted) context? Also, can you connect to the database with a MySQL client? Finding out would help narrow down whether this is a Talend issue, or a credentials issue.

Six Stars

Re: tMySqlIput not able to connect to MySql server database

Hi, 

Thanks for the reply. It was issue with the access for the user.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download