On Sun, 2008-07-27 at 09:32 -0400, Dan Langille wrote:
> James Bowes wrote:
> > 
> > On Sat, 2008-07-26 at 20:32 -0400, Dan Langille wrote:
> >> James Bowes wrote:
> >>> Hi.
> >>>
> >>> I am still having some problems running the BackupCatalog. Would anyone
> >>> be able to point out where my mistake is so I figure out why it doesn't
> >>> run?
> >> Could you elaborate up on "doesn't run"?  It helps to know more than 
> >> your configuration.  For example, errors messages etc.
> 
>  > It's the dreaded cannot stat bacula.sql error. I posted this before
>  > and was unable to get any response about this.
> 
> I have no idea what you are talking about.  :)

For what it's worth, I have also posted about this issue, in the thread
titled "Cannot stat bacula.sql", though my RunBeforeJob statement runs
the script make_catalog_backup, rather than an awk script. If I run
make_catalog_backup, as the bacula user, with the same parameters, it
creates bacula.sql, but the job complains that it cannot stat
bacula.sql.

The job:

Job {
  Name = pokey-catalog
  Type = Backup
  Level = Full
  FileSet = pokey-catalog
  Messages = Standard
  Pool = pokey-pool
  Client = pokey-fd
  Schedule = daily-after-backup
  # This creates an ASCII copy of the catalog
  RunBeforeJob = "/usr/local/libexec/bacula/make_catalog_backup bacula
bacula"
  # This deletes the copy of the catalog
  RunAfterJob  = "/usr/local/libexec/bacula/delete_catalog_backup"
  Write Bootstrap = "/var/bacula/BackupCatalog.bsr"
  Priority = 11                   # run after main backup
}

The log of a job run:

21-Jul 03:00 archie-dir JobId 18: BeforeJob: run command
"/usr/local/libexec/bacula/make_catalog_backup bacula bacula"
21-Jul 03:00 archie-dir JobId 18: Start Backup JobId 18,
Job=pokey-catalog.2008-07-21_03.00.27
21-Jul 03:00 archie-dir JobId 18: There are no more Jobs associated with
Volume "Vol0009". Marking it purged.
21-Jul 03:00 archie-dir JobId 18: All records pruned from Volume
"Vol0009"; marking it "Purged"
21-Jul 03:00 archie-dir JobId 18: Recycled volume "Vol0009"
21-Jul 03:00 archie-dir JobId 18: Using Device "pokey-storage"
21-Jul 03:00 archie-sd JobId 18: Recycled volume "Vol0009" on device
"pokey-storage" (/usr/local/archive/pokey), all previous data lost.
21-Jul 03:00 archie-dir JobId 18: Max Volume jobs exceeded. Marking
Volume "Vol0009" as Used.
21-Jul 03:06 pokey-fd JobId 18:      Could not
stat /var/bacula/bacula.sql: ERR=No such file or directory
21-Jul 03:00 archie-sd JobId 18: Job write elapsed time = 00:00:01,
Transfer rate = 0  bytes/second
21-Jul 03:00 archie-dir JobId 18: Bacula archie-dir 2.2.8 (26Jan08):
21-Jul-2008 03:00:19
  Build OS:               x86_64-unknown-openbsd4.3 openbsd 4.3
  JobId:                  18
  Job:                    pokey-catalog.2008-07-21_03.00.27
  Backup Level:           Full
  Client:                 "pokey-fd" 2.2.8 (26Jan08)
i686-pc-linux-gnu,debian,lenny/sid
  FileSet:                "pokey-catalog" 2008-07-07 03:00:00
  Pool:                   "pokey-pool" (From Job resource)
  Storage:                "pokey-archive" (From Pool resource)
  Scheduled time:         21-Jul-2008 03:00:00
  Start time:             21-Jul-2008 03:00:18
  End time:               21-Jul-2008 03:00:19
  Elapsed time:           1 sec
  Priority:               11
  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
  Storage Encryption:     no
  Volume name(s):         Vol0009
  Volume Session Id:      18
  Volume Session Time:    1215368484
  Last Volume Bytes:      626 (626 B)
  Non-fatal FD errors:    1
  SD Errors:              0
  FD termination status:  OK
  SD termination status:  OK
  Termination:            Backup OK -- with warnings

21-Jul 03:00 archie-dir JobId 18: Begin pruning Jobs.
21-Jul 03:00 archie-dir JobId 18: No Jobs found to prune.
21-Jul 03:00 archie-dir JobId 18: Begin pruning Files.
21-Jul 03:00 archie-dir JobId 18: No Files found to prune.
21-Jul 03:00 archie-dir JobId 18: End auto prune.

21-Jul 03:00 archie-dir JobId 18: AfterJob: run command
"/usr/local/libexec/bacula/delete_catalog_backup"


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users