Show Posts

16

MySQL / Re: MARIADB10.4.0 to 10.10.0

« on: December 10, 2024, 05:18:14 AM »

Ok so I attempted this again when I found a new tutorial at https://blog.alphagnu.com/update-upgrade-to-mariadb-10-4-on-vestacp-cwp-centos-7/.

Below is the resuklts of it, why did it go right back to 10.4?

[root@viking etc]# cp /etc/my.cnf /etc/my.cnf.bak
[root@viking etc]# nano /etc/my.cnf
[root@viking etc]# mv /etc/yum.repos.d/mariadb.repo /etc/yum.repos.d/mariadb.repo.bak
[root@viking etc]# nano /etc/yum.repos.d/mariadb.repo
[root@viking etc]# yum clean all
81 files removed
[root@viking etc]# yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y
CentOS Web Panel repo for Linux 8 - x86_64 302 kB/s | 305 kB 00:01
AlmaLinux 8 - BaseOS 18 MB/s | 9.6 MB 00:00
AlmaLinux 8 - AppStream 27 MB/s | 15 MB 00:00
AlmaLinux 8 - Extras 37 kB/s | 13 kB 00:00
AlmaLinux 8 - PowerTools 9.1 MB/s | 4.0 MB 00:00
AlmaLinux 8 - PowerTools Source 207 kB/s | 138 kB 00:00
AlmaLinux 8 - PowerTools debuginfo 1.2 MB/s | 688 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 30 MB/s | 14 MB 00:00
MariaDB 1.9 MB/s | 604 kB 00:00
nginx repo 1.1 MB/s | 71 kB 00:00
Package MariaDB-server-10.4.34-1.el8.x86_64 is already installed.
Package MariaDB-client-10.4.34-1.el8.x86_64 is already installed.
Package perl-DBD-MySQL-4.046-3.module_el8.6.0+2827+49d66dc3.x86_64 is already installed.
Dependencies resolved.
============================================================================================================================================================================================
Package Architecture Version Repository Size
============================================================================================================================================================================================
Installing:
net-snmp x86_64 1:5.8-30.el8 appstream 355 k
Upgrading:
MariaDB-client x86_64 10.6.20-1.el8 mariadb 15 M
MariaDB-common x86_64 10.6.20-1.el8 mariadb 88 k
MariaDB-server x86_64 10.6.20-1.el8 mariadb 26 M

Transaction Summary
============================================================================================================================================================================================
Install 1 Package
Upgrade 3 Packages

Total download size: 41 M
Downloading Packages:
(1/4): net-snmp-5.8-30.el8.x86_64.rpm 2.3 MB/s | 355 kB 00:00
(2/4): MariaDB-common-10.6.20-1.el8.x86_64.rpm 456 kB/s | 88 kB 00:00
(3/4): MariaDB-client-10.6.20-1.el8.x86_64.rpm 27 MB/s | 15 MB 00:00
(4/4): MariaDB-server-10.6.20-1.el8.x86_64.rpm 41 MB/s | 26 MB 00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 36 MB/s | 41 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: MariaDB-common-10.6.20-1.el8.x86_64 1/1
Upgrading : MariaDB-common-10.6.20-1.el8.x86_64 1/7
Upgrading : MariaDB-client-10.6.20-1.el8.x86_64 2/7
Running scriptlet: MariaDB-server-10.6.20-1.el8.x86_64 3/7

******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.4.34-1.el8.x86_64) is installed.

Upgrading directly from MySQL 10.4 to MariaDB 10.6 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'

You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-10.6.20-1.el8.x86_64) scriptlet failed, exit status 1

Error in PREIN scriptlet in rpm package MariaDB-server
Installing : net-snmp-1:5.8-30.el8.x86_64 4/7
error: MariaDB-server-10.6.20-1.el8.x86_64: install failed

Running scriptlet: net-snmp-1:5.8-30.el8.x86_64 4/7
Running scriptlet: MariaDB-client-10.4.34-1.el8.x86_64 5/7
error: MariaDB-server-10.4.34-1.el8.x86_64: erase skipped

Cleanup : MariaDB-client-10.4.34-1.el8.x86_64 5/7
Running scriptlet: MariaDB-client-10.4.34-1.el8.x86_64 5/7
Running scriptlet: MariaDB-common-10.4.34-1.el8.x86_64 6/7
Cleanup : MariaDB-common-10.4.34-1.el8.x86_64 6/7
Running scriptlet: MariaDB-common-10.4.34-1.el8.x86_64 6/7
Verifying : net-snmp-1:5.8-30.el8.x86_64 1/7
Verifying : MariaDB-client-10.6.20-1.el8.x86_64 2/7
Verifying : MariaDB-client-10.4.34-1.el8.x86_64 3/7
Verifying : MariaDB-common-10.6.20-1.el8.x86_64 4/7
Verifying : MariaDB-common-10.4.34-1.el8.x86_64 5/7
Verifying : MariaDB-server-10.6.20-1.el8.x86_64 6/7
Verifying : MariaDB-server-10.4.34-1.el8.x86_64 7/7

Upgraded:
MariaDB-client-10.6.20-1.el8.x86_64 MariaDB-common-10.6.20-1.el8.x86_64
Installed:
net-snmp-1:5.8-30.el8.x86_64
Failed:
MariaDB-server-10.4.34-1.el8.x86_64 MariaDB-server-10.6.20-1.el8.x86_64

