Re: [Bacula-users] How to avoid The sizes do not match!?
You could configure your Bacula to use new volume for every job, this could solve your problem. -Original Message- From: epiuse [mailto:bacula-fo...@backupcentral.com] Sent: Thursday, October 15, 2009 10:45 AM To: bacula-users@lists.sourceforge.net Subject: [Bacula-users] How to avoid The sizes do not match!? Hi there, We're currently using bacula 3.0.2 to backup some windows XP and Vista clients. Every now and then, while a backup (Diff or Full) are running, the user may turn of his/her laptop, network issues may occur or whatever else may cause a connection error and then obviously the backup fails. My problem is that each time this happens and the next client's backup starts to make use of the same volume, it gives me the Error: Bacula cannot write on disk Volume Diff_Vol0217 because: The sizes do not match! error message and marks the volume in error in the catalog. Is there any wau to avoid this happening each time? Pool definition: Pool { Name = Diff Label Format = Diff_Vol Pool Type = Backup Recycle = yes # Bacula can automatically recycle Volumes AutoPrune = yes # Prune expired volumes Volume Retention = 3 days Maximum Volumes = 7 Maximum Volume Bytes = 40G } Thanks in advance :) +-- |This was sent by ech...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- 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 -- 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] Out of Disk Space
Hi, 16.10.2009 00:38, Dupree, Craig wrote: Hi Arno, Theoretically, yes, though it will lock up your tape drive for a while, and might leave you with an incomplete backup. If the job was actually finished writing to tape, and you're absolutely sure everything you need ended up on tape, you could do that. A full backup would lock the tape drive up for longer though. If that's the case, use bscan. Although I found that bscanning usually takes longer than writing, though there are some factors involved which make that hard to guess - starting with your network and client throughput during backup, if spooling is used, and the catalog performance. At least the tape drive is actually hooked up to the system. I suppose I should just bite the bullet, and backup again. That way I know that I'm safe. That's surely right... The error was: Fatal error: Can't 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=Disk is full writing './bacula/File.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 The director claimed that it was inserting the attributes. This was the first clue that there was problem, as this was what it said at 6:00 am when I woke up checked the system out. I remember thinking yea it finished. Then later when I got in to work, I pulled my checklist off of the printer, logged in to the backup server since that is check 1. It still said inserting attributes, and then when I got to step 2 (check disk space) then I knew what the problem was. Hmm... the cases when I had that same problem usually resolved without permanent erros, but I assume there might be some timeouts either in MySQL or Bacula. In your case, the disk full condition might have existed for too long to Bacula to automatically recover. But this seems to confirm that the disk full was indeed the underlying problem, and the insertion of the attributes finally failed. This is for the older 2.x release. I plan to upgrade to 3.x over the Winter break. Perhaps better to add more disk space first :-) Yes. Or at least re-installing the system so it is laid out better. I love LVM :-) Arno Craig -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück www.its-lehmann.de -- 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 to avoid The sizes do not match!?
epiuse schrieb: Hi there, We're currently using bacula 3.0.2 to backup some windows XP and Vista clients. Every now and then, while a backup (Diff or Full) are running, the user may turn of his/her laptop, network issues may occur or whatever else may cause a connection error and then obviously the backup fails. My problem is that each time this happens and the next client's backup starts to make use of the same volume, it gives me the Error: Bacula cannot write on disk Volume Diff_Vol0217 because: The sizes do not match! error message and marks the volume in error in the catalog. Is there any wau to avoid this happening each time? Pool definition: Pool { Name = Diff Label Format = Diff_Vol Pool Type = Backup Recycle = yes # Bacula can automatically recycle Volumes AutoPrune = yes # Prune expired volumes Volume Retention = 3 days Maximum Volumes = 7 Maximum Volume Bytes = 40G } Thanks in advance :) Do you have spooling enabled? Enabling spooling should work around a failure on the client side during the backup during writing of the spool (the job will just fail), if the spooling part gets done OK then bacula will start writing to the real volume. Note: this will only really work if your spool can hold the full backup, otherwise something can go wrong during the multiple spooling / despooling phases. Note2: iirc bacula wont actually finish the job on the client side until the despooling is also completed so things may still go wrong during the despooling phase even if the SD already has all the data when the client goes away, but the time to despool is (for me) much faster than getting data directly from the client, so the window for failure gets a lot smaller. -- 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
[Bacula-users] Renaming volumes...
Hi, I use a USB disk as storage and at first I had volumes labeled like this: Label Format = ${Client}.${Year}-${Month:p/2/0/r}.full.v${NumVols} Label Format = ${Client}.${Year}-${Month:p/2/0/r}.diff.v${NumVols} Label Format = ${Client}.${Year}-${Month:p/2/0/r}.incr.v${NumVols} But, after seeing that the date is useless/confusing with the recycling, I'd like to use this: Label Format = ${Client}.full.v${NumVols} Label Format = ${Client}.diff.v${NumVols} Label Format = ${Client}.incr.v${NumVols} Is there a list of steps to follow or is it a nightmare? Or, at worse, how can I restart from 'zero'? Delete from the console and then the files? Thx, JD -- 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-devel] VirtualFull backup: bacula selects the wrong read device
Hello, On Monday 12 October 2009 04:09:16 Nicolae Mihalache wrote: I tried your change but VirtualFull with multiple read devices is not working. Restore is working but it was working even without your change. Yes, I hadn't noticed one small important detail in your code :-( so my code didn't implement what you had done. I think I know why: 1. the code from reserve.c:637 dcr = new_dcr(rctx.jcr, rctx.jcr-dcr, rctx.device-dev); always changes the write device, never the read device. The function new_dcr returns the rctx.jcr-dcr if it's not NULL. Your change of removing the rctx.jcr-dcr= in front has no effect when the dcr is not NULL. 2. however, further down in reserve.c:716 rctx.jcr-read_dcr = dcr; this makes effectively the read_dcr the same with the write dcr. The old read_dcr is lost. 3. why restoring from multiple devices works? Because after the first pass, the read_dcr and the write dcr are the same, so in all the subsequent passes, changing the write dcr will also change the read_dcr. In restores the write dcr is not used so it all works. 4. why the virtual full backup works when there is only one read device? Because the storage director selects first the read dcr (overwriting in the same time the write dcr) but then it creates a brand new write dcr in reserve.c:251. So the original write dcr is used for reading and a new dcr is used for writing. This all happens before the backup starts when the dcr pointers can still change (apparently). 5. why the virtual full backup doesn't work when there is more than one device? Because the trick of transforming the write dcr into the read_dcr doesn't work anymore first because the backup has started and dcr pointers can't change anymore and second because the write dcr is still needed. OK. I have reviewed the code again, and put in your code but re-written slightly. The only problem is that it then breaks bextract. After a good deal of debugging, I finally figured out why (a problem of initialization of read_dcr I think). It is now fixed and in version 3.0.3. nicolae Kern Sibbald wrote: By the way, the new_dcr(), form me is OK as is. It does indeed create a new dcr, but if it is possible to reuse the existing one, it does rather than mallocing a new one. In any case, any change to new_dcr() is a bit more disruptive than I would like to do just now. The name new_dcr is confusing (not anymore to me). The function returns the dcr passed as argument unless it was null. It should be perhaps called renew_dcr. Maybe I'm spoiled by all these OOP languages where new of something makes you a brand new object. I have attached the patch that went into version 3.0.3 (applies in principle to 3.0.2 on top of my previous (broken) patch. You will see that the code in reserve.c is essentially identical to yours, and there is one new line added to acquire.c (jcr-read_dcr = dcr;) that is important if you want bextract to work. Version 3.0.3 should be released Monday at the latest ... Thanks for your work on this. It was extremely helpful. Best regards, Kern commit 9ddecaa80c15d1abd89f29c9185a464103d9d5aa Author: Kern Sibbald k...@sibbald.com Date: Fri Oct 16 07:50:48 2009 +0200 Fix switching read device reported by Nicolae Mihalache ma...@abcpages.com diff --git a/bacula/src/stored/acquire.c b/bacula/src/stored/acquire.c index b2bf07e..7042440 100644 --- a/bacula/src/stored/acquire.c +++ b/bacula/src/stored/acquire.c @@ -63,7 +63,8 @@ bool acquire_device_for_read(DCR *dcr) int vol_label_status; int retry = 0; - Dmsg1(950, jcr-dcr=%p\n, jcr-dcr); + Dmsg2(950, dcr=%p dev=%p\n, dcr, dcr-dev); + Dmsg2(950, MediaType dcr=%s dev=%s\n, dcr-media_type, dev-device-media_type); dev-dblock(BST_DOING_ACQUIRE); if (dev-num_writers 0) { @@ -123,6 +124,7 @@ bool acquire_device_for_read(DCR *dcr) lock_reservations(); memset(rctx, 0, sizeof(RCTX)); rctx.jcr = jcr; + jcr-read_dcr = dcr; jcr-reserve_msgs = New(alist(10, not_owned_by_alist)); rctx.any_drive = true; rctx.device_name = vol-device; @@ -166,6 +168,7 @@ bool acquire_device_for_read(DCR *dcr) goto get_out; } } + Dmsg2(400, MediaType dcr=%s dev=%s\n, dcr-media_type, dev-device-media_type); dev-clear_unload(); @@ -329,7 +332,8 @@ get_out: } else { dev-dunlock(); /* dunblock() unlock the device too */ } - Dmsg1(950, jcr-dcr=%p\n, jcr-dcr); + Dmsg2(950, dcr=%p dev=%p\n, dcr, dcr-dev); + Dmsg2(950, MediaType dcr=%s dev=%s\n, dcr-media_type, dev-device-media_type); return ok; } diff --git a/bacula/src/stored/reserve.c b/bacula/src/stored/reserve.c index a4fe70c..6824d16 100644 --- a/bacula/src/stored/reserve.c +++ b/bacula/src/stored/reserve.c @@ -634,7 +634,11 @@ static int reserve_device(RCTX rctx) rctx.suitable_device = true; Dmsg1(dbglvl, try reserve %s\n, rctx.device-hdr.name); - dcr =
[Bacula-users] Order of Install?
I've look at a number of guides, and as yet, none recommend an order to install bacula in. Also, none recommend what is the best source to use, packaged for the distro, or the source. I'm attempting to install on a CentOS 5.3 box fully updated. Any hints and tips will be appreciated. --- Kind Regards, Mr Gabriel -- 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] autochanger and barcode
Nicola, If you're using barcodes you can greatly simplify what you're doing. Instead of using one pool per day, just use one pool for all backups and one scratch pool. Place all the tapes in the scratch pool. Forget about trying to keep straight which tape is for which day and let bacula track that for you. When you need to do a restore, let bacula tell you which volumes that data is on. Set volume retention, job retention, file retention, and volume use duration if you find that you don't fill up a tape as fast as you would like, then if you wanted to do some inchanger-out of changer tape rotation, periodically remove tapes marked Full or Used. To label them do 'label barcodes slots=first-last substituting the slot numbers for the first and last slots holding the tapes to be labelled. Bob From: Nicola Quargentan nic...@quargentan.com Subject: [Bacula-users] autochanger and barcode To: bacula-users@lists.sourceforge.net Message-ID: 4ad79c49.3080...@quargentan.com Content-Type: text/plain; charset=ISO-8859-15; format=flowed hi, I'm very newbie and I want to use a DELL TL2000 autochanger. I made 7 pool in config file, one for each day of week: Monday, Tuesday, etc. I want to use one volume for day and label it same as barcode. When I tried label barcode I must to put all tape in only one pool: *label barcode The defined Storage resources are: 1: File 2: autochanger Select Storage resource (1-2): 2 Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4 has 23 slots. Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger list command. The following Volumes will be labeled: Slot Volume == 1 GDV100L4 5 GDV101L4 6 GDV102L4 12 GDV107L4 13 GDV105L4 14 GDV104L4 15 GDV103L4 16 GDV106L4 Do you want to label these Volumes? (yes|no): yes Defined Pools: 1: Scratch 2: FullTest 3: DiffTest 4: IncrTest 5: Default 6: Monday 7: Tuesday 8: Wednesday 9: Thursday 10: Friday 11: Saturday 12: Sunday Select the Pool (1-12): . So I cannot put the volume GDV100L4 in Monday, GDV101L4 in Tuesday etc. I tried also to put all volumes in Scratch pool, but bacula return a lot of messages: Cannot label Volume because it is already labeled. 1) Is there a clue to add one volume labeled by barcode to a single pool? 2) How I can relabel the volumes (I found a bad clue on the web: erase every tapes manually :( ). Thanks, Nicola. -- 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] autochanger and barcode
If you're using barcodes you can greatly simplify what you're doing. Instead of using one pool per day, just use one pool for all backups and one scratch pool. Place all the tapes in the scratch pool. BTW, I definitely agree with this. It's best not to have 1 pool per day if you do not really need that. Having this many pools is going to reduce the number autochanger slots you have available. At minimum 7 slots will have partially used tapes at all times and if you have any retention period this will use at least 14 slots when the first volume of each pool is full. John -- 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] autochanger and barcode
John Drescher ha scritto: On Thu, Oct 15, 2009 at 7:48 PM, Nicola Quargentan nic...@quargentan.com wrote: John Drescher ha scritto: On Thu, Oct 15, 2009 at 6:03 PM, Nicola Quargentan nic...@quargentan.com wrote: hi, I'm very newbie and I want to use a DELL TL2000 autochanger. I made 7 pool in config file, one for each day of week: Monday, Tuesday, etc. I want to use one volume for day and label it same as barcode. When I tried label barcode I must to put all tape in only one pool: cut Uhm, ok, but how? *update volume Parameters to modify: 1: Volume Status 2: Volume Retention Period 3: Volume Use Duration 4: Maximum Volume Jobs 5: Maximum Volume Files 6: Maximum Volume Bytes 7: Recycle Flag 8: Slot 9: InChanger Flag 10: Volume Files 11: Pool 12: Volume from Pool 13: All Volumes from Pool 14: Enabled 15: RecyclePool 16: Done Select parameter to modify (1-16): 11 Defined Pools: 1: Scratch 2: FullTest 3: DiffTest 4: IncrTest 5: Default 6: Monday 7: Tuesday 8: Wednesday 9: Thursday 10: Friday 11: Saturday 12: Sunday Select the Pool (1-12): 1 No results to list. Enter MediaId or Volume name: GDV100L4 sql_get.c:1005 Media record for Volume GDV100L4 not found. Thanks. I just tested this and the Select the Pool must be the old pool. But I haven't an old pool, I never associated a volume to a pool (I hope). After you select a volume bacula will ask you to type the pool name. In this case I would put all volumes into the Scratch pool. Ok, I think this is a good clue. If you labeled many tapes this will be tedious. A second way would be direct manipulation of the database. Remember to shut down bacula-dir before you do this. Uhm, I don't want to handle manually the database, If I can. Thanks, Nicola Quargentan. -- 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] autochanger and barcode
Alex Chekholko ha scritto: On Fri, 16 Oct 2009 16:52:21 +0200 Nicola Quargentan nic...@quargentan.com wrote: I just tested this and the Select the Pool must be the old pool. But I haven't an old pool, I never associated a volume to a pool (I hope). From your previous mail, it looks like when you did a label barcodes and it asked you which pool to put them into, you entered . Entering a period should cancel the whole operation. But maybe it didn't. What does your list volumes return? It will show which volumes bacula knows about, what pool they are in (and they must be in some pool! Scratch is best for new volumes) and what slot bacula thinks they are in the library. *list volumes Pool: Scratch No results to list. Pool: FullTest No results to list. Pool: DiffTest No results to list. Pool: IncrTest No results to list. Pool: Default No results to list. Pool: Monday No results to list. Pool: Tuesday No results to list. Pool: Wednesday No results to list. Pool: Thursday No results to list. Pool: Friday No results to list. Pool: Saturday No results to list. Pool: Sunday No results to list. Nicola Quargentan. -- 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] autochanger and barcode
On Fri, Oct 16, 2009 at 12:17 PM, Nicola Quargentan nic...@quargentan.com wrote: Alex Chekholko ha scritto: On Fri, 16 Oct 2009 16:52:21 +0200 Nicola Quargentan nic...@quargentan.com wrote: I just tested this and the Select the Pool must be the old pool. But I haven't an old pool, I never associated a volume to a pool (I hope). From your previous mail, it looks like when you did a label barcodes and it asked you which pool to put them into, you entered . Entering a period should cancel the whole operation. But maybe it didn't. What does your list volumes return? It will show which volumes bacula knows about, what pool they are in (and they must be in some pool! Scratch is best for new volumes) and what slot bacula thinks they are in the library. *list volumes Pool: Scratch No results to list. Pool: FullTest No results to list. Pool: DiffTest No results to list. Pool: IncrTest No results to list. Pool: Default No results to list. Pool: Monday No results to list. Pool: Tuesday No results to list. Pool: Wednesday No results to list. Pool: Thursday No results to list. Pool: Friday No results to list. Pool: Saturday No results to list. Pool: Sunday No results to list. Okay. None of the tapes are in any pool. So now you really only want to use the label barcodes command and put all volumes in the Scratch pool. No need to specify slots since all tapes need to go to the scratch. John -- 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] autochanger and barcode
Bob Hetzel ha scritto: Nicola, If you're using barcodes you can greatly simplify what you're doing. Instead of using one pool per day, just use one pool for all backups and one scratch pool. Place all the tapes in the scratch pool. Ok, now this is that I want. Forget about trying to keep straight which tape is for which day and let bacula track that for you. When you need to do a restore, let bacula tell you which volumes that data is on. I'm not fully persuased about bacula. I fear that the database (MySQL) become corrupted. Set volume retention, job retention, file retention, and volume use duration if you find that you don't fill up a tape as fast as you would like, then if you wanted to do some inchanger-out of changer tape rotation, periodically remove tapes marked Full or Used. To label them do 'label barcodes slots=first-last substituting the slot numbers for the first and last slots holding the tapes to be labelled. Ok, I think the first problem was to erase all volume. Now when I label barcodes the volumes was defined in my scratch pool :) cut... Thanks. Nicola Quargentan -- 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
[Bacula-users] brestore cache tables
Hi trying to get webrestore to work, so far I can see page clients but not jobs. I believe this is because I have no imported the bweb.sql. According to the install file its says, 3) Make sure that brestore cache tables are in your catalog (bweb-xxx.sql files) How do I achieve this, I ran the following but it doesn't work. mysql -u bacula -p bacula bweb-mysql.sql Enter password: ERROR 1064 (42000) at line 7: 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 'IF EXISTS base64_decode_lstat' at line 1 -- 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] autochanger and barcode
I'm not fully persuased about bacula. I fear that the database (MySQL) become corrupted. That is why you should keep a copy of the database on a disk based volume (or other backup) on a different machine than the one that contains the database. I have most of my backups ( 25TB now) go to tape but my database backup goes to a disk volume on a different machine than the one containing the database. John -- 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] autochanger and barcode
John Drescher ha scritto: On Fri, Oct 16, 2009 at 12:17 PM, Nicola Quargentan nic...@quargentan.com wrote: Alex Chekholko ha scritto: cut... Okay. None of the tapes are in any pool. So now you really only want to use the label barcodes command and put all volumes in the Scratch pool. No need to specify slots since all tapes need to go to the scratch. John Ok, current situation: *update slots The defined Storage resources are: 1: File 2: autochanger Select Storage resource (1-2): 2 Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4 has 23 slots. Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger list command. Catalog record for Volume GDV100L4 updated to reference slot 1. Catalog record for Volume GDV106L4 updated to reference slot 2. Volume GDV101L4 not found in catalog. Slot=5 InChanger set to zero. Catalog record for Volume GDV102L4 updated to reference slot 6. Catalog record for Volume GDV107L4 updated to reference slot 12. Catalog record for Volume GDV105L4 updated to reference slot 13. Catalog record for Volume GDV104L4 updated to reference slot 14. Catalog record for Volume GDV103L4 updated to reference slot 15. *list volumes Pool: Scratch +-++---+-+--+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | Enabled | VolBytes | VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-++---+-+--+--+--+-+--+---+---+-+ | 14 | GDV100L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 |1 | 1 | LTO4 | -00-00 00:00:00 | | 15 | GDV106L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 |2 | 1 | LTO4 | -00-00 00:00:00 | | 16 | GDV102L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 |6 | 1 | LTO4 | -00-00 00:00:00 | | 17 | GDV107L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 | 12 | 1 | LTO4 | -00-00 00:00:00 | | 18 | GDV105L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 | 13 | 1 | LTO4 | -00-00 00:00:00 | | 19 | GDV104L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 | 14 | 1 | LTO4 | -00-00 00:00:00 | | 20 | GDV103L4 | Append| 1 | 64,512 |0 | 31,536,000 | 1 | 15 | 1 | LTO4 | -00-00 00:00:00 | +-++---+-+--+--+--+-+--+---+---+-+ Pool: FullTest No results to list. Pool: DiffTest No results to list. Pool: IncrTest No results to list. Pool: Default No results to list. Pool: Monday No results to list. Pool: Tuesday No results to list. Pool: Wednesday No results to list. Pool: Thursday No results to list. Pool: Friday No results to list. Pool: Saturday No results to list. Pool: Sunday No results to list. * Now I have some problem with slot 5. I will try to clean the tape (with mtx). Nicola Quargentan. -- 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] autochanger and barcode
On Fri, Oct 16, 2009 at 1:05 PM, Nicola Quargentan nic...@quargentan.com wrote: John Drescher ha scritto: On Fri, Oct 16, 2009 at 12:17 PM, Nicola Quargentan nic...@quargentan.com wrote: Alex Chekholko ha scritto: cut... Okay. None of the tapes are in any pool. So now you really only want to use the label barcodes command and put all volumes in the Scratch pool. No need to specify slots since all tapes need to go to the scratch. John Ok, current situation: *update slots The defined Storage resources are: 1: File 2: autochanger Select Storage resource (1-2): 2 Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4 has 23 slots. Connecting to Storage daemon autochanger at backup.quargentan.loc:9103 ... 3306 Issuing autochanger list command. Catalog record for Volume GDV100L4 updated to reference slot 1. Catalog record for Volume GDV106L4 updated to reference slot 2. Volume GDV101L4 not found in catalog. Slot=5 InChanger set to zero. Catalog record for Volume GDV102L4 updated to reference slot 6. Catalog record for Volume GDV107L4 updated to reference slot 12. Catalog record for Volume GDV105L4 updated to reference slot 13. Catalog record for Volume GDV104L4 updated to reference slot 14. Catalog record for Volume GDV103L4 updated to reference slot 15. *list volumes Pool: Scratch +-++---+-+--+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | Enabled | VolBytes | VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-++---+-+--+--+--+-+--+---+---+-+ | 14 | GDV100L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 1 | 1 | LTO4 | -00-00 00:00:00 | | 15 | GDV106L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 2 | 1 | LTO4 | -00-00 00:00:00 | | 16 | GDV102L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 6 | 1 | LTO4 | -00-00 00:00:00 | | 17 | GDV107L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 12 | 1 | LTO4 | -00-00 00:00:00 | | 18 | GDV105L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 13 | 1 | LTO4 | -00-00 00:00:00 | | 19 | GDV104L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 14 | 1 | LTO4 | -00-00 00:00:00 | | 20 | GDV103L4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 15 | 1 | LTO4 | -00-00 00:00:00 | +-++---+-+--+--+--+-+--+---+---+-+ Pool: FullTest No results to list. Pool: DiffTest No results to list. Pool: IncrTest No results to list. Pool: Default No results to list. Pool: Monday No results to list. Pool: Tuesday No results to list. Pool: Wednesday No results to list. Pool: Thursday No results to list. Pool: Friday No results to list. Pool: Saturday No results to list. Pool: Sunday No results to list. * Now I have some problem with slot 5. I will try to clean the tape (with mtx). Perhaps you did not do an update slots before the label? type label barcodes again into the Scratch pool. Even though bacula will say its going to label all of the volumes it will only choose the one in slot5 John -- 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] Building bacula-fd on OpenBSD 4.5
Martin Simmons wrote: On Thu, 15 Oct 2009 07:34:57 -0300, Daniel Bareiro said: On Wednesday, 14 October 2009 17:38:59 +0100, Martin Simmons wrote: # DGB - 20091012 # Starting bacula-fd on boot if [ -x /etc/bacula/scripts/bacula-ctl-fd ]; then /etc/bacula/scripts/bacula-ctl-fd start fi Daniel, I'm the port maintainer for Bacula on OpenBSD. And this is the way I start bacula (with /etc/rc.local). There is some way to normally stop daemon during shutdown/reboot of the operating system? bacula-fd will just stop properly when it receives the kill signal during the shutdown process. If that's not good enough for you, you could add a similar stanza as you use in rc.local to rc.shutdown with s/start/stop/. Also, the port that's in -current for the latest and greatest Bacula that should work with only a little tweaking in 4.5. Email me privately if you need some help. If OpenBSD uses /usr/local/etc/rc.d like FreeBSD, then it would be better to add a script there. It doesn't out of the box. There are a couple ports that offer a SysV-like startup process, but rc.local is the preferred way to start daemons. -ME -- 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] autochanger and barcode
Hi, 16.10.2009 18:45, Nicola Quargentan wrote: Bob Hetzel ha scritto: ... Forget about trying to keep straight which tape is for which day and let bacula track that for you. When you need to do a restore, let bacula tell you which volumes that data is on. I'm not fully persuased about bacula. I fear that the database (MySQL) become corrupted. In all the years I use Bacula at several locations I haven't seen such a case (unless I broke it myself, manually, and knowing the risk I ran :-) , so I believe you don't have to be afraid of that. Furthermore, once you have more than a really small number of backup jobs, backups you keep, clients, and media, you need some way to track all of that. Bacula's database catalog is, compared to most of the other solutions I had to suffer, astonishingly robust. Furthermore, you can do as many dumps of it as you like. And any manual way of managing that information is, in my opinion, doomed to fail - I recall when I was using tar and lots of post-its on the tapes, and then tar plus some script resulting in printouts of the backup information... unmaintainable is a polite word to describe that. In short, the catalog *any* serious backup solution provides is essential, and you've simply got to trust it. Bacula's catalog is one of the more robust versions of such a catalog, and thus it's unlikely any alternative will work more considerably reliable. Arno cut... Thanks. Nicola Quargentan -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück www.its-lehmann.de -- 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
[Bacula-users] Tape Problems
Hi everyone! I having some problems with my backup planning. I want to work with five tapes per week. One for Monday, Tuesday, Wednesday, Thursday and Friday. This five tapes will be used till the end of the month. The problem is the following. The backup finished OK yesterday (Thursday). Later I changed the tape for one labeled Friday. However, when bacula started its jobs, it required the Thursday tape instead of using the new tape and did not finished the backup job. How can I make this work? Best regards, João K. -- 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 Problems
On Fri, Oct 16, 2009 at 3:10 PM, João Kuchnier joao.kuchn...@gmail.com wrote: Hi everyone! I having some problems with my backup planning. I want to work with five tapes per week. One for Monday, Tuesday, Wednesday, Thursday and Friday. This five tapes will be used till the end of the month. The problem is the following. The backup finished OK yesterday (Thursday). Later I changed the tape for one labeled Friday. However, when bacula started its jobs, it required the Thursday tape instead of using the new tape and did not finished the backup job. How can I make this work? This is expected unless you take specific steps to force bacula use the tapes you want. The safest way to do this is make a pool for each day. MondayPool TuesdayPool ... And then only put the Monday tape in the MondayPool and then have your schedule backup jobs on Monday to the MondayPool ... A hack to force Bacula to use the Friday tape today is to update volume on the Thursday Tape and mark it Full or Used Then purge the Friday tape. John -- 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 Problems
On Fri, Oct 16, 2009 at 3:44 PM, João Kuchnier joao.kuchn...@gmail.com wrote: I will need create new schedules and jobs too write? One for each pool. No one schedule but one Run= for each day. For example: Schedule { Name = MonthlyCycle Run = Level=Full Pool=SundayPool sun at 2:05 Run = Level=Incremental Pool=MondayPool mon at 2:05 Run = Level=Incremental Pool=TuesdayPool tue 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] Renaming volumes...
John Doe wrote: Hi, I use a USB disk as storage and at first I had volumes labeled like this: Label Format = ${Client}.${Year}-${Month:p/2/0/r}.full.v${NumVols} Label Format = ${Client}.${Year}-${Month:p/2/0/r}.diff.v${NumVols} Label Format = ${Client}.${Year}-${Month:p/2/0/r}.incr.v${NumVols} But, after seeing that the date is useless/confusing with the recycling, I'd like to use this: Label Format = ${Client}.full.v${NumVols} Label Format = ${Client}.diff.v${NumVols} Label Format = ${Client}.incr.v${NumVols} Is there a list of steps to follow or is it a nightmare? Not a nightmare, but lots of sql digging ... Or, at worse, how can I restart from 'zero'? Delete from the console and then the files? You can use the delete volume on bconsole ( this ensure not leaving orphaned file/jobs/volumes in db ) After that you can delete corresponding volumes. (I would tend to prefer this one) Thx, JD -- Bruno Friedmann Ioda-Net Sàrl 2830 Vellerat - Switzerland Tél : ++41 32 435 7171 Fax : ++41 32 435 7172 gsm : ++41 78 802 6760 www.ioda-net.ch Centre de Formation et de Coaching En Ligne www.cfcel.com -- 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 Problems
On Fri, Oct 16, 2009 at 4:59 PM, João Kuchnier joao.kuchn...@gmail.com wrote: I will test this settings as soon as I can. Thanks! BTW, you can move your current tapes to the new pools (one by one) using update volume then choose Pool then select the current pool. then enter the id either by tape name or metaid. Proceed this with a * if you type the metaid. Then you are prompted for the new pool. John -- 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
[Bacula-users] sorting output bconsole
Does bconsole support sorting of output? For instance, can bconsole sort the output of list volumes pool=FullPool by size or date? kind regards, Terry -- 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] sorting output bconsole
On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro tinza...@ha-solutions.net wrote: Does bconsole support sorting of output? For instance, can bconsole sort the output of list volumes pool=FullPool by size or date? kind regards, You can do that in a query. John -- 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] sorting output bconsole
Hi: On Fri, Oct 16, 2009 at 4:03 PM, Terry L. Inzauro tinza...@ha-solutions.net wrote: Does bconsole support sorting of output? For instance, can bconsole sort the output of list volumes pool=FullPool by size or date? I don't think this is possible but you could some bash script to sort: -init of bconsole.sh script --- #!/bin/bash bconsole EOF messages list jobs EOF end of bash script --- $ ./bconsole.sh | dos2unix | awk '{ print $15 }' | sort -n That is just an idea (I use a lot of this kind of scripts with bconsole). Right know I'm not sure if 15th (from $15 in awk command) column of 'list jobs' output contains bytes size of the backup. I hope this helps kind regards, Terry -- 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 -- 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] sorting output bconsole
John Drescher wrote: On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro tinza...@ha-solutions.net wrote: Does bconsole support sorting of output? For instance, can bconsole sort the output of list volumes pool=FullPool by size or date? kind regards, You can do that in a query. John When you say query, I'm assuming you are suggesting I run an SQL query. I like the idea, however, I am not versed in the ways of the SQL master. Is there a repository of SQL queries somewhere that may be of use for reporting purposes? I am trying to figure out a way to automate reporting for a client on a daily/weekly/monthly basis. Terry -- 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] autochanger and barcode
John Drescher ha scritto: I'm not fully persuased about bacula. I fear that the database (MySQL) become corrupted. That is why you should keep a copy of the database on a disk based volume (or other backup) on a different machine than the one that contains the database. I have most of my backups ( 25TB now) go to tape but my database backup goes to a disk volume on a different machine than the one containing the database. But the use of pools on what for? Just for completeness I must save this data: 1) Oracle db (size unknown) 2) 5-6 MySQL db (about 25 Gb) 3) Some samba share, with office files (5Gb) 4) An subversion reposity (size unknown) 5) Mail server (size unknown) 6) The configuration of 8 servers 7) Other things that now I do not remember :) I should make a pool for each points? Thanks. Nicola Quargentan -- 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] sorting output bconsole
On Fri, Oct 16, 2009 at 6:30 PM, Terry L. Inzauro tinza...@ha-solutions.net wrote: John Drescher wrote: On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro tinza...@ha-solutions.net wrote: Does bconsole support sorting of output? For instance, can bconsole sort the output of list volumes pool=FullPool by size or date? kind regards, You can do that in a query. John When you say query, I'm assuming you are suggesting I run an SQL query. I like the idea, however, I am not versed in the ways of the SQL master. Is there a repository of SQL queries somewhere that may be of use for reporting purposes? I am trying to figure out a way to automate reporting for a client on a daily/weekly/monthly basis. type query in bconsole. There are several builtin queries you can use as examples. I believe bacula-dir.conf specifies the location of where the query file is. On my system I have QueryFile = /usr/libexec/bacula/query.sql Add your query to that file at the end and bacula will load and execute that with the query command of bconsole. John -- 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 Problems
On Fri, Oct 16, 2009 at 7:10 PM, João Kuchnier joao.kuchn...@gmail.com wrote: I created the new pools but I had a problem.: pool directive in Job BKP_Servidor resource is required, but not found. What pool I can configure here? I putted the pool configuration inside Schedules. Like this: Schedule { Name = ScheduleDefault Run = Level=Full Pool=segunda-vol mon at 01:00 Run = Level=Differential Pool=terca-vol tue at 01:00 Run = Level=Differential Pool=quarta-vol wed at 01:00 Run = Level=Differential Pool=quinta-vol thu at 01:00 Run = Level=Differential Pool=sexta-vol fri at 01:00 } I tough Bacula would catches the pool configuration from here. What can I do? Just give the job any pool and the run command of the schedule will override the default job pool. See here: http://www.bacula.org/en/dev-manual/Configuring_Director.html#SECTION00145 John -- 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] sorting output bconsole
John Drescher wrote: On Fri, Oct 16, 2009 at 6:30 PM, Terry L. Inzauro tinza...@ha-solutions.net wrote: John Drescher wrote: On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro tinza...@ha-solutions.net wrote: Does bconsole support sorting of output? For instance, can bconsole sort the output of list volumes pool=FullPool by size or date? kind regards, You can do that in a query. John When you say query, I'm assuming you are suggesting I run an SQL query. I like the idea, however, I am not versed in the ways of the SQL master. Is there a repository of SQL queries somewhere that may be of use for reporting purposes? I am trying to figure out a way to automate reporting for a client on a daily/weekly/monthly basis. type query in bconsole. There are several builtin queries you can use as examples. I believe bacula-dir.conf specifies the location of where the query file is. On my system I have QueryFile = /usr/libexec/bacula/query.sql Add your query to that file at the end and bacula will load and execute that with the query command of bconsole. John Yup. That should do it. For testing, I've decided to use the mysql command line interface and I have one last question. How would I take take sums of two columns such as JobFiles and JobBytes [18:13:04 r...@jenna:~]# mysql -u root -px Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 489 Server version: 5.0.51a-24+lenny2-log (Debian) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use bacula; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql SELECT DISTINCT Job.JobId as JobId,Client.Name as Client, FileSet.FileSet AS FileSet,Level,StartTime, JobFiles,JobBytes,VolumeName FROM Client,Job,JobMedia,Media,FileSet WHERE Client.Name='peyton' AND Client.ClientId=Job.ClientId AND Job.Type='B' AND Job.JobStatus='T' AND Job.FileSetId=FileSet.FileSetId AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId ORDER BY Job.StartTime; +---++---+---+-+--+---+---+ | JobId | Client | FileSet | Level | StartTime | JobFiles | JobBytes | VolumeName| +---++---+---+-+--+---+---+ | 4700 | peyton | StandardLinux | F | 2009-09-06 05:28:54 |47498 | 789899195 | FullPool_0067 | | 4777 | peyton | StandardLinux | D | 2009-09-13 00:37:11 | 50 | 2442702 | DiffPool_0004 | | 4910 | peyton | StandardLinux | I | 2009-09-25 00:28:57 | 43 | 2095221 | IncrPool_0036 | | 4921 | peyton | StandardLinux | I | 2009-09-26 00:29:15 | 41 | 2072585 | IncrPool_0090 | | 4932 | peyton | StandardLinux | D | 2009-09-27 00:53:34 | 52 | 2497277 | DiffPool_0011 | | 4943 | peyton | StandardLinux | I | 2009-09-28 00:29:48 | 50 | 2366865 | IncrPool_0037 | | 4954 | peyton | StandardLinux | I | 2009-09-29 00:28:55 | 41 | 2018132 | IncrPool_0119 | | 4965 | peyton | StandardLinux | I | 2009-09-30 00:38:28 | 41 | 2035566 | IncrPool_0136 | | 4976 | peyton | StandardLinux | I | 2009-10-01 00:29:36 | 41 | 2052047 | IncrPool_0130 | | 4987 | peyton | StandardLinux | I | 2009-10-02 00:31:56 | 45 | 2069134 | IncrPool_0011 | | 4998 | peyton | StandardLinux | I | 2009-10-03 00:29:48 | 41 | 2085954 | IncrPool_0140 | | 5009 | peyton | StandardLinux | F | 2009-10-04 05:36:39 |47498 | 789930570 | FullPool_0009 | | 5020 | peyton | StandardLinux | I | 2009-10-05 00:29:15 | 50 | 2378897 | IncrPool_0029 | | 5031 | peyton | StandardLinux | I | 2009-10-06 00:29:07 | 41 | 2029220 | IncrPool_0004 | | 5042 | peyton | StandardLinux | I | 2009-10-07 00:51:50 | 41 | 2046245 | IncrPool_0055 | | 5053 | peyton | StandardLinux | I | 2009-10-08 00:28:28 | 41 | 2062919 | IncrPool_0077 | | 5108 | peyton | StandardLinux | I | 2009-10-14 01:25:39 | 50 | 2430892 | IncrPool_0079 | | 5119 | peyton | StandardLinux | I | 2009-10-14 02:41:33 | 50 | 2431747 | IncrPool_0027 | | 5130 | peyton | StandardLinux | I | 2009-10-15 00:30:11 | 41 | 2073822 | IncrPool_0009 | | 5141 | peyton | StandardLinux | I | 2009-10-16 00:30:07 | 41 | 2091084 | IncrPool_0005 | +---++---+---+-+--+---+---+ 20 rows in set (0.01 sec) Thank you for all of your help. Terry -- 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
[Bacula-users] Fwd: Tape Problems
Forwarding to the list so others can possibly answer.. -- Forwarded message -- From: João Kuchnier joao.kuchn...@gmail.com Date: Fri, Oct 16, 2009 at 7:10 PM Subject: Re: [Bacula-users] Tape Problems To: John Drescher dresche...@gmail.com I created the new pools but I had a problem.: pool directive in Job BKP_Servidor resource is required, but not found. What pool I can configure here? I putted the pool configuration inside Schedules. Like this: Schedule { Name = ScheduleDefault Run = Level=Full Pool=segunda-vol mon at 01:00 Run = Level=Differential Pool=terca-vol tue at 01:00 Run = Level=Differential Pool=quarta-vol wed at 01:00 Run = Level=Differential Pool=quinta-vol thu at 01:00 Run = Level=Differential Pool=sexta-vol fri at 01:00 } I tough Bacula would catches the pool configuration from here. What can I do? João K. 2009/10/16 John Drescher dresche...@gmail.com: On Fri, Oct 16, 2009 at 4:59 PM, João Kuchnier joao.kuchn...@gmail.com wrote: I will test this settings as soon as I can. Thanks! BTW, you can move your current tapes to the new pools (one by one) using update volume then choose Pool then select the current pool. then enter the id either by tape name or metaid. Proceed this with a * if you type the metaid. Then you are prompted for the new pool. John -- John M. Drescher -- 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] Fwd: Tape Problems
Sorry, I though I was answering to all the list. The schedules will start on monday. If something goes wrong, I report to the list. João K. 2009/10/16 John Drescher dresche...@gmail.com: Forwarding to the list so others can possibly answer.. -- Forwarded message -- From: João Kuchnier joao.kuchn...@gmail.com Date: Fri, Oct 16, 2009 at 7:10 PM Subject: Re: [Bacula-users] Tape Problems To: John Drescher dresche...@gmail.com I created the new pools but I had a problem.: pool directive in Job BKP_Servidor resource is required, but not found. What pool I can configure here? I putted the pool configuration inside Schedules. Like this: Schedule { Name = ScheduleDefault Run = Level=Full Pool=segunda-vol mon at 01:00 Run = Level=Differential Pool=terca-vol tue at 01:00 Run = Level=Differential Pool=quarta-vol wed at 01:00 Run = Level=Differential Pool=quinta-vol thu at 01:00 Run = Level=Differential Pool=sexta-vol fri at 01:00 } I tough Bacula would catches the pool configuration from here. What can I do? João K. 2009/10/16 John Drescher dresche...@gmail.com: On Fri, Oct 16, 2009 at 4:59 PM, João Kuchnier joao.kuchn...@gmail.com wrote: I will test this settings as soon as I can. Thanks! BTW, you can move your current tapes to the new pools (one by one) using update volume then choose Pool then select the current pool. then enter the id either by tape name or metaid. Proceed this with a * if you type the metaid. Then you are prompted for the new pool. John -- John M. Drescher -- 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 -- 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] sorting output bconsole
17.10.2009 2:19, Terry L. Inzauro kirjoitti: For testing, I've decided to use the mysql command line interface and I have one last question. How would I take take sums of two columns such as JobFiles and JobBytes [18:13:04 r...@jenna:~]# mysql -u root -px Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 489 Server version: 5.0.51a-24+lenny2-log (Debian) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use bacula; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql SELECT DISTINCT Job.JobId as JobId,Client.Name as Client, FileSet.FileSet AS FileSet,Level,StartTime, JobFiles,JobBytes,VolumeName FROM Client,Job,JobMedia,Media,FileSet WHERE Client.Name='peyton' AND Client.ClientId=Job.ClientId AND Job.Type='B' AND Job.JobStatus='T' AND Job.FileSetId=FileSet.FileSetId AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId ORDER BY Job.StartTime; +---++---+---+-+--+---+---+ | JobId | Client | FileSet | Level | StartTime | JobFiles | JobBytes | VolumeName| +---++---+---+-+--+---+---+ | 4700 | peyton | StandardLinux | F | 2009-09-06 05:28:54 |47498 | 789899195 | FullPool_0067 | | 4777 | peyton | StandardLinux | D | 2009-09-13 00:37:11 | 50 | 2442702 | DiffPool_0004 | | 4910 | peyton | StandardLinux | I | 2009-09-25 00:28:57 | 43 | 2095221 | IncrPool_0036 | | 4921 | peyton | StandardLinux | I | 2009-09-26 00:29:15 | 41 | 2072585 | IncrPool_0090 | | 4932 | peyton | StandardLinux | D | 2009-09-27 00:53:34 | 52 | 2497277 | DiffPool_0011 | | 4943 | peyton | StandardLinux | I | 2009-09-28 00:29:48 | 50 | 2366865 | IncrPool_0037 | | 4954 | peyton | StandardLinux | I | 2009-09-29 00:28:55 | 41 | 2018132 | IncrPool_0119 | | 4965 | peyton | StandardLinux | I | 2009-09-30 00:38:28 | 41 | 2035566 | IncrPool_0136 | | 4976 | peyton | StandardLinux | I | 2009-10-01 00:29:36 | 41 | 2052047 | IncrPool_0130 | | 4987 | peyton | StandardLinux | I | 2009-10-02 00:31:56 | 45 | 2069134 | IncrPool_0011 | | 4998 | peyton | StandardLinux | I | 2009-10-03 00:29:48 | 41 | 2085954 | IncrPool_0140 | | 5009 | peyton | StandardLinux | F | 2009-10-04 05:36:39 |47498 | 789930570 | FullPool_0009 | | 5020 | peyton | StandardLinux | I | 2009-10-05 00:29:15 | 50 | 2378897 | IncrPool_0029 | | 5031 | peyton | StandardLinux | I | 2009-10-06 00:29:07 | 41 | 2029220 | IncrPool_0004 | | 5042 | peyton | StandardLinux | I | 2009-10-07 00:51:50 | 41 | 2046245 | IncrPool_0055 | | 5053 | peyton | StandardLinux | I | 2009-10-08 00:28:28 | 41 | 2062919 | IncrPool_0077 | | 5108 | peyton | StandardLinux | I | 2009-10-14 01:25:39 | 50 | 2430892 | IncrPool_0079 | | 5119 | peyton | StandardLinux | I | 2009-10-14 02:41:33 | 50 | 2431747 | IncrPool_0027 | | 5130 | peyton | StandardLinux | I | 2009-10-15 00:30:11 | 41 | 2073822 | IncrPool_0009 | | 5141 | peyton | StandardLinux | I | 2009-10-16 00:30:07 | 41 | 2091084 | IncrPool_0005 | +---++---+---+-+--+---+---+ 20 rows in set (0.01 sec) If you want that same list, and add the sums at the end, I don't believe it is possible with MySQL client. It would be easy with Oracle SQL*Plus, but not with MySQL client. A simple query will return those SELECT SUM(JobFiles) AS JobFilesSum, SUM(JobBytes) AS JobBytesSum FROM Job ; but that is not much of interest, I guess. -- http://www.iki.fi/jarif/ Ships are safe in harbor, but they were never meant to stay there. pgp4nr7VIFAt3.pgp Description: PGP signature -- 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
[Bacula-users] Best backup strategy to use the minimum size
Hi people: I'm trying to find the best combination of Full, Differential and Incremental backups to save disk space, I'd like someone can help me with some ideas: Our policy says that we must keep user data of last 3 months, so according to that I planned to do something like this: Client { ... ... File Retention = 90 days Job Retention = 90 days } Pool { Name = Default Type = Backup Recycle = yes Autoprune = yes Label Format = Vol- Volume Use Duration = 10 days Volume Retention = 90 days } Schedule { Name = Daily Run Level=Incremental Pool=Default } As you see I only run Incremental backups letting Bacula autodetect the first as a Full Backup. So after 90 days I would have a Full Backup and 89 Incremental Backups (or so), but past ten days my first Volume (the one that includes my first and unique Full Backup) would be marked as Purged and consequently Recycled. So I would lose the posibility to restore my hole data within those 90 days because with many incremental but no full backup I can't do anything, right? If I pretend not to lose my Full Backups every time a Volume gets recycled I think should be necessary to run a Full Backup every ten days, right? But I think that doing so would consume too much disk space, or not? - Is this the best way (space economically) to keep 90 days of recoverable data? - Do I need to use different Pools for Incremental and Full Backups? - What are your best backup strategies to keep data available to be restored? Please consider that I'm using File disk Backups. I hope someone can point me to better ideas than mine Thanks -- 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
On Fri, Oct 16, 2009 at 8:05 PM, Jose Perez jvoorhe...@gmail.com wrote: Hi people: I'm trying to find the best combination of Full, Differential and Incremental backups to save disk space, I'd like someone can help me with some ideas: Our policy says that we must keep user data of last 3 months, so according to that I planned to do something like this: Client { ... ... File Retention = 90 days Job Retention = 90 days } Pool { Name = Default Type = Backup Recycle = yes Autoprune = yes Label Format = Vol- Volume Use Duration = 10 days Volume Retention = 90 days } Schedule { Name = Daily Run Level=Incremental Pool=Default } As you see I only run Incremental backups letting Bacula autodetect the first as a Full Backup. So after 90 days I would have a Full Backup and 89 Incremental Backups (or so), but past ten days my first Volume (the one that includes my first and unique Full Backup) would be marked as Purged and consequently Recycled. So I would lose the posibility to restore my hole data within those 90 days because with many incremental but no full backup I can't do anything, right? If I pretend not to lose my Full Backups every time a Volume gets recycled I think should be necessary to run a Full Backup every ten days, right? But I think that doing so would consume too much disk space, or not? - Is this the best way (space economically) to keep 90 days of recoverable data? - Do I need to use different Pools for Incremental and Full Backups? - What are your best backup strategies to keep data available to be restored? Please consider that I'm using File disk Backups. I hope someone can point me to better ideas than mine Here's one possibility: Pool { Name = Full ... Volume Use Duration = 23 hours Volume Retention = 89 days } Pool { Name = Differential ... Volume Use Duration = 23 hours Volume Retention = 89 days } Pool { Name = Incremental ... Volume Use Duration = 23 hours Volume Retention = 90 days } 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). Another way to do it that uses even less disk space would be to eliminate the differentials completely and just create a new Full backup every 90 days. - 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