Virtualmin Backup - mysqldump failing

14 posts / 0 new
Last post
#1 Sat, 01/10/2015 - 03:37
stevepburgess

Virtualmin Backup - mysqldump failing

In the past week I have noticed that the mysqldump part of the virtualmin scheduled backup has started failing.

The error given is:

mysqldump: Got error: 1045: Access denied for user 'username'@'localhost' (using password: YES) when trying to connect

This happens on all virtualserver backups on my server.

What is baffling is that I can connect remotely, from the server via command line and by managing the database within webmin/virtualmin. I can also run mysqldump manually from the command line without any problems.

I have tried resetting the passwords just in case password file has become corrupted - but this has no effect.

Any ideas?

Steve

Sat, 01/10/2015 - 04:59
SkaFan

Same problem here, since update

An update to webmin-virtual-server from 4.12.gpl to 4.13.gpl is available.

I get

Backup failed! See the progress output above for the reason why. Total backup time was 00 minutes, 08 seconds.
 
Virtual servers that failed :
    skafan.de.vu
Sent by Virtualmin at: https://**********.***:10000
 
Creating backup for virtual server skafan.de.vu ..
    Copying virtual server configuration ..
    .. done
 
    Backing up Cron jobs ..
    .. none defined.
 
    Saving mail aliases ..
    .. done
 
    Saving mail and FTP users ..
    .. done
 
    Backing up mail and FTP user Cron jobs ..
    .. none to backup
 
    Copying Apache virtual host configuration ..
    .. done
 
    Copying Apache log files ..
    .. done
 
    Copying Webalizer configuration files ..
    .. done
 
    Copying Logrotate configuration ..
    .. done
 
    Dumping MySQL database skafan ..
    .. dump failed! mysqldump: Got error: 1045: Access denied for user 'skafan'@'localhost' (using password: YES) when trying to connect

May this be a bug in virtualmin 4.13 gpl? I didn't chance any password (not to MySQL or the user or datebase)! Only chance I know is virtualmin 4.13... or hacker... :(

Sat, 01/10/2015 - 04:59
dabol

hello,

i have the same problem, i dont changed anything on servers, 3 servers have problemes backup database with mysqldump .

last backup succes : 08/Jan/2015 17:20 first probleme : 08/Jan/2015 17:30

i just run a upgrade betwen this time :

08/Jan/2015 17:23 : apt-get -y install webmin-virtual-server

and post-install script

on 3 of my servers ... 2 servers on debian 6 and one on debian 7

http://imageshack.com/a/img537/3416/7d72io.png http://imageshack.com/a/img673/3594/99GvDs.png

if you want more information, no problemes, but i think the upgrade may cause the problem

if someone can help ^^

thanks you !

Sat, 01/10/2015 - 05:03
dabol

read this : https://www.virtualmin.com/node/35794

The simpler fix is to edit /etc/webmin/mysql/config and add the line login=root

it works...

Sat, 01/10/2015 - 05:08
SkaFan

for me too, Thank you dabol!

Sat, 01/10/2015 - 05:15
stevepburgess

Thanks dabol. Works like a dream.

:o)

Sat, 01/10/2015 - 11:45
evnimaster

Hi, I have the same issue here since I updated virtualmin + webmin packages to the latest version. Running Bedian 7 and all is up to date. Error is only regarding mysql dump.

Sun, 01/11/2015 - 04:23
Shirehosting

Same here, happened Jan 7 with an update.

Sun, 01/11/2015 - 05:49
stevepburgess

The solution posted by dabol works:

read this : https://www.virtualmin.com/node/35794

The simpler fix is to edit /etc/webmin/mysql/config and add the line login=root

it works...

Sun, 01/11/2015 - 08:10
evnimaster

Few minutes ago, an update to virtualmin-virtual-server has been published. I installed it and removed the line from config file and my backups seem to work as they should. Thanks to all the team !

Sun, 01/11/2015 - 08:27
Shirehosting

I noticed the update come through as well. I did the update but now apache will not start. error is as follows.

Failed to start service :

Starting web server: apache2Syntax error on line 38 of /etc/apache2/sites-enabled/mjbcontrols.com.au.conf: Invalid command 'php_admin_value', perhaps misspelled or defined by a module not included in the server configuration Action 'start' failed. The Apache error log may have more information. failed!

Any ideas as all sites are now down.

Mon, 01/12/2015 - 06:32
MattWilcox

I too have been getting this error since the last update, and the only way to get Apache to start is to comment out the offending lines in the conf files for each site - but I think that's a work-around rather than a fix.

Mon, 01/12/2015 - 06:44
Shirehosting

See below for a fix.

http://virtualmin.com/node/35807

I have no idea why apache decided to take the weekend off.

Mon, 01/12/2015 - 08:08 (Reply to #13)
MattWilcox

That worked, thanks very much! A little worrying that it broke in the first place though :/

Topic locked