RE: [Bacula-users] Re: File attributes

2006-05-10 Thread James Harper
I just threw together some MS SQL (because that's what I've got in front of me) code that sort of does what you want, but not in a way that could be used in a query (you'd have to put it in a user defined function, which is easy enough to do), and being MSSQL it won't work as given under any of the

[Bacula-users] Rene' Fiby/Debortoli is out of the office.

2006-05-10 Thread rene_fiby
I will be out of the office starting Thu 11/05/2006 and will not return until Mon 15/05/2006. I will respond to your message when I return. __ This email has been scanned by the MessageLabs Email Security System. For more infor

Re: [Bacula-users] Re: File attributes

2006-05-10 Thread Troy Daniels
Hi, There was thread a couple of weeks back about the fact that bacula uses a slightly different algorithm to the "standard" base64 one. Would that apply in this case and would it account for the confusing output received by Mark? Just a thought - could be completely off the mark. Troy. J

RE: [Bacula-users] Re: File attributes

2006-05-10 Thread James Harper
> > James Harper wrote: > > Do you want to deal with it in the query (harder), or in the code that > > processes the query (easier)? Are you asking what Base64 is, or do you > > know already and would just like some help doing something useful with > > it from within the SQL language? > > My hope

[Bacula-users] Re: File attributes

2006-05-10 Thread Mark Nienberg
Cedric Tefft wrote: Mark Nienberg wrote: I'd like to write an SQL query to extract some information from the bacula catalog including file dates. I see from the bacula developers guide that the "File" table has a field named "LStat" that is defined as "File attributes in base64 encoding". I

[Bacula-users] Re: File attributes

2006-05-10 Thread Mark Nienberg
James Harper wrote: Do you want to deal with it in the query (harder), or in the code that processes the query (easier)? Are you asking what Base64 is, or do you know already and would just like some help doing something useful with it from within the SQL language? My hope was to write a custom

[Bacula-users] bacula dvd-writing on FreeBSd via dvd+rw-tools port

2006-05-10 Thread Dave
Hello, For those of you who have wanted to try out dvd writing on FreeBSD now you can. Previously one had to, if you had the dvd+rw-tools port installed, uninstall that, download the 6.1 tarball, patch it, and compile and install. Now thanks to Chuck Swiger, the maintainer of the port of dvd

Re: [Bacula-users] Autochanger *almost* working (resolved with ugly hack)

2006-05-10 Thread Gregory Brauer
Arno Lehmann wrote: Hi, On 5/9/2006 7:37 PM, Gregory Brauer wrote: Gregory Brauer wrote: I believe I can get the behavior I want by setting all of my volumes as InChanger=1 and never running update slots again. I didn't follow this thread, but what behaviour would that be? Should probably

Re: [Bacula-users] Re: File attributes

2006-05-10 Thread Cedric Tefft
Mark Nienberg wrote: Mark Nienberg wrote: I'd like to write an SQL query to extract some information from the bacula catalog including file dates. I see from the bacula developers guide that the "File" table has a field named "LStat" that is defined as "File attributes in base64 encoding".

RE: [Bacula-users] Re: File attributes

2006-05-10 Thread James Harper
Do you want to deal with it in the query (harder), or in the code that processes the query (easier)? Are you asking what Base64 is, or do you know already and would just like some help doing something useful with it from within the SQL language? Just in case you don't know already, the date fields

[Bacula-users] Re: File attributes

2006-05-10 Thread Mark Nienberg
Mark Nienberg wrote: I'd like to write an SQL query to extract some information from the bacula catalog including file dates. I see from the bacula developers guide that the "File" table has a field named "LStat" that is defined as "File attributes in base64 encoding". I assume my file dates

[Bacula-users] Storage Daemon ported to Windows

2006-05-10 Thread Robert Nelson
I've ported the Storage Daemon and related tools to Windows.  Tested the tape with btape and all tests passed.  WooHoo!!   Next I need to get the Daemon running as a service and do some more backup / restore testing.  

Re: [Bacula-users] bacula-tray-monitor error

2006-05-10 Thread Pfunk Mallone
> From: "Steven Ellis" <[EMAIL PROTECTED]> > To: "Pfunk Mallone" <[EMAIL PROTECTED]> > Subject: Re: [Bacula-users] bacula-tray-monitor error > Date: Wed, 10 May 2006 13:02:34 -0700 > > Yes, the restricted console that is provided by default for this > purpose has inadequate permissions. I struggl

Re: [Bacula-users] bacula-tray-monitor error

2006-05-10 Thread Steven Ellis
Pfunk Mallone wrote: Hello, On a new setup of Bacula (1.38.9), when using the bacula-tray-monitor I get the following error when viewing the DIR server: 'You must specify a "use " command before continuing.'. I've successfully run several backups, but I can't see the status using the tray-mo

Re: [Bacula-users] bacula-tray-monitor error

2006-05-10 Thread Arno Lehmann
Hi, On 5/10/2006 9:48 PM, Pfunk Mallone wrote: Hello, On a new setup of Bacula (1.38.9), when using the bacula-tray-monitor I get the following error when viewing the DIR server: 'You must specify a "use " command before continuing.'. I've successfully run several backups, but I can't see th

[Bacula-users] bacula-tray-monitor error

2006-05-10 Thread Pfunk Mallone
Hello, On a new setup of Bacula (1.38.9), when using the bacula-tray-monitor I get the following error when viewing the DIR server: 'You must specify a "use " command before continuing.'. I've successfully run several backups, but I can't see the status using the tray-monitor tool. Accessing

[Bacula-users] bacula-sd.conf for Exabyte Mammoth EXB-8900 8mm

2006-05-10 Thread lreynolds
I'm trying to get a single Exabyte Mammoth EXB-8900 8mm tape drive working under solaris 8. Everything seems happy except for that when I run the btape tests, I get the following error message at the end: === End Forward space files test === *btape: btape.c:2576 is an illegal command Does a

Re: [Bacula-users] using bacula for automatic rollout of Windows machines

2006-05-10 Thread Erich Prinz
Given the unique 'hands-on' approach of your successful 'almost bare metal' recovery, it might be useful. We use a customized version of BDD that Microsoft puts out specifically for the process you suggest. It's very involved to setup. Once completed however, it takes about 10 minutes to do

[Bacula-users] full automatic backups like in handbook, tips and suggestions

2006-05-10 Thread Dennis Berger
I'm currently refering to the section tips and sugestions/Total Automation of Bacula Tape Handling. I would like to have exactly this but since script and sample entries are from 2003 they don't fit anymore. I added an autochanger device and modified various parts of the script, but currently it

[Bacula-users] Re: [Bacula-devel] Appending DVD volume problem and patch (Bacula 1.38.6)

2006-05-10 Thread drescher0110-bacula
> I haven't checked this, but the latest release announcement doesn't > mention such fix, so it probably didn't. If the patch works for you, > then let Bacula developers know about that to encourage them to apply > the patch or, at least, comment it. > > Greets, > Jacek > WOW! Thanks for

Re: [Bacula-users] Autochanger *almost* working (resolved with ugly hack)

2006-05-10 Thread Alan Brown
On Tue, 9 May 2006, Gregory Brauer wrote: This just seems broken to me, though. Bacula should automatically check what tapes are currently in the loader every time it runs a job. Why doesn't it do this? Because if the tapes aren't barcoded, this requires reading the labels. AB --

Re: [Bacula-users] Long wait time for restore

2006-05-10 Thread Greg Cope
On Mon, 2006-05-08 at 12:04 -0600, Michael Morgan wrote: > I had the exact same problem when I first tried to restore some files > from one of my bacula installations. The problem was the database on the > back end. I had my database expert (who isn't me!) reindex the database > and everything b

[Bacula-users] Write Error

2006-05-10 Thread Thomas Franz
Hello, with about the half of my tapes , bacula doesn't write the full capacity and ends with something like this: 05-May 13:06 backup-sd: Backup.2006-05-05_11.05.00 Error: block.c:552 Write error at 1108:12049 on device /dev/nsa2. ERR=Invalid argument. 05-May 13:06 backup-sd: End of medium on V