Database

A variety of databases can be used with the Sepasoft MES modules. The MES modules create and maintain their own schemas to store configuration information and production data. All you have to do is provide the database for them to reside in. Since MySQL is free, reliable and easy to use, it is the most common choice for use with Ignition. 

This tutorial uses MySQL, so we'll utilize a MySQL ConnectorJ connection to the mes database schema that you created earlier. 

To configure the MySQL database:

• Open and log in to your Ignition Gateway page (localhost:8088/main/web/home). 
• Go to: Configure tab → Databases section → Connections.
• Click Create new Database Connection...
• Choose the MySQL ConnectorJ and click Next.
• Complete the following configuration items below:
  • Name:mes
  • Connect URL:jdbc:mysql://localhost:3306/mes
  • Username:root
  • Password:12345 (or whatever password you used to create the schema)
  • Extra Connection Properties: Append serverTimezone=UTC to the end of the settings. This is a new requirement for MyQL Connector/J 8.0. More info is available in Section 4.14 and Section 4.3.3.1.7 of the MySQL documentation.
• Click Create New Database Connection at the bottom of the page.
• Verify that the connection displays "valid" on the database status page before continuing to the next section. We now have a connected database to store the MES data in.