Re: [Bacula-users] What new feature are you waiting for?

2008-11-07 Thread Tilman Schmidt
On Thu, 6 Nov 2008 22:14:08 -0500, Dan Langille wrote:
 On Nov 6, 2008, at 5:23 AM, Tilman Schmidt wrote:
 
 Am 05.11.2008 22:03 schrieb Dan Langille:
 - Bacula has known how to use the current tape that is a drive for a
 long time
 now.  It is discouraged, but just a matter of configuration.

 I'm sorry but I'm starting to have serious doubts about that.
 I have been trying for a long time and in many different ways
 to get that to work, and each time I ask a question here why
 my latest attempt doesn't work either, the answer is post
 config, post log, and then: silence.
 
 What can I say?  I'm not responsible for people not answering.
 Nor is anybody else.  That's how it works.  Or more precisely,
 doesn't.

Sure. I'm not complaining about that. Sorry if my answer came
across as such. But the fact that nobody could come up with an
answer might indicate that the answer doesn't exist.

 And if it is discouraged, what is the recommended alternative?
 
 Work with Bacula, not against it.  I don't know what more to say.

Sure, and I'm trying my best to do exactly that. But the topic
of this thread is desirable new features for Bacula, ie. things
that currently cannot be done but would be nice if they could.
For me, better support for the classic scenario standalone tape
drive with daytime operator and nighttime backups does fall
into that category, and surely the existence of unanswerable
questions in that area seems to indicate that there is indeed
room for improvement.

Again, I do not want to complain. Bacula is a great product,
and the support from the Bacula community is better than the
company support of many commercial products I have used. All
I want to do with my contributions to this thread is to help
making Bacula even better. If the community decides that my
scenario lies outside the main target area of Bacula then
that's fine with me.

Thanks,
Tilman

-- 
Tilman Schmidt
Phoenix Software GmbH
Bonn, Germany



signature.asc
Description: OpenPGP digital signature
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] MaximumBlockSize Problem and Question

2008-11-07 Thread Ulrich Leodolter
On Thu, 2008-11-06 at 22:20 +0100, Kern Sibbald wrote:
 On Thursday 06 November 2008 22:02:26 Alex Chekholko wrote:
  On Wed, 5 Nov 2008 16:12:51 +0100
 
  Kern Sibbald [EMAIL PROTECTED] wrote:
   For writing to tape (providing it is LTO-n) I strongly recommend a block
   size not to exceed 256K.
 
  Hi Kern,
 
  Why do you say that?  
 
 It is my experience with my own testing, and I asked the Quantum technical 
 gurus about using large blocks. They think it is not a good idea at all using 
 values larger than 512K and prefer as I do values around 256K.  The bigger it 
 is the more likely the tape writing will get out of phase and IMO the gain is 
 not worth the possible problems.
 
 
  Is this thread relevant?: 
  http://www.mail-archive.com/[EMAIL PROTECTED]/msg01246.htm
 l
 
 Possibly.
 
 
  Also, I would like to corroborate the OP's experiences; I had an almost
  identical thread about small block size and slow write speed:
  http://www.nabble.com/LTO-4-performance--td17407840.html
 
  In fact, I was unable to get higher block sizes working at all with
  btape:
  http://www.adsm.org/lists/html/Bacula-users/2008-05/msg00504.html
 
  So I am still stuck at ~22MB/s writing to LTO-4 with the default block
  size.
 
 There are a lot of other parameters to consider, but I cannot give such 
 advice 
 any more -- no time:
 
 - Up the block size to 128K or 256K and verify that it is being written that 
 size.

Hi,

Be warned!  Changing this parameter will deny access to existing
backup data.



 - Increase the Maximum File Size to about 5GB.


Are existing data still accessible when increasing
Maximum File Size ?  i hope so

BR
Ulrich

 - Use only *very* fast RAID disks running at 15,000 rpm.  Maybe soon we can 
 use SSD. 
 
 - Get only the best disk and tape controllers.
 
 - Get good quality, big, fast hardware -- you need hardware experts to get 
 lots of speed.
 
 Then you need to do the same kinds of tuning of your network.
 
 Regards,
 
 Kern
 
 
 -
 This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
 Build the coolest Linux based applications with Moblin SDK  win great prizes
 Grand prize is a trip for two to an Open Source event anywhere in the world
 http://moblin-contest.org/redirect.php?banner_id=100url=/
 ___
 Bacula-devel mailing list
 [EMAIL PROTECTED]
 https://lists.sourceforge.net/lists/listinfo/bacula-devel

-- 
Ulrich Leodolter [EMAIL PROTECTED]
OBVSG


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] What new feature are you waiting for?

2008-11-07 Thread Erik Logtenberg
Hi,

 Synthetic full backups or consolidation. A feature that is in the 
 development queue and could (in my opinion) be one of the major new 
 things in a 3.1 release, i.e. perhaps next year.
 
 To learn more, search the bacula-devel list archive for subjects 
 containing Synthetic or Consolidation - you'll find that, if 
 someone invests money or programmer's time, this project could be started.

What kind of funding are we talking about here?


Erik.

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Warning: VSS was not initialized properly. VSS support is disabled.

2008-11-07 Thread Jon Ingason
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I see that that pepole on the list has problem with this, but I can't
see no solution.

Is there a solution to this?

I am backing up some Windows 2008 64bit and using Bacula win32 2.4.3.
- --
Regards

Jon Ingason

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJFEskWn396VE8BCsRAkKdAKCbQ6qIp2Rq6NvZN4TvvMNrC+jdmwCdFauC
oCdIewvwvleEmIO2H2w/Eio=
=vQfk
-END PGP SIGNATURE-

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] bacula and MySQL license

2008-11-07 Thread LeJav
Hello,

I am preparing a NFS server (Linux) which is a part of a global project for a 
customer.
This NFS server will be backuped with bacula; I use MySQL for the database.
Could someone explain me if I am right with MySQL licencing ?
MySQL is only used for the bacula data.
My global project is not GPL; but my NFS Server and bacula are GPL.
Can I install bacula and MySQL on this server with respect to GPL licencing ?

Thx for your answers.


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula and MySQL license

2008-11-07 Thread Silver Salonen
On Friday 07 November 2008 15:57:52 LeJav wrote:
 Hello,
 
 I am preparing a NFS server (Linux) which is a part of a global project for 
a customer.
 This NFS server will be backuped with bacula; I use MySQL for the database.
 Could someone explain me if I am right with MySQL licencing ?
 MySQL is only used for the bacula data.
 My global project is not GPL; but my NFS Server and bacula are GPL.
 Can I install bacula and MySQL on this server with respect to GPL licencing 
?
 
 Thx for your answers.

Yes, you're OK. You're only affected by GPL licence if you want to change the 
code of either MySQL or Bacula. Otherwise it doesn't matter.

--
Silver

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula and MySQL license

2008-11-07 Thread Dan Langille

