1 hour ago, Sandeep B. said:

Try

rpm -e --nodeps mysql-common-8.0.41-1.module_el8.10.0+3965+b415b607.x86_64

There are probably 20 of these conflicts

On 6/2/2023 at 9:42 AM, Sandeep B. said:

yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y

Warning: failed loading '/etc/yum.repos.d/mariadb.repo', skipping.
(this file is in the right location and has the following content:
name = MariaDB
baseurl = https://rpm.mariadb.org/10.11/centos/$releasever/$basearch
module_hotfixes = 1
gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1
)

This is on a brand new server than my last failed attempt at doing this.  I dont know what to say, except this is not working for alma8.

Hi Sandeep,

The upgrade went with a few hiccups but i managed to it working. when i do

mysql -V it shows me mysql Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) using readline 5.1

but after i did the command

mysql_upgrade --force

and i scrolled up it gave me this :

mysql.transaction_registry OK

mysql.user OK

Phase 2/8: Installing used storage engines... Skipped

Phase 3/8: Running 'mysql_fix_privilege_tables'

Phase 4/8: Fixing views

mysql.user

Warning : The user specified as a definer ('mariadb.sys'@'localhost') does not exist

status : OK

sys.host_summary OK

the rest says all ok... behind.

is this an issue or ?

regards

Mike

On 4/21/2025 at 9:52 AM, Dutch_Mike said:

Hi Sandeep,

The upgrade went with a few hiccups but i managed to it working. when i do

mysql -V it shows me mysql Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) using readline 5.1

but after i did the command

mysql_upgrade --force

and i scrolled up it gave me this :

mysql.transaction_registry OK

mysql.user OK

Phase 2/8: Installing used storage engines... Skipped

Phase 3/8: Running 'mysql_fix_privilege_tables'

Phase 4/8: Fixing views

mysql.user

Warning : The user specified as a definer ('mariadb.sys'@'localhost') does not exist

status : OK

sys.host_summary OK

the rest says all ok... behind.

is this an issue or ?

regards

Mike

Recreate the user and try the upgrade again:

CREATE USER `mariadb.sys`@`localhost` ACCOUNT LOCK PASSWORD EXPIRE;

GRANT SELECT, DELETE ON `mysql`.`global_priv` TO `mariadb.sys`@`localhost`;

While following the step

rpm --nodeps -ev MariaDB-server

got

error: package MariaDB-server is not installed

But I continued and everything seems to be working.

Hope its okay to ignore this error

Edited October 8, 2025Oct 8 by siteur

When upgrading from 10.1, 10.2, 10.3 to 10.11 to find the proper MariaDB repo you can use this service:

curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-10.11"

Description:

Link: https://mariadb.com/kb/en/mariadb/mariadb-package-repository-setup-and-usage/

Thank you so much!

Something changed in AlmaLinux 9.7.

You will get an error trying to install install perl-DBD-MySQL, because it tried to load the dependency of mysql-common, which will give an error that it conflicts with mariadb-common

Fix seems to be installing perl-DBD-MariaDB instead of perl-DBD-MySQL, so you can update MariaDB on a CURRENT AL9 server that upgraded to 9.7 or a NEW AL 9.7 install.

BUT...
Then CWP will give errors with the Anacron job 'cron.daily Daily MySQL Backup starting section:

###############################################
Daily MySQL Backup starting
###############################################

PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Skipping database: information_schema.
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: mysql --> /backup/mysql/daily//mysql.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: oauthv2 --> /backup/mysql/daily//oauthv2.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Skipping database: performance_schema.
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: postfix --> /backup/mysql/daily//postfix.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: root_cwp --> /backup/mysql/daily//root_cwp.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: roundcube --> /backup/mysql/daily//roundcube.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: sys --> /backup/mysql/daily//sys.sql.gz
warning: /var/tmp/rpm-tmp.AaH9Yb: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
	perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch

###############################################
Daily MySQL Backup finished
###############################################

So you will need to backup those databases yourself.

On 12/5/2025 at 10:09 AM, Starburst said:

Something changed in AlmaLinux 9.7.

You will get an error trying to install install perl-DBD-MySQL, because it tried to load the dependency of mysql-common, which will give an error that it conflicts with mariadb-common

Fix seems to be installing perl-DBD-MariaDB instead of perl-DBD-MySQL, so you can update MariaDB on a CURRENT AL9 server that upgraded to 9.7 or a NEW AL 9.7 install.

BUT...
Then CWP will give errors with the Anacron job 'cron.daily Daily MySQL Backup starting section:

###############################################
Daily MySQL Backup starting
###############################################

PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Skipping database: information_schema.
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: mysql --> /backup/mysql/daily//mysql.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: oauthv2 --> /backup/mysql/daily//oauthv2.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Skipping database: performance_schema.
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: postfix --> /backup/mysql/daily//postfix.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: root_cwp --> /backup/mysql/daily//root_cwp.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: roundcube --> /backup/mysql/daily//roundcube.sql.gz
PHP Notice:  Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Notice: Trying to access array offset on value of type null in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
Database Backup: sys --> /backup/mysql/daily//sys.sql.gz
warning: /var/tmp/rpm-tmp.AaH9Yb: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
	perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch

###############################################
Daily MySQL Backup finished
###############################################

So you will need to backup those databases yourself.

@Starburst The mentioned issue may related to this topic:

Edited February 20Feb 20 by TheHolbi
typo

Hello,

Thanks to the instructions, we were able to update to version 10.11.16-MariaDB without any problems. How high can the MySQL server be updated without crashing the entire system?

By the way, I'm the same person with the same name from the CWP forum! :-)