Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Erik P. Olsen
Frank Sweetser wrote: On Tue, Feb 20, 2007 at 01:04:44AM +0100, Erik P. Olsen wrote: I wasn't aware that it was important to run dbcheck at certain intervals. So I sat it up about 8 hours ago. It showed 4919334 orphaned file records and it is now deleting them. How long time is it supposed to

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Kern Sibbald
On Monday 19 February 2007 15:06, Frank Altpeter wrote: On 2/19/07, Bill Moran [EMAIL PROTECTED] wrote: In response to Frank Altpeter [EMAIL PROTECTED]: My current bacula system (FreeBSD, bacula-2.0.1, mysql-4.1) has currently some massive performance problems. One of the reasons i

Re: [Bacula-users] RunBeforeJob variable expansion

2007-02-20 Thread Eric Bollengier
Hi, I'm working on writing a perl script that will backup volumes in my AFS cell by dumping them to a NFS share. I'm running this as a RunBeforeJob script using some of the variable expansion features of bacula to fill in the arguments to the script. I have a question regarding the

Re: [Bacula-users] Tape robot

2007-02-20 Thread Geir Asle Borgen
Sorry I forgot to send the error messages: 16-Feb 16:02 dracula-sd: Please mount Volume VOlUME-Dracula-Tape-2007.02.14 on Storage Device DLT8000-Dracula (/dev/nst0) for Job Torvalds.2007-02-16_15.49.17 16-Feb 15:49 helsing-dir: Start Backup JobId 2845, Job=Torvalds.2007-02-16_15.49.17 16-Feb

Re: [Bacula-users] No Job status returned from FD with windows server 2003

2007-02-20 Thread Silver Salonen
Um.. OK, should have read mailing lists first - setting Heartbeat Interval = 60 seconds on FD helped. Silver On Monday 19 February 2007 15:31, Silver Salonen wrote: Hi. I've got Bacula server 2.0.2 running on FreeBSD-6.1 and client 2.0.2 running on Windows 2003 (with Exchange 2003).

Re: [Bacula-users] RunBeforeJob variable expansion

2007-02-20 Thread Scott Peshak
On Feb 20, 2007, at 2:46 AM, Eric Bollengier wrote: Hi, I'm working on writing a perl script that will backup volumes in my AFS cell by dumping them to a NFS share. I'm running this as a RunBeforeJob script using some of the variable expansion features of bacula to fill in the arguments

Re: [Bacula-users] Upgrading from 1.36.1 - 2.0.2 - not going smoothly.

2007-02-20 Thread Andrew Paterson
Kern Sibbald wrote: My best guess is that the indexes did not get properly generated some where along the line. Whether the indexes were not there in 1.36.1 or they got lost or need rebuilding when upgrading I am not sure -- this seems to have happened to other users. I recommend that

Re: [Bacula-users] Issue with multiple drives and autochanger

2007-02-20 Thread Adam Cécile
Hi, Any suggest I could start looking at ? Regards, Adam Cécile. Adam Cécile a écrit : Hello, I have set up a bacula installation with a Dell 132T autochanger (/dev/sg2). It has two LOT3 drives, /dev/nst0 and /dev/nst1. Both drives works fine with the mtx-changer script. Currently backup

[Bacula-users] Bad load-unload sequence

2007-02-20 Thread Gabriele Bulfon
Hello, I had a strange problem this Saturday night on an LTO library. Bacula was in a consistent state, after the Friday nightly backup. The drive 0 was loaded with slot 4 (friday tape). At saturday job startup, the associated volumes were correctly recycled, and bacula started moving the tapes.

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Eric Bollengier
I wasn't aware that it was important to run dbcheck at certain intervals. So I sat it up about 8 hours ago. It showed 4919334 orphaned file records and it is now deleting them. How long time is it supposed to take? It has now been deleting for almost 8 hours and mysqld takes about 85% of the

Re: [Bacula-users] RunBeforeJob variable expansion

