Re: [Bacula-users] Cannot find any appendable volumes - But auto labeling is enabled? [SOLVED]

2011-01-05 Thread Mister IT Guru
On 04/01/2011 14:14, Kleber Leal wrote:
 What pool your jobs are writing?
 You enabled autolabel on File pool. Your jobs are trying write on it?

 Verify your config files. By default (no config), the job get JobDefs 
 definition and write on Default pool. Your default pool has not 
 autolabeling enabled. Try change it to File pool overriding config or 
 editing your JobDefs.conf.

That was the problem! I did have everything in my configuration as I 
expected it to be - except i forgot autolabelling on the default pool. 
I've been able to fully test all I wanted to, I've got my default job, 
and I've run jobs across all my clients, I've tried to overload it, it 
just keeps on queuing the jobs, and running them very nice! Thank you 
bacula-list and Kleber Leal :)

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Mister IT Guru
I've run lots of test jobs, and I have a lot of backup data, that I 
don't really need, around 2TB or so! (we have a few servers!) I would 
like to know if it's possible to remove all of those jobs out of the 
bacula database. Personally, I would have cut this configure out, and 
drop it on a previous backup I have, but then I don't learn about how 
bacula works.

My main fear, is that I rsync my disk backend offsite, and I've 
currently suspended that because of all these test jobs that I'm 
running. Also, I've reset the bacula-dir and sd, during backups, and 
I've a feeling that some of them are not viable.

I guess what I'm asking is, is it possible to wipe the slate clean, but 
keep my working configuration from within bacula?

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Graham Keeling
On Wed, Jan 05, 2011 at 09:38:14AM +, Mister IT Guru wrote:
 I've run lots of test jobs, and I have a lot of backup data, that I 
 don't really need, around 2TB or so! (we have a few servers!) I would 
 like to know if it's possible to remove all of those jobs out of the 
 bacula database. Personally, I would have cut this configure out, and 
 drop it on a previous backup I have, but then I don't learn about how 
 bacula works.
 
 My main fear, is that I rsync my disk backend offsite, and I've 
 currently suspended that because of all these test jobs that I'm 
 running. Also, I've reset the bacula-dir and sd, during backups, and 
 I've a feeling that some of them are not viable.
 
 I guess what I'm asking is, is it possible to wipe the slate clean, but 
 keep my working configuration from within bacula?

It sounds like you just want to wipe your sql database and keep your bacula
configuration files.

When I want to do this, I stop bacula and stop mysql (I use mysql):

/etc/rc.d/init.d/bacula stop
/etc/rc.d/init.d/mysql stop

I then 'rm -r' the bacula mysql database files - something like this:

cd /var/lib/mysql/data
rm -r bacula

I then start mysql and start bacula:

/etc/rc.d/init.d/mysql start
/etc/rc.d/init.d/bacula start


--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Mister IT Guru
On 05/01/2011 09:51, Graham Keeling wrote:
 On Wed, Jan 05, 2011 at 09:38:14AM +, Mister IT Guru wrote:
 I've run lots of test jobs, and I have a lot of backup data, that I
 don't really need, around 2TB or so! (we have a few servers!) I would
 like to know if it's possible to remove all of those jobs out of the
 bacula database. Personally, I would have cut this configure out, and
 drop it on a previous backup I have, but then I don't learn about how
 bacula works.

 My main fear, is that I rsync my disk backend offsite, and I've
 currently suspended that because of all these test jobs that I'm
 running. Also, I've reset the bacula-dir and sd, during backups, and
 I've a feeling that some of them are not viable.

 I guess what I'm asking is, is it possible to wipe the slate clean, but
 keep my working configuration from within bacula?
 It sounds like you just want to wipe your sql database and keep your bacula
 configuration files.

 When I want to do this, I stop bacula and stop mysql (I use mysql):

 /etc/rc.d/init.d/bacula stop
 /etc/rc.d/init.d/mysql stop

 I then 'rm -r' the bacula mysql database files - something like this:

 cd /var/lib/mysql/data
 rm -r bacula

 I then start mysql and start bacula:

 /etc/rc.d/init.d/mysql start
 /etc/rc.d/init.d/bacula start

This would mean I would manually deleted my disk based backups? 
Otherwise if I don't then wouldn't the first attempt to run a backup 
fail, because that disk volume exists? DiskBackupPool-001 as a file 
already exists, so will bacula just overwrite it?

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Graham Keeling
On Wed, Jan 05, 2011 at 09:55:17AM +, Mister IT Guru wrote:
 On 05/01/2011 09:51, Graham Keeling wrote:
  On Wed, Jan 05, 2011 at 09:38:14AM +, Mister IT Guru wrote:
  I've run lots of test jobs, and I have a lot of backup data, that I
  don't really need, around 2TB or so! (we have a few servers!) I would
  like to know if it's possible to remove all of those jobs out of the
  bacula database. Personally, I would have cut this configure out, and
  drop it on a previous backup I have, but then I don't learn about how
  bacula works.
 
  My main fear, is that I rsync my disk backend offsite, and I've
  currently suspended that because of all these test jobs that I'm
  running. Also, I've reset the bacula-dir and sd, during backups, and
  I've a feeling that some of them are not viable.
 
  I guess what I'm asking is, is it possible to wipe the slate clean, but
  keep my working configuration from within bacula?
  It sounds like you just want to wipe your sql database and keep your bacula
  configuration files.
 
  When I want to do this, I stop bacula and stop mysql (I use mysql):
 
  /etc/rc.d/init.d/bacula stop
  /etc/rc.d/init.d/mysql stop
 
  I then 'rm -r' the bacula mysql database files - something like this:
 
  cd /var/lib/mysql/data
  rm -r bacula
 
  I then start mysql and start bacula:
 
  /etc/rc.d/init.d/mysql start
  /etc/rc.d/init.d/bacula start
 
 This would mean I would manually deleted my disk based backups? 
 Otherwise if I don't then wouldn't the first attempt to run a backup 
 fail, because that disk volume exists? DiskBackupPool-001 as a file 
 already exists, so will bacula just overwrite it?

Sorry, I don't know what bacula will do if the actual volume already exists.

But, yes, if I wanted to start fresh but keep the same configuration, I would
wipe the database as already described, and delete the actual volumes manually.


--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Jan Lentfer
On Wed, 05 Jan 2011 09:38:14 +, Mister IT Guru misteritg...@gmx.com
wrote:
 I've run lots of test jobs, and I have a lot of backup data, that I 
 don't really need, around 2TB or so! (we have a few servers!) I would 
 like to know if it's possible to remove all of those jobs out of the 
 bacula database. Personally, I would have cut this configure out, and 
 drop it on a previous backup I have, but then I don't learn about how 
 bacula works.
 
 My main fear, is that I rsync my disk backend offsite, and I've 
 currently suspended that because of all these test jobs that I'm 
 running. Also, I've reset the bacula-dir and sd, during backups, and 
 I've a feeling that some of them are not viable.
 
 I guess what I'm asking is, is it possible to wipe the slate clean, but 
 keep my working configuration from within bacula?

For each database type there is a description in the manual how to wipe
the database clean after initial setup and testing, e.g.

http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION00433

hth

Jan

-- 
professional: http://www.oscar-consult.de
private: http://neslonek.homeunix.org/drupal/

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Paulo Martinez
Am 05.01.2011 um 10:38 schrieb Mister IT Guru:
 I've run lots of test jobs, and I have a lot of backup data, that I
 don't really need, around 2TB or so! (we have a few servers!) I would
 like to know if it's possible to remove all of those jobs out of the
 bacula database. Personally, I would have cut this configure out, and
 drop it on a previous backup I have, but then I don't learn about how
 bacula works.

 My main fear, is that I rsync my disk backend offsite, and I've
 currently suspended that because of all these test jobs that I'm
 running. Also, I've reset the bacula-dir and sd, during backups, and
 I've a feeling that some of them are not viable.

 I guess what I'm asking is, is it possible to wipe the slate clean,  
 but
 keep my working configuration from within bacula?




/etc/init.d/bacula-dir stop
/etc/init.d/bacula-sd stop
/etc/init.d/bacula-fd stop

/usr/libexec/bacula/drop_bacula_tables
/usr/libexec/bacula/make_mysql_tables

STR=$(cat /etc/bacula/bacula-sd.conf | grep Archive Device |grep -v  
dev |cut -d= -f2 | grep -v tmp | tr -d  )
  if [ -d $STR ];then
   echo Removing $STR ...
   rm $STR/*
  fi

rm /var/spool/bacula/*

/etc/init.d/bacula-dir start
/etc/init.d/bacula-sd start
/etc/init.d/bacula-fd start

maybe (for sure) some path are different on you system

--
PM



--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Jeremy Maes
Op 5/01/2011 10:55, Mister IT Guru schreef:
 On 05/01/2011 09:51, Graham Keeling wrote:
 On Wed, Jan 05, 2011 at 09:38:14AM +, Mister IT Guru wrote:
 I've run lots of test jobs, and I have a lot of backup data, that I
 don't really need, around 2TB or so! (we have a few servers!) I would
 like to know if it's possible to remove all of those jobs out of the
 bacula database. Personally, I would have cut this configure out, and
 drop it on a previous backup I have, but then I don't learn about how
 bacula works.

 My main fear, is that I rsync my disk backend offsite, and I've
 currently suspended that because of all these test jobs that I'm
 running. Also, I've reset the bacula-dir and sd, during backups, and
 I've a feeling that some of them are not viable.

 I guess what I'm asking is, is it possible to wipe the slate clean, but
 keep my working configuration from within bacula?
 It sounds like you just want to wipe your sql database and keep your bacula
 configuration files.

 When I want to do this, I stop bacula and stop mysql (I use mysql):

 /etc/rc.d/init.d/bacula stop
 /etc/rc.d/init.d/mysql stop

 I then 'rm -r' the bacula mysql database files - something like this:

 cd /var/lib/mysql/data
 rm -r bacula

 I then start mysql and start bacula:

 /etc/rc.d/init.d/mysql start
 /etc/rc.d/init.d/bacula start

 This would mean I would manually deleted my disk based backups?
 Otherwise if I don't then wouldn't the first attempt to run a backup
 fail, because that disk volume exists? DiskBackupPool-001 as a file
 already exists, so will bacula just overwrite it?


Or you could do this, as the bacula manual describes:
Section 41.3 Re-initializing the Catalog Database

After you have done some initial testing with Bacula, you will probably 
want to re-initialize the catalog
database and throw away all the test Jobs that you ran. To do so, you 
can do the following:

cd install-directory
./drop_mysql_tables
./make_mysql_tables

Please note that all information in the database will be lost and you 
will be starting from scratch. If you
have written on any Volumes, you must write an end of file mark on the 
volume so that Bacula can reuse it.

Do so with:
(stop Bacula or unmount the drive)
mt -f /dev/nst0 rewind
mt -f /dev/nst0 weof

Where you should replace /dev/nst0 with the appropriate tape drive 
device name for your machine.

If you're writing to files on disk you can just delete the volumes 
without any issues after clearing the catalog.

Kind regards,
Jeremy

  DISCLAIMER 
http://www.schaubroeck.be/maildisclaimer.htm

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Mister IT Guru
On 05/01/2011 10:01, Jan Lentfer wrote:
 On Wed, 05 Jan 2011 09:38:14 +, Mister IT Gurumisteritg...@gmx.com
 wrote:
 I've run lots of test jobs, and I have a lot of backup data, that I
 don't really need, around 2TB or so! (we have a few servers!) I would
 like to know if it's possible to remove all of those jobs out of the
 bacula database. Personally, I would have cut this configure out, and
 drop it on a previous backup I have, but then I don't learn about how
 bacula works.

 My main fear, is that I rsync my disk backend offsite, and I've
 currently suspended that because of all these test jobs that I'm
 running. Also, I've reset the bacula-dir and sd, during backups, and
 I've a feeling that some of them are not viable.

 I guess what I'm asking is, is it possible to wipe the slate clean, but
 keep my working configuration from within bacula?
 For each database type there is a description in the manual how to wipe
 the database clean after initial setup and testing, e.g.

 http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION00433

 hth
Thanks for the link, most useful! But I'm going to assume that all disk 
based volumes already have an EOF? I can understand having to mark 
tapes, so can I assume that the disk based volumes that are already in 
existence will just get reused?

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Jan Lentfer
On Wed, 05 Jan 2011 10:15:10 +, Mister IT Guru misteritg...@gmx.com
wrote:

 Thanks for the link, most useful! But I'm going to assume that all disk 
 based volumes already have an EOF? I can understand having to mark 
 tapes, so can I assume that the disk based volumes that are already in 
 existence will just get reused?

Just rm them an start fresh should be ok.

Jan

-- 
professional: http://www.oscar-consult.de
private: http://neslonek.homeunix.org/drupal/

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Trying to understand why device FileStorage can't access the disk?

2011-01-05 Thread Piotr Gbyliczek
On Thursday 30 December 2010 11:03:07 Mister IT Guru wrote:
   When I run a backup, I end up with this error:
 
 30-Dec 10:53 bacula.local JobId 16: Warning: mount.c:217 Open device
 FileStorage (/backups/default) Volume BaculaBackups-0001 failed:
 ERR=dev.c:549 Could not open: /backups/default/BaculaBackups-0001,
 ERR=No such file or directory

As silly as it sounds, I would attribute this error at first to non existing 
directories. Are you sure that /backups/default/ exists ?? 

-- 
Piotr Gbyliczek
Second Line Technician
ForLinux Ltd
Tel:  0845 4210444 

-- 
ForLinux Ltd, Innovation House,
Cafferata Way, Beacon Hill Business
Park, Newark, Notts. NG24 2TN

Tel:  0845 4210444  FAX 01636 703910
Web:  http://www.forlinux.co.uk/

Registered Company No 04227715
A BS9001  ISO27001 Accredited Hosting Provider

The information contained in this message or any of its attachments maybe 
confidential and is intended for the exclusive use of the addressee(s).

Any disclosure, reproduction, distribution or other dissemination or use
of this communication is strictly prohibited without the express
permission of the sender. The views expressed in this email are those of
the individual and not necessarily those of ForLinux Limited.

ForLinux Limited email is for business use only.

This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.


--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] incorrect User specified spool size reached message

2011-01-05 Thread Tilman Schmidt
I'm running Bacula 3.0.2 to back up a dozen of Linux servers
and a few Windows ones. Recently, messages like this started
showing up in the backup logs:

04-Jan 22:10 vm-backup-sd JobId 11043: Spooling data ...
04-Jan 22:11 vm-backup-sd JobId 11043: User specified spool size reached.
04-Jan 22:11 vm-backup-sd JobId 11043: Writing spooled data to Volume. 
Despooling 16,001,952 bytes ...
04-Jan 22:11 vm-backup-sd JobId 11043: Despooling elapsed time = 00:00:01, 
Transfer rate = 16.00 M bytes/second
04-Jan 22:11 vm-backup-sd JobId 11043: Spooling data again ...
04-Jan 22:11 vm-backup-sd JobId 11043: User specified spool size reached.
04-Jan 22:11 vm-backup-sd JobId 11043: Writing spooled data to Volume. 
Despooling 16,001,952 bytes ...
04-Jan 22:11 vm-backup-sd JobId 11043: Despooling elapsed time = 00:00:01, 
Transfer rate = 16.00 M bytes/second
04-Jan 22:11 vm-backup-sd JobId 11043: Spooling data again ...

The number of despooled bytes stays around the same during one
backup run (all jobs of one day) but decreases substantially
from one day to the next. For example:

03-Jan 22:29 vm-backup-sd JobId 11028: User specified spool size reached.
03-Jan 22:29 vm-backup-sd JobId 11028: Writing spooled data to Volume. 
Despooling 364,044,395 bytes ...
03-Jan 22:29 vm-backup-sd JobId 11028: Despooling elapsed time = 00:00:24, 
Transfer rate = 15.16 M bytes/second
03-Jan 22:29 vm-backup-sd JobId 11028: Spooling data again ...

My storage configuration looks like this:

Device {
  Name = LTO1
  Media Type = LTO1
  Archive Device = /dev/nst0
  AutomaticMount = yes;   # when device opened, read it
# OfflineOnUnmount = yes; # when unmounted, eject tape
  AlwaysOpen = yes;
  RemovableMedia = yes;
  RandomAccess = no;
  SpoolDirectory = /home/backup/spool;
  MaximumSpoolSize = 50G;
}

So, taken literally, that message is just plain wrong. The 16 MB
spooled are far less than my specified spool size of 50 GB.

I checked the spool directory for stale files, and it is empty.
The filesystem it resides on has 98 GB of free space.
There are no concurrent jobs. (Maximum Concurrent Jobs = 1)

What other possible reasons are there for that message?

TIA,
Tilman

-- 
Tilman Schmidt
Phoenix Software GmbH
Bonn, Germany



signature.asc
Description: OpenPGP digital signature
--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] How would I 'nuke' my bacula instance - Start afresh so to speak.

2011-01-05 Thread Phil Stracchino
On 01/05/11 04:51, Graham Keeling wrote:
 When I want to do this, I stop bacula and stop mysql (I use mysql):
 
 /etc/rc.d/init.d/bacula stop
 /etc/rc.d/init.d/mysql stop
 
 I then 'rm -r' the bacula mysql database files - something like this:
 
 cd /var/lib/mysql/data
 rm -r bacula
 
 I then start mysql and start bacula:
 
 /etc/rc.d/init.d/mysql start
 /etc/rc.d/init.d/bacula start

Well, you could do it that way, but it's a bit like taking your car
apart to get your groceries out of the trunk.

This is particularly a poor method since Bacula already provides tools
for the job.

$ .../bacula/etc/bacula stop
$ .../bacula/etc/drop-mysql-tables
$ .../bacula/etc/make-mysql-tables
$ .../bacula/etc/bacula start

Done.


-- 
  Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
  ala...@caerllewys.net   ala...@metrocast.net   p...@co.ordinate.org
 Renaissance Man, Unix ronin, Perl hacker, Free Stater
 It's not the years, it's the mileage.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] incorrect User specified spool size reached message

2011-01-05 Thread Dan Langille
On 1/5/2011 6:50 AM, Tilman Schmidt wrote:
 I'm running Bacula 3.0.2 to back up a dozen of Linux servers
 and a few Windows ones. Recently, messages like this started
 showing up in the backup logs:

 04-Jan 22:10 vm-backup-sd JobId 11043: Spooling data ...
 04-Jan 22:11 vm-backup-sd JobId 11043: User specified spool size reached.
 04-Jan 22:11 vm-backup-sd JobId 11043: Writing spooled data to Volume. 
 Despooling 16,001,952 bytes ...
 04-Jan 22:11 vm-backup-sd JobId 11043: Despooling elapsed time = 00:00:01, 
 Transfer rate = 16.00 M bytes/second
 04-Jan 22:11 vm-backup-sd JobId 11043: Spooling data again ...
 04-Jan 22:11 vm-backup-sd JobId 11043: User specified spool size reached.
 04-Jan 22:11 vm-backup-sd JobId 11043: Writing spooled data to Volume. 
 Despooling 16,001,952 bytes ...
 04-Jan 22:11 vm-backup-sd JobId 11043: Despooling elapsed time = 00:00:01, 
 Transfer rate = 16.00 M bytes/second
 04-Jan 22:11 vm-backup-sd JobId 11043: Spooling data again ...

 The number of despooled bytes stays around the same during one
 backup run (all jobs of one day) but decreases substantially
 from one day to the next. For example:

 03-Jan 22:29 vm-backup-sd JobId 11028: User specified spool size reached.
 03-Jan 22:29 vm-backup-sd JobId 11028: Writing spooled data to Volume. 
 Despooling 364,044,395 bytes ...
 03-Jan 22:29 vm-backup-sd JobId 11028: Despooling elapsed time = 00:00:24, 
 Transfer rate = 15.16 M bytes/second
 03-Jan 22:29 vm-backup-sd JobId 11028: Spooling data again ...

 My storage configuration looks like this:

 Device {
Name = LTO1
Media Type = LTO1
Archive Device = /dev/nst0
AutomaticMount = yes;   # when device opened, read it
 # OfflineOnUnmount = yes; # when unmounted, eject tape
AlwaysOpen = yes;
RemovableMedia = yes;
RandomAccess = no;
SpoolDirectory = /home/backup/spool;
MaximumSpoolSize = 50G;
 }

 So, taken literally, that message is just plain wrong. The 16 MB
 spooled are far less than my specified spool size of 50 GB.

 I checked the spool directory for stale files, and it is empty.
 The filesystem it resides on has 98 GB of free space.
 There are no concurrent jobs. (Maximum Concurrent Jobs = 1)

 What other possible reasons are there for that message?

At one time, was MaximumSpoolSize set to 16GB?  If so, did you restat 
bacula-sd after making that change?

-- 
Dan Langille - http://langille.org/

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] incorrect User specified spool size reached message

2011-01-05 Thread Tilman Schmidt
Am 2011-01-05 14:06 schrieb Dan Langille:
 On 1/5/2011 6:50 AM, Tilman Schmidt wrote:
[...]
 04-Jan 22:11 vm-backup-sd JobId 11043: User specified spool size reached.
 04-Jan 22:11 vm-backup-sd JobId 11043: Writing spooled data to Volume. 
 Despooling 16,001,952 bytes ...
 04-Jan 22:11 vm-backup-sd JobId 11043: Despooling elapsed time = 00:00:01, 
 Transfer rate = 16.00 M bytes/second
 04-Jan 22:11 vm-backup-sd JobId 11043: Spooling data again ...
[...]
SpoolDirectory = /home/backup/spool;
MaximumSpoolSize = 50G;
 }

 So, taken literally, that message is just plain wrong. The 16 MB
 spooled are far less than my specified spool size of 50 GB.

 I checked the spool directory for stale files, and it is empty.
 The filesystem it resides on has 98 GB of free space.
 There are no concurrent jobs. (Maximum Concurrent Jobs = 1)

 What other possible reasons are there for that message?
 
 At one time, was MaximumSpoolSize set to 16GB?  If so, did you restat 
 bacula-sd after making that change?

The SD config file hasn't been touched for more than a year,
and I'm pretty sure I never set MaximumSpoolSize as low as 16M.

Nevertheless, restarting bacula-sd sounds like a good idea.
It has been running for quite a long time and accumulated an
impressive CPU time of 2024:10. Perhaps there's some sort of leak.

Thanks,
Tilman

-- 
Tilman Schmidt
Phoenix Software GmbH
Bonn, Germany



signature.asc
Description: OpenPGP digital signature
--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive

2011-01-05 Thread Arunav Mandal

Is there any way I can test the full capacity of tape with compression?
 
Arunav.
 
 Date: Tue, 4 Jan 2011 10:48:17 +
 From: a...@mssl.ucl.ac.uk
 To: di...@hotmail.com
 CC: bacula-users@lists.sourceforge.net
 Subject: Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive
 
 Arunav Mandal wrote:
  I have a Tandberg T40+ Tapeloader with HP LTO-5 tape drive connected to
  QLogic Corp. ISP2532-based 8Gb Fibre Channel to PCI Express HBA on a Dell
  2950 running Ubuntu Server 10.10. The kernel version is 2.6.35-24-server.
  The autoloader device number changes sometimes with reboot. When I installed
  the server it was /dev/sg4 and now it is /dev/sg2. The tape drive is at
  /dev/st0 and /dev/nst0. 
 
 the SG number depends entirely on the order things are picked up in. So 
 does ST/NST for that matter. The trick there is to use a script to link 
 each detecetd ST to a WWID entry and use that in bacula-sd.conf
 
 Bacula does use ST - more specifically it locks to whatever you have 
 defined in bacula-sd - which means if you put an incorrect entry it will 
 use it (GIGO)
 
  My question is how can I fix the problem of device number changing with
  reboots?
 
 Like this (from my configuration on RHEL5.5):
 
 bacula-sd.conf
 
 [snip]
 Device {
 Name = MSSLY8-0
 Drive Index = 0
 Device Type = Tape
 Media Type = LTO5
 AutoChanger = yes;
 Changer Device = /etc/bacula/DEVICES/MSSLY8-changer
 Archive Device = /etc/bacula/DEVICES/MSSLY8-0
 AutomaticMount = yes; # when device opened, read it
 AlwaysOpen = yes;
 LabelMedia = yes; # lets Bacula label unlabeled media
 RemovableMedia = yes;
 RandomAccess = no;
 Volume Poll Interval = 7200
 Alert Command = sh -c '/usr/local/bin/gettapeinfo.sh 
 /etc/bacula/DEVICES/MSSLY8-0'
 Spool Directory = /var/bacula/spool/MSSLY8-0
 Maximum File Size = 10GB
 Maximum Network Buffer Size = 65536
 Maximum Spool Size = 250G
 Maximum Job Spool Size = 50G
 }
 [snip]
 
 The /etc/bacula/DEVICES entries are there simply for readability and are 
 symlinks to the WWIDs of the tapes:
 
 # ls -l /etc/bacula/DEVICES
 total 0
 lrwxrwxrwx 1 root root 42 Nov 18 14:45 MSSLY8-0 - 
 /dev/tape/by-id/scsi-3500110a001313fee-nst
 lrwxrwxrwx 1 root root 42 Nov 18 14:45 MSSLY8-1 - 
 /dev/tape/by-id/scsi-3500110a0013141aa-nst
 lrwxrwxrwx 1 root root 42 Nov 18 14:45 MSSLY8-2 - 
 /dev/tape/by-id/scsi-3500110a001314b4a-nst
 lrwxrwxrwx 1 root root 42 Nov 18 14:42 MSSLY8-3 - 
 /dev/tape/by-id/scsi-3500110a001314b12-nst
 lrwxrwxrwx 1 root root 42 Nov 18 14:50 MSSLY8-4 - 
 /dev/tape/by-id/scsi-3500110a0013144e2-nst
 lrwxrwxrwx 1 root root 42 Nov 18 15:00 MSSLY8-5 - 
 /dev/tape/by-id/scsi-3500110a0013132b6-nst
 lrwxrwxrwx 1 root root 42 Nov 18 15:04 MSSLY8-6 - 
 /dev/tape/by-id/scsi-3500110a00131426e-nst
 lrwxrwxrwx 1 root root 38 Oct 29 20:47 MSSLY8-changer - 
 /dev/tape/by-id/scsi-200900d071022
 
 # ls -l /dev/tape/by-id/
 total 0
 lrwxrwxrwx 1 root root 10 Dec 23 19:15 scsi-200900d071022 - ../../sg46
 lrwxrwxrwx 1 root root 10 Dec 23 19:15 scsi-3500110a0013132b6-nst - 
 ../../nst9
 lrwxrwxrwx 1 root root 10 Dec 23 19:14 scsi-3500110a001313fee-nst - 
 ../../nst4
 lrwxrwxrwx 1 root root 11 Dec 23 19:15 scsi-3500110a0013141aa-nst - 
 ../../nst11
 lrwxrwxrwx 1 root root 10 Dec 23 19:14 scsi-3500110a00131426e-nst - 
 ../../nst6
 lrwxrwxrwx 1 root root 10 Dec 23 19:14 scsi-3500110a0013144e2-nst - 
 ../../nst3
 lrwxrwxrwx 1 root root 11 Dec 23 19:15 scsi-3500110a001314b12-nst - 
 ../../nst10
 lrwxrwxrwx 1 root root 11 Dec 23 19:16 scsi-3500110a001314b4a-nst - 
 ../../nst13
 
 Note that only the SG of trhe changer is listed above. That's where 
 /usr/local/bin/gettapeinfo.sh comes in to find the sg of individual tape 
 drives for reporting purposes:
 
 ===
 #!/bin/bash
 export INDIRECT=`ls -l $1 | cut -f2 -d\`
 export DEVICE=`ls -l $INDIRECT | cut -f2 -d\ | cut -f3 -d/`
 export GENERIC=`ls /sys/class/scsi_tape/$DEVICE/device | grep 
 scsi_generic | cut -f2 -d:`
 
 echo $1 $INDIRECT $DEVICE $GENERIC
 
 tapeinfo -f /dev/$GENERIC
 smartctl -H -d scsi -l error /dev/$GENERIC
 ===
 
 Ideally RHEL's udev rules would put the sg entry in /dev/tape/by-id and 
 I wouldn't have to kludge the script...
 
 NOTE: Linux multipathing does NOT support generic or tape devices, so be 
 careful what you disconnect in a fibre network!
 
 
  --
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive

2011-01-05 Thread John Drescher
 Is there any way I can test the full capacity of tape with compression?


That question does not make total sense. I mean compression is
dependent on the data you supply. On one tape you can get 5:1 on a
second tape you can get 1.1:1 depending on your data. For me I average
1.5:1 compression. And that seems to be the expectation even though
the standard claims the overly optimistic 2:1.

John

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive

2011-01-05 Thread Phil Stracchino
On 01/05/11 10:45, John Drescher wrote:
 Is there any way I can test the full capacity of tape with compression?

 
 That question does not make total sense. I mean compression is
 dependent on the data you supply. On one tape you can get 5:1 on a
 second tape you can get 1.1:1 depending on your data. For me I average
 1.5:1 compression. And that seems to be the expectation even though
 the standard claims the overly optimistic 2:1.

All tape drive marketing claims assume 2:1 overall compression.  My
experience is that with my real-world data set, I get about 15%
compression overall, i.e about 230GB on a 200/400GB LTO2 tape.


-- 
  Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
  ala...@caerllewys.net   ala...@metrocast.net   p...@co.ordinate.org
 Renaissance Man, Unix ronin, Perl hacker, Free Stater
 It's not the years, it's the mileage.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Creating archival backup

2011-01-05 Thread Ben Beuchler
Once a year, I need to create a full backup that will be stored
off-site.  This backup will not be readily available for normal
restores.  The obvious approach would be to delete that backup (and
its volumes) from the catalog so they will not be considered when
performing future backups/restores.

Is there a better approach?  This seems rather clumsy.

Thanks!

-Ben

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Creating archival backup

2011-01-05 Thread John Drescher
On Wed, Jan 5, 2011 at 12:06 PM, Ben Beuchler ins...@gmail.com wrote:
 Once a year, I need to create a full backup that will be stored
 off-site.  This backup will not be readily available for normal
 restores.  The obvious approach would be to delete that backup (and
 its volumes) from the catalog so they will not be considered when
 performing future backups/restores.

 Is there a better approach?  This seems rather clumsy.


I create a duplicate job that has the same fileset. This job goes to
an archive pool that does not recycle.

John

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Cannot compile bacula 5.0.3 on Solaris 10.

2011-01-05 Thread robert . denault
I am trying to compile the bacula service on Solaris 10 system.  I have 
followed the documentation but I get errors during the compilation.  All 
required package are installed:
SUNWbinutils binutils - GNU binutilsSUNWarc Lint Libraries (usr)SUNWhea SunOS 
Header FilesSUNWgcc gcc - The GNU C compilerSUNWgnutls GNU Transport Layer 
Security LibrarySUNWgnutls-devel GNU Transport Layer Security Library - 
developer filesSUNWgmake gmake - GNU makeSUNWgccruntime GCC Runtime 
librariesSUNWlibgcrypt Libgcrypt - Cryptographic LibrarySUNWzlib The Zip 
compression librarySUNWzlibS Source for the Zip compression 
librarySUNWbinutilsS GNU binutils - GNU Binary file utilities 
(Source)SUNWgmakeS GNU make - A utility used to build software (Source)SUNWlibm 
Math  Microtasking Library Headers  Lint Files (Usr)


Parameters for configure:
LDFLAGS=-L/usr/sfw/lib -R/usr/sfw/libCFLAGS=-gexport PATH LDFLAGS CFLAGS 
./configure \  --prefix=/opt \  --datarootdir=/usr/share \  
--mandir=/usr/share/man \  --sbindir=/opt/bacula/sbin \  
--sysconfdir=/opt/bacula/etc \  --oldincludedir=/usr/include \  
--includedir=/usr/local/include \  --with-mysql \  --enable-smartalloc \  
--disable-nls \  --enable-conio \  --with-pid-dir=/var/run \  
--with-subsys-dir=/var/bacula \  --with-working-dir=/var/bacula \  
--with-job-email=mtl-core...@telus.com \  
--with-smtp-host=coredev-mail-relay.coredev.mtl.emergis.com

Contents of config.out:Configuration on Wed Jan  5 11:08:03 EST 2011:   Host:   
 sparc-sun-solaris2.10 -- solaris 5.10   Bacula version:
  Bacula 5.0.3 (04 August 2010)   Source code location:.   Install 
binaries:/opt/bacula/sbin   Install libraries:   /opt/lib   Install 
config files:/opt/bacula/etc   Scripts directory:   /opt/bacula/etc   
Archive directory:   /tmp   Working directory:   /var/bacula   PID 
directory:   /var/run   Subsys directory:/var/bacula   Man 
directory:   /usr/share/man   Data directory:  /usr/share   
Plugin directory:/opt/lib   C Compiler:  gcc 3.4.6   C++ 
Compiler:/usr/local/bin/g++ 3.4.6   Compiler flags:   -g 
-fno-strict-aliasing -fno-exceptions -fno-rtti   Linker flags: 
-L/usr/sfw/lib -R/usr/sfw/lib   Libraries:   -lpthread -lresolv 
-lnsl -lsocket -lxnet  -lintl -lresolv -lrt   Statically Linked Tools: no   
Statically Linked FD:no   Statically Linked SD:no   Statically Linked 
DIR:   no   Statically Linked CONS:  no   Database type:   MySQL   
Database port:   Database lib:   Database name: 
  bacula   Database user:   bacula   Job Output Email:
mtl-core...@telus.com   Traceback Email: r...@localhost   SMTP Host 
Address:   coredev-mail-relay.coredev.mtl.emergis.com   Director Port:  
 9101   File daemon Port:9102   Storage daemon Port: 9103   
Director User:  Director Group: Storage Daemon User:
Storage DaemonGroup:File Daemon User:   File Daemon Group:  
SQL binaries Directory   /usr/local/mysql/bin   Large file support: 
 yes   Bacula conio support:yes -lncurses   readline support:no
TCP Wrappers support:noTLS support: no   Encryption 
support:  no   ZLIB support:yes   enable-smartalloc:   yes  
 enable-lockmgr:  no   bat support: no   enable-gnome:  
  noenable-bwx-console:  noenable-tray-monitor: no   
client-only: no   build-dird:  yes   build-stored:  
  yes   Plugin support:  yes   AFS support: no   ACL 
support: yes   XATTR support:   yes   Python support:   
   noBatch insert enabled:no
Result of the make command:
-bash-3.00$ /usr/ccs/bin/make==Entering directory 
/export/home/rdenault/downloads/bacula/bacula-5.0.3/src==Entering directory 
/export/home/rdenault/downloads/bacula/bacula-5.0.3/scripts==Entering 
directory /export/home/rdenault/downloads/bacula/bacula-5.0.3/src/libCompiling 
attr.cIn file included from /usr/include/sys/wait.h:24, from 
/usr/include/stdlib.h:22, from ../bacula.h:76, 
from attr.c:36:/usr/include/sys/siginfo.h:259: error: `ctid_t' does not name a 
type/usr/include/sys/siginfo.h:260: error: `zoneid_t' does not name a 
type/usr/include/sys/siginfo.h:390: error: `ctid_t' does not name a 
type/usr/include/sys/siginfo.h:391: error: `zoneid_t' does not name a typeIn 
file included from ../bacula.h:148, from 
attr.c:36:/usr/include/pthread.h:299: error: `pthread_spinlock_t' was not 
declared in this scope/usr/include/pthread.h:299: error: expected 
primary-expression before ',' token/usr/include/pthread.h:299: error: expected 
primary-expression before int/usr/include/pthread.h:299: error: initializer 
expression 

Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive

2011-01-05 Thread Arunav Mandal

Very true, in real world data is so different that compression ratio is 
different. Is there any easy way to find out how much data is stored per tape?
 
Arunav.
 

 
 Date: Wed, 5 Jan 2011 10:45:09 -0500
 Subject: Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive
 From: dresche...@gmail.com
 To: di...@hotmail.com; Bacula-users@lists.sourceforge.net
 
  Is there any way I can test the full capacity of tape with compression?
 
 
 That question does not make total sense. I mean compression is
 dependent on the data you supply. On one tape you can get 5:1 on a
 second tape you can get 1.1:1 depending on your data. For me I average
 1.5:1 compression. And that seems to be the expectation even though
 the standard claims the overly optimistic 2:1.
 
 John
  --
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] client backup paths stored in database?

2011-01-05 Thread Joseph Spenner
Does bacula store the File = /path/to/backup (as described in the 
bacula-dir.conf FileSet sections) in the database anywhere?

If so, which tables would I find it?  I spun through them and couldn't find 
anything.

Thanks!



  

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive

2011-01-05 Thread John Drescher
On Wed, Jan 5, 2011 at 3:11 PM, Arunav Mandal di...@hotmail.com wrote:
 Very true, in real world data is so different that compression ratio is
 different. Is there any easy way to find out how much data is stored per
 tape?


list media

in bconsole

volbytes will tell you how much data is on each tape.

John

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive

2011-01-05 Thread Phil Stracchino
On 01/05/11 15:11, Arunav Mandal wrote:
 Very true, in real world data is so different that compression ratio is
 different. Is there any easy way to find out how much data is stored per
 tape?

The Media or Pools view in bat (for one easy way to access it) will show
you the exact amount of data written to any volume, which in the case of
tape hardware compression will be the data amount before compression.
As noted elsewhere, I'm typically seeing around 230GB on an LTO2 tape.

(It should be noted in fairness that by far the majority of the backup
set on my NAS server is already-compressed data such as digital audio
and video.)

The way LTO compression works, the tape drive compresses each block on
the fly, then writes to tape whichever is the *smaller* of the raw or
the compressed block, flagging it accordingly.


-- 
  Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
  ala...@caerllewys.net   ala...@metrocast.net   p...@co.ordinate.org
 Renaissance Man, Unix ronin, Perl hacker, Free Stater
 It's not the years, it's the mileage.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] client backup paths stored in database?

2011-01-05 Thread Phil Stracchino
On 01/05/11 15:13, Joseph Spenner wrote:
 Does bacula store the File = /path/to/backup (as described in the 
 bacula-dir.conf FileSet sections) in the database anywhere?
 
 If so, which tables would I find it?  I spun through them and couldn't find 
 anything.

Bacula stores the metadata about each backed-up file as a File record
(in the File table) which contains pointers to a Filename record and a
Path record.  The complete pathname does not exist *as such* at any
single location in the database.


-- 
  Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
  ala...@caerllewys.net   ala...@metrocast.net   p...@co.ordinate.org
 Renaissance Man, Unix ronin, Perl hacker, Free Stater
 It's not the years, it's the mileage.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Hardware Encryption?

2011-01-05 Thread Mingus Dew
Fellow Bacula Users,
 I am in search of a hardware based encryption solution that is
OS/Storage independent. Whether it be a new drive or something else even
Bacula compatible. The encryption provided within Bacula itself is not
sufficient for my needs and during my last search I was unable to find an
LTO-4 drive with encryption that was capable of encrypting tapes w/o
interaction from the Backup program (essentially only being supported by the
software of the vendor itself)

So some responses from fellow users on what you're doing for encryption
of Tapes outside of Bacula would be great.

Thanks,
Shon
--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] client backup paths stored in database?

2011-01-05 Thread Kleber Leal
I was suprised, is not on database.
On table FileSet has not this information.

++--+--+-+-++
| Field  | Type | Null | Key | Default |
Extra  |
++--+--+-+-++
| FileSetId  | int(10) unsigned | NO   | PRI | NULL|
auto_increment |
| FileSet| tinyblob | NO   | | NULL
||
| MD5| tinyblob | YES  | | NULL
||
| CreateTime | datetime | YES  | | -00-00 00:00:00
||
++--+--+-+-++

Has no information about file paths.
I think the director read all filesets from config file in memory during
start up.

Kleber


2011/1/5 Joseph Spenner joseph85...@yahoo.com

 Does bacula store the File = /path/to/backup (as described in the
 bacula-dir.conf FileSet sections) in the database anywhere?

 If so, which tables would I find it?  I spun through them and couldn't find
 anything.

 Thanks!






 --
 Learn how Oracle Real Application Clusters (RAC) One Node allows customers
 to consolidate database storage, standardize their database environment,
 and,
 should the need arise, upgrade to a full multi-node Oracle RAC database
 without downtime or disruption
 http://p.sf.net/sfu/oracle-sfdevnl
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Hardware Encryption?

2011-01-05 Thread Edward M. Markowski

here at work we do not use bacula so I can't speak to the compatibility, 
but we use the following:

Started with Netapp Datafort inline apiliances, we have around 30 of the 
deployed, they work mostly, but require more maintaince then I would like.

Our second generation solution for inline encryption is using lto-4 and 
sun T-10k native encryption.

Ed m.

On Wed, 5 Jan 2011, Mingus Dew wrote:

 Fellow Bacula Users,
 I am in search of a hardware based encryption solution that is
 OS/Storage independent. Whether it be a new drive or something else even
 Bacula compatible. The encryption provided within Bacula itself is not
 sufficient for my needs and during my last search I was unable to find an
 LTO-4 drive with encryption that was capable of encrypting tapes w/o
 interaction from the Backup program (essentially only being supported by the
 software of the vendor itself)

So some responses from fellow users on what you're doing for encryption
 of Tapes outside of Bacula would be great.

 Thanks,
 Shon


 


!DSPAM:4d24eb1011887277626594!



--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive

2011-01-05 Thread Arunav Mandal

Is deduplication possible in Bacula.
 
Arunav.
 
 Date: Wed, 5 Jan 2011 15:28:20 -0500
 From: ala...@metrocast.net
 To: bacula-users@lists.sourceforge.net
 Subject: Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive
 
 On 01/05/11 15:11, Arunav Mandal wrote:
  Very true, in real world data is so different that compression ratio is
  different. Is there any easy way to find out how much data is stored per
  tape?
 
 The Media or Pools view in bat (for one easy way to access it) will show
 you the exact amount of data written to any volume, which in the case of
 tape hardware compression will be the data amount before compression.
 As noted elsewhere, I'm typically seeing around 230GB on an LTO2 tape.
 
 (It should be noted in fairness that by far the majority of the backup
 set on my NAS server is already-compressed data such as digital audio
 and video.)
 
 The way LTO compression works, the tape drive compresses each block on
 the fly, then writes to tape whichever is the *smaller* of the raw or
 the compressed block, flagging it accordingly.
 
 
 -- 
 Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
 Renaissance Man, Unix ronin, Perl hacker, Free Stater
 It's not the years, it's the mileage.
 
 --
 Learn how Oracle Real Application Clusters (RAC) One Node allows customers
 to consolidate database storage, standardize their database environment, and, 
 should the need arise, upgrade to a full multi-node Oracle RAC database 
 without downtime or disruption
 http://p.sf.net/sfu/oracle-sfdevnl
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
  --
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula configration for FC LTO-5 tape drive

2011-01-05 Thread Phil Stracchino
On 01/05/11 17:31, Arunav Mandal wrote:
 Is deduplication possible in Bacula.

Not yet.  :)


(Well, OK, not deduplication as such.  Yet.  But look into the Base Jobs
feature.  It *MAY* do what you want.)


-- 
  Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
  ala...@caerllewys.net   ala...@metrocast.net   p...@co.ordinate.org
 Renaissance Man, Unix ronin, Perl hacker, Free Stater
 It's not the years, it's the mileage.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] client backup paths stored in database?

2011-01-05 Thread Dan Langille
On 1/5/2011 4:47 PM, Kleber Leal wrote:
 2011/1/5 Joseph Spenner joseph85...@yahoo.com
 mailto:joseph85...@yahoo.com

 Does bacula store the File = /path/to/backup (as described in the
 bacula-dir.conf FileSet sections) in the database anywhere?

 If so, which tables would I find it?  I spun through them and
 couldn't find anything.

 Thanks!

  I was suprised, is not on database.
  On table FileSet has not this information.
 
  Has no information about file paths.
  I think the director read all filesets from config file in memory
  during start up.

Right you are.

-- 
Dan Langille - http://langille.org/

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] client backup paths stored in database?

2011-01-05 Thread Phil Stracchino
On 01/05/11 19:30, Dan Langille wrote:
 On 1/5/2011 4:47 PM, Kleber Leal wrote:
 2011/1/5 Joseph Spenner joseph85...@yahoo.com
 mailto:joseph85...@yahoo.com

 Does bacula store the File = /path/to/backup (as described in the
 bacula-dir.conf FileSet sections) in the database anywhere?

 If so, which tables would I find it?  I spun through them and
 couldn't find anything.

 Thanks!
 
   I was suprised, is not on database.
   On table FileSet has not this information.
  
   Has no information about file paths.
   I think the director read all filesets from config file in memory
   during start up.
 
 Right you are.
 

Ah, upon re-reading, I see I misunderstood the question


-- 
  Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
  ala...@caerllewys.net   ala...@metrocast.net   p...@co.ordinate.org
 Renaissance Man, Unix ronin, Perl hacker, Free Stater
 It's not the years, it's the mileage.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] client backup paths stored in database?

2011-01-05 Thread Dan Langille
On 1/5/2011 7:49 PM, Phil Stracchino wrote:
 On 01/05/11 19:30, Dan Langille wrote:
 On 1/5/2011 4:47 PM, Kleber Leal wrote:
 2011/1/5 Joseph Spennerjoseph85...@yahoo.com
 mailto:joseph85...@yahoo.com

  Does bacula store the File = /path/to/backup (as described in the
  bacula-dir.conf FileSet sections) in the database anywhere?

  If so, which tables would I find it?  I spun through them and
  couldn't find anything.

  Thanks!

 I was suprised, is not on database.
 On table FileSet has not this information.
   
 Has no information about file paths.
 I think the director read all filesets from config file in memory
 during start up.

 Right you are.


 Ah, upon re-reading, I see I misunderstood the question

So did I at first, until I saw the reply above.

-- 
Dan Langille - http://langille.org/

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] REPOST Can't connect to Remote.

2011-01-05 Thread Wayne Spivak
 Installed Bacula 5.0.2 on Fedora 14 (called Kira).

 Previously had it installed and working on Fedora 11 (called Beech)

 I copied all the conf files from Beech to Kira (adjusted them for new
 Machine names), debugged normal errors and Bacula started.

Did a backup on Kira without problems.

 Went to test on Ladymax (on other side of firewall - public machine):
 Port 9102 works both ways (only running bacula-fd) Port 9101 and 9103 
 work from Ladymax to Kira Both using 5.0.2 (FD for Ladymax) 

Started Ladymax in Debug mode:
 /sbin/bacula-fd -c/etc/bacula/bacula-fd.conf -f -d20 -m -v -s -dt 
 29-Dec-2010 09:20:44 ladymax.sbanetweb.com-fd: filed.c:275-0 filed:
 listening on port 9102

 Bacula on Kira won't find Ladymax.  Error is  kira.sbanetweb.com-dir 
 JobId  14: Fatal error: Socket error on Storage command: ERR=Connection
reset 
 by peer 29-Dec 10:19 kira.sbanetweb.com-dir JobId 14: Fatal error: 
 Network error with FD during Backup: ERR=Connection reset by peer 29-Dec
10:19

 Remember, Ladymax works under a Fedora 11 install... I even turned off 
 iptables on Kira (inside of firewall), to no avail.  


I then loaded Bacula client (5.0.2) on a differnt Fedora 14 box which is
behind the
firewall (EMMA) and is 1 IP address different from KIRA.  I took down
iptables (since it is redundant and to minimize possible errors).

Same basic error:
Fatal error: bsock.c:135 Unable to connect to Client: emma.sbanetweb.com-fd
on 192.68.0.30:9102. ERR=Interrupted system call


There is nothing I can find using Google.

Some help or additional pointers would be helpful.

Thank you.



Wayne Spivak
SBA * Consulting®   SBA.NET.WEB®
divisions of SBA * Consulting, Ltd.
2711 Bellmore Avenue, Bellmore, New York  11710-4319
Tel: 516-221-3306  mailto:wspi...@sbanetweb.com
http://www.sbanetweb.com   or  http://www.sbaconsulting.com






--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Cannot compile bacula 5.0.3 on Solaris 10.

2011-01-05 Thread Gary R. Schmidt
On 6/01/2011 5:17 AM, robert.dena...@videotron.ca wrote:
 I am trying to compile the bacula service on Solaris 10 system. I have

Have you tried it with the Sun Studio compiler, rather than GNU?  I try 
to avoid using gcc on Solaris these days as Studio gives much better 
results.

Here's my redacted 3.0.2/5.0.0 configuration - note that it uses the 
WebStack/CoolStack version of MySQL, which means that the configure 
script has to also be modified to recognise it.

Cheers,
GaryB-)

Cut-Here--
PATH=/opt/webstack/bin:/opt/webstack/mysql/bin:/bin:/usr/bin:/opt/SUNWspro/bin:/usr/ccs/bin:/sbin:/usr/sbin:/opt/local/bin
export PATH

./configure \
   CC=cc CXX=CC \
   CFLAGS=-g -O \
   LDFLAGS=-R/opt/webstack/mysql/lib/mysql \
   --prefix=/opt/bacula \
   --datarootdir=/opt/bacula/share \
   --mandir=/opt/bacula/man \
   --with-archivedir=/opt/bacula/archive \
   --with-working-dir=/opt/bacula/working \
   --with-plugindir=/opt/bacula/plugins \
   --with-scriptdir=/opt/bacula/scripts \
   --with-subsys-dir=/opt/bacula/subsys \
   --with-mysql=/opt/webstack/mysql \
   --with-dir-password=123 \
   --with-fd-password=456 \
   --with-sd-password=789 \
   --with-dir-user=bacula \
   --with-dir-group=backup \
   --with-sd-user=bacula \
   --with-sd-group=backup \
   --with-fd-user=root \
   --with-fd-group=backup \
   --enable-smartalloc \
   --enable-batch-insert \
   --enable-smartalloc \
   --with-dump-email=me \
   --with-job-email=me \
   --with-smtp-host=localhost

Cut-Here--

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users