Re: [Bacula-users] Bacula Project Status Report

2009-04-08 Thread Kern Sibbald
Hello Craig,

Thanks for the very kind email, and the well balanced presentation of some of 
Bacula's features that can be improved :-)

Concerning automatic handling of LVMs: I think it would be a nice feature, 
where I hesitate is that it is OS dependent, and 99% of the directives we 
have (not all) are OS independent.  That means that before implementing 
something like that, we need to give it very careful consideration.

On the question of lstat in the database: yes, a number of people have 
requested what you are suggesting.  The problem of just putting the lstat 
packet in the database is two fold:

1. Without careful though, it would very significantly increase the size of 
the database and possibly slow down record insertion.  The size issue is 
really quite worrisome.  Your statement that PostgreSQL would be as efficient 
as the current base64 encoding is interesting and worth understanding ...

2. The current lstat is not really system independent (I forgot that the silly 
mode bits can differ from Unix to Unix).

Item 2 is just something to consider when we re-work the lstat packet -- it 
probably needs to be a part of the project.

Item 1 is much more problematic.  Eric and I have been working on a design for 
making selected parts of the lstat more accessible (i.e. have them as 
separate table columns -- perhaps Eric could dig out our notes on this 
subject).  There are fields that we can totally eliminate, and that would 
largely compensate for the extra space taken by adding new separate columns, 
but for 3.0, we decided not to make any changes since all the design issues 
were not totally clear.  One important aspect is the requirement to convert 
existing databases.

You certainly have the right attitude by mentioning MySQL and SQLite.  One 
important point is that we need to be as SQL engine neutral as possible (not 
always so easy).

If you would like to work on either or both of these projects, we would be 
very happy, but as you can see, I feel we need to carefully design what will 
be done before coding.  However, as long as we discuss these points and 
resolve as much as possible beforehand, and as you say assuming perf testing 
worked out and it worked OK for MySQL and SQLite as well, I don't see any 
problem, and the simple answer is yes, it is OK ...

What do you think?

Best regards,

Kern

On Wednesday 08 April 2009 03:35:50 Craig Ringer wrote:
 Kern Sibbald wrote:
  On Tuesday 07 April 2009 17:32:27 Reynier Perez Mira wrote:
  1.Bacula Release 3.0
 
  When will be Bacula 3.0 released during this week?
 
  Since I am working 12-16 hours a day, and I as well as the other
  developers are doing it all for free: It will be ready when it is ready
  (during this week).

 For what it's worth, as someone who's done my own fair share of OSS dev
 work (on Scribus, PoDoFo, lprof, and misc other things):

*THANKS*

 Bacula makes part of my job dramatically simpler, easier, and safer. It
 takes some learning and can take some coaxing to get it to do what you
 want, but once it's set up it *just* *goes*, and it informs you if/when
 something DOES go wrong. I cannot overstate the value of this.

 It's also nice to see a project where I start using it and don't
 immediately feel the gotta-fix-that-unfeature/bug/whatever itch. Because
 Bacula already does what I need it to. Ther are things where it could be
 simpler/cleaner/nicer, mostly in configuration, but they're all pretty
 minor.

 Other backup systems I've investigated (including several commercial
 ones) have had weird limitations, horrifying UIs (yes, compared to
 Bacula!), and/or scary packaging and setup that makes me reluctant to
 let them anywhere near my servers.

 Bacula is already integrated into most of the OSes I use, and trivial to
 install on the others.

 Now that it handles deleted files correctly, it's pretty much perfect.

 BTW, if I was to find the time to implement native fd support for LVM
 snapshots, so that rather than using pre- and post- scripts for
 snapshots and using path stripping, the user could just specify (eg)
 lvm_snapshot=/var/spool/cyrus/mail;2GB in the FileSet options and have
 Bacula take care of managing the snapshot, would that be something you'd
 potentially want to see included?

 Also, if I was to submit a patch that changed the database format for
 post-3.0 to store lstat attributes as individual fields in the DB,
 rather than using the almost-base64 encoded strings Bacula currently
 uses, would that be considered? I'd *REALLY* like the ability to query
 those values directly and to create indexes on them, something I can
 currently do only by adding a C helper function to PostgreSQL and using
 functional indexes. Kinda clunky. Since (at least in Pg) storage as
 native values is at least as storage-efficient as the base64 form, would
 this be considered assuming perf testing worked out and it worked OK for
 MySQL and SQLite as well?

  Is the SVN release ready for production?
 
  Yes.  

Re: [Bacula-users] Schedule full backups without inter rupting incrementals

2009-04-08 Thread Paweł Madej
Use separate job for the same fileset but with different schedule for tape 
backups then it will be clearly separated.

On poniedziałek, 6 kwietnia 2009 23:42:21 Mike Ruskai wrote:
 On 04/06/2009 17:19, (private) HKS wrote:
  The obvious problem is that the weekly tape backup will disrupt my
  incremental/differential scheme. Is there any way to avoid this? I'm

 Use a separate job and file set.  Or maybe just a separate job - not
 sure which Bacula uses to calculate the backup level required.


 ---
--- This SF.net email is sponsored by:
 High Quality Requirements in a Collaborative Environment.
 Download a free trial of Rational Requirements Composer Now!
 http://p.sf.net/sfu/www-ibm-com
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users




--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] I really need some help with bscan and trying to restore (repost)

2009-04-08 Thread Bruno Friedmann
John Drescher wrote:
 John,

 The out put of netstat -a -n | grep 9103 ...

 tcp0  0 127.0.0.1:9103  0.0.0.0:*   LISTEN

 Now how do I correct this?

 
 Edit bacula-sd.conf and put the real ip address in SDAddress instead
 of 127.0.0.1 or localhost.
 
 John
 
 --
 This SF.net email is sponsored by:
 High Quality Requirements in a Collaborative Environment.
 Download a free trial of Rational Requirements Composer Now!
 http://p.sf.net/sfu/www-ibm-com
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

One time again : debian like package paranoid settings :-)))

I've made a dream, one day this guys would understand that a NETWORK backup 
service should listen some network interfaces.

Did they restrict also apache or lighttpd to listen only localhost ???



-- 

 Bruno Friedmann


--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] backup speed is slow

2009-04-08 Thread Bruno Friedmann
Pascal Clermont wrote:
 Hi,
 I was reading the archives and stumbled upon [Bacula-users] Improving Backup 
 speed thread which caught my eye since I am having issues.
 we backup over 6TB of small files during a full usually started on Friday 
 night these are far from being finished on Mondays. the transfer on the wire 
 is usually finished within 24 hours.
 My bottleneck being Dir inserting Attributes in my database. I only have 
 2.5 Gb of ram on that machine and intend to upgrade by the end of the month. 
 (so far we intend to upgrade to 8gb of ram)
 
 Something in the thread caught my eye :
 
 
 On Thu, 15 Jan 2009 13:31:54 +0100, Bruno Friedmann br...@ioda-net.ch
 wrote:
 I added the following indexes:
 
 CREATE INDEX File_JobId_idx ON File(JobId);
 CREATE INDEX File_PathId_idx ON File(PathId);
 CREATE INDEX File_FilenameId_idx ON File(FilenameId);
 CREATE INDEX Path_PathId_idx ON Path(PathId);
 CREATE INDEX Job_FileSetId_idx ON Job(FileSetId);
 CREATE INDEX Job_ClientId_idx ON Job(ClientId);
 CREATE INDEX File_FilenameId-PathId_idx ON File(FilenameId,PathId);
 
 
 It remains to be seen whether the added indexing will impact insert/update
 performance, but I'll take a small performance hit if it means faster
 restores and sanity checks. 
 
 As I am no database expert, Would I benefit from creating these indexes in 
 order to speed up attributes inserting?
 My database is already at 137G in size with only about 3 months of jobs. I've 
 ran the dbcheck a few times ( which takes ~48 hours to complete ) but do not 
 feel an improvement once that is done.
 
 
 Any tips/comments concerning improving database insertion would be greatly 
 appreciated.
 
 Regards,
 
 Pascal S. Clermont
 

Same request about Dan : which database are you using on which OS, and with 
which bacula version
This would help us a lot to understand your context.

Did you have modify the default serveur db ?
distribution tends to setup a minimal not optimized server ...

