Strange errors in backup - Mysql dumping.

Submitted by combine on Fri, 05/22/2015 - 01:25 Pro Licensee

Hi,

I startet to see error in the backup log regarding MySQL dumps. I know that there have been a problem with sites containing .my.cnf files. that seems to have been fixed and not causing problems on some of our servers other servers still have the problem. all running Debian/Ubuntu, the error is Dumping MySQL database somedatabase .. .. dump failed! Warning: Using a password on the command line interface can be insecure. The backup seems to be working, but I get an email from virtualmin with errors. That is quite anoing as this seems to be wrong.

Today i got this message on a server running Ubuntu 14.04

Dumping MySQL database somedatabase .. .. dump failed! su: Authentication failure (Ignored)

Any idea?

And yes we need those .my.cnf files all our webapplications use these files, we are running around 100 sites on multiple servers, all have the .my.cnf but not all backup jobs fail...

Sune

Status: 
Closed (fixed)

Comments

Submitted by JamieCameron on Fri, 05/22/2015 - 13:38

That message "su: Authentication failure" seems to be the cause of the problem, and looks unrelated to any MySQL permission issue.

If you login to your system as root via SSH, can you use su to switch to a domain owner account?

Submitted by combine on Mon, 05/25/2015 - 13:31 Pro Licensee

Hi,

The su problem seemed to be related to an issue with Ubuntu, that server has now been replaced by a CentOS server. We are moving all of our installs to CentOS. But I still get this on 2 of our Debian 7 servers.

the error is Dumping MySQL database somedatabase .. .. dump failed! Warning: Using a password on the command line interface can be insecure.

Any Idea?

Sune

Submitted by JamieCameron on Mon, 05/25/2015 - 15:51

That could be a false error, if the whole error message is just a "warning". Does it say anything else?

Submitted by combine on Tue, 05/26/2015 - 05:00 Pro Licensee

No it does not say anything else. And the backup seems to be fine. But I will get an email stating that the backup failed, that is pretty anoying.

Today i got this "error" on another Debian server.

Dumping MySQL database somedatabase .. .. dump failed!

Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead. Warning: mysqldump: ignoring option '--databases' due to invalid value 'somedatabase'

That would be the same, a false error...???

Sune

Submitted by JamieCameron on Tue, 05/26/2015 - 11:29

It may be that warnings are treated as failures. Which Debian version is this?

Submitted by combine on Wed, 05/27/2015 - 01:42 Pro Licensee

This is running on Debian 7 with all the latest patches and everything.

Submitted by JamieCameron on Wed, 05/27/2015 - 21:57

Ok, in the next Webmin release we will ignore these harmless warning messages.

Submitted by Issues on Wed, 06/10/2015 - 21:57

Automatically closed -- issue fixed for 2 weeks with no activity.

Submitted by Issues on Wed, 06/10/2015 - 21:58

Automatically closed -- issue fixed for 2 weeks with no activity.