Re: [Bacula-users] Error with DR backups

2009-10-30 Thread Cedric Tefft
DAve wrote:
 No change, same error.

 30-Oct 07:09 director-dir: Allied-ex3.2009-10-30_01.00.02 Warning: Error 
 updating job record. sql_update.c:194 Update problem: affected_rows=0
 30-Oct 07:09 director-dir: Allied-ex3.2009-10-30_01.00.02 Warning: Error 
 getting job record for stats: sql_get.c:293 No Job found for JobId 20604
 30-Oct 07:09 director-dir: Allied-ex3.2009-10-30_01.00.02 Error: Bacula 
 2.0.3 (06Mar07):

 Baffling.
   
You might be running out of disk space on /tmp or /var or wherever the 
DB engine writes its temp tables.   The important thing is that you will 
probably only see this condition WHILE bacula is actually trying to 
update the database.  If you check it now, you will probably find you 
have plenty of space -- don't let that fool you.


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Schedule question.

2009-10-30 Thread Cedric Tefft
Ronan Eckelberry wrote:
 Hi guys,

 Quick scheduling question.  I want to run Fulls 1st of every 3rd 
 month and Incrementals on 2nd-31st.  I think the incremental part is 
 easy, but does anyone know of a good way to specify the Fulls?

 Looking for something to do the following:

 FULL  Jan1, Apr1, July1, Oct1, etc
 incrementals every 2-31sth day

 Can I do comma separated?  Something like:

   Run = Level=Full on 1, 4, 7, etc at 2:05

 I'm sure someone has a schedule like this somewhere.  ;)  Any help would 
 be appreciated.


   

  Run = Level=Full jan,apr,jul,oct 1 at 2:05

--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] SD connect to FD?

2009-10-30 Thread Cedric Tefft
Matt Richards wrote:
 Hello,

 It is possible to get the SD to connect out to the FD for a single FD?

 I have a single FD outside of the network that bacula runs on and this
 FD is behind NAT for the rest of the network.

 I could start natting connections into the network that are from this
 host but it would be better if I could get the SD to connect out of the
 NAT and to the FD service.

 Both my SD and DIR are on the same network behind this NAT.

 Cheers,

 Matt.
   

No.  The FD connects to the SD.  That's just how Bacula is designed.  
There is no way to change it without altering the code (as far as I know).

--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] backing up databases - mysql mssql

2009-10-30 Thread Cedric Tefft

 My biggest issues is the space usage. Right now I would have to backup
 200GB to a file, then compress it to 2gb, delete the 200gb file. If
 you do that every day that is extremely heavy on hdd.

 Is there a better way for mssql?

 Thanks,
 Lucas
   

In your original post, you proposed the idea of piping the generated 
dump file directly through the compressor:

somecommand backup all  7z.exe outputfile.gz ??

I assume you used 'somecommand' because you don't know what/if there is a tool 
to dump a MSSQL database to STDOUT.  But isn't that question more appropriate 
for a MSSQL forum than a Bacula forum?

- Cedric

P.S. If you get that far, the pipe symbol is |, not .




--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula v3 on older systems

2009-10-30 Thread Cedric Tefft
Gabriel - IP Guys wrote:

 I’ve just completed the installation and setup of a Bacula based 
 backup system, and I'm happy with everything so far. I have two legacy 
 machines, one running FC6, and one running FC3. I wish to build RPM’s 
 for these systems, but is there anyway I can do this without having to 
 upgrade any other aspects of those systems?


Sure. Build the RPMs on boxes running FC3 and FC6.

But really, if it's just these two boxes, I'm not sure if it's worth 
your while to build RPMS. Why not just compile Bacula from source 
directly on those clients? They'll need gcc, make, and some other build 
tools, of course, all of which are included in Fedora.



--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Allow SpoolData=no on the job level to override a schedule's setting

2009-10-30 Thread Cedric Tefft
Steve Polyack wrote:
 I've recently enabled spooling on a storage director by turning it on in 
 the Director and Storage sections of the dir's config.  I've also 
 enabled it in the schedules where it should be.  However, for a 
 particular schedule there is one job which I do not want to spool 
 because it's coming locally from the storage daemon to tape.  I've set 
 SpoolData = no in the job, but this doesn't help.  It appears that 
 this is overwritten by the schedule's SpoolData=yes setting.

 Is the only solution to NOT set the spooling flag in the schedule, and 
 instead set it in every Job?  This seems counter-intuitive, but it may 
 make sense in other circumstances.

   

As far as I know, options given in the schedule always override options 
given in the job defs.  You could, as you suggest, set it in every job 
and make no mention of it in the schedule.  Another possibility is to 
create a different schedule for the job(s) where you want spooling 
turned off.

--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] simple (?) mount/unmount of USB storage device

2009-10-30 Thread Cedric Tefft
Michael FIG wrote:
 Hi,

 I'm a long-term Bacula user, having used it for file and DVD volume
 backups in the past.  I'm scratching my head over what seems like a
 really simple requirement, but I can't for the life of me figure it
 out right now.

 I have a large external USB drive on which I want to write file
 volumes, by mounting it as /var/lib/bacula/media

 I have everything working to create and rotate files in the
 /var/lib/bacula/media directory, but I want to leave the drive
 unmounted (and thereby less liable to corruption) as often as
 possible, so that bacula-sd mounts it as /var/lib/bacula/media to do
 the backup, and umounts it when the backup is finished.

 I've been messing around with the autochanger scripts, but just don't
 understand them enough to put something this simple together.

 Anybody out there have a suggestion for what to do?

 Thanks,

   
An autochanger config is probably overkill.  You can implement autofs as 
John already suggested, or you can use the Mount Command, Unmount 
Command (et. al.) directives in your Device resource:

http://www.bacula.org/3.0.x-manuals/en/install/install/Storage_Daemon_Configuratio.html#SECTION0083

Mine looks like this:

Device {
  Name = BackupDrive
  Media Type = File
  Archive Device = /media/backup/volumes
  Mount Point = /media/backup
  Mount Command = /bin/mount %m
  Unmount Command = /bin/umount %m
  Requires Mount = yes
  LabelMedia = yes
  Random Access = Yes
  AutomaticMount = yes
  RemovableMedia = yes
  AlwaysOpen = no
  Offline On Unmount = Yes
}

Note that there is a bug in 3.0.2 that prevents Bacula from calling the 
unmount command for file resources.  It's fixed in the git repository, 
but I don't know if the fix made it into 3.0.3.

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] multithreaded compression

2009-10-29 Thread Cedric Tefft
Fredrik Tegenfeldt wrote:
 Hello,

 is there any plans for using multithreading in the compression as in e.g 
 pbzip2 ?
   
Your question is probably more appropriate for the developers mailing 
list, bacula-devel.

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Question on LabelFormat

2009-10-29 Thread Cedric Tefft
Syn, Joonho wrote:
 Here is how my pool is setup

 Pool {
   Name = Linux
   Pool Type = Backup
   Recycle = no   # Bacula can automatically 
 recycle Volumes
   AutoPrune = yes # Prune expired volumes
   Volume Retention = 45 days # one year
   LabelFormat = linvol
   Maximum Volume Bytes = 5261334937
 }

 My volumes started with linvol0001 and are currently up to linvol0200. 
  Will bacula simply roll over to linvol1 after linvol?
Theoretically yes, although in practice most implementations will start 
recycling volumes long before they hit 10,000.

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] FD command not found:

2009-10-28 Thread Cedric Tefft
Pascal Clermont wrote:
 I have added a new machine to be backed up with bacula and I cannot get a 
 full backup, always have these weird errors.
 the current setup is all centos 5.3 86_64 and every other host besides this 
 one have been working flawlessly for over 6 months.

 DIR Version: Version: 3.0.1 (30 April 2009)

 Client-FD Version: Version: 3.0.1 (30 April 2009)


 the error output:

 JobId 2744: Fatal error: fd_cmds.c:181 FD command not found: 
 wMTAxMDEwMTAxMDEwMTAxMDEwMTAxMDEwMTAxMDEwMTAxZjUwMDczNWEw
 MTRmMzYwMDAwMjQ3ZjAxMDEwMTAxMDEwMTAxMDEwMTAxMDENCjE4MmEzNzAwMzUwMTAxMDEw
 MTAxMDEwMTAxMDEwMTAxZjcwMDMzMDEwMTAxMDEwMTAxNWE5YTY4NTQ1NzliODYxNjAxMDEw
 MTNiOGEwMWE3ODcwMTAxMDE0ZWI5MmQwMTc4ZjhlYzAxMDEwMTAxMDEwMTAxMDEwMTAxNGZi
 NGNhDQo1MTAxMDEwMTAxMDExYmM3N2UyMzRhYjAwMzFlMDFlNzAwOTFiODAwYzc4NTAwNTYw 
 snip
 DkwYzE4MzcyYjAxMDEwMTAxMDEwMTAxMDEwMTAxMDEwZWI5Y2Ux
 NjAxMGU1YjY1MDEzMg0KMDFiZDRmNGY3NWUwZDQ4MWIwZWFkMTM3MmIwMTAxMDFhMTAwYjNh
 MDAxMDEwMTAxY2Y3MWUwZTBlMDgxODAwMTAxMDEwMTAxMDEwMTAxOTI3Y2NhYzQ0YTQ0ZTAw
 YjAxMDEwMTAxMDEwMTAxMDEwMTAxMDEwMTAxMDE4N227
 JobId 2744: Fatal error: fd_cmds.c:172 Command error with FD, hanging up.
   

Your disk might be filling up during the backup.  See 
http://bugs.bacula.org/view.php?id=1356

--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Tape Drive blocked, waiting for tape in, another drive

2009-10-28 Thread Cedric Tefft
Evan Fraser wrote:
 Attached are the excerpts of the log from last night, and the list media 
 command I ran this morning whilst the job is hung.

 As you can see, I have setup a weekly pool rotation, but this problem was 
 also occurring when I only had default and scratch pools.

 I forgot to mention that I have prefer mounted volumes = no set.
   

Wow, what a mess.  You certainly have an interesting definition of 
running very well.Your job log looks like it includes about 20 
different jobs most of which include at least one error, some of which 
don't appear to finish at all.  Which one, exactly, are you asking about?

--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] lzma compression and bacula?

2009-10-26 Thread Cedric Tefft
Soeren Sonnenburg wrote:
 Dear List,

 is it possible to use compression algorithms other than gzip, like lzma?

 Soeren
   
No, but you can affect the LEVEL of GZIP compression by specifying 
compression=GZIPn where n is 1-9 (1 being the fastest but worst 
compression ratio, 9 being the slowest but best compression ratio).  
According to the manual, the default is 6, so there is some leeway in 
either direction.

Also, from the file 'kernstodo' in the source distribution:

- see lzma401.zip in others directory for new compression algorithm/library.

To me, this implies lzma compression is somewhere on the horizon, though 
you'd probably have to check with Kern himself to know for sure.

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Tape Drive blocked, waiting for tape in another drive

2009-10-26 Thread Cedric Tefft
Evan Fraser wrote:
 Hello again,

 Sorry to spam but I'm stuck with this problem.  Does anyone have any ideas?

 Thanks, Evan.
 -Original Message-
 From: Evan Fraser [mailto:evan.fra...@rms.com]
 Sent: 20 October 2009 11:25
 To: bacula-users@lists.sourceforge.net
 Subject: [Bacula-users] Tape Drive blocked, waiting for tape in another drive

 Hello everyone,

 I have a 6 drive LTO4 Dell ML6000 changer, running on a Dell Poweredge 2900 
 with Suse Enterprise 10 SP2, and over the last weeks I've managed to get 
 Bacula 3.0.2 running very well with it.

 Except for one problem where every night now a few jobs stall requiring 
 intervention requesting tapes.  I am using brand new tapes that are being 
 autolabelled and moved from a scratch pool.  The autolabelling etc is all 
 working well and I'm sure that's not causing problems.

 I've been trawling through the email archives, and found a few similar 
 situations where people were using older versions of bacula that had a bug.  
 But I thought that it was fixed in version 3.0.2...?

 Here's an excerpt from the storage status whilst the jobs are requiring 
 intervention:

 Device Drive-0 (/dev/tape/by-id/scsi-3500308c09f221090-nst) is mounted with:
 Volume:  LX0005
 Pool:Week3
 Media type:  LTO4
 Slot 76 is loaded in drive 0.
 Total Bytes=3,571,088,384 Blocks=3,407 Bytes/block=1,048,162
 Positioned at File=5 Block=0

   
