MySQL 8 repo not available for Bookworm yet

[darden]

Hi there,
Just to point that MySQL 8 won't install with latest script and Debian 12. There is no MySQL 8 repo for Bookworm yet:
http://repo.mysql.com/apt/debian/dists/

Tried editing script with Bullseye repo for MySQL 8, but then, dependencies for mysql won't be resolved in Debian 12 (if i did correctly).

[myVesta]

If official MySQL didn't make a build for Bookworm, what can we do?

[darden]

Yeah, not a MyVestaCP issue , just wanted to share it just in case some other tried to install it with D12.

[myVesta]

It will be nice if somebody tries to install Bullseye mysql8 build on Bookworm... maybe it will work

For faster probing, do it on clean Bookworm, without myVesta, just manually copy-paste this piece of code: (copy and run each line/block):

Code: Select all

    codename='bullseye'

    echo "### THIS FILE IS AUTOMATICALLY CONFIGURED ###" > /etc/apt/sources.list.d/mysql.list
    echo "# You may comment out entries below, but any other modifications may be lost." >> /etc/apt/sources.list.d/mysql.list
    echo "# Use command 'dpkg-reconfigure mysql-apt-config' as root for modifications." >> /etc/apt/sources.list.d/mysql.list
    echo "deb http://repo.mysql.com/apt/debian/ $codename mysql-apt-config" >> /etc/apt/sources.list.d/mysql.list
    echo "deb http://repo.mysql.com/apt/debian/ $codename mysql-8.0" >> /etc/apt/sources.list.d/mysql.list
    echo "deb http://repo.mysql.com/apt/debian/ $codename mysql-tools" >> /etc/apt/sources.list.d/mysql.list
    echo "#deb http://repo.mysql.com/apt/debian/ $codename mysql-tools-preview" >> /etc/apt/sources.list.d/mysql.list
    echo "deb-src http://repo.mysql.com/apt/debian/ $codename mysql-8.0" >> /etc/apt/sources.list.d/mysql.list

    # apt-key adv --keyserver pgp.mit.edu --recv-keys 3A79BD29
    key="467B942D3A79BD29"
    readonly key
    GNUPGHOME="$(mktemp -d)"
    export GNUPGHOME
    for keyserver in $(shuf -e ha.pool.sks-keyservers.net hkp://p80.pool.sks-keyservers.net:80 keyserver.ubuntu.com hkp://keyserver.ubuntu.com:80)
    do
        gpg --keyserver "${keyserver}" --recv-keys "${key}" 2>&1 && break
    done
    gpg --export "${key}" > /etc/apt/trusted.gpg.d/mysql.gpg
    gpgconf --kill all
    rm -rf "${GNUPGHOME}"
    unset GNUPGHOME
    
    mpass='somerandompass' # change it
    
    debconf-set-selections <<< "mysql-community-server mysql-community-server/root-pass password $mpass"
    debconf-set-selections <<< "mysql-community-server mysql-community-server/re-root-pass password $mpass"
    debconf-set-selections <<< "mysql-community-server mysql-server/default-auth-override select Use Legacy Authentication Method (Retain MySQL 5.x Compatibility)"

    apt-get update
    apt-get -y install mysql-server mysql-client mysql-common
   
    echo -e "[client]\npassword='$mpass'\n" > /root/.my.cnf
    chmod 600 /root/.my.cnf
    mysqladmin -u root password $mpass
    
    systemctl enable mysql
    systemctl start mysql
 

[darden]

I'm messing at the moment with containers, i'll do it with a fresh D12 one.

[darden]

Done, it fails because there is no libssl1.1 in Bookworm (it comes with libssl3).

Code: Select all

Los siguientes paquetes tienen dependencias incumplidas:
 mysql-community-client : 
 	Depende: libssl1.1 (>= 1.1.1) pero no es instalable
        Depende: mysql-community-client-core (= 8.0.34-1debian11) pero no va a instalarse
 mysql-community-server-core : 
 	Depende: libssl1.1 (>= 1.1.1) pero no es instalable
        Recomienda: mecab-ipadic-utf8 pero no va a instalarse
 

Getting libssl1.1 from Bullseye did the trick:
https://packages.debian.org/bullseye/am ... 1/download

Code: Select all

wget http://security.debian.org/debian-security/pool/updates/main/o/openssl/libssl1.1_1.1.1n-0+deb11u5_amd64.deb
sudo dpkg -i libssl1.1_1.1.1n-0+deb11u5_amd64.deb
sudo apt-get -f install

So, seems like the only dependency for bookworm to install mysql-server & mysql-client from bullseye was libssl1.1 if i'm not missing something.
Anyways, not sure about the consequences of having both libssl1.1 and libssl3 on bookworm.