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 8Oct 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.