Re: [Bacula-users] Error with DR backups
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.
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?
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
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
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
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
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
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
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:
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
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?
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
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
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
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
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
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
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
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?
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
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
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
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?
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
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 ???
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 ?
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
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
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
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?
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?
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.
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?
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
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
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
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
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?
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
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?
[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?
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
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.
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
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
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
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
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.
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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?)
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
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
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?)
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?)
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
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