The version of the MySQL JDBC driver included with some versions of Ignition does not support MySQL 5.6. This problem can manifest itself in different ways, but is often encountered when using tag history. Since it can result in a variety of down stream errors, you should verify that this is the root cause by examining the gateway console log (available under Config>Console in the gateway administration website) for an error resembling the one above.
Note: A newer version of the driver is included with the latest versions of Ignition, however, if performing an upgrade the older version will be maintained. Therefore, this error can be received in any version of Ignition, depending on the install history.
To upgrade the MySQL driver:
- Go to http://www.mysql.com/downloads/connector/j/
- Select "Platform Independent" from the Select Platform dropdown list, and download the latest driver.
- Extract the contents and locate the "mysql-connector-java-...jar" file.
- Copy that file to "{Ignition Install Directory}\user-lib\jdbc", and remove the previous version.
- Restart the Ignition gateway to reload the drivers.
Comments
0 comments
Please sign in to leave a comment.