You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-03-14 15:40:36

jay_m
Member
14 posts

jay_m said:

MySQL Connections

Hello,

I've been scratching my head trying to figure out how to connect to a different instance (connection) in MySQL and any search/help was fruitless. 
I have several Connections in MySQL, several internal and some external. Instead of recreating these connection in Talend I want to be able to connect directly to a particular connection. As an example I have
Local instance MySQL57
BSD (This is an external database)
SDB (This is another internal database)

I want to setup a metadata connection for BSD. How can I do that? 
I am trying to overcome a basic issue with the tmysqlconnection component. It gives me an error (Connection failure. You must change the Database Settings. java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'xyz'@'IP Address here' (using password: YES)) when I try setup the connection directly in Talend however I'm still able to connect using MySQL connection and query the database tables. I have tried many different ways to get this working but none of them have worked so far and I'm reluctant to go back to the external company to ask them to make a change that might cause a security issue due to the sensitive nature of the data.

Thanks
Jay

Offline

#2 2017-03-14 23:33:32

vapukov
Member
470 posts

vapukov said:

Re: MySQL Connections

Not sure - what Your try to do globally,
If I correct understand You - You can create single DB connection (Left side of screen - Metadata) and define it as context based
than create as many context environment as You want 

about error

Access denied for user 'xyz'@'IP Address here' (using password: YES))

it very clean - check the user permission. How Your user (which You use to connect from Talend) defined in database:

  • check password

  • check allowed hosts

  • try to connect with same user from Talend Machine with mysql command line client and see what happens

Offline

#3 2017-03-16 12:38:52

jay_m
Member
14 posts

jay_m said:

Re: MySQL Connections

Thanks vapukov. You are partly correct in understanding what I want to do. I've created a single DB connection in Metadata but now get a different error message when I use the connection for BSD:
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

How is it that I can connect successfully to this external database using MySQL but not the component when I am referencing this same connection in the component?

Jay

Offline

#4 2017-03-16 13:07:49

vapukov
Member
470 posts

vapukov said:

Re: MySQL Connections

without pictures - we can only guess what are You make wrong
it common error - I do all same, but have error only there!!! smile
in fact it mean - something difference in settings. Compare Your MySQL client (as I can guess MySQL Workbench) and Talend settings
as example - MySQL Workbench could connect over ssh tunnel ...
I just can confirm - it work!
mini_Screen_Shot_2017-03-17_at_1.04.52_AM.png.png  mini_Screen_Shot_2017-03-17_at_1.05.06_AM.png.png

Offline

#5 2017-04-08 00:50:42

cacak
Member
9 posts

cacak said:

Re: MySQL Connections

vapukov wrote:

without pictures - we can only guess what are You make wrong
it common error - I do all same, but have error only there!!! smile
in fact it mean - something difference in settings. Compare Your MySQL client (as I can guess MySQL Workbench) and Talend settings
as example - MySQL Workbench could connect over ssh tunnel ...
I just can confirm - it work!

Are your MySql connection use SSH?
I have a problem to connect to MySql with SSH, i dont know about the command on tSSH or tSystem.

Can you tell me?

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy