Install MySQL - Revision history

Vmurrell at 12:04, 30 March 2024

2024-03-30T12:04:15Z

Vmurrell at 12:14, 23 March 2024

2024-03-23T12:14:22Z

Plazarou: /* Installing MySQL 5.7 */

2022-10-26T07:38:07Z

‎Installing MySQL 5.7

Plazarou: /* Overview */

2022-10-26T07:37:56Z

‎Overview

Plazarou: /* Using FMR 11.4 or later versions */

2022-10-13T15:26:12Z

‎Using FMR 11.4 or later versions

Plazarou: /* Connection Details */

2022-10-13T15:25:55Z

‎Connection Details

Plazarou: /* Connection Details */

2022-10-13T15:25:47Z

‎Connection Details

Plazarou: /* Obtaining the MySQL Connector Dependency */

2022-10-13T15:24:23Z

‎Obtaining the MySQL Connector Dependency

Plazarou: /* New Installations of FMR */

2022-10-13T15:23:39Z

‎New Installations of FMR

Plazarou: /* New Installations of FMR */

2022-10-13T15:23:30Z

‎New Installations of FMR

@@ Line 1: / Line 1: @@
-[[Category:Draft_-_Installation_and_Configuration]]
+[[Category:Installation_and_Configuration]]
 [[Category:How_To]]
 [[Category:How_To V11]]

← Older revision		Revision as of 12:14, 23 March 2024
Line 1:		Line 1:
		+	[[Category:Draft_-_Installation_and_Configuration]]
		+
	[[Category:How_To]]		[[Category:How_To]]
	[[Category:How_To V11]]		[[Category:How_To V11]]

@@ Line 6: / Line 6: @@
 Version 8 of MySql may be used with FMR, and it is permitted to use a MySQL equivalent service like MariaDB, provided it is MySQL compatible.
-=Installing MySQL 5.7=
+=Installing MySQL=
 It is beyond the scope of this article to explain how to install MySQL, but at the current time of writing the community edition of MySQL Server may be [https://dev.mysql.com/downloads/windows/installer/5.7.html downloaded for free].

@@ Line 4: / Line 4: @@
 MySQL may be used to act as the persistant store for Registry information. However the JDBC driver that communicates from the Registry to a MySQL instance is '''not''' provided within FMR (since FMR version 11.4.0) and must be obtained by a Systems Administrator.
-It is also permitted to use a MySQL equivalent service like MariaDB.  It must be MySQL 5.7 compatible.
+Version 8 of MySql may be used with FMR, and it is permitted to use a MySQL equivalent service like MariaDB, provided it is MySQL compatible.
 =Installing MySQL 5.7=

@@ Line 82: / Line 82: @@
 || com.mysql.cj.jdbc.Driver
 |}
 =Creating the Fusion Metadata Registry schema=

@@ Line 67: / Line 67: @@
 Oracle by default uses port 1521.
-If you wish to make a custom connection to Oracle, the information you will likely need is:
+If you wish to make a custom connection to MySQL, the information you will likely need is:
 {| class="wikitable" style="vertical-align:top; text-align:left;"

@@ Line 72: / Line 72: @@
 ! Connection String
 || Of the form:
-jdbc:oracle:thin:@server url>:<server port>/<oracle schema>
+jdbc:mysql://<server>:<server port>/<database name>
 <br/>
-e.g. jdbc:oracle:thin:@localhost:1521/orcl12c
+e.g. jdbc:mysql://localhost:3306/fmr_test_v11?serverTimezone=GMT
 |-
 ! Dialect
-|| org.hibernate.dialect.Oracle10gDialect
+|| org.hibernate.dialect.MySQL55Dialect
 |-
 ! Class Name
-|| oracle.jdbc.driver.OracleDriver
+|| com.mysql.cj.jdbc.Driver
 |}

@@ Line 18: / Line 18: @@
 ==Obtaining the MySQL Connector Dependency==
-The ‘jar’ file is not included as part of the FMR distribution so must be obtained and installed separately prior to starting the application.<br>
+To enable FMR and a MySQL database to communicate the depdendency '''MySQL Connector/J''' version 8.0.29 (or higher) is required. This is a Jar file of approximately 2.5 Mb in size and called: '''mysql-connector-java-8.0.29.jar'''
 ==Driver Installation==

← Older revision		Revision as of 15:23, 13 October 2022
Line 70:		Line 70:

	It's usual to give the schema a name like <code>fusion_metsdata_registry</code>, but there's no restrictions so call it what you like. You'll tell Fusion Metadata Registry the name of the schema to use during the install process.		It's usual to give the schema a name like <code>fusion_metsdata_registry</code>, but there's no restrictions so call it what you like. You'll tell Fusion Metadata Registry the name of the schema to use during the install process.
−
−	~~=New Installations of FMR=~~
−	~~If you are implementing a new installation of Fusion Metadata Registry, having installed MySQL the next step is to to complete the installation process [[Install Fusion Metadata Registry\|More]].~~

	==Troubleshooting==		==Troubleshooting==

← Older revision		Revision as of 15:23, 13 October 2022
Line 73:		Line 73:
	=New Installations of FMR=		=New Installations of FMR=
	If you are implementing a new installation of Fusion Metadata Registry, having installed MySQL the next step is to to complete the installation process [[Install Fusion Metadata Registry\|More]].		If you are implementing a new installation of Fusion Metadata Registry, having installed MySQL the next step is to to complete the installation process [[Install Fusion Metadata Registry\|More]].
		+
		+	==Troubleshooting==
		+	If FMR fails to start, inspect the Web Server logs. If you encounter the following error:
		+
		+	<pre>
		+	2022-09-30 23:59:59.999 WARN main org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator - HHH000342: Could not obtain connection to query metadata
		+	java.sql.SQLException: Cannot load JDBC driver class 'com.mysql.cj.jdbc.Driver'
		+	at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:54)
		+	at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:459)
		+	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:525)
		+	...
		+	Caused by: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
		+	at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1407)
		+	...
		+	</pre>
		+
		+	This means that the JAR file has not been supplied correctly to your Web Server. Please review the steps you took in supplying the jar file to your Web Server and ensure that all locations and file names have been correctly specified.