Re: [Bacula-users] Database trouble on 9.0.4

2017-12-29 Thread Matthias Koch-Schirrmeister 
Am 29.12.2017 um 15:07 schrieb Dan Langille:

>>  JobId 21: BeforeJob: could not identify current directory:
>> Permission denied
>>  JobId 21: BeforeJob: could not identify current directory:
>> Permission denied
>>  JobId 21: BeforeJob: psql: could not find own program executable
>>  JobId 21: BeforeJob: root doesn't have access to the catalog
>> database
>>  JobId 21: Error: Runscript: BeforeJob returned non-zero
>> status=1. ERR=Child exited with code 1

> What is this script doing?


Oops, I missed the first line when copying. This is the relevant log output:

 JobId 21: shell command: run BeforeJob "/usr/local
/libexec/bacula/make_catalog_backup.pl MyCatalog"
 JobId 21: BeforeJob: could not identify current directory:
Permission denied
 JobId 21: BeforeJob: could not identify current directory:
Permission denied
 JobId 21: BeforeJob: psql: could not find own program executable
 JobId 21: BeforeJob: root doesn't have access to the catalog
database
 JobId 21: Error: Runscript: BeforeJob returned non-zero
status=1. ERR=Child exited with code 1


So it's the standard database dump that is performed. Consequently, the
backup of the database fails. I'm not sure if the two "could not
identify current directory:" lines are related because they appear on
the other machine as well, but the databse is properly dumped and backed up.

The script make_catalog_backup.pl and /usr/local/bin/psql are
world-executable.

Matthias



signature.asc
Description: OpenPGP digital signature
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Database trouble on 9.0.4

2017-12-29 Thread Dan Langille 
> On Dec 29, 2017, at 5:00 AM, Matthias Koch-Schirrmeister  
> wrote:
> 
> Good morning everybody,
> 
> a fresh installation of 9.0.4 on OpenBSD 6.2 is giving me various
> troubles. Amoong other things, the catalog backups fail:
> 
> 
> From bacula.log:
> 
>  JobId 21: BeforeJob: could not identify current directory:
> Permission denied
>  JobId 21: BeforeJob: could not identify current directory:
> Permission denied
>  JobId 21: BeforeJob: psql: could not find own program executable
>  JobId 21: BeforeJob: root doesn't have access to the catalog
> database
>  JobId 21: Error: Runscript: BeforeJob returned non-zero
> status=1. ERR=Child exited with code 1

I think this is file / directory permissions.

Check the RunBefore job, the directory it is in, and the directories it will 
access.

I think this is not specifically related to configuration or 9.0.4

Is this script dumping the database?  If so, it is running at the bacula-dir 
server.

If you want it running on the client, you want a slightly different directive, 
perhaps RunBeforeClient.

What is this script doing?

-- 
Dan Langille - BSDCan / PGCon
d...@langille.org




--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Database trouble on 9.0.4

2017-12-29 Thread Matthias Koch-Schirrmeister 
Good morning everybody,

a fresh installation of 9.0.4 on OpenBSD 6.2 is giving me various
troubles. Amoong other things, the catalog backups fail:


From bacula.log:

 JobId 21: BeforeJob: could not identify current directory:
Permission denied
 JobId 21: BeforeJob: could not identify current directory:
Permission denied
 JobId 21: BeforeJob: psql: could not find own program executable
 JobId 21: BeforeJob: root doesn't have access to the catalog
database
 JobId 21: Error: Runscript: BeforeJob returned non-zero
status=1. ERR=Child exited with code 1



A snippet from bacula-dir.conf:
# Generic catalog service
Catalog {
  Name = MyCatalog
  dbname = "bacula"; dbuser = "bacula"; dbpassword = ""
}


From pgAdmin III:

CREATE ROLE bacula LOGIN
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE REPLICATION;


CREATE DATABASE bacula
  WITH OWNER = bacula
   ENCODING = 'SQL_ASCII'
   TABLESPACE = pg_default
   LC_COLLATE = 'C'
   LC_CTYPE = 'C'
   CONNECTION LIMIT = -1;

ALTER DATABASE bacula
  SET DateStyle = 'ISO, YMD';



The whole setup follows widely the setup from another 7.x machine which
has been in production for about two years now.

Am I missing something obvious?

TIA
Matthias, Marburg (Germany)



signature.asc
Description: OpenPGP digital signature
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users