Control Web Panel

WebPanel => MySQL => Topic started by: megaster55 on March 08, 2025, 06:30:09 PM

Title: mariadb error during update
Post by: megaster55 on March 08, 2025, 06:30:09 PM
Hello, I am using Centos web panel. When I update, I get a warning about Mardiadb, why? also im use vbulletin 3.8.5 Will there be any problems if I upgrade my mariadb version?


(https://i.hizliresim.com/8de4r1o.jpg) (https://hizliresim.com/8de4r1o)
Title: Re: mariadb error during update
Post by: overseer on March 08, 2025, 10:03:50 PM
I would suggest upgrading to MariaDB 10.11 (an LTS version) in the current stream of your 10.x install:
https://endoflife.date/mariadb (https://endoflife.date/mariadb)

Here are directions from a CWP developer:
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/#comment-25 (https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/#comment-25)
Title: Re: mariadb error during update
Post by: megaster55 on March 08, 2025, 10:44:19 PM
that not work
Title: Re: mariadb error during update
Post by: overseer on March 09, 2025, 03:25:38 AM
You tried the correct portion of the instructions for your OS? Which OS are you running?
Title: Re: mariadb error during update
Post by: Starburst on March 09, 2025, 07:11:20 AM
It looks like MariaDB has dropped Red Hat Enterprise Linux 7 support.
And from the look, since you are running 10.3.39, you are running a now unsupported OS.

If you select it, then try to load the different MariaDB versions, it gives an error "An error occured. The mirrors could not be loaded."
https://mariadb.org/download/?t=repo-config&d=Red+Hat+Enterprise+Linux+7 (https://mariadb.org/download/?t=repo-config&d=Red+Hat+Enterprise+Linux+7)

@megaster55 If you are still running CentOS 7, which it looks like you are, you need to upgrade to AlmaLinux 8.

CentOS 7 is past EOL.
Title: Re: mariadb error during update
Post by: megaster55 on March 09, 2025, 01:14:43 PM
@Starburst im use almalinux 8
Title: Re: mariadb error during update
Post by: megaster55 on March 09, 2025, 01:19:39 PM
I install the centos web panel with this method, how should I install it? During the installation, I edit the sh cwp-el8-latest file and write 10.11, but it still installs the 10.39 version.


cd /usr/local/src
wget http://centos-webpanel.com/cwp-el8-latest
sh cwp-el8-latest


Title: Re: mariadb error during update
Post by: Starburst on March 10, 2025, 01:19:55 PM
Try this:
https://starburst.help/common-issues/updated-cwp-installer-script-for-almalinux-8-with-mariadb-10-6/ (https://starburst.help/common-issues/updated-cwp-installer-script-for-almalinux-8-with-mariadb-10-6/)

Then after the installation, upgrade to 10.11
Title: Re: mariadb error during update
Post by: megaster55 on March 11, 2025, 10:41:16 AM
@overseer I tried the method you mentioned but I get this error

(https://i.hizliresim.com/b81k43k.png) (https://hizliresim.com/b81k43k)
Title: Re: mariadb error during update
Post by: overseer on March 11, 2025, 10:49:46 AM
Dunno --I can curl the script down from here:
Code: [Select]
curl -O https://starburst.help/downloads/CWP/cwp-el8-20250215.sh
Title: Re: mariadb error during update
Post by: Starburst on March 11, 2025, 01:07:39 PM
Frak.
You are seeing Cloudflare because of hackers trying to do DDoS attacks.

Need a few.

But let me know if @overseer option works.
Title: Re: mariadb error during update
Post by: Starburst on March 11, 2025, 01:24:29 PM
OK, will be updating the KB.

Use this link:
wget --no-cache http://dl.starburst.help/CWP/cwp-el8-20250215.sh (http://wget --no-cache http://dl.starburst.help/CWP/cwp-el8-20250215.sh)
Title: Re: mariadb error during update
Post by: megaster55 on March 12, 2025, 02:27:42 PM
@Starburst It remains like this

(https://i.hizliresim.com/6dy0g82.jpg) (https://hizliresim.com/6dy0g82)
Title: Re: mariadb error during update
Post by: overseer on March 12, 2025, 02:37:25 PM
If you can curl or wget the fixed installer script to your local workstation, then you can transfer it to the server. (Either via SFTP or a copy/paste the text stream into a new text document with nano on the server.)
Title: Re: mariadb error during update
Post by: Starburst on March 12, 2025, 10:15:55 PM
DOH. Just looked, the text is OK in that link I posted, but the : was missing after http for some reason.

Other than that, I just tried it to a mirror server overseas, and it works OK.
Unless you are trying to connect from a network that is blacklisted.

As @overseer mentioned, try it from your browser
https://dl.starburst.help/CWP/cwp-el8-20250215.sh

You can also just goto https:// or http://dl.starburst.help an goto CWP and then click on it and prompt you to download.
Title: Re: mariadb error during update
Post by: megaster55 on March 13, 2025, 11:19:08 AM
DOH. Just looked, the text is OK in that link I posted, but the : was missing after http for some reason.

Other than that, I just tried it to a mirror server overseas, and it works OK.
Unless you are trying to connect from a network that is blacklisted.

As @overseer mentioned, try it from your browser
https://dl.starburst.help/CWP/cwp-el8-20250215.sh

You can also just goto https:// or http://dl.starburst.help an goto CWP and then click on it and prompt you to download.

Towards the end the server gave such an error. It has 2 CPUand 2GB RAM.

(https://i.hizliresim.com/esfnj6x.jpg) (https://hizliresim.com/esfnj6x)
Title: Re: mariadb error during update
Post by: overseer on March 13, 2025, 09:36:21 PM
2GB of RAM is sub-minimal. True minimal should be 4GB of RAM, with more being more ideal.
Title: Re: mariadb error during update
Post by: megaster55 on March 14, 2025, 05:41:53 PM
2GB of RAM is sub-minimal. True minimal should be 4GB of RAM, with more being more ideal.

I tried it on a server with 8GB RAM - 4 CPU and it gave the same error.

(https://i.hizliresim.com/esfnj6x.jpg) (https://hizliresim.com/esfnj6x)
Title: Re: mariadb error during update
Post by: Starburst on March 15, 2025, 01:33:38 PM
If you don't have a SWAP created you can run into problems, even if you have 2GB or more RAM.

Is this server behind a NAT?
Title: Re: mariadb error during update
Post by: megaster55 on March 16, 2025, 10:17:59 AM
If you don't have a SWAP created you can run into problems, even if you have 2GB or more RAM.

Is this server behind a NAT?

i use for test digitalocean

Also do I need to create a swap like this?
https://linuxize.com/post/how-to-add-swap-space-on-centos-7/
Title: Re: mariadb error during update
Post by: cyberspace on March 16, 2025, 11:03:58 AM
What is SWAP ? SWAP is a technology used to emulate RAM using any item recognized as block device. In other words it "expands" amount of available RAM using disk mounted locally/remotely. However, SWAP isn't so fast as RAM even if SSD/NVMe drives are used for swapping. So huge swap disk has no sense because than more intense SWAP is used by the server/computer than slower the server/computer works.

In case your server has 2Gb of RAM then create SWAP disk (mount a file as a swap disk) of size 2Gb-4Gb (2Gb is recommended).