Hi,

31.10.2008 10:27, Isabel Bermejo wrote:
> 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

I assume this works correctly.

> 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

This is probably not what you want - the FIFO is read by the FD and 
you've already set that up above.

Here, you need a normal storage device - either a tape drive or a disk 
directory where the volumes will be written to. The SD doesn't need to 
know anything about the FIFO setup.

>    Label Media = yes
>    Random Access = no
>    AutomaticMount = no
>    RemovableMedia = no
>    MaximumOpenWait = 60
>    AlwaysOpen = no

Those settings also look like you tried to set up a FIFO for storage - 
you can do that, but is is in no way related to the FIFO where the 
backed up data comes from.

You'd need a FIFO created on the SD, which would direct its output 
somewhere else.

You probably should simply try this with a regular disk-based storage 
first.

Arno

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

-- 
Arno Lehmann
IT-Service Lehmann
Sandstr. 6, 49080 Osnabrück
www.its-lehmann.de

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