MySQL 8 and UGCC Support

Post Reply
Masher
Site Admin
Posts: 3381
Joined: Thu Apr 20, 2006 2:54 pm
Location: America's Hearland
Contact:

MySQL 8 and UGCC Support

Post by Masher » Mon Dec 31, 2018 2:38 pm

Starting with version 2.13 of UGCC, we added an sslmode setting that allows the panel to work with MySQL 8.

New users/installs don't need to do anything as these additions were added in the templates.

We set the default setting to Preferred if the panel/monitor does not see the setting in the configs. This will use encryption on the connection if available, otherwise fall back to an unencrypted connection. If this causes you issues, or you want a different policy to apply, you will need to:

Add the following to your Web Panel's Web.config, below <add key="dbname"..... >

Code: Select all

<add key="sqlsslmode" value="Preferred"/>
Other options for the value can be found at: https://dev.mysql.com/doc/connector-net ... tions.html

For the monitor, edit C:\Windows\System32\ugccmon.cfg Append the following to the database= configuration line:

Code: Select all

;sslmode=Preferred
Masher
-----------
Please do not PM me unless asked to! We are a small company and if you have an issue or question it would be best to post it in the forums where it can help others in the future.

Need an affordable web control panel? Try UGCC.

Post Reply