AL 9.6, I have info about 240 updates

Hi,

I work with AL 9.6... Since yesterday, I have info about 240 updates:

https://prnt.sc/vRmNk7sYu7wR

... but nothing happens..., after I select update, nothing happens, and this information about 240 updates available appears again ...

BR
Venty

As others have mentioned, the Yum Manager in the web GUI can be buggy. Best to leave yum behind as legacy and get acquainted with dnf. Try:

Code: [Select]

dnf --refresh update

As others have mentioned, the Yum Manager in the web GUI can be buggy. Best to leave yum behind as legacy and get acquainted with dnf. Try:

Code: [Select]

dnf --refresh update

Ok, the result is:

https://prnt.sc/wuudORVZrfXQ

his information about 240 updates available appears again ...

BR
Venty

See here for fix  https://forum.centos-webpanel.com/centos-webpanel-bugs/can-t-update-linux-os-because-of-mysql-common/msg52726/#msg52726

That is because you are probably running AlmaLinux 9.6, and 9.7 just dropped.

So about 360 package updates is normal.

To fix the conflict:

Code: [Select]

dnf remove perl-DBD-MySQL -y

Code: [Select]

dnf install perl-DBD-MariaDB -y
Finish the upgrade to AlmaLinux 9.7:

Code: [Select]

dnf --refresh update

To fix the conflict:

Code: [Select]

dnf remove perl-DBD-MySQL -y

Code: [Select]

dnf install perl-DBD-MariaDB -y
Finish the upgrade to AlmaLinux 9.7:

Code: [Select]

dnf --refresh update

Hello.

I was just coming here because of this same problem. I have AL 9.6 + CWP 9 (to do testing) installed thanks to...
And I've run into the same problem. When I try to update (I think there's an update from 9.6 to 9.7), I get several lines with:

Code: [Select]

Error: Transaction test error:
file /usr/share/mysql/charsets/Index.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64

file /usr/share/mysql/charsets/armscii8.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
Basically, the same problem is described in this post:

https://forum.centos-webpanel.com/centos-webpanel-bugs/can-t-update-linux-os-because-of-mysql-common/msg52726
I've done some research and saw what you mentioned, Starburts, as a solution.

The link they mention here:

They talk about modifying a file to make the mail server work. I haven't done it (due to lack of time, I haven't yet done the necessary migration tests from AL8 to this server with AL9 to configure mail), so I deduce that it's not necessary.

As always, thank you for being here, on the front lines, helping out.

We had the same problem with that message when running dnf --refresh update

If you are not running CBPolicyD, you don't need to edit any files, and just run those 2 commands above before upgrading.

Indeed, I don't use CBPolicyD, and that's how I proceeded. I ran both commands, the uninstaller and the installer, and AL9 updated without issue.

However, I later saw the following message in my Anacron email, and I'm not sure if it's relevant:

Code: [Select]

###############################################
Daily MySQL Backup starting
###############################################
(Sorry, I can't post the paths. Notice: the "forbidden" forum is giving an error.)
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
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
...
perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch

Currently, I only have the databases included with CWP9, but that last line indicates that it needs perl(DBD::mysql) >= 1.0, precisely the one we replaced. I don't know if it's all related to the replacement.

It's an encrypted file, so I can see how/what is being run. 

I have contact higher powers...