The indexes I've creade help dbcheck a lot (many hours to  1 hour on some 
sites)
( don't forget to modify it's default mode choice 1: if you want your db 
corrected otherwise it's only a read operation )



-- 

 Bruno Friedmann



--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula client is causing error in Server 2008 eventlog

2009-04-08 Thread Kevin Keane
This is a Windows VSS error; maybe something like a shadow copy provider 
is not working properly, or it could be a hardware problem. There 
probably are more events in the event log related to it that give you 
more details. You can then google for it.

Arch Willingham wrote:

 When I enable “ Enable VSS = yes”, for Server 2008 machines running 
 the window client (winbacula 2.4.4), I get errors in the eventlog of 
 the client machine. The file set in bacula-dir.conf is as follows:

 FileSet {

 Name = COMPUTER Data only

 Enable VSS = yes

 # IgnoreCase = yes

 Include {

 File = c:/n/tsgold/tup

 File = c:/m/123

 File = c:/m/AIA

 File = c:/m/ArchiCAD 6.5

 File = c:/m/BATCH

 File = c:/m/images

 File = c:/m/PEGENL-A

 File = c:/m/TUPARKS

 File = c:/m/users

 File = c:/j/wp

 Options {

 compression = GZIP

 IgnoreCase = yes

 }

 }

 Exclude {

 File = c:/m/users/*/My Documents/My Music

 File = c:/m/users/*/My Documents/RECYCLER

 File = c:/m/users/*/My Documents

 File = c:/m/users/*/My Pictures

 }

 }

 The errors are below:

 Event Type: Error

 Event Source: VSS

 Event Category: None

 Event ID: 8193

 Date: 04/05/2009

 Time: 11:27:17 PM

 User: N/A

 Computer: COMPUTER

 Description:

 Volume Shadow Copy Service error: Unexpected error calling routine 
 CoCreateInstance. hr = 0x80040154.

 : 2d 20 43 6f 64 65 3a 20 - Code:

 0008: 42 55 45 43 58 4d 4c 43 BUECXMLC

 0010: 30 30 30 30 34 32 38 31 4281

 0018: 2d 20 43 61 6c 6c 3a 20 - Call:

 0020: 42 55 45 43 58 4d 4c 43 BUECXMLC

 0028: 30 30 30 30 34 32 35 30 4250

 0030: 2d 20 50 49 44 3a 20 20 - PID:

 0038: 30 30 30 30 32 34 32 30 2420

 0040: 2d 20 54 49 44 3a 20 20 - TID:

 0048: 30 30 30 30 35 31 30 34 5104

 0050: 2d 20 43 4d 44 3a 20 20 - CMD:

 0058: 22 43 3a 5c 50 72 6f 67 C:\Prog

 0060: 72 61 6d 20 46 69 6c 65 ram File

 0068: 73 20 28 78 38 36 29 5c s (x86)\

 0070: 42 61 63 75 6c 61 5c 62 Bacula\b

 0078: 69 6e 5c 62 61 63 75 6c in\bacul

 0080: 61 2d 66 64 2e 65 78 65 a-fd.exe

 0088: 22 20 2f 73 65 72 76 69  /servi

 0090: 63 65 20 20 2d 63 20 22 ce -c 

 0098: 43 3a 5c 50 72 6f 67 72 C:\Progr

 00a0: 61 6d 44 61 74 61 5c 42 amData\B

 00a8: 61 63 75 6c 61 5c 62 61 acula\ba

 00b0: 63 75 6c 61 2d 66 64 2e cula-fd.

 00b8: 63 6f 6e 66 22 20 20 20 conf

 00c0: 2d 20 55 73 65 72 3a 20 - User:

 The rest is deleted

 Event Type: Error

 Event Source: VSS

 Event Category: None

 Event ID: 32

 Date: 04/05/2009

 Time: 11:27:17 PM

 User: N/A

 Computer: COMPUTER

 Description:

 The description for Event ID ( 32 ) in Source ( VSS ) cannot be found. 
 The local computer may not have the necessary registry information or 
 message DLL files to display messages from a remote computer. You may 
 be able to use the /AUXSOURCE= flag to retrieve this description; see 
 Help and Support for details. The following information is part of the 
 event:

 Operation:

 Instantiating VSS server.

 Data:

 : 2d 20 43 6f 64 65 3a 20 - Code:

 0008: 42 55 45 43 58 4d 4c 43 BUECXMLC

 0010: 30 30 30 30 34 32 37 35 4275

 0018: 2d 20 43 61 6c 6c 3a 20 - Call:

 0020: 42 55 45 43 58 4d 4c 43 BUECXMLC

 0028: 30 30 30 30 34 32 35 30 4250

 0030: 2d 20 50 49 44 3a 20 20 - PID:

 0038: 30 30 30 30 32 34 32 30 2420

 0040: 2d 20 54 49 44 3a 20 20 - TID:

 0048: 30 30 30 30 35 31 30 34 5104

 0050: 2d 20 43 4d 44 3a 20 20 - CMD:

 0058: 22 43 3a 5c 50 72 6f 67 C:\Prog

 0060: 72 61 6d 20 46 69 6c 65 ram File

 0068: 73 20 28 78 38 36 29 5c s (x86)\

 0070: 42 61 63 75 6c 61 5c 62 Bacula\b

 0078: 69 6e 5c 62 61 63 75 6c in\bacul

 0080: 61 2d 66 64 2e 65 78 65 a-fd.exe

 0088: 22 20 2f 73 65 72 76 69  /servi

 0090: 63 65 20 20 2d 63 20 22 ce -c 

 0098: 43 3a 5c 50 72 6f 67 72 C:\Progr

 00a0: 61 6d 44 61 74 61 5c 42 amData\B

 00a8: 61 63 75 6c 61 5c 62 61 acula\ba

 00b0: 63 75 6c 61 2d 66 64 2e cula-fd.

 00b8: 63 6f 6e 66 22 20 20 20 conf

 00c0: 2d 20 55 73 65 72 3a 20 - User:

 The rest is deleted

 Any ideas?

 Thanks!

 Arch

 

 --
 This SF.net email is sponsored by:
 High Quality Requirements in a Collaborative Environment.
 Download a free trial of Rational Requirements Composer Now!
 http://p.sf.net/sfu/www-ibm-com
 

 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
   


-- 
Kevin Keane
Owner
The NetTech
Find the Uncommon: Expert Solutions for a Network You Never Have to Think About

Office: 866-642-7116
http://www.4nettech.com

This e-mail and attachments, if any, may contain confidential and/or 
proprietary information. Please be advised that the unauthorized use or 
disclosure of the information is strictly prohibited. The information herein is 
intended only 

Re: [Bacula-users] Bacula Project Status Report

2009-04-08 Thread Mark V
Hi Craig and Kern,
Just one observation

On Wed, Apr 8, 2009 at 5:09 PM, Kern Sibbald k...@sibbald.com wrote:
 Hello Craig,

 Thanks for the very kind email, and the well balanced presentation of some of
 Bacula's features that can be improved :-)

 Concerning automatic handling of LVMs: I think it would be a nice feature,
 where I hesitate is that it is OS dependent, and 99% of the directives we
 have (not all) are OS independent.  That means that before implementing
 something like that, we need to give it very careful consideration.


I can't comment on the technicalities, but I do know that within
Amazon's EC2 (their cloud computing service) a perennial issu that
comes up is:
 'How do I do backups of ...' usually MySQL is inserted
The answer seems to be:
 'Place it on a LVM volume and take scripts to take snapshots'
The process looks something like:

   1. mysql connection (left open): FLUSH TABLES WITH READ LOCK;
   2. lvcreate -L16G -s -n dbbackup /dev/vg/myvmdisk1
   3. mysql connection: UNLOCK TABLES;

Anyway, I just thought I'd throw in one more use case to contemplate.
There maybe other common EC2 cases but the mention of LVM snapshots
jogged the memory.
While such things are OS dependent they do potentially expand the user
base if the answer to backup questions in the EC2 becomes:
Configure and point Bacula at it and it'll just work

Thanks for a great application!!

HTH

Mark

 On the question of lstat in the database: yes, a number of people have
 requested what you are suggesting.  The problem of just putting the lstat
 packet in the database is two fold:

 1. Without careful though, it would very significantly increase the size of
 the database and possibly slow down record insertion.  The size issue is
 really quite worrisome.  Your statement that PostgreSQL would be as efficient
 as the current base64 encoding is interesting and worth understanding ...

 2. The current lstat is not really system independent (I forgot that the silly
 mode bits can differ from Unix to Unix).

 Item 2 is just something to consider when we re-work the lstat packet -- it
 probably needs to be a part of the project.

 Item 1 is much more problematic.  Eric and I have been working on a design for
 making selected parts of the lstat more accessible (i.e. have them as
 separate table columns -- perhaps Eric could dig out our notes on this
 subject).  There are fields that we can totally eliminate, and that would
 largely compensate for the extra space taken by adding new separate columns,
 but for 3.0, we decided not to make any changes since all the design issues
 were not totally clear.  One important aspect is the requirement to convert
 existing databases.

 You certainly have the right attitude by mentioning MySQL and SQLite.  One
 important point is that we need to be as SQL engine neutral as possible (not
 always so easy).

 If you would like to work on either or both of these projects, we would be
 very happy, but as you can see, I feel we need to carefully design what will
 be done before coding.  However, as long as we discuss these points and
 resolve as much as possible beforehand, and as you say assuming perf testing
 worked out and it worked OK for MySQL and SQLite as well, I don't see any
 problem, and the simple answer is yes, it is OK ...

 What do you think?

 Best regards,

 Kern

 On Wednesday 08 April 2009 03:35:50 Craig Ringer wrote:
 Kern Sibbald wrote:
  On Tuesday 07 April 2009 17:32:27 Reynier Perez Mira wrote:
  1.Bacula Release 3.0
 
  When will be Bacula 3.0 released during this week?
 
  Since I am working 12-16 hours a day, and I as well as the other
  developers are doing it all for free: It will be ready when it is ready
  (during this week).

 For what it's worth, as someone who's done my own fair share of OSS dev
 work (on Scribus, PoDoFo, lprof, and misc other things):

    *THANKS*

 Bacula makes part of my job dramatically simpler, easier, and safer. It
 takes some learning and can take some coaxing to get it to do what you
 want, but once it's set up it *just* *goes*, and it informs you if/when
 something DOES go wrong. I cannot overstate the value of this.

 It's also nice to see a project where I start using it and don't
 immediately feel the gotta-fix-that-unfeature/bug/whatever itch. Because
 Bacula already does what I need it to. Ther are things where it could be
 simpler/cleaner/nicer, mostly in configuration, but they're all pretty
 minor.

 Other backup systems I've investigated (including several commercial
 ones) have had weird limitations, horrifying UIs (yes, compared to
 Bacula!), and/or scary packaging and setup that makes me reluctant to
 let them anywhere near my servers.

 Bacula is already integrated into most of the OSes I use, and trivial to
 install on the others.

 Now that it handles deleted files correctly, it's pretty much perfect.

 BTW, if I was to find the time to implement native fd support for LVM
 snapshots, so that rather than using pre- 

Re: [Bacula-users] [Bulk] Re: thannyd earthlink.net

2009-04-08 Thread Foo
On Tue, 07 Apr 2009 22:19:54 +0200, Dan Langille d...@langille.org wrote:

 Regardless of the personal religious views, I wish to point out this
 user-configurable mailing list option:

 ###
 Avoid duplicate copies of messages?

 When you are listed explicitly in the To: or Cc: headers of a list
 message, you can opt to not receive another copy from the mailing list.
 Select Yes to avoid receiving copies from the mailing list; select No to
 receive copies.

This is useful to a degree (and set to yes by default), but the mail sent  
privately will be different as far as filtering is concerned (i.e. arrive  
in a different mailbox) and so require extra effort on the recipient's  
part.


--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Howto recover from a job being rerun around a summer time change

2009-04-08 Thread Foo
On Tue, 07 Apr 2009 20:23:49 +0200, Martin Simmons mar...@lispworks.com  
wrote:

 On Tue, 07 Apr 2009 16:45:54 +0200, Foo  said:

 Basically on startup Bacula needs to check the locale, get the offset  
 from
 UTC, if any, and set its internal clock to UTC, and change the offset on
 DST changes. Then use the offset for calculations involving configs/user
 output like logging.

 Doing all of those calculations doesn't solve the underlying problem,  
 which is
 that the user has entered ambiguous data by saying run this at 2:05am  
 local
 time today.  On the day of the DST change, there is no unique UTC for  
 2:05am
 local time -- it might occur twice or not at all.

