Re: [Bacula-users] Linux Bare Metal Recovery USB

2011-09-19 Thread Geert Stappers
Op 20110915 om 12:24 schreef niki niki:
 How i can make Linux Bare Metal Recovery USB Key on Debian?

http://live.debian.net/manual/
--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] problem of disk space - 80 GB backup catalog...

2011-09-19 Thread Pieter (NL)


LAZARO Bruno wrote:
 
 Hello,
 
  
 
 Attached is the job history BackupCatalog »:
 
  
 
 16-Sep 15:07 tis002-dir JobId 4631: shell command: run BeforeJob
 F:\Serveur_Sauvegarde\Bacula\bin\make_catalog_backup
 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob: 
 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob: C:\WINDOWS\system32DEL /f
 C:\Documents and Settings\All Users\Application
 Data\Bacula\Work\trustbacula.sql  2nul 16-Sep 15:07 tis002-dir JobId
 4631: BeforeJob: 
 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob: C:\WINDOWS\system32set
 path=F:\Serveur_Sauvegarde\wamp\bin\mysql\mysql5.1.36\bin;F:\Serveur_Sauvegarde\wamp\bin\mysql\mysql5.1.36\bin
 
 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob: 
 
 16-Sep 15:07 tis002-dir JobId 4631: BeforeJob:
 C:\WINDOWS\system32F:\Serveur_Sauvegarde\wamp\bin\mysql\mysql5.1.36\bin\mysqldump
 -u bacula --password=trustbacula bacula  1C:\Documents and Settings\All
 Users\Application Data\Bacula\Work\trustbacula.sql 
 
 16-Sep 15:11 tis002-dir JobId 4631: Start Backup JobId 4631,
 Job=BackupCatalog.2011-09-15_23.55.02_25
 
 16-Sep 15:11 tis002-dir JobId 4631: Using Device FileStorage
 
 16-Sep 15:11 tis002-sd JobId 4631: Volume VolLocalN1 previously written,
 moving to end of data.
 
 16-Sep 15:11 tis002-sd JobId 4631: Ready to append to end of Volume
 VolLocalN1 size=85616645910 16-Sep 15:11 tis002-fd JobId 4631: Generate
 VSS snapshots. Driver=VSS Win 2003, Drive(s)=C
 
 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer (BackupComplete):
 SqlServerWriter, State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId
 4631: VSS Writer (BackupComplete): System Writer, State: 0x1
 (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer
 (BackupComplete): WMI Writer, State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14
 tis002-fd JobId 4631: VSS Writer (BackupComplete): FRS Writer, State:
 0x1 (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer
 (BackupComplete): NTDS, State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14
 tis002-sd JobId 4631: Job write elapsed time = 00:03:21, Transfer rate =
 1.510 M bytes/second 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer
 (BackupComplete): Event Log Writer, State: 0x1 (VSS_WS_STABLE) 16-Sep
 15:14 tis002-fd JobId 4631: VSS Writer (BackupComplete): MSDEWriter,
 State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId 4631: VSS Writer
 (BackupComplete): Registry Writer, State: 0x1 (VSS_WS_STABLE) 16-Sep
 15:14 tis002-fd JobId 4631: VSS Writer (BackupComplete): COM+ REGDB
 Writer, State: 0x1 (VSS_WS_STABLE) 16-Sep 15:14 tis002-fd JobId 4631: VSS
 Writer (BackupComplete): IIS Metabase Writer, State: 0x1 (VSS_WS_STABLE)
 16-Sep 15:14 tis002-dir JobId 4631: Bacula tis002-dir 3.0.3a (06Dec09):
 16-Sep-2011 15:14:51
 
   Build OS:   Linux Cross-compile Win32
 
   JobId:  4631
 
   Job:BackupCatalog.2011-09-15_23.55.02_25
 
   Backup Level:   Full
 
   Client: tis002-fd 3.0.3a (06Dec09)
 Linux,Cross-compile,Win32
 
   FileSet:Catalog 2009-11-19 23:55:00
 
   Pool:   Default (From Run pool override)
 
   Catalog:MyCatalog (From Client resource)
 
   Storage:File (From Job resource)
 
   Scheduled time: 15-Sep-2011 23:55:02
 
   Start time: 16-Sep-2011 15:11:29
 
   End time:   16-Sep-2011 15:14:51
 
   Elapsed time:   3 mins 22 secs
 
   Priority:   12
 
   FD Files Written:   1
 
   SD Files Written:   1
 
   FD Bytes Written:   303,681,022 (303.6 MB)
 
   SD Bytes Written:   303,681,220 (303.6 MB)
 
   Rate:   1503.4 KB/s
 
   Software Compression:   None
 
   VSS:yes
 
   Encryption: no
 
   Accurate:   no
 
   Volume name(s): VolLocalN1
 
   Volume Session Id:  133
 
   Volume Session Time:1314373648
 
   Last Volume Bytes:  85,920,552,714 (85.92 GB)
 
   Non-fatal FD errors:0
 
   SD Errors:  0
 
   FD termination status:  OK
 
   SD termination status:  OK
 
   Termination:Backup OK
 
  
 
 16-Sep 15:14 tis002-dir JobId 4631: Begin pruning Jobs.
 
 16-Sep 15:14 tis002-dir JobId 4631: No Jobs found to prune.
 
 16-Sep 15:14 tis002-dir JobId 4631: Begin pruning Files.
 
 16-Sep 15:14 tis002-dir JobId 4631: No Files found to prune.
 
 16-Sep 15:14 tis002-dir JobId 4631: End auto prune.
 
  
 
 16-Sep 15:14 tis002-dir JobId 4631: shell command: run AfterJob
 F:\Serveur_Sauvegarde\Bacula\bin\delete_catalog_backup
 
 16-Sep 15:14 tis002-dir JobId 4631: AfterJob: 
 
 16-Sep 15:14 tis002-dir JobId 4631: AfterJob: C:\WINDOWS\system32DEL /f
 C:\Documents and Settings\All Users\Application
 Data\Bacula\Work\trustbacula.sql 
 
  
 
  
 
 Sincerely,Trust-informatique
 
  
 
  
 
 De : LAZARO Bruno 
 Envoyé : vendredi 16 septembre 2011 15:07
 À : 'bacula-users@lists.sourceforge.net'
 Cc : exploit
 Objet : problem of disk space - 80 GB backup catalog...
 
  
 
 

Re: [Bacula-users] Backing up lvm snapshots?

2011-09-19 Thread Konstantin Khomoutov
On Sun, 18 Sep 2011 17:47:34 +0200
Tobias Schenk tob...@die-schenks.net wrote:

 I try use bacula 5.0.3 on suse linux to backup lvm snapshots.
 Basically, I create a lvm snapshot called /dev/vmguests/backup using
 the RunScript directive. Unfortunately, this is a sym link
 to /dev/dm-6. I cannot be sure it is always dm-6. I would like to
 follow the sym link and backup /dev/dm-6 as raw device.
 
 The hints I found while googling are are not working (like
 appending /. to the File directive) or obscure (like using bash
 scripting to resolve File names).
 I cannot simply mount /dev/dm-6 to somewhere because the contents is
 a partitioned raw device of a kvm instance.
 Maybe it is possible resolve the link using a bash script in the file 
 directive
You can use the `readlink` command to resolve the symlink.

 but I have not found information about when the File
 directive will be evaluated relative to RunScript.
 
 Has anyone a working solution for lvm snapshots?
 
 The Job currently looks very plainly like this:
 
 FileSet {
Name = FsVMMyDms   # Adjust to VM
Include {
  Options {
compression = GZIP
signature = SHA1
sparse = yes
  }
  File = /dev/vmguests/backup
}
 }
You can try to use something like

File = | readlink /dev/vmguests/backup

to dynamically read that file containing the real device name.

--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Full backups and off-sites

2011-09-19 Thread Alan Brown
Wouter Verhelst wrote:

 Is it possible to have bacula base its incremental backups not on the
 most recent full backup, but on the one preceding that?

Only if you setup seperate jobs.

 This way, you
 can have your most recent full backup off-site, yet you should still be
 able to restore the most recent version of a file, even if that tape
 just happens to be off-site, without having to retrive them from the
 off-site location.

Investing in a _good_ fireproof data safe isn't expensive compared with 
the cost of the other equipment ($500-$7000, depending on requirements)

A fully certified one can handle 2 hours at 1200C, survive a drop of 10 
metres and then another hour burning and 24-48 hours cooldown without 
the internal temperature exceeding 60C

Check out http://www.phoenixsafeusa.com/

As a matter of policy: Your backup equipment should be isolated from the 
rest of the data centre, preferably in a separate building and at least 
in a separate room with its own fire supression setup. I know this isn't 
always practical but it's something you should shoot for when setting 
things up.






--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread Oliver Hoffmann
Hello list,

bacula does a ClientRunBeforeJob which is a mysqldump script. The
script returns an error (problem with Lock Tables) but the email has
the subject Bacula: Backup OK of myclient-fd Incremental.
Even webacula shows an OK. 
This is misleading and this way one would be forced to read every
status mail. Any (nice) ideas how to deal with it? All right, I could
alter my script or something but maybe there is a way to put a keyword
into the subject? 

Thanx for input,

Oliver

--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread John Drescher
On Mon, Sep 19, 2011 at 8:58 AM, Oliver Hoffmann o...@dom.de wrote:
 Hello list,

 bacula does a ClientRunBeforeJob which is a mysqldump script. The
 script returns an error (problem with Lock Tables) but the email has
 the subject Bacula: Backup OK of myclient-fd Incremental.
 Even webacula shows an OK.
 This is misleading and this way one would be forced to read every
 status mail. Any (nice) ideas how to deal with it? All right, I could
 alter my script or something but maybe there is a way to put a keyword
 into the subject?


Get your script to return a non zero exit status on database error.

John

--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread Jeremy Maes

Op 19/09/2011 15:27, John Drescher schreef:

On Mon, Sep 19, 2011 at 8:58 AM, Oliver Hoffmanno...@dom.de  wrote:

Hello list,

bacula does a ClientRunBeforeJob which is a mysqldump script. The
script returns an error (problem with Lock Tables) but the email has
the subject Bacula: Backup OK of myclient-fd Incremental.
Even webacula shows an OK.
This is misleading and this way one would be forced to read every
status mail. Any (nice) ideas how to deal with it? All right, I could
alter my script or something but maybe there is a way to put a keyword
into the subject?


Get your script to return a non zero exit status on database error.

John
In my experience, Bacula will not see a failing script as an 'Error' but 
rather as a 'Warning'.
The status line at the bottom of your email should say 
/Termination:Backup OK -- with warnings/ but the subject 
will still be /Backup OK/.
(my mysqldump script does return 1 on failure and bacula reports this, 
but it's still only a 'warning')


There are a few ways to get this info from what I know. You could have 
your script parse that specific /Termination/ line in the email (should 
be pretty straightforward).
Another way is to get the info from the bacula database with an SQL 
query. An example query the way I use it:


/SELECT JobID, Name, Level, Job.JobStatus, JobStatusLong, SchedTime, 
RealEndTime, JobErrors

FROM Job
INNER JOIN Status
ON (Job.JobStatus = Status.JobStatus)
WHERE ( Type = 'B' OR Type = 'V' )
AND DATE_SUB(NOW(),INTERVAL 18 HOUR) = SchedTime;
EOFCMD/

This runs in a script after all jobs and gets parsed afterwards. The 
JobErrors field will increase for each warning or error, so as soon as 
it differs from 0 it's worth taking a look at the given job.


There's probably other ways I haven't thought of aswell :)

Kind regards,
Jeremy

 DISCLAIMER 
http://www.schaubroeck.be/maildisclaimer.htm
--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 ___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread Konstantin Khomoutov
On Mon, 19 Sep 2011 09:27:54 -0400
John Drescher dresche...@gmail.com wrote:

  bacula does a ClientRunBeforeJob which is a mysqldump script. The
  script returns an error (problem with Lock Tables) but the email has
  the subject Bacula: Backup OK of myclient-fd Incremental.
  Even webacula shows an OK.
  This is misleading and this way one would be forced to read every
  status mail. Any (nice) ideas how to deal with it? All right, I
  could alter my script or something but maybe there is a way to put
  a keyword into the subject?
 
 
 Get your script to return a non zero exit status on database error.
I'd like to add that the easiest way to achieve this is to
add

set -e

at the beginning of the script (assuming it's a Unix shell script).
In this case the script will fail as soon as the first command
pipeline it runs exits with a non-zero exit code.

Actually, I think that a good programming practice is to always start a
shell script with `set -e -u`.

--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread Ben Walton
Excerpts from John Drescher's message of Mon Sep 19 09:27:54 -0400 2011:

 Get your script to return a non zero exit status on database error.

This would see the whole job fail without backing anything else up
though, no?  Although that might be appropriate in some, cases, I
think the OP wanted the job to complete but present an easy to pick
out visual indicator that it wasn't a clean run.

I can appreciate this need as it's something I'd like as well.

Thanks
-Ben
--
Ben Walton
Systems Programmer - CHASS
University of Toronto
C:416.407.5610 | W:416.978.4302


--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread Jeremy Maes
Op 19/09/2011 16:00, Ben Walton schreef:
 Excerpts from John Drescher's message of Mon Sep 19 09:27:54 -0400 2011:

 Get your script to return a non zero exit status on database error.
 This would see the whole job fail without backing anything else up
 though, no?  Although that might be appropriate in some, cases, I
 think the OP wanted the job to complete but present an easy to pick
 out visual indicator that it wasn't a clean run.
I'm not sure of the default value of the Fail Job On Error setting for 
a Client Before Job, but it's pretty easy to specify it yourself and set 
it to no.
That way the errors will be reported, along with any script output to 
console, but the job itself won't fail even if the script fails.

 I can appreciate this need as it's something I'd like as well.

 Thanks
 -Ben


  DISCLAIMER 
http://www.schaubroeck.be/maildisclaimer.htm

--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread Oliver Hoffmann
Didn't help. As well as set -e.
The script basically does the following. Make a list of databases with
mysqlshow and then do mysqldumps for all the db found in the list. So
the important part here is:

for i in `cat list.txt`
do

 /usr/bin/mysqldump $i 

   if [ $? != 0 ]; then
exit 1

   fi

done

exit 0

I still got Backup OK of
The error message if mysqldump is ClientRunBeforeJob: mysqldump: Got
error: 1449: The user specified as a definer ('xyz'@'%') does not exist
when using LOCK TABLES

The result is a dump with a few kb. Anyway, the problem is that I can't
see that problem at once. A Termination: Backup OK -- with
warnings would be just fine as I could easily filter those mails to
appear in my inbox.

Oliver

 On Mon, Sep 19, 2011 at 8:58 AM, Oliver Hoffmann o...@dom.de wrote:
  Hello list,
 
  bacula does a ClientRunBeforeJob which is a mysqldump script. The
  script returns an error (problem with Lock Tables) but the email has
  the subject Bacula: Backup OK of myclient-fd Incremental.
  Even webacula shows an OK.
  This is misleading and this way one would be forced to read every
  status mail. Any (nice) ideas how to deal with it? All right, I
  could alter my script or something but maybe there is a way to put
  a keyword into the subject?
 
 
 Get your script to return a non zero exit status on database error.
 
 John
 



--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread John Drescher
On Mon, Sep 19, 2011 at 10:23 AM, Oliver Hoffmann o...@dom.de wrote:
 This would see the whole job fail without backing anything else up
 though, no?  Although that might be appropriate in some, cases, I
 think the OP wanted the job to complete but present an easy to pick
 out visual indicator that it wasn't a clean run.

 Exactly!


Would it be too inconvenient to run the database backup as a separate job?

John

--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread Oliver Hoffmann
 On Mon, Sep 19, 2011 at 10:23 AM, Oliver Hoffmann o...@dom.de wrote:
  This would see the whole job fail without backing anything else up
  though, no?  Although that might be appropriate in some, cases, I
  think the OP wanted the job to complete but present an easy to pick
  out visual indicator that it wasn't a clean run.
 
  Exactly!
 
 
 Would it be too inconvenient to run the database backup as a separate
 job?
 
That would be OK, but the script goes like dump of db1, db2, db3, etc.
If it would stop at db2 (because of exit 1) then db3 wouldn't be dumped
which is not what I want.

Oliver


--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] junction point pain

2011-09-19 Thread Ben Walton

Hi All,

Is there an easy way to define a fileset for windows systems where
junction points are ignored by default or will I need to use wildcards
for this?  I'd like to the logs from these jobs to be free of the
clutter from all of the junction points in Users\, etc.

Thanks
-Ben
--
Ben Walton
Systems Programmer - CHASS
University of Toronto
C:416.407.5610 | W:416.978.4302


--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread Jeremy Maes
Op 19/09/2011 16:47, Oliver Hoffmann schreef:
 On Mon, Sep 19, 2011 at 10:23 AM, Oliver Hoffmanno...@dom.de  wrote:
 This would see the whole job fail without backing anything else up
 though, no?  Although that might be appropriate in some, cases, I
 think the OP wanted the job to complete but present an easy to pick
 out visual indicator that it wasn't a clean run.
 Exactly!

 Would it be too inconvenient to run the database backup as a separate
 job?

 That would be OK, but the script goes like dump of db1, db2, db3, etc.
 If it would stop at db2 (because of exit 1) then db3 wouldn't be dumped
 which is not what I want.

 Oliver

I've been a happy user of 
http://sourceforge.net/projects/automysqlbackup/  (v2.5, haven't tried 
v3 yet) for quite some time now, you should be able to configure it to 
do what you want ...

Regards,
Jeremy

  DISCLAIMER 
http://www.schaubroeck.be/maildisclaimer.htm

--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup status OK, but mysql errors

2011-09-19 Thread Oliver Hoffmann
Ben,

you're right, it's directing in a bash script direction. So, coming
back to bacula, I'd better like to find a way of communication between
a ClientRunBeforeJob error and the Termination/mail-subject. With such
a solution tinkering around with every script would be obsolete.

Your trick did not work though.

Oliver

 
 Hi Oliver,
 
 Replying off-list as it's not of general relevance...
 
 I have a similar script that used this pattern.  I ended up modifying
 it to do:
 
  for i in `cat list.txt`
  do
  
   /usr/bin/mysqldump $i 
  
 if [ $? != 0 ]; then
 
   exitcode=1
  
 fi
  
  done
  
 
 exit $exitcode
 
 
 I didn't want a failure in one dump to prevent dumping the other
 db's.  Maybe this is just simplified for email, so forgive me if
 you're already handling this.
 
 HTH.
 
 Thanks
 -Ben
 --
 Ben Walton
 Systems Programmer - CHASS
 University of Toronto
 C:416.407.5610 | W:416.978.4302
 
 


--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] junction point pain

