[opensuse] automysqlbackup stopped working
Hello, I use automysqlbackup to daily backup MariaDB databases on openSUSE 13.1. The package is version v3.0_rc6-2.1 from JeanVEGA's Home Project in OBS. I have script # l /etc/cron.daily/runmysqlbackup -rwxr-xr-x 1 root root 242 22. čen 14.16 /etc/cron.daily/runmysqlbackup* Containing just #!/bin/sh /usr/bin/automysqlbackup /etc/automysqlbackup/myserver.conf When I run it manually, it works perfectly: # /etc/cron.daily/runmysqlbackup Parsed config file "/etc/automysqlbackup/automysqlbackup.conf" # Checking for permissions to write to folders: base folder /backups ... exists ... ok. backup folder /backups/automysqlbackup ... exists ... writable? yes. Proceeding. checking directory "/backups/automysqlbackup/daily" ... exists. checking directory "/backups/automysqlbackup/weekly" ... exists. checking directory "/backups/automysqlbackup/monthly" ... exists. checking directory "/backups/automysqlbackup/latest" ... exists. checking directory "/backups/automysqlbackup/tmp" ... exists. checking directory "/backups/automysqlbackup/fullschema" ... exists. checking directory "/backups/automysqlbackup/status" ... exists. # Testing for installed programs pigz ... found. mysql ... found. mysqldump ... found. # Parsing databases ... done. ====================================================================== AutoMySQLBackup version 3.0 http://sourceforge.net/projects/automysqlbackup/ Backup of Database Server - 127.0.0.1 ... and backed up databases are created. But cron doesn't work. The weird point is, that it had been working until last week. I don't remember all the updates, but I haven't changed the configuration. The only error I get is mail from cron to root with subject "cronjob@localhost - daily - FAILURE" and empty text. Any ideas how to trace and fix it? Sincerely, Vojtěch -- Vojtěch Zeisek Komunita openSUSE GNU/Linuxu Community of the openSUSE GNU/Linux http://www.opensuse.org/ http://trapa.cz/
On Sat, 11 Oct 2014 13:17:40 +0200 Vojtěch Zeisek wrote:
Any ideas how to trace and fix it?
Hi Vojtěch, I don't have any experience with automysqlbackup, but what's under '/backups/automysqlbackup/status'? Might be some interesting clues there. Do you see anything interesting in '/var/log/mysqld.log'? regards, Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Dne So 11. října 2014 10:09:22, Carl Hartung napsal(a):
On Sat, 11 Oct 2014 13:17:40 +0200
Vojtěch Zeisek wrote:
Any ideas how to trace and fix it?
Hi Vojtěch,
I don't have any experience with automysqlbackup, but what's under '/backups/automysqlbackup/status'? Might be some interesting clues
Just list of backuped databases.
there. Do you see anything interesting in '/var/log/mysqld.log'?
Nothing. And as it works when called manually, I think it is more problem of cron. And the system log record "run-crons[10377]: runmysqlbackup returned 1“ isn't very informative either... Other tasks ruled by cron work fine...
regards,
Carl
Thank You, Vojtěch -- Vojtěch Zeisek Komunita openSUSE GNU/Linuxu Community of the openSUSE GNU/Linux http://www.opensuse.org/ http://trapa.cz/
Dne 11.10.2014 v 16:09 Carl Hartung napsal(a):
On Sat, 11 Oct 2014 13:17:40 +0200 Vojtěch Zeisek wrote:
Any ideas how to trace and fix it?
Hi Vojtěch,
I don't have any experience with automysqlbackup, but what's under '/backups/automysqlbackup/status'? Might be some interesting clues there. Do you see anything interesting in '/var/log/mysqld.log'?
OK, I had /etc/cron.daily/runmysqlbackup. It stopped to work. I added line /etc/cron.daily/runmysqlbackup to /etc/cron.daily/cron.daily and it works. Nice. Should I try to understand it...?
regards,
Carl
Sincerely, Vojtěch -- Vojtěch Zeisek Komunita openSUSE GNU/Linuxu Community of the openSUSE GNU/Linux http://www.opensuse.org/ http://trapa.cz/cs
participants (2)
-
Carl Hartung
-
Vojtěch Zeisek