Skip to end of metadata
Go to start of metadata
Go Back to Start of Tutorial

Go back to Start of Section

Move to Last Page
Move to Next Page
Jump to Next Section 















The MES modules create their own database schema to store configuration information and production data in. All you have to do is provide the database, create a database connection on the Ignition Gateway and let the MES modules know to use this database. You should have already created the database when you installed the Database instance in the Let's Get Set Up section. If not, open up MySQL Workbench and create a database called mes

To download and install MySQL, go to the MySQL website at
http://dev.mysql.com/downloads/mysql/



We'll create a database connection in the Ignition Gateway configuration section. If you are using a different type of database server than MySQL, then you'll need to set it up accordingly. The instructions below are for MySQL.


  • Log in to Configuration and select Databases > Connections from the menu.
  • Click on the Create new Database Connection... link to add a new connection.
  • Choose the MySQL ConnectorJ for this database. 
  • Give the connection a name, specify the connection URL, and the credentials to use.  

    • Name: MES

    • Connect URL: jdbc:mysql://localhost:3306/mes

    • Username: select the username i.e. root

    • Password: select the password you setup for this user in mysql

    • 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 on the Create New Database Connection button to finish creating the connection.




  • Verify the connection displays "valid" on the database status page before continuing to the next section. Now we have a database to store the MES data in.



 

Go Back to Start of Tutorial

Go back to Start of Section

Move to Last Page
Move to Next Page
Jump to Next Section 















  • No labels