2007-02-20 Thread Eric Bollengier
I could not find any definitive answer in the manual and couldn't find it right away when looking at the source. Also is there any timeframe of when (or even if) the format of the timestamp will be user configurable? I saw some comments in lib/ btime.c about it and I for one would

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Kern Sibbald
On Tuesday 20 February 2007 09:05, Erik P. Olsen wrote: Frank Sweetser wrote: On Tue, Feb 20, 2007 at 01:04:44AM +0100, Erik P. Olsen wrote: I wasn't aware that it was important to run dbcheck at certain intervals. So I sat it up about 8 hours ago. It showed 4919334 orphaned file records

Re: [Bacula-users] limit the size of storage files

2007-02-20 Thread Kern Sibbald
On Tuesday 20 February 2007 07:23, Florin Andrei wrote: Florin Andrei wrote: I've a chicken-and-egg problem with recovering the MySQL database from the DVDs, since it appears that I need it to run Bacula to begin with. Nevermind, I figure that one out. RTFM :-) How about coining a new

Re: [Bacula-users] are SELinux attributes backed up / restored?

2007-02-20 Thread Kern Sibbald
On Tuesday 20 February 2007 07:54, Florin Andrei wrote: With v2.0.2 on a recent Linux distro that supports SELinux, if I do a restore from a backup, will the SELinux attributes of the files be restored too? Is there any connection between SELinux attributes and aclsupport = yes ? I would

Re: [Bacula-users] Job Migration and Catalog

2007-02-20 Thread Kern Sibbald
On Tuesday 20 February 2007 04:10, Support wrote: Dear All I have adopted job migration and all seems to work well with clients that were already in the Catalog when the backup was direct to tape (after spooling). I have an old client that had not been backed up for 6 weeks and so had no

Re: [Bacula-users] limit the size of storage files

2007-02-20 Thread Steve Barnes
I thought it meant Read The Friendly Manual any how? ;D -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kern Sibbald Sent: 20 February 2007 14:09 To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] limit the size of storage files On

Re: [Bacula-users] Issue with multiple drives and autochanger

2007-02-20 Thread Kern Sibbald
On Tuesday 20 February 2007 10:47, Adam Cécile wrote: Hi, Any suggest I could start looking at ? 1. Run the SD with debug level 100. 2. Look at doc for PreferMountedVolumes 3. Although you provided your conf files (very useful), you did not say what version of Bacula you are using

Re: [Bacula-users] Bad load-unload sequence

2007-02-20 Thread Kern Sibbald
You didn't mention which version of Bacula you are using. I seem to recall that this was just a problem of incorrectly printing the slot number. More recent versions of Bacula (2.0.x) print the details of why the script failed, which makes debugging these problems easier. On Tuesday 20

Re: [Bacula-users] Issue with multiple drives and autochanger

2007-02-20 Thread Adam Cécile
Kern Sibbald a écrit : On Tuesday 20 February 2007 10:47, Adam Cécile wrote: Hi, Any suggest I could start looking at ? 1. Run the SD with debug level 100. 2. Look at doc for PreferMountedVolumes Thanks a lot, it was my mistake ;-) 3. Although you provided your conf files

Re: [Bacula-users] Segmentation Fault on RHEL4

2007-02-20 Thread Jason King
That got it fixed! I just needed to install the 64 bit version of the bacula-client. I assumed the 64bit version would be available from bacula.org through their sourceforge CVS but apparently someone else maintains the 64bit version. Who would have known. Anyway...thanks for the tip. jason

Re: [Bacula-users] Upgrading from 1.36.1 - 2.0.2 - not goingsmoothly.

2007-02-20 Thread Richard Mortimer
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kern Sibbald Sent: 19 February 2007 17:10 To: bacula-users@lists.sourceforge.net Cc: Andrew Paterson Subject: Re: [Bacula-users] Upgrading from 1.36.1 - 2.0.2 - not goingsmoothly. My best

[Bacula-users] A few questions....

