Hi, can some one help me understanding the below error.
Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Hello Chandu, It is a setting on the datasource to connect to the DB, it is recommended when connecting to MySQL to set that flag to true so you will be connecting using SSL. community.appian.com/.../kb-1740-mysql-ssl-warning-establishing-ssl-connection-without-server-s-identity-verification-is-not-recommended As per the installation documentation the useSSL is not mentioned. So it is natural that the jdbc recommends "for security" to make make a secure connection from the server to the DB. docs.appian.com/.../Configuring_Relational_Databases.html It is a normal warning in the Java world when we are not using SSL connections to connect to the DB when developing. www.logicbig.com/.../connect-my-sql.html At the end certainly to enable the SSL you need to play with the Certificates on the MySQL Side documentation.cpanel.net/.../How to Configure MySQL SSL Connections With all this said we can all raise a ticket so Appian set the ssl, or do something. Or we just forget about that Warning been there Jose
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.