Hi Kendall, as people previously awsered your thread ;-(

Your trouble came that you launch a dir job inside a fd-job ...
Also your script doesn't launch bacula (db) bacula (user) bacula (default 
password)

Read my post about how to run the script inside the dir user env.



Kendall Shaw wrote:
> 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


-- 

      Bruno Friedmann

Ioda-Net Sàrl   - www.ioda-net.ch
   2830 Vellerat - Switzerland

   Tél : ++41 32 435 7171
   Fax : ++41 32 435 7172
   gsm : ++41 78 802 6760

C'est Facile et Cool d'Évoluer en ligne : www.cfcel.com


-------------------------------------------------------------------------
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