On Nov 7, 2008, at 8:57 AM, LeJav wrote:

 Hello,

 I am preparing a NFS server (Linux) which is a part of a global  
 project for a customer.
 This NFS server will be backuped with bacula; I use MySQL for the  
 database.
 Could someone explain me if I am right with MySQL licencing ?
 MySQL is only used for the bacula data.
 My global project is not GPL; but my NFS Server and bacula are GPL.
 Can I install bacula and MySQL on this server with respect to GPL  
 licencing ?


I cannot imagine any circumstances under which this would not be  
allowed.

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





-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Forcing volume change.

2008-11-07 Thread Arno Lehmann
Hi,

07.11.2008 11:10, Fábio Catunda wrote:
 Hi list.
 
 This is my first message to the list, I'm new on bacula, if some 
 information is missing, please, just ask and I promise that next time 
 the information will be in the first e-mail.
 
 Bacula version: 1.38.11 (28 June 2006) Debian package.

A very good start to include that information.
And - your Bacula is outdated. You should upgrade as soon as possible. 
Recebt versions not only add new features but also fix serious issues.

 I have a storage, so I'm using file storage. Everything was fine until 
 the volume I created got about 50GB of data, then I saw that it was 
 taking too long to restore some files. Search google for help I got to:
 http://bacula.org/en/rel-manual/Basic_Volume_Management.html#SECTION002611000
 
 Great. So I made the following config (relevant sections only):
 in bacula-sd:
 
 Device {
   Name = Default
   Media Type = File
   Archive Device = /backup/bacula
   LabelMedia = yes;
   Random Access = Yes;
   AutomaticMount = yes;
   RemovableMedia = no;
   AlwaysOpen = no;
 }
 
 And in bacula-dir.conf:
 JobDefs {
   Name = ETC
   Type = Backup
   Level = Incremental
   FileSet = ETC
   Schedule = WeeklyCycle
   Storage = File
   Messages = Standard
   Pool = Default
   Priority = 10
 }
 
 Pool {
   Name = Default
   Pool Type = Backup
   Recycle = yes
   AutoPrune = yes
   Volume Retention = 180 days
   Volume Use Duration = 23h
   LabelFormat = Backup-${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}
 }
 
 Storage {
   Name = File
   Address = hefesto.mydomain.com.br
   SDPort = 9103
   Password = ThisIsMyPassword
   Device = Default
   Media Type = File
 }
 
 I was expecting a volume cycle, but more than 23h has passed and still 
 no new volume in my default pool.

That's probably because your existing volume still uses the original 
information. What you set in the pool configuration is merely a 
template used when creating new volumes, so you need to update the 
existing volume. In bconsole, the command to use is - surprise! - 
'update'.

 I would like to know what is wrong, any tip is appreciated. Also, is 
 there a way to force a volume creation? I would like to run some backups 
 today (fryday) in a new volume, just in case.

You could also simply set the volume status to Used and use the 
'label' command to create a new volume.

Arno

 Thanks for the help.
 
 Fábio Catunda.

-- 
Arno Lehmann
IT-Service Lehmann
Sandstr. 6, 49080 Osnabrück
www.its-lehmann.de

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula and MySQL license

2008-11-07 Thread Jose Ildefonso Camargo Tolosa
Hi!

On Sat, Nov 8, 2008 at 9:27 AM, LeJav [EMAIL PROTECTED] wrote:
 Hello,

 I am preparing a NFS server (Linux) which is a part of a global project for a 
 customer.
 This NFS server will be backuped with bacula; I use MySQL for the database.
 Could someone explain me if I am right with MySQL licencing ?
 MySQL is only used for the bacula data.
 My global project is not GPL; but my NFS Server and bacula are GPL.
 Can I install bacula and MySQL on this server with respect to GPL licencing ?

If your business is services, you have no problem at all, if you are
doing some sort of closed source software development, it would be
necessary to analyze the particular case.


 Thx for your answers.


 -
 This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
 Build the coolest Linux based applications with Moblin SDK  win great prizes
 Grand prize is a trip for two to an Open Source event anywhere in the world
 http://moblin-contest.org/redirect.php?banner_id=100url=/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] Fwd: 64bit for File.FileId

2008-11-07 Thread Kern Sibbald
Hello,

Bacula can handle 64 bit FileId fields, but unfortunately, I forget exactly 
the version where all the work was done.  However, I am sure that version 
2.4.x does contain all the necessary modifications so that it will work.

We are sure it is working because Eric has been running with 64 bit 
(bigserial) PostgreSQL FileIds for quite some time.  Eric can fill you in on 
the steps that are necessary to make it work.  Currently, upgrading from 32 
bit FileIds to 64 bit is a manual exercise, but with the next major release 
(around the end of the year) we are planning to make it the default.

Best regards,

Kern

PS: I would be interested to hear about your setup since you seem to have 
quite big backup needs.

On Friday 07 November 2008 15:23:01 Dan Langille wrote:
 Sorry, I meant this for devel@

 Begin forwarded message:
  From: Dan Langille [EMAIL PROTECTED]
  Date: November 7, 2008 8:02:13 AM EST
  To: bacula-users bacula-users@lists.sourceforge.net
  Subject: [Bacula-users] 64bit for File.FileId
 
  I know I've seen something about moving to BIGSERIAL but don't know
  where.  Does someone have a patch.
 
  Please CC the original poster who would like to fix this before the
  weekend backups.
 
  Begin forwarded message:
  From: James Cort [EMAIL PROTECTED]
  Date: November 7, 2008 4:50:59 AM EST
  To: bacula-users bacula-users@lists.sourceforge.net
  Subject: [Bacula-users] Ran out of fileid's in postgres-backed
  database
 
  I appear to have run out of fileids in my bacula database.
 
  I'm using bacula 2.2.8-8~bpo40+1  (the Debian Etch backported
  package)
  and my backups have failed with the error:
 
  Fatal error: Can't fill File table Query failed: INSERT INTO File
  (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT
  batch.FileIndex, batch.JobId, Path.PathId,
  Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
  (batch.Path = Path.Path) JOIN Filename ON (batch.Name =
  Filename.Name):
  ERR=ERROR:  integer out of range
 
 
  I'm using Postgres as the backend and I note from the script which
  bacula uses to setup the table file that fileid is of type serial.
 
  bacula= select max(fileid) from file;
max
  
  2147272756
  (1 row)
 
  2^31=2147483648
 
 
  Postgresql's documentation states:
 
  The type names serial and serial4 are equivalent: both create
  integer
  columns. The type names bigserial and serial8 work just the same way,
  except that they create a bigint column. bigserial should be used if
  you
  anticipate the use of more than 2^31 identifiers over the lifetime of
  the table.
 
  ... but I'm not too keen on doing this unless I can be sure it won't
  have a knock-on effect on Bacula.
 
  What can I do to fix this?
 
 
  James
 
  --
  U4EA Technologies
  http://www.u4eatech.com
 
 
  
 - This SF.Net email is sponsored by the Moblin Your Move Developer's
  challenge
  Build the coolest Linux based applications with Moblin SDK  win
  great prizes
  Grand prize is a trip for two to an Open Source event anywhere in
  the world
  http://moblin-contest.org/redirect.php?banner_id=100url=/
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users
 
  --
  Dan Langille
  http://langille.org/
 
 
 
 
 
  -
  This SF.Net email is sponsored by the Moblin Your Move Developer's
  challenge
  Build the coolest Linux based applications with Moblin SDK  win
  great prizes
  Grand prize is a trip for two to an Open Source event anywhere in
  the world
  http://moblin-contest.org/redirect.php?banner_id=100url=/
  ___
  Bacula-users mailing list
  Bacula-users@lists.sourceforge.net
  https://lists.sourceforge.net/lists/listinfo/bacula-users



-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Fwd: Re: [Bacula-devel] Fwd: 64bit for File.FileId

2008-11-07 Thread Eric Bollengier
Hello,

We have a patch for that, this is scheduled for the 3.0.0 version.
trunk/patches/testing/fileid64.patch

Modifications are quite simple (postgresql part)

BEGIN;
ALTER TABLE file ALTER fileid TYPE bigint ;
ALTER TABLE basefiles ALTER fileid TYPE bigint;
COMMIT;

The serial counter doesn't need to be modified.

= This will take time and space (2x the actual db size)

And, also a typedef in src/cats/cats.h
-typedef uint32_t FileId_t;
+typedef uint64_t FileId_t;

which is less critical, but needs to recompile the director.

James, please, can you fill the testimonial page on www.bacula.org, your setup 
seems to be very cool :) (it can be anonymous)

