mysql-server apport fails to report my.cnf

This error seems to show up because my.cnf has two levels of symbolic link:

my.cnf -> /etc/alternatives/my.cnf -> /etc/mysql/mysql.cnf

This bug was fixed in the package mysql-8.0 - 8.0.29-0ubuntu3

---------------
mysql-8.0 (8.0.29-0ubuntu3) kinetic; urgency=medium

  * d/a/source_mysql-8.0.py: Fix apport too many symbolic
    links report for my.cnf (LP: #1969369)

 -- Lena Voytek <email address hidden> Thu, 12 May 2022 09:00:19 -0700

Hello Lena, or anyone else affected,

Accepted mysql-8.0 into jammy-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/mysql-8.0/8.0.29-0ubuntu0.22.04.3 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-jammy to verification-done-jammy. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-jammy. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

All autopkgtests for the newly accepted mysql-8.0 (8.0.29-0ubuntu0.22.04.3) for jammy have finished running.
The following regressions have been reported in tests triggered by the package:

exim4/4.95-4ubuntu2.1 (ppc64el)
ruby-mysql2/0.5.3-3ubuntu4 (armhf, amd64, s390x, arm64, ppc64el)

Please visit the excuses page listed below and investigate the failures, proceeding afterwards as per the StableReleaseUpdates policy regarding autopkgtest regressions [1].

https://people.canonical.com/~ubuntu-archive/proposed-migration/jammy/update_excuses.html#mysql-8.0

[1] https://wiki.ubuntu.com/StableReleaseUpdates#Autopkgtest_Regressions

Thank you!

Impish support ending in a few days, marked as wont fix

Verified the fix works through the following:

# lxc launch images:ubuntu/jammy test-jammy
# lxc exec test-jammy bash

# apt update && apt dist-upgrade -y

# apt install apport mysql-server software-properties-common

# ubuntu-bug mysql-server
V
- Under the my.cnf section the too many symbolic links error will be shown
C

# add-apt-repository ppa:lvoytek/mysql-8.0-fix-apport-my-cnf-kinetic

# cat <<EOF >/etc/apt/sources.list.d/ubuntu-$(lsb_release -cs)-proposed.list
# Enable Ubuntu proposed archive
deb http://archive.ubuntu.com/ubuntu/ $(lsb_release -cs)-proposed restricted main multiverse universe
EOF

# apt update && apt upgrade -y

# export APPORT_DISABLE_DISTRO_CHECK=1

- Check default config
# ubuntu-bug mysql-server
V
- The my.cnf section will now show "MySQLConf.etc.mysql.my.cnf: my.cnf links to /etc/mysql/mysql.cnf"
C

- Check custom config
# rm /etc/mysql/my.cnf
# cp /etc/mysql/mysql.cnf /etc/mysql/my.cnf

# ubuntu-bug mysql-server
V
- The my.cnf section will now show the contents of the file
C

This bug was fixed in the package mysql-8.0 - 8.0.29-0ubuntu0.22.04.3

---------------
mysql-8.0 (8.0.29-0ubuntu0.22.04.3) jammy; urgency=medium

  * d/a/source_mysql-8.0.py: Fix apport too many symbolic
    links report for my.cnf (LP: #1969369)
  * d/mysql-server-8.0.postinst: Confirm mysqld shuts down with stop_server
    after initialization to avoid overlapping use of port 3306 (LP: #1921378)

 -- Lena Voytek <email address hidden> Mon, 27 Jun 2022 10:55:12 -0700

The verification of the Stable Release Update for mysql-8.0 has completed successfully and the package is now being released to -updates. Subsequently, the Ubuntu Stable Release Updates Team is being unsubscribed and will not receive messages about this bug report. In the event that you encounter a regression using the package from -updates please report a new bug using ubuntu-bug and tag the bug report regression-update so we can easily find any regressions.