Debian 12: `mysql-connector-python-py3` is not offered in the debian package repository; extra documentation is needed.

[ShadowJonathan]

problem

Trying to "just" install cloudstack-management from the debian install instructions, I see this;

$ sudo apt install cloudstack-management
Solving dependencies... Error!
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

Unsatisfied dependencies:
cloudstack-management : Depends: python3-mysql.connector but it is not installable or
mysql-connector-python-py3 but it is not installable
Error: Unable to correct problems, you have held broken packages.
Error: The following information from --solver 3.0 may provide additional context:
Unable to satisfy dependencies. Reached two conflicting decisions:
1. cloudstack-management:amd64=4.22.0.0 is selected for install
2. cloudstack-management:amd64 Depends python3-mysql.connector | mysql-connector-python-py3
but none of the choices are installable:
[no choices]

Which then leads me to #9738, which assumes that mysql-connector-python-py3 is "just" available, while it is not;

$ apt search mysql-connector-python-py3
[ no output ]

Doing a bit of digging, I find that mysql-connector-python-py3 is provided by MYSQL's own apt repository: thread link, which isn't noted in the documentation.

versions

N/A, all versions on the debian repository

The steps to reproduce the bug

1. Install .deb via apt install cloud-management
2. Observe error

What to do about it?

Adjust dependency, or add missing instruction to documentation to include https://dev.mysql.com/downloads/repo/apt/

[ShadowJonathan]

Digging a bit, it looks like that the python connector is not available via the debian repository, since they removed debian building since version 9.0.0: https://downloads.mysql.com/archives/c-python/

[ShadowJonathan]

And taking a further look in https://repo.mysql.com/apt/debian/dists/, it only looks like wheezy and jessie have this connector.

[DaanHoogland]

@ShadowJonathan , do you have a doc PR to submit? you can at https://github.com/apache/cloudstack-documentation

[weizhouapache]

And taking a further look in https://repo.mysql.com/apt/debian/dists/, it only looks like wheezy and jessie have this connector.

it is part of mysql-tools for bookworm/debian12
https://repo.mysql.com/apt/debian/dists/bookworm/mysql-tools/binary-amd64/Packages

you can just follow the steps in #9738

[ShadowJonathan]

@weizhouapache i'll need to take a look at that again, in my testing this did not show up at all, so it being in this packages file is odd to me

[weizhouapache]

@weizhouapache i'll need to take a look at that again, in my testing this did not show up at all, so it being in this packages file is odd to me

@ShadowJonathan
please share your steps if it does not work for you

root@debian-127:~# apt search mysql-connector-python-py3
Sorting... Done
Full Text Search... Done
mysql-connector-python-py3/unknown 8.4.0-1debian12 amd64
  MySQL database driver written in pure Python 3

mysql-connector-python-py3-dbgsym/unknown 8.4.0-1debian12 amd64
  debug symbols for mysql-connector-python-py3

[ShadowJonathan]

Ah I see what is going on.

The trixie release does not have the python connector: https://repo.mysql.com/apt/debian/dists/trixie/mysql-tools/binary-amd64/Packages

This makes #12251 related, and it'll work on debian 12 as expected.

So then the only issue left is the absence in the documentation.

[DaanHoogland]

@ShadowJonathan are you submitting a doc PR?

[ShadowJonathan]

I'm not entirely sure how I can add wording for this into the documentation site, so I don't feel confident to propose a documentation PR, no.

[DaanHoogland]

:) @weizhouapache, any advice?