![]() With the changes made to the MySQL JDBC driver, any new MySQL databases that you configure on the Ignition gateway will reflect the changes. Click on 'Save Changes' at the bottom of the page to save the changes to the MySQL JDBC driver entry. Afterward, under Driver Defaults & Instructions, the Default Connection Properties section will need to be set to the following value: zeroDateTimeBehavior=CONVERT_TO_NULL connectTimeout=120000 socketTimeout=120000 useSSL=false allowPublicKeyRetrieval=true 3. jar file in the previous step to upload it onto the Ignition gateway. Navigate to the location that you stored the. Under Classname, change the value to .jdbc.Driver. Under the JAR File(s) section, click on Choose File. Once in here, click on Edit on the MySQL ConnectorJ entry. This is found under Configure > Databases > Drivers. Open your Ignition Gateway Webpage interface and navigate to the JDBC drivers page. This file is the driver that we will need on the next step. jar file onto a directory that is easily accessible. Once downloaded, extract the contents inside the ZIP archive and save the. In the drop-down list for Select Operating System, select Platform Independent and Download the ZIP Archive. You can retrieve the latest JDBC driver (version 8.0.11 at the time of the writing) by going to the following link. Download the latest JDBC driver for MySQL The solution to this problem is to update the MySQL JDBC driver to the latest version provided by Oracle. This, in turn, would cause the previous driver to not function correctly on a new database version. Ignition, by default, ships with JDBC drivers for major databases but there are cases when a new database version requires an updated JDBC driver to be released by the developer of the database. There were changes that were introduced in MySQL 8.0 that broke backward compatibility with the bundled JDBC driver. This is an issue that is due to the JDBC driver that is bundled with Ignition by default. When trying to set up your MySQL database on version 8.0, the connection faults and is unable to connect. Solution: Update the JDBC driver for MySQL, change the Classname, and Extra Connection Properties value Background Information Issue: In the event of configuring or upgrading your MySQL database to version 8.0, the connection would get faulted and the Ignition gateway would post the following error(s) in the logs: .SQLNestedException: Cannot create PoolableConnectionFactory (Unable to load authentication plugin 'caching_sha2_password'.) .SQLNestedException: Cannot create PoolableConnectionFactory (: cannot be cast to ) The changes do not get reflected if upgrading to version 7.9.9 and we would need to do the steps above. This error has been fixed in version 7.9.9 and any clean installations of that version will contain the changes that were referenced above by default. ![]() Mysql node package is designed to be used like that: let configuration = Ĭonnection.Note: On versions prior to Ignition 7.9.9, you will continue to see an error in the Database Query Browser that it fails to list the table names with the changes made above.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |