• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Please beaware of a breaking change in the REST API on the next Plesk release (18.0.62).
    Starting from Plesk Obsidian 18.0.62, requests to REST API containing the Content-Type header with a media-type directive other than “application/json” will result in the HTTP “415 Unsupported Media Type” client error response code. Read more here

Resolved Maria DB update fail, autoupdate no longer works

carini

carini

Basic Pleskian
Server operating system version
Ubuntu 22.04.4 LTS
Plesk version and microupdate number
Plesk Obsidian v18.0.61_build1800240521.14
Autoupdate fail every time with warning mail:

Code: 
Reason: 2024-05-27 06:26:06 INFO: pum is called with arguments: ['--list', '--repo-info', '--json']
2024-05-27 06:29:14 ERROR: Apt cache fetch failed. Try to run the `apt-get update` command.
2024-05-27 06:29:14 ERROR:
2024-05-27 06:29:14 ERROR: Exited with returncode 1.

Problem should be on Maria DB update source

Code: 
root@plesk81:~# cat /etc/apt/sources.list.d/mariadb.list


# 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/ubuntu jammy main
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu jammy main/debug

# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main

Where https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu is no longer valid.

This is the second server with this problem, pure stock, no custom repos, freshly rebooted.

Anyone with the same problem? Is a Ubuntu-specific bug?
 
Replaced: ...

Code: 
root@plesk:/etc/apt/sources.list.d# diff /root/rollback/etc/apt/sources.list.d/mariadb.list_2024-05-27 ./mariadb.list
0a1
> # MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC
2,7c3,7
< # 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/ubuntu jammy main
<
< deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu jammy main/debug
<
---
> # https://mariadb.org/download/
> # deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
> deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu jammy main
> # deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
> # deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
10a11
>

New file is:

Code: 
root@plesk:/etc/apt/sources.list.d# cat ./mariadb.list
# MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC


# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu jammy main
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main


# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main

We have to expect the same issue on all of our servers?
 
carini said:
Replaced: ...

Code: 
root@plesk:/etc/apt/sources.list.d# diff /root/rollback/etc/apt/sources.list.d/mariadb.list_2024-05-27 ./mariadb.list
0a1
> # MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC
2,7c3,7
< # 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/ubuntu jammy main
<
< deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu jammy main/debug
<
---
> # https://mariadb.org/download/
> # deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
> deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu jammy main
> # deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
> # deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
10a11
>

New file is:

Code: 
root@plesk:/etc/apt/sources.list.d# cat ./mariadb.list
# MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC


# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu jammy main
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main


# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main

We have to expect the same issue on all of our servers?
Click to expand...


Sorry for the late Reply:

Attention Carini:

in my case I need the arch=amd64,arm64 property otherwise i receive the next error , receive after apt-get update !
 
Thanks for your suggestion. Now reads

Code: 
root@plesk81:~# cat /etc/apt/sources.list.d/mariadb.list
# MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC

# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
deb [arch=amd64] https://deb.mariadb.org/10.11/ubuntu jammy main
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main

# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main
 
carini said:
Thanks for your suggestion. Now reads

Code: 
root@plesk81:~# cat /etc/apt/sources.list.d/mariadb.list
# MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC

# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
deb [arch=amd64] https://deb.mariadb.org/10.11/ubuntu jammy main
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main

# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main
Click to expand...


Good Morning,

No you misunderstood me,

my mariadb.list

Code: 
# MariaDB 10.11 repository list - created 2024-05-27 14:01 UTC
# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu focal main
deb [arch=amd64,arm64 signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.digitalnova.at/mariadb/repo/10.11/ubuntu focal main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.digitalnova.at/mariadb/repo/10.11/ubuntu focal main

# MariaDB MaxScale
# To use the latest stable release of MaxScale, use "latest" as the version
# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/maxscale/latest/apt focal main

# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu focal main
 
Apart from MaxScale, which I am unsure if it is supported under Plesk, why include arm64?

The signed-by option also confuses me. I have noticed that some repositories are configured to use it, while others are not. It seems to be really necessary only if you are upgrading from third-party repositories.
 
i hope it is supported , i copy paste MaxScale from my original mariadb.list

I think arm64 could be omitted, but it was in the original file, so I included it.
 
Bonjour tout le monde,
nous avons exactement les mêmes erreurs
installation :
PLESK OBSIDIAN 18.0.61
DEBIAN 10.13

auriez vous une solution pour moi ? merci

voici mon fichier mariadb.list

[Courtesy translation by Admin]
Hello everyone,
we have exactly the same errors
installation:
PLESK OBSIDIAN 18.0.61
DEBIAN 10.13

would you have a solution for me? thank you

here is my mariadb.list file

Code: 
# 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.6/repo/debian buster main


# MariaDB MaxScale
# To use the latest stable release of MaxScale, use "latest" as the version
# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/maxscale/latest/apt buster main


# MariaDB Tools
deb [arch=amd64] Tools/debian/ - MariaDB buster main
 
Last edited by a moderator:
Merci Kaspar,
mais est ce que je peux remplacer les éléments de mon mariadb.list par celui de Carini même si sur le mien il y a ..../10.6/repo/debian et pas ubuntu
?

[courtesy translation by Admin]
but can I replace the items in my mariadb.list with Carini's even though mine has ..../10.6/repo/debian and not ubuntu?
 
Last edited by a moderator:
@learning.neo the official forum language is English. Please use a translator like DeepL to translate posts before posting them. That way other users can read and react too.

learning.neo said:
[courtesy translation by Admin]
but can I replace the items in my mariadb.list with Carini's even though mine has ..../10.6/repo/debian and not ubuntu?
Click to expand...
No. Use this link to get the right repositories for Ubuntu which you can use in your mariadb.list configration: Download MariaDB Server - MariaDB.org
 
Good morning

I did the test yesterday on one of our VPS by generating my configuration files from your link
and this morning no error message
Thank you again for your help
I will apply this to our 2 other VPS

Have a good day
 
Hello everyone, I have an ubuntu 20.04 server and when I add the new repo I get an error sayting it can't be verified.

This is the content of the mariadb.list

# 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/ubuntu focal main
deb [arch=amd64,arm64, signed-by=/etc/apt/keyrings/mariadb-keyring.php] Index of /mariadb/repo/10.11/ubuntu focal main

#deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu focal main/debug


# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu focal main


This is the error when I run apt-get update

W: GPG error: Index of /mariadb/repo/10.11/ubuntu focal InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY F1656F24C74CD1D8
E: The repository 'Index of /mariadb/repo/10.11/ubuntu focal InRelease' is not signed.

I tried to add the key buy running this command

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys F1656F24C74CD1D8

But that did not fix the issue

Any idea?

Thanks in advance!
 
dgarcia90 said:
Hello everyone, I have an ubuntu 20.04 server and when I add the new repo I get an error sayting it can't be verified.

This is the content of the mariadb.list

# 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/ubuntu focal main
deb [arch=amd64,arm64, signed-by=/etc/apt/keyrings/mariadb-keyring.php] Index of /mariadb/repo/10.11/ubuntu focal main

#deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu focal main/debug


# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu focal main


This is the error when I run apt-get update

W: GPG error: Index of /mariadb/repo/10.11/ubuntu focal InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY F1656F24C74CD1D8
E: The repository 'Index of /mariadb/repo/10.11/ubuntu focal InRelease' is not signed.

I tried to add the key buy running this command

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys F1656F24C74CD1D8

But that did not fix the issue

Any idea?

Thanks in advance!
Click to expand...
Update: removing the "signed-by=/etc/apt/keyrings/mariadb-keyring.php" part fixed the issue for me
 
You must log in or register to reply here.

Similar threads

brainforge
Resolved System updates have started failing.
Replies
2
Views
691
brainforge
brainforge
Jan Bludau
Issue Updating Debian 10 to 11
Replies
1
Views
871
Jan Bludau
Jan Bludau
T
Resolved Grafana fails: Option '[alerting].enabled' cannot be true. Legacy Alerting is removed. It is no longer deployed, enhanced, or supported.
Replies
10
Views
389
theunknownstuntman
T
C
Resolved Mariadb not working - DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
7
Views
406
Crash79797
C
S
Issue Getting 404 Not Found NGINX error, not able to access plesk and website went down after update
Replies
2
Views
937
Dave W
Dave W
Back
Top