Thanks for your reply. I just checked the permissions of the bacula folder and see the following:
Is this sufficient? I've noticed the mysql error no longer shows up but the BackupCatalog job still returns error:
> Date: Fri, 13 Jan 2012 10:58:39 +0100
> From: mromani AT ottotecnica DOT com
> To: bacula-users AT lists.sourceforge DOT 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 DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