Error: Transaction failed
[root@viking etc]# rm -rf /etc/my.cnf
[root@viking etc]# cp /etc/my.cnf.bak /etc/my.cnf
[root@viking etc]# systemctl enable mariadb
[root@viking etc]# service mysql start
Redirecting to /bin/systemctl start mysql.service
[root@viking etc]# mysql_upgrade
This installation of MariaDB is already upgraded to 10.4.34-MariaDB.
There is no need to run mysql_upgrade again for 10.4.34-MariaDB.
You can use --force if you still want to run mysql_upgrade
[root@viking etc]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5198
Server version: 10.4.34-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

17

CentOS-WebPanel GUI / Re: Known Issue???

« on: October 08, 2024, 11:07:21 PM »

For future fyi this fixed my user panels:

sh /scripts/cwpsrv_rebuild_user_conf

More Info @: https://wiki.centos-webpanel.com/404-on-user-login

18

CentOS-WebPanel GUI / Re: Known Issue???

« on: October 07, 2024, 08:09:40 AM »

Quote from: overseer on October 07, 2024, 05:45:17 AM

https://blog.alphagnu.com/fix-cwp-500-internal-server-error-expired-white-blank-screen/

[root@viking ~]# chattr -i -R /usr/local/cwpsrv/var/services/
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//user_api/v1/app/libs/hooks.php
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//user_api/v1/app/libs/functions.php
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//users/login/cwp_theme
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//users/softaculous/softimages
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//users/softaculous/themes
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//users/dragocom
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//users/nulled
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//users/nullwh
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//users/vipanel
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//users/fvault
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//users/users
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube/public_html/program/resources
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube/public_html/program/js
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube/public_html/skins
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube/public_html/.htaccess
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube/public_html/plugins
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube/public_html/robots.txt
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube/vendor/bin/crypt-gpg-pinentry
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube/vendor/bin/rcubeinitdb.sh
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube_06-08-2024.bak/public_html/robots.txt
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube_06-08-2024.bak/public_html/plugins
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube_06-08-2024.bak/public_html/.htaccess
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube_06-08-2024.bak/public_html/skins
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube_06-08-2024.bak/public_html/program/js
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcube_06-08-2024.bak/public_html/program/resources
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcubemail-1.4.11/public_html/program/resources
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcubemail-1.4.11/public_html/program/js
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcubemail-1.4.11/public_html/.htaccess
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcubemail-1.4.11/public_html/skins
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcubemail-1.4.11/public_html/plugins
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcubemail-1.4.11/vendor/bin/rcubeinitdb.sh
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//roundcubemail-1.4.11/vendor/bin/crypt-gpg-pinentry
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//pma_06-08-2024.bak/vendor/bin/highlight-query
chattr: Operation not supported while reading flags on /usr/local/cwpsrv/var/services//pma_06-08-2024.bak/vendor/bin/lint-query

I went ahead and ran the rest of the commands and the sh update and it didn't help.

19

CentOS-WebPanel GUI / Re: Known Issue???

« on: October 07, 2024, 08:03:49 AM »

Quote from: Starburst on October 06, 2024, 06:08:24 AM

Try

User Account -> Fix Permissions -> (Select User) nobody

Check All 3 boxes, and then Fix Selected Issues.

If it's a permission issue, this 'might' take care of it.

Tried it same black screen with the same message.

20

CentOS-WebPanel GUI / Re: Known Issue???

« on: October 06, 2024, 02:41:03 AM »

Quote from: Starburst on October 05, 2024, 07:07:48 AM

Might be that bug popping up.

Try Suspending the client, make sure the suspend page come up, and then unsuspend.

That didn'twork unfortunately

21

CentOS-WebPanel GUI / Re: Known Issue???

« on: October 05, 2024, 06:10:49 AM »

Quote from: Starburst on October 04, 2024, 08:15:07 AM

Yesterday the control panel updated, and today there was an update to the cwp-suphp if you have the CWP repo active.

Did you try to reboot?

Yeah I tried a reboot. The cwp user page comes up I enter my l/p in the fields and submit and it goes to 500 error

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

HTTP ERROR 500

22

MySQL / Re: MARIADB10.4.0 to 10.10.0

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

Quote from: Starburst on October 04, 2024, 08:19:04 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

23

MySQL / Re: MARIADB10.4.0 to 10.10.0

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

Thanks

24

MySQL / Re: MARIADB10.4.0 to 10.10.0

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

Quote from: Starburst on October 04, 2024, 07:02:37 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.

25

MySQL / Re: MARIADB10.4.0 to 10.10.0

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

Quote from: cyberspace on October 03, 2024, 06:59:27 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.

26

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.

27

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

28

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?

29

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

30

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

Control Web Panel

Messages - DragoCom

MySQL / Re: MARIADB10.4.0 to 10.10.0

CentOS-WebPanel GUI / Re: Known Issue???

CentOS-WebPanel GUI / Re: Known Issue???

CentOS-WebPanel GUI / Re: Known Issue???

CentOS-WebPanel GUI / Re: Known Issue???

CentOS-WebPanel GUI / Re: Known Issue???

MySQL / Re: MARIADB10.4.0 to 10.10.0

MySQL / Re: MARIADB10.4.0 to 10.10.0

MySQL / Re: MARIADB10.4.0 to 10.10.0

MySQL / Re: MARIADB10.4.0 to 10.10.0

CentOS-WebPanel GUI / Known Issue???

MySQL / Re: MARIADB10.4.0 to 10.10.0

MySQL / Re: MARIADB10.4.0 to 10.10.0

MySQL / Re: MARIADB10.4.0 to 10.10.0

MySQL / MARIADB10.4.0 to 10.10.0