You are currently reviewing an older revision of this page.
Users are unable to add a MySQL data source from the Admin Console. The following error is printed in the application server log:
ERROR com.appiancorp.expr.server.scriptingfunctions.DataSourceFunctions - Failed datasource validationcom.appiancorp.rdbms.datasource.DataSourceValidationException: java.sql.SQLException: Cannot create PoolableConnectionFactory (SSL connection is required. Please specify SSL options and retry.)...Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (SSL connection is required. Please specify SSL options and retry.)...Caused by: java.sql.SQLException: SSL connection is required. Please specify SSL options and retry.
The MySQL data source requires an SSL connection, but the connection string does not specify that SSL should be used.
This error can be resolved by appending &useSSL=true to the MySQL connection string to require the connection string to use SSL. If the error still occurs, it can be resolved by appending &useSSL=true&trustServerCertificate=true to the connection string. This requires the connection to both use SSL and trust the existing certificate if the certificate is self-signed and/or not trusted automatically.
&useSSL=true
&useSSL=true&trustServerCertificate=true
This article applies to all versions of Appian.
Last Reviewed: August 2020