Backup Central

Thanks everyone. The permission denied error below started to occur when I followed the instruction and cleaned up the bacula.sql file.

12-Jan 05:39 babar-dir JobId 1639: shell command: run BeforeJob "/etc/bacula/scripts/make_catalog_backup.pl MyCatalog"
12-Jan 05:39 babar-dir JobId 1639: BeforeJob: sh: cannot create /var/lib/bacula/bacula.sql: Permission denied
12-Jan 05:39 babar-dir JobId 1639: Error: Runscript: BeforeJob returned non-zero status=2. ERR=Child exited with code 2
12-Jan 05:39 babar-dir JobId 1639: Error: Bacula babar-dir 5.0.1 (24Feb10): 12-Jan-2012 05:39:13

These were the commands I ran to cleanup the database:

mysqldump -f --opt bacula > bacula.sql
mysql bacula < bacula.sql
rm -f bacula.sql

How can I test and find out what's wrong here? When I had shut down the backup server, everything was fine. Looks like something is holiding up the servers until 8 AM or so, just can't tell what that is.

I'd appreciate your help,
h



From: bwalton < at > artsci.utoronto.ca
To: bacula-users < at > lists.sourceforge.net
Date: Thu, 12 Jan 2012 10:33:32 -0500
Subject: Re: [Bacula-users] Bacula database is getting too long

Excerpts from Martin Simmons's message of Thu Jan 12 10:25:02 -0500 2012:

The mail server's name is Gauss and although I have it setup babar
(name of the backup server where has bacula installed) to start at
20:05 every night, the mail server will not be accessible until
8:15 AM and by that I mean people at work cannot get their
messages or send messages because the server is not responding.

This is very unlikely to be caused by Bacula.

Agreed, but if there are, say, network issues, bacula could exacerbate
a problem that flies under the radar during normal operation. I'd be
checking the network settings on every device from the NIC to the
backup server and running some performance tools while bacula is not
active to see if you experience the same degradation.

HTH
-Ben
--
Ben Walton
Systems Programmer - CHASS
University of Toronto
C:416.407.5610 | W:416.978.4302


------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

12.1.2012 18:10, Honia A kirjoitti:
Thanks everyone. The permission denied error below started to occur when
I followed the instruction and cleaned up the bacula.sql file.

12-Jan 05:39 babar-dir JobId 1639: shell command: run BeforeJob
"/etc/bacula/scripts/make_catalog_backup.pl MyCatalog"
12-Jan 05:39 babar-dir JobId 1639: BeforeJob: sh: cannot create
/var/lib/bacula/bacula.sql: Permission denied
12-Jan 05:39 babar-dir JobId 1639: Error: Runscript: BeforeJob returned
non-zero status=2. ERR=Child exited with code 2
12-Jan 05:39 babar-dir JobId 1639: Error: Bacula babar-dir 5.0.1
(24Feb10): 12-Jan-2012 05:39:13

These were the commands I ran to cleanup the database:

mysqldump -f --opt bacula > bacula.sql
mysql bacula < bacula.sql
rm -f bacula.sql

How can I test and find out what's wrong here? When I had shut down the
backup server, everything was fine. Looks like something is holiding up
the servers until 8 AM or so, just can't tell what that is.

I'd appreciate your help,
h* *


The process running bacula-fd can't create your bacula.sql dump file.

12-Jan 05:39 babar-dir JobId 1639: BeforeJob: sh: cannot create
/var/lib/bacula/bacula.sql: Permission denied

Who owns the folder /var/lib/bacula? What kind of permissions are
allowed there for the process running bacula-dir? Bacula-dir is run by
user bacula normally.

--

You're currently going through a difficult transition period called "Life."


------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

After seeing your post I did some research and just ran this to change the ownership but didn't help: chown root:bacula /var/lib/bacula/bacula.sql

The output is: drwx------ 2 bacula bacula 4096 2012-01-12 14:37 bacula

And

-rw-r--r-- 1 root bacula 209927918 2012-01-12 13:45 bacula.sql


root < at > servername:/var/lib/bacula# cd /etc/bacula/scripts
root < at > servername:/etc/bacula/scripts# ls -l
total 72
-rw-r--r-- 1 root root 296 2010-03-23 16:27 btraceback.gdb
-rwxr-xr-x 1 root root 112 2010-03-23 16:27 delete_catalog_backup
-rwxr-xr-x 1 root root 9012 2010-03-23 16:27 disk-changer
-rwxr-xr-x 1 root root 16948 2010-03-23 16:27 dvd-handler
-rwxr-xr-x 1 root root 2047 2010-03-23 16:27 make_catalog_backup
-rw-r--r-- 1 root root 1646 2010-03-23 16:27 make_catalog_backup_awk
-rwxr-xr-x 1 root root 4106 2010-03-23 16:27 make_catalog_backup.pl
-rwxr-xr-x 1 root root 6899 2010-03-23 16:27 mtx-changer
-rwxr-xr-x 1 root root 1506 2010-03-23 16:27 mtx-changer.conf
-rw-r--r-- 1 root root 90 2010-03-23 16:27 query.sql





[b]
[/b]




Date: Thu, 12 Jan 2012 18:49:08 +0200
From: jarif < at > iki.fi
To: bacula-users < at > lists.sourceforge.net
Subject: Re: [Bacula-users] Bacula database is getting too long