2011-09-19 Thread Bob Hetzel

The current beta version 5.20rc1 seems to no longer output a line for each 
windows junction point it hits.

It might be worth checking out just the windows client (assuming you're 
already running a 5.x director/storage to see if it suits your needs before 
they do the final 5.2 release.

Bob


 From: Ben Walton bwal...@artsci.utoronto.ca
 Subject: [Bacula-users] junction point pain
 To: Bacula Users bacula-users@lists.sourceforge.net
 Message-ID: 131686-sup-9...@pinkfloyd.chass.utoronto.ca
 Content-Type: text/plain; charset=UTF-8


 Hi All,

 Is there an easy way to define a fileset for windows systems where
 junction points are ignored by default or will I need to use wildcards
 for this?  I'd like to the logs from these jobs to be free of the
 clutter from all of the junction points in Users\, etc.

 Thanks
 -Ben
 --
 Ben Walton
 Systems Programmer - CHASS
 University of Toronto
 C:416.407.5610 | W:416.978.4302



--
BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerryreg; mobile platform with sessions, labs  more.
See new tools and technologies. Register for BlackBerryreg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backing up lvm snapshots?

2011-09-19 Thread Tobias Schenk
Am 19.09.2011 10:35, schrieb Konstantin Khomoutov:
 On Sun, 18 Sep 2011 17:47:34 +0200
 Tobias Schenktob...@die-schenks.net  wrote:

 I try use bacula 5.0.3 on suse linux to backup lvm snapshots.
 Basically, I create a lvm snapshot called /dev/vmguests/backup using
 the RunScript directive. Unfortunately, this is a sym link
 to /dev/dm-6. I cannot be sure it is always dm-6. I would like to
 follow the sym link and backup /dev/dm-6 as raw device.

 The hints I found while googling are are not working (like
 appending /. to the File directive) or obscure (like using bash
 scripting to resolve File names).
 I cannot simply mount /dev/dm-6 to somewhere because the contents is
 a partitioned raw device of a kvm instance.
 Maybe it is possible resolve the link using a bash script in the file
 directive
 You can use the `readlink` command to resolve the symlink.

 but I have not found information about when the File
 directive will be evaluated relative to RunScript.

 Has anyone a working solution for lvm snapshots?

 The Job currently looks very plainly like this:

 FileSet {
 Name = FsVMMyDms   # Adjust to VM
 Include {
   Options {
 compression = GZIP
 signature = SHA1
 sparse = yes
   }
   File = /dev/vmguests/backup
 }
 }
 You can try to use something like

 File = | readlink /dev/vmguests/backup

 to dynamically read that file containing the real device name.


--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Fwd: Re: Backing up lvm snapshots?

2011-09-19 Thread Tobias Schenk
Oh, sorry, I really got confused with this mail.

Hello,

thank you for the comments regarding readlink. Unfortunately, it does
not work :(
if I do:
bashreadlink /dev/vmguests/backup
I get:
../dm-6

I was suspicous about the relative path but this can be healed by adding -f:
bashreadlink -f /dev/vmguests/backup
/dev/vmguests/dm-6

With this new weapon I changed the File = directive as described in your
mails: File = | readlink /dev/vmguests/backup.
I open bconsole, do reload, do run, select job ... and get 89 bytes
backuped.
( I tested also the -f variant)

I cross checked by changing File= /dev/dm-6. This saves 4.4GB of data.

My guess is that the link does not yet exist when the Fileset is parsed.
How can I find out about this. Can I raise the log level to see the
parsed version of File= ?

Thank you for any advice,
Tobias


Am 19.09.2011 10:35, schrieb Konstantin Khomoutov:
  On Sun, 18 Sep 2011 17:47:34 +0200
  Tobias Schenktob...@die-schenks.net   wrote:

  I try use bacula 5.0.3 on suse linux to backup lvm snapshots.
  Basically, I create a lvm snapshot called /dev/vmguests/backup using
  the RunScript directive. Unfortunately, this is a sym link
  to /dev/dm-6. I cannot be sure it is always dm-6. I would like to
  follow the sym link and backup /dev/dm-6 as raw device.

  The hints I found while googling are are not working (like
  appending /. to the File directive) or obscure (like using bash
  scripting to resolve File names).
  I cannot simply mount /dev/dm-6 to somewhere because the contents is
  a partitioned raw device of a kvm instance.
  Maybe it is possible resolve the link using a bash script in the file
  directive
  You can use the `readlink` command to resolve the symlink.

  but I have not found information about when the File
  directive will be evaluated relative to RunScript.

  Has anyone a working solution for lvm snapshots?

  The Job currently looks very plainly like this:

  FileSet {
  Name = FsVMMyDms   # Adjust to VM
  Include {
Options {
  compression = GZIP
  signature = SHA1
  sparse = yes
}
File = /dev/vmguests/backup
  }
  }
  You can try to use something like

  File = | readlink /dev/vmguests/backup

  to dynamically read that file containing the real device name.



--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] junction point pain

2011-09-19 Thread Ben Walton
Excerpts from Bob Hetzel's message of Mon Sep 19 13:53:25 -0400 2011:

Hi Bob,

 It might be worth checking out just the windows client (assuming
 you're already running a 5.x director/storage to see if it suits
 your needs before they do the final 5.2 release.

Thanks for the pointer.  I'll see if this decreases the whining! :)

Thanks
-Ben
--
Ben Walton
Systems Programmer - CHASS
University of Toronto
C:416.407.5610 | W:416.978.4302


--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Fwd: Re: Backing up lvm snapshots?

2011-09-19 Thread Mark
Hi,

On Mon, Sep 19, 2011 at 3:22 PM, Tobias Schenk tob...@die-schenks.netwrote:

 Oh, sorry, I really got confused with this mail.

 Hello,

 thank you for the comments regarding readlink. Unfortunately, it does
 not work :(
 if I do:
 bashreadlink /dev/vmguests/backup
 I get:
 ../dm-6


Does it work if you add the ' --canonicalize' option?

readlink --canonicalize /dev/vmguests/backup


HTH,
Mark
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Fwd: Re: Backing up lvm snapshots?

2011-09-19 Thread Mark
On Mon, Sep 19, 2011 at 3:27 PM, Mark bacula-l...@nerdish.us wrote:

 Hi,

 On Mon, Sep 19, 2011 at 3:22 PM, Tobias Schenk tob...@die-schenks.netwrote:

 Oh, sorry, I really got confused with this mail.


 bashreadlink /dev/vmguests/backup
 I get:
 ../dm-6


 Does it work if you add the ' --canonicalize' option?

 readlink --canonicalize /dev/vmguests/backup



Sorry for the noise, I see that's not your problem now, your issue is that
the link doesn't exist yet.  It's Monday, at least that's my current
excuse...

Mark
--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backing up lvm snapshots?

2011-09-19 Thread Konstantin Khomoutov
On Mon, Sep 19, 2011 at 10:15:02PM +0200, Tobias Schenk wrote:

 thank you for the comments regarding readlink. Unfortunately, it
 does not work :(
 if I do:
 bashreadlink /dev/vmguests/backup
 I get:
 ../dm-6
 
 I was suspicous about the relative path but this can be healed by adding -f:
 bashreadlink -f /dev/vmguests/backup
 /dev/vmguests/dm-6
 
 With this new weapon I changed the File = directive as described in
 your mails: File = | readlink /dev/vmguests/backup.
 I open bconsole, do reload, do run, select job ... and get 89 bytes
 backuped.
 ( I tested also the -f variant)
 
 I cross checked by changing File= /dev/dm-6. This saves 4.4GB of data.
 
 My guess is that the link does not yet exist when the Fileset is parsed.
 How can I find out about this. Can I raise the log level to see the
 parsed version of File= ?
Let's quote the manual:

Any name beginning with a vertical bar () is assumed to be the name of
a program. This program will be executed on the Director's machine at
the time the Job starts (not when the Director reads the configuration
file), and any output from that program will be assumed to be a list of
files or directories, one per line, to be included.

The run before job scripts are run before the job is considered to be
started, so you have to make sure the snapshot device is created in that
run before job type script.


--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users