Messages

31

MySQL / Re: MARIADB10.4.0 to 10.10.0

« on: October 05, 2024, 04:35:00 AM »

I would redo your mariadb.repo, and put in the info for RHEL 8, you can find this at:

https://mariadb.org/download/?t=repo-config

You can also select the closest mirror to your location.

If using AL8, you really should be using dnf, instead of yum, just to get use to the newer stuff.

I jusdt setup dnf automatic

32

MySQL / Re: MARIADB10.4.0 to 10.10.0

« on: October 04, 2024, 05:11:14 PM »

Thanks

33

MySQL / Re: MARIADB10.4.0 to 10.10.0

« on: October 04, 2024, 07:08:16 AM »

MariaDB 10.4.x is past EOL.

10.11.x works on AlmaLinux 8.10 and 9.4 without problems.

Curious why you haven't updated to 8.10 for the security fixes.

I run update and upgrade all the time. I do all the yum updates as well but it's a production vps with lots of sites on it and can't afford for it to be down.

34

MySQL / Re: MARIADB10.4.0 to 10.10.0

« on: October 04, 2024, 06:16:14 AM »

1. MariaDB 10.10.is EOL. It is better to upgrade MariaDB to 10.6 or 10.11.

2. Centos 8 aren't supported by MariaDB. It is EOL too.

You can upgrade MariaDB on Centos 8 to 10.10 still, but you need to download the binary packages (RPM) and install them manually. So I recommend you to upgrade MariaDB to 10.6 following the instructions:
https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4
with minor changes.

I run almalinux 8.9 not centos. I solved it by using a snapshot from the day before.

35

CentOS-WebPanel GUI / Known Issue???

« on: October 04, 2024, 06:14:07 AM »

All of a sudden tonight my cwp user panels won't load, they just hang there but if I do a domain.com:20893/user/ I get a 500 error like this?

This page isn’t working
viking.dragocom.xyz is currently unable to handle this request.

HTTP ERROR 500

I have restarted cwp root admin panel which works fine but cwp user panel does not.

36

MySQL / Re: MARIADB10.4.0 to 10.10.0

« on: October 03, 2024, 05:54:34 AM »

I have a snapshot from last night with Contabo:
SnapShot 10-2-24   02.10.2024 08:06

37

MySQL / Re: MARIADB10.4.0 to 10.10.0

« on: October 03, 2024, 05:45:05 AM »

I can't just re-install 10.4 again?

38

MySQL / Re: MARIADB10.4.0 to 10.10.0

« on: October 03, 2024, 05:30:10 AM »

It looks like it's still trying to install 10.4 anyway after doing those commands on that page. I can't install laravel without incresing to 10.10

[root@viking ~]# mysql -V
mysql  Ver 15.1 Distrib 10.4.34-MariaDB, for Linux (x86_64) using readline 5.1
[root@viking ~]# cat /etc/redhat-release
AlmaLinux release 8.10 (Cerulean Leopard)
[root@viking ~]# mysqldump –all-databases > /tmp/all-database-backup.sql
mysqldump: Got error: 1049: "Unknown database '–all-databases'" when selecting the database
[root@viking ~]# rpm -qa|grep -i maria|grep "\-10.4."
MariaDB-devel-10.4.34-1.el8.x86_64
MariaDB-common-10.4.34-1.el8.x86_64
MariaDB-client-10.4.34-1.el8.x86_64
MariaDB-server-10.4.34-1.el8.x86_64
MariaDB-shared-10.4.34-1.el8.x86_64
[root@viking ~]# sed -i 's/10.4/10.10/g' /etc/yum.repos.d/mariadb.repo
[root@viking ~]# systemctl stop mariadb mysql mysqld
[root@viking ~]# systemctl disable mariadb
Removed /etc/systemd/system/multi-user.target.wants/mariadb.service.
Removed /etc/systemd/system/mysql.service.
Removed /etc/systemd/system/mysqld.service.
[root@viking ~]# rpm --nodeps -ev MariaDB-server
Preparing packages...
MariaDB-server-10.4.34-1.el8.x86_64
[root@viking ~]# yum clean all
81 files removed
[root@viking ~]# yum -y update "MariaDB-*"
CentOS Web Panel repo for Linux 8 - x86_64                                                                                                                  1.7 MB/s | 305 kB     00:00
AlmaLinux 8 - BaseOS                                                                                                                                         13 MB/s | 7.4 MB     00:00
AlmaLinux 8 - AppStream                                                                                                                                      19 MB/s |  13 MB     00:00
AlmaLinux 8 - Extras                                                                                                                                         31 kB/s |  13 kB     00:00
AlmaLinux 8 - PowerTools                                                                                                                                    7.0 MB/s | 3.7 MB     00:00
AlmaLinux 8 - PowerTools Source                                                                                                                             108 kB/s | 138 kB     00:01
AlmaLinux 8 - PowerTools debuginfo                                                                                                                          666 kB/s | 610 kB     00:00
Extra Packages for Enterprise Linux 8 - x86_64                                                                                                               22 MB/s |  14 MB     00:00
MariaDB                                                                                                                                                      52  B/s |  10  B     00:00
Errors during downloading metadata for repository 'mariadb':
  - Status code: 404 for http://mirror.mariadb.org/yum/10.10/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)
Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@viking ~]# yum -y install MariaDB-server
MariaDB                                                                                                                                                      53  B/s |  10  B     00:00
Errors during downloading metadata for repository 'mariadb':
  - Status code: 404 for http://mirror.mariadb.org/yum/10.10/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)
Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@viking ~]# systemctl enable mariadb
Failed to enable unit: Unit file mariadb.service does not exist.
[root@viking ~]# systemctl start mariadb