Bye


Le Friday 07 November 2008 15:23:01 Dan Langille, vous avez écrit :
 Sorry, I meant this for devel@

 Begin forwarded message:
  From: Dan Langille [EMAIL PROTECTED]
  Date: November 7, 2008 8:02:13 AM EST
  To: bacula-users bacula-users@lists.sourceforge.net
  Subject: [Bacula-users] 64bit for File.FileId
 
  I know I've seen something about moving to BIGSERIAL but don't know
  where.  Does someone have a patch.
 
  Please CC the original poster who would like to fix this before the
  weekend backups.
 
  Begin forwarded message:
  From: James Cort [EMAIL PROTECTED]
  Date: November 7, 2008 4:50:59 AM EST
  To: bacula-users bacula-users@lists.sourceforge.net
  Subject: [Bacula-users] Ran out of fileid's in postgres-backed
  database
 
  I appear to have run out of fileids in my bacula database.
 
  I'm using bacula 2.2.8-8~bpo40+1  (the Debian Etch backported
  package)
  and my backups have failed with the error:
 
  Fatal error: Can't fill File table Query failed: INSERT INTO File
  (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT
  batch.FileIndex, batch.JobId, Path.PathId,
  Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
  (batch.Path = Path.Path) JOIN Filename ON (batch.Name =
  Filename.Name):
  ERR=ERROR:  integer out of range
 
 
  I'm using Postgres as the backend and I note from the script which
  bacula uses to setup the table file that fileid is of type serial.
 
  bacula= select max(fileid) from file;
max
  
  2147272756
  (1 row)
 
  2^31=2147483648
 
 
  Postgresql's documentation states:
 
  The type names serial and serial4 are equivalent: both create
  integer
  columns. The type names bigserial and serial8 work just the same way,
  except that they create a bigint column. bigserial should be used if
  you
  anticipate the use of more than 2^31 identifiers over the lifetime of
  the table.
 
  ... but I'm not too keen on doing this unless I can be sure it won't
  have a knock-on effect on Bacula.
 
  What can I do to fix this?
 
 
  James
 
  --
  U4EA Technologies
  http://www.u4eatech.com
 

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/bacula-devel


---

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] Fwd: 64bit for File.FileId

2008-11-07 Thread James Cort
I had hoped to avoid upgrading to 2.4 because I've got a lot of FDs
using much older versions of baculabut if I must I must

 PS: I would be interested to hear about your setup since you seem to have 
 quite big backup needs.

About 20 servers, several million files and around 8-900GB per night.
The big killer is the mail server which is courier-imap with a maildir
backend - every email is a file and they get fairly unique names.

I think I've hit this problem not because of the size of the database
but because of how Postgres works - serial numbers aren't reused and
looking at the postgres dump, a dump/reload probably doesn't regenerate
them from zero.  Well, I doubt it will because the serial numbers are
present in the SQL dump.  The table itself doesn't have anything like
2^31 entries:

bacula=# select count(fileid) from file;
   count
---
 174610251
(1 row)


I've been using Bacula for almost three years so that's 3 years worth of
fileids there.

-- 
James Cort

IT Manager
U4EA Technologies Ltd.

-- 
U4EA Technologies
http://www.u4eatech.com


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula and MySQL license

2008-11-07 Thread LeJav
Thx everbody for your answer.

 Hello,

 I am preparing a NFS server (Linux) which is a part of a global project for
 a customer.
 This NFS server will be backuped with bacula; I use MySQL for the database.
 Could someone explain me if I am right with MySQL licencing ?
 MySQL is only used for the bacula data.
 My global project is not GPL; but my NFS Server and bacula are GPL.
 Can I install bacula and MySQL on this server with respect to GPL licencing
 ?

 Thx for your answers.
 
 Yes, you're OK. You're only affected by GPL licence if you want to change the
 code of either MySQL or Bacula. Otherwise it doesn't matter.
 

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] 64bit for File.FileId

2008-11-07 Thread Dan Langille
I know I've seen something about moving to BIGSERIAL but don't know
where.  Does someone have a patch.

Please CC the original poster who would like to fix this before the
weekend backups.

