Re: [Bacula-users] Dell TL2000 Tape Library with HHLTO7 drive
This is my homelab. No one here to help but me and this mailing list The Tl2000 has a single half height drive it’s SAS Previously I ran bacula on a Debian based dell r610 I never saw this message in bacula 9 or bacula 11 Now running under Ubuntu VM hosted by truenas scale, running bacula 15 The tape connects to an hba sas card that in pci passthru mode to the vm Sent from my iPhone > On May 4, 2024, at 9:00 PM, Bill Arlofski via Bacula-users > wrote: > > On 5/4/24 6:44 PM, Neil Balchin wrote: >> Everything is working but on every tape job I get this error: >> bacularis-sd JobId 5: Warning: Alert: Volume="LR7782L7" alert=25: ERR=A >> redundant interface port on the tape drive has failed. Failure of one >> interface port in a dual-port configuration, e.g. Fibrechannel. >> Any Ideas on how to get rid of it ? Backups appear to be working just fine >> I’ve tested restore jobs several times > > How is your tape drive connected? ie: Is it actually a dual connected fibre > channel? Is one link actually down? > > The Bacula tapealert script, which calls the `tapeinfo` utility is reporting > that there is a TapeAlert[25] error. This is not a Bacula issue specifically, > just an external script/utility which the SD calls that is reporting back to > the SD what the drive itself is telling tapeinfo when queried. > > Who manages the hardware ie: Tape library, drive(s), and Linux server that > this SD runs on? Maybe they can assist? > > I'd have a look in that direction. > > Let us know what you find. It is always nice to see an issue's primary cause > reported after a solution is found. > > Good luck! :) > > > Thank you, > Bill > > -- > Bill Arlofski > w...@protonmail.com > > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Dell TL2000 Tape Library with HHLTO7 drive
On 5/4/24 6:44 PM, Neil Balchin wrote: Everything is working but on every tape job I get this error: bacularis-sd JobId 5: Warning: Alert: Volume="LR7782L7" alert=25: ERR=A redundant interface port on the tape drive has failed. Failure of one interface port in a dual-port configuration, e.g. Fibrechannel. Any Ideas on how to get rid of it ? Backups appear to be working just fine I’ve tested restore jobs several times How is your tape drive connected? ie: Is it actually a dual connected fibre channel? Is one link actually down? The Bacula tapealert script, which calls the `tapeinfo` utility is reporting that there is a TapeAlert[25] error. This is not a Bacula issue specifically, just an external script/utility which the SD calls that is reporting back to the SD what the drive itself is telling tapeinfo when queried. Who manages the hardware ie: Tape library, drive(s), and Linux server that this SD runs on? Maybe they can assist? I'd have a look in that direction. Let us know what you find. It is always nice to see an issue's primary cause reported after a solution is found. Good luck! :) Thank you, Bill -- Bill Arlofski w...@protonmail.com signature.asc Description: OpenPGP digital signature ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Dell TL2000 Tape Library with HHLTO7 drive
Everything is working but on every tape job I get this error: bacularis-sd JobId 5: Warning: Alert: Volume="LR7782L7" alert=25: ERR=A redundant interface port on the tape drive has failed. Failure of one interface port in a dual-port configuration, e.g. Fibrechannel. Any Ideas on how to get rid of it ? Backups appear to be working just fine I’ve tested restore jobs several times ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] DELL TL2000
I've wrote many times: Il giorno gio, 10/05/2012 alle 09.28 -0700, Tim Krieger ha scritto: I think you have two options... Probably the simplest and most straight forward would be to create a copy job for each pool, then a simple SQL select query for that pool to grab the latest full backup. This seems to be consistent with the rest of your configuration and probably the recommended way to go. This is a huge work. However, if all of your pools have the same storage = defined for them you can probably get away with a single SQL query that will grab the required backups. Something like the following query : SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime FROM job j WHERE j.type = 'B' AND j.level = 'F' AND (j.jobstatus = ANY (ARRAY['T', 'W'])) AND NOT (j.jobid IN (SELECT job.priorjobid FROM job WHERE (job.type = ANY (ARRAY['B', 'C'])) AND (job.jobstatus = ANY (ARRAY['T', 'W'])) AND job.priorjobid = 0)) GROUP BY j.name ORDER BY max(j.jobid); Do test the query in your DB to ensure it returns the expected list of backup jobs, if I understand the bacula DB correctly, this should give you the latest Full(highest job ID number with level F and type B) backup job for every unique job name. You may want to add some more restrictions like a list of what pools you want jobs selected from, or a list of job names to limit your selection to. Poke around in the bacula db tables and I'm sure you'll get the idea pretty quick. I have one Device defined (in bacula-sd.conf) for each Pool. Is not possibile to create a single job/pool for the copy? Il giorno ven, 18/05/2012 alle 12.33 -0400, John Drescher ha scritto: On Fri, May 18, 2012 at 12:23 PM, Gandalf Corvotempesta newsletter-...@guest.net wrote: PLEASE HELP What was the exact problem again? John -- 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] DELL TL2000
I've wrote many times: You did write several times, however the last 4 or 5 emails you sent to the list did not appear to ask any question or at least I could not find a question in your reply. Except for the comment about how much work. Il giorno gio, 10/05/2012 alle 09.28 -0700, Tim Krieger ha scritto: I think you have two options... Probably the simplest and most straight forward would be to create a copy job for each pool, then a simple SQL select query for that pool to grab the latest full backup. This seems to be consistent with the rest of your configuration and probably the recommended way to go. This is a huge work. Can't you write a script to generate the Jobs possibly using the bacua @ include file? I assume most jobs would follow some pattern that could be easily generated from a script. You could also script the running of the jobs by echoing commands to bconsole from the shell. For example to run the vs_svn-root job I can do this from the shell: echo run vs_svn-root yes | bconsole However, if all of your pools have the same storage = defined for them you can probably get away with a single SQL query that will grab the required backups. Something like the following query : SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime FROM job j WHERE j.type = 'B' AND j.level = 'F' AND (j.jobstatus = ANY (ARRAY['T', 'W'])) AND NOT (j.jobid IN (SELECT job.priorjobid FROM job WHERE (job.type = ANY (ARRAY['B', 'C'])) AND (job.jobstatus = ANY (ARRAY['T', 'W'])) AND job.priorjobid = 0)) GROUP BY j.name ORDER BY max(j.jobid); Do test the query in your DB to ensure it returns the expected list of backup jobs, if I understand the bacula DB correctly, this should give you the latest Full(highest job ID number with level F and type B) backup job for every unique job name. You may want to add some more restrictions like a list of what pools you want jobs selected from, or a list of job names to limit your selection to. Poke around in the bacula db tables and I'm sure you'll get the idea pretty quick. I have one Device defined (in bacula-sd.conf) for each Pool. Is not possibile to create a single job/pool for the copy? I do not know the answer to this. John -- 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] DELL TL2000
Il giorno mar, 22/05/2012 alle 09.02 -0400, John Drescher ha scritto: Can't you write a script to generate the Jobs possibly using the bacua @ include file? I assume most jobs would follow some pattern that could be easily generated from a script. You could also script the running of the jobs by echoing commands to bconsole from the shell. For example to run the vs_svn-root job I can do this from the shell: echo run vs_svn-root yes | bconsole Yes, I could, but I'm trying to understand if will be possibile to have a single copy job for multiple source pools. -- 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] DELL TL2000
PLEASE HELP Il giorno gio, 10/05/2012 alle 09.28 -0700, Tim Krieger ha scritto: I think you have two options... Probably the simplest and most straight forward would be to create a copy job for each pool, then a simple SQL select query for that pool to grab the latest full backup. This seems to be consistent with the rest of your configuration and probably the recommended way to go. This is a huge work. However, if all of your pools have the same storage = defined for them you can probably get away with a single SQL query that will grab the required backups. Something like the following query : SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime FROM job j WHERE j.type = 'B' AND j.level = 'F' AND (j.jobstatus = ANY (ARRAY['T', 'W'])) AND NOT (j.jobid IN (SELECT job.priorjobid FROM job WHERE (job.type = ANY (ARRAY['B', 'C'])) AND (job.jobstatus = ANY (ARRAY['T', 'W'])) AND job.priorjobid = 0)) GROUP BY j.name ORDER BY max(j.jobid); Do test the query in your DB to ensure it returns the expected list of backup jobs, if I understand the bacula DB correctly, this should give you the latest Full(highest job ID number with level F and type B) backup job for every unique job name. You may want to add some more restrictions like a list of what pools you want jobs selected from, or a list of job names to limit your selection to. Poke around in the bacula db tables and I'm sure you'll get the idea pretty quick. I have one Device defined (in bacula-sd.conf) for each Pool. -- 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 -- 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 -- 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 -- 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] DELL TL2000
On Fri, May 18, 2012 at 12:23 PM, Gandalf Corvotempesta newsletter-...@guest.net wrote: PLEASE HELP What was the exact problem again? John -- 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] DELL TL2000
Il giorno gio, 10/05/2012 alle 09.28 -0700, Tim Krieger ha scritto: I think you have two options... Probably the simplest and most straight forward would be to create a copy job for each pool, then a simple SQL select query for that pool to grab the latest full backup. This seems to be consistent with the rest of your configuration and probably the recommended way to go. This is a huge work. However, if all of your pools have the same storage = defined for them you can probably get away with a single SQL query that will grab the required backups. Something like the following query : SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime FROM job j WHERE j.type = 'B' AND j.level = 'F' AND (j.jobstatus = ANY (ARRAY['T', 'W'])) AND NOT (j.jobid IN (SELECT job.priorjobid FROM job WHERE (job.type = ANY (ARRAY['B', 'C'])) AND (job.jobstatus = ANY (ARRAY['T', 'W'])) AND job.priorjobid = 0)) GROUP BY j.name ORDER BY max(j.jobid); Do test the query in your DB to ensure it returns the expected list of backup jobs, if I understand the bacula DB correctly, this should give you the latest Full(highest job ID number with level F and type B) backup job for every unique job name. You may want to add some more restrictions like a list of what pools you want jobs selected from, or a list of job names to limit your selection to. Poke around in the bacula db tables and I'm sure you'll get the idea pretty quick. I have one Device defined (in bacula-sd.conf) for each Pool. -- 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 -- 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 -- 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] DELL TL2000
Il giorno gio, 10/05/2012 alle 09.28 -0700, Tim Krieger ha scritto: I think you have two options... Probably the simplest and most straight forward would be to create a copy job for each pool, then a simple SQL select query for that pool to grab the latest full backup. This seems to be consistent with the rest of your configuration and probably the recommended way to go. This is a huge work. However, if all of your pools have the same storage = defined for them you can probably get away with a single SQL query that will grab the required backups. Something like the following query : SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime FROM job j WHERE j.type = 'B' AND j.level = 'F' AND (j.jobstatus = ANY (ARRAY['T', 'W'])) AND NOT (j.jobid IN (SELECT job.priorjobid FROM job WHERE (job.type = ANY (ARRAY['B', 'C'])) AND (job.jobstatus = ANY (ARRAY['T', 'W'])) AND job.priorjobid = 0)) GROUP BY j.name ORDER BY max(j.jobid); Do test the query in your DB to ensure it returns the expected list of backup jobs, if I understand the bacula DB correctly, this should give you the latest Full(highest job ID number with level F and type B) backup job for every unique job name. You may want to add some more restrictions like a list of what pools you want jobs selected from, or a list of job names to limit your selection to. Poke around in the bacula db tables and I'm sure you'll get the idea pretty quick. I have one Device defined (in bacula-sd.conf) for each Pool. -- 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 -- 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] DELL TL2000
Il giorno gio, 10/05/2012 alle 09.28 -0700, Tim Krieger ha scritto: I think you have two options... Probably the simplest and most straight forward would be to create a copy job for each pool, then a simple SQL select query for that pool to grab the latest full backup. This seems to be consistent with the rest of your configuration and probably the recommended way to go. This is a huge work. However, if all of your pools have the same storage = defined for them you can probably get away with a single SQL query that will grab the required backups. Something like the following query : SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime FROM job j WHERE j.type = 'B' AND j.level = 'F' AND (j.jobstatus = ANY (ARRAY['T', 'W'])) AND NOT (j.jobid IN (SELECT job.priorjobid FROM job WHERE (job.type = ANY (ARRAY['B', 'C'])) AND (job.jobstatus = ANY (ARRAY['T', 'W'])) AND job.priorjobid = 0)) GROUP BY j.name ORDER BY max(j.jobid); Do test the query in your DB to ensure it returns the expected list of backup jobs, if I understand the bacula DB correctly, this should give you the latest Full(highest job ID number with level F and type B) backup job for every unique job name. You may want to add some more restrictions like a list of what pools you want jobs selected from, or a list of job names to limit your selection to. Poke around in the bacula db tables and I'm sure you'll get the idea pretty quick. I have one Device defined (in bacula-sd.conf) for each Pool. -- 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] DELL TL2000
Il giorno mer, 09/05/2012 alle 19.29 +0100, Martin Simmons ha scritto: That explains why the job can't find any appendable volumes in the Tape pool. Should the job be using the Tape pool or something else? Or maybe you specified a different pool when you labeled the new volume? Could you tell me exactly what I have to do? It's more then 1 month that i'm trying to make this tape working with no success. What I would like is: 1) copy the latest backup (Full plus all incrementals) of *ALL CLIENTS* to a Tape library. -- 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] DELL TL2000
Il giorno mer, 09/05/2012 alle 14.20 -0700, Tim Krieger ha scritto: I'm not certain if the TL2000 supports barcodes, or if you are using them, if so, you should be able to use the following : Label barcodes storage=TL2000-LTO-1 To view the tapes in the library : status slots storage=TL2000-LTO-1 3306 Issuing autochanger list command. No Volumes found, or no barcodes. Very stupid question, is the first time that I use a tape library: should I put a physical label with a barcode on the tape? -- 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] DELL TL2000
Very stupid question, is the first time that I use a tape library: should I put a physical label with a barcode on the tape? Yes. Your tape functionality will be greatly increased if you have a barcode reader on your archive and use barcode labels. After you do that. use the bacula update slots command to tell to reinventory the volumes then use the bacula label barcodes command to put the tapes in the Tape pool. John -- 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] DELL TL2000
Il giorno gio, 10/05/2012 alle 07.20 -0400, John Drescher ha scritto: Yes. Your tape functionality will be greatly increased if you have a barcode reader on your archive and use barcode labels. Ok, i've added a sample barcode to the tape. Now library is able to detect the tape, but Bacula does not. After you do that. use the bacula update slots command to tell to reinventory the volumes then use the bacula label barcodes command to put the tapes in the Tape pool. Connecting to Storage daemon Libreria DELL TL2000 at 172.17.0.1:9103 ... 3306 Issuing autochanger slots command. Device DELL TL2000 has 24 slots. Connecting to Storage daemon Libreria DELL TL2000 at 172.17.0.1:9103 ... 3306 Issuing autochanger list command. No Volumes found to label, or no barcodes. -- 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] DELL TL2000
On Thu, May 10, 2012 at 9:21 AM, Gandalf Corvotempesta newsletter-...@guest.net wrote: Il giorno gio, 10/05/2012 alle 07.20 -0400, John Drescher ha scritto: Yes. Your tape functionality will be greatly increased if you have a barcode reader on your archive and use barcode labels. Ok, i've added a sample barcode to the tape. Now library is able to detect the tape, but Bacula does not. After you do that. use the bacula update slots command to tell to reinventory the volumes then use the bacula label barcodes command to put the tapes in the Tape pool. Connecting to Storage daemon Libreria DELL TL2000 at 172.17.0.1:9103 ... 3306 Issuing autochanger slots command. Device DELL TL2000 has 24 slots. Connecting to Storage daemon Libreria DELL TL2000 at 172.17.0.1:9103 ... 3306 Issuing autochanger list command. No Volumes found to label, or no barcodes. I would start with the testing the autochanger part of the manual: http://www.bacula.org/en/dev-manual/main/main/Autochanger_Resource.html John -- 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] DELL TL2000
Il giorno gio, 10/05/2012 alle 09.36 -0400, John Drescher ha scritto: I would start with the testing the autochanger part of the manual: http://www.bacula.org/en/dev-manual/main/main/Autochanger_Resource.html I've read that many times with no succes, but now i've made some little progress. Copy to tape seems to work. Now the hard part: how can I copy the latest complete backup from every client to tape? Should I create a copy job for each client or can I create a single job? Any help? -- 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] DELL TL2000
http://www.bacula.org/en/dev-manual/main/main/Autochanger_Resource.html I've read that many times with no succes, but now i've made some little progress. We can help if you post the terminal output of your testing with mtx. John -- 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] DELL TL2000
Hello, 2012/5/10 Gandalf Corvotempesta newsletter-...@guest.net Now the hard part: how can I copy the latest complete backup from every client to tape? Should I create a copy job for each client or can I create a single job? Any help? It depends how your disk polls are arranged (sorry I don't have your very first email). If you have only one pool, then it could be achieved by only one job with a proper selection criteria and pattern (especially a dedicated sql statement). If you have more pools then you have to prepare a number of copy jobs. I hope it helps. 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] DELL TL2000
Il giorno gio, 10/05/2012 alle 16.37 +0200, Radosław Korzeniewski ha scritto: It depends how your disk polls are arranged (sorry I don't have your very first email). If you have only one pool, then it could be achieved by only one job with a proper selection criteria and pattern (especially a dedicated sql statement). If you have more pools then you have to prepare a number of copy jobs. I have one pool for each backup level for each client. For example: 50 clients, 3 backup levels (F, D, I) = 150 Pools - We have to create 150 Copy Job? - How can I select the most recent backup-set for a client ? - Should I create a 150 Tape storage resources? I'm really a newbie on Bacula, a working configuration is accepted. :) -- 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] DELL TL2000
I think you have two options... Probably the simplest and most straight forward would be to create a copy job for each pool, then a simple SQL select query for that pool to grab the latest full backup. This seems to be consistent with the rest of your configuration and probably the recommended way to go. However, if all of your pools have the same storage = defined for them you can probably get away with a single SQL query that will grab the required backups. Something like the following query : SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime FROM job j WHERE j.type = 'B' AND j.level = 'F' AND (j.jobstatus = ANY (ARRAY['T', 'W'])) AND NOT (j.jobid IN (SELECT job.priorjobid FROM job WHERE (job.type = ANY (ARRAY['B', 'C'])) AND (job.jobstatus = ANY (ARRAY['T', 'W'])) AND job.priorjobid = 0)) GROUP BY j.name ORDER BY max(j.jobid); Do test the query in your DB to ensure it returns the expected list of backup jobs, if I understand the bacula DB correctly, this should give you the latest Full(highest job ID number with level F and type B) backup job for every unique job name. You may want to add some more restrictions like a list of what pools you want jobs selected from, or a list of job names to limit your selection to. Poke around in the bacula db tables and I'm sure you'll get the idea pretty quick. -Original Message- From: Gandalf Corvotempesta [mailto:newsletter-...@guest.net] Sent: Thursday, May 10, 2012 8:22 AM To: Radosław Korzeniewski Cc: bacula-users Subject: Re: [Bacula-users] DELL TL2000 Il giorno gio, 10/05/2012 alle 16.37 +0200, Radosław Korzeniewski ha scritto: It depends how your disk polls are arranged (sorry I don't have your very first email). If you have only one pool, then it could be achieved by only one job with a proper selection criteria and pattern (especially a dedicated sql statement). If you have more pools then you have to prepare a number of copy jobs. I have one pool for each backup level for each client. For example: 50 clients, 3 backup levels (F, D, I) = 150 Pools - We have to create 150 Copy Job? - How can I select the most recent backup-set for a client ? - Should I create a 150 Tape storage resources? I'm really a newbie on Bacula, a working configuration is accepted. :) -- 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 This electronic mail transmission and any accompanying attachments contain confidential information intended only for the use of the individual or entity named above. Any dissemination, distribution, copying or action taken in reliance on the contents of this communication by anyone other than the intended recipient is strictly prohibited. If you have received this communication in error please immediately delete the e-mail and either notify the sender at the above e-mail address or by telephone at +1 250.386.5323. -- 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] DELL TL2000
Il giorno mar, 08/05/2012 alle 13.18 +0200, Jürgen Echter ha scritto: Hi Gandalf, what tells you 'messages' about this 'waiting for an appendable volume' issue? 08-May 12:18 b01-sd JobId 14449: Ready to read from volume 20120401_0035-myclient-full on device myclient-FileStorage (/var/bacula/backups/clients/myclient). 08-May 12:18 b01-sd JobId 14449: Job TapeCopyFull.2012-05-08_12.18.51_13 is waiting. Cannot find any appendable volumes. Please use the label command to create a new Volume for: Storage: TL2000-LTO4-1 (/dev/nst0) Pool: Tape Media type: LTO4 08-May 13:18 b01-sd JobId 14449: Job TapeCopyFull.2012-05-08_12.18.51_13 is waiting. Cannot find any appendable volumes. Please use the label command to create a new Volume for: Storage: TL2000-LTO4-1 (/dev/nst0) Pool: Tape Media type: LTO4 I've tried to run label command and then mount to mount the tape, but bacula is still waiting for an appendable volume are the tapes labeled already? I don't think they are labeled are you using automatic labeling? No, i don't. How can I enable automatic labeling and how can I ensure that these tapes are not already labeled? -- 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] DELL TL2000
On Wed, 09 May 2012 10:29:28 +0200, Gandalf Corvotempesta said: Il giorno mar, 08/05/2012 alle 13.18 +0200, Jürgen Echter ha scritto: Hi Gandalf, what tells you 'messages' about this 'waiting for an appendable volume' issue? 08-May 12:18 b01-sd JobId 14449: Ready to read from volume 20120401_0035-myclient-full on device myclient-FileStorage (/var/bacula/backups/clients/myclient). 08-May 12:18 b01-sd JobId 14449: Job TapeCopyFull.2012-05-08_12.18.51_13 is waiting. Cannot find any appendable volumes. Please use the label command to create a new Volume for: Storage: TL2000-LTO4-1 (/dev/nst0) Pool: Tape Media type: LTO4 08-May 13:18 b01-sd JobId 14449: Job TapeCopyFull.2012-05-08_12.18.51_13 is waiting. Cannot find any appendable volumes. Please use the label command to create a new Volume for: Storage: TL2000-LTO4-1 (/dev/nst0) Pool: Tape Media type: LTO4 I've tried to run label command and then mount to mount the tape, but bacula is still waiting for an appendable volume What is the output of list volumes pool=Tape after labeling? are the tapes labeled already? I don't think they are labeled are you using automatic labeling? No, i don't. How can I enable automatic labeling and how can I ensure that these tapes are not already labeled? The mount command will tell you the label (or fail if not labeled). __Martin -- 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] DELL TL2000
Il giorno mer, 09/05/2012 alle 10.58 +0100, Martin Simmons ha scritto: What is the output of list volumes pool=Tape after labeling? *list volumes pool=Tape No results to list. But i don't know how to label properly. The mount command will tell you the label (or fail if not labeled). 3001 OK mount requested. Device=TL2000-LTO4-1 (/dev/nst0) -- 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] DELL TL2000
On Wed, 09 May 2012 14:31:29 +0200, Gandalf Corvotempesta said: Il giorno mer, 09/05/2012 alle 10.58 +0100, Martin Simmons ha scritto: What is the output of list volumes pool=Tape after labeling? *list volumes pool=Tape No results to list. That explains why the job can't find any appendable volumes in the Tape pool. Should the job be using the Tape pool or something else? Or maybe you specified a different pool when you labeled the new volume? But i don't know how to label properly. The mount command will tell you the label (or fail if not labeled). 3001 OK mount requested. Device=TL2000-LTO4-1 (/dev/nst0) Hmm, looks like it doesn't print the tape if the device is blocked. You could try unmount and then mount. __Martin -- 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] DELL TL2000
I'm not certain if the TL2000 supports barcodes, or if you are using them, if so, you should be able to use the following : Label barcodes storage=TL2000-LTO-1 To view the tapes in the library : status slots storage=TL2000-LTO-1 -Original Message- From: Gandalf Corvotempesta [mailto:newsletter-...@guest.net] Sent: Wednesday, May 09, 2012 5:31 AM To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] DELL TL2000 Il giorno mer, 09/05/2012 alle 10.58 +0100, Martin Simmons ha scritto: What is the output of list volumes pool=Tape after labeling? *list volumes pool=Tape No results to list. But i don't know how to label properly. The mount command will tell you the label (or fail if not labeled). 3001 OK mount requested. Device=TL2000-LTO4-1 (/dev/nst0) -- 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 This electronic mail transmission and any accompanying attachments contain confidential information intended only for the use of the individual or entity named above. Any dissemination, distribution, copying or action taken in reliance on the contents of this communication by anyone other than the intended recipient is strictly prohibited. If you have received this communication in error please immediately delete the e-mail and either notify the sender at the above e-mail address or by telephone at +1 250.386.5323. -- 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] DELL TL2000
Il giorno lun, 07/05/2012 alle 12.45 -0700, Tim Krieger ha scritto:
Hi Gandalf, while I do not have exactly the same requirements, possibly the
information below will be helpful.
You do not mention it but I am assuming you are doing backups to disk.
Yes, actually i'm doing backup to disks.
You also do not mention using the tape device for any other backups so I
will assume you do not(If you do, there is some trickery you may need to
employ).
Tape device is not used.
It sounds like you need to modify your Full Pool for each client, add the
Next Pool resource and point it at the Tape drive pool(lets call it Tape).
Already done for a test client, but Bacula is not able
to connect to the tape.
This is my test client pool:
Pool {
Name = myclient-FullPool
Label Format = ${Year}${Month:p/2/0/r}${Day:p/2/0/r}_
${Hour:p/2/0/r}${Minute:p/2/0/r}-myclient-full
Pool Type = Backup
Recycle = no
AutoPrune = yes
Volume Retention = 90 days
Maximum Volume Jobs = 1
Action On Purge = Truncate
Next Pool = Tape # Necessario per fare la copia su nastro
}
The following copy job is what works for me :
Job {
Name = Offsite Backup
Client = backup-fd
JobDefs = DefaultJob
Type = Copy
FileSet = Full Set
Priority = 11
SpoolData = No
Messages = ErrorOnly
Schedule = Offsite Schedule
Pool = File
Selection Type = SQL Query
Selection Pattern = select * from offsite_backups
}
This is mine:
Job {
Name = TapeCopyFull
Type = Copy
Pool = myclient-FullPool
Level = Full
Schedule = WeeklyTapeFull
Client = None
Fileset = None
Selection Type = SQLQuery
Selection Pattern = SELECT * FROM Job WHERE (EndTime BETWEEN NOW() -
INTERVAL 40 DAY AND NOW()) AND Level = 'F' AND (JobStatus = 'e' OR
JobStatus = 'T') AND Name LIKE '%myclient%' GROUP BY Name;
Maximum Concurrent Jobs = 1
Allow Duplicate Jobs = Yes
Messages = Standard
Storage = File
Write Bootstrap = /var/lib/bacula/offsite-copy-%c.bsr
}
what should I use as Client option ?
You may run into problems if you have multiple source pools. I am selecting
particular backups by name, you could drop this and choose all backups if you
wish.
The query should return the highest ID number for each job name ( type : F
(Full), status : T(OK) or W(warnings only, no errors)
I have tons of Full Pools that need to by copied to tape.
Should I edit each pool and add the Next Pool option or should I use a
single configuration that will copy all full pools in a single run?
--
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] DELL TL2000
Il giorno mar, 08/05/2012 alle 10.57 +0200, Gandalf Corvotempesta ha scritto: I have tons of Full Pools that need to by copied to tape. Should I edit each pool and add the Next Pool option or should I use a single configuration that will copy all full pools in a single run? I have some updates. btape is working properly, but bacula is locked in: Running Jobs: Console connected at 08-May-12 12:18 JobId Level Name Status == 14449 FullTapeCopyFull.2012-05-08_12.18.51_13 is waiting for an appendable Volume 14450 Increme myclient-job.2012-05-08_12.18.51_14 is running -- 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] DELL TL2000
Am 08.05.2012 12:46, schrieb Gandalf Corvotempesta: Il giorno mar, 08/05/2012 alle 10.57 +0200, Gandalf Corvotempesta ha scritto: I have tons of Full Pools that need to by copied to tape. Should I edit each pool and add the Next Pool option or should I use a single configuration that will copy all full pools in a single run? I have some updates. "btape" is working properly, but bacula is locked in: Running Jobs: Console connected at 08-May-12 12:18 JobId Level Name Status == 14449 FullTapeCopyFull.2012-05-08_12.18.51_13 is waiting for an appendable Volume 14450 Increme myclient-job.2012-05-08_12.18.51_14 is running -- 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 Hi Gandalf, what tells you 'messages' about this 'waiting for an appendable volume' issue? are the tapes labeled already? are you using automatic labeling? cheers. Juergen -- Mit freundlichen Grssen Jrgen Echter ECHTER Kchen Elektro GmbH Augsburger Str. 49 86529 Schrobenhausen Tel: 08252 / 8976 - 0 Fax: 08252 / 8976 - 10 e-mail: i...@echter-kuechen-elektro.de web: www.echter-kuechen-elektro.de Reg.-Gericht: Ingolstadt Nr. HR B 101907 Ust.-Id. Nr.: DE234419866 Steuernummer: 124/125/51166 Geschftsfhrer: Thomas Echter -- 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] DELL TL2000
Hey Gandalf, The client should be the file daemon that has your tape drive attached I would think, that is what mine is defined as. I have not seen the message waiting for volume, I would think bacula should have emailed a message to the operator for intervention tho, possibly it will contain clues. I suspect Jurgen is on the correct track, bacula does not seem to be able to find an appendable volume for some reason -Original Message- From: Gandalf Corvotempesta [mailto:newsletter-...@guest.net] Sent: Tuesday, May 08, 2012 3:46 AM To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] DELL TL2000 Il giorno mar, 08/05/2012 alle 10.57 +0200, Gandalf Corvotempesta ha scritto: I have tons of Full Pools that need to by copied to tape. Should I edit each pool and add the Next Pool option or should I use a single configuration that will copy all full pools in a single run? I have some updates. btape is working properly, but bacula is locked in: Running Jobs: Console connected at 08-May-12 12:18 JobId Level Name Status == 14449 FullTapeCopyFull.2012-05-08_12.18.51_13 is waiting for an appendable Volume 14450 Increme myclient-job.2012-05-08_12.18.51_14 is running -- 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 This electronic mail transmission and any accompanying attachments contain confidential information intended only for the use of the individual or entity named above. Any dissemination, distribution, copying or action taken in reliance on the contents of this communication by anyone other than the intended recipient is strictly prohibited. If you have received this communication in error please immediately delete the e-mail and either notify the sender at the above e-mail address or by telephone at +1 250.386.5323. -- 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] DELL TL2000
No help about this? No one is using this library? Il giorno gio, 03/05/2012 alle 15.01 +0200, Gandalf Corvotempesta ha scritto: Hi all, I have a bacula server configured to use one pool for every client host and for every backup level. In this way, a single client has 3 pool: Full, Incr, Diff What i would like to do is to copy the latest full pool for each client to a tape library. I've tried to configurare a Copy job with no success. Do you have some docs or example that will allow me to copy more then one pool to a tape library at once? Thank you. -- 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 -- 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] DELL TL2000
No help about this? No one is using this library? I do not use that library however you problem does not appear to have anything at all to do with your choice of hardware. I never ever use Copy jobs so I can not help with that either however I do have a 2 drive autochanger and I do use that with jobs going to 2 different pools at the same time. Have you been able to configure bacula to run regular jobs concurrently? John -- 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] DELL TL2000
Hi Gandalf, while I do not have exactly the same requirements, possibly the
information below will be helpful.
You do not mention it but I am assuming you are doing backups to disk. You
also do not mention using the tape device for any other backups so I will
assume you do not(If you do, there is some trickery you may need to employ).
It sounds like you need to modify your Full Pool for each client, add the Next
Pool resource and point it at the Tape drive pool(lets call it Tape).
The following copy job is what works for me :
Job {
Name = Offsite Backup
Client = backup-fd
JobDefs = DefaultJob
Type = Copy
FileSet = Full Set
Priority = 11
SpoolData = No
Messages = ErrorOnly
Schedule = Offsite Schedule
Pool = File
Selection Type = SQL Query
Selection Pattern = select * from offsite_backups
}
NOTES : FileSet can be anything, it's required for a job definition but totally
ignored by copy
Pool can be anything BUT I found that in the pool definition Storage
must be the same as the source for the copy jobs and Next Pool must point to
where you want the copy jobs to go
My SQL Query in the job definition is overly simple because I use a stored
query in the DB (query was too long for bacula)
Here is a simplified version of my query (postgres, someone with more DB
experience will have to help if you need to change this):
SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime
FROM job j
JOIN pool p ON j.poolid = p.poolid
WHERE p.name = 'File'::text AND (j.name = ANY (ARRAY['server 1 Backup'::text,
'Server 2 Backup'::text, 'Crazy Server Backup'::text ])) AND j.type =
'B'::bpchar AND j.level = 'F'::bpchar AND (j.jobstatus = ANY
(ARRAY['T'::bpchar, 'W'::bpchar]))
AND NOT (j.jobid IN ( SELECT job.priorjobid
FROM job
WHERE (job.type = ANY (ARRAY['B'::bpchar, 'C'::bpchar])) AND (job.jobstatus =
ANY (ARRAY['T'::bpchar, 'W'::bpchar])) AND job.priorjobid = 0))
GROUP BY j.name
ORDER BY max(j.jobid);
You may run into problems if you have multiple source pools. I am selecting
particular backups by name, you could drop this and choose all backups if you
wish.
The query should return the highest ID number for each job name ( type : F
(Full), status : T(OK) or W(warnings only, no errors)
-Original Message-
From: Gandalf Corvotempesta [mailto:newsletter-...@guest.net]
Sent: Thursday, May 03, 2012 6:02 AM
To: bacula-users@lists.sourceforge.net
Subject: [Bacula-users] DELL TL2000
Hi all,
I have a bacula server configured to use
one pool for every client host and for every
backup level.
In this way, a single client has 3 pool: Full, Incr, Diff
What i would like to do is to copy the latest full pool for
each client to a tape library.
I've tried to configurare a Copy job with no success.
Do you have some docs or example that will allow me to
copy more then one pool to a tape library at once?
Thank you.
--
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
This electronic mail transmission and any accompanying attachments contain
confidential information intended only for the use of the individual or entity
named above. Any dissemination, distribution, copying or action taken in
reliance on the contents of this communication by anyone other than the
intended recipient is strictly prohibited. If you have received this
communication in error please immediately delete the e-mail and either notify
the sender at the above e-mail address or by telephone at +1 250.386.5323.
--
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
[Bacula-users] DELL TL2000
Hi all, I have a bacula server configured to use one pool for every client host and for every backup level. In this way, a single client has 3 pool: Full, Incr, Diff What i would like to do is to copy the latest full pool for each client to a tape library. I've tried to configurare a Copy job with no success. Do you have some docs or example that will allow me to copy more then one pool to a tape library at once? Thank you. -- 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
[Bacula-users] Dell TL2000 (IBM Ultrium HH LTO-5) and Solaris
Dear Bacula Community, I am seeking help from anyone who has a TL2000/4000 or other autochanger that utilized the IBM Ultrium HH LTO-5 drives or similar on a Solaris 10 system. I am seeking correct st.conf definition for this drive. I have an exisiting definition for an LTO-3 drive and the system is able to configure and use the LTO-5 drives, but the speed is horrendous. Yours, Shon -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Dell TL2000 library control
Hi all,
I'm currently trying to setup a backup system with bacula and a Dell
TL2000 LTO4 library.
My Bacula server is a Debian Lenny install with 2.6.26-2-amd64 Debian
stock kernel. I backported Bacula 3.0.1 to Lenny from the Experimental
Debian repository.
The library is correctly recognized :
burp:/etc/bacula# dmesg|grep 6:0 | cut -c 16-
scsi 6:0:0:0: Sequential-Access IBM ULT3580-HH489B1 PQ: 0 ANSI: 3
scsi 6:0:0:1: Medium ChangerIBM 3573-TL7.40 PQ: 0 ANSI: 5
scsi 6:0:1:0: Sequential-Access IBM ULT3580-HH489B1 PQ: 0 ANSI: 3
scsi 6:0:1:1: Medium ChangerIBM 3573-TL7.40 PQ: 0 ANSI: 5
st 6:0:0:0: Attached scsi tape st0
st 6:0:0:0: st0: try direct i/o: yes (alignment 4 B)
st 6:0:1:0: Attached scsi tape st1
st 6:0:1:0: st1: try direct i/o: yes (alignment 4 B)
ch 6:0:0:1: Attached scsi changer ch0
ch 6:0:1:1: Attached scsi changer ch1
st 6:0:0:0: Attached scsi generic sg3 type 1
ch 6:0:0:1: Attached scsi generic sg4 type 8
st 6:0:1:0: Attached scsi generic sg5 type 1
ch 6:0:1:1: Attached scsi generic sg6 type 8
The mtx script works well :
burp:/etc/bacula# /etc/bacula/scripts/mtx-changer /dev/sg4 list
0 /dev/nst0 0
1:BK0001L4
2:BK0004L4
5:BK0002L4
9:BK0003L4
12:CL0001L4
I setted-up bacula-sd as bellow :
Autochanger {
Name = lib-tl2000-1
Device = tape-burp-LTO4-1
Changer Command = /etc/bacula/scripts/mtx-changer %c %o %S %a %d
Changer Device = /dev/sg4
}
Device {
Name = tape-burp-LTO4-1
Drive Index = 0
Media Type = LTO4
Archive Device = /dev/nst0
AutomaticMount = yes;
AlwaysOpen = yes;
RemovableMedia = yes;
RandomAccess = no;
AutoChanger = yes
Alert Command = sh -c '/usr/sbin/smartctl -H -l error %c'
}
Autochanger {
Name = lib-tl2000-2
Device = tape-burp-LTO4-2
Changer Command = /etc/bacula/scripts/mtx-changer %c %o %S %a %d
Changer Device = /dev/sg6
}
Device {
Name = tape-burp-LTO4-2
Drive Index = 0
Media Type = LTO4
Archive Device = /dev/nst1
AutomaticMount = yes;
AlwaysOpen = yes;
RemovableMedia = yes;
RandomAccess = no;
AutoChanger = yes
Alert Command = sh -c '/usr/sbin/smartctl -H -l error %c'
}
but I can't handle the lib from bconsole :
*update slots
Automatically selected Catalog: MyCatalog
Using Catalog MyCatalog
The defined Storage resources are:
1: filer-burp-storage
2: tape-burp-lto4-1-storage
3: tape-burp-lto4-2-storage
Select Storage resource (1-3): 2
Connecting to Storage daemon tape-burp-lto4-1-storage at
burp.eve:9103 ...
3306 Issuing autochanger slots command.
Device tape-burp-LTO4-1 has 0 slots.
No slots in changer to scan.
So What's wrong in my config ??? This worked with bacula 2.4 !
The final idea is to handle backups with one drive, and duplicate tapes
with the other drive. If possible, I would do that in only one job, but
I don't know how to do that... I guess it is possible with bacula 3 ?
Note that I can configure the TL2000 to handle 1 or 2 logical
libraries :
- on 1 logical library mode, the library reports 2 drives an 1
autochanger lib,
- on 1 logical library mode, the library reports 2 autochangers, each
has one drive
I wondered the 2 logical lib is better suited for what I intend to do,
but maybe am I wrong ?
Thanks,
--
Rico
smime.p7s
Description: S/MIME cryptographic signature
--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Dell TL2000 library control
Le jeudi 11 juin 2009 à 11:15 +0200, Eric Belhomme a écrit : *update slots Automatically selected Catalog: MyCatalog Using Catalog MyCatalog The defined Storage resources are: 1: filer-burp-storage 2: tape-burp-lto4-1-storage 3: tape-burp-lto4-2-storage Select Storage resource (1-3): 2 Connecting to Storage daemon tape-burp-lto4-1-storage at burp.eve:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4-1 has 0 slots. No slots in changer to scan. So What's wrong in my config ??? This worked with bacula 2.4 ! I missed to precise : it seems that mtx-change script is not executed by sd daemon ! I added some quick'n dirty echoes in it to check some variables on a log file, and the file is even not created ! I really don't know why ? file perms seems ok : burp:/etc/bacula# ll scripts/mtx-changer* -rwxr-xr-x 1 root root 5269 jun 11 09:28 scripts/mtx-changer -rw-r--r-- 1 root root 54 jun 11 07:46 scripts/mtx-changer.conf Thanks, -- Eric Belhomme - EVE SA - www.eve-team.com 2bis, voie la cardon, 91120 PALAISEAU, FRANCE Tel: +33 1 64 53 27 30,Fax: +33 1 64 53 27 40 smime.p7s Description: S/MIME cryptographic signature -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Dell TL2000 library control
Hi, 11.06.2009 12:32, Eric Belhomme wrote: Le jeudi 11 juin 2009 à 11:15 +0200, Eric Belhomme a écrit : *update slots Automatically selected Catalog: MyCatalog Using Catalog MyCatalog The defined Storage resources are: 1: filer-burp-storage 2: tape-burp-lto4-1-storage 3: tape-burp-lto4-2-storage Select Storage resource (1-3): 2 Connecting to Storage daemon tape-burp-lto4-1-storage at burp.eve:9103 ... 3306 Issuing autochanger slots command. Device tape-burp-LTO4-1 has 0 slots. No slots in changer to scan. So What's wrong in my config ??? This worked with bacula 2.4 ! Which user does the SD run as? I missed to precise : it seems that mtx-change script is not executed by sd daemon ! I added some quick'n dirty echoes in it to check some variables on a log file, and the file is even not created ! I really don't know why ? file perms seems ok : burp:/etc/bacula# ll scripts/mtx-changer* -rwxr-xr-x 1 root root 5269 jun 11 09:28 scripts/mtx-changer -rw-r--r-- 1 root root 54 jun 11 07:46 scripts/mtx-changer.conf Also do a 'ls -l /dev/nst0 /dev/sg4' to see if the user the SD runs as has permissions on those devices. (udev rules - a fun thing :-) Arno Thanks, -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück www.its-lehmann.de -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
