Recently FreeBSD announced that its default Perl version is now 5.20 and urged all users to upgrade to that version. I did so. Now make_catalog_backup.pl doesn’t run. The first indication was as follows:

 

30-May 09:05 pisces-dir JobId 15770: shell command: run BeforeJob "/usr/local/share/bacula/make_catalog_backup1.pl MyCatalog"

30-May 09:05 pisces-dir JobId 15770: BeforeJob: Statement unlikely to be reached at /usr/local/share/bacula/make_catalog_backup1.pl line 40.

30-May 09:05 pisces-dir JobId 15770: BeforeJob:       (Maybe you meant system() when you said exec()?)

30-May 09:05 pisces-dir JobId 15770: BeforeJob: Statement unlikely to be reached at /usr/local/share/bacula/make_catalog_backup1.pl line 67.

30-May 09:05 pisces-dir JobId 15770: BeforeJob:       (Maybe you meant system() when you said exec()?)

30-May 09:05 pisces-dir JobId 15770: BeforeJob: Statement unlikely to be reached at /usr/local/share/bacula/make_catalog_backup1.pl line 97.

30-May 09:05 pisces-dir JobId 15770: BeforeJob:       (Maybe you meant system() when you said exec()?)

30-May 09:05 pisces-dir JobId 15770: BeforeJob: cannot create /backup/bacula.sql: Permission denied

30-May 09:05 pisces-dir JobId 15770: Error: Runscript: BeforeJob returned non-zero status=2. ERR=Child exited with code 2

30-May 09:05 pisces-dir JobId 15770: Error: Bacula pisces-dir 7.0.5 (28Jul14):

  Build OS:               i386-portbld-freebsd9.3 freebsd 9.3-RELEASE-p5

  JobId:                  15770

  Job:                    BackupCatalog.2015-05-30_09.05.00_22

  Backup Level:           Full

  Client:                 "pisces-fd" 7.0.5 (28Jul14) i386-portbld-freebsd9.3,freebsd,9.3-RELEASE-p5

  FileSet:                "Catalog" 2010-10-06 06:00:00

  Pool:                   "BackupCatalog" (From Run Pool override)

  Catalog:                "MyCatalog" (From Client resource)

  Storage:                "FileStorageBackupCatalog" (From Job resource)

  Scheduled time:         30-May-2015 09:05:00

  Start time:             30-May-2015 09:05:02

  End time:               30-May-2015 09:05:03

  Elapsed time:           1 sec

  Priority:               30

  FD Files Written:       0

  SD Files Written:       0

  FD Bytes Written:       0 (0 B)

  SD Bytes Written:       0 (0 B)

  Rate:                   0.0 KB/s

  Software Compression:   None

  VSS:                    no

  Encryption:             no

  Accurate:               no

  Volume name(s):        

  Volume Session Id:      0

  Volume Session Time:    0

  Last Volume Bytes:      0 (0 B)

  Non-fatal FD errors:    1

  SD Errors:              0

  FD termination status: 

  SD termination status: 

  Termination:            *** Backup Error ***

 

 

Okay, so I changed all three instances of the ‘exec’ string to ‘system’. I tested the script manually and it succeeded. The next time it ran unattended, an error message was produced as follows:

 

02-Jun 06:00 pisces-dir JobId 15778: shell command: run BeforeJob "/usr/local/share/bacula/make_catalog_backup1.pl MyCatalog"

02-Jun 06:03 pisces-dir JobId 15778: BeforeJob: Error while executing postgres dump

02-Jun 06:03 pisces-dir JobId 15778: Error: Runscript: BeforeJob returned non-zero status=1. ERR=Child exited with code 1

02-Jun 06:03 pisces-dir JobId 15778: Error: Bacula pisces-dir 7.0.5 (28Jul14):

  Build OS:               i386-portbld-freebsd9.3 freebsd 9.3-RELEASE-p5

  JobId:                  15778

  Job:                    BackupCatalog.2015-06-02_06.00.00_32

  Backup Level:           Full

  Client:                 "pisces-fd" 7.0.5 (28Jul14) i386-portbld-freebsd9.3,freebsd,9.3-RELEASE-p5

  FileSet:                "Catalog" 2010-10-06 06:00:00

  Pool:                   "BackupCatalog" (From Run Pool override)

  Catalog:                "MyCatalog" (From Client resource)

  Storage:                "FileStorageBackupCatalog" (From Job resource)

  Scheduled time:         02-Jun-2015 06:00:00

  Start time:             02-Jun-2015 06:03:34

  End time:               02-Jun-2015 06:03:34

  Elapsed time:           0 secs

  Priority:               30

  FD Files Written:       0

  SD Files Written:       0

  FD Bytes Written:       0 (0 B)

  SD Bytes Written:       0 (0 B)

  Rate:                   0.0 KB/s

  Software Compression:   None

  VSS:                    no

  Encryption:             no

  Accurate:               no

  Volume name(s):        

  Volume Session Id:      0

  Volume Session Time:    0

  Last Volume Bytes:      0 (0 B)

  Non-fatal FD errors:    1

  SD Errors:              0

  FD termination status: 

  SD termination status: 

  Termination:            *** Backup Error ***

 

Checking the backup location of the SQL dump shows that the dump was successful:

 

root@pisces:/usr/local/share/bacula# ll /backup

total 5718218

< .. snip .. >

-rw-------  1 bacula  bacula             5852490083 Jun  2 06:03 bacula.sql

< .. snip .. >

root@pisces:/usr/local/share/bacula#

 

I’m not sure what needs to be done next in order to avoid the error from occurring. Can someone shed light on what I need to do next? Running Bacula 7.0.5 on FreeBSD 9.3.

 

~Doug