Re: [Bacula-users] Create two identical tapes, with one tape drive.
Le 15 juin 2012 à 00:36, Yougo a écrit : Hi A second demand to the list this evening. ;-) I have an external script that select jobids in my db and then select them for copying via a copy job into a tape, once the selection is done it sends the sequentially to bconsole. This create an external tape archive of the enterprise main data I am supposed to keep the file records from theses tapes as long as possible, at least for some particular jobs. Also, to be fully redundant i want to create a second copy of this archive, the first one would be stored locally in order to recover some particular files, the second one is externalized just in case the first one is destroyed in a disaster. I have only one LTO3 drive so I cant copy directly from one tape to another. To keep the catalog as light as possible I don't want to create a second copy of the file records inside bacula but in want to be able to restore from one tape as well as from the other one. This last condition infers that both tape should have the same label. What methods are possible to make it ? I have minded in using dd,bcopy… But I cant say which one is the more appropriated and safe. Also I tried to write to a kind of spool file device and then to dd it to my two tapes. I saw that bcopy is only writing to a volume that got a different name, does someone succeeded in cloning a file into a tape Thanks for your answers Hugo Hello ? No one already did that ? I have tried bcopy but the problem is that I should use it from one tape to another with a different label. So I lose the capacity to restore easily from that tape because I don't have the file/job records associated to that tape in database. Hugo -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] PKI decryption problem: missing private key
Hello Ricky, 2012/6/22 Ricky Tong rt...@research.baycrest.org ** Hi Radoslaw, How is that relevant? (Maybe I am missing something here). Could you, please answer the question: What are the names of client A and B stored in bacula-fd.conf file? If no, I cant help you. Sorry. best regards -- Radosław Korzeniewski rados...@korzeniewski.net -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Query what clients haven't been backed up within a certain time period
Op 20120622 om 16:52 schreef Dan Langille: On 2012-06-21 19:54, Mike Hobbs wrote: Hello, I was wondering if anyone has written a bacula query that you can run to find out what clients haven't been backed up within a certain time period? If so could you share? I'm not an SQL guy which is why I am asking. This query provides a list of all clients who have not had a backup finish within the past week: SELECT C.name FROM client C WHERE NOT EXISTS (SELECT jobid FROM job J WHERE J.endtime (now() - interval '1 week') AND J.clientid = C.clientid) ORDER BY name This was written for PostgreSQL. I hope it runs on MySQL with minor modifications. Yes, after minor modifications it does run on MySQL SELECT C.name FROM Client C WHERE NOT EXISTS ( SELECT jobid FROM Job J WHERE J.endtime date_sub( now(),INTERVAL 1 week ) AND J.clientid = C.clientid ) ORDER BY name Cheers Geert Stappers -- http://www.vanadplatform.com/ -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Scratch Pool
Hi Dan,
I believe that solved my problem, and explains why the new volume (which only
got created after making changes and running reload) made it into the
bryanslack-scratch pool. But the other old volumes still around from before
the changes didn't seem to want to go into the scratch pool like I wanted.
Also I put some lines to kick off a remove scratch pools admin-job after my
job. After a migration the source volumes go to scratch, then after that, they
get deleted from the catalog and from the disk. I'm not sure if after or
before is right, in fact I am not sure if I'm using the scratch pools correctly
in the first place. But now when I run list volume I don't see anything in
the virtual pool anymore, which was what I was hoping for. They go to scratch,
and then the stuff below removes them.
Command = sh -c \/bin/echo run job=bryanslack-remove yes | bconsole -n\
Then that job (bryanslack-remove) basically does nothing at all except it runs
this at the end,
Command = /etc/bacula/scripts/removeScratchPools.sh %c
And that command is converted from a perl script I found somewhere.
Thanks Dan and Phil for your time.
Bryan
On Jun 22, 2012, at 9:56 AM, Dan Langille wrote:
On 2012-06-19 19:57, Bryan Harris wrote:
Hello all,
I'm trying to place my volumes into a scratch pool of a custom name
using these lines. However, the volumes do not move into the scratch
pool after usage. Instead, they remain in the pool called
bryanslack-virtuals. When I run list volume I get a volume in my
scratch pool. The listed volume says Recycle for VolStatus.
I guess my question is, how can I move the volumes used by a job
right after that job runs?
Pool {
Name = bryanslack-virtuals
Storage = bryanslack-virtuals
Pool Type = Backup
Use Volume Once = yes
Recycle = yes
Recycle Oldest Volume = yes
Recycle Current Volume = yes
Purge Oldest Volume = yes
Auto Prune = yes
Maximum Volumes = 100
Volume Retention = 1 minute
Maximum Volume Jobs = 1
Label Format =
${Client}_${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}_${Hour:p/2/0/r}:${Minute:p/2/0/r}-${Pool}-${JobId}
Next Pool = bryanslack
Action On Purge = Truncate
Scratch Pool = bryanslack-scratch
Recycle Pool = bryanslack-scratch
}
Pool {
Name = bryanslack-scratch
Pool Type = Backup
}
After making these changes, did you run update in bconsole? You need to
update the volume definitions from the pool definition.
That is, you need to tell the existing volumes that their attributes have
changes.
--
Dan Langille - http://langille.org/
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
