Author Topic: Error found on the email from - Anacron job 'cron.daily'  (Read 613 times)

0 Members and 1 Guest are viewing this topic.

Offline
**
Error found on the email from - Anacron job 'cron.daily'
« on: September 03, 2018, 05:44:00 AM »
For the first time I've looked deeply into the email received for the daily backups and found some errors (marked the errors in Red):

---
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dba --> /backup/mysql/daily//dbb_dba.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbb --> /backup/mysql/daily//dbb_dbb.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbc --> /backup/mysql/daily//dbb_dbc.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbd --> /backup/mysql/daily//dbb_dbd.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbe --> /backup/mysql/daily//dbb_dbe.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbf --> /backup/mysql/daily//dbb_dbf.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbg --> /backup/mysql/daily//dbb_dbg.sql
Skipping database: information_schema.
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbh --> /backup/mysql/daily//dbb_dbh.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: mysql --> /backup/mysql/daily//mysql.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: oauthv2 --> /backup/mysql/daily//oauthv2.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: performance_schema --> /backup/mysql/daily//performance_schema.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: postfix --> /backup/mysql/daily//postfix.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: root_cwp --> /backup/mysql/daily//root_cwp.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: roundcube --> /backup/mysql/daily//roundcube.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbi --> /backup/mysql/daily//dbb_dbi.sql
warning: /var/tmp/rpm-tmp.RpBiRK: 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
---

Any idea what might be wrong?
« Last Edit: September 03, 2018, 05:48:38 AM by ring_c »

Offline
****
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #1 on: September 03, 2018, 11:31:06 AM »
What is output of

Code: [Select]
cat /etc/my.cnf
Did you added local-infile=0 under [mysqld] so it would look like

Code: [Select]
[mysqld]
local-infile=0

Offline
**
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #2 on: September 03, 2018, 11:56:10 AM »

cat /etc/my.cnf:
Code: [Select]

[xxx@cwp ~]# cat /etc/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]


#
# include all files from the config directory
#
!includedir /etc/my.cnf.d


#
# Disable LOAD DATA LOCAL commands in MySQL
#
local-infile=0


As you can see, the
Code: [Select]
local-infile=0 is there...

Offline
****
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #3 on: September 03, 2018, 12:15:02 PM »
You didnt read my whole reply. i told you it should be under [mysqld]

Also when you added local-infile=0 you didnt restart mysql?

so now added it under [mysqld]

Quote
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]


#
# include all files from the config directory
#
!includedir /etc/my.cnf.d


#
# Disable LOAD DATA LOCAL commands in MySQL
#
[mysqld]
local-infile=0

Also dont forget to restart mysql

Offline
**
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #4 on: September 03, 2018, 12:25:21 PM »
You didnt read my whole reply. i told you it should be under [mysqld]
Sorry. I'm quite new to VPS in general and CWP in particular. I thought that's what you meant.


Also when you added local-infile=0 you didnt restart mysql?

so now added it under [mysqld]

Quote
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]


#
# include all files from the config directory
#
!includedir /etc/my.cnf.d


#
# Disable LOAD DATA LOCAL commands in MySQL
#
[mysqld]
local-infile=0

Also dont forget to restart mysql
I don't really know. I only follow tutorials. Though I'm quite sure I made a server restart 2 days ago...
I will change according to your guidance, restart mysql and will keep an eye on further emails hopping it'll be resolved.


Thanks!

Offline
****
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #5 on: September 03, 2018, 12:30:42 PM »
Well you can replicate the issue easily.

in /etc/my.cnf file remove [mysqld] and restart mysql. See if it starts.

Offline
**
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #6 on: September 03, 2018, 12:38:45 PM »
Yes. It does restart!

Offline
****
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #7 on: September 03, 2018, 12:39:28 PM »
what is output of

mysqldump

Does it gives same warning like  you mentioned above?

Offline
**
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #8 on: September 03, 2018, 12:47:05 PM »
Sorry, what exactly should I have to run?  :-[

Offline
****
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #9 on: September 03, 2018, 12:50:36 PM »
make /etc/my.cnf to look like below as I comment out [mysqld]

nano /etc/my.cnf
Quote
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]


#
# include all files from the config directory
#
!includedir /etc/my.cnf.d


#
# Disable LOAD DATA LOCAL commands in MySQL
#
# [mysqld]
local-infile=0

restart mysql

Code: [Select]
service mysqld restart
Does it restart?

run the command below

Code: [Select]
mysqldump
Does the above command gives same warning as you mentioned in the first thread.

Offline
**
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #10 on: September 03, 2018, 12:56:31 PM »
Oh, this time it doesn't restart (I was using the restart button in CWP's dashboard before that, and I didn't get an error then).
Running service mysqld status after the restart command resolves in "ERROR! MariaDB is not running".
And mysqldump resolves in " unknown variable 'local-infile=0' " indeed.


I'll uncomment the [mysqld] and restart mysql again.
But... how come my wordpress sites are working then if the mysql is not running?

Offline
**
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #11 on: September 03, 2018, 12:58:14 PM »
Oh, damn... I've uncommented the [mysqld], saved the file and restarted mysqld.
But the status still shows the error message (though mysqldump doesn't).

Offline
****
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #12 on: September 03, 2018, 01:08:36 PM »
Adding that line I think you didnt restart mysql and thats why it happened.

by uncommenting [mysqld] and restarting through ssh did it give any error?

Offline
**
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #13 on: September 03, 2018, 01:49:12 PM »
The last time I did it through SSH.
I still get the same error that MariaDB is not running. :(

Offline
****
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #14 on: September 03, 2018, 01:51:11 PM »
stop mysql

Code: [Select]
service mysqld stop
service mysql stop

Now start from cwp gui