Download Jar Mysql-connector-java 5.1.38
Jaskon Farr
The mysql-connector-java-5.1.46.jar and mysql-connector-java-5.1.46-bin.jar are binary identical, except for the META-INF/INDEX.LIST (which contains the actual jar filename). I have unzipped both and compared them using kdiff3.
The bundle for Connector/J 5.1 delivered by Oracle now contains an additional jar package with the name mysql-connector-java-5.1.ver.jar (mysql-connector-java-commercial-5.1.ver.jar for commercial bundles). It is identical with the other jar package with the original package named mysql-connector-java-5.1.ver-bin.jar (mysql-connector-java-commercial-5.1.ver-bin.jar for commercial bundles), except for its more Maven-friendly file name. (Bug #27231383)
So I replaced the mysql-connector-java file with an older version (8.0.15), but when I go to CF admin settings page and look at CF Server Java Class Path, it still lists the newer version (8.0.25). And I did confirm the location of the file. I have restarted CommandBox and even my laptop, just in case.
In CF Admin, Settings Summary: /Users/felix/.CommandBox/lib/var/root/.CommandBox/server/0000BFE9FDDB8536A2AA8EE8CA10AFE5-mydev/adobe-2016.0.17.325979/WEB-INF/cfusion/lib/mysql-connector-java-8.0.25.jar
I am installing Ignition 8.1.xx on a Red Hat Enterprise Linux 8.5 server. When I attempt to make a database connection to my MySQL database I get an error that connector files are missing. I believe the missing file is mysql-connector-java-8.0.29-1.e18.noarch.rpm. When I proceed to install this file I get the following error:
I have also tried to use a single mysql.m with the driver file that should be compatible with the old database (mysql-connector-java-3.0.10-stable-bin.jar) and also tried with mysql-connector-java-5.1.38-bin.jar as well as with the current standard mySQL driver mysql-connector-j-8.1.0.jar. These are the stable versions from Oracle which correspond to different eras, with either 3.0.10 or 5.1.38 corresponding to the drivers which old Mathematica (v10, v11) that had connected ok with my old databases.
In all these cases, I still get the same error.
I have additionally tried to use AddToClassPath with the Prepend -> True option, but still get the same authentication protocol error.
(OR) if you are downloading the mysql-connector-java JAR from some tar.gz archive then please make sure to check the following locations and create the symlinks something like following to point to your jar.
If it is not available in the available Yum repo then you will need to manually download it from: After downloading the "(mysql-connector-java-5.1.46.zip)" OR tar version you will need to extract it and then you will find the "mysql-connector-java-xxxx.jar" file inside it that you need to put on your ambari server host. As following:
When I execute "ls -l /var/lib/ambari-server/resources/mysql-connector-java.jar" in the master node, I get the correct output "/var/lib/ambari-server/resources/mysql-connector-java.jar -> /usr/share/java/mysql-connector-java.jar".
It appears you may be running liquibase from a windows machine. If so, correct the value of classpath to point to the absolute location (e.g. of the MySQL driver mysql-connector-java-5.1.13-bin.jar (although relative would work too, I prefer absolute)
I want to use a mysql connection in jaspsersoft studio. The mysql connector is not included, and needs to be added, as is described in various places, e.g. here. Unfortunatly, it seems to be common knowledge how to do this - no one describes how. I have been trying all sorts of locations for the mysql-connector-java-5.1.30-bin.jar file with no success. Can someone tell me the exact steps on how to add the mysql connector?I have jaspersoft studi 5.5.1, mysql-connector-java-5.1.30 on ubuntu 12.04.
Go to environment variable then click on new tab. In variable name write classpath and in variable value paste the path to the mysqlconnector.jar file by appending mysqlconnector.jar;.; as C:\folder\mysql-connector-java-5.0.8-bin.jar;.;
The connector itself is a single file named mysql-connector-java-X.X.XX-bin.jar.Extract this file from the downloaded archive to a location on your hard drive that is accessible from RapidMiner Studio.
760c119bf3