Connection Error -- mysql

[Anonymous]

Hi, 
I am quite new to Talend; I have installed Talend Open Studio v6.1.1 and I am trying to create a connection to mysql DB installed locally in my system. my mysql version is v57. I have insattaled all the additional packages asked by talend (help>install additional packages)
DB Details:
host: localhost
Port: 3306
However, It's throwing below error:
Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.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: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
      at java.net.URLClassLoader.findClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:121)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:146)
      ... 9 more





Could someone please advise on this?

Thanks

[Anonymous]

Hi,
Talend Studio  requires specific third-party Java libraries or database drivers (. jar  files) to be installed to connect to sources and targets. Those libraries or drivers, known as external modules, can be required  by some of Talend components  or by some connection wizards or by both . Due to license restrictions,  Talend  may not be able to ship certain external modules within  Talend Studio .
Please take a look at documents about:TalendHelpCenter:Identify required external modules and TalendHelpCenter:Install external modules.
Best regards
Sabrina

[Anonymous]

Hi,

Appreciating your quick response.
From your reply, I infer that, the Open source pack of Talend does not hold the license to download external (may be some of the) drivers/modules. I have gone through the links given and tried to download from Help>Instal Additional Packages, but it throws "Time out" issues for many downloads, a few got successful though; so I may need to buy a fledged version, correct?

Cheers,
Sreekumar

[Anonymous]

Hi,

Due to license restrictions, Talend may not be able to ship certain external modules within Talend Studio.

Actually, we are talking about Apache License. 
Is your network Ok with you? Are you working behind proxy? 
Some modules are not available on the Talend website but can be downloaded directly from external websites. Once downloaded, these modules must be placed in specific folders. For the studio, the downloaded modules must be placed in the following folder:<StudioPath>/configuration/.m2


Best regards
Sabrina

[Anonymous]

Hi,
How can i connect to a remote MySQL server in Talend over SSH? A "Connection Failure" was encountered when trying to connect to the remote server. I was able to connect it though via MySQL instance with the correct SSH key.

[Anonymous]

Hi  AntonioOna,
Could you please take a look at  the solution mentioned in this topic: https://community.talend.com/t5/Design-and-Development/How-to-create-DB-Connection-over-SSH/td-p/188... to see if it works?
Best regards
Sabrina

[Anonymous]

Hi,
No it did not. i still got the same error. what i am trying to achieve here is to add a new mysql connection in talend.

[Anonymous]

Hi,
So far, MySql components just support for jdbc connection not SSH tunneling.

Best regards
Sabrina