2007-02-20 Thread Deric Abel
Hello, I've been running Bacula 1.39.18 since about August, and have been very happy with it. I have also been using the data encryption that was part of that version, now my question is this: Will I be able to restore the encrypted data from my previous backups once I upgrade to 2.0.2? Is

[Bacula-users] Retention Periods for long-term archival

2007-02-20 Thread Ralf Gross
Hi, I had a very simple setup for the last 12 months. * backup everything to tape and keep the last 2 weeks before recycling old volumes * keep the monthly tape(s) for 3 years I didn't care much about the retention periods of the monthly tapes. I just set the Volume Retention to 3 years for

Re: [Bacula-users] A few questions....

2007-02-20 Thread Kern Sibbald
Well, there are several important considerations you need to be aware of: 1. If I am not mistaken, there were some problems with the version you are using and we modified the format of the Volume data in some very particular cases, so going to 2.0.2 in some special cases may not be compatible.

Re: [Bacula-users] Issue with multiple drives and autochanger

2007-02-20 Thread Alan Davis
Adam, Take a look at the directive Prefer Open Volumes. I had to set this to No to get concurrent jobs to run on 2 tape drives. The only other significant difference that I see is that I have AutoSelect set to 'yes' in my config under the Device entry in the SD config file. Alan Davis

Re: [Bacula-users] limit the size of storage files

2007-02-20 Thread Florin Andrei
Kern Sibbald wrote: On Tuesday 20 February 2007 07:23, Florin Andrei wrote: Florin Andrei wrote: I've a chicken-and-egg problem with recovering the MySQL database from the DVDs, since it appears that I need it to run Bacula to begin with. Nevermind, I figure that one out. RTFM :-) How

[Bacula-users] Fwd: Cleaning up database records

2007-02-20 Thread Frank Altpeter
-- Forwarded message -- From: Frank Altpeter [EMAIL PROTECTED] Date: Feb 20, 2007 7:00 PM Subject: Re: [Bacula-users] Cleaning up database records To: Kern Sibbald [EMAIL PROTECTED] I'm running dbcheck periodically every sunday with the following script:

Re: [Bacula-users] Retention Periods for long-term archival

2007-02-20 Thread Kern Sibbald
Just a few quick responses ... On Tuesday 20 February 2007 17:24, Ralf Gross wrote: Hi, I had a very simple setup for the last 12 months. * backup everything to tape and keep the last 2 weeks before recycling old volumes * keep the monthly tape(s) for 3 years I didn't care much about

Re: [Bacula-users] differential and incremental backup requires another full backup.

2007-02-20 Thread Martin Simmons
On Mon, 19 Feb 2007 14:46:07 -0500, Naufal Zamir said: Hi Martin, thanks for your reply. i really appreciate it. I don;t think the job retentions should be a problem, however I did not get the level options. I tried using the same name for the jobs, but check conf gave me an error saying

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Martin Simmons
On Mon, 19 Feb 2007 15:10:26 -0500, Bill Moran said: In response to Martin Simmons [EMAIL PROTECTED]: On Mon, 19 Feb 2007 08:55:07 -0500, Bill Moran said: On the flip side, running dbcheck periodically is pretty much a requirement for keeping Bacula's database reasonably

Re: [Bacula-users] differential and incremental backup requires another full backup.

2007-02-20 Thread Naufal Zamir
Martin, thanks for your reply. I am still not sure about the exact problem. Please correect me if I am wrong on following: As the example states, it looks like that there has to be one schedule ( as compared to 3 seperate I have) which will spepcify the level of the backup i.e. full,

Re: [Bacula-users] Cleaning up database records

2007-02-20 Thread Bill Moran
In response to Martin Simmons [EMAIL PROTECTED]: On Mon, 19 Feb 2007 15:10:26 -0500, Bill Moran said: In response to Martin Simmons [EMAIL PROTECTED]: On Mon, 19 Feb 2007 08:55:07 -0500, Bill Moran said: On the flip side, running dbcheck periodically is pretty much a

[Bacula-users] Info on setting up a second catalog?

