Re: [Bacula-users] List compile options used for binary

2012-08-16 Thread Geert Stappers
Op 20120815 om 12:36 schreef lst_ho...@kwsoft.de:
 
 Zitat von Geert Stappers geert.stapp...@vanadgroup.com:
 
  Op 20120814 om 15:10 schreef lst_ho...@kwsoft.de:
  Hello List
 
  is it possible to get the compile time options used for building the
  binary? It would be nice to have so we could build updates as close as
  possible to original packages for example on Ubuntu.
 
  Beware the next information is untested:
 
cd /usr/scr
apt-get source bacula
cd bacula*  # wildcard for version
cd debian
grep configure rules
 
  That should give you the compile time options.
 
 
  Many Thanks
 
  Please verify and provide feedback.
 
 
 Ouput of the grep command:
 
 # These are used for cross-compiling and for saving the configure script
 configure-stamp-%: extract-stamp-%
   QMAKE=/usr/bin/qmake-qt4 ./configure --config-cache \
 build-stamp-%: configure-stamp-%
 
 But the rules file is the place to look.

Yes,   debian/rules   is the file with compile time options.


Thanks for the feedback.

Cheers
Geert Stappers
-- 
debian/rules
--
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] Bacula Windows client using ntfs change log?

2012-08-16 Thread lst_hoe02
Hello List

i recently read about the NTFS change journal and its aim to support  
backups in finding files for incremental backups. Are there any plans  
to maybe include such a feature in the windows client? I suspect this  
would be really helpful on bigger sized filesystems with a lot of  
files. Information about the NTFS feature can for example found here:  
http://msdn.microsoft.com/en-us/library/aa363798.aspx

Regards

Andreas






--
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] The next tapes that Bacula will need

2012-08-16 Thread Tilman Schmidt
Am 15.08.2012 21:13, schrieb Conrad Lawes:
 At my company, we store  our backup tapes offsite with a storage provider.  
 We have 28-day retention policy for  weekly backups.  May times I not sure 
 which tapes Bacula will need for the coming weekly schedule.  As a result, I 
 oftentime have to manually  change the volume status  in the autochanger so 
 that Bacula completes the weekly backup jobs.
 Is there a way to query the bacula catalog to determine the tapes that Bacula 
 will need for the next weekly backup?  

It works the other way round. Bacula decides which tape to use upon
seeing which tapes are available.

So you should
1. configure the tape's retention parameters so that Bacula knows it may
use the tape
2. load the tape into the changer and update slots
3. let Bacula decide to use that tape.

If step 3 fails, you've done something wrong in step 1. :-)

HTH
T.

-- 
Tilman Schmidt
Phoenix Software GmbH
Bonn, Germany


--
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] The next tapes that Bacula will need

2012-08-16 Thread Alan Brown
On 16/08/12 11:16, Tilman Schmidt wrote:
 Am 15.08.2012 21:13, schrieb Conrad Lawes:
 At my company, we store  our backup tapes offsite with a storage provider.  
 We have 28-day retention policy for  weekly backups.  May times I not sure 
 which tapes Bacula will need for the coming weekly schedule.  As a result, I 
 oftentime have to manually  change the volume status  in the autochanger so 
 that Bacula completes the weekly backup jobs.
 Is there a way to query the bacula catalog to determine the tapes that 
 Bacula will need for the next weekly backup?

 It works the other way round. Bacula decides which tape to use upon
 seeing which tapes are available.

 So you should
 1. configure the tape's retention parameters so that Bacula knows it may
 use the tape
 2. load the tape into the changer and update slots
 3. let Bacula decide to use that tape.

 If step 3 fails, you've done something wrong in step 1. :-)

I believe Conrad wants to know which tapes he should be loading into the 
changer BEFORE Bacula asks for them.


The queries attached will answer that question and which tapes should be 
removed from the changer.

I also have a shell script which will move tapes for removal to the 
mailslot magazine - but that is only useful for larger changers such as 
a neo8000, which have a mailslot magazine.

#  18
:List Volumes Bacula thinks should be removed from changer
SELECT Slot, VolumeName,VolStatus AS Status,
   lpad(text(round(VolBytes/(1024.00*1024.00*1024.00),1)),7,' ') AS GB,
   date(LastWritten) AS LastWritten,
   date(Media.LastWritten + interval '1 second' * Media.VolRetention) AS 
Expiry
##,Storage.Name AS Location
   FROM Media,Pool,Storage
   WHERE Media.PoolId=Pool.PoolId
   AND ((VolStatus='Used') OR (VolStatus='Full') OR 
(VolStatus='Disabled') OR (VolStatus='Error'))
   AND Slot0 and Slot501 AND InChanger=1
   AND Media.StorageId=Storage.StorageId
   AND date(Media.LastWritten + interval '1 second' * Media.VolRetention 
* .98)-current_date  5
   ORDER BY VolumeName;

