package mysql-server-8.0 8.0.25-0ubuntu0.20.04.1 failed to install/upgrade: Too many levels of symbolic links: '/etc/mysql/my.cnf'

[Liam Birt]

I've never reported one of these before and not exactly sure what's going on. I tried to install the Open Source Social Network and it said there's some MySQL errors and conflicts? I do have PHP installed on my AWS EC2 server but not I didn't have it on here before I ran this. Not quite sure what's happening?

https://www.opensource-socialnetwork.org/

ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: mysql-server-8.0 8.0.25-0ubuntu0.20.04.1
ProcVersionSignature: Ubuntu 5.8.0-59.66~20.04.1-generic 5.8.18
Uname: Linux 5.8.0-59-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.18
Architecture: amd64
CasperMD5CheckResult: skip
Date: Wed Jul 21 21:16:40 2021
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2021-06-11 (41 days ago)
InstallationMedia: Ubuntu 20.04.2.0 LTS "Focal Fossa" - Release amd64 (20210209.1)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
 [mysqldump]
 quick
 quote-names
 max_allowed_packet = 16M
MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf'
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.8.0-59-generic root=UUID=2bee3a90-436f-4900-bce8-c63cf2c91e7b ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.8, Python 3.8.10, python3-minimal, 3.8.2-0ubuntu2
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.19.7ubuntu3
 apt 2.0.6
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.25-0ubuntu0.20.04.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Utkarsh Gupta (utkarsh)]

Hello,

Thank you for filing this bug report. As I see:
> I tried to install the Open Source Social Network and it
> said there's some MySQL errors and conflicts?

After reading the logs, which say:
> 2021-07-22T02:13:49.189938Z 0 [ERROR] [MY-010285] [Server]
> Failure to parse RSA private key (file exists):
> /var/lib/mysql//private_key.pem: error:0909006C:PEM
> routines:get_name:no start line

It looks like the public key file contents were replaced with the private key file contents or somehow the keys got messed up.

Interestingly, there's a similar known report in upstream tracker:
https://bugs.mysql.com/bug.php?id=70115

Maybe you can manually recover the keys and restart the slaves and things should start to work again normally?

I tried to reproduce but couldn't find a way to do that. So whilst I can think it's a local issue and I am marking as "Incomplete", if you believe that it's actually a bug in the package rather than a local problem, let us know why you think that and if possible, give us some steps to reproduce the issue. Once done, also set the status of the bug to "New" and we'll take a look at it again.

For local configuration issues, you can find assistance here:
http://www.ubuntu.com/support/community

Thank you!