Since nobody's offered any suggestions, it seems that whatever is wrong, 
it's not apparent from the information you've posted so far.  Therefore, 
it might make sense to provide more information.  I suggest you post:

1) Your entire director config
2) The part of your log file from the start of the job through the part 
where it starts requesting tapes.
3) The output of 'list volumes', preferably taken while a job is on hold 
requesting tapes.

- Cedric

These things usually turn out to be in some place you haven't

--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] version 3

2009-10-23 Thread Cedric Tefft
glynd wrote:
 Hi Cedric,

 IS this what you are looking for?

 r...@mistral:~# ls -la /var/lib/bacula/bin/bacula.sql
 -rw-rw-r-- 1 bacula root 0 2009-10-22 08:20 /var/lib/bacula/bin/bacula.sql
 r...@mistral:~#
   

The size of the dump file is zero bytes.  That's definitely not good!  I 
can think of three reasons off the top of my head why this might happen:

1) You ran the ls command at JUST the right second -- after the dump job 
started but before it had generated any data (possible, but unlikely)
2) The dump failed completely
3) The dump job is still running (or, more likely hung) and the dump 
file is essentially locked by the running job

Try running the dump script manually.  Look for errors.  Check the size 
of the dump file when it is finished.

BTW, it's probably not a bad idea to make sure you're not running low on 
disk space on /var (or anywhere else).

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] version 3

2009-10-23 Thread Cedric Tefft
glynd wrote:
 Sorry forget this
 # Backup the catalog database (after the nightly save)
 Job {
   Name = SugarCatalog
   JobDefs = SugarJob
   Level = Full
   FileSet=Catalog
   Schedule = WeeklyCycleAfterBackup
   # This creates an ASCII copy of the catalog
   # WARNING!
   # Ubuntu uses make_catalog_backup_awk script for
   # security reasons
   # Replace CatalogName with the real Catalog name
   RunBeforeJob = /var/lib/bacula/bin/make_catalog_backup bacula bacula
   # This deletes the copy of the catalog
   RunAfterJob  = /var/lib/bacula/bin/delete_catalog_backup
   Write Bootstrap = /var/lib/bacula/bin/SugarBackupCatalog.bsr
   Priority = 11   # run after main backup
 }
   
[snip]

I see you're using JobDefs.  The only way for us to get a clear picture 
of your Job configs is to include the JobDefs they're based on.

Also, I asked if you could post your FileSets, but it appears you did 
not do that,  however that may turn out to be moot because...

as Martin pointed out it's rather unusual to have five separate 
catalogs, and this may be where you're getting into trouble.  You need 
to make sure your dump scripts correlate exactly with your clients -- in 
other words make absolutely certain you aren't dumping the database to 
the backup server's hard drive, and then trying to pull the dump file 
from one of your remote client's hard drives (where it obviously doesn't 
exist).

- Cedric



--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula Client for Mac OS X Snow Leopard

2009-10-20 Thread Cedric Tefft

Daniel Cukier wrote:

*I'd like to backup my Mac with bacula (I'm using version 2.4.4). *
*When I try to compile it, using:*
*./configure --enable-client-only*
*make*
*
*
* I get the following error message. How can I solve this issue?*
*
*
*Thanks in advance.*
*
*
*Daniel*

==Entering directory /Users/danicuki/Downloads/bacula-2.4.4/src
make[1]: Nothing to be done for `all'.


I know nothing about Macs, however, I'll go ahead and point out that, 
while you say you ran both configure and make, it appears you've only 
included the output for make.  Did you omit the output of configure for 
a reason?  It may reveal the real reason make is failing.


Also, these may be of some use

   http://www.pixelchaos.net/2009/07/14/bacula-3-0-1-for-mac-os-x/
   http://www.pixelchaos.net/2008/11/25/bacula-243-for-mac-os-x/

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problems with restore

2009-10-20 Thread Cedric Tefft
Matti Jormakka wrote:
 Remote backup client:

 * OS: CentOS 4.8
 * Bacula-fd: Version 1.38.11

 Backup server:

 * OS: Ubuntu 8.04.3 LTS
 * Bacula-dir, -sd and -fd: Version 2.4.2
 * Catalog: SQLite 2.8.17


What happens if you restore to the remote instead of the local backup 
server?  Do you get the same error?
What happens if you restore the local server's files instead of the 
remote's files?  Do you get the same error?

This may or may not be related, but were you aware that major versions 
of the various bacula daemons (major version is the 'x' in version 
x.y.z) are not fully compatible?  I have to wonder if the real problem 
is not actually in the restore but in the backup itself -- i.e. due to 
using a 1.38.11 FD with a 2.4.2 SD  DIR.  You might want to upgrade the 
FD on the remote to 2.4.2.  Obviously, if that really is the problem it 
wouldn't fix your restore issue right away -- you'd have to do a fresh 
backup and try to restore from that.

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Best backup strategy to use the minimum size

2009-10-17 Thread Cedric Tefft
Jesper Krogh wrote:
 Cedric wrote:
   
 Do a Differential once every 90 days and Incrementals the rest of the time.
 In theory, you only need to run one Full backup. Ever. In practice, you'll
 probably want to create a new Full backup every year or so to clear out the
 obsolete data and make your differentials smaller (and faster).
 

 Also keep restores in mind.. using above configuration and running a
 full yearly and a differential every 90 months could require you to find
 1 (full) + 1(differential) + 89(incremental) = 91 tapes to do a
 restore. Either you have a huge changer, or you are heading into an
 administrative nightmare.

 I suggest running differentials at least weekly, just to lower the
 amount of tapes needed for restores.
   
I think you missed an important detail given in the OP:

Please consider that I'm using File disk Backups.

He's backing up to disk. There are no tapes to change because there are 
no tapes.

- Cedric



--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Encryption by SD or Pool

2009-10-15 Thread Cedric Tefft
Matt Richards wrote:
 I currently have bacula setup to backup to disk volumes that reside on
 encrypted file systems.

 I have just added a tape drive on another SD and would like the data
 on the tapes to be encrypted.

 Is this possible without using encryption from the FD?

   

My solution to essentially the same problem was to run two copies of the 
FD: one with encryption and one without.  You pull from the FD  without 
encryption when writing to disk, and the one with encryption when 
writing to tape.

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] When is my Volume will be recycled?

2009-10-15 Thread Cedric Tefft




Jose Perez wrote:

  Hi people:

I'm a little confused about how bacula deals with Pools and Volumes.
I'm using Automatic labeling with a Pool that uses a unique Volume (as
file disk) that is continuosly increasing its size. I have a unique
volume named Vol-0001 with a size of 900 GB and status Append.

If I pretend to preserve Files for 30 days, Jobs for 60 days.. so When
my big volume will be marked as Full or Used to be able to get
recycled? These are my Pool and Clients configurations:

  


Bacula's retention times for volumes are based on the date the volume
was last written. So, every time Bacula writes a backup job to a
volume, your 15-day retention clock starts over from zero. As long as
your volume's status is Append, bacula will keep writing to it.

With a physical, magnetic tape volume, you will eventually reach the
end of the tape, Bacula will mark the volume FULL, and move on to the
next volume. With logical (disk file) volumes, there is no natural
limit on the size of the volume other than the size of the underlying
disk partition. Since you probably don't want Bacula to fill up your
entire partition, you need to place an artificial limit on the size of
your volumes. 

There are several directives you can include in your Pool definition
which will accomplish this:

 Maximum Volume Jobs
 Maximum Volume Files
 Maximum Volume Bytes
 Volume Use Duration

See the manual for full details:
http://www.bacula.org/3.0.x-manuals/en/install/install/Configuring_Director.html#SECTION00615

- Cedric




--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Compatibility with older bacula-fd

2009-10-15 Thread Cedric Tefft
Marek Simon wrote:
 Hi,
 I have a box with pretty old operating system, which cannot be upgraded, 
 but I need to have there a bacula client. The newest version I have run 
 there was 1.36.6. I have Director 2.4.4. The full backup was OK, but 
 when I start an Incremental Job I got this Error:
 15-říj 14:40 the-host-fd: 
 the.host.cz_-_default-redhat-set.2009-10-15_14.33.28.37 Fatal error: 
 job.c:1037 Unknown backup level: incremental

 WTF?
 The documentation says that version 1.36 suported incremental backups. 
 Do I something wrong?

   
Daemons which are different major versions (the x in version x.y.z) 
are generally considered to be incompatible with each other.   SOMETIMES 
you get lucky and can squeeze some limited functionality out of such a 
setup, but eventually you will try to do something which fails for 
reasons which otherwise make no sense.  This seems to be exactly what 
you're experiencing.

So short answer: ignore the error message.  Your 2.4.4 daemon is not 
fully compatible with 1.36.6 FD. 

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problem with bacula differential strategy

2009-10-13 Thread Cedric Tefft
carfieldboy wrote:
 hi all
 I'm use bacula3.01 server and client to backup my files. It works good.
 But i found a problem here.

 I think  the 184 server's differential backup strategy is correct
 ===
 184| 2009-09-24 01:48:47 | B| F | 1,752,636 | 
 3,527,191,160 | T 
 184| 2009-09-25 03:33:05 | B| D | 60,936 |
 153,237,899 | T 
 184| 2009-09-26 03:33:04 | B| D | 61,593 |   
 154,167,499 | T

 But the 183 server's differential backup strategy is  abnormal   |
 ===
 183| 2009-09-27 01:30:09 | B| F | 1,919,599 |
 48,705,123,134 | T
 183| 2009-09-28 01:30:10 | B| D | 1,284,990 |
 31,494,192,087 | T  

 and i checked some files on the server and compare with the file i was
 restored from full backup,they not changed  after full backup and time stamp
 is correct. 
 why 183 server have many files were backuped in differential backup
 strategy?what cause it?


   
When you say the time stamp is correct you're probably only looking at 
the modification time (mtime) of the file.  By default, Bacula uses both 
the mtime AND the ctime (Change Time) of a file to determine its 
effective timestamp.  Try using the stat command to check the ctime on a 
couple of your files.

- Cedric


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Encryption and hardware compression

2009-10-12 Thread Cedric Tefft
Cedric Tefft wrote:
 Markus Falb wrote:
 Eric Böse-Wolf wrote:

  
 Vladimir Doisan vdoi...@giantmarkets.com writes:


 If you turn TLS and file encryption - the data will be double 
 encrypted
   
 If I only turn on file encryption, then the data goes encrypted over 
 the
 wire or the air, but what is not encrypted?

 For example what's with the connection cookie the director presents the
 [FS]D (don't know exactly)?
 

 Same Question here! In other words: If i do Data Encryption, is it 
 safe to avoid the double encryption by disabling TLS for File Daemon 
 to Storage Daemon Network Communication ?

   
 As I understand it, data encryption (as the manual uses the term) 
 means the FD encrypts the CONTENTS of every file before it's sent to 
 the SD.  The SD then stores each file to the backup media as-is (in 
 its encrypted form).  No decryption (or encryption for that matter) is 
 done by the SD.  File metadata (filename, path, size, permissions, 
 etc.) are not encrypted, nor are any other aspects of the 
 communication between the FD and SD (commands, negotiation, etc.).

 TLS encryption refers to encryption of the communication channel 
 between the various daemons -- in this case, we're concerned with the 
 communication channel between the SD and FD.  With TLS encryption  
 the FD encrypts everything it sends to the SD (file contents, 
 metadata, commands, etc.) , but unlike data encryption the SD 
 decrypts everything at the other end.  If you are not also using data 
 encryption your files get written to the backup media UNencrypted.

 So the answer to your question depends on which pieces of your backup 
 scheme you consider to be insecure.  If you're worried about someone 
 getting hold of your backup media, you need data encryption.  If 
 you're worried about someone eavesdropping on communications between 
 the FD and SD, you need TLS encryption.  And obviously, if you're 
 worried about both, you need both.

Actually, now that I re-read it, I realize that last bit was a little 
misleading, so I'll try to clarify:

If you're using data encryption ONLY (i.e. not in conjunction with TLS 
encryption), anyone who can eavesdrop on the communication between your 
SD and FD will NOT have access to the unencrypted contents of your 
files.  However, he WILL have access to the names of those files as well 
as size, permissions, timestamp, etc.  If that doesn't concern you, 
data encryption alone might be what you want, although I'd recommend 
you think very carefully before going that route.  A sophisticated 
hacker could potentially use the unencrypted metadata as the basis of an 
attack.

- Cedric

--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How can I identifying slack in backup volumes?

2009-10-12 Thread Cedric Tefft
Ben Beuchler wrote:
 I'm doing disk-to-disk backups.  Since backup sets fluctuate in size
 quite a bit, it's hard to tell how many volumes may be available to be
 recycled.  This makes it difficult to tell when I need to add
 additional disks.  As it stands, I may have hit a peak in backup size
 several months ago and may now have many volumes that are not
 necessary to meet my retention requirements.


   
I'm not positive but I THINK what you're asking for is a way to 
determine which volumes are older than their retention times and are 
therefore eligible for pruning and recycling.  This should just be a 
matter of querying the database.  For instance, this query shows you 
which volumes in the 'Default' pool are old enough to be pruned/recycled:

mysql select Pool.Name as POOL, Media.VolumeName, Media.VolBytes, 
FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten)+Media.VolRetention) as 
EXPIRED from Pool LEFT JOIN Media ON Media.PoolId=Pool.PoolId where 
Name='Default' and 
FROM_UNIXTIME(UNIX_TIMESTAMP(Media.LastWritten)+Media.VolRetention) = 
NOW() order by EXPIRED;
+-++-+-+
| POOL| VolumeName | VolBytes| EXPIRED |
+-++-+-+
| Default | TAPE07 | 20946014208 | 2009-08-28 13:31:04 |
| Default | TAPE14 | 20593843200 | 2009-09-03 10:04:21 |
| Default | TAPE13 | 20034846720 | 2009-09-03 16:18:50 |
| Default | TAPE09 | 17308247040 | 2009-09-03 19:03:16 |
| Default | TAPE02 | 17353792512 | 2009-09-03 21:53:28 |
| Default | TAPE08 | 18065359872 | 2009-09-07 13:02:19 |
| Default | TAPE15 | 27043043328 | 2009-10-01 09:08:56 |
| Default | TAPE11 | 18494300160 | 2009-10-01 13:00:32 |
+-++-+-+
8 rows in set (0.00 sec)

With a little SQL knowledge you should be able to rework this into 
whatever form you need.


- Cedric





--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Not to block Storage when inserting attributes

2009-10-07 Thread Cedric Tefft
Marek Simon wrote:
 Hi,
 I have a complex bacula config (2.4.4) with about 100 clients, 300 Jobs 
 and 48 Storages on two Storage Daemons (32 on one and 16 on the other). 
 The multiplicity of Storages is for paralelism. The clients are spread 
 among the storages with config generator, which selects the Storage for 
 them. But still many clients share the Storages and must wait for each 
 other. I noticed each job goes through two phases: running phase 
 (aquiring data from client) and Dir inserting attribures phase (DIA). In 
 DIA phase job still blocks the Storage but actualy it does not need it 
 more. Is it possible to avoid that? Some asynchronous catalog inserting 
 or some feature in 3.0?

 Marek
The second phase (what you describe as DIA) is a result of using  Spool 
Attributes = yes in your job defs.  Changing this to no MIGHT solve 
your problem.  OTOH, it might actually make things worse.  I suggest you 
look up the Spool Attributes directive in the manual.

- Cedric



--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula performance so slow ???

2009-10-05 Thread Cedric Tefft
Klaus Troeger wrote:

 Does it mean, that the spooling to disk was at avarage of 6 MB/sec,
 and the writing to tape
 reached the 35 MB/sec
It does appear that way.  Are you using encryption and/or (software) 
compression?  Both slow down the spooling process, though by how much I 
don't know.  If you are using either/both, you might try turning them 
off just to see if it makes any difference.

- Cedric



--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Unchanged files still saved in incremental backup

2009-10-05 Thread Cedric Tefft


Guillaume_h wrote:
 Kevin Keane a écrit :
   
 Bacula uses the file date to determine which files have changed. So a 
 file with a future file date would be backed up by each incremental backup.

 Since you say that your file was NOT backed up on 9/15 and 9/16, my 
 guess is that some application may be opening the file for writing 
 without actually making a change. Whatever application is responsible 
 for that probably wasn't running on 9/15 and 9/16.

   
 
 No. The history posted by Le Dahut does not end on 9/17. Beginning 
 from 17/09, all files are backed up every day with incremental backup 
 whatever the mod date is (I have some files that has not been modified 
 since 2k8 and bacula backup these files every day).

   
Run stat on one of those older files.  Look at the ctime.  Is it very 
recent -- perhaps a day or less?  By default, bacula uses both the mtime 
and ctime of a file to determine if it has been changed.  If EITHER one 
of those is newer than the last backup, bacula will include the file in 
an incremental.

For example:

lithium:/data/temp  dir testfile
-rwxr-xr-x 1 cedric cedric 2.1K 2004-06-24 08:01 testfile


lithium:/data/temp  stat testfile
  File: `testfile'
  Size: 2137Blocks: 8  IO Block: 4096   regular file
Device: fe03h/65027dInode: 2899Links: 1
Access: (0755/-rwxr-xr-x)  Uid: (  500/  cedric)   Gid: (  500/  cedric)
Access: 2009-09-30 22:02:46.005409891 -0700
Modify: 2004-06-24 08:01:58.0 -0700
Change: 2009-10-05 19:10:58.90135 -0700



- Cedric

--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Auto recycle volume

2009-09-25 Thread Cedric Tefft
Proskurin Kirill wrote:
 Hello all.

 Im confused about recycle options in Bacula 2.4.4.
 I have such options on some pools:

 Recycle = yes
 AutoPrune = yes
 Volume Retention = 30 days
 Maximum Volumes = 3
 Maximum Volume Bytes = 10G

 As I understand - volume what older than 30 day will be recycled if it 
 FULL. BUT - how can I set to recycle volume if all volumes are FULL?

 For example I fill all 3 volumes with 10G each by 20 days.
 How to make auto recycle of latest volume?

   
*Use Purge Oldest Volume = yes
*

--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Strange problem with Bacula

2009-09-24 Thread Cedric Tefft
Reynier Pérez Mira wrote:
 Hi:

 Cedric Tefft wrote:
 Reynier Pérez Mira wrote:
 Probably /tmp.  Run show variables where Variable_name = 'tmpdir'; 
 in mysql to find out for sure.

 I use PostgreSQL instead of MySQL. What this query should return? How 
 I can run the same query in Postgres? I suspect it may be a thing of 
 the postgres tablespaces because I use the default tablespace.
I don't know what the equivalent would be in Postgres, or if there is an 
equivalent.  What you're looking for is the directory Postgres uses when 
it needs to write temporary tables to disk.  I suggest checking the 
Postgres manual and/or Google.


 I tought this lines are a little suspicious, don't you think?

 23-Sep 03:17 serverbacula-dir JobId 2215: Fatal error: 
 sql_create.c:825 Fill File table Query failed: INSERT INTO File 
 (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT 
 batch.FileIndex, batch.JobId, Path.PathId, 
 Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON 
 (batch.Path = Path.Path) JOIN Filename ON (batch.Name = 
 Filename.Name): ERR=ERROR:  could not write to hash-join temporary 
 file: No space left on device
Well, it's an ERROR message, so it's definitely not good, but 
suspicious?  No.

 Be aware that if the problem really is a lack of temp space, you 
 would probably only see /tmp at or near capacity WHILE bacula is 
 actively trying to update the database (i.e. not before or after).

 So /tmp will be full capacity WHILE bacula try to save data? Is that 
 what you said?
Yes.


--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Problem with plannification

2009-09-22 Thread Cedric Tefft
Federico Torres wrote:
 Good morning: 
 I'm having a problem for quite some time with Bacula. I'm backing up about
 30 servers ( 1Tb of info), and despite it all works, this problem is
 breaking my head a couple of times a month. 

 I'm planning a scheme of jobs as follows: 1 Full on the first Sunday of each
 month, 1 Differential on the others Sundays, and 1 Incremental every other
 days. 

 It has happened on more than one occasion for various reasons, that some of
 the backups took longer than expected (especially on a weekend when
 differentials are made). This produces a chain reaction as a task that took
 more than a day keeps the remaining tasks of the day and late start, and the
 next day tasks still later and everything is delayed until manually cancel
 all tasks that in my opinion are useless. 

 One consequence of this is that the next Monday at time when all servers are
 in critical use, bacula continues making delayed copies, significantly
 reducing the performance of servers, therefore the quality of service, and
 producing simultaneously the backup tasks take longer to complete (further
 fueling the chain reaction). 

 My question is whether there is any configuration parameter, allowing Bacula
 automatically cancel a daily job, if it is not executed within 24 hours
 following initial planned time. 


   
http://bacula.org/3.0.x-manuals/en/concepts/concepts/New_Features.html#SECTION00310

--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Strange problem with Bacula

2009-09-22 Thread Cedric Tefft
Reynier Pérez Mira wrote:
 Bruno Friedmann wrote:
   
 /tmp obviously full
 on dir/sd

 

 See this:

 #df -h
 FilesystemSize  Used Avail Use% Mounted on
 /dev/mapper/vg00-lv_root
2.4G  888M  1.4G  39% /
 tmpfs1007M 0 1007M   0% /lib/init/rw
 varrun   1007M   96K 1007M   1% /var/run
 varlock  1007M 0 1007M   0% /var/lock
 udev 1007M  160K 1007M   1% /dev
 tmpfs1007M 0 1007M   0% /dev/shm
 lrm  1007M  2.4M 1005M   1% 
 /lib/modules/2.6.28-11-server/volatile
 /dev/sda1  89M   27M   58M  32% /boot
 /dev/mapper/vg00-lv_tmp
477M   11M  442M   3% /tmp
 /dev/mapper/vg00-lv_var
2.4G  467M  1.9G  21% /var
 /dev/sdb11008G  801G  157G  84% /data
 tmpfs1007M  2.2M 1005M   1% 
 /lib/modules/2.6.28-15-server/volatile

 So wich /tmp is full?

   
Probably /tmp.  Run show variables where Variable_name = 'tmpdir'; in 
mysql to find out for sure.

Be aware that if the problem really is a lack of temp space, you would 
probably only see /tmp at or near capacity WHILE bacula is actively 
trying to update the database (i.e. not before or after).

- Cedric


--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Calculating number of Tapes

2009-09-19 Thread Cedric Tefft
Daniel Durgin wrote:
 I have searched google but haven't found a tape rotation calculator.

 Does anyone know of a way to use bconsole or the mysql database to 
 calculate number of tapes needed.  I was hoping for something dynamic 
 so I could forecast different Tape Schedules.

No, there is no such facility built into bacula. 

--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Request from a beginner outline of possible setup

2009-09-19 Thread Cedric Tefft
Harry Putnam wrote:
 I've been using Retrospect on my windows machines to write backups to
 my OpenSolaris zfs server.

 It isn't really centralized since I was unwilling to plop down more
 than the initial $150 or so It cost (its been some yrs and upgrades so
 not really sure of what I paid originally), to buy licensenses for
 more than 2 clients.

 My operation is really just a home setup with 3 windows XP pro 1
 laptop running Vista, 2 linux machines (1 is my main desktop) and 1
 running Opensolaris as a zfs server.

 So 7 machines in all.

 I need a centrallized backup seup that can be run from one machine.
 The Solaris server makes the most sense... and I know bacula has
 been/and can be compiled on it.

 I've tinkered with bacula before but never really got is going as my
 main backup method.  Also its been several yrs ago now.

 What I'd like to see is a brief outline describing how I might go
 about setting up bacula to backup those 6 machines.  (The zfs server
 has its own mirrored pool setup)

 My needs put into a diagram might look like:

mch1  mch2  mch3  mch4  mch5  mch6OpenSol_server
 | | | | | |  |
 | | | | | |  |
 | | | | | |  |
   --- gigabit switch/router -
   |
   |
 cable router
   |
   |
INTERNET


 The only way I can do them all (all windows) with Retrospect
 is to install Retro on each machine and setup that machines' backup.
  
 That way I have 4 independent backups running and no way to control
 them centrally.  Also leaves 2 linux machines that need their own
 backup setup.

 Can someone show an outline of what I'd need to do to get bacula
 working to cover the above diagram and backup the machines to solaris
 server.

   
On the Solaris box, do a full install (director, storage, and file 
daemons, plus the database -- usually MySQL).  On all the other 
machines, install just the file daemon.  Configure the file sets, 
schedules, clients, etc. on the Solaris box.  Sit back and let bacula do 
its thing.

If you didn't already know that, you need to read the Concepts and 
Overview section of the manual.

http://www.bacula.org/3.0.x-manuals/en/concepts/concepts/What_is_Bacula.html#SECTION0022

If you DID already know that, you need to be more specific about what it 
is you DON'T understand.

- Cedric







--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Repeated job failures

2009-09-17 Thread Cedric Tefft
Alan Brown wrote:
 On Wed, 16 Sep 2009, Richard Mortimer wrote:

   
 The immediate failure is because the number of affected rows is zero. I'm not
 sure what the underlying cause could be (apart from the fact that JobId 
 104670
 is not in the Job table - pruning or a bug?)
 

 More likely bug than pruning. It's being run by the scheduler and then
 failing almost immediately.

   
 But I vaguely remember a discussion about zero lines changed on bacula-devel.
 Looking at the code the test that reports the failure has changed between
 2.4.4 and now (it tests affected_rows  1 in the latest code).
 

 This happens about 1 in 10 runs, so it's not consistent.

 It also happens more often than not on various incremental/diff backups of
 the bacula server and there is _always_ at least one changed file each run
 (logfiles)
   
I'm wondering if the problem is with MySQL.  Is it possible the database 
is corrupt and/or that MySQL is running out of disk space?

W/rt to corruption, I'd suggest maybe running mysqlcheck and while 
you're at it you might as well run dbcheck (bacula's high-level database 
consistency checker).

Also, I'd be interested to know if the missing job records really and 
truly are not there, or if the error report itself is bogus.  You should 
be able to test this by doing a SQL query on the database after a failed 
job, something like select * from Job where JobID = 
jobid_of_failed_job;.  If the error message is accurate, this query 
should return no rows.

- Cedric


--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Full/Differential with one job

2009-09-11 Thread Cedric Tefft
Joseph L. Casale wrote:
 The manual states
 variable expansion is for Volume Labels only
Really?  Where does it say that, exactly?  I looked at what I believe in 
the relevant section of the manual, and I came away with a completely 
different understanding.

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Full/Differential with one job

2009-09-11 Thread Cedric Tefft
Joseph L. Casale wrote:
 Really?  Where does it say that, exactly?  I looked at what I believe in
 the relevant section of the manual, and I came away with a completely
 different understanding.
 

 In the middle of general Functionality of
 http://www.bacula.org/en/dev-manual/Variable_Expansion.html

 But, now that I read it only says When using not only for. Problem is
 I can't make it work for anything else:)


   
OK, I see the problem.  Variable Expansion is a concept used mostly 
(exclusively?) by the LabelFormat directive inside Pool resource 
definitions:

http://bacula.org/3.0.x-manuals/en/install/install/Configuring_Director.html#SECTION00615

Unfortunately, this is more or less irrelevant to what you're doing.  
You need to be looking at the section of the manual that details the Job 
resource, specifically the RunScript directive:

http://bacula.org/3.0.x-manuals/en/install/install/Configuring_Director.html#SECTION0063

- Cedric



--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Strange FD errors on Windows Full Backup Jobs

2009-09-11 Thread Cedric Tefft
Tyler Seaton wrote:
 Hey Everyone,

 I am getting some strange behavior on backups which take longer than 2
 hours and are on Windows machines. I have set the heartbeat interval on
 all FD's, the SD and the director but I still am getting strange output
 from the FD:
   
[snip]
 10-Sep 19:13 watukBackup01-sd JobId 101: Fatal error: fd_cmds.c:177 FD
 command not found:
 Merchants Credit Corp.GRANT, MELINDA
 �0�0�27.05�0�0�0�0�0�0�0�0�0�0�0�0�0�0�0�0�0�0���0T
   
Sounds like you might be experiencing bug 1356: Failure to recycle 
volumes and SD reads FD data as a command.

http://bugs.bacula.org/view.php?id=1356

- Cedric




--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Strange FD errors on Windows Full Backup Jobs

2009-09-11 Thread Cedric Tefft
Tyler Seaton wrote:
 It's entirely possible I don't fully understand the bug which you are
 referring to, but it sounds like this would only be a problem if the
 pool I was writing to did not have enough enough disk space available. I
 have around 1.8TB still available, so it should be able to create new
 volumes on the fly. 

 Am I understanding this correctly? (what a question huh?)

 Tyler 
   
The assumption in the bug report is that the full disk is the trigger 
for the SD getting out of sync with the FD, BUT IT MAY NOT BE.  Or, it 
may be one of several triggers -- yours being something else.  The bug 
hasn't been diagnosed or fixed, and until it is, everybody's basically 
just guessing.

Which brings us to you.

You are experiencing the sync error without a full disk, so, MAYBE the 
full disk is not related to the sync problem as has been assumed.  If I 
were in your position, I would add a me too to the bug report, 
including the relevant diagnostics and (obviously) pointing out that 
unlike the reporter, your disk is not full.  Perhaps your input will 
help them diagnose  fix the problem.

- Cedric


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula not running correct job type

2009-09-11 Thread Cedric Tefft
Joseph L. Casale wrote:
 When I run it the first time, it does a FULL, when I add data, and
 run it again, it does am Incremental?

 What am I missing? I was expecting a Differential?

   
When you ran the job the first and second time, do you mean you 
initiated the job manually (i.e. with the run command in the console) 
or do you mean you sat back, did nothing, and let bacula start the job 
all by itself based on the schedule?


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula not running correct job type

2009-09-11 Thread Cedric Tefft
Joseph L. Casale wrote:
 When you ran the job the first and second time, do you mean you
 initiated the job manually (i.e. with the run command in the console)
 or do you mean you sat back, did nothing, and let bacula start the job
 all by itself based on the schedule?
 

 I used the run command (Well weBacula did actually). I didn't even think
 of that, heh, Friday night:)

 How does bacula choose Incremental or any job type in this case?

   
If you explicitly specify Level = level in your Job (or JobDefs) 
resource, then it will default to that level.  If you DON'T specify the 
level in Job or JobDefs, then it will use the implicit default which is 
Incremental.

In the console, you have the option to override the level every time you 
invoke the run command -- I don't know about webacula.

- Cedric


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] allways full even if incremental

2009-09-10 Thread Cedric Tefft
Troy Daniels wrote:
 Hi,

   
 Actually bacula uses ctime by default, not mtime.


 Actually under the 'Level = Incremental' section of the page you 
 linked it states:

 The File daemon (Client) decides which files to backup for an 
 Incremental backup by comparing start time of the prior Job (Full, 
 Differential, or Incremental) against the time each file was last 
 modified (st_mtime) and the time its attributes were last 
 changed(st_ctime). If the file was modified or its attributes 
 changed on or after this start time, it will then be backed up.

 So we were both right almost :)
Fair enough.

 One possibility which occurs to me is that there may be some kind of 
 time synchronization problem between the director and the client.  I 
 suspect the problem as described could be a result of the client's 
 clock being too far ahead of the director's.  I would suggest 
 verifying the client and director's clocks more or less agree.  This 
 may be a non-obvious issue if the client and director are in 
 different time zones -- or, more to the point, if one of them is in 
 the wrong timezone.


 I've seen Bacula compensate for different clock times on servers a few 
 seconds/minutes apart - it logs a line at the top of the job saying 
 it's doing so.

Ah, interesting.  I use ntp on all my systems, so I've never seen that 
message.  Anyway, it occurred to me that simply picking a file on the 
client that is getting backed up repeatedly and doing a stat on it might 
be informative if the problem is time or timestamp related:  Stat shows 
you the mtime, ctime, and atime (among other things):

  stat myfile
  File: `myfile'
  Size: 11603298Blocks: 22664  IO Block: 4096   regular file
Device: fe03h/65027dInode: 810095  Links: 1
Access: (0644/-rw-r--r--)  Uid: (  500/  cedric)   Gid: (  500/  cedric)
Access: 2009-08-19 23:04:07.0 -0700
Modify: 2002-02-09 04:55:02.0 -0700
Change: 2009-08-19 23:04:07.721728624 -0700

In particular, doing a stat on the same file immediately before, and 
again immediately after a backup might reveal something.

- Cedric





--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How does work a FULL Backup not correctly ending ?

2009-09-10 Thread Cedric Tefft

pierre1106 wrote:

Hello,

i've got  a little problem with my bacula server and Full backup :

i have a remote client on a 10 Mbits line (optical fiber) with a lot to backup 
(more than 30 Gb) and a time frame to do this backup relatively short 
comparatively (10 hours)

My main problem is that I can't terminated correctly a full backup.
I know that i've got to change either the line or the date size to backup but 
my question is how a full backup is working in this case ?

Does the next time that the full backup will try to run (and fail), will it be 
doing it from the starting point or will it restart from the last time it 
failed ?

In other words, will it do a complete full backup at every try or sort of an 
incremental of the failed full until the full backup is done correctly ?

Thanks.

  
No, it will try to do a complete full backup every time.  This is 
clearly explained in the FAQ 
http://www.bacula.org/en/rel-manual/Bacula_Freque_Asked_Questi.html#SECTION003721 
:


Before doing an Incremental or a Differential backup, Bacula checks to 
see if there was a prior Full backup of the same Job *that terminated 
successfully*. If so, it uses the date that full backup started as the 
time for comparing if files have changed. If Bacula does not find a 
*successful* full backup, it proceeds to do one.


One possible workaround would be to break your single backup job into 
several smaller jobs, each of which can be completed within your 10-hour 
window.


- Cedric



--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] allways full even if incremental

2009-09-09 Thread Cedric Tefft
Troy Daniels wrote:
 Is it possible the files where created with a mtime in the future?

  From memory, Bacula uses the mtime of the files to determine if they 
 have changed since the last backup ran.

 If they have a mtime in the future they get backed up every time.

 If so, using 'touch' on all the files to reset their mtime should stop 
 the behaviour I believe.
   
Actually bacula uses ctime by default, not mtime.

According to the documentation for File Set options  ( 
http://www.bacula.org/manuals/en/install/install/Configuring_Director.html#SECTION0067
 
), if you set keepatime=yes WITHOUT also setting mtimeonly=yes, bacula 
will back up every file every time, even for incrementals.  HOWEVER if 
the OP is literally using one file set definition for multiple hosts, 
then he should expect to see this behavior on all of those hosts, not 
just the one.

One possibility which occurs to me is that there may be some kind of 
time synchronization problem between the director and the client.  I 
suspect the problem as described could be a result of the client's clock 
being too far ahead of the director's.  I would suggest verifying the 
client and director's clocks more or less agree.  This may be a 
non-obvious issue if the client and director are in different time zones 
-- or, more to the point, if one of them is in the wrong timezone.

- Cedric



--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Updating database 2.x.x to 3.x.x ubuntu problems

2009-09-08 Thread Cedric Tefft
k...@computerking.ca wrote:
 Hello all i am having database problems again, have recently updated to 
 Bacula version 3.0.2 (installed from source on ubuntu 8.04). Tried to run 
 /etc/bacula/update_mysql_tables and got this error

 This script will update a Bacula MySQL database from version 10 to 11
  which is needed to convert from Bacula version 2.0.x to 3.0.x or higher

 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
 password: NO)
 Update of Bacula MySQL tables failed.

 So then i tried to pass the script to mysql like this still did not work

 mysql bacula -ubacula -pbacula  /etc/bacula/update_mysql_tables
 ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the 
 manual that corresponds to your MySQL server version for the right syntax to 
 use near 'echo  
 echo This script will update a Bacula MySQL database from version 10 t' at 
 line 1

 Can i run the script from within mysql? seem to remember that being an unwise 
 thing to do!  However i do not know how to get bacula's database updated! 
 need pass a username and password to the script somehow? 

 Please help
  
   
Any arguments you pass to the update script are passed blindly on to 
mysql, so if you use the -u and -p options to log in to mysql, you need 
to use those same arguments for the update script, like so:

/etc/bacula/update_mysql_tables -u bacula -pbacula

- Cedric



--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Particular schedule

2009-09-06 Thread Cedric Tefft
Fabrizio Reale wrote:
 Hi all,
 what is the best configuration to keep only the backup of:
  * the last 7 days
  * the last 4 sundays
  * the last 6 31st days of the month
  * the last 31st of December
 ?

 Thank you for your help and your software.

 Fabrizio
   
You probably want separate pools for each retention period, so...

 * the last 7 days: Define a DailyPool pool with option VolumeRetention = 7 
days
 * the last 4 sundays: Define a WeeklyPool pool with VolumeRetention = 4 
weeks
etc.


The schedule you described above is a little strange given that five of the 
twelve months of the year do not even have a 31st day.  Anyway, here's a 
schedule that is similar to what I THINK you are trying to achieve without 
being overly complex.  Obviously, this is just a starting point.

Schedule {
  Name = MyCycle
  Run = Level=Full Pool=YearlyPool Jan 1st sun at 6:00
  Run = Level=Full Pool=MonthlyPool feb-dec 1st sun at 6:00
  Run = Level=Full Pool=WeeklyPool 2nd-5th sun at 6:00
  Run = Level=Full Pool=DailyPool mon-sat at 6:00
}


- Cedric


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How could I exlude files greater than a specific filesize from a backup?

2009-09-03 Thread Cedric Tefft
You might be able to accomplish this with a short script that identifies 
the large files, run it before every backup, and use its output as an 
include list for your large-files job and an exclude list for your 
small-files job.

Here is an example for which I've assumed your users are backing up 
their data to /home and your definition of a large file is anything 
larger than 1GB.  Obviously, you should adjust these details fit your 
situation.

Anyway, the script might look something like this:

#!/bin/sh
# generate_large_file_list.sh: Generates a list of files under /home 
larger than 1GB
find /home -size +1G  /etc/bacula/largefiles.lst

Include a RunBeforeJob directive in the job definitions for both your 
large-files and small-files jobs

RunBeforeJob = /path/to/generate_large_file_list.sh

Your large-files File Set would use the generated list as the primary 
file list, like this:

FileSet {
  Name = LargeFiles
  Include {
Options {
   ...
}

File = /etc/bacula/largefiles.lst
  }
}

And the small-files File Set would do the reverse -- it would use the 
same list to tell bacula what NOT to back up, like this:

FileSet {
  Name = SmallFiles
  Include {
Options {
   ...
}

File = /home

  }

  Exclude {
File = /etc/bacula/largefiles.lst
  }
}


- Cedric


Martina Mohrstein wrote:
 Sometimes Users placing a complete image Backup of their drives or big 
 truecrypt containers on the filesystems that are backed up.

 Now I'm thinking of writing two backup Jobs with their own schedules. 
 One for file smaller than a specific some with is run more frequently 
 than the other job which backups only files that are bigger than that 
 specific size.
 I knew that a complete recovery in this case for a complete directory 
 is more difficult, but with these split jobs the needed amount of 
 backup space will be much smaller than now.

 Regards Martina

 
 Surfen – optimiert für MSN. 
 http://redirect.gimas.net/?n=M0908aIE_MSN1_WW
 

 --
 Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
 trial. Simplify your report design, integration and deployment - and focus on 
 what you do best, core application coding. Discover what's new with 
 Crystal Reports now.  http://p.sf.net/sfu/bobj-july
 

 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
   

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How could I exlude files greater than a specific filesize from a backup?

2009-09-03 Thread Cedric Tefft
Nicolas Jungers wrote:
 Le jeudi 03 septembre 2009 à 11:24 -0700, Cedric Tefft a écrit :
   
 You might be able to accomplish this with a short script that identifies 
 the large files, run it before every backup, and use its output as an 
 include list for your large-files job and an exclude list for your 
 small-files job.
 

 I didn't test it, but I've infered from the doc (2.4): 

 Any change to the list of the included files will cause Bacula
 to
 automatically create a new FileSet (defined by the name and an
 MD5
 checksum of the Include/Exclude contents). Each time a new
 FileSet is created, Bacula will ensure that the next backup is
 always a Full save.

 that your proposed solution shall trigger a full save, which may not be
 what's wanted /understatement

 I'll be very happy to learn that I'm wrong because it's one of the
 issues that nags me in Bacula.

 Nicolas
 stinfo/bacula-users
   
I'm not sure the MD5 checksum includes the contents of files external to 
the config, but if it does, just add

  Ignore FileSet Changes = yes

to your File Set definition, and it will do what you want.

- Cedric

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula is not recognising tape as appendable.

2009-09-02 Thread Cedric Tefft
terryc wrote:
 A job calls for an appendable tape
 A volume listing says the tape is appendable.
 The tape is mounted in the drive.
 It acknowledges that the tape is mounted and correctly reports the 
 label, BUT director keeps squarking for hours for an appendable tape.

 Where this happens is on full backup day when the final FULL job gets 
 delayed until a DIFF job gets started because it has higher priority.

 If I cancel the DIFF job, then Bacula gets hopelessly muddled and 
 screwed up and fails to recognise the mounted FULL tape as appendable.

 Nothing short of a complete reboot of the machine (involdes dir, sd  
 fd) will fix this foul up.

 What is wrong in the programming that it persists in rejecting the tape?

   
It might be useful to post your job log as well as the relevant Pool 
definition from your director's config.

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Unsupported feature concerning the Storage definitions?

2009-09-02 Thread Cedric Tefft

Graham Keeling wrote:
 Hello,

 On http://bugs.bacula.org/view.php?id=1356 Kern told me this...

 ...you are using an undocumented feature concerning the Storage definitions,
 and in any case, the way you are using it is definitely not supported and at
 some time will probably cause severe restore problems. You need some support
 help for your conf files, which is not what we do in the bugs database.

 I don't know what he is referring to here. Can anybody help me out?
 I have attached my bacula-sd.conf.
   
My guess would be that he's referring to the fact that you have multiple 
storage devices pointed to exactly the same directory on disk.

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] feature suggestion: convert old full backups to reverse incremental backups

2009-09-02 Thread Cedric Tefft
Good idea.

Gavin McCullagh wrote:
 Hi,

 I'm not sure if this suggestion is well-known already, implemented already
 or maybe just a plain stupid idea that wouldn't work.  So, I'm going to
 suggest it and don my flame-retardant suit.   Feel free to flame or shoot
 it down.

 Suppose I do monthly full backups with differentials and incrementals in
 between.  I'd like to hold onto many years of monthly snapshots.  A file
 which is in the backups unchanged the entire time will be duplicated 12
 times each year.  This is kind of wasteful and will be expensive.  What I'd
 prefer to do is keep a series of full backups (say 6 months worth) and keep
 monthly incrementals or differentials which allow me to get back to earlier
 snapshots.

 I think this might be doable by, every month, running a (new?) type of
 migrate job which takes the oldest two full datasets (fb_t0 and fb_t1) and
 creates an incremental dataset (ib_t1t0) which, applied to fb_t1 would give
 the older dataset.  You would then recycle the fb_t0 dataset but the full
 data would still be available via the incrementals.  A month later the same
 process would happen with fb_t1 and fb_t2.  fb_t0 would then be available
 via fb_t2, ib_t1t0, ib_t2t1.  Over the years, making your way back to the
 start would become a longer and longer process, but at least it would still
 be possible.

 This seems somewhat similar to the new virtual backup feature (which is a
 brilliant one, might I add).

 All suggestions, corrections and criticisms welcome,

 Gavin

 PS if further background is required, see the first three paragraphs of
 this earlier thread.

 http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg36365.html


 --
 Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
 trial. Simplify your report design, integration and deployment - and focus on 
 what you do best, core application coding. Discover what's new with 
 Crystal Reports now.  http://p.sf.net/sfu/bobj-july
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

   

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula backups and restores

2009-09-01 Thread Cedric Tefft
tqz wrote:
 Hmm...I may be getting confused with another response I received from another 
 forum...

 I have my keys stored off site in a secured location, as well as the bacula 
 config files. So in the event of a disaster, if I reinstall bacula and my 
 database management system, restore my keys (from the CD and place them where 
 they were before), use bextract/bscan to dump the latest copy of the bacula 
 catalog/recreate catalog saved on the tape, and then use bacula to restore 
 the contents of the tape should this work? i will test this out, but just 
 want a plan and to confirm that this is possible before doing this. Like I 
 said I am not a system admins (or have any exp in this area as is prob 
 obvious from my posts! :)  )

 Thanks for all your responses...and patience! :)
   
Sounds right to me.

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula thinks empty tapes are full

2009-08-31 Thread Cedric Tefft
Before you start forcibly changing bacula's notion of what tapes are 
full and what tapes are empty, you might want to try to figure out WHY 
bacula thinks your empty tapes are full.  I'm certainly no expert, but 
my guess would be that this is a symptom of a larger problem.  I noticed 
all your non-empty empty tapes aren't JUST marked as full, Bacula thinks 
they all have around 60MB worth of data on them, and they were all 
written to (again as far as bacula is concerned) within the space of 
about an hour.  Are your tapes in a changer?  Is it possible they were 
used without your knowledge?  I have no idea what's going on -- my point 
is only that telling bacula to treat the tapes as empty is probably more 
of a workaround than an actual solution for whatever caused them to be 
marked as full in the first place.   Personally, I would try running 
query #13 or 14 to see what jobs (if any) bacula thinks is on those tapes.


Anyway, to answer your question more directly, you can try pruning the 
offending volumes (use the prune command in the bacula console).  If 
that doesn't work, try purging them (again, the obvious: use the purge 
command), and if THAT fails, use the update command to directly change 
the tapes' status.

- Cedric

Edward Aronyk wrote:
 Hey All,

 I've been using Bacula to backup 7 or 8 servers for a while now and  
 have been fairly pleased. I backup to an external autochanger.

 I started with 20 empty tapes. Now, half way through Bacula is  
 convinced that the rest of the tapes are full, but they aren't...  
 they've never been written to.

 Does anyone have any suggestions how to convince bacula that these  
 tape aren't full?

 *list volumes
 Automatically selected Catalog: MyCatalog
 Using Catalog MyCatalog
 Pool: Default
 +-++---+-+- 
 +--+--+-+--+---+--- 
 +-+
 | MediaId | VolumeName | VolStatus | Enabled | VolBytes|  
 VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType |  
 LastWritten |
 +-++---+-+- 
 +--+--+-+--+---+--- 
 +-+
 |   1 | KHA000L1   | Full  |   1 | 247,597,894,656 |   
 548 |   31,536,000 |   1 |1 | 1 | LTO-1 |  
 2008-11-03 01:07:34 |
 |   2 | KHA001L1   | Full  |   1 | 326,155,640,832 |   
 736 |   31,536,000 |   1 |2 | 1 | LTO-1 |  
 2009-01-05 00:10:10 |
 |   3 | KHA002L1   | Full  |   1 | 257,168,572,416 |   
 491 |   31,536,000 |   1 |3 | 1 | LTO-1 |  
 2009-02-06 23:12:42 |
 |   4 | KHA003L1   | Full  |   1 | 293,170,913,280 |   
 531 |   31,536,000 |   1 |4 | 1 | LTO-1 |  
 2009-03-15 23:15:33 |
 |   5 | KHA004L1   | Error |   1 | 136,982,974,464 |   
 256 |   31,536,000 |   1 |5 | 1 | LTO-1 |  
 2009-04-02 23:14:37 |
 |   6 | KHA005L1   | Error |   1 |  93,291,061,248 |   
 138 |   31,536,000 |   1 |6 | 1 | LTO-1 |  
 2009-04-10 23:43:20 |
 |   7 | KHA006L1   | Full  |   1 | 271,544,232,960 |   
 474 |   31,536,000 |   1 |7 | 1 | LTO-1 |  
 2009-05-17 23:49:44 |
 |   8 | KHA007L1   | Full  |   1 | 278,454,435,840 |   
 472 |   31,536,000 |   1 |8 | 1 | LTO-1 |  
 2009-06-22 23:13:12 |
 |   9 | KHA008L1   | Full  |   1 | 249,486,999,552 |   
 402 |   31,536,000 |   1 |9 | 1 | LTO-1 |  
 2009-07-16 23:21:56 |
 |  10 | KHA009L1   | Full  |   1 |  42,706,944  
 |0 |   31,536,000 |   1 |   10 | 1 | LTO-1 |  
 2009-07-16 23:34:23 |
 |  11 | KHA010L1   | Full  |   1 |  59,157,504  
 |0 |   31,536,000 |   1 |   11 | 1 | LTO-1 |  
 2009-07-16 23:39:32 |
 |  12 | KHA011L1   | Full  |   1 |  66,963,456  
 |0 |   31,536,000 |   1 |   12 | 1 | LTO-1 |  
 2009-07-16 23:44:47 |
 |  13 | KHA012L1   | Full  |   1 |  61,608,960  
 |0 |   31,536,000 |   1 |   13 | 1 | LTO-1 |  
 2009-07-16 23:49:32 |
 |  14 | KHA013L1   | Full  |   1 |  58,447,872  
 |0 |   31,536,000 |   1 |   14 | 1 | LTO-1 |  
 2009-07-16 23:54:16 |
 |  15 | KHA014L1   | Full  |   1 |  57,028,608  
 |0 |   31,536,000 |   1 |   15 | 1 | LTO-1 |  
 2009-07-16 23:59:38 |
 |  16 | KHA015L1   | Full  |   1 |  56,383,488  
 |0 |   31,536,000 |   1 |   16 | 1 | LTO-1 |  
 2009-07-17 00:04:49 |
 |  17 | KHA016L1   | Full  |   1 |  58,705,920  
 |0 |   31,536,000 |   1 |   17 | 1 | LTO-1 |  
 2009-07-17 00:10:00 |

Re: [Bacula-users] Bacula backups and restores

2009-08-31 Thread Cedric Tefft
tqz wrote:
 Hmm...I dont like the fact that if my server and nas devices are all damaged 
 in a fire (for example) then my off site backup copy (the encrypted tape) is 
 useless to me! I dont see the point of having the offsite copy, if what is 
 saved on the tape cant be restored! I'm no system admin, or have any 
 experience in other backup software so dont know if this is the case with 
 them as well or if this is just a down point for using bacula. 

 My boss would like the tapes encrypted as there may be confidential data on 
 the tapes so encrypting the tapes is a requirement for him. Is there any way 
 that I could keep the bacula catalog unencrypted on the same tape? Is this 
 possible to specify in the config files? Or is this being illogical as then 
 anyone can restore the data if they have knowledge on bacula even if the 
 other contents on the tape is encrypted...or is just sending a dump of the 
 bacula catalog via email or to an off site location the only option if we 
 encrypt the tape

 Many thanks in advance
 t.
   

Either you're confused about how encryption works or I'm confused about 
your question.

In order to encrypt (or decrypt) your data you need encryption keys.  
Encryption keys are a bit like passwords, except that they're a little 
bit too long and complex for humans to remember, so we generally store 
them in files.  They have nothing to do with your catalog which is 
basically just a LIST of files you've backed up to tape.

An unencrypted copy of your catalog does not allow you decrypt the 
encrypted data on your tapes.  For that, you need the encryption keys.

I think what you want to do is copy your encryption keys to some type of 
portable media (USB drive, CD, etc.) and store them in a SECURE off-site 
location, but -- and here is the important part -- SEPARATE from where 
you store your tapes.  A safe-deposit box at a bank is a typical example.

Anyone who has your encrypted tapes AND your encryption keys has your 
data, so you need to make sure only trusted individuals have access to 
both.  For added security, I'd suggest you wrap your off-site encryption 
keys in another layer of encryption.  Using PGP (or GPG) to 
conventionally encrypt the key files before writing them to the USB/CD 
would be a good example -- just make sure you don't forget your password!

- Cedric


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Howto make bacula unmount a disk after backup?

2009-08-31 Thread Cedric Tefft
Josh Fisher wrote:
 Thomas wrote:
   
 one year ago i ran into the same problem:

 http://www.adsm.org/lists/html/Bacula-users/2008-07/msg00885.html

 i did only a few tests with usb-sticks
 so there is no solution until now
   
 

 I find it far simpler to use the autofs daemon to automount removable 
 drives at a static mountpoint. Then the Bacula config is exactly as for 
 fixed disk drives
Actually, I considered autofs, but I don't want my backup drive to be 
automatically mounted if I do something stupid like typing rm -rf in 
the wrong directory.  :-)

- Cedric


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] adding my first windows client

2009-08-31 Thread Cedric Tefft
Syn, Joonho wrote:

 Hi,
 I’m trying to add my first windows client to my test instance of 
 bacula running on RHEL5 but I keep getting Authentication Failed 
 errors. It claims that I have an incorrect password but I know this is 
 not true. Since the client is a laptop I thought perhaps that bacula 
 might be confused since it has a wireless and wired interface but this 
 is not the case since I hard-coded the IP into the bacula-dir.conf. 
 I’ll paste the bacula-dir.conf and the bacula-fd.conf from the client.


Version incompatibility?? I see your director is v3.0.1. What version of 
the FD are you running on the Windows box? If it is not at least 3.0 you 
might need to upgrade.

A couple more things to try: run the FD on the Windows box with 
debugging turned on (try adding -d 200 to the command-line). The 
debugging output may be more helpful.
Also, just for grins, I would try temporarily disabling the Windows 
box's other network card -- whichever one bacula is not connecting to. 
This shouldn't make any difference, but if nothing changes it will 
eliminate a number of possibilities.

- Cedric


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Howto make bacula unmount a disk after backup?

2009-08-30 Thread Cedric Tefft
  [Bacula-users] Howto make bacula unmount a disk after backup?
  From: Adam ald.b...@go... - 2009-08-24 23:10
 
  I have looked at bug report 830 on the bug reports list and it would 
appear
  that it has not been fixed. I am using version 3.0.2 of Bacula with the
  following device configuration. The device is not unmounted after the 
job is
  executed.
 
  Device {
  Name = USBBackup1
  Media Type = ExtUSB
  Device Type = File
  LabelMedia = yes
  Random Access = yes
  Requires Mount = yes
  Removable Media = yes
  AlwaysOpen = yes
  Mount Point = /dev/disk/by-label/usb-backup-1
  Mount Command = /bin/mount %m
  Unmount Command = /bin/umount %m
  Archive Device = /mnt/usb-backup-1/backup
  Maximum File Size = 10485760
  }
 
  Regards,
 
  Adam

 From what I can tell, I'm having exactly the same problem.  I am also 
running 3.0.2.  As a test, I tried logging calls to the mount and 
unmount commands with wrapper scripts like so:

Device {
  Name = BackupDrive
  Media Type = File
  Archive Device = /mnt/backup/volumes
  Mount Point = /mnt/backup
  Mount Command = /etc/bacula/mount-wrapper %m
  Unmount Command = /etc/bacula/umount-wrapper %m
  Requires Mount = yes
  LabelMedia = yes
  Random Access = Yes
  AutomaticMount = yes
  RemovableMedia = yes
  AlwaysOpen = no
  Offline On Unmount = Yes  # Also tried no

}

The wrappers are pretty much what you would expect:

# cat /etc/bacula/umount-wrapper
#!/bin/sh
echo umount-wrapper called as $0 $1 $2 $3 $4 $5 $6 $7 $8 $9  
/tmp/mount.log
/bin/umount $1 $2 $3 $4 $5 $6 $7 $8 $9  /tmp/mount.log 21

+++

# cat /etc/bacula/mount-wrapper
#!/bin/sh
echo mount-wrapper called as $0 $1 $2 $3 $4 $5 $6 $7 $8 $9  /tmp/mount.log
/bin/mount $1 $2 $3 $4 $5 $6 $7 $8 $9  /tmp/mount.log 21

+++

After running a couple of backup jobs, I looked at the mount log:

# cat /tmp/mount.log
mount-wrapper called as /etc/bacula/mount-wrapper /mnt/backup
mount-wrapper called as /etc/bacula/mount-wrapper /mnt/backup

It appears bacula calls the mount command as expected, but it never 
calls the unmount command.  Not only does it not do it automatically 
after a backup job completes, it doesn't even do it on an explicit 
umount issued from the console.

Like you, I looked at bug 830 ( http://bugs.bacula.org/view.php?id=830 ) 
which was closed as fixed on 2007-07-16 with the comment::  Fixed in 
current SVN. You must have the appropriate Mount/Unmount commands 
defined in the Device resource and you must declare the device as 
removable otherwise Bacula will not try to mount/unmount it.

Am I missing something?  Is there some reason bug 830 should NOT be 
reopened?

Thx,

- Cedric







--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Howto make bacula unmount a disk after backup?

2009-08-30 Thread Cedric Tefft
OK, I posted new bug, # 1361 ( http://bugs.bacula.org/view.php?id=1361 )

I encourage anybody who is experiencing the same issue to have a look at 
the bug report and add anything relevant.

Thx,

- Cedric


Thomas wrote:
 one year ago i ran into the same problem:

 http://www.adsm.org/lists/html/Bacula-users/2008-07/msg00885.html

 i did only a few tests with usb-sticks
 so there is no solution until now

 Best Regards

 Thomas


 Cedric Tefft schrieb:
   
   [Bacula-users] Howto make bacula unmount a disk after backup?
   From: Adam ald.b...@go... - 2009-08-24 23:10
  
   I have looked at bug report 830 on the bug reports list and it would 
 appear
   that it has not been fixed. I am using version 3.0.2 of Bacula with the
   following device configuration. The device is not unmounted after the 
 job is
   executed.
  
   Device {
   Name = USBBackup1
   Media Type = ExtUSB
   Device Type = File
   LabelMedia = yes
   Random Access = yes
   Requires Mount = yes
   Removable Media = yes
   AlwaysOpen = yes
   Mount Point = /dev/disk/by-label/usb-backup-1
   Mount Command = /bin/mount %m
   Unmount Command = /bin/umount %m
   Archive Device = /mnt/usb-backup-1/backup
   Maximum File Size = 10485760
   }
  
   Regards,
  
   Adam

  From what I can tell, I'm having exactly the same problem.  I am also 
 running 3.0.2.  As a test, I tried logging calls to the mount and 
 unmount commands with wrapper scripts like so:

 Device {
   Name = BackupDrive
   Media Type = File
   Archive Device = /mnt/backup/volumes
   Mount Point = /mnt/backup
   Mount Command = /etc/bacula/mount-wrapper %m
   Unmount Command = /etc/bacula/umount-wrapper %m
   Requires Mount = yes
   LabelMedia = yes
   Random Access = Yes
   AutomaticMount = yes
   RemovableMedia = yes
   AlwaysOpen = no
   Offline On Unmount = Yes  # Also tried no

 }

 The wrappers are pretty much what you would expect:

 # cat /etc/bacula/umount-wrapper
 #!/bin/sh
 echo umount-wrapper called as $0 $1 $2 $3 $4 $5 $6 $7 $8 $9  
 /tmp/mount.log
 /bin/umount $1 $2 $3 $4 $5 $6 $7 $8 $9  /tmp/mount.log 21

 +++

 # cat /etc/bacula/mount-wrapper
 #!/bin/sh
 echo mount-wrapper called as $0 $1 $2 $3 $4 $5 $6 $7 $8 $9  /tmp/mount.log
 /bin/mount $1 $2 $3 $4 $5 $6 $7 $8 $9  /tmp/mount.log 21

 +++

 After running a couple of backup jobs, I looked at the mount log:

 # cat /tmp/mount.log
 mount-wrapper called as /etc/bacula/mount-wrapper /mnt/backup
 mount-wrapper called as /etc/bacula/mount-wrapper /mnt/backup

 It appears bacula calls the mount command as expected, but it never 
 calls the unmount command.  Not only does it not do it automatically 
 after a backup job completes, it doesn't even do it on an explicit 
 umount issued from the console.

 Like you, I looked at bug 830 ( http://bugs.bacula.org/view.php?id=830 ) 
 which was closed as fixed on 2007-07-16 with the comment::  Fixed in 
 current SVN. You must have the appropriate Mount/Unmount commands 
 defined in the Device resource and you must declare the device as 
 removable otherwise Bacula will not try to mount/unmount it.

 Am I missing something?  Is there some reason bug 830 should NOT be 
 reopened?

 Thx,

 - Cedric







 --
 Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
 trial. Simplify your report design, integration and deployment - and focus 
 on 
 what you do best, core application coding. Discover what's new with 
 Crystal Reports now.  http://p.sf.net/sfu/bobj-july
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 

   

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] contradicting volume requests

2006-05-18 Thread Cedric Tefft

Sebastian Stark wrote:

How can I resolve this situation? Volume 81 is currently loaded  
but it is not acceptable. Bacula somehow wants volume 84, which  
is also not acceptable for some reason...



*m
13-May 10:07 yangtse-sd: Backup_yangtse-system.2006-05-13_01.05.00  
Warning: Director wanted Volume 84 for device Drive0 (/dev/ 
rmt/0cbn).

Current Volume 81 not acceptable because:
1998 Volume 81 status is Full, but should be Append,  Purged 
or Recycle.
13-May 10:07 yangtse-sd: Please mount Volume 81 on Storage  
Device Drive0 (/dev/rmt/0cbn) for Job Backup_yangtse-system. 
2006-05-13_01.05.00



This is bacula-1.38.6


On what are you basing your statement that Bacula things volume 84 is 
not acceptable?  I see nothing in the log fragment above to suggest 
this.  Did you actually try mounting volume 84?  If so, where's the 
corresponding piece of the log?


- Cedric




---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Fw: Problem with Python-Script DirStartUp.py: Can't import time-module: Bacula disables python interpreter.

2006-05-17 Thread Cedric Tefft

Christoff Buch wrote:



Dear users,

as the subject says, bacula disables the python interpreter if I try 
to import the time - module (which I need).

Has anyone any idea or experience with this?

Thanks a lot!


I can confirm the problem -- unfortunately no clue on the solution.

- Cedric



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re: excluding with wildcards

2006-05-14 Thread Cedric Tefft

Mark Nienberg wrote:


Cedric Tefft wrote:


Mark Nienberg wrote:

  I understand that I can't change a fileset definition without 
triggering a full backup




Actually, you can.  Just add the line:

 Ignore FileSet Changes = yes

to your file set definition.



Does this mean that the fileset changes are ignored completely until 
the next full backup?  Or does it mean that the incremental backups 
use the new fileset definition without forcing a full backup?


The latter.


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re: excluding with wildcards

2006-05-11 Thread Cedric Tefft

Mark Nienberg wrote:

  I understand that I can't change a fileset definition without 
triggering a full backup




Actually, you can.  Just add the line:

 Ignore FileSet Changes = yes

to your file set definition.

- Cedric



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re: File attributes

2006-05-10 Thread Cedric Tefft

Mark Nienberg wrote:


Mark Nienberg wrote:

I'd like to write an SQL query to extract some information from the 
bacula catalog including file dates.  I see from the bacula 
developers guide that the File table has a field named LStat that 
is defined as File attributes in base64 encoding.  I assume my file 
dates are in there, but how do I deal with the base64 bit?


A typical entry looks like this:
P0A HL4KO IHk B A A A BdD BAA Y BEU0tK BEHwQV BEHwQV A A C

Thanks,
Mark



Anyone?



I've got about half an answer for 'ya.

The database entry appears to be a series of base-64 encoded values 
corresponding to the fields of a UNIX stat structure (plus a couple 
extra bits), which 'man lstat' says is:


 struct stat {
 dev_t st_dev; /* ID of device containing file */
 ino_t st_ino; /* inode number */
 mode_tst_mode;/* protection */
 nlink_t   st_nlink;   /* number of hard links */
 uid_t st_uid; /* user ID of owner */
 gid_t st_gid; /* group ID of owner */
 dev_t st_rdev;/* device ID (if special file) */
 off_t st_size;/* total size, in bytes */
 blksize_t st_blksize; /* blocksize for filesystem I/O */
 blkcnt_t  st_blocks;  /* number of blocks allocated */
 time_tst_atime;   /* time of last access */
 time_tst_mtime;   /* time of last modification */
 time_tst_ctime;   /* time of last status change */
 };

Therefore, from your example, P0A is the base64-encoded value of 
st_dev, HL4KO is the base64-encoded value of st_ino, etc.


So, if you're after the modification time (st_mtime) of your file, you 
should theoretically just have to base64 decode the string BEHwQV to 
get back a standard UNIX timestamp value (seconds since Jan 1, 1970).  
Exactly how you go about doing a base64 decode is, of course, the other 
half of the answer which I'm far too lazy to go into here, but Google 
should be able to take you the rest of the way, and if you're a C 
programmer, the bacula source code itself (in particular 
src/lib/base64.c) should be helpful.


- Cedric




---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Running two jobs consecutively

2006-05-08 Thread Cedric Tefft

Robin Bowes wrote:



How can I guarantee that the verify job will run immediately after the
backup job?

 

Schedule both jobs to start at exactly the same time and set the 
priority of the verify job to be one higher than the priority of the 
backup job.


- Cedric




---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula-web: is it normal for index.php to be blank if there are no jobs set up.

2006-05-01 Thread Cedric Tefft

Chuck Bunn wrote:


Hi Cedric,

Thanks for responding. I looked at my logs and it looks like there are 
a lot of issues. The README says nothing about LDAP or rights and 
ownership on directories under bacula-web. Is there a document 
somewhere that can guide me to do what is necessary to get this 
running. I changed ownership on templates_c to apache:apache but this 
still didn't fix the problem. At least there is progress, now the 
screen shows Error querry: 4. Here is my log:


[client 192.168.1.37] PHP Fatal error:  Smarty error: unable to write 
to $compile_dir '/var/www/html/bacula-web/templates_c'. Be sure 
$compile_dir is writable by the web server user. in 
/var/www/html/bacula-web/external_packages/smarty/Smarty.class.php on 
line 1088



Well, the bacula-web manual is posted on bacula web site:

http://www.bacula.org/bacula-web/index.html

I didn't see any mention of file system permissions there either, but 
then again, the error message itself kinda tells you what to do.  As for 
LDAP, I think those messages are generated by Apache for reasons 
unrelated to bacula-web.




I cleared the log after changing rights on 'templates_c' and I now get 
the following after accessing the page:


[EMAIL PROTECTED] httpd]#  /var/log/httpd/error_log
[EMAIL PROTECTED] httpd]# cat error_log
[client 127.0.0.1] PHP Notice:  Use of undefined constant phptype - 
assumed 'phptype' in /var/www/html/bacula-web/classes.inc on line 82

ANy ideas on what to do next??


I have this message in my error log as well, but it works anyway, so I 
guess it's not fatal (you'll notice it's a NOTICE, not an error).  The 
only other things I can suggest are


1) Read the manual
2) Make sure you've got the latest public release which is apparently 
here: 
http://prdownloads.sourceforge.net/bacula/bacula-gui-1.38.5.tar.gz?download


- Cedric





---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula-web image test/phplot fails with argument not an array errors

2006-04-27 Thread Cedric Tefft

Juan Luis Frances wrote:


Hello Cedric,

If you use the last public version you musn't to have this problem: 
http://prdownloads.sourceforge.net/bacula/bacula-gui-1.38.5.tar.gz?download


I have PHP 5.1.2 and bacula-web runs ok.

Best regards,
Juan Luis Francés

 


Much better.

Thanks,

- Cedric



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula-web: is it normal for index.php to be blank if there are no jobs set up.

2006-04-27 Thread Cedric Tefft

Chuck Bunn wrote:


Hi,

I am just getting a blank page with no errors when I go to 
'mymachine/bacula-web/index.php'. When I go to 
'mymachine/bacula-web/stats.php' I get a small table that says None 
data to process (yes it says 'None' instead of 'No'). Is all of this 
normal or do I have a problem somewhere. I would think the page would 
come up with at least the descriptions even though there is no data 
yet to display? I have no jobs setup yet...


Thanks

Check your web server's error log.  Mine's /var/log/httpd/error_log -- 
but yours may be elsewhere.


- Cedric




---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula-web image test/phplot fails with argument not an array errors

2006-04-26 Thread Cedric Tefft

Pieter (NL) wrote:


I've got it working. Problem is the array_merge function. For phplot I've
installed a newer version of phplot (rc2) from
http://www.sourceforge.net/projects/phplot/ in the external_packages/phplot
directory.
There are some other phpscripts i've adjusted
classes.inc:

bsdtest# grep -e array_merge *
classes.inc: $whole_result[] =
array_merge((array)$row[$derecha],(array)$row[$izquierda]);
classes.inc: $whole_result[] =
array_merge((array)$row[Jobid],(array)$row[JobFiles],(array)$row[JobBytes]);
classes.inc: $spr2 =
array_merge($spr2,array($row[Name]=$row[SUM(JobBytes)]));

Pieter

 

Thanks, that did the trick, but yuck!  Anybody got a reason why this 
shouldn't be submitted as a bug?


Thx,

- Cedric



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-24 Thread Cedric Tefft

Cedric Tefft wrote:


Robert Nelson wrote:


You can also try select Name from Filename where CAST(Name AS CHAR) =
'makedev';.

On my machine it was somewhat faster than CONVERT.

  


Out of curiosity, I plugged the CAST() function in to query.sql and 
ran a real bacula search for 'makedev'.  I did this three times and 
then did the CONVERT() version three times.


Averages:

CAST: 62 seconds
CONVERT: 58 seconds


Obviously the CAST() version is preferable though, in practice, I 
don't know if you'd be able to tell the difference without a stopwatch.


Yeah, that makes a lot of sense.  Sorry, I swapped the figures.  CAST 
average was 58 seconds, CONVERT was 62



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Windows client problems

2006-04-24 Thread Cedric Tefft

Brian McCann wrote:


Hi all.  I'm having a problem with a Windows client when I try to run
the system state backup.  If the bacula-fd service is set to run as
LocalSystem, it runs fine.  But, when I change the service to run as
Administrator, it dies right away and doesn't run the backup.  To make
things more interesting, when I manaully run bacula-fd -d 100  out
while logged in as Administrator, the out file never gets anything
in it, and the backup runs fine.

Any ideas anyone?

--Brian


I've never used the Windows daemon, but since nobody else has chimed in I'll 
just throw out a couple things I remember from my Windows sysadmin days...

If bacula-fd's output is all generated to STDERR instead of STDOUT, it would explain why 
the out file is empty.  You can capture STDERR as well as STDOUT with 
something like:

bacula-fd -d 100  out 21


Have you checked permissions for the Administrator account -- i.e. does 
it have the Log in as Service right?


Have you given the Administrator password in the service config?

Have you checked the event log?

When you say it dies right away are you talking about the backup or 
the daemon?  In other words, when you try to start the service, can you 
verify that it actually appears in the Services MMC as started?


- Cedric


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Newbie: How to manage multiple pools and multiple FDs

2006-04-24 Thread Cedric Tefft

Ryan Novosielski wrote:

Sorry I wasn't clearer -- why I'd want multiple pools is fairly 
obvious. Why I'd possibly want multiple catalogs is what I didn't 
understand.


Well, one possible reason would be to keep your catalog(s) to a 
manageable size.  There are other threads on the list right now 
discussing the problem of running out of memory trying to restore large 
file sets (millions of files).  In one case the poster reported that it 
took over an hour for Bacula just to pull the LIST of files out of the 
database.  If your installation is large enough, you can end up with a 
catalog that is unwieldy, if not outright unmanageable.  Splitting the 
data up into multiple catalogs is one way to address this problem.


- Cedric



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Getting Version error for database bacula

2006-04-24 Thread Cedric Tefft

Raffaele Pantaleoni wrote:

Hi,
this is the first time I write. I'm going to use bacula in my office
network to help my users with a network backup. So during the last days
I was playing with Bacula to understand it (I already printed and read
the huge manual). After some useful tests I tried to uninstall it and
reinstall, but from this point I run into the following error:

Starting the Bacula Storage daemon
Starting the Bacula File daemon
Starting the Bacula Director daemon
24-Apr 15:51 bacula-dir:  Fatal error: Version error for database
bacula. Wanted 8, got 0
24-Apr 15:51 bacula-dir:  Fatal error: Could not open database bacula.
24-Apr 15:51 bacula-dir:  Fatal error: Version error for database
bacula. Wanted 8, got 0
24-Apr 15:51 bacula-dir ERROR TERMINATION
Please correct configuration file: /etc/bacula/bacula-dir.conf

My system is the following:
Linux Debian 3.1r0
AMD Athlon 2800+
256 MB Ram
40 Gb Hd
Bacula 1.36.2-2 with sqlite support

I've installed Bacula (1.36.2-2) using Aptitude , first time everything
was fine and I backed up and restored a Linux pc as well a Windows one.
Then I've tried to clean up to start again from scratch but something is
wrong.

I've tried also to download the sources and build them. Everything was
configured and made but if I try to run it I get the above error.

What's wrong? I would like to understand where my mistakes are!

Thanks a lot.
  

Sounds like you might need to reinitialize the bacula database:

http://www.bacula.org/rel-manual/Installing_Configurin_MySQL.html#SECTION000483000

- Cedric



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] bacula-web image test/phplot fails with argument not an array errors

2006-04-24 Thread Cedric Tefft

Hi all -

I'm struggling to get bacula-web 1.1 working.  System is Fedora core 5, 
Apache 2.2.0, PHP 5.1.2, gd 2.0.33, bacula 1.38.8.


test.php reports GetText, Pear(DB), and GD are all OK.  Then I click on 
the link to test the graph system capabilities, and all the image links 
are broken.  The page continues to load for a while (the browser's 
spinner keeps spinning anyway), but eventually times out.


I found a clue as to what's going on, I'm just not sure what to do about 
it.  Apache's error log shows hundreds of thousands of these entries:


[Mon Apr 24 18:54:18 2006] [error] [client 192.168.1.22] PHP Warning:  
array_merge() [a href='function.array-merge'function.array-merge/a]: 
Argument #1 is not an array in 
/home/httpd/html/bacula/external_packages/phplot/phplot.php on line 
4084, referer: 
http://www.chaos.local/bacula/external_packages/phplot/examples/test_setup.php
[Mon Apr 24 18:54:18 2006] [error] [client 192.168.1.22] PHP Warning:  
array_merge() [a href='function.array-merge'function.array-merge/a]: 
Argument #2 is not an array in 
/home/httpd/html/bacula/external_packages/phplot/phplot.php on line 
4084, referer: 
http://www.chaos.local/bacula/external_packages/phplot/examples/test_setup.php
[Mon Apr 24 18:54:18 2006] [error] [client 192.168.1.22] PHP Warning:  
array_merge() [a href='function.array-merge'function.array-merge/a]: 
Argument #1 is not an array in 
/home/httpd/html/bacula/external_packages/phplot/phplot.php on line 
4084, referer: 
http://www.chaos.local/bacula/external_packages/phplot/examples/test_setup.php
[Mon Apr 24 18:54:18 2006] [error] [client 192.168.1.22] PHP Warning:  
array_merge() [a href='function.array-merge'function.array-merge/a]: 
Argument #2 is not an array in 
/home/httpd/html/bacula/external_packages/phplot/phplot.php on line 
4084, referer: 
http://www.chaos.local/bacula/external_packages/phplot/examples/test_setup.php


I'm not a PHP programmer and I don't play one on TV, but this looks like 
a bug or a misleading error message.  Short of debugging phplot, I'm not 
quite sure where to go from here.  Any suggestions?


Thx,

- Cedric








---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-23 Thread Cedric Tefft

Robert Nelson wrote:

You can also try select Name from Filename where CAST(Name AS CHAR) =
'makedev';.

On my machine it was somewhat faster than CONVERT.

  
Out of curiosity, I plugged the CAST() function in to query.sql and ran 
a real bacula search for 'makedev'.  I did this three times and then did 
the CONVERT() version three times.


Averages:

CAST: 62 seconds
CONVERT: 58 seconds


Obviously the CAST() version is preferable though, in practice, I don't 
know if you'd be able to tell the difference without a stopwatch. 


- Cedric




---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Newbie: How to manage multiple pools and multiple FDs

2006-04-23 Thread Cedric Tefft

Ryan Novosielski wrote:


Can anyone explain why one might want to have more than one? I don't
recall this being covered in the manual. I know there are slightly
obvious reasons, but they aren't coming to me at present.

 


The answer to your question is cleverly hidden in the manual:

http://www.bacula.org/rel-manual/Getting_Started_with_Bacula.html#SECTION00092000


- Cedric



---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Segmentation violation message

2006-04-19 Thread Cedric Tefft

Jaime Ventura wrote:



18-Apr 18:50 bserver-dir:  Error: message.c:668 fopen 
ñ/bserver-dir.bserver-dir.5 992232.mail failed: ERR=No 
such file or directory
18-Apr 18:50 bserver-dir: Fatal Error because: Bacula interrupted by 
signal 11: Segmentation viol ation

*
Can you help me with this last error messages?


It just means the director crashed -- probably due to the errors in your 
initial config.  Now that you've corrected those errors, it shouldn't 
happen again.


- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Cedric Tefft

Mark Nienberg wrote:

I'm using Bacula to back up a Linux Samba fileserver among other 
machines.  Of course the clients to the fileserver are windows 
machines and they don't care about case in filenames.  They create all 
sorts of case combinations like document1.doc, Document2.DOC and 
so on.


My most common restore scenario is when someone deletes or corrupts a 
file and asks me to restore a previous version of it.  The easiest way 
to do this in the console is (I think) to use the query command option 
2 List Jobs where a given File is saved, and then pick an 
appropriate jobID to restore from based on date of backup.


The problem is that the search for the filename is case sensitive (the 
MySQL field is type binary) so it is hard to guess what filename to 
enter.  I wonder if I could use option 4 Enter SQL list command to 
do a case-insensitive search.  Any suggestions on what this SQL 
command would look like for MySQL?  Or is there a better way to do this?



Add this query to your  query.sql file:

# 18 - case insensitive version of query #2
:List up to 20 places where a File is saved regardless of the directory 
(case insensitive):

*Enter Filename (no path):
SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
 Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
AND JobStatus='T' AND Job.JobId=File.JobId
AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
AND convert(Filename.Name USING latin1)='%1'
ORDER BY Job.StartTime LIMIT 20;

Now, instead of picking query #2, pick query #18 (or whatever is the 
last one on the list).  It works exactly like query #2, but it's case 
insensitive.  I suspect you'll need at least mysql 4.0 or better for 
this to work, and it's rather slow, but it should do the trick.


- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Newbie: How to manage multiple pools and multiple FDs

2006-04-19 Thread Cedric Tefft

Thomas Deutsch wrote:


How can I backup (nightly backup) both of this servers on the same tape and use my 4 
tapepools? The 4 pools are for daily, weekly, monthly and yearly backup. But in the 
definition of the jobs, I can use Pool =  only once, right? How can I make 
this?
 

This would be done in the schedule definition.  See 
http://www.bacula.org/rel-manual/Configuring_Director.html#SECTION000145000



And another stupid newbie-question: What is catalog database and do I have to 
backup ist for every FD?
 

To the first question, read the manual: 
http://www.bacula.org/rel-manual/What_is_Bacula.html#SECTION00042000


To the second question: no.  By default, you have only one catalog 
database which holds metadata for all your clients.


- Cedric




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] what kind of pool

2006-04-19 Thread Cedric Tefft

Eric Warnke wrote:

I would _presume_ it used the one in the job description ( more 
specific ), but you can always tell by issuing a the reload and run 
command in bconsole to preview what pool it's using.


According to the docs, the settings in the Schedule take precedence over 
the settings in the Job:


From 

http://www.bacula.org/rel-manual/Configuring_Director.html#SECTION000145000

The *Job-overrides* permit overriding the Level, the Storage, the 
Messages, and the Pool specifications provided in the Job resource. In 
addition, the FullPool, the IncrementalPool, and the DifferentialPool 
specifications permit overriding the Pool specification according to 
what backup Job Level is in effect.


- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula segfault (pythonlib?)

2006-04-19 Thread Cedric Tefft

Kern Sibbald wrote:

By the way, I would be interested in hearing what you are doing with 
Bacula+Python, and most likely some of the list members would too.


 

Nothing very exciting -- just generating new volume labels.  The script 
is attached to my original post on this topic if you're curious.


- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Segmentation violation message

2006-04-19 Thread Cedric Tefft

Jaime Ventura wrote:


Ok, i understand that. But should i report it as a bug?
Should i never use the reload command on the console any more?
If i do /etc/init.d/bacula-dir restart, at least i wont have a 
Segmentation violation...:(

Well, thanks anyway.


Well, I don't think it was technically the reload that caused the 
crash.  From your original report, the last line in the log file before 
the crash was about Resetting previous configuration, so it would 
appear the problem is not so much in the reload command, but in bacula's 
attempt to revert to the previous config.


This does look like a bug, and you can report it as such (go to 
http://bugs.bacula.org), but it's a bug that would only occur when your 
config file is invalid, so my suspicion is that  it may not be at the 
top of Kern's to do list.  But I don't want to speak for the guy, and it 
can't hurt to try, so by all means, give it a shot.


- Cedric




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] case insensitive query

2006-04-19 Thread Cedric Tefft

Troy Daniels wrote:


An update to this.

I cant vouch for this exact query - on my system it takes a looonnggg 
time to finish due to the 2 million plus files recorded and I gave up 
and canceled it, but the following simplified version worked:


mysql select Name from Filename where LCASE(Name) = 'makedev';
+-+
| Name|
+-+
| MAKEDEV |
+-+
1 row in set (1.15 sec)

So I dont understand why it wouldn't work in the other query - but I'm 
not a MySQL Guru.


I am running MySQL Server 3.23.58 tho which could be the difference I 
suppose.




Hmm... yeah, I tried that, but it didn't work for me, whereas the 
CONVERT() strategy does:


mysql select Name from Filename where LCASE(Name) = 'makedev';
Empty set (1.03 sec)

mysql select Name from Filename where CONVERT(Name using latin1)='makedev';
+-+
| Name|
+-+
| MAKEDEV |
+-+
1 row in set (1.85 sec)


I am using mysql 5.0.18, though, like you,  I don't know why that should 
make a difference.


- Cedric






---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula segfault (pythonlib?)

2006-04-16 Thread Cedric Tefft

Kern Sibbald wrote:

Can you confirm either by testing or from your knowledge of the problem that 
it does not occur if there are not simultaneous jobs using Python.  If this 
is the case, let me know and I'll work on adding a correct recursive lock 
that allows only one Bacula thread at a time in the Python libraries ...


 

Hmm... tricky. Of course, any change I make has a good chance of 
preventing the segfault, so I'm not sure if this proves anything, but 
here 'ya go:  I spaced the three jobs out to start one minute apart and 
changed the file sets to back up more data (enough to make the backup 
jobs take about ten minutes to run).  This ensured the Python init 
scripts wouldn't run at the same time, but made sure that (after the 
third minute) all three jobs would be active (running or waiting) at 
the same time.  Sure enough, the segfault was prevented, however I'm not 
sure if this was because there was only one instance of Python running 
at any given time or because I'd simply perturbed the race condition.  I 
think that's the best test I can do, but if you have an alternate 
suggestion, I'd be happy to try it out.


Thanks,

- Cedric






---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Re: Bacula segfault (pythonlib?)

2006-04-14 Thread Cedric Tefft
Sorry, I should have prefaced this by mentioning this is an AMD K6-2 
system running Fedora Core 5 (kernel 2.6.16.2), Python 2.4.2, just 
upgraded from FC3 (kernel 2.11.11, Python 2.3).  The segfaults occured 
both before and after the OS upgrade (and yes, I remembered to recompile 
Bacula).


Thx,

- Cedric



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Variable expansion with padding and increment

2005-05-21 Thread Cedric Tefft

Hi all -

I've having trouble with variable expansion.  I can get it to do padding 
and I can get it to do autoincrement, but I can't figure out how to do 
both in the same operation.


Here's the scenario:

I've been using Bacula for a couple years, but up to now I've been 
labeling tapes manually.  Now I'm trying to set up automatic tape 
labeling.  My tape names look like TAPE01, TAPE02, etc. so I obviously 
want to continue labeling them with that format.  Unfortunately, I can't 
use the built-in NumVols because some earlier tapes have been destroyed, 
so the number of volumes in the pool no longer coincides with the next 
tape number.   I've got a database counter defined in bacula-dir.conf


Counter {
 Name = DefaultPoolCounter
 Minimum=1
 Catalog=MyCatalog
}

The padding seems to work OK:

# var TAPE${DefaultPoolCounter:p/2/0/r}
TAPE02

And the autoincrement seems to work OK

#var TAPE${DefaultPoolCounter+}
TAPE2

#var TAPE${DefaultPoolCounter+}
TAPE3

But when I try to do both in the same operation, the counter is 
incremented, but the padding specifier is not honored.  It's printed 
literally:


#var ${DefaultPoolCounter+:p/2/0/r}
TAPE3p/2/0/r}

#var ${DefaultPoolCounter+:p/2/0/r}
TAPE4p/2/0/r}

I've tried the '+' sign in various places...

#var ${DefaultPoolCounter:p/2/0/r+}
#var ${DefaultPoolCounter:p/2/0/r}+
#var ${DefaultPoolCounter:+p/2/0/r}

all to no avail.

What am I doing wrong? 


- Cedric



---
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7412alloc_id=16344op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users