[MDEV-30092] SSL Error after Update Created: 2022-11-25 Updated: 2023-03-07 Resolved: 2022-12-02 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Platform Debian, SSL |
| Affects Version/s: | 10.3.37 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Christian | Assignee: | Sergei Golubchik |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
Today my apt-cron installed the newest release for Debian:
Since this release the MariaDB Service will not start. In Logs I can found:
When I deactivate SSL in config everything is fine again. |
| Comments |
| Comment by Sergei Golubchik [ 2022-11-27 ] | |||||||||||
|
The error says it
Do you have such a file? Does it have a valid private key? This is likely the effect of Now the server refuses to start if the SSL was configured incorrectly, if SSL was requested, the server will not start without it. | |||||||||||
| Comment by Christian [ 2022-11-27 ] | |||||||||||
|
Yes - file is at this path, was used by the service before. Also it is used by other services like postfix - so I can confirm the certificate is valide and also my mailclient works with it. Permission are for All readable (ugo+r). Greetings | |||||||||||
| Comment by Sergei Golubchik [ 2022-12-02 ] | |||||||||||
|
Do you use distro mariadb packages? They might be compiled with yassl, and yassl can refuse to load keys that openssl can. You've always had this error, just after in 10.3.37 it became visible, earlier versions simply disabled SSL and pretended than everything's fine, and 10.3.37 refuses to lie about it. Search for "Unable to get private key" — I've got quite a few hits, both for MariaDB and MySQL, for older versions too. For example, https://bugs.mysql.com/bug.php?id=71271 | |||||||||||
| Comment by Stefan [ 2022-12-20 ] | |||||||||||
|
Same happened when upgrading from 10.5.15-0+deb11u1 to 10.5.18-0+deb11u1 on Debian 11. This is a really critical bug as our configs (managed through Puppet) include ssl = false in the config, so naturally one would expect that the ssl-cert etc. parameters would be ignored. For a patch update to change such a functionality to bring down all MySQL servers is not ideal. | |||||||||||
| Comment by Faustin Lammler [ 2022-12-20 ] | |||||||||||
|
I have just tested this and indeed, the server still tries to activate ssl (even if
or
is used and further ssl directives are in the configuration file:
I am not sure if this is on purpose though, my understanding from https://mariadb.com/kb/en/mysqld-options/#-ssl is that
should disable any further ssl options but it also mention
? Anyway, I have forwarded https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1026353 to this jira issue and regarding the puppet deployment tool, this comment is correct, there is no reason to deploy extra ssl directives if it's supposed to be disabled in the first place IMO. | |||||||||||
| Comment by Otto Kekäläinen [ 2023-03-07 ] | |||||||||||
|
This was also related to https://bugs.launchpad.net/ubuntu/+source/mariadb-10.3/+bug/1997916 and |