Hi
I'm trying to backup MySQL database using bacula and a FifoStorage. First I
configure a script named "backwithfifo" which dumps the database.

#!/bin/sh
#
exec > /dev/null
SCRIPTDIR=/usr/bin
mkfifo /tmp/tmpfifo
cd $SCRIPTDIR
./mysqldump -h localhost -u root -pclipper iesa > /tmp/tmpfifo
res=$?
if (test $res -ne 0) then
   logger -t mysql -isd ERROR Dump done with errors. Exit status $res
else
   logger -t mysql -isd OK Dump done with no errors. Exit status $res
fi

Then I modify Bacula files to run the backup, using the script, to a
fifofile.

In Bacula-Director file:
Job {
   Name = "BackupMySQL"
   Type = Backup
   Client = client-fd
   FileSet = "MySQLdb"
   Schedule = "WeeklyCycleAfterBackup"
   Storage = FifoStorage
   Messages = Standard
   Pool = MySQLPool
   RunBeforeJob = "/etc/bacula/MyScripts/backwithfifo" #this is the script
which dumps the database to a fifofile
   Write Bootstrap = "/var/lib/bacula/BackupMySQL.bsr"

FileSet {
   Name = "MySQLdb"
   Include {
      Options {
         signature = MD5
         readfifo = yes
      }
      File = /tmp/fifofiles
   }
}

Storage {
   Name = FifoStorage
   Address = xxx.xxx.xxx.xxx
   SDPort = 9103
   Password = "password"
   Device = FifoStorage
   Media Type = Fifo
}

In Bacula-Storage file:
Device {
   Name = FifoStorage
   Media Type = Fifo
   Archive Device = /tmp/fifofiles
   Label Media = yes
   Random Access = no
   AutomaticMount = no
   RemovableMedia = no
   MaximumOpenWait = 60
   AlwaysOpen = no
}

When I run the backup job, it results on an error:

31-Oct 10:08 client-dir: RunBefore: mysql[28164]: Volcado realizado
correctamente.Exit status 0
31-Oct 10:08 client-dir: No prior Full backup Job record found.
31-Oct 10:08 client-dir: No prior or suitable Full backup found. Doing FULL
backup.
31-Oct 10:08 client-dir: Start Backup JobId 10063,
Job=BackupMySQL.2008-10-31_10.07.42
31-Oct 10:08 client-sd: BackupMySQL.2008-10-31_10.07.42 Fatal error:
     Archive "FifoStorage" requested by DIR could not be opened or does not
exist.
31-Oct 10:08 client-dir: BackupMySQL.2008-10-31_10.07.42 Fatal error:
     Storage daemon didn't accept Device "FifoStorage" because:
     3925 Device "FifoStorage" could not be opened or does not exist.
31-Oct 10:08 client-dir: BackupMySQL.2008-10-31_10.07.42 Error: Bacula
1.36.3 (22Apr05): 31-Oct-2008 10:08:26
  JobId:                  10063
  Job:                    BackupMySQL.2008-10-31_10.07.42
  Backup Level:           Full (upgraded from Incremental)
  Client:                 client-fd
  FileSet:                "MySQLdb" 2008-10-31 09:59:45
  Pool:                   "MySQLPool"
  Storage:                "FifoStorage"
  Start time:             31-Oct-2008 10:07:44
  End time:               31-Oct-2008 10:08:26
  FD Files Written:       0
  SD Files Written:       0
  FD Bytes Written:       0
  SD Bytes Written:       0
  Rate:                   0.0 KB/s
  Software Compression:   None
  Volume name(s):
  Volume Session Id:      2
  Volume Session Time:    1225443462
  Last Volume Bytes:      0
  Non-fatal FD errors:    0
  SD Errors:              0
  FD termination status:
  SD termination status:
  Termination:            *** Backup Error ***

As you can see, the error is "Storage daemon didn't accept Device
FifoStorage because could not be opened or does not exist". I can see the
file fifofile in /tmp/fifofile and I can do a cat but the Storage Daemon
seems can't open the file. I don't know how to configure a backup job for a
database using fifo. Can anyone tell me where is the error?

Thanks a lot
ISABEL


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