MySQL 8 SSL
Issue
Admin is making a database connection to a MySQL 8 database. When clicking the Ping button on the DB Connection object, the following error is presented:
WARN: 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.
Solution
If you are unable to add a SSL Certificate to the SQL server/database, can setup the DB Connection object in UW as a Customized DB type for the connection, adding ?useSSL=false to the end of the Connection String.
Can't find the KB
Unable to find the KB to address your issue ?
Recent Articles
Lenovo Unified Workspace 7.0.2.5 Released
Highlights of Unified Workspace 7.0.2.5 Before you install: Please view the installation notes here. 7.0.2.5 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Fixed external storage providers oauth ...Lenovo Unified Workspace 7.0.1.41 Released
Highlights of Unified Workspace 7.0.1.41 Before you install: Please view the installation notes here. 7.0.1.41 requires a 7.0 license file. Below is a list of enhancements and fixes for Unified Workspace 7.0.1.41 Updated Log4j Updated Java Updated ...Alternative Product for Unified Workspace
Unfortunately, Lenovo Software does not have an alternative product in which to migrate. To our knowledge, there just isn't any other single product out there that can do all that Lenovo Unified Workspace (LUW) was able to do. In searching for ...Retiring Unified Workspace
Lenovo and Stoneware are committed to providing the highest quality products and services to our customers. As part of our continued focus on innovation, we will be retiring Unified Workspace (formerly Stoneware webNetwork), effective January 31, ...Assigned tiles not showing due to missing back-link
Question We have several staff members that can't see a specific assigned tile/link. The tile has many group assignments the user is a member of, but when I view User Access and look at the assigned Link Sources, the tile/link is not listed. Issue ...
Related Articles
Our SSL cert is expiring on our UW servers, can Lenovo Software help us renew that certificate?
Issue SSL Certificate is expiring/expired on customer's Unified Workspace (formerly webNetwork) server(s). Solution Lenovo Software Support can assist you with renewing the SSL Certificate on your UW servers. The only downtime required will be a ...Convert PFX certificate to JKS keystore using KeyStore Explorer
Issue: Can we import the wildcard SSL Certificate we already have on our IIS server(s)? Solution: Please see the following documentation on how to convert a PFX certificate, exported from an IIS server, to a Java JKS keystore. Once you have your new ...Verify Active Directory SSL
How can I check if my Microsoft Active Directory Domain controller / LDAP Server has SSL ? The following URL has a nice write up about the Microsoft Tool called LDP.exe http://www.computerperformance.co.uk/w2k3/utilities/ldp.htm You can download ...SSL certificate installation - part 2
Problem: Need to create and add new wildcard SSL certificate to Unified Workspace server. Prerequisite(s): Completed part 1 Access to keystore password Solution(s): Below instructions will walk you through process of placing a new keystore on ...SSL certificate installation - part 1
Problem: Need to create and add new wildcard SSL certificate to Unified Workspace server. Prerequisite(s): Download and install KeyStore Explorer tool on workstation Solution(s): Below instructions will walk you through process of creating a new ...