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