2007-02-20 Thread Alan Davis
I've seen a number of comments on the list about using a second DB, usually mentioned as a second catalog, for particular purposes. I've looked through both the User's manual and Developer's manual looking for instructions on how to do this but I haven't found anything other than the mention

Re: [Bacula-users] Info on setting up a second catalog?

2007-02-20 Thread Jason King
For starters, you can adjust the scripts to rename the database to anything you wish. Just vi the scripts, search for the name of the database bacula, then replace those names where it appears to be creating a database...should only be one place though. Jason Alan Davis wrote: I’ve seen a

Re: [Bacula-users] differential and incremental backup requires another full backup.

2007-02-20 Thread Martin Simmons
On Tue, 20 Feb 2007 14:16:50 -0500, Naufal Zamir said: Martin, thanks for your reply. I am still not sure about the exact problem. Please correect me if I am wrong on following: As the example states, it looks like that there has to be one schedule ( as compared to 3 seperate I have)

Re: [Bacula-users] Tape robot

2007-02-20 Thread Arno Lehmann
Hello, On 2/20/2007 10:02 AM, Geir Asle Borgen wrote: Sorry I forgot to send the error messages: 16-Feb 16:02 dracula-sd: Please mount Volume VOlUME-Dracula-Tape-2007.02.14 on Storage Device DLT8000-Dracula (/dev/nst0) for Job Torvalds.2007-02-16_15.49.17 16-Feb 15:49 helsing-dir:

Re: [Bacula-users] Upgrading from 1.36.1 - 2.0.2 - not going smoothly.

2007-02-20 Thread Arno Lehmann
Hello, On 2/20/2007 10:45 AM, Andrew Paterson wrote: Kern Sibbald wrote: ... Actually, it turns out that the upgrade went pretty well considering the way I just went for it!. ... Still being picky tho' - can't something be done about a busy director blocking bconsole? I don't think

Re: [Bacula-users] differential and incremental backup requires another full backup.

2007-02-20 Thread Naufal Zamir
Thanks for your reply, I just modified the conf file, and will start the backup tommorow. I have one more question though. I initially had seperate daily pools e.g. Daily-tues to Daily-Fri. All the three system daily backups went to one pool each day. In the configuration you just told, if I am

Re: [Bacula-users] bacula 2.0.2 on Mac OS X

2007-02-20 Thread Erich Prinz
Yikes - my bad. It is part of the win32 build (where I've been spending a lot of time lately) and didn't bother to check the OS X side of the house. So, in the sd conf file where the directives are similar for your device, my best guess is it will mount in /Volumes/tape drive the relevant

Re: [Bacula-users] mtx-changer script

2007-02-20 Thread Erich Prinz
Hi Robert, Yes and it serves to expose just how weak I am at scripting. I understand what is happening, however, translating Alexander's script to a win32 script is likely a four to five hour operation for me - that's why I was hoping someone had already taken it to task. Hanging my head

Re: [Bacula-users] Retention Periods for long-term archival

2007-02-20 Thread Ralf Gross
Kern Sibbald schrieb: I created differnt pools for regular backups and long term archival. I think the retention times are reasonable. We are aware that we can't handle a _real_ long time archival (copy to new media, verify...), but we want to keep the volumes for 30 years. Be sure to

Re: [Bacula-users] Fwd: Cleaning up database records

2007-02-20 Thread Michael Nelson
On Tue, February 20, 2007 10:00 am, Frank Altpeter wrote: I'm running dbcheck periodically every sunday with the following script: SNIP Thanks for sharing your script, Frank. I modified it to work on our servers, and on one of them that had a File table that was over 1.6G, it is now down to a

Re: [Bacula-users] Retention Periods for long-term archival

2007-02-20 Thread Ralf Gross
Ralf Gross schrieb: But now bacula-dir does not start with the second catalog: 20-Feb 22:07 bacula-dir: Fatal error: Database not created or server not running. 20-Feb 22:07 bacula-dir: Fatal error: Could not open Catalog ArchiveCatalog, database bacula_archive. 20-Feb 22:07