Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
I am new to this and I have been looking for a tool that will help me with data integration.
I have found this WONDERFUL TOOL that I am willing to work with and understand it at the top and make it my personal DB tool
I want to understand it better and I have a project that I want to be able to accomplish with this tool.
The idea is to be able to take tables from one server - IP 10.0.0.214 and Store then (Upgrade DB) on a newer server 10.0.0.100
I am working from Windows Desktop and I am willing to work with TWO CentOS Linux Servers.
I am trying to connect to the Server using root and password - I am getting error since it changes the root to root@10.0.0.197 and not the one I am using on the Remote server.
I can NOT use localhost since it will add the same as well.
I have tried using the Server IP and I am getting errors all the time.
So I have created a user on the remote Linux server and called it arye@10.0.0.197 and gave it all the privileges using PhpMyAdmin.
When I try to connect I am getting Errors that user can NOT connect with Or without password - Every time when I check the connection I am getting Errors
Can you please let me know why? and How do I connect to a REMOTE LINUX server to have a job that will update data from Old server to new server.
I really think that this would be the tool that I will work with from now on and I have seen tutorials and realized that this is the tool for me - Also, In all of the tutorials I have seen that CONNECTION were created with root and localhost - Assuming that th MySQL server is resident on the same PC where the Talend solution is installed.
I would be happy to make two connections to the databases on both of my servers and upgrade from Old to new with one job - that would be great!!!!
Please assist me with HOW to make that happened.
Thank you so much in advance.
Arye
I am new to this and I have been looking for a tool that will help me with data integration.
I have found this WONDERFUL TOOL that I am willing to work with and understand it at the top and make it my personal DB tool
I want to understand it better and I have a project that I want to be able to accomplish with this tool.
The idea is to be able to take tables from one server - IP 10.0.0.214 and Store then (Upgrade DB) on a newer server 10.0.0.100
I am working from Windows Desktop and I am willing to work with TWO CentOS Linux Servers.
I am trying to connect to the Server using root and password - I am getting error since it changes the root to root@10.0.0.197 and not the one I am using on the Remote server.
I can NOT use localhost since it will add the same as well.
I have tried using the Server IP and I am getting errors all the time.
So I have created a user on the remote Linux server and called it arye@10.0.0.197 and gave it all the privileges using PhpMyAdmin.
When I try to connect I am getting Errors that user can NOT connect with Or without password - Every time when I check the connection I am getting Errors
Can you please let me know why? and How do I connect to a REMOTE LINUX server to have a job that will update data from Old server to new server.
I really think that this would be the tool that I will work with from now on and I have seen tutorials and realized that this is the tool for me
- Also, In all of the tutorials I have seen that CONNECTION were created with root and localhost - Assuming that th MySQL server is resident on the same PC where the Talend solution is installed.
I would be happy to make two connections to the databases on both of my servers and upgrade from Old to new with one job - that would be great!!!!
Please assist me with HOW to make that happened.
Thank you so much in advance.
Arye
Hi arye,
Thanks for posting your issue here.
Do you want to set up DB connection between 2 servers?
Have you already checked online document about: TalendHelpCenter
etting up a database connection?
Best regards
Sabrina
Thanks for posting your issue here.
Do you want to set up DB connection between 2 servers?
Have you already checked online document about: TalendHelpCenter
etting up a database connection?
Best regards
Sabrina
Here is a screen of what I am trying to do:
Thank you Sabrina!
Yes I can Ping it Successfully
No problem accessing 10.0.0.100 from 10.0.0.197.
When using localhost it will be like I am trying to connect MY PC (10.0.0.197) and Not a remote PC.
I have made the change just in case you will be able to see something in the result I got:
I do not have that database on my PC and I want to connect a remote Linux PC - that is whay I think setting "localhost" will not serve the propose.
Please assist,
Thank You.
Yes I can Ping it Successfully
Pinging 10.0.0.100 with 32 bytes of data:
Reply from 10.0.0.100: bytes=32 time=1ms TTL=64
Reply from 10.0.0.100: bytes=32 time<1ms TTL=64
Reply from 10.0.0.100: bytes=32 time<1ms TTL=64
Reply from 10.0.0.100: bytes=32 time<1ms TTL=64
Ping statistics for 10.0.0.100:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 1ms, Average = 0ms
No problem accessing 10.0.0.100 from 10.0.0.197.
When using localhost it will be like I am trying to connect MY PC (10.0.0.197) and Not a remote PC.
I have made the change just in case you will be able to see something in the result I got:
Connection failure. You must change the Database Settings.
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.
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:164)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1078)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:313)
at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:272)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$30.runWithCancel(DatabaseForm.java:2513)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$30.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: 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.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1127)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:356)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2502)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:155)
... 9 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:315)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:306)
... 22 more
I do not have that database on my PC and I want to connect a remote Linux PC - that is whay I think setting "localhost" will not serve the propose.
Please assist,
Thank You.