12.1.2012 18:10, Honia A kirjoitti:> Thanks everyone. The permission denied error below started to occur when> I followed the instruction and cleaned up the bacula.sql file.> > 12-Jan 05:39 babar-dir JobId 1639: shell command: run BeforeJob> "/etc/bacula/scripts/make_catalog_backup.pl MyCatalog"> 12-Jan 05:39 babar-dir JobId 1639: BeforeJob: sh: cannot create> /var/lib/bacula/bacula.sql: Permission denied> 12-Jan 05:39 babar-dir JobId 1639: Error: Runscript: BeforeJob returned> non-zero status=2. ERR=Child exited with code 2> 12-Jan 05:39 babar-dir JobId 1639: Error: Bacula babar-dir 5.0.1> (24Feb10): 12-Jan-2012 05:39:13> > These were the commands I ran to cleanup the database:> > mysqldump -f --opt bacula > bacula.sql> mysql bacula < bacula.sql> rm -f bacula.sql> > How can I test and find out what's wrong here? When I had shut down the> backup server, everything was fine. Looks like something is holiding up> the servers until 8 AM or so, just can't tell what that is.> > I'd appreciate your help,> h* *> The process running bacula-fd can't create your bacula.sql dump file. > 12-Jan 05:39 babar-dir JobId 1639: BeforeJob: sh: cannot create> /var/lib/bacula/bacula.sql: Permission denied Who owns the folder /var/lib/bacula? What kind of permissions areallowed there for the process running bacula-dir? Bacula-dir is run byuser bacula normally. -- You're currently going through a difficult transition period called "Life."
------------------------------------------------------------------------------ RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400 by Jan. 27 Register now! http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________ Bacula-users mailing list Bacula-users < at > lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users

Il 12/01/2012 21:03, Honia A ha scritto:
After seeing your post I did some research and just ran this to change
the ownership but didn't help: chown root:bacula /var/lib/bacula/bacula.sql


The problem is not the permission bits on bacula.sql file, but rather
those of /var/lib/bacula folder.

If the process that is trying to create the bacula.sql file is run as
user "bacula", then /var/lib/bacula should be owned by user "bacula",
who should have rwx access permission. Or, if user "bacula" is part of
group "bacula", /var/lib/bacula could be owned by root:bacula, provided
group permission is rwx as well.

--
Marcello Romani

------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Thanks for your reply. I just checked the permissions of the bacula folder and see the following:

root < at > servername:/var/lib ([email]root < at > servername:/var/lib[/email])# ls -l
drwx------ 2 bacula bacula 4096 2012-01-13 09:24 bacula

Is this sufficient? I've noticed the mysql error no longer shows up but the BackupCatalog job still returns error:

1650 Full 0 0 Error 12-Jan-12 21:55 BackupCatalog

How can I find out what's causing this error?

Thank you in advance
[b]
[/b]



Date: Fri, 13 Jan 2012 10:58:39 +0100
From: mromani < at > ottotecnica.com
To: bacula-users < at > lists.sourceforge.net
Subject: Re: [Bacula-users] Bacula database is getting too long

Il 12/01/2012 21:03, Honia A ha scritto:
After seeing your post I did some research and just ran this to change
the ownership but didn't help: chown root:bacula /var/lib/bacula/bacula.sql


The problem is not the permission bits on bacula.sql file, but rather
those of /var/lib/bacula folder.

If the process that is trying to create the bacula.sql file is run as
user "bacula", then /var/lib/bacula should be owned by user "bacula",
who should have rwx access permission. Or, if user "bacula" is part of
group "bacula", /var/lib/bacula could be owned by root:bacula, provided
group permission is rwx as well.

--
Marcello Romani

------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Il 13/01/2012 15:30, Honia A ha scritto:
Thanks for your reply. I just checked the permissions of the bacula
folder and see the following:

root < at > servername:/var/lib <mailto:root < at > servername:/var/lib># ls -l
drwx------ 2 bacula bacula 4096 2012-01-13 09:24 bacula

IMHO it should suffice.


Is this sufficient? I've noticed the mysql error no longer shows up but
the BackupCatalog job still returns error:

1650 Full 0 0 Error 12-Jan-12 21:55 BackupCatalog

How can I find out what's causing this error?

Thank you in advance
*
**
*

Well, I'd start reading the job log...

HTH



Date: Fri, 13 Jan 2012 10:58:39 +0100
From: mromani < at > ottotecnica.com
To: bacula-users < at > lists.sourceforge.net
Subject: Re: [Bacula-users] Bacula database is getting too long

Il 12/01/2012 21:03, Honia A ha scritto:
After seeing your post I did some research and just ran this to change
the ownership but didn't help: chown root:bacula
/var/lib/bacula/bacula.sql

The problem is not the permission bits on bacula.sql file, but rather
those of /var/lib/bacula folder.

If the process that is trying to create the bacula.sql file is run as
user "bacula", then /var/lib/bacula should be owned by user "bacula",
who should have rwx access permission. Or, if user "bacula" is part of
group "bacula", /var/lib/bacula could be owned by root:bacula, provided
group permission is rwx as well.

--
Marcello Romani


------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


--
Marcello Romani

------------------------------------------------------------------------------
RSA(R) Conference 2012
Mar 27 - Feb 2
Save $400 by Jan. 27
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev2
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users