MariaDB repository fail

[mikafouenski]

✅ Have you read and understood the above guidelines?

yes

📜 What is the name of the script you are using?

Shinobi

📂 What was the exact command used to execute the script?

bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/ct/shinobi.sh)"

⚙️ What settings are you using?

• Default Settings
• Advanced Settings

🖥️ Which Linux distribution are you using?

Debian 12

📝 Provide a clear and concise description of the issue.

Hello 👋

While installing Shinobi, the script is failing at the MariaDB install stage.

🔄 Steps to reproduce the issue.

Just try to install any script using the MariaDB snippet.
https://github.com/community-scripts/ProxmoxVE/blob/main/misc/tools.func#L226

eg: Shinobi

❌ Paste the full error output (if available).

  ✔️  Latest GA MariaDB version is 12.0.1
Hit:1 http://archive.ubuntu.com/ubuntu jammy InReleasery 
Ign:2 http://mirror.mariadb.org/repo/12.0.1/debian jammy InRelease
Hit:3 http://archive.ubuntu.com/ubuntu jammy-updates InRelease
Hit:4 https://deb.nodesource.com/node_22.x nodistro InRelease       
Hit:5 http://archive.ubuntu.com/ubuntu jammy-security InRelease     
Err:6 http://mirror.mariadb.org/repo/12.0.1/debian jammy Release
  404  Not Found [IP: 162.55.42.214 80]
Reading package lists... Done
E: The repository 'http://mirror.mariadb.org/repo/12.0.1/debian jammy Release' does not have 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.
 ⠧
[ERROR] in line 276: exit code 0: while executing command $STD apt-get update
/dev/fd/63: line 74: SPINNER_PID: unbound variable

🖼️ Additional context (optional).

jammy doesn't appear to be valid for the /debian subpath.

Replacing the sourcelist with the bookworm distrib will fix the issue:

$ cat /etc/apt/sources.list.d/mariadb.list
deb [signed-by=/etc/apt/trusted.gpg.d/mariadb.gpg] http://mirror.mariadb.org/repo/12.0.1/debian bookworm main

OR
Use the /ubuntu subpath for the ubuntu distrib:

(It's "probably" the same package either way)

Thank you for the scripts, they are really neat. 🙂

[Gormandy]

I'm also having difficulties with mariadb trying to set up Gatus and Wordpress; I think something is going on with their repo right now... The specific error I'm getting is due to hash and filesize discrepancies - I'm on bookworm / Proxmox 8.4.1 so I'm not having the same issues you are with jammy. Regardless I thought it might be useful to include these issues here since it's related to MariaDB and might point to a repository issue vs a issue with the code.

Err:38 http://mirror.mariadb.org/repo/12.0.1/debian bookworm/main amd64 mariadb-server amd64 1:12.0.1+maria~deb12
  Hash Sum mismatch
  Hashes of expected file: 
   - SHA256:91b4344e27f127f86e4e848f168f979ba2799c59f7c940d40e8521eee9633a24
   - SHA1:62cc451dc7e536ec3694fadfd51a75056c36ffc5 [weak]
   - MD5Sum:3edf89d43c6d47d4a6c6cb0ed41e9e09 [weak]
   - Filesize:3812104 [weak]
  Hashes of received file:
   - SHA256:c79d44adcbed9e057c26248b1cd779e40147f69e5dcb74d96f2d18f2fcbf57ca
   - SHA1:f980da50513046f6d71521e6cbfb2fd0cd3ee2c4 [weak]
   - MD5Sum:06078ac3bd85058c447c28c0a85b9a7a [weak]
   - Filesize:3812104 [weak]
  Last modification reported: Wed, 28 May 2025 03:01:11 +0000
Get:39 http://mirror.mariadb.org/repo/12.0.1/debian bookworm/main amd64 mariadb-client-compat all 1:12.0.1+maria~deb12 [4,520 B]
Get:40 http://mirror.mariadb.org/repo/12.0.1/debian bookworm/main amd64 mariadb-server-compat all 1:12.0.1+maria~deb12 [3,412 B]
Err:40 http://mirror.mariadb.org/repo/12.0.1/debian bookworm/main amd64 mariadb-server-compat all 1:12.0.1+maria~deb12
  File has unexpected size (4520 != 3412). Mirror sync in progress? [IP: 172.16.0.10 3142]
  Hashes of expected file:
   - SHA256:c1943ed5b0598e2d1b37e059b5ab8aafced8152bbbc3ea218839ba2b094553f0
   - SHA1:310a0e44b1d6b1d4ecc47a100572ecdbd51b22a4 [weak]
   - MD5Sum:7ca73ed7aa71f27b976dab03bbca0802 [weak]
   - Filesize:3412 [weak]
Fetched 18.9 MB in 3s (7,562 kB/s)           
E: Failed to fetch http://mirror.mariadb.org/repo/12.0.1/debian/pool/main/g/galera-4/galera-4_26.4.22-deb12_amd64.deb  File has unexpected size (4188 != 11871404). Mirror sync in progress? [IP: 172.16.0.10 3142]
   Hashes of expected file:
    - SHA256:a670834ce2008b0877d460b94ffe8e3869a855dfd5d3049be3723c32073ae72b
    - SHA1:f9862a11cb14044de6ffe6e657f71c0cc02ff537 [weak]
    - MD5Sum:77505ccebca23b6bd54f95f073ec216b [weak]
    - Filesize:11871404 [weak]
E: Failed to fetch http://mirror.mariadb.org/repo/12.0.1/debian/pool/main/m/mariadb/libmariadb3_12.0.1%2bmaria%7edeb12_amd64.deb  File has unexpected size (4188 != 160444). Mirror sync in progress? [IP: 172.16.0.10 3142]
   Hashes of expected file:
    - SHA256:bbb66b607168fde6f65f543c556098331708aff867d4f56dfb10f60d608b83b0
    - SHA1:0fca252d4982a93b5985b4490443b98e0a0841bb [weak]
    - MD5Sum:0cca24e6c0207511532a053b30167948 [weak]
    - Filesize:160444 [weak]
E: Failed to fetch http://mirror.mariadb.org/repo/12.0.1/debian/pool/main/m/mariadb/mariadb-client-core_12.0.1%2bmaria%7edeb12_amd64.deb  File has unexpected size (4188 != 884888). Mirror sync in progress? [IP: 172.16.0.10 3142]
   Hashes of expected file:
    - SHA256:0580180135463f8983446fefdded0f71b9d6850c4d3ed33035197ab4b94f2b19
    - SHA1:168430aee95151b6c5b507da2077478712b198d7 [weak]
    - MD5Sum:35ffa9839cedf83a554db558716b61b4 [weak]
    - Filesize:884888 [weak]
E: Failed to fetch http://mirror.mariadb.org/repo/12.0.1/debian/pool/main/m/mariadb/mariadb-server_12.0.1%2bmaria%7edeb12_amd64.deb  Hash Sum mismatch
   Hashes of expected file:
    - SHA256:91b4344e27f127f86e4e848f168f979ba2799c59f7c940d40e8521eee9633a24
    - SHA1:62cc451dc7e536ec3694fadfd51a75056c36ffc5 [weak]
    - MD5Sum:3edf89d43c6d47d4a6c6cb0ed41e9e09 [weak]
    - Filesize:3812104 [weak]
   Hashes of received file:
    - SHA256:c79d44adcbed9e057c26248b1cd779e40147f69e5dcb74d96f2d18f2fcbf57ca
    - SHA1:f980da50513046f6d71521e6cbfb2fd0cd3ee2c4 [weak]
    - MD5Sum:06078ac3bd85058c447c28c0a85b9a7a [weak]
    - Filesize:3812104 [weak]
   Last modification reported: Wed, 28 May 2025 03:01:11 +0000
E: Failed to fetch http://mirror.mariadb.org/repo/12.0.1/debian/pool/main/m/mariadb/mariadb-server-compat_12.0.1%2bmaria%7edeb12_all.deb  File has unexpected size (4520 != 3412). Mirror sync in progress? [IP: 172.16.0.10 3142]
   Hashes of expected file:
    - SHA256:c1943ed5b0598e2d1b37e059b5ab8aafced8152bbbc3ea218839ba2b094553f0
    - SHA1:310a0e44b1d6b1d4ecc47a100572ecdbd51b22a4 [weak]
    - MD5Sum:7ca73ed7aa71f27b976dab03bbca0802 [weak]
    - Filesize:3412 [weak]
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?
 ⠋
[ERROR] in line 277: exit code 0: while executing command $STD apt-get install -y mariadb-server mariadb-client
 ⠙/dev/fd/63: line 74: SPINNER_PID: unbound variable

[tremor021]

Its possible mirror sync in progress. Just try sometime later.

Also, don't tag repo errors as script bugs. Thanks

[Dosepower]

so we just have to wait i get the same error

[Gormandy]

Yeah I'd give it like 24h or so

[mikafouenski]

What I meant is that it's not a repo error.
The MariaDB snippet from proxmoxVE script need to be modified.

This line: https://github.com/community-scripts/ProxmoxVE/blob/main/misc/tools.func#L273

Force the /debian repo path regardless of the distribution. Which won't work for bad mix match.

You might want to parametrize the path with the distrib name, much like you did in :
https://github.com/community-scripts/ProxmoxVE/blob/main/misc/tools.func#L229
But with the Distribution field

[MrPenguin07]

This issue is as described by @mikafouenski and remains ongoing.

[MickLesk]

Maybe fixed today, currently im a little bit ill and not very active (this week)

[tremor021]

@MickLesk i got you. Fixed after #5138 merges

[MrPenguin07]

Confirmed fixed.
Well done.