I'm just guessing here but this would seem logical to me: when Bacula  
(re)loads the config, it parses the Schedule {} stanzas and puts them in  
an array, then it does a neverending sleep/check loop to see if the  
current time occurs in the array and if so executes the associated job.

I'm proposing to remap the schedule array to UTC and check against UTC  
current time. Since neither changes during the course of the year, every  
scheduled job is executed exactly once, and always - unless the config is  
changed/reloaded exactly during a DST change period, but that's up to the  
user to deal with.

The trick is while doing the mapping, you look at whether the schedule  
would fall in/on a DST change period/second or not. If so, then map it so  
it occurs on the UTC time equivalent to the 'first' local time (for  
changes backwards) or immediately after the change (for changes forwards,  
possibly offset by the same amount in the hour), i.e. a job scheduled for  
02:05 local time would occur at 02:05 364 times a year (at the 'first  
02:05' on summer to wintertime change day), and at 03:00 (or 03:05) once a  
year.

Obviously this would mean instead of having a static array as large as  
there are schedules, a dynamic array that needs to be calculated ahead of  
time for a certain period and refilled every so often (e.g. FIFO every 24  
hours). This might cost some extra memory but can be scaled if needed,  
down to 1 hour and a second basically.

 The problem is what should 2:05am mean in that case?  E.g. is it 2 hours  
 after midnight or 10 hours before midday?

It is 02:05+$offset UTC :)

 The code gets even more non-trivial when you also need to deal with clock
 adjustment as well.  See the first half of cron_tick in
 http://www.freebsd.org/cgi/cvsweb.cgi/src/usr.sbin/cron/cron/cron.c?rev=1.20
 for example.

I haven't thoroughly read the code so I'll assume it is an example of  
dealing with time/offset changes by checking whether current time   
previous time instead of the above proposal.


--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Feature request: relative rentention times

2009-04-08 Thread Kevin Keane
Dan Langille wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Kevin Keane wrote:
   
 Item  n:  implement retention times specified as number of copies.
  Date:   4/6/2009
  Origin: Kevin Keane - subscription at kkeane dot com
  Status: 
  
  What:   Currently, the retention time for a volume/job etc. is a
  fixed number of seconds from the last time the item (volume,
  job, file) was written or backed up.

  What I would like to see is a retention time based on the last
  successful backup at Full or Differential levels instead.

  For instance:

  Keep Copies = 2

  would mean expire retention time for a file or job when there
  are at least two newer copies of the same file/job.
  
  Why:There are three benefits to this approach.

  1) archiving. If you decommission a server, the last backup of
  that server would automatically stay around forever.

  2) storage management. Currently, if a full backup is done in the 
 middle
  of a backup cycle, the previous full backup will still be retained, 
 and
  take up space, until its full expiration time.

  3) fail safety. If a full backup fails for some reason for several 
 days
  in a row, the current retention-time mechanism may still allow the
  previous full backup to expire, leaving you potentially with no 
 good backup
  at all.
  
  Notes:  This feature may only makes sense for jobs and files, maybe not for 
 volumes.
  I haven't fully thought through the implications yet.
  The interaction between Keep Copies and Volume Retention
  needs to be defined.
  A possible alternate implementation might be to have a relative
  retention time instead of the number of copies: keep a backup until
  two days after the next full backup. I believe that Keep Copies is
  better, though, because the relative retention time mechanism would 
 not
  allow for an easy mechanism to specify that you want to keep several
  full backups before expiring the oldest one.
 

 - From a programming point of view, have you thought about the algorithm
 which could be used to determine 2 copies?
   
For the jobs, it should be pretty simple to do with a single database 
query. Simply count the last two backups of jobs with the same name and 
the appropriate levels. BTW, I just realize that my spec is a bit vague: 
does one differential + the previous full backup count as two backups? 
I'd say, no; it has to be two differentials.

For the files, theoretically it should also be pretty simple to do, but 
it would probably be unacceptably slow to do that way.

Maybe this feature should only be implemented for jobs? That's where it 
would be most useful anyway.

-- 
Kevin Keane
Owner
The NetTech
Find the Uncommon: Expert Solutions for a Network You Never Have to Think About

Office: 866-642-7116
http://www.4nettech.com

This e-mail and attachments, if any, may contain confidential and/or 
proprietary information. Please be advised that the unauthorized use or 
disclosure of the information is strictly prohibited. The information herein is 
intended only for use by the intended recipient(s) named above. If you have 
received this transmission in error, please notify the sender immediately and 
permanently delete the e-mail and any copies, printouts or attachments thereof.


--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Deduplication feature

2009-04-08 Thread Corneliu P
Hi all,

Does Bacula support deduplication feature?

That is, for the backup software to detect duplicate files and not
actually backup duplicates, but store a pointer to original backed up
file, and make all this transparent on restore operations?

Thanks,
Corneliu

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] restore file in folder with accent

2009-04-08 Thread Craig Ringer
François Mehault wrote:
 Hi All !
 
 I would like to restore a file which is in a folder named « Mes données ». As 
 you can see there is accent in the folder's  name. So i can't enter in the 
 folder on bconsole :
 
 $ dir
 -drwxrwxrwx   1 root wheel0  2009-04-08 13:58:38  C:/Rep1/Mes 
 données/
 -rwxrwxrwx   1 root wheel8  2009-04-08 13:58:34  
 C:/Rep1/héhé lol.txt

Really?

That's a nasty encoding bug, if so. Is this considered expected
behaviour from bacula? If so, I just found something I need to send a
patch in for, because I've done *LOTS* of work fixing application
encoding bugs and issues.


What database backend are you using? What's your locale on:

- The client where the fd runs
- The director server

On a Linux machine and some other UNIXes, you can get the locale info
with the locale command.

On Windows, use the nlsinfo command (Start-Run-cmd.exe, nlsinfo).

--
Craig Ringer

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] make bat troubles in bacula 3.0.0

2009-04-08 Thread JanJaap Scholing

Hi,

I'm trying to install bat. 
./configure --enable-lockmgr --with-mysql --enable-bat --disable-libtool looks 
ok

But when I make I see the following error messages:

ui/ui_main.h: In member function ‘void Ui_MainForm::setupUi(QMainWindow*)’:
ui/ui_main.h:168: error: ‘class QGridLayout’ has no member named ‘setLeftMargin’
ui/ui_main.h:169: error: ‘class QGridLayout’ has no member named ‘setTopMargin’
ui/ui_main.h:170: error: ‘class QGridLayout’ has no member named 
‘setRightMargin’
ui/ui_main.h:171: error: ‘class QGridLayout’ has no member named 
‘setBottomMargin’
ui/ui_main.h:172: error: ‘class QGridLayout’ has no member named 
‘setHorizontalSpacing’
ui/ui_main.h:173: error: ‘class QGridLayout’ has no member named 
‘setVerticalSpacing’
ui/ui_main.h:224: error: ‘class QGridLayout’ has no member named ‘setLeftMargin’
ui/ui_main.h:225: error: ‘class QGridLayout’ has no member named ‘setTopMargin’
ui/ui_main.h:226: error: ‘class QGridLayout’ has no member named 
‘setRightMargin’
ui/ui_main.h:227: error: ‘class QGridLayout’ has no member named 
‘setBottomMargin’
ui/ui_main.h:228: error: ‘class QGridLayout’ has no member named 
‘setHorizontalSpacing’
ui/ui_main.h:229: error: ‘class QGridLayout’ has no member named 
‘setVerticalSpacing’
ui/ui_main.h:255: error: ‘class QGridLayout’ has no member named ‘setLeftMargin’
ui/ui_main.h:256: error: ‘class QGridLayout’ has no member named ‘setTopMargin’
ui/ui_main.h:257: error: ‘class QGridLayout’ has no member named 
‘setRightMargin’
ui/ui_main.h:258: error: ‘class QGridLayout’ has no member named 
‘setBottomMargin’
ui/ui_main.h:259: error: ‘class QGridLayout’ has no member named 
‘setHorizontalSpacing’
ui/ui_main.h:260: error: ‘class QGridLayout’ has no member named 
‘setVerticalSpacing’
ui/ui_main.h:264: error: ‘class QHBoxLayout’ has no member named ‘setLeftMargin’
ui/ui_main.h:265: error: ‘class QHBoxLayout’ has no member named ‘setTopMargin’
ui/ui_main.h:266: error: ‘class QHBoxLayout’ has no member named 
‘setRightMargin’
ui/ui_main.h:267: error: ‘class QHBoxLayout’ has no member named 
‘setBottomMargin’
ui/ui_prefs.h: In member function ‘void Ui_PrefsForm::setupUi(QDialog*)’:
ui/ui_prefs.h:109: error: ‘class QGridLayout’ has no member named 
‘setLeftMargin’
ui/ui_prefs.h:110: error: ‘class QGridLayout’ has no member named ‘setTopMargin’
ui/ui_prefs.h:111: error: ‘class QGridLayout’ has no member named 
‘setRightMargin’
ui/ui_prefs.h:112: error: ‘class QGridLayout’ has no member named 
‘setBottomMargin’
ui/ui_prefs.h:113: error: ‘class QGridLayout’ has no member named 
‘setHorizontalSpacing’
ui/ui_prefs.h:114: error: ‘class QGridLayout’ has no member named 
‘setVerticalSpacing’
ui/ui_prefs.h:161: error: ‘class QGridLayout’ has no member named 
‘setLeftMargin’
ui/ui_prefs.h:162: error: ‘class QGridLayout’ has no member named ‘setTopMargin’
ui/ui_prefs.h:163: error: ‘class QGridLayout’ has no member named 
‘setRightMargin’
ui/ui_prefs.h:164: error: ‘class QGridLayout’ has no member named 
‘setBottomMargin’
ui/ui_prefs.h:165: error: ‘class QGridLayout’ has no member named 
‘setHorizontalSpacing’
ui/ui_prefs.h:166: error: ‘class QGridLayout’ has no member named 
‘setVerticalSpacing’
ui/ui_prefs.h:176: error: ‘class QGridLayout’ has no member named 
‘setLeftMargin’
ui/ui_prefs.h:177: error: ‘class QGridLayout’ has no member named ‘setTopMargin’
ui/ui_prefs.h:178: error: ‘class QGridLayout’ has no member named 
‘setRightMargin’
ui/ui_prefs.h:179: error: ‘class QGridLayout’ has no member named 
‘setBottomMargin’
ui/ui_prefs.h:180: error: ‘class QGridLayout’ has no member named 
‘setHorizontalSpacing’
ui/ui_prefs.h:181: error: ‘class QGridLayout’ has no member named 
‘setVerticalSpacing’
ui/ui_prefs.h:184: error: ‘class QGridLayout’ has no member named 
‘setLeftMargin’
ui/ui_prefs.h:185: error: ‘class QGridLayout’ has no member named ‘setTopMargin’
ui/ui_prefs.h:186: error: ‘class QGridLayout’ has no member named 
‘setRightMargin’
ui/ui_prefs.h:187: error: ‘class QGridLayout’ has no member named 
‘setBottomMargin’
ui/ui_prefs.h:188: error: ‘class QGridLayout’ has no member named 
‘setHorizontalSpacing’
ui/ui_prefs.h:189: error: ‘class QGridLayout’ has no member named 
‘setVerticalSpacing’
ui/ui_prefs.h:242: error: ‘class QGridLayout’ has no member named 
‘setLeftMargin’
ui/ui_prefs.h:243: error: ‘class QGridLayout’ has no member named ‘setTopMargin’
ui/ui_prefs.h:244: error: ‘class QGridLayout’ has no member named 
‘setRightMargin’
ui/ui_prefs.h:245: error: ‘class QGridLayout’ has no member named 
‘setBottomMargin’
ui/ui_prefs.h:246: error: ‘class QGridLayout’ has no member named 
‘setHorizontalSpacing’
ui/ui_prefs.h:247: error: ‘class QGridLayout’ has no member named 
‘setVerticalSpacing’
ui/ui_prefs.h:270: error: ‘class QGridLayout’ has no member named 
‘setLeftMargin’
ui/ui_prefs.h:271: error: ‘class QGridLayout’ has no member named ‘setTopMargin’
ui/ui_prefs.h:272: error: ‘class QGridLayout’ has no member named 
‘setRightMargin’
ui/ui_prefs.h:273: error: ‘class 

