Anacron job 'cron.daily' on server.locksmithunit.com | MariaDB105/repomd.xml

nadav123 · Feb 10, 2022

Hey guys, from the last update i start to get emails from hourly cron again:

Code:

Anacron job 'cron.daily' on server.locksmithunit.com


Anacron <[email protected]>
7:54 AM (4 hours ago)


to root




/etc/cron.daily/0yum-daily.cron:

Not using downloaded MariaDB105/repomd.xml because it is older than what we have:
Current : Tue Feb 8 03:21:08 2022
  Downloaded: Tue Nov  9 16:27:39 2021

________________________________________

and similar email without the ANACRON:

Code:

Cron <[email protected]> run-parts /etc/cron.hourly



/etc/cron.hourly/0yum-hourly.cron:



Not using downloaded MariaDB105/repomd.xml because it is older than what we have:

  Current   : Tue Feb  8 03:21:08 2022

  Downloaded: Tue Nov  9 16:27:39 2021

________________________

This issue was before a mount ago and fix itself automagically.
what needs to do guys? don't have any docomantion how hendel this issue ( its new issue from the last update i get it on both of my servers ):
server.locksmithunit.com - N.Virgina US
server.locksmithunit.es - Zuric EU

its starts from the last cPanel update.

cPRex · Feb 11, 2022

Hey there! I'm sorry to hear about the issues with MySQL. If you run this command on your server

Code:

mysql --version

Does that give you any output?

Can you also send the output of this command?

Code:

grep -i mysql /var/cpanel/cpanel.config

nadav123 · Feb 11, 2022

This is the first:

Code:

[[email protected] ~]# mysql --version
mysql  Ver 15.1 Distrib 10.5.14-MariaDB, for Linux (x86_64) using readline 5.1

this the second output:

Code:

[[email protected] ~]# grep -i mysql /var/cpanel/cpanel.config
mysql-host=localhost
mysql-version=10.5
usemysqloldpass=0

please is must be quick, all this time my site is down, and i am nervous i lose the Data i have in the database ( i sure i am not, i see my user and my website database throw ssh:
cd /var/lib/mysql )

I was thinking is this because are VMs on Google Cloud:

https://support.cpanel.net/hc/en-us/articles/4418907865239-MySQL-data-directory-missing-after-rebooting-server-

but its impossible, i chack the "backup" folder its before 4 mounts... and not from the day of the problem ( yesterday )
I turn off the script ( only check if it is will improve ):

systemctl disable cpinit.service

but not, interface of "WHM > MySQL/MariaDB Upgrade" NOT WORKING!

What start this isiue was a warning email from cron / Anacron about MariaDB105 RepoXML:

Code:

Anacron <[email protected]>
11:07 AM (1 hour ago)


to root




/etc/cron.daily/0yum-daily.cron:

Not using downloaded MariaDB105/repomd.xml because it is older than what we have:
Current : Tue Feb 8 09:21:08 2022
  Downloaded: Tue Nov  9 22:27:39 2021

This started a couple of days/week ago from your last update of cPanel.
It's on 2 different servers located in different places in the world.
( Only prof my problem is not coming from the server and from an update - not make sense 2 different servers will get the same errors from the latest Cpanel update ).

I hope all this information is helpful.
Please i need help fast, i am not getting jobs right now because everything shut down with this issue.

I attached a screenshot of both of the servers together, and the UI inside WHM with the FATAL error.
hope its will help to help me

cPRex · Feb 11, 2022

Can you post the output of this command?

Code:

cat /var/cpanel/rpm.versions.d/local.versions

nadav123 · Feb 11, 2022

This brother:

Code:

[[email protected] ~]# cat /var/cpanel/rpm.versions.d/local.versions
---
file_format:
  version: 2
target_settings: {}

Thanks for the fast response.
please help

cPRex · Feb 11, 2022

Thanks for that. In the past when we have seen this issue, the mariadb-server package has been missing from the machine. Can you try running this to see if that helps get things working?

Code:

yum install MariaDB-server

nadav123 · Feb 11, 2022

it will not change the version of mariadb? dont need to specified the version? 10.5 ( i prefer to avoid conflicts before running this command )

btw i checked YUM repo's:

Code:

[[email protected] ~]# yum repolist
Loaded plugins: fastestmirror, universal-hooks
Loading mirror speeds from cached hostfile
* EA4: 63.247.64.58
* EA4-experimental: 63.247.64.58
* cpanel-addons-production-feed: 63.247.64.58
* cpanel-plugins: 63.247.64.58
* base: mirror.wdc1.us.leaseweb.net
* epel: iad.mirror.rackspace.com
* extras: mirror.mia11.us.leaseweb.net
* updates: mirror.atl.genesisadaptive.com
repo id                                                                                                      repo name                                                                                                               status
EA4/7/x86_64                                                                                                 EA4 ( EasyApache 4 )                                                                                                     4,623+834
EA4-experimental/7/x86_64                                                                                    EA4 Experimental ( EasyApache 4 )                                                                                          213+148
cpanel-addons-production-feed/x86_64                                                                         cPanel Addons Production Feed                                                                                                   68
cpanel-plugins/x86_64                                                                                        cPanel Plugins project                                                                                                          97
MariaDB105                                                                                                   MariaDB105                                                                                                                    95+3
base/7/x86_64                                                                                                CentOS-7 - Base                                                                                                          10,038+34
epel/x86_64                                                                                                  Extra Packages for Enterprise Linux 7 - x86_64                                                                          12,913+807
extras/7/x86_64                                                                                              CentOS-7 - Extras                                                                                                              500
google-cloud-sdk                                                                                             Google Cloud SDK                                                                                                             2,205
google-compute-engine                                                                                        Google Compute Engine                                                                                                           10
mysql-connectors-community/x86_64                                                                            MySQL Connectors Community                                                                                                     230
mysql-tools-community/x86_64                                                                                 MySQL Tools Community                                                                                                          138
mysql57-community/x86_64                                                                                     MySQL 5.7 Community Server                                                                                                     564
nginx/7/x86_64                                                                                               nginx mainline repo                                                                                                            899
updates/7/x86_64                                                                                             CentOS-7 - Updates                                                                                                         3,410+1
wp-toolkit-cpanel                                                                                            WordPress Toolkit for cPanel                                                                                                     1
wp-toolkit-thirdparties                                                                                      WordPress Toolkit third parties                                                                                                 19
repolist: 36,023
[[email protected] ~]#

I tried to reinstall MariaDB105 with:
yum reinstall MariaDB105

but it didn't fix the issue.

I still didn't try your commend. i am afraid to make duplication
( maybe need to specify the version on the command line you provide me? or this automagically? )

want to be sure with you before we process this command line.
Please confirm me, and i will run the command line:

yum install MariaDB-server

BUT WE MUST BE SURE IT WILL NOT DOWNGRADE OR DUPLICATE THE REPO'S.
PLEASE ONLY CONFIRM ME IT WILL NOT DUPLICATE I WILL RUN IT AND FIX EVERYTHING, BUT WE MUST BE SURE. ( RESULT CAN BE DISASTER IF IT DUPLICATED )

I appreciate the fast response really you are an angel cPRex.

cPRex · Feb 11, 2022

Please run this to confirm the packages you have installed

Code:

rpm -qa | grep -i maria

That will tell us what is missing from the system.

nadav123 · Feb 11, 2022

This what get out:

Code:

[[email protected] ~]# rpm -qa | grep -i maria
cpanel-mariadb-connector-3.1.8-1.cp1198.x86_64
MariaDB-client-10.5.14-1.el7.centos.x86_64
MariaDB-shared-10.5.14-1.el7.centos.x86_64
MariaDB-common-10.5.14-1.el7.centos.x86_64
MariaDB-compat-10.5.14-1.el7.centos.x86_64
MariaDB-devel-10.5.14-1.el7.centos.x86_64

btw i attached a screenshot is heppend in 2 different servers and not one... this issue is global, and gonna happen to a lot of customers.
Thanks again.

cPRex · Feb 11, 2022

A properly working system should have the following packages: (please note this is for MariaDB 10.5, so the exact version numbers may not match your machine)

Code:

# rpm -qa | grep -i maria
MariaDB-devel-10.5.13-1.el7.centos.x86_64
MariaDB-compat-10.5.13-1.el7.centos.x86_64
MariaDB-client-10.5.13-1.el7.centos.x86_64
MariaDB-shared-10.5.13-1.el7.centos.x86_64
MariaDB-common-10.5.13-1.el7.centos.x86_64
cpanel-mariadb-connector-3.1.8-1.cp1198.x86_64
MariaDB-server-10.5.13-1.el7.centos.x86_64

It seems like you are missing the MariaDB-server package, and the previous Yum command I provided - "yum install MariaDB-server" will take care of that.

I haven't seen any other reports of this issue at this time so I'm not aware of this being a widespread issue.

Can you try that install to see if that gets things working?

Thread starter	Similar threads	Forum	Replies	Date
G	Anacron job 'cron.daily' on <host>	Server Management	2	Jan 21, 2023
N	Anacron \| Still issue accrue with other RPM	Server Management	4	Feb 12, 2022
	Anacron job 'cron.daily'	Server Management	3	Jun 26, 2021
	Anacron job 'cron.daily' error	Server Management	2	Mar 11, 2016
W	Anacron job 'cron.daily'	Server Management	2	Dec 1, 2005

Search

Search

Anacron job 'cron.daily' on server.locksmithunit.com | MariaDB105/repomd.xml

nadav123

Well-Known Member

cPRex

Jurassic Moderator

nadav123

Well-Known Member

Attachments

cPRex

Jurassic Moderator

nadav123

Well-Known Member

cPRex

Jurassic Moderator

nadav123

Well-Known Member

cPRex

Jurassic Moderator

nadav123

Well-Known Member

Attachments

cPRex

Jurassic Moderator