Error found on the email from - Anacron job 'cron.daily'

Still the same.

what does below command shows

Code: [Select]

service mysqld status

As before:

Code: [Select]

ERROR! MariaDB is not running


what is output of

Code: [Select]

mysqlcheck

Code: [Select]

[root@cwp ~]# mysqlcheck
You forgot to give the arguments! Please see mysqlcheck --help
for more information.


what is final output of

Code: [Select]

service mysqld start

Code: [Select]


[root@cwp ~]# service mysqld start
Starting mysqld (via systemctl):                           [  OK  ]
[root@cwp ~]# service mysqld status
 ERROR! MariaDB is not running


what does centos web panel gui says?

Hmmmm my bad you are running centos 7 and mariadb

start

Code: [Select]

systemctl start mariadb.service
stop

Code: [Select]

systemctl stop mariadb.service
restart

Code: [Select]

systemctl restart mariadb.service
status

Code: [Select]

systemctl status mariadb.service

I was wondering why we're using the mysql command, but I thought - hey, I know nothing, I better shut up.


Well, yeah it seems it all works (all that time everything was Green in CWP dashboard).
Here's the status:

Code: [Select]

Active: active (running) since Mon 2018-09-03 21:04:47 IDT; 5s ago

So, I'm good? No need to panic? Do I have to change anything in /etc/my.cnf (remember we've added [mysqld] ?).

Yes my fault, agreed

Yes everything is fine as long as there is green light in GUI of CWP.

Thank you, dear bullten.
Yet, I'm still getting the following error in the log sent by email for daily backups:

Code: [Select]

warning: /var/tmp/rpm-tmp.VFyLyO: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYerror: Failed dependencies:        perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch

Code: [Select]

yum install perl-DBI -y

Already installed
Maybe perl needs mysql while I have MariaDB?

Code: [Select]


[root@cwp ~]# yum install perl-DBI -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
epel/x86_64/metalink                                     |  31 kB     00:00
 * base: mirror.ratiokontakt.de
 * epel: mirror.wiuwiu.de
 * extras: mirror.ratiokontakt.de
 * remi-safe: mirror.23media.de
 * updates: mirror.ratiokontakt.de
base                                                     | 3.6 kB     00:00
cwp                                                      | 2.9 kB     00:00
extras                                                   | 3.4 kB     00:00
mariadb                                                  | 2.9 kB     00:00
remi-safe                                                | 2.9 kB     00:00
updates                                                  | 3.4 kB     00:00
varnishcache_varnish5/x86_64/signature                   |  836 B     00:00
varnishcache_varnish5/x86_64/signature                   | 1.0 kB     00:00 !!!
varnishcache_varnish5-source/signature                   |  836 B     00:00
varnishcache_varnish5-source/signature                   | 1.0 kB     00:00 !!!
Package perl-DBI-1.627-4.el7.x86_64 already installed and latest version
Nothing to do


You need to find out from where it is generating.