Begin forwarded message:

 From: James Cort [EMAIL PROTECTED]
 Date: November 7, 2008 4:50:59 AM EST
 To: bacula-users bacula-users@lists.sourceforge.net
 Subject: [Bacula-users] Ran out of fileid's in postgres-backed  
 database

 I appear to have run out of fileids in my bacula database.

 I'm using bacula 2.2.8-8~bpo40+1  (the Debian Etch backported package)
 and my backups have failed with the error:

 Fatal error: Can't fill File table Query failed: INSERT INTO File
 (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT
 batch.FileIndex, batch.JobId, Path.PathId,
 Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
 (batch.Path = Path.Path) JOIN Filename ON (batch.Name =  
 Filename.Name):
 ERR=ERROR:  integer out of range


 I'm using Postgres as the backend and I note from the script which
 bacula uses to setup the table file that fileid is of type serial.

 bacula= select max(fileid) from file;
max
 
 2147272756
 (1 row)

 2^31=2147483648


 Postgresql's documentation states:

 The type names serial and serial4 are equivalent: both create integer
 columns. The type names bigserial and serial8 work just the same way,
 except that they create a bigint column. bigserial should be used if  
 you
 anticipate the use of more than 2^31 identifiers over the lifetime of
 the table.

 ... but I'm not too keen on doing this unless I can be sure it won't
 have a knock-on effect on Bacula.

 What can I do to fix this?


 James

 -- 
 U4EA Technologies
 http://www.u4eatech.com


 -
 This SF.Net email is sponsored by the Moblin Your Move Developer's  
 challenge
 Build the coolest Linux based applications with Moblin SDK  win  
 great prizes
 Grand prize is a trip for two to an Open Source event anywhere in  
 the world
 http://moblin-contest.org/redirect.php?banner_id=100url=/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

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





-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula and MySQL license

2008-11-07 Thread Jose Ildefonso Camargo Tolosa
On Sat, Nov 8, 2008 at 9:52 AM, Dan Langille [EMAIL PROTECTED] wrote:

 On Nov 7, 2008, at 8:57 AM, LeJav wrote:

 Hello,

 I am preparing a NFS server (Linux) which is a part of a global
 project for a customer.
 This NFS server will be backuped with bacula; I use MySQL for the
 database.
 Could someone explain me if I am right with MySQL licencing ?
 MySQL is only used for the bacula data.
 My global project is not GPL; but my NFS Server and bacula are GPL.
 Can I install bacula and MySQL on this server with respect to GPL
 licencing ?


 I cannot imagine any circumstances under which this would not be
 allowed.

Yes, there are: say that the project is a propiertary backup
solution, and that the company wants to use bacula and/or mysql code
for their non-gpl backup solution: they can't do that.


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





 -
 This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
 Build the coolest Linux based applications with Moblin SDK  win great prizes
 Grand prize is a trip for two to an Open Source event anywhere in the world
 http://moblin-contest.org/redirect.php?banner_id=100url=/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] MaximumBlockSize Problem and Question

2008-11-07 Thread T. Horsnell
Eric Bollengier wrote:
 Le Friday 07 November 2008 14:36:46 Kern Sibbald, vous avez écrit :
 On Friday 07 November 2008 13:19:45 Ralf Gross wrote:
 Kern Sibbald schrieb:
 On Thursday 06 November 2008 22:47:41 Ralf Gross wrote:
 Alex Chekholko schrieb:
 On Wed, 5 Nov 2008 16:12:51 +0100

 Kern Sibbald [EMAIL PROTECTED] wrote:
 For writing to tape (providing it is LTO-n) I strongly recommend
 a block size not to exceed 256K.
 Hi Kern,

 Why do you say that?  Is this thread relevant?:
 http://www.mail-archive.com/[EMAIL PROTECTED]/msg0
 12 46.h tml

 Also, I would like to corroborate the OP's experiences; I had an
 almost identical thread about small block size and slow write
 speed: http://www.nabble.com/LTO-4-performance--td17407840.html

 In fact, I was unable to get higher block sizes working at all with
 btape:
 http://www.adsm.org/lists/html/Bacula-users/2008-05/msg00504.html

 So I am still stuck at ~22MB/s writing to LTO-4 with the default
 block size.
 I don't think that the blocksize is the problem. I did some tests but
 couldn't get higher results with larger blocksizes. I get 75-85 MB/s
 with the default bs and no additional tuning.
 That is probably correct, but most likely only because you have a
 bottleneck elsewhere -- probably in one of the points I mentioned.  The
 speed is always capped by the slowest component. Once you remove the
 other bottlenecks on your system, the blocksize will very likely become
 the bottleneck and then you can measure the difference.
 I didn't want to compain, just show the org. poster that his 22 MB/s
 are likely not a bs issue.

 That being said, I started a thread on the user list a while ago where
 I aked what throughput people are getting when writing to tape. Nobody
 involved in this thread got higher numbers than 80-85 MB/s for a
 single job.
 That is probably reasonable for one job, but if you are writing to an
 LTO-2,3, or 4, we know that with multiple simultaneous jobs it is possible
 to get write speeds of 150 MB/sec.

 Kern
 
 This is with a good hardware compression rate, but it's a very good test, 
 IMHO, more than using random data to get only 80MB/sec. If you able to write 
 at 150MB/s, i'm pretty sure that you will be able to write at 80MB/s... Even 
 if your source file is made with a dd if=/dev/zero, your harddisk, your 
 network, your SCSI/SAS or whatever controler have to handle it like real 
 data.
 


I've done extensive throughput experiments on my Dell LTO4 and have 
never managed to get the advertised streaming-rate of 120MBytes/sec.
Even writing a stream ov zeros to the drive with hardware-compression 
turned on only gets me 100MBytes/sec.


All zeros without compression:
[root]# mt -f /dev/st0 compression 0
[root]# dd if=/dev/zero of=/dev/nst0 bs=100 count=1
100 bytes (10 GB) copied, 107.498 seconds, 93.0 MB/s

All zeros with compression:
[root]# mt -f /dev/st0 compression 1
[root]# dd if=/dev/zero of=/dev/nst0 bs=100 count=1
100 bytes (10 GB) copied, 100.147 seconds, 99.9 MB/s

gzip for comparison:

On a 1.6GHz Xeon box:
[root]# dd if=/dev/zero  bs=100 count=1 | gzip -c | wc -c
100 bytes (10 GB) copied, 135.79 seconds, 73.6 MB/s
gives a compression ratio of 1030:1

And on a 2.9GHz Xeon box:
[root]#  dd if=/dev/zero bs=100 count=1 | gzip -c | wc -c
100 bytes (10 GB) copied, 76.6102 seconds, 131 MB/s


Cheers,
Terry







-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Ran out of fileid's in postgres-backed database

2008-11-07 Thread James Cort
I appear to have run out of fileids in my bacula database.

I'm using bacula 2.2.8-8~bpo40+1  (the Debian Etch backported package)
and my backups have failed with the error:

Fatal error: Can't fill File table Query failed: INSERT INTO File
(FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT
batch.FileIndex, batch.JobId, Path.PathId,
Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
(batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name):
ERR=ERROR:  integer out of range


I'm using Postgres as the backend and I note from the script which
bacula uses to setup the table file that fileid is of type serial.

bacula= select max(fileid) from file;
max

 2147272756
(1 row)

2^31=2147483648


Postgresql's documentation states:

The type names serial and serial4 are equivalent: both create integer
columns. The type names bigserial and serial8 work just the same way,
except that they create a bigint column. bigserial should be used if you
anticipate the use of more than 2^31 identifiers over the lifetime of
the table.

... but I'm not too keen on doing this unless I can be sure it won't
have a knock-on effect on Bacula.

What can I do to fix this?


James

-- 
U4EA Technologies
http://www.u4eatech.com


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Question about tape labels

2008-11-07 Thread Hemant Shah

Folks,

  I have setup bacula to automatic label the tapes, so when I do stat dir I 
get following output:

Level  Type Pri  Scheduled  Name   Volume
=
Full   Backup 5  07-Nov-08 20:00lidp4-FullBackupToTape *unknown*
Full   Backup 5  07-Nov-08 20:00lidp7-FullBackupToTape *unknown*
Full   Backup 5  07-Nov-08 20:00lidp5-FullBackupToTape *unknown*
Full   Backup 5  07-Nov-08 20:00lidp9-FullBackupToTape *unknown*
Full   Backup 5  07-Nov-08 20:00lidp11-FullBackupToTape 
*unknown*
Full   Backup 5  07-Nov-08 20:00lidp18-FullBackupToTape 
*unknown*


I was testing my script that checks for the tape in the drive
and makes sure that the tape is unlabeled, so I labeled the tape as testvol. 
After I was done testing, I removed the label from the tape.

When I ran stat dir command I noticed that bacula would use the tape labeled 
testvol:


Level  Type Pri  Scheduled  Name   Volume
===
Full   Backup 5  07-Nov-08 20:00lidp4-FullBackupToTape testvol
Full   Backup 5  07-Nov-08 20:00lidp7-FullBackupToTape testvol
Full   Backup 5  07-Nov-08 20:00lidp5-FullBackupToTape testvol
Full   Backup 5  07-Nov-08 20:00lidp9-FullBackupToTape testvol
Full   Backup 5  07-Nov-08 20:00lidp11-FullBackupToTape testvol
Full   Backup 5  07-Nov-08 20:00lidp18-FullBackupToTape testvol


I deleted the volume from the database and stat dir displayed *unknown* as 
tape label.

If bacula was configured to automatically label the tape why did it choose the 
testvol as label?

If I had not deleted the volume what would have happened?
 1) Bacula would try to use testvol and fail because tape was not labeled.
 2) It would automatically label the tape based upon Label Format.
 3) Ask me to insert tape with testvol label.