Re: [Bacula-users] Howto recover from a job being rerun around a summer time change

2009-04-08 Thread Josh Fisher

Martin Simmons wrote:
 On Tue, 07 Apr 2009 16:45:54 +0200, Foo  said:
 
 On Mon, 06 Apr 2009 19:41:52 +0200, Martin Simmons mar...@lispworks.com  
 wrote:

 
 On Mon, 06 Apr 2009 17:34:09 +0200, Foo  said:
 
 The best solution would be for Bacula to translate time to UTC  
 internally
 for scheduling, everything external such as logfiles, scheduling stanzas
 in config etc. would remain in the user's locale.
 
 That doesn't help, because saying 2:05am local time in the config file is
 still ambiguous if the local time moves backwards by 1 hour at 3:00am.
   
 Not really, UTC remains the same on DST changes, so internal events using  
 UTC should be fine.

 Basically on startup Bacula needs to check the locale, get the offset from  
 UTC, if any, and set its internal clock to UTC, and change the offset on  
 DST changes. Then use the offset for calculations involving configs/user  
 output like logging.
 

 Doing all of those calculations doesn't solve the underlying problem, which is
 that the user has entered ambiguous data by saying run this at 2:05am local
 time today.  On the day of the DST change, there is no unique UTC for 2:05am
 local time -- it might occur twice or not at all.

 The problem is what should 2:05am mean in that case?  E.g. is it 2 hours after
 midnight or 10 hours before midday?
   

This is the crux of the problem. For time zones that have DST, there are 
ambiguous times caused by the two yearly time shifts. Worse, they have 
to be dealt with differently in Spring than in Fall. There are basically 
3 methods for each:

Spring forward causes there to be non-existent local times between 
02:00:00 and 02:59:59, assuming the time shift occurs at 02:00:00 local 
time. The possibilities for handling these times are:
1. Skip them altogether.
2. Special treatment to translate 02:mm:ss to 03:mm:ss for these 
times only.
3. Compress time. Attempt to translate 02:mm:ss to 03:mm:ss, but 
decrement the actual time such that events
   specified as 02:mm:ss end up scheduled before any events 
scheduled between 03:00:00 and 03:59:59.

The third option is the only way to ensure that events happen in the 
same order on the day the time shifts, though the time between events in 
the range 02:00:00 - 03:59:59 may be compressed.

Fall back causes times between 01:00:00 and 01:59:59 to repeat, again 
assuming the time shift occurs at 02:00:00 local time. The possibilities 
for handling these times are:
1. Allow them to be scheduled twice.
2. Special treatment to translate 01:mm:ss to 02:mm:ss for these 
times only.
3. Expand time. Schedule nothing for the first hour following the 
time shift, forcing the events scheduled for these times to
   fire for only the first occurrence of the wall clock time.

The third option ensures that events happen in order, but expands the 
time between 01:mm:ss events and 02:mm:ss events by an hour.

This is most definitely a non-trivial problem. DST greatly complicates 
schedulers. Only governments can create chaos from something as orderly 
as time.

 The code gets even more non-trivial when you also need to deal with clock
 adjustment as well.  See the first half of cron_tick in
 http://www.freebsd.org/cgi/cvsweb.cgi/src/usr.sbin/cron/cron/cron.c?rev=1.20
 for example.

 __Martin

 --
 This SF.net email is sponsored by:
 High Quality Requirements in a Collaborative Environment.
 Download a free trial of Rational Requirements Composer Now!
 http://p.sf.net/sfu/www-ibm-com
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
   

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Deduplication feature

2009-04-08 Thread Marc Schiffbauer
* Corneliu P schrieb am 08.04.09 um 15:08 Uhr:
 Hi all,
 
 Does Bacula support deduplication feature?
 
 That is, for the backup software to detect duplicate files and not
 actually backup duplicates, but store a pointer to original backed up
 file, and make all this transparent on restore operations?


No. But it may be listed in the feature request list...

-Marc
-- 
8AAC 5F46 83B4 DB70 8317  3723 296C 6CCA 35A6 4134

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] make bat troubles in bacula 3.0.0

2009-04-08 Thread John Drescher
2009/4/8 JanJaap Scholing janjaapschol...@hotmail.com:
 Hi,

 I'm trying to install bat.
 ./configure --enable-lockmgr --with-mysql --enable-bat --disable-libtool
 looks ok

 But when I make I see the following error messages:

 ui/ui_main.h: In member function ‘void Ui_MainForm::setupUi(QMainWindow*)’:
 ui/ui_main.h:168: error: ‘class QGridLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_main.h:169: error: ‘class QGridLayout’ has no member named
 ‘setTopMargin’
 ui/ui_main.h:170: error: ‘class QGridLayout’ has no member named
 ‘setRightMargin’
 ui/ui_main.h:171: error: ‘class QGridLayout’ has no member named
 ‘setBottomMargin’
 ui/ui_main.h:172: error: ‘class QGridLayout’ has no member named
 ‘setHorizontalSpacing’
 ui/ui_main.h:173: error: ‘class QGridLayout’ has no member named
 ‘setVerticalSpacing’
 ui/ui_main.h:224: error: ‘class QGridLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_main.h:225: error: ‘class QGridLayout’ has no member named
 ‘setTopMargin’
 ui/ui_main.h:226: error: ‘class QGridLayout’ has no member named
 ‘setRightMargin’
 ui/ui_main.h:227: error: ‘class QGridLayout’ has no member named
 ‘setBottomMargin’
 ui/ui_main.h:228: error: ‘class QGridLayout’ has no member named
 ‘setHorizontalSpacing’
 ui/ui_main.h:229: error: ‘class QGridLayout’ has no member named
 ‘setVerticalSpacing’
 ui/ui_main.h:255: error: ‘class QGridLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_main.h:256: error: ‘class QGridLayout’ has no member named
 ‘setTopMargin’
 ui/ui_main.h:257: error: ‘class QGridLayout’ has no member named
 ‘setRightMargin’
 ui/ui_main.h:258: error: ‘class QGridLayout’ has no member named
 ‘setBottomMargin’
 ui/ui_main.h:259: error: ‘class QGridLayout’ has no member named
 ‘setHorizontalSpacing’
 ui/ui_main.h:260: error: ‘class QGridLayout’ has no member named
 ‘setVerticalSpacing’
 ui/ui_main.h:264: error: ‘class QHBoxLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_main.h:265: error: ‘class QHBoxLayout’ has no member named
 ‘setTopMargin’
 ui/ui_main.h:266: error: ‘class QHBoxLayout’ has no member named
 ‘setRightMargin’
 ui/ui_main.h:267: error: ‘class QHBoxLayout’ has no member named
 ‘setBottomMargin’
 ui/ui_prefs.h: In member function ‘void Ui_PrefsForm::setupUi(QDialog*)’:
 ui/ui_prefs.h:109: error: ‘class QGridLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_prefs.h:110: error: ‘class QGridLayout’ has no member named
 ‘setTopMargin’
 ui/ui_prefs.h:111: error: ‘class QGridLayout’ has no member named
 ‘setRightMargin’
 ui/ui_prefs.h:112: error: ‘class QGridLayout’ has no member named
 ‘setBottomMargin’
 ui/ui_prefs.h:113: error: ‘class QGridLayout’ has no member named
 ‘setHorizontalSpacing’
 ui/ui_prefs.h:114: error: ‘class QGridLayout’ has no member named
 ‘setVerticalSpacing’
 ui/ui_prefs.h:161: error: ‘class QGridLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_prefs.h:162: error: ‘class QGridLayout’ has no member named
 ‘setTopMargin’
 ui/ui_prefs.h:163: error: ‘class QGridLayout’ has no member named
 ‘setRightMargin’
 ui/ui_prefs.h:164: error: ‘class QGridLayout’ has no member named
 ‘setBottomMargin’
 ui/ui_prefs.h:165: error: ‘class QGridLayout’ has no member named
 ‘setHorizontalSpacing’
 ui/ui_prefs.h:166: error: ‘class QGridLayout’ has no member named
 ‘setVerticalSpacing’
 ui/ui_prefs.h:176: error: ‘class QGridLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_prefs.h:177: error: ‘class QGridLayout’ has no member named
 ‘setTopMargin’
 ui/ui_prefs.h:178: error: ‘class QGridLayout’ has no member named
 ‘setRightMargin’
 ui/ui_prefs.h:179: error: ‘class QGridLayout’ has no member named
 ‘setBottomMargin’
 ui/ui_prefs.h:180: error: ‘class QGridLayout’ has no member named
 ‘setHorizontalSpacing’
 ui/ui_prefs.h:181: error: ‘class QGridLayout’ has no member named
 ‘setVerticalSpacing’
 ui/ui_prefs.h:184: error: ‘class QGridLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_prefs.h:185: error: ‘class QGridLayout’ has no member named
 ‘setTopMargin’
 ui/ui_prefs.h:186: error: ‘class QGridLayout’ has no member named
 ‘setRightMargin’
 ui/ui_prefs.h:187: error: ‘class QGridLayout’ has no member named
 ‘setBottomMargin’
 ui/ui_prefs.h:188: error: ‘class QGridLayout’ has no member named
 ‘setHorizontalSpacing’
 ui/ui_prefs.h:189: error: ‘class QGridLayout’ has no member named
 ‘setVerticalSpacing’
 ui/ui_prefs.h:242: error: ‘class QGridLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_prefs.h:243: error: ‘class QGridLayout’ has no member named
 ‘setTopMargin’
 ui/ui_prefs.h:244: error: ‘class QGridLayout’ has no member named
 ‘setRightMargin’
 ui/ui_prefs.h:245: error: ‘class QGridLayout’ has no member named
 ‘setBottomMargin’
 ui/ui_prefs.h:246: error: ‘class QGridLayout’ has no member named
 ‘setHorizontalSpacing’
 ui/ui_prefs.h:247: error: ‘class QGridLayout’ has no member named
 ‘setVerticalSpacing’
 ui/ui_prefs.h:270: error: ‘class QGridLayout’ has no member named
 ‘setLeftMargin’
 ui/ui_prefs.h:271: error: ‘class QGridLayout’ has no member named
 

Re: [Bacula-users] make bat troubles in bacula 3.0.0

2009-04-08 Thread John Drescher
 What can I do to solve this problem?


 Install Qt 4.3 or greater.


Ignore that. I was looking at the wrong class in the Qt docs.

John

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] PG database error

2009-04-08 Thread Tom Plancon




Craig,

Thanks for the response. I altered all the tables to owner "bacula",
ran catalogbackup and got the same error:

08-Apr 10:04 p-plover-dir JobId 5: BeforeJob: pg_dump: Error message
from server: ERROR: permission denied for relation contact_userid_seq

So I went in to the db via phpPgAdmin and checked the sequences. I had
been mucking around in the db changing permissions/owners a bit
haphazardly before I got your response. Sure enough, some of the
sequences where owned by another user even though all the bacula tables
were owned by bacula. Corrected that and now all is well!

Thanks again for the help and your clear and complete explanation! Very
helpful!

Craig Ringer wrote:
T. Plancon wrote:
  
  Hello,


I'm setting up bacula 2.4.2 on a CentOS 5 system using postgresql as
the

db. I've used the scripts in /usr/lib/bacula, running as user

'postgres'

  
  
Whoops. You should create the tables under user `bacula' if that's the
user ID your director runs under.
  
  
  create_postgresql_database,
make_postgresql_tables,

grant_postgresql_privileges in that order. An initial backup ran fine,

but I got this error when doing the catalog backup:


07-Apr 14:00 p-plover-dir JobId 1: BeforeJob: run command
"/usr/lib/bacula/make_catalog_backup bacula bacula"

07-Apr 14:00 p-plover-dir JobId 1: BeforeJob: pg_dump: SQL command
failed

07-Apr 14:00 p-plover-dir JobId 1: BeforeJob: pg_dump: Error message
from server: ERROR: permission denied for relation contact_userid_seq

  
  
If you connect to the database `bacula' as user `postgres' (usually:
  
sudo su postgres -c "psql bacula"
  
) and run:
  
\dt+
  
you'll probably find that the tables are owned by a user other than
`bacula' - in your case, `postgres'.
  
  
I landed up with a database where Bacula had been GRANTed SELECT,
INSERT, UPDATE and DELETE rights, but didn't have the right to LOCK
tables, so pg_dump would fail when run as user `bacula' by the
director. You probably have related rights issues.
  
  
To resolve this, just:
  
  
ALTER TABLE tablename OWNER TO bacula;
  
  
after connecting to the database as user `postgres' (since that'll be
the current owner in your case).
  
  
Unfortunately, Pg offers no way to recursively change ownership. Either
script it, or just enter the tables by hand; there aren't that many.
  
  
IMO, the make_postgreql_tables SQL script really needs to `\c - bacula'
(or "\c - ${bacula_user}" ... whatever) to ensure that it creates the
tables with appropriate ownership.
  
  
--
  
Craig Ringer
  
  


-- 
myEMAILsignature

 Thomas E. Plancon
CAD/IS Manager
B K A Architects, Inc.
142 Crescent Street
Brockton, MA 02302
tel: 508 . 583 . 5603 ext 313
fax: 508 . 584 . 2914
www.bkaarchitects.com




--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] backup speed is slow

2009-04-08 Thread Pascal Clermont
Dan Langille wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 Pascal Clermont wrote:
 Hi,
 I was reading the archives and stumbled upon [Bacula-users] Improving 
 Backup speed thread which caught my eye since I am having issues.
 we backup over 6TB of small files during a full usually started on Friday 
 night these are far from being finished on Mondays. the transfer on the wire 
 is usually finished within 24 hours.
 My bottleneck being Dir inserting Attributes in my database. I only have 
 2.5 Gb of ram on that machine and intend to upgrade by the end of the month. 
 (so far we intend to upgrade to 8gb of ram)

 Something in the thread caught my eye :

 
 On Thu, 15 Jan 2009 13:31:54 +0100, Bruno Friedmann br...@ioda-net.ch
 wrote:
 I added the following indexes:

 CREATE INDEX File_JobId_idx ON File(JobId);
 CREATE INDEX File_PathId_idx ON File(PathId);
 CREATE INDEX File_FilenameId_idx ON File(FilenameId);
 CREATE INDEX Path_PathId_idx ON Path(PathId);
 CREATE INDEX Job_FileSetId_idx ON Job(FileSetId);
 CREATE INDEX Job_ClientId_idx ON Job(ClientId);
 CREATE INDEX File_FilenameId-PathId_idx ON File(FilenameId,PathId);
 
 
 It remains to be seen whether the added indexing will impact insert/update
 performance, but I'll take a small performance hit if it means faster
 restores and sanity checks. 

 As I am no database expert, Would I benefit from creating these indexes in 
 order to speed up attributes inserting?
 My database is already at 137G in size with only about 3 months of jobs. 
 I've ran the dbcheck a few times ( which takes ~48 hours to complete ) but 
 do not feel an improvement once that is done.


 Any tips/comments concerning improving database insertion would be greatly 
 appreciated.
 
 I don't see any mention of MySQL or PostgreSQL.  Which are you using?
I am using postgresql 8

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] backula-sd.conf and MountCommand

2009-04-08 Thread Rae, Charles
I am new to bacula and am attempting to back up to a Network Appliance
Near Store NFS Mounted

I am unable to get the the NFS to mount. The backup works but places the
data in the regular directory.

It is like the mount command was never executed  

I am testing as root at this point so sudo is not an issue  I will
modify the mount and umount to sudo 
when I move to bacula user and production. 


Device {
Name = FileStorage
Device Type = File
Media Type = File
Archive Device = /BACULA
LabelMedia = yes
Random Access = yes
RemovableMedia = yes
AlwaysOpen = no
RequiresMount = yes
MountPoint = /BACULA
AutomaticMount = yes
UnmountCommand = /bin/umount /BACULA
MountCommand = /bin/mount zptlf05:/vol/bacula /BACULA
}


Thanks in advance

Charles Rae
/PREhtmlPSPAN style=FONT-SIZE: 8ptFONT color=#00FONT 
face=Arial
This communication and any files or attachments transmitted with it may contain 
information that is copyrighted or confidential and exempt from br  
disclosure under applicable law. It is intended solely for the use of the 
individual or the entity to which it is addressed. br
If you are not the intended recipient, you are hereby notified that any use, 
dissemination, or copying of this communication is strictly prohibited. br
If you have received this communication in error, please notify us at once so 
that we may take the appropriate action and avoid troubling you further. br 
Thank you for your cooperation. Please contact your local IT staff or email a 
href=mailto:i...@siltronic.com?subject=disclaimer;i...@siltronic.com/a if 
you need assistance.
/FONT/FONT/SPAN/P/html
--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] backula-sd.conf and MountCommand

2009-04-08 Thread John Drescher
 I am new to bacula and am attempting to back up to a Network Appliance Near
 Store NFS Mounted

 I am unable to get the the NFS to mount. The backup works but places the
 data in the regular directory.

 It is like the mount command was never executed ….

 I am testing as root at this point so sudo is not an issue ….
You started bacula-sd as root?

John

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Schedule full backups without interrupting incrementals

2009-04-08 Thread (private) HKS
Thanks for the responses. I created separate jobs for each of my
clients. Inelegant, but oh well.

-HKS

2009/4/8 Paweł Madej nysan...@quanteam.pl:
 Use separate job for the same fileset but with different schedule for tape
 backups then it will be clearly separated.

 On poniedziałek, 6 kwietnia 2009 23:42:21 Mike Ruskai wrote:
 On 04/06/2009 17:19, (private) HKS wrote:
  The obvious problem is that the weekly tape backup will disrupt my
  incremental/differential scheme. Is there any way to avoid this? I'm

 Use a separate job and file set.  Or maybe just a separate job - not
 sure which Bacula uses to calculate the backup level required.

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] I really need some help with bscan and trying to restore (repost)

2009-04-08 Thread Dan Langille
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Rick Knight wrote:
 Dan Langille wrote:
 John Drescher wrote:
  
 John,

 The out put of netstat -a -n | grep 9103 ...

 tcp0  0 127.0.0.1:9103  0.0.0.0:*  
 LISTEN

 Now how do I correct this?

   
 Edit bacula-sd.conf and put the real ip address in SDAddress instead
 of 127.0.0.1 or localhost.
 
 
 Work for someone: contact the downstream packager and see whether or not
  appropriate instructions are being provided to their users that these
 values must be updated to suit their situation.
 
 If it is documented, they aren't reading them.
 
 The number of support requests regarding this particular problem
 (localhost) seems to have increased significantly lately.
 
 This is not directed at the OP.
 

 Now that I have this working, even though incorrectly, I want to use
 bscan to scan the rest of my media. I know at least one of my tapes has
 my previous Bacula settings and I want to reuse those. Problem is, some
 of the labels I wrote on the tapes do not match the actual tape label as
 bacula and bscan see it. Is there a way to have bscan or bacula report
 the volume name so that I can scan the volume? When I run bscan without
 a volume name it complains about no volume name, if I use an incorrect
 volume name it times out waiting for a volume that is not inserted.

Rick: please remember to CC the list too on these emails.  That way, if
I'm busy, someone else can help.  Plus, you have the added security of
knowing that when things are public, you are much less likely to receive
 malicious advice.

That said, sorry, I can't help just now.

- --
Dan Langille

BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon  - The PostgreSQL Conference: http://www.pgcon.org/
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.11 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAknc5rAACgkQCgsXFM/7nTx1NQCffwsTS/10Wh9KmD8eesnu4cq5
kAMAoPsfg6aA2C1LBtlwef8YvhwcHQ56
=GPKM
-END PGP SIGNATURE-

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] backup speed is slow

2009-04-08 Thread Dan Langille
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Pascal Clermont wrote:
 Dan Langille wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Pascal Clermont wrote:
 Hi,
 I was reading the archives and stumbled upon [Bacula-users]
 Improving Backup speed thread which caught my eye since I am having
 issues.
 we backup over 6TB of small files during a full usually started on
 Friday night these are far from being finished on Mondays. the
 transfer on the wire is usually finished within 24 hours.
 My bottleneck being Dir inserting Attributes in my database. I only
 have 2.5 Gb of ram on that machine and intend to upgrade by the end
 of the month. (so far we intend to upgrade to 8gb of ram)

 Something in the thread caught my eye :

 
 On Thu, 15 Jan 2009 13:31:54 +0100, Bruno Friedmann br...@ioda-net.ch
 wrote:
 I added the following indexes:

 CREATE INDEX File_JobId_idx ON File(JobId);
 CREATE INDEX File_PathId_idx ON File(PathId);
 CREATE INDEX File_FilenameId_idx ON File(FilenameId);
 CREATE INDEX Path_PathId_idx ON Path(PathId);
 CREATE INDEX Job_FileSetId_idx ON Job(FileSetId);
 CREATE INDEX Job_ClientId_idx ON Job(ClientId);
 CREATE INDEX File_FilenameId-PathId_idx ON File(FilenameId,PathId);
 
 
 It remains to be seen whether the added indexing will impact
 insert/update
 performance, but I'll take a small performance hit if it means faster
 restores and sanity checks. 

 As I am no database expert, Would I benefit from creating these
 indexes in order to speed up attributes inserting?
 My database is already at 137G in size with only about 3 months of
 jobs. I've ran the dbcheck a few times ( which takes ~48 hours to
 complete ) but do not feel an improvement once that is done.


 Any tips/comments concerning improving database insertion would be
 greatly appreciated.

 I don't see any mention of MySQL or PostgreSQL.  Which are you using?
 I am using postgresql 8

8.1?  8.3?  There are significant differences in performance there IIRC.

The following query will tell: select version()


- --
Dan Langille

BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon  - The PostgreSQL Conference: http://www.pgcon.org/
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.11 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAknc5usACgkQCgsXFM/7nTwldACfVQwhLoeyBx17uEwhY7TidOmE
65YAn3y+E5IyQdWPnNodVct+wrQvtCAH
=6a1N
-END PGP SIGNATURE-

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] I really need some help with bscan and trying to restore (repost)

2009-04-08 Thread Rick Knight
Dan Langille wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Rick Knight wrote:
   
 Dan Langille wrote:
 John Drescher wrote:
  
 
 John,

 The out put of netstat -a -n | grep 9103 ...

 tcp0  0 127.0.0.1:9103  0.0.0.0:*  
 LISTEN

 Now how do I correct this?

   
 
 Edit bacula-sd.conf and put the real ip address in SDAddress instead
 of 127.0.0.1 or localhost.
 
   
 Work for someone: contact the downstream packager and see whether or not
  appropriate instructions are being provided to their users that these
 values must be updated to suit their situation.

 If it is documented, they aren't reading them.

 The number of support requests regarding this particular problem
 (localhost) seems to have increased significantly lately.

 This is not directed at the OP.

 

   
 Now that I have this working, even though incorrectly, I want to use
 bscan to scan the rest of my media. I know at least one of my tapes has
 my previous Bacula settings and I want to reuse those. Problem is, some
 of the labels I wrote on the tapes do not match the actual tape label as
 bacula and bscan see it. Is there a way to have bscan or bacula report
 the volume name so that I can scan the volume? When I run bscan without
 a volume name it complains about no volume name, if I use an incorrect
 volume name it times out waiting for a volume that is not inserted.
 

 Rick: please remember to CC the list too on these emails.  That way, if
 I'm busy, someone else can help.  Plus, you have the added security of
 knowing that when things are public, you are much less likely to receive
  malicious advice.

 That said, sorry, I can't help just now.

 - --
 Dan Langille

 BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
 PGCon  - The PostgreSQL Conference: http://www.pgcon.org/
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v2.0.11 (FreeBSD)
 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

 iEYEARECAAYFAknc5rAACgkQCgsXFM/7nTx1NQCffwsTS/10Wh9KmD8eesnu4cq5
 kAMAoPsfg6aA2C1LBtlwef8YvhwcHQ56
 =GPKM
 -END PGP SIGNATURE-
   
Now that I have this working, even though incorrectly, I want to use 
bscan to scan the rest of my media. I know at least one of my tapes has 
my previous Bacula settings and I want to reuse those. Problem is, some 
of the labels I wrote on the tapes do not match the actual tape label as 
bacula and bscan see it. Is there a way to have bscan or bacula report 
the volume name so that I can scan the volume? When I run bscan without 
a volume name it complains about no volume name, if I use an incorrect 
volume name it times out waiting for a volume that is not inserted.

Thanks again,
Rick

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] I really need some help with bscan and trying to restore (repost)

2009-04-08 Thread John Drescher
 I was finally able to get things to work by changing Address from my
 machine name, rick-desktop, to the localhost address 127.0.0.1 in the
 bacula config files.

Hmm. The correct fix is to remove 127.0.0.1 and localhost from all
bacula files and put the external ipaddress in it if you plan on
backing up more than 1 machine ever. Otherwise you can keep bacula
locked down as a single system network backup program.

 Clearly this is not the way it should work. Is it
 just a matter of the Debian/Kubuntu packager being too paranoid?

Yes, they effectively make bacula a single machine backup program
(with the exception of the ssh tunneling backups). However they do the
same with apache which is just as nuts. I mean install an Apache web
server that only the local host can access, I am sure there are good
reasons for this however 99% of users will have to change the
default..

John

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] What is jobStatus 'W' in migrate.c?

2009-04-08 Thread Brian Debelius
Hi,

What is Job.JobStatus 'W' in migrate.c?  I do not see that status in my 
table.

brian-

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Deduplication feature

2009-04-08 Thread Corneliu P
Ok, then I am sending attached a new feature request.
Looking forward to its implementation - I'll look carefully for news
about it so to test it as soon as it is available.

Thanks,
Corneliu

On Wed, Apr 8, 2009 at 9:58 AM, Marc Schiffbauer m...@schiffbauer.net wrote:
 * Corneliu P schrieb am 08.04.09 um 15:08 Uhr:
 Hi all,

 Does Bacula support deduplication feature?

 That is, for the backup software to detect duplicate files and not
 actually backup duplicates, but store a pointer to original backed up
 file, and make all this transparent on restore operations?


 No. But it may be listed in the feature request list...

 -Marc
 --
 8AAC 5F46 83B4 DB70 8317  3723 296C 6CCA 35A6 4134

 --
 This SF.net email is sponsored by:
 High Quality Requirements in a Collaborative Environment.
 Download a free trial of Rational Requirements Composer Now!
 http://p.sf.net/sfu/www-ibm-com
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users

Feature Request Form

Item 1:   Implement Deduplication feature
  Origin: Corneliu Popescu, corneliu.popescu_at_gmail_dot_com
  Date:   8 April 2009
  Status: New

  What:   Detect duplicate files and not actually backup duplicates, but 
  store a pointer to original backed up file, and make all this 
  transparent on restore operations.


  Why:It would eliminate redundancy therefore optimizing resource 
  usage during backup: storage space, network bandwidth, backup 
  window time. Especially in case of backing up multiple similar 
  systems (like end-user workstations for example) this would 
  dramatically improve performance.

  Notes:  Feature could be implemented via a checksum calculation. Checksum 
  number could be stored in the database along with file information 
  and could be searched for, to identify previous backed up copies of 
  the same file, regardless of original filename and path. 

  On having to back up a file, first a checksum calculation could be 
  done locally by the backup agent. Then the agent would sent checksum
  and other necessary file information (like filename and path) to the
  server. The server would search for the checksum in its database to
  identify previously backed up copy of the same file. If not found, 
  the server would continue to backup the file normally, asking the 
  agent to send over the network the actual file content. Additionally 
  the server would store the checksum along with the 
other file 
  information in the file's new database record, to allow for future 
  searches. If found, the server would consider it as duplicate, ask 
  the agent to mark the file as already backed up (therefore not 
  sending actual file content over the network) and to just continue 
  with the next file. Additionally, the server would create a new 
  database record for the duplicate file and also would store a pointer
  to the database record of the original file, so to be able to locate
  previously backed up content on a future restore request.

  On having to restore a file, the server would first have to identify
  if the file is a duplicate or not. If it is not a duplicate, restore
  would continue normally. If it's a duplicate, then the server would 
  follow the original file pointer, locate original's file content and 
  then push it to the agent as the duplicate file.

  Since implementing this feature would increase the probability to 
  have to restore files from different media, some additional 
  optimization of the restore job might be necessary (to restore at 
  once all files stored on the same media, independent of restore file 
  sequence). Also, apropriate backup media management would be 
  required, to make as sure as possible that duplicate file content 
  still exists and can be accessed by a future restore job. 

  The backup admin should be able to enable or disable this feature by 
  job, as needed.

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] TLS negotiation handshake errors

2009-04-08 Thread baculalist

Hello List,

Bacula 2.4.4 and OpenSSL 0.9.8k on Solaris x86 11 (nv-b91),
everything is hand compiled but nothing special.

  Director hostname back1.host.com: Solaris x86 11 (nv-b91)
  File daemon hostname back1.host.com: Solaris x86 11 (nv-b91)

  Errors seen on the director:
  08-Apr 09:36 bacsrv-dir JobId 40: Start Backup JobId 40, 
Job=Debut.2009-04-08_09.36.52.03
  08-Apr 09:36 bacsrv-dir JobId 40: Using Device FileStorage
  08-Apr 09:37 bacsrv-dir JobId 0: Error: openssl.c:86 Connect failure: 
ERR=error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number
  08-Apr 09:37 bacsrv-dir JobId 40: Fatal error: TLS negotiation failed with FD 
at back1.host.com:9102.

If I try:

  back1$ /pfx/bin/openssl s_client -connect back1.host.com:9102
  CONNECTED(0004)
  10511:error:140790E5:SSL routines:SSL23_WRITE:ssl handshake 
failure:s23_lib.c:188:

If I try:

  back1# /pfx/bin/openssl s_server -accept 1080 -cert bacula-crt.pem -key 
bacula-key.pem -CAfile certauth.pem
  back1$ /pfx/bin/openssl s_client -connect back1.host.com:1080

...everything works and TLS negotiation succeeds without errors.

By the way, an identical (same versions and config files) setup
with two other hosts Ubuntu 8.04 server AMD64 and OpenSUSE 11
AMD64 succeeds.

My question is, 'have you seen this (SSL3_GET_RECORD:wrong version
number) or similar errors appearing in bacula? Any idea how to rid
the daemons of this problem?

Where is the openssl code which is responsible for the TLS
negotiation and handshake - src/lib/openssl.c?

Thanks,
Eduard


--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] make bat troubles in bacula 3.0.0

2009-04-08 Thread Kelvin Raywood
JanJaap Scholing janjaapschol...@hotmail.com:
 I'm trying to install bat.
 ./configure --enable-lockmgr --with-mysql --enable-bat --disable-libtool
 looks ok

 But when I make I see the following error messages:

[snip]

 I use Debian 4 with qt4 installed (4.2.1-2+etch1), bacula 3.0.0 (latest svn)
 What can I do to solve this problem?

John Drescher wrote:
 Install Qt 4.3 or greater.

 Ignore that. I was looking at the wrong class in the Qt docs.

I think the first advice was correct.  I recently had the same problem 
myself building  bacula-2.5.42-b2 on CentOS-5 which includes QT4.2.1 .

I grabbed qt 4.3.4 srpm from Fedora-7 and did

  rpmbuild --rebuild --define 'dist .el5' --define 'rhel 5' \
qt4-4.3.4-14.fc7.src.rpm

  yum localinstall qt4-4.3.4-14.el5.x86_64.rpm \
   qt4-devel-4.3.4-14.el5.x86_64.rpm \
   qt4-x11-4.3.4-14.el5.x86_64.rpm

I installed qwt-devel from EPEL.

BAT built and runs fine.

Kel Raywood

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] PG Insert NEVER stops

2009-04-08 Thread mehma sarja
PROBLEM - I have run multiple fulls and have NEVER been able to complete a
PG insert operation. Granted my fileset is large - about 9.8 million files,
~700GB. What am I doing wrong?

SYSTEM
FreeBSD  7.1-RELEASE system, 8 GB RAM, 4 core AMD 64 processor, SUN Ultra 40

DATABASE
Postgresql version 8.2

postgresql.conf

shared_buffers = 20MB
temp_buffers = 96MB
max_prepared_transactions = 10
work_mem = 512MB
maintenance_work_mem = 256MB
max_stack_depth = 525kB
checkpoint_segments = 15
autovacuum = off


DIR
bacula-dir.conf
Director {  # define myself
  Name = titanic-dir  # director name
  DIRport = 9101# where director
listens for console connections
  QueryFile = /usr/local/share/bacula/query.sql   # query commands for
console
  WorkingDirectory = /var/db/bacula   # Director puts status files
here
  PidDirectory = /var/run # Director puts puts
process Id file here
  Maximum Concurrent Jobs = 1   # max # of total Director
Jobs that should run concurrently
  Password = something   # Console
password
  Messages = Daemon  # Director messages
not associated with a specific Job
}

JobDefs {
  Name = DefaultJob   # Job name specified in console Run
command to start a job
  Type = Backup
  Level = Incremental   # files changed since the last
backup of the same Job
  Client = zydeco-fd# Client (File daemon) that will be
used in the current Job
  FileSet = Full Set  # Name of file set used for the
current job
  Schedule = MonthlyCycle
  Storage = File# name of storage services to backup
FileSet
  Messages = Standard   # Messages resource used for this
job
  Pool = Default# defines the pool of Volumes
  Priority = 10 # control the order in which jobs
will be run
}


# Define the main nightly save backup job
# By default, this job will back up to disk
Job {
  Name = zydeco
  JobDefs = DefaultJob
  Write Bootstrap = /var/db/bacula/zydeco.bsr
# Bacula writes a bootstrap
file for each Backup job run
}

# Backup the catalog database (after the nightly save)
Job {
  Name = BackupCatalog
  JobDefs = DefaultJob
  Level = Full
  FileSet=Catalog
  Schedule = MonthlyCycleAfterBackup
  # This creates an ASCII copy of the catalog
  # Arguments to make_catalog_backup are:
  #  make_catalog_backup database-name user-name password host
  RunBeforeJob = /usr/local/share/bacula/make_catalog_backup bacula pgsql
  # This deletes the copy of the catalog
  RunAfterJob  = /usr/local/share/bacula/delete_catalog_backup
  Write Bootstrap = /var/db/bacula/BackupCatalog.bsr
  Priority = 11   # run after main backup
}

 # Standard Restore template, to be changed by Console program
#  Only one such job is needed for all Jobs/Clients/Storage ...
Job {
  Name = RestoreFiles
  Type = Restore
  Client=zydeco-fd
  FileSet=Full Set
  Storage = File
  Pool = Default
  Messages = Standard
  Where = /array/bacula-restores
}

# List of files to be backed up
FileSet {
Name = Full Set
  Include {
Options {
  signature = MD5
  noatime=yes
  onefs=yes
}
  File = /array/home
  }
}

# This is the backup of the catalog
FileSet {
  Name = Catalog
  Include {
Options {
  signature = MD5
}
File = /var/db/bacula/bacula.sql
  }
}

Schedule {
  Name = MonthlyCycle
  Run = Level=Full Pool=Default 1st fri at 17:05
  Run = Level=Differential 2nd-5th fri at 17:05
  Run = Level=Incremental Pool=Default mon-sat at 17:05
}

# This schedule does the catalog. It starts after the WeeklyCycle
Schedule {
  Name = MonthlyCycleAfterBackup
  Run = Full sun-sat at 23:10
}

# Client (File Services) to backup
Client {
  Name = zydeco-fd
  Address = zydeco
  FDPort = 9102
  Catalog = MyCatalog
  Password = bacula  # password for FileDaemon
  File Retention = 30 days# 30 days
  Job Retention = 6 months# six months
  AutoPrune = yes # Prune expired Jobs/Files
}

# Definition of file storage device
Storage {
  Name = File
# Do not use localhost here
  Address = titanic.ucolick.org# N.B. Use a fully qualified
name here
  SDPort = 9103
  Password = bacula
  Device = FileStorage
  Media Type = File
}



# Generic catalog service
Catalog {
  Name = MyCatalog
  dbname = db_bacula; dbuser = pg_user; dbpassword = something
}

# Reasonable message delivery -- send most everything to email address
#  and to the console
Messages {
  Name = Standard
 mailcommand = /usr/local/sbin/bsmtp -h localhost -f \\(Bacula\) \%r\\
-s \
Bacula: %t %e of %c %l\ %r
  operatorcommand = /usr/local/sbin/bsmtp -h localhost -f \\(Bacula\)
\%r\\
-s \Bacula: 

Re: [Bacula-users] PG Insert NEVER stops

2009-04-08 Thread Dan Langille
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

mehma sarja wrote:
 PROBLEM - I have run multiple fulls and have NEVER been able to complete
 a PG insert operation. Granted my fileset is large - about 9.8 million
 files, ~700GB. What am I doing wrong?

Well, you've not told us much.  What happens when you run the job?
Perhaps the job output would help.

- --
Dan Langille

BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon  - The PostgreSQL Conference: http://www.pgcon.org/
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.11 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkndLXMACgkQCgsXFM/7nTwVYACfYELqPJy3vMHEJh+Sc7IpNCMO
hPgAoJtHQmFyYu1V42po3oajF1D/IRwv
=3/tF
-END PGP SIGNATURE-

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] TLS negotiation handshake errors

2009-04-08 Thread Dan Langille
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

baculal...@encambio.com wrote:
 Hello List,
 
 Bacula 2.4.4 and OpenSSL 0.9.8k on Solaris x86 11 (nv-b91),
 everything is hand compiled but nothing special.
 
   Director hostname back1.host.com: Solaris x86 11 (nv-b91)
   File daemon hostname back1.host.com: Solaris x86 11 (nv-b91)
 
   Errors seen on the director:
   08-Apr 09:36 bacsrv-dir JobId 40: Start Backup JobId 40, 
 Job=Debut.2009-04-08_09.36.52.03
   08-Apr 09:36 bacsrv-dir JobId 40: Using Device FileStorage
   08-Apr 09:37 bacsrv-dir JobId 0: Error: openssl.c:86 Connect failure: 
 ERR=error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number
   08-Apr 09:37 bacsrv-dir JobId 40: Fatal error: TLS negotiation failed with 
 FD at back1.host.com:9102.
 
 If I try:
 
   back1$ /pfx/bin/openssl s_client -connect back1.host.com:9102
   CONNECTED(0004)
   10511:error:140790E5:SSL routines:SSL23_WRITE:ssl handshake 
 failure:s23_lib.c:188:
 
 If I try:
 
   back1# /pfx/bin/openssl s_server -accept 1080 -cert bacula-crt.pem -key 
 bacula-key.pem -CAfile certauth.pem
   back1$ /pfx/bin/openssl s_client -connect back1.host.com:1080
 
 ...everything works and TLS negotiation succeeds without errors.
 
 By the way, an identical (same versions and config files) setup
 with two other hosts Ubuntu 8.04 server AMD64 and OpenSUSE 11
 AMD64 succeeds.
 
 My question is, 'have you seen this (SSL3_GET_RECORD:wrong version
 number) or similar errors appearing in bacula? Any idea how to rid
 the daemons of this problem?

I Googled. I found:

http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg04842.html

Does that help?

- --
Dan Langille

BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon  - The PostgreSQL Conference: http://www.pgcon.org/
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.11 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkndLdwACgkQCgsXFM/7nTxOwQCgkfd7KaWBOPcvEMiTVb3aVvJg
XQQAoNF1z+SgnkchG2ky21iQIEQHWX+e
=lWLx
-END PGP SIGNATURE-

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] restore file in folder with accent

2009-04-08 Thread James Harper
 
 Hi All !
 
 I would like to restore a file which is in a folder named « Mes données ». As
 you can see there is accent in the folder's  name. So i can't enter in the
 folder on bconsole :
 
 $ dir
 
 -drwxrwxrwx   1 root wheel0  2009-04-08 13:58:38  C:/Rep1/Mes
 données/
 
 -rwxrwxrwx   1 root wheel8  2009-04-08 13:58:34
 C:/Rep1/héhé lol.txt
 
  $ cd Mes donnes (i can't write the good name, putty said wuff --- wuff !!)
 

Can you copy and paste the filename using the mouse (putty or gpm or whatever)?

Do you have all the correct locale's set?

James

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] TLS negotiation handshake errors

2009-04-08 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dan Langille wrote:
 baculal...@encambio.com wrote:
 Hello List,
 
 Bacula 2.4.4 and OpenSSL 0.9.8k on Solaris x86 11 (nv-b91),
 everything is hand compiled but nothing special.
 
   Director hostname back1.host.com: Solaris x86 11 (nv-b91)
   File daemon hostname back1.host.com: Solaris x86 11 (nv-b91)
 
   Errors seen on the director:
   08-Apr 09:36 bacsrv-dir JobId 40: Start Backup JobId 40, 
 Job=Debut.2009-04-08_09.36.52.03
   08-Apr 09:36 bacsrv-dir JobId 40: Using Device FileStorage
   08-Apr 09:37 bacsrv-dir JobId 0: Error: openssl.c:86 Connect failure: 
 ERR=error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number
   08-Apr 09:37 bacsrv-dir JobId 40: Fatal error: TLS negotiation failed with 
 FD at back1.host.com:9102.
 
 If I try:
 
   back1$ /pfx/bin/openssl s_client -connect back1.host.com:9102
   CONNECTED(0004)
   10511:error:140790E5:SSL routines:SSL23_WRITE:ssl handshake 
 failure:s23_lib.c:188:
 
 If I try:
 
   back1# /pfx/bin/openssl s_server -accept 1080 -cert bacula-crt.pem -key 
 bacula-key.pem -CAfile certauth.pem
   back1$ /pfx/bin/openssl s_client -connect back1.host.com:1080
 
 ...everything works and TLS negotiation succeeds without errors.
 
 By the way, an identical (same versions and config files) setup
 with two other hosts Ubuntu 8.04 server AMD64 and OpenSUSE 11
 AMD64 succeeds.
 
 My question is, 'have you seen this (SSL3_GET_RECORD:wrong version
 number) or similar errors appearing in bacula? Any idea how to rid
 the daemons of this problem?
 
 I Googled. I found:
 
 http://www.mail-archive.com/bacula-users@lists.sourceforge.net/msg04842.html
 
 Does that help?

Having done this myself (and having had the good sense to Google it, I
might add ;)), I concur -- this is very likely the problem.

- --
  _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
 |$| |__| |  | |__/ | \| _| |novos...@umdnj.edu - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/CST - NJMS Medical Science Bldg - C630
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkndLpsACgkQmb+gadEcsb4v9QCgi3+Y2xdMGsjI4HOIubg+eCMC
bPgAn32yP23APNGb4R2EGFqvumYKJZot
=nNUO
-END PGP SIGNATURE-
begin:vcard
fn:Ryan Novosielski
n:Novosielski;Ryan
org:UMDNJ;IST/AST
adr;dom:MSB C630;;185 South Orange Avenue;Newark;NJ;07103
email;internet:novos...@umdnj.edu
title:Systems Programmer II
tel;work:(973) 972-0922
tel;fax:(973) 972-7412
tel;pager:(866) 20-UMDNJ
x-mozilla-html:FALSE
version:2.1
end:vcard

--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] make bat troubles in bacula 3.0.0

2009-04-08 Thread Dirk Bartley
I have done a patch for being able to install on the older qt.  If you
wat it, let me know.  I'll hunt it down.  The issue is not with the
programming but the version of designer I was using.  If I open with an
older designer and solve a couple of issues it compiled just fine on
centos.

I'm trying not to keep so up to date lately.

Dirk


On Wed, 2009-04-08 at 15:27 -0700, Kelvin Raywood wrote:
 JanJaap Scholing janjaapschol...@hotmail.com:
  I'm trying to install bat.
  ./configure --enable-lockmgr --with-mysql --enable-bat --disable-libtool
  looks ok
 
  But when I make I see the following error messages:
 
 [snip]
 
  I use Debian 4 with qt4 installed (4.2.1-2+etch1), bacula 3.0.0 (latest 
  svn)
  What can I do to solve this problem?
 
 John Drescher wrote:
  Install Qt 4.3 or greater.
 
  Ignore that. I was looking at the wrong class in the Qt docs.
 
 I think the first advice was correct.  I recently had the same problem 
 myself building  bacula-2.5.42-b2 on CentOS-5 which includes QT4.2.1 .
 
 I grabbed qt 4.3.4 srpm from Fedora-7 and did
 
   rpmbuild --rebuild --define 'dist .el5' --define 'rhel 5' \
 qt4-4.3.4-14.fc7.src.rpm
 
   yum localinstall qt4-4.3.4-14.el5.x86_64.rpm \
qt4-devel-4.3.4-14.el5.x86_64.rpm \
qt4-x11-4.3.4-14.el5.x86_64.rpm
 
 I installed qwt-devel from EPEL.
 
 BAT built and runs fine.
 
 Kel Raywood
 
 --
 This SF.net email is sponsored by:
 High Quality Requirements in a Collaborative Environment.
 Download a free trial of Rational Requirements Composer Now!
 http://p.sf.net/sfu/www-ibm-com
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Backups are failing for one client

2009-04-08 Thread Steve O'Brien
Hi all,
I have been trying to figure out why one of my clients cannot get a successful 
backup.  Here is the output:
08-Apr 13:17 backup01-dir JobId 6524: Start Backup JobId 6524, 
Job=esis-db.2009-04-08_13.17.10
08-Apr 13:17 backup01-dir JobId 6524: Using Device LTO-2
esis-db-fd JobId 6524:  Disallowed filesystem. Will not descend from / into 
/selinux
esis-db-fd JobId 6524:  Disallowed filesystem. Will not descend from / into 
/var/lib/nfs/rpc_pipefs
08-Apr 13:27 esis-db-fd JobId 6524: Fatal error: backup.c:892 Network send 
error to SD. ERR=Broken pipe
08-Apr 13:27 backup01-sd JobId 6524: Fatal error: append.c:259 Network error on 
data channel. ERR=Connection reset by peer
08-Apr 13:27 backup01-sd JobId 6524: Job write elapsed time = 00:09:51, 
Transfer rate = 7.579 M bytes/second
08-Apr 13:27 backup01-sd JobId 6524: Error: bsock.c:444 Read error from 
client:10.128.10.20:36643: ERR=Connection reset by peer
08-Apr 13:27 backup01-dir JobId 6524: Error: Bacula backup01-dir 2.4.3 
(10Oct08): 08-Apr-2009 13:27:14
  Build OS:   x86_64-unknown-linux-gnu redhat Enterprise release
  JobId:  6524
  Job:esis-db.2009-04-08_13.17.10
  Backup Level:   Full
  Client: esis-db-fd 2.4.2 (26Jul08) 
x86_64-redhat-linux-gnu,redhat,
  FileSet:FullLinux-esis-db 2009-04-08 09:59:00
  Pool:   Default (From Job resource)
  Storage:PowerVault (From Job resource)
  Scheduled time: 08-Apr-2009 13:17:09
  Start time: 08-Apr-2009 13:17:13
  End time:   08-Apr-2009 13:27:14
  Elapsed time:   10 mins 1 sec
  Priority:   10
  FD Files Written:   12,653
  SD Files Written:   12,653
  FD Bytes Written:   4,477,785,876 (4.477 GB)
  SD Bytes Written:   4,479,712,237 (4.479 GB)
  Rate:   7450.6 KB/s
  Software Compression:   None
  VSS:no
  Storage Encryption: no
  Volume name(s): 26L2
  Volume Session Id:  3
  Volume Session Time:1239209904
  Last Volume Bytes:  164,096,916,480 (164.0 GB)
  Non-fatal FD errors:0
  SD Errors:  0
  FD termination status:  Error
  SD termination status:  Error
  Termination:*** Backup Error ***

Here is the fileset config:
FileSet {
  Name = FullLinux-esis-db
  Include {
Options {
  Signature = MD5
  OneFS = no
  Sparse = yes
  ACLSupport = yes
  FSType = ext2
  Exclude = yes
 wildDir = /proc
 wildDir = /sys
 wildDir = /var/run/*
 wildDir = /var/spool/clientmqueue/*
 wildDir = /lost+found/*
 wildDir = /DB/*
}
File = /
  }
}

I tried upgrading the ethernet driver (e100e) with no luck.  I also changed the 
fileset config thinking that maybe it was getting hung up on the Oracle 
database in /DB and changed from an exclude { section to the wilddir.  It seems 
to fail almost at the same point every time.  Let me know if you need any other 
info.

TIA,
Steve
--
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users