Hello,

I have to backup machines which have been configured different ways for the same feature. In fact, I want to backup mysql binlogs on a hourly basis.
binlogs can be located at different locations:
 /home/mysql
 /usr/local/mysql/data
 /home/binlogs
Depending on the client.

If I use the following Fileset directive,

FileSet {
  Name = "Mysql Binlogs"
  Include {
    Options {
      signature = MD5
      wildfile = "*-bin.*"
    }
    Options {
      Regex = ".*"
      Exclude = yes
    }
    File = "/home/mysql"
    File = "/home/binlogs"
    File = "/usr/local/mysql/data"
  }
  Ignore Fileset Changes = yes
}

the backup log contains:

10-mai 05:17 tucana-dir JobId 117: Start Backup JobId 117, Job=Backup_aquila1_binlogs.2011-05-10_05.17.00_46
10-mai 05:17 tucana-dir JobId 117: Using Device "FileStorage"
10-mai 05:17 tucana-dir JobId 117: Sending Accurate information.
10-mai 05:17 aquila1-fd JobId 117:      Could not stat "/home/binlogs": ERR=No such file or directory
10-mai 05:17 aquila1-fd JobId 117:      Could not stat "/usr/local/mysql/data": ERR=No such file or directory
10-mai 05:17 tucana-sd JobId 117: Job write elapsed time = 00:00:03, Transfer rate = 5.502 M Bytes/second
10-mai 05:17 tucana-dir JobId 117: Bacula tucana-dir 5.0.2 (28Apr10): 10-mai-2011 05:17:06
  [...]
  Non-fatal FD errors:    2
  SD Errors:              0
  FD termination status:  OK
  SD termination status:  OK
  Termination:            Backup OK -- with warnings

I would like to tune my Fileset definition to avoid these non-fatal errors.
If I run the following command on the client, I'm sure to get the correct path to backup:

`awk '{ if($1 ~ /^log[-_]bin/ && NF==3) logfile=$3; else if($1 ~ /^datadir/) datadir=$3 } END { if (logfile != NULL) print "dirname " logfile; else print "echo " datadir }' /etc/mysql/my.cnf`

I created /tmp/binlogs.sh:

8<------
#!/bin/bash

`awk '{ if($1 ~ /^log[-_]bin/ && NF==3) logfile=$3; else if($1 ~ /^datadir/) datadir=$3 } END { if (logfile != NULL) print "dirname " logfile; else print "echo " datadir }' /etc/mysql/my.cnf`
------->8

If I set File = "\\| /tmp/binlogs.sh" the backup runs fine.
I would like to use the awk command directly in the Fileset directive.
Any time I use a backquote, the command fails and my backup does not work.

My last attempt was: File = "\\| bash -c \"`/usr/bin/awk '{ if(\$1 ~ /^log[-_]bin/ && NF==3) logfile=\$3; else if(\$1 ~ /^datadir/) datadir=\$3 } END { if (logfile != NULL) print \"dirname \" logfile; else print \"echo \" datadir }' /etc/mysql/my.cnf`\""
I tried with: File = "\\| bash -c \"\`/usr/bin/awk '/datadir/ {print \"echo \" \$3}' /etc/mysql/my.cnf\`\" " without success.

aquila1:~#  bash -c "`/usr/bin/awk '/datadir/ {print "echo " $3}' /etc/mysql/my.cnf`"
/home/mysql
aquila1:~# bash -c "`awk '{ if($1 ~ /^log[-_]bin/ && NF==3) logfile=$3; else if($1 ~ /^datadir/) datadir=$3 } END { if (logfile != NULL) print "dirname " logfile; else print "echo " datadir }' /etc/mysql/my.cnf`"
/home/mysql

10-mai 11:17 aquila1-fd JobId 149: Fatal error: Error running program: bash -c "`/usr/bin/awk '/datadir/ {print "echo " $3}' /etc/mysql/my.cnf`". stat=2: ERR=Child exited with code 2
10-mai 10:31 aquila1-fd JobId 144: Fatal error: Error running program: bash -c "`/usr/bin/awk '{ if($1 ~ /^log[-_]bin/ && NF==3) logfile=$3; else if($1 ~ /^datadir/) datadir=$3 } END { if (logfile != NULL) print "dirname " logfile; else print "echo " datadir }' /etc/mysql/my.cnf`". stat=2: ERR=Child exited with code 2

What could I try to perform what I want ?

Best regards.
Jerome Blion.