Problems setting a Mysql database connection

One Star

Problems setting a Mysql database connection

When trying to create a new dbconnection to a MySql database I get this error message
Connection failure. You must change the Database Settings.
I can ping the server where the database is located and I can see the database using phpmyadmin with the same settings I use in the dbconnection.
I should also say that I'm a rookie in this subject.
Thank you very much for any assistance with this problem
Employee

Re: Problems setting a Mysql database connection

Hi,
In the Modules view (next to the Run Job view), you can check what perl modules you have installed.
Check if modules DBI and DBD:mysql are correctly installed.
For more information about Talend Open Studio installation : see the installation guide.
Regards.
One Star

Re: Problems setting a Mysql database connection

Thanks for your quick reply
the two modules DBI and DBD seems to be installed correctly.
I don't have any problems connecting to a local Mysql database.
thanks again
Employee

Re: Problems setting a Mysql database connection

Hello,
Do you still have a problem to connect to your mysql db ?
I think you mean that you can connect to a local mysql db but not to a remote one with Talend but it works with phpmyadmin, is that right ?
If yes, could you post a screen capture of your db connection wizard ?
One Star

Re: Problems setting a Mysql database connection

Still have the same problem, and yes I can connect to a local database but I can't connect to a remote one
Employee

Re: Problems setting a Mysql database connection

Still have the same problem, and yes I can connect to a local database but I can't connect to a remote one

Hello
I think your problem comes from your MySQL setting actually! It seems that your MySQL doesn't accept remote connection. Check out the MySQL manual http://dev.mysql.com/doc/refman/5.0/en/connection-access.html on how to grant privileges (Host=<clientIPAdress> or Host=% in order to accept all connections from any client IP Adress).
One Star

Re: Problems setting a Mysql database connection

I can connect to the remote database using phpmyadmin and I'm using same user name and password for both connections
Attached a print screen of my root user configuration using phpmyadmin from a remote connection
thanks for your help
Employee

Re: Problems setting a Mysql database connection

I can connect to the remote database using phpmyadmin

Hi,
PhpMyAdmin is a web client and doesn't run on your local machine. I think PHPMyAdmin is installed on your MySQL server and use a local connection.
I think you should installed on your local machine a SQL client (like MySQL Query brower, SQLExplorer...) to test and I think the connection will be failure. See my previous post to grant privileges in order to accept all connections from any client IP Adress.
Highlighted
One Star

Re: Problems setting a Mysql database connection

Hi,
I faced similar problem. I'm using Talend Open Studio 5.1.1 and I can connect to a remote MySQL server using MySQL Workbench running on my local PC. However, I got the following error in my TOS log file when I try to create DB connection under Metadata.
!ENTRY org.talend.platform.logging 4 0 2012-10-08 11:17:30.081
!MESSAGE 2012-10-08 11:17:30,080 ERROR org.talend.commons.exception.CommonExceptionHandler - com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Malformed reply from SOCKS server
STACKTRACE:
java.net.SocketException: Malformed reply from SOCKS server
at java.net.SocksSocketImpl.readSocksReply(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:39)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:105)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:840)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:1933)
at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:141)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.checkConnection(DatabaseForm.java:863)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm.access$19(DatabaseForm.java:814)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$4.widgetSelected(DatabaseForm.java:1029)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.talend.repository.ui.actions.metadata.CreateConnectionAction.doRun(CreateConnectionAction.java:210)
at org.talend.repository.ui.actions.AContextualAction$2.run(AContextualAction.java:589)
at org.talend.repository.RepositoryWorkUnit.executeRun(RepositoryWorkUnit.java:84)
at org.talend.core.repository.model.AbstractRepositoryFactory.executeRepositoryWorkUnit(AbstractRepositoryFactory.java:217)
at org.talend.repository.localprovider.model.LocalRepositoryFactory.executeRepositoryWorkUnit(LocalRepositoryFactory.java:2751)
at org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:1882)
at org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:601)
at org.talend.repository.viewer.action.RepoDoubleClickAction.run(RepoDoubleClickAction.java:102)
at org.eclipse.ui.actions.RetargetAction.run(RetargetAction.java:221)
at org.eclipse.ui.navigator.CommonNavigatorManager$3.open(CommonNavigatorManager.java:185)
at org.eclipse.ui.OpenAndLinkWithEditorHelper$InternalListener.open(OpenAndLinkWithEditorHelper.java:48)
at org.eclipse.jface.viewers.StructuredViewer$2.run(StructuredViewer.java:845)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
at org.eclipse.jface.viewers.StructuredViewer.fireOpen(StructuredViewer.java:843)
at org.eclipse.jface.viewers.StructuredViewer.handleOpen(StructuredViewer.java:1131)
at org.eclipse.ui.navigator.CommonViewer.handleOpen(CommonViewer.java:462)
at org.eclipse.jface.viewers.StructuredViewer$6.handleOpen(StructuredViewer.java:1235)
at org.eclipse.jface.util.OpenStrategy.fireOpenEvent(OpenStrategy.java:264)
at org.eclipse.jface.util.OpenStrategy.access$2(OpenStrategy.java:258)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:298)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.talend.rcp.intro.Application.start(Application.java:126)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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 org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:619)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)

** END NESTED EXCEPTION **

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch