Anyone install MySQL 8.0 and connect with Ignition? I get an error when I attempt. Wondering if maybe the java MySQL driver needs to be updated to work… org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.lang.ClassCastException: java.math.BigInteger cannot b…

Have you verified your versions based on this chart ?

There are some known issues with MySQL 8.0 and our current bundled JDBC driver. We’re working on a works-for-the-most-people solution, but you should also be aware that QA hasn’t fully tested MySQL 8.0 yet so it’s not guaranteed compatible.

You can install the latest MySQL JDBC driver yourself if you don’t want to wait for us to ship an updated version.

Thanks all, I’ll just roll back to 5.7 for now until the team vets the latest version and connector etc.

I just got burned with this as well on a new installation

Us too. Tried installing MySQL 8 with Ignition 7.9.5. Trying to install newest JDBC driver now but no luck getting it to connect

I had the same problem. Just downladed mysql-connector-java-5.1.46.zip from MySQL and changed the driver for JDBC with the .jar file mysql-connector-java-5.1.46.jar. It worked.

I had the same problem. Followed davoodnasehi recommendation: “Just downladed mysql-connector-java-5.1.46.zip from MySQL and changed the driver for JDBC with the .jar file mysql-connector-java-5.1.46.jar. It worked! Yey! ;-)”

is there any update on this matter ? I tried to use mysql-connector-java-8.0.13 or mysql-connector-java-5.1.46 and I can’t get a connection with either of these using 7.9.10 :frowning:

[image] philippe.timothee: I tried to use mysql-connector-java-8.0.13 or mysql-connector-java-5.1.46 and I can’t get a connection with either of these using 7.9.10 :frowning: There should be an error in the gateway logs - could you post it here (or get in contact with support?) A default ins…

Inductive Automation Forum

MySQL 8.0 Connection

Ignition

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled