Re: [Bacula-users] Dell TL2000 Tape Library with HHLTO7 drive

2024-05-04 Thread Neil Balchin
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

2024-05-04 Thread Bill Arlofski via Bacula-users

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


Re: [Bacula-users] DELL TL2000

2012-05-22 Thread Gandalf Corvotempesta
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

2012-05-22 Thread John Drescher
> 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

2012-05-22 Thread Gandalf Corvotempesta
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
>  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

2012-05-18 Thread John Drescher
On Fri, May 18, 2012 at 12:23 PM, Gandalf Corvotempesta
 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

2012-05-18 Thread Gandalf Corvotempesta
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

2012-05-17 Thread Gandalf Corvotempesta
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

2012-05-15 Thread Gandalf Corvotempesta
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

2012-05-14 Thread Gandalf Corvotempesta
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

2012-05-10 Thread Tim Krieger
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

2012-05-10 Thread Gandalf Corvotempesta
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

2012-05-10 Thread Radosław Korzeniewski
Hello,

2012/5/10 Gandalf Corvotempesta 

>
> 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

2012-05-10 Thread John Drescher
>> 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

2012-05-10 Thread Gandalf Corvotempesta
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

2012-05-10 Thread John Drescher
On Thu, May 10, 2012 at 9:21 AM, Gandalf Corvotempesta
 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

2012-05-10 Thread Gandalf Corvotempesta
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

2012-05-10 Thread John Drescher
> 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

2012-05-10 Thread Gandalf Corvotempesta
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

2012-05-10 Thread Gandalf Corvotempesta
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

2012-05-09 Thread Tim Krieger
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

2012-05-09 Thread Martin Simmons
> 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

2012-05-09 Thread Gandalf Corvotempesta
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

2012-05-09 Thread Martin Simmons
> 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

2012-05-09 Thread Gandalf Corvotempesta
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

2012-05-08 Thread Tim Krieger
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

2012-05-08 Thread Jürgen Echter

  
  
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 Grüssen
  

  

   
Jürgen Echter

  

  
  

  


  

  ECHTER Küchen & 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

  Geschäftsführer: 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

2012-05-08 Thread 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


Re: [Bacula-users] DELL TL2000

2012-05-08 Thread Gandalf Corvotempesta
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

2012-05-07 Thread Tim Krieger
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


Re: [Bacula-users] DELL TL2000

2012-05-07 Thread John Drescher
> 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

2012-05-07 Thread Gandalf Corvotempesta
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 library control

2009-06-11 Thread Arno Lehmann
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


Re: [Bacula-users] Dell TL2000 library control

2009-06-11 Thread Eric Belhomme
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