Database Errors

MySQL 8: Public Key Retrieval is not allowed

After upgrading to MySQL 8, you may encounter the following error on startup:

liquibase.exception.JDBCException: java.sql.SQLException: Cannot create PoolableConnectionFactory (Public Key Retrieval is not allowed)
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed

To remedy this:

  • Stop Cascade CMS
  • Edit your tomcat/conf/context.xml file and add allowPublicKeyRetrieval=true to your url parameter. Example:
url="jdbc:mysql://localhost:3306/cascade?useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true"
  • Start Cascade CMS