Failed to install due to invalid apt repo source (mariadb) https required #387

Closed
opened 2026-04-05 20:27:25 +02:00 by MrUnknownDE · 0 comments
Owner

Originally created by @decryptedchaos on 6/8/2023

CloudPanel version(s) affected

2.3.0

Description

This is in reference to issue #269

UPDATE:
I switched to Debian 11 (Which i really didn't want to do because its not really LTS) to avoid the release upgrade as a test and the issue is still there resulting from this error it seams

Ign:4 https://mirror.its.dal.ca/mariadb/mariadb-10.11.4/repo/debian bullseye InRelease
Err:7 https://mirror.its.dal.ca/mariadb/mariadb-10.11.4/repo/debian bullseye Release
404 Not Found [IP: 192.75.96.254 443]
Reading package lists... Done
E: The repository 'http://mirror.mariadb.org/repo/10.11/debian bullseye Release' no longer has a Release file.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.

To work around this I needed to change the mariadb.list to the following

# MariaDB Server
# To use a different major version of the server, or to pin to a specific minor version, change URI below.
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/debian bullseye main

P.S you also need to import the keys i used maria's bash script that does it for me so use that or manually import the keys

if you don't do this before running install.sh it will likely fail (and you may need to chattr +i /etc/apt/sources.d/mariadb.list) so the script cant change it

Originally posted by @decryptedchaos in https://github.com/cloudpanel-io/cloudpanel-ce/issues/269#issuecomment-1581058841

How to reproduce

Simply install using MariaDB 10.11 using the instructions in the docs

Possible Solution

UPDATE 2

Upon further investigating, this seems to be caused by missing https:// in the provided mariadb.list

In the install.sh on line 217 you will find this block, it adds http://mirror.mariadb.org/** this is where the problem lies. change it to https://** beefore running install.sh and it should work..

installMySQL()
{
  addAptSourceList

  if [ "$OS_NAME" = "Debian" ]; then
    case $DB_ENGINE in
      "MYSQL_5.7")
        echo "deb https://$ORIGIN/ $OS_CODE_NAME percona-server-server-5.7" > /etc/apt/sources.list.d/percona-mysql.list
        apt -y update
        DEBIAN_FRONTEND=noninteractive apt -y install percona-server-client-5.7 percona-server-server-5.7
      ;;
      "MYSQL_8.0")
        echo "deb https://$ORIGIN/ $OS_CODE_NAME percona-server-server-8.0" > /etc/apt/sources.list.d/percona-mysql.list
        apt -y update
        DEBIAN_FRONTEND=noninteractive apt -y install percona-server-client percona-server-server
      ;;
      "MARIADB_10.6")
        wget -qO- https://mariadb.org/mariadb_release_signing_key.asc | gpg --dearmor > /etc/apt/trusted.gpg.d/mariadb.gpg
        echo "deb [arch=amd64,arm64] http://mirror.mariadb.org/repo/10.6/debian bullseye main" > /etc/apt/sources.list.d/mariadb.list
        apt -y update
        apt -y install mariadb-server
      ;;
      "MARIADB_10.11")
        wget -qO- https://mariadb.org/mariadb_release_signing_key.asc | gpg --dearmor > /etc/apt/trusted.gpg.d/mariadb.gpg
        echo "deb [arch=amd64,arm64] http://mirror.mariadb.org/repo/10.11/debian bullseye main" > /etc/apt/sources.list.d/mariadb.list
        apt -y update
        apt -y install mariadb-server
      ;;
      *)
        die "Database Engine $DB_ENGINE not supported."
      ;;
    esac
  else
    case $DB_ENGINE in
      "MYSQL_8.0")
        apt -y update
        DEBIAN_FRONTEND=noninteractive apt -y install mysql-client-8.0 mysql-server-8.0
      ;;
     "MARIADB_10.6")
       apt -y update
       apt -y install mariadb-server
     ;;
     "MARIADB_10.11")
       wget -qO- https://mariadb.org/mariadb_release_signing_key.asc | gpg --dearmor > /etc/apt/trusted.gpg.d/mariadb.gpg
       echo "deb [arch=amd64,arm64] http://mirror.mariadb.org/repo/10.11/ubuntu/ jammy main" > /etc/apt/sources.list.d/mariadb.list
       apt -y update
       apt -y install mariadb-server
     ;;
      *)
        die "Database Engine $DB_ENGINE not supported."
      ;;
      esac
  fi
}

Additional Context

This was incredibly aggravating i was very close to just giving up on this software as nice as it seems

Please fix your install script, i want to add here to the developers of this software.. you have chosen to make this software non-open source which is your choice and you have been generous enough to provide it free this does not go un-noticed i assure you..

However, with that said.. fixing these issues therefore does fall upon you to fix, we, the community can't legally do so as per your license agreement..

Thanks

*Originally created by @decryptedchaos on 6/8/2023* ### CloudPanel version(s) affected 2.3.0 ### Description This is in reference to issue #269 **UPDATE:** I switched to Debian 11 (Which i really didn't want to do because its not really LTS) to avoid the release upgrade as a test and the issue is still there resulting from this error it seams Ign:4 https://mirror.its.dal.ca/mariadb/mariadb-10.11.4/repo/debian bullseye InRelease Err:7 https://mirror.its.dal.ca/mariadb/mariadb-10.11.4/repo/debian bullseye Release 404 Not Found [IP: 192.75.96.254 443] Reading package lists... Done E: The repository 'http://mirror.mariadb.org/repo/10.11/debian bullseye Release' no longer has a Release file. N: Updating from such a repository can't be done securely, and is therefore disabled by default. N: See apt-secure(8) manpage for repository creation and user configuration details. To work around this I needed to change the mariadb.list to the following ``` # MariaDB Server # To use a different major version of the server, or to pin to a specific minor version, change URI below. deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/debian bullseye main ``` P.S you also need to import the keys i used maria's bash script that does it for me so use that or manually import the keys if you don't do this before running install.sh it will likely fail (and you may need to chattr +i /etc/apt/sources.d/mariadb.list) so the script cant change it _Originally posted by @decryptedchaos in https://github.com/cloudpanel-io/cloudpanel-ce/issues/269#issuecomment-1581058841_ ### How to reproduce Simply install using MariaDB 10.11 using the instructions in the docs ### Possible Solution **UPDATE 2** Upon further investigating, this seems to be caused by missing https:// in the provided mariadb.list In the install.sh on line 217 you will find this block, it adds http://mirror.mariadb.org/** this is where the problem lies. change it to https://** beefore running install.sh and it should work.. ``` installMySQL() { addAptSourceList if [ "$OS_NAME" = "Debian" ]; then case $DB_ENGINE in "MYSQL_5.7") echo "deb https://$ORIGIN/ $OS_CODE_NAME percona-server-server-5.7" > /etc/apt/sources.list.d/percona-mysql.list apt -y update DEBIAN_FRONTEND=noninteractive apt -y install percona-server-client-5.7 percona-server-server-5.7 ;; "MYSQL_8.0") echo "deb https://$ORIGIN/ $OS_CODE_NAME percona-server-server-8.0" > /etc/apt/sources.list.d/percona-mysql.list apt -y update DEBIAN_FRONTEND=noninteractive apt -y install percona-server-client percona-server-server ;; "MARIADB_10.6") wget -qO- https://mariadb.org/mariadb_release_signing_key.asc | gpg --dearmor > /etc/apt/trusted.gpg.d/mariadb.gpg echo "deb [arch=amd64,arm64] http://mirror.mariadb.org/repo/10.6/debian bullseye main" > /etc/apt/sources.list.d/mariadb.list apt -y update apt -y install mariadb-server ;; "MARIADB_10.11") wget -qO- https://mariadb.org/mariadb_release_signing_key.asc | gpg --dearmor > /etc/apt/trusted.gpg.d/mariadb.gpg echo "deb [arch=amd64,arm64] http://mirror.mariadb.org/repo/10.11/debian bullseye main" > /etc/apt/sources.list.d/mariadb.list apt -y update apt -y install mariadb-server ;; *) die "Database Engine $DB_ENGINE not supported." ;; esac else case $DB_ENGINE in "MYSQL_8.0") apt -y update DEBIAN_FRONTEND=noninteractive apt -y install mysql-client-8.0 mysql-server-8.0 ;; "MARIADB_10.6") apt -y update apt -y install mariadb-server ;; "MARIADB_10.11") wget -qO- https://mariadb.org/mariadb_release_signing_key.asc | gpg --dearmor > /etc/apt/trusted.gpg.d/mariadb.gpg echo "deb [arch=amd64,arm64] http://mirror.mariadb.org/repo/10.11/ubuntu/ jammy main" > /etc/apt/sources.list.d/mariadb.list apt -y update apt -y install mariadb-server ;; *) die "Database Engine $DB_ENGINE not supported." ;; esac fi } ``` ### Additional Context This was incredibly aggravating i was very close to just giving up on this software as nice as it seems Please fix your install script, i want to add here to the developers of this software.. you have chosen to make this software non-open source which is your choice and you have been generous enough to provide it free this does not go un-noticed i assure you.. However, with that said.. fixing these issues therefore does fall upon you to fix, we, the community can't legally do so as per your license agreement.. Thanks
Sign in to join this conversation.