39

MySQL / MARIADB10.4.0 to 10.10.0

« on: October 03, 2024, 04:11:07 AM »

Will this method still work to go from 10.4 to 10.10?

https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4

40

DNS / DNS Issue?

« on: August 29, 2024, 02:54:56 AM »

My site keeps saying it can't be found, this site is not secure even though I have an autossl cert that is valid.or sometimes it will say too many redirects. I am running Xenforo on the site...


The page isn’t redirecting properly

LibreWolf has detected that the server is redirecting the request for this address in a way that will never complete.

    This problem can sometimes be caused by disabling or refusing to accept cookies.

In CWP...

Checking DNS Zone Record for Domain: blah.com   
Checking Zone File: /var/named/blah.com.db

/var/named/blah.com.db:28: file does not end with newline
zone blah.com/IN: loaded serial 2013071600
OK

41

Suggestions / Re: So here we are at EOL's

« on: August 07, 2024, 12:41:00 AM »

Have to say, never seen someone reserve 3GB for PHP before.

The normal recommended is usually only 512M

Also a 2GB limit on uploads, interesting.

Why is the max execution time 100 mins.?
If a script goes rouge, and locks, waiting 1.67 hours for it to timeout seems a little long.

But to each their own.

3GB because there is 6 sites on the server and it won't hurt to allow each one some wiggle room. As for 512mb ram that's old school memory rates, that's like saying lets run an AMD Ryzen 9 with 512MB ram hehe.

2GB limit because a lot of my sites are download/upload file sharing and some files are as high as 1.7gb or so. Hence the reason for 6000 because uploading through php times out way to quickly.

I run file sharing, I run XF/IPS forums, these type of sites require higher resources than the typical wordpress or html5 site. I don't have strangers on my box, it is me and one other person with 6 sites.

42

Suggestions / Re: So here we are at EOL's

« on: August 06, 2024, 09:34:34 PM »

What is your memory_limit = line set to?

Do you have a screenshot of that.

You should see the format of the csf.pignore, and just add to the bottom.

43

Suggestions / Re: So here we are at EOL's

« on: August 06, 2024, 08:13:29 PM »

Raise up your mem_Limit under: PHP Settings -> PHP Simple Editor

Also those LFD emails will tell you what program is causing the problem, and you can add it to

Code: [Select]

nano /etc/csf/csf.pignore

exe:/usr/sbin/varnishd
exe:/usr/sbin/nginx
exe:/usr/sbin/mariadbd
exe:/usr/sbin/redis
exe:/usr/bin/redis-server
exe:/opt/alt/php-fpm72/usr/sbin/php-fpm
exe:/opt/alt/php-fpm74/usr/sbin/php-fpm
exe:/opt/alt/php-fpm81/usr/sbin/php-fpm
exe:/opt/alt/php-fpm82/usr/sbin/php-fpm
exe:/opt/alt/php-fpm83/usr/sbin/php-fpm

44

Suggestions / Re: So here we are at EOL's

« on: August 06, 2024, 08:09:32 PM »

I have mem limit set 3096 already and I have added php-fpm and redis paths in pignore and I am still getting them.  <<<

I have been reading about that memory_limit. it is the limit that every connection / user gets. if you you have a server with just 4 gb of memory your system can handle only  40 connections or users before it goes out of memory.

I would say that I definitely don't have that issue with 48GB ram and 1.6TB ssd hehe

45

Suggestions / Re: So here we are at EOL's

« on: August 06, 2024, 07:53:32 PM »

Raise up your mem_Limit under: PHP Settings -> PHP Simple Editor

Also those LFD emails will tell you what program is causing the problem, and you can add it to

Code: [Select]

nano /etc/csf/csf.pignore

I have mem limit set 3096 already and I have added php-fpm and redis paths in pignore and I am still getting them.