#  19
:List Volumes Bacula thinks are eligible for the changer
SELECT DISTINCT VolumeName,VolStatus as Status,
##Storage.Name AS Location,
   lpad(text(round(VolBytes/(1024.00*1024.00*1024.00),1)),7,' ') AS GB,
   date(LastWritten) AS LastWritten,
   date(Media.LastWritten + interval '1 second' * Media.VolRetention) AS 
Expiry
   FROM Media,Pool,Storage
   WHERE Media.PoolId=Pool.PoolId
#  AND Media.StorageId=Storage.StorageId
   AND InChanger=0
##Volume is ready to be used
   AND ((VolStatus='Purged') OR (VolStatus='Append') OR 
(VolStatus='Recycle')
##or volume is at (98% of cycle time minus 5 days)
   OR date(Media.LastWritten + interval '1 second' * Media.VolRetention 
* .98)-current_date = 5)
   ORDER BY VolumeName ASC ;




--
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] No space left on device.

2012-08-16 Thread Luis H. Forchesatto
Greetings.

Trying to make run an job via bconsole I got the followin logs:


16-Aug 14:27 backup-dir JobId 0: Fatal error: sql_create.c:94
sql_create.c:94 insert INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId) VALUES
('proxy.sysconf.2012-08-16_14.27.52.05','proxy.sysconf','B','F','C','2012-08-16
14:27:49',1345138069,3) failed:
unable to open database file
16-Aug 14:27 backup-dir JobId 0: Fatal error: sql_create.c:96 Create DB Job
record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId) VALUES
('proxy.sysconf.2012-08-16_14.27.52.05','proxy.sysconf','B','F','C','2012-08-16
14:27:49',1345138069,3) failed. ERR=unable to open database file
16-Aug 14:27 backup-dir JobId 0: Error: message.c:743 fopen
/var/lib/bacula/backup-dir.proxy.sysconf.2012-08-16_14.27.52.05.135319776.mail
failed: ERR=No space left on device
16-Aug 14:27 backup-dir JobId 0: Error: message.c:743 fopen
/var/lib/bacula/backup-dir.proxy.sysconf.2012-08-16_14.27.52.05.135319776.mail
failed: ERR=No space left on device
16-Aug 14:27 backup-dir JobId 0: Error: message.c:743 fopen
/var/lib/bacula/backup-dir.proxy.sysconf.2012-08-16_14.27.52.05.135319776.mail
failed: ERR=No space left on device
16-Aug 14:27 backup-dir JobId 0: Error: message.c:743 fopen
/var/lib/bacula/backup-dir.proxy.sysconf.2012-08-16_14.27.52.05.135319776.mail
failed: ERR=No space left on device

Surely there's space left on the disk. All director, storage and
file-daemon runs on Debian 5 machines at the same network. I've restarted
all bacula services and rsyslogd trying to make it work but with no
responses. I also found this logs on the log file:

16-Aug 14:20 bacula-dir JobId 0: Error: sql_update.c:263 sql_update.c:263
update UPDATE Pool SET
NumVols=790,MaxVols=0,UseOnce=0,UseCatalog=1,AcceptAnyVolume=0,VolRetention='31536000',VolUseDuration='0',MaxVolJobs=1,MaxVolFiles=0,MaxVolBytes=0,Recycle=1,AutoPrune=1,LabelType=0,LabelFormat='$Job-$Year-$Month-$Day-$Hour:$Minute:$Second',RecyclePoolId=0
WHERE PoolId=1 failed:
unable to open database file
16-Aug 14:20 bacula-dir JobId 0: Error: sql_update.c:278 sql_update.c:278
update UPDATE Storage SET AutoChanger=0 WHERE StorageId=1 failed:
unable to open database file

-- 
Att.*
***
--
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] Verify a Copy Job

2012-08-16 Thread Diego Rubert

  
  
I found the following "trick", any better?

##
From: Ulrich Leodolter ulrich.leodolter at obvsg.at
Subject: multiple
  copy pools
Newsgroups: gmane.comp.sysutils.backup.bacula.devel
Date: 2009-06-08 11:58:34 GMT (3 years, 9 weeks, 6 days, 11 hours
and 44 minutes ago)
Hello,

i would like to run disk2tape copy jobs
into different pools.

the current version (3.0.2) doesn't allow this setup (afaik)
there is only one NextPool which determines the destination
pool for copy jobs.

i tried a "trick" to overcome this limitation.

1.) define a dummy pool, no backup jobs go into this pool.

Pool {
  Name = ExtBackup
  Pool Type = Backup
  Next Pool = ExtClone
}

2.) define a copy job using the above dummy pool and
custom sqlquery to select jobid from different pool.

Job {
  Name = "CopyDiskToExtClone"
  Type = Copy
  Client = None
  Level = Full  # must be defined, but is ignored
  FileSet = None# must be defined, but is ignored
  Pool = ExtBackup
  Selection Type = SQLQuery
  Selection Pattern = "SELECT DISTINCT Job.JobId FROM Job,Pool WHERE
 Pool.Name = 'DiskBackup' AND Pool.PoolId = Job.PoolId AND ..."
  ...
}

using this method i was able top copy jobs from pool DiskBackup
to pool ExtClone, even though DiskBackup-NextPool = DiskCopy

can i expect troubles using this trick?

Regards
Ulrich
##
--

Diego P. Rubert
Coordenadoria de Informtica
Procuradoria da Repblica no Estado de Mato Grosso do Sul
Ministrio Pblico Federal


Em 15-08-2012 15:49, Diego Rubert escreveu:

  Hello!
Is it possible to verify (VolumeToCatalog) a copied job?
I've found only a reference in an old message with subject 
"[Bacula-users] is it possible to verify copy jobs?", with no response.
It seems bacula doesn't find the copied job, with or without a "Verify 
Job = MyBackupJobName" at verify job definition, resulting in a 
verification of an older (real) backup.
Regards,
   Diego

--
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] No space left on device.

2012-08-16 Thread Clark, Patricia A.

From: Luis H. Forchesatto 
luisforchesa...@gmail.commailto:luisforchesa...@gmail.com
Date: Thursday, August 16, 2012 1:42 PM
To: 
bacula-users@lists.sourceforge.netmailto:bacula-users@lists.sourceforge.net 
bacula-users@lists.sourceforge.netmailto:bacula-users@lists.sourceforge.net
Subject: [Bacula-users] No space left on device.

Greetings.

Trying to make run an job via bconsole I got the followin logs:


16-Aug 14:27 backup-dir JobId 0: Fatal error: sql_create.c:94 sql_create.c:94 
insert INSERT INTO Job 
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId) VALUES 
('proxy.sysconf.2012-08-16_14.27.52.05','proxy.sysconf','B','F','C','2012-08-16 
14:27:49',1345138069,3) failed:
unable to open database file
16-Aug 14:27 backup-dir JobId 0: Fatal error: sql_create.c:96 Create DB Job 
record INSERT INTO Job 
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId) VALUES 
('proxy.sysconf.2012-08-16_14.27.52.05','proxy.sysconf','B','F','C','2012-08-16 
14:27:49',1345138069,3) failed. ERR=unable to open database file
16-Aug 14:27 backup-dir JobId 0: Error: message.c:743 fopen 
/var/lib/bacula/backup-dir.proxy.sysconf.2012-08-16_14.27.52.05.135319776.mail 
failed: ERR=No space left on device
16-Aug 14:27 backup-dir JobId 0: Error: message.c:743 fopen 
/var/lib/bacula/backup-dir.proxy.sysconf.2012-08-16_14.27.52.05.135319776.mail 
failed: ERR=No space left on device
16-Aug 14:27 backup-dir JobId 0: Error: message.c:743 fopen 
/var/lib/bacula/backup-dir.proxy.sysconf.2012-08-16_14.27.52.05.135319776.mail 
failed: ERR=No space left on device
16-Aug 14:27 backup-dir JobId 0: Error: message.c:743 fopen 
/var/lib/bacula/backup-dir.proxy.sysconf.2012-08-16_14.27.52.05.135319776.mail 
failed: ERR=No space left on device

Surely there's space left on the disk. All director, storage and file-daemon 
runs on Debian 5 machines at the same network. I've restarted all bacula 
services and rsyslogd trying to make it work but with no responses. I also 
found this logs on the log file:

16-Aug 14:20 bacula-dir JobId 0: Error: sql_update.c:263 sql_update.c:263 
update UPDATE Pool SET 
NumVols=790,MaxVols=0,UseOnce=0,UseCatalog=1,AcceptAnyVolume=0,VolRetention='31536000',VolUseDuration='0',MaxVolJobs=1,MaxVolFiles=0,MaxVolBytes=0,Recycle=1,AutoPrune=1,LabelType=0,LabelFormat='$Job-$Year-$Month-$Day-$Hour:$Minute:$Second',RecyclePoolId=0
 WHERE PoolId=1 failed:
unable to open database file
16-Aug 14:20 bacula-dir JobId 0: Error: sql_update.c:278 sql_update.c:278 
update UPDATE Storage SET AutoChanger=0 WHERE StorageId=1 failed:
unable to open database file

--
Att.

Why is this so hard to believe?  /var is your database area and your spooling 
area along with everything else as far as logs, some temp space, etc as long as 
no other separate space has been created and mounted there.  I have just 
created both separate database space and separate spool space to control the 
amounts and to control the I/O.  Restarting services will not clear up your 
space issue.

Patti Clark
Information International Associates, Inc.
Linux Administrator and subcontractor to:
Research and Development Systems Support Oak Ridge National Laboratory




--
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] No space left on device.

2012-08-16 Thread hymie!

Luis H. Forchesatto writes:

Trying to make run an job via bconsole I got the followin logs:

failed: ERR=No space left on device
failed: ERR=No space left on device
failed: ERR=No space left on device
failed: ERR=No space left on device

Surely there's space left on the disk.

That's a question only you can answer.

--hymie!http://lactose.homelinux.net/~hymiehy...@lactose.homelinux.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