If the tape was labeled as testvol what would have happened?
 1) Bacula would have used testvol and continued with backup
 2) Ask me for the new unlabeled tape because it had wrong label

Thanks.

Hemant Shah
E-mail: [EMAIL PROTECTED]


  

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Forcing volume change.

2008-11-07 Thread Fábio Catunda
Hi list.

This is my first message to the list, I'm new on bacula, if some 
information is missing, please, just ask and I promise that next time 
the information will be in the first e-mail.

Bacula version: 1.38.11 (28 June 2006) Debian package.

I have a storage, so I'm using file storage. Everything was fine until 
the volume I created got about 50GB of data, then I saw that it was 
taking too long to restore some files. Search google for help I got to:
http://bacula.org/en/rel-manual/Basic_Volume_Management.html#SECTION002611000

Great. So I made the following config (relevant sections only):
in bacula-sd:

Device {
  Name = Default
  Media Type = File
  Archive Device = /backup/bacula
  LabelMedia = yes;
  Random Access = Yes;
  AutomaticMount = yes;
  RemovableMedia = no;
  AlwaysOpen = no;
}

And in bacula-dir.conf:
JobDefs {
  Name = ETC
  Type = Backup
  Level = Incremental
  FileSet = ETC
  Schedule = WeeklyCycle
  Storage = File
  Messages = Standard
  Pool = Default
  Priority = 10
}

Pool {
  Name = Default
  Pool Type = Backup
  Recycle = yes
  AutoPrune = yes
  Volume Retention = 180 days
  Volume Use Duration = 23h
  LabelFormat = Backup-${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}
}

Storage {
  Name = File
  Address = hefesto.mydomain.com.br
  SDPort = 9103
  Password = ThisIsMyPassword
  Device = Default
  Media Type = File
}

I was expecting a volume cycle, but more than 23h has passed and still 
no new volume in my default pool.

I would like to know what is wrong, any tip is appreciated. Also, is 
there a way to force a volume creation? I would like to run some backups 
today (fryday) in a new volume, just in case.

Thanks for the help.

Fábio Catunda.


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [Bacula-devel] MaximumBlockSize Problem and Question

2008-11-07 Thread Kern Sibbald
On Friday 07 November 2008 10:55:57 Ulrich Leodolter wrote:
 On Thu, 2008-11-06 at 22:20 +0100, Kern Sibbald wrote:
  On Thursday 06 November 2008 22:02:26 Alex Chekholko wrote:
   On Wed, 5 Nov 2008 16:12:51 +0100
  
   Kern Sibbald [EMAIL PROTECTED] wrote:
For writing to tape (providing it is LTO-n) I strongly recommend a
block size not to exceed 256K.
  
   Hi Kern,
  
   Why do you say that?
 
  It is my experience with my own testing, and I asked the Quantum
  technical gurus about using large blocks. They think it is not a good
  idea at all using values larger than 512K and prefer as I do values
  around 256K.  The bigger it is the more likely the tape writing will get
  out of phase and IMO the gain is not worth the possible problems.
 
   Is this thread relevant?:
   http://www.mail-archive.com/[EMAIL PROTECTED]/msg01246
  .htm l
 
  Possibly.
 
   Also, I would like to corroborate the OP's experiences; I had an almost
   identical thread about small block size and slow write speed:
   http://www.nabble.com/LTO-4-performance--td17407840.html
  
   In fact, I was unable to get higher block sizes working at all with
   btape:
   http://www.adsm.org/lists/html/Bacula-users/2008-05/msg00504.html
  
   So I am still stuck at ~22MB/s writing to LTO-4 with the default block
   size.
 
  There are a lot of other parameters to consider, but I cannot give such
  advice any more -- no time:
 
  - Up the block size to 128K or 256K and verify that it is being written
  that size.

 Hi,

 Be warned!  Changing this parameter will deny access to existing
 backup data.


  - Increase the Maximum File Size to about 5GB.

 Are existing data still accessible when increasing
 Maximum File Size ?  i hope so

Changing the Maximum File Size is completely upwards/downwards compatible, 
with the reservation that if you make it too small you will incur increased 
overhead, and if you make it larger, it may take longer to recover files. 

Changing the tape block size can create compatibility problems.

Regards,

Kern


 BR
 Ulrich

  - Use only *very* fast RAID disks running at 15,000 rpm.  Maybe soon we
  can use SSD.
 
  - Get only the best disk and tape controllers.
 
  - Get good quality, big, fast hardware -- you need hardware experts to
  get lots of speed.
 
  Then you need to do the same kinds of tuning of your network.
 
  Regards,
 
  Kern
 
 
  -
  This SF.Net email is sponsored by the Moblin Your Move Developer's
  challenge Build the coolest Linux based applications with Moblin SDK 
  win great prizes Grand prize is a trip for two to an Open Source event
  anywhere in the world
  http://moblin-contest.org/redirect.php?banner_id=100url=/
  ___
  Bacula-devel mailing list
  [EMAIL PROTECTED]
  https://lists.sourceforge.net/lists/listinfo/bacula-devel



-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Running different concurrent client backups to different FileStorages

2008-11-07 Thread Crawford Rainwater
- Chad Walstrom [EMAIL PROTECTED] wrote:
 Crawford Rainwater [EMAIL PROTECTED] wrote:
  What I have tried is creating a FileStore-1 and FileStorage-2 along
  with Device-1 and Device-2 all of Type = File.  The backup jobs
  (Job-1 and Job-2) will write to their respective places on the same
  system.
 
 I just set something like this up as well, however in reading the
 manual, I noted that the Type must also be unique between the two. 
 The
 type File is misleading, as what determines whether the backup
 media
 is file-based or tape-based is bacula examining the path you've given
 it.
 

Chad:

Correct on that as well.  What I did in this case was make a File-1 and 
File-2 to correspond with Client-1 and Client-2 and such accordingly.  
This helped with separating things out, and also making the bacula-dir.conf 
file a bit large.

--- Crawford

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] What new feature are you waiting for?

2008-11-07 Thread Dan Langille

On Nov 7, 2008, at 4:02 AM, Tilman Schmidt wrote:

 On Thu, 6 Nov 2008 22:14:08 -0500, Dan Langille wrote:
 On Nov 6, 2008, at 5:23 AM, Tilman Schmidt wrote:

 Am 05.11.2008 22:03 schrieb Dan Langille:
 - Bacula has known how to use the current tape that is a drive  
 for a
 long time
 now.  It is discouraged, but just a matter of configuration.

 I'm sorry but I'm starting to have serious doubts about that.
 I have been trying for a long time and in many different ways
 to get that to work, and each time I ask a question here why
 my latest attempt doesn't work either, the answer is post
 config, post log, and then: silence.

 What can I say?  I'm not responsible for people not answering.
 Nor is anybody else.  That's how it works.  Or more precisely,
 doesn't.

 Sure. I'm not complaining about that. Sorry if my answer came
 across as such. But the fact that nobody could come up with an
 answer might indicate that the answer doesn't exist.

Or more simply, it could mean that the people who know have
not answered. :)

 And if it is discouraged, what is the recommended alternative?

 Work with Bacula, not against it.  I don't know what more to say.

 Sure, and I'm trying my best to do exactly that. But the topic
 of this thread is desirable new features for Bacula, ie. things
 that currently cannot be done but would be nice if they could.

Well, for what it's worth: that seems to be how people have
interpreted it.

The intention of this thread was what new feature in the upcoming
release are you waiting for?.  My first sentence in the first post
was:

'With the upcoming release of Bacula, what new feature are you waiting  
for?

But no worries.  The thread is good.  :)

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





-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] next tape autolabel source

2008-11-07 Thread John Drescher
On Fri, Nov 7, 2008 at 7:39 AM, James Harper
[EMAIL PROTECTED] wrote:
 Quick question - I've been looking through the docs and the source code
 and can't find the answer - where does bacula store the counter for the
 next tape label number?


It does not. It gets that from the database. In old versions it took
the count of the current tapes in the pool and used that as the
number. This has a flaw if any tapes are deleted it will try to number
the tape the same as a previous tape. The new system increments the
highest volume id throught the whole system and that is the next tape
number.

John

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula and MySQL license

2008-11-07 Thread Rich
On 2008.11.07. 16:21, Silver Salonen wrote:
 On Friday 07 November 2008 15:57:52 LeJav wrote:
 Hello,

 I am preparing a NFS server (Linux) which is a part of a global project for 
 a customer.
 This NFS server will be backuped with bacula; I use MySQL for the database.
 Could someone explain me if I am right with MySQL licencing ?
 MySQL is only used for the bacula data.
 My global project is not GPL; but my NFS Server and bacula are GPL.
 Can I install bacula and MySQL on this server with respect to GPL licencing 
 ?
 Thx for your answers.
 
 Yes, you're OK. You're only affected by GPL licence if you want to change the 
 code of either MySQL or Bacula. Otherwise it doesn't matter.

actually, you can change code as hell. gpl will only kick in if you will 
_distribute_ said code.

 --
 Silver
-- 
  Rich

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula and MySQL license

2008-11-07 Thread Rich
On 2008.11.07. 18:39, Jose Ildefonso Camargo Tolosa wrote:
 On Sat, Nov 8, 2008 at 9:52 AM, Dan Langille [EMAIL PROTECTED] wrote:
 On Nov 7, 2008, at 8:57 AM, LeJav wrote:

 Hello,

 I am preparing a NFS server (Linux) which is a part of a global
 project for a customer.
 This NFS server will be backuped with bacula; I use MySQL for the
 database.
 Could someone explain me if I am right with MySQL licencing ?
 MySQL is only used for the bacula data.
 My global project is not GPL; but my NFS Server and bacula are GPL.
 Can I install bacula and MySQL on this server with respect to GPL
 licencing ?

 I cannot imagine any circumstances under which this would not be
 allowed.
 
 Yes, there are: say that the project is a propiertary backup
 solution, and that the company wants to use bacula and/or mysql code
 for their non-gpl backup solution: they can't do that.

please, please, don't do this.
they can change the code until nobody can recognise it or whatever. they 
can molest, abuse, ridicule that code. as long as it stays inhouse, it's 
their choice.
now, if they modify and distribute the modified code... yes, now gpl 
kicks in and requires publishing changes (actually, that's not true 
either, they have to provide source to the receivers of the modifications).

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

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] next tape autolabel source

2008-11-07 Thread James Harper
Quick question - I've been looking through the docs and the source code
and can't find the answer - where does bacula store the counter for the
next tape label number?

Thanks

James

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Moving from Tape to DVD

2008-11-07 Thread Jari Fredriksson
 
I just bought a Plextor DVD-writer, 100 DVD-RW disks, and a bag for them.

Now wondering best practises with DVD backups.

My first backup is running, so configuration seems to be ok. However, I did not 
set Maximum Part Size. Should I? I see often used 800M as that. What good 
does it bring?

If the spool file is bigger than free space, that part will stay on harddisk? 
No way, I guess bacula does not create bigger parts than the free space on 
current media, right?

What other gotchas there might be?

My bacula-sd contains

Device {
  Name = DVD_RW#
  Media Type = DVD+RW
  Device Type = DVD
  Archive Device = /dev/hdc
  Requires Mount = Yes;
  Automatic Mount = Yes;  # when device opened, read it
  Offline On Unmount = Yes;
  Mount Point = /mnt/dvd
  Mount Command = /bin/mount -t iso9660 -o ro %a %m   # mount as Read 
Only to save DVD+RW from counting as written. Bacula still writes fine.
  Unmount Command = /bin/umount %m
  Write Part Command = /etc/bacula/scripts/dvd-handler %a write %e %v
  Free Space Command = /etc/bacula/scripts/dvd-handler %a free
  Always Open = yes;
  Removable Media = yes;
  Random Access = yes;
  Spool directory = /usr/local/srv/backup ;
  Maximum Spool Size = 20GB
  Maximum Job Spool Size = 10GB
}


bacula-dir contains

# Definition of DVD+RW storage device
Storage {
  Name = DVDRW-Drive
  Address = wellington.lan.dyn-o-saur.com # N.B. Use a fully qualified name here
  SDPort = 9103
  Password = xxx# password for Storage daemon
  Device = DVD_RW  # must be same as Device in Storage daemon
  Media Type = DVD+RW# must be same as MediaType in Storage daemon
  Maximum Concurrent Jobs = 1   # Only one job must be allowed to write to 
DVD
}


Any thoughts?



-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Moving from Tape to DVD

2008-11-07 Thread John Drescher
On Fri, Nov 7, 2008 at 3:14 PM, Jari Fredriksson [EMAIL PROTECTED] wrote:

 I just bought a Plextor DVD-writer, 100 DVD-RW disks, and a bag for them.

 Now wondering best practises with DVD backups.

 My first backup is running, so configuration seems to be ok. However, I did 
 not set Maximum Part Size. Should I? I see often used 800M as that. What 
 good does it bring?

 If the spool file is bigger than free space, that part will stay on harddisk? 
 No way, I guess bacula does not create bigger parts than the free space on 
 current media, right?

 What other gotchas there might be?

 My bacula-sd contains

 Device {
  Name = DVD_RW#
  Media Type = DVD+RW
  Device Type = DVD
  Archive Device = /dev/hdc
  Requires Mount = Yes;
  Automatic Mount = Yes;  # when device opened, read it
  Offline On Unmount = Yes;
  Mount Point = /mnt/dvd
  Mount Command = /bin/mount -t iso9660 -o ro %a %m   # mount as Read 
 Only to save DVD+RW from counting as written. Bacula still writes fine.
  Unmount Command = /bin/umount %m
  Write Part Command = /etc/bacula/scripts/dvd-handler %a write %e %v
  Free Space Command = /etc/bacula/scripts/dvd-handler %a free
  Always Open = yes;
  Removable Media = yes;
  Random Access = yes;
  Spool directory = /usr/local/srv/backup ;
  Maximum Spool Size = 20GB
  Maximum Job Spool Size = 10GB
 }


 bacula-dir contains

 # Definition of DVD+RW storage device
 Storage {
  Name = DVDRW-Drive
  Address = wellington.lan.dyn-o-saur.com # N.B. Use a fully qualified name 
 here
  SDPort = 9103
  Password = xxx# password for Storage daemon
  Device = DVD_RW  # must be same as Device in Storage daemon
  Media Type = DVD+RW# must be same as MediaType in Storage daemon
  Maximum Concurrent Jobs = 1   # Only one job must be allowed to write to 
 DVD
 }


 Any thoughts?


Make sure you have dvd+rw-tools-7.1 or greater. If you have a previous
version you will need to upgrade.

John

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Moving from Tape to DVD

2008-11-07 Thread Jari Fredriksson
 On Fri, Nov 7, 2008 at 3:14 PM, Jari Fredriksson
 [EMAIL PROTECTED] wrote: 
 
 
 Make sure you have dvd+rw-tools-7.1 or greater. If you
 have a previous version you will need to upgrade.
 

Thanks for the tip! I have latest Debian Etch+backports dvd+rw-tools which 
should be okay according to Bacula documentation.



-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] searching the bacula catalog for a filename with wildcards?

2008-11-07 Thread Bob Hetzel

Folks,

I've got a user who thinks a file was deleted but she isn't sure of the 
exact name or where it was in the file system.  Is there a command to 
search for a file with wildcards which could be anywhere in the catalog 
(where both the date it was backed up and the directory it lived in are 
not known)?

Barring that, what might the syntax of a mysql select command to do it?

   Bob

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Moving from Tape to DVD

2008-11-07 Thread Jari Fredriksson

Hmm.

[ 5053.929447] attempt to access beyond end of device
[ 5053.929447] hdc: rw=0, want=68, limit=4
[ 5053.929447] isofs_fill_super: bread failed, dev=hdc, iso_blknum=16, block=16
[ 5054.954192] attempt to access beyond end of device
[ 5054.954192] hdc: rw=0, want=68, limit=4
[ 5054.954192] isofs_fill_super: bread failed, dev=hdc, iso_blknum=16, block=16
[ 5055.009549] attempt to access beyond end of device
[ 5055.009549] hdc: rw=0, want=68, limit=4
[ 5055.009549] isofs_fill_super: bread failed, dev=hdc, iso_blknum=16, block=16
[ 5056.027985] attempt to access beyond end of device
[ 5056.027985] hdc: rw=0, want=68, limit=4
[ 5056.027985] isofs_fill_super: bread failed, dev=hdc, iso_blknum=16, block=16
[ 5948.257464] ISO 9660 Extensions: RRIP_1991A
[ 6097.944016] ISO 9660 Extensions: RRIP_1991A
[13464.702833] ISO 9660 Extensions: RRIP_1991A


Bacula job did not fail, but syslog and dmesg shows stuff like this.

I have not tried restore yet...



-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Forcing volume change.

2008-11-07 Thread Arno Lehmann
Hi,

07.11.2008 15:54, Fábio Catunda wrote:
 Arno,
 
 Thanks a lot, pretty simple. I just updated all informations running 
 update from console and selecting option 13, then status 1 showed
 07-Nov 12:46 hefesto-dir: Max configured use duration exceeded. Marking 
 Volume StorageDisk as Used.
 
 So I just ran a job and the new volume has been created:
 Volume name(s): Backup-2008-11-07

Good. That's what should have happened. (Note that, if you upgrade, 
volumes will not necessarily be purged by a 'status' command.)

 About my bacula version, do you think that the debian version have a lot 
 of problems?

I don't know if the debian team did anything to their versions of 
Bacula, but the release notes for Bacula document a huge number of bug 
fixes since version 2.0 only.

  I believe that the package maintainer use some patches to
 keep it stable, I'm I right?

I don't know. I guess backporting *all* the fixes to a 1.38 Bacula 
would be impossible, though.

Arno

 Anyway, really thanks for the tip, one more learned.
 
 Fábio Catunda.
 
 Arno Lehmann wrote:
 Hi,

 07.11.2008 11:10, Fábio Catunda wrote:
   
 Hi list.

 This is my first message to the list, I'm new on bacula, if some 
 information is missing, please, just ask and I promise that next time 
 the information will be in the first e-mail.

 Bacula version: 1.38.11 (28 June 2006) Debian package.
 
 A very good start to include that information.
 And - your Bacula is outdated. You should upgrade as soon as possible. 
 Recebt versions not only add new features but also fix serious issues.

   
 I have a storage, so I'm using file storage. Everything was fine until 
 the volume I created got about 50GB of data, then I saw that it was 
 taking too long to restore some files. Search google for help I got to:
 http://bacula.org/en/rel-manual/Basic_Volume_Management.html#SECTION002611000

 Great. So I made the following config (relevant sections only):
 in bacula-sd:

 Device {
   Name = Default
   Media Type = File
   Archive Device = /backup/bacula
   LabelMedia = yes;
   Random Access = Yes;
   AutomaticMount = yes;
   RemovableMedia = no;
   AlwaysOpen = no;
 }

 And in bacula-dir.conf:
 JobDefs {
   Name = ETC
   Type = Backup
   Level = Incremental
   FileSet = ETC
   Schedule = WeeklyCycle
   Storage = File
   Messages = Standard
   Pool = Default
   Priority = 10
 }

 Pool {
   Name = Default
   Pool Type = Backup
   Recycle = yes
   AutoPrune = yes
   Volume Retention = 180 days
   Volume Use Duration = 23h
   LabelFormat = Backup-${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}
 }

 Storage {
   Name = File
   Address = hefesto.mydomain.com.br
   SDPort = 9103
   Password = ThisIsMyPassword
   Device = Default
   Media Type = File
 }

 I was expecting a volume cycle, but more than 23h has passed and still 
 no new volume in my default pool.
 
 That's probably because your existing volume still uses the original 
 information. What you set in the pool configuration is merely a 
 template used when creating new volumes, so you need to update the 
 existing volume. In bconsole, the command to use is - surprise! - 
 'update'.

   
 I would like to know what is wrong, any tip is appreciated. Also, is 
 there a way to force a volume creation? I would like to run some backups 
 today (fryday) in a new volume, just in case.
 
 You could also simply set the volume status to Used and use the 
 'label' command to create a new volume.

 Arno

   
 Thanks for the help.

 Fábio Catunda.
 
   
 
 -
 This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
 Build the coolest Linux based applications with Moblin SDK  win great prizes
 Grand prize is a trip for two to an Open Source event anywhere in the world
 http://moblin-contest.org/redirect.php?banner_id=100url=/
 ___
 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

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula and MySQL license

2008-11-07 Thread Jose Ildefonso Camargo Tolosa
On Sat, Nov 8, 2008 at 12:38 PM, Rich [EMAIL PROTECTED] wrote:
 On 2008.11.07. 18:39, Jose Ildefonso Camargo Tolosa wrote:
 On Sat, Nov 8, 2008 at 9:52 AM, Dan Langille [EMAIL PROTECTED] wrote:
 On Nov 7, 2008, at 8:57 AM, LeJav wrote:

 Hello,

 I am preparing a NFS server (Linux) which is a part of a global
 project for a customer.
 This NFS server will be backuped with bacula; I use MySQL for the
 database.
 Could someone explain me if I am right with MySQL licencing ?
 MySQL is only used for the bacula data.
 My global project is not GPL; but my NFS Server and bacula are GPL.
 Can I install bacula and MySQL on this server with respect to GPL
 licencing ?

 I cannot imagine any circumstances under which this would not be
 allowed.

 Yes, there are: say that the project is a propiertary backup
 solution, and that the company wants to use bacula and/or mysql code
 for their non-gpl backup solution: they can't do that.

 please, please, don't do this.
 they can change the code until nobody can recognise it or whatever. they
 can molest, abuse, ridicule that code. as long as it stays inhouse, it's
 their choice.

true.  But they can't start selling a product based on a GPL software,
and license it with other terms: they can sell the GPL product, but
they must give access to the code under the GPL terms.

 now, if they modify and distribute the modified code... yes, now gpl
 kicks in and requires publishing changes (actually, that's not true
 either, they have to provide source to the receivers of the modifications).

Not only that, it requires that such modifications are covered by GPL,
which means that the receivers of the modifications can distribute the
modifications, under the GPL terms.


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

 -
 This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
 Build the coolest Linux based applications with Moblin SDK  win great prizes
 Grand prize is a trip for two to an Open Source event anywhere in the world
 http://moblin-contest.org/redirect.php?banner_id=100url=/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Moving from Tape to DVD

2008-11-07 Thread Jari Fredriksson
 Hmm.
 
 [ 5053.929447] attempt to access beyond end of device
 [ 5053.929447] hdc: rw=0, want=68, limit=4
 [ 5053.929447] isofs_fill_super: bread failed, dev=hdc,
 iso_blknum=16, block=16 [ 5054.954192] attempt to access
 beyond end of device [ 5054.954192] hdc: rw=0, want=68,
 limit=4 [ 5054.954192] isofs_fill_super: bread failed,
 dev=hdc, iso_blknum=16, block=16 [ 5055.009549] attempt
 to access beyond end of device [ 5055.009549] hdc: rw=0,
 want=68, limit=4 [ 5055.009549] isofs_fill_super: bread
 failed, dev=hdc, iso_blknum=16, block=16 [ 5056.027985]
 attempt to access beyond end of device [ 5056.027985]
 hdc: rw=0, want=68, limit=4 [ 5056.027985]
 isofs_fill_super: bread failed, dev=hdc, iso_blknum=16,
 block=16 [ 5948.257464] ISO 9660 Extensions: RRIP_1991A [
 6097.944016] ISO 9660 Extensions: RRIP_1991A
 [13464.702833] ISO 9660 Extensions: RRIP_1991A 
 
 
 Bacula job did not fail, but syslog and dmesg shows stuff
 like this. 
 

I googled, and changed /etc/fstab to 

/dev/hdc/media/cdromautoro,user,noauto  0   0

it was 

/dev/hdc/media/cdromufs,iso9660ro,user,noauto  0   0

Auto mount was offearleir too, but maybe that affected Baculas mount, dunno. No 
errors now.

The common nominator in that is /dev/hdc.. Bacula does not mount to 
/media/cdrom but /mnt/dvd..

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] next tape autolabel source

2008-11-07 Thread James Harper
 On Fri, Nov 7, 2008 at 7:39 AM, James Harper
 [EMAIL PROTECTED] wrote:
  Quick question - I've been looking through the docs and the source
code
  and can't find the answer - where does bacula store the counter for
the
  next tape label number?
 
 
 It does not. It gets that from the database.

If it stores it in the database, do you know what table? I have looked
through all the tables and can't see what counter would represent 'last
tape labelled' or 'next autolabel number'...

Basically, I want to reset the counter to a given number.

Thanks

James


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] next tape autolabel source

2008-11-07 Thread John Drescher
On Fri, Nov 7, 2008 at 9:10 PM, James Harper
[EMAIL PROTECTED] wrote:
 On Fri, Nov 7, 2008 at 7:39 AM, James Harper
 [EMAIL PROTECTED] wrote:
  Quick question - I've been looking through the docs and the source
 code
  and can't find the answer - where does bacula store the counter for
 the
  next tape label number?
 

 It does not. It gets that from the database.

 If it stores it in the database, do you know what table? I have looked
 through all the tables and can't see what counter would represent 'last
 tape labelled' or 'next autolabel number'...

 Basically, I want to reset the counter to a given number.

There is no counter. It finds the maximum mediaid of all the volumes
that exist in the database. I believe the only way to reset this
counter is to delete all of your media in every pool.


Here is some info on why this is so:
http://sourceforge.net/mailarchive/forum.php?thread_name=479E22E3.40805%40neuro-tech.netforum_name=bacula-devel


BTW, I am going on vacation in 6 hours and will not be back till the
15th or 16th. I am not sure if I will have internet access in during
this time so I probably will not be able to reply again until I
return.

John

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users