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

[ring_c]

Still the same.

[bullten]

what does below command shows

Code Select Expand

service mysqld status

[ring_c]

As before:

Code Select Expand


ERROR! MariaDB is not running


[bullten]

what is output of

Code Select Expand

mysqlcheck

[ring_c]

Code Select Expand


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


[bullten]

what is final output of

Code Select Expand

service mysqld start

[ring_c]

Code Select Expand



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


[bullten]

what does centos web panel gui says?

[bullten]

Hmmmm my bad you are running centos 7 and mariadb

start

Code Select Expand

systemctl start mariadb.service

stop

Code Select Expand

systemctl stop mariadb.service

restart

Code Select Expand

systemctl restart mariadb.service

status

Code Select Expand

systemctl status mariadb.service

[ring_c]

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 Expand

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] ?).

[bullten]

Yes my fault, agreed

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

[ring_c]

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

Code Select Expand

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

[bullten]

Code Select Expand

yum install perl-DBI -y

[ring_c]

Already installed
Maybe perl needs mysql while I have MariaDB?

Code Select Expand



[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


[bullten]

You need to find out from where it is generating.