MySQL client fails to connect, seems to force SSL
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Release Notes for Ubuntu |
New
|
Undecided
|
Unassigned | ||
mysql-8.0 (Ubuntu) |
Invalid
|
High
|
Unassigned |
Bug Description
Description: Ubuntu Focal Fossa (development branch)
Release: 20.04
mysql Ver 8.0.19-0ubuntu4 for Linux on x86_64 ((Ubuntu))
I get this error from command line when trying to connect to a remote server:
# ERR: SSL connection error: error:1425F102:SSL routines:
I get the same error from C++ scripts using MySQL Connector++.
Only way mysql command line works is to add --ssl-mode=DISABLED
Server version: 5.6.10-log MySQL Community Server (GPL)
The connection goes through OpenVPN.
Alternative solution: Using instead mariadb-client works without problems.
Older versions of Ubuntu don't present this issue. I tested 16.04, 18.04, 19.10, and I can connect using mysql in all of them.
Fails in 20.04 in a virtual machine too.
ProblemType: Bug
DistroRelease: Ubuntu 20.04
Package: mysql-client 8.0.19-0ubuntu4
ProcVersionSign
Uname: Linux 5.4.0-21-generic x86_64
ApportVersion: 2.20.11-0ubuntu26
Architecture: amd64
CasperMD5CheckR
CurrentDesktop: ubuntu:GNOME
Date: Mon Apr 13 13:42:25 2020
InstallationDate: Installed on 2020-04-12 (0 days ago)
InstallationMedia: Ubuntu 20.04 LTS "Focal Fossa" - Beta amd64 (20200409)
PackageArchitec
SourcePackage: mysql-8.0
UpgradeStatus: No upgrade log present (probably fresh install)
Changed in mysql-8.0 (Ubuntu): | |
status: | New → Triaged |
Hello Nicolay,
Thank you for taking the time to file a bug report.
Could you please describe your problem with more detailed information ? mysql-server-8.0 default installation in 20.04 does NOT enable SSL by default, in the server, nor in the client:
"""
mysql> status;
--------------
mysql Ver 8.0.19-0ubuntu5 for Linux on x86_64 ((Ubuntu))
Connection id: 9 noco/.vim/ plugged/ vimpager/ vimpager mysqld/ mysqld. sock
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: /home/rafaeldti
Using outfile: ''
Using delimiter: ;
Server version: 8.0.19-0ubuntu5 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/run/
Binary data as: Hexadecimal
Uptime: 1 min 54 sec
"""
The fact that your mysql client is trying to reach the server using SSL by default gives the impression that my.cnf (or any other included configuration file) is configuring that behavior. Could you please provide, together with your report, all your mysql configuration files ?
Since there is not enough information in your report to begin triage or to
differentiate between a local configuration problem and a bug in Ubuntu, I
am marking this bug as "Incomplete". We would be grateful if you would:
provide a more complete description of the problem, explain why you
believe this is a bug in Ubuntu rather than a problem specific to your
system, and then change the bug status back to "New".
For local configuration issues, you can find assistance here: www.ubuntu. com/support/ community
http://