Bug #105429 Server Connection manager enforces SSL encryption

• Submitted: 2 Nov 2021 15:13
• Modified: 3 Nov 2021 7:45
• Reporter: Dimitar Nikov
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.27
• OS: Any
• CPU Architecture: Any
• Tags: SSL

[2 Nov 2021 15:13] Dimitar Nikov

Description:
"Use SSL" drop-down under SSL Tab in Server Connection Manager enforces SSL encryption.
Making SSL encryption mandatory when adding new and/or editing existing connections with no-SSL enabled servers renders Workbench unusable.

Possible workaround: Edit the `connection.xml` file and change `<value type="int" key="useSSL">2</value>` to `<value type="int" key="useSSL">0</value>`. One-liner for Linux

sed -i.bak -e 's/useSSL">2</useSSL">0</g' ~/.mysql/workbench/connections.xml

For other OSes - please put the correct path to the file.

How to repeat:
1. Create new or edit existing connection
2. Navigate to "SSL" tab
3. Try to chose anything but SSL encryption in drop-down for "Use SSL"

Suggested fix:
Add an empty option in drop-down menu for "Use SSL" drop-down in SSL tab.

[2 Nov 2021 15:13] Dimitar Nikov

Use SSL Drop-down in SSL Tab

Attachment: Use-SSL-MySQL-Workbench.png (image/png, text), 57.49 KiB.

[3 Nov 2021 4:24] MySQL Verification Team

Hello Dimitar Nikov,

Thank you for the bug report.
Imho this is duplicate of Bug #105327, please see Bug #105327.

Regards,
Ashwini Patil

[3 Nov 2021 7:45] Dimitar Nikov

Hi Ashwini,
you are right, please consider closing this one.

I'll put my workaround in #105327.