Re: [Bacula-users] Win32 Version 1.38.5

2006-03-01 Thread Landon Fuller


On Mar 1, 2006, at 2:15 AM, Chris Crowther wrote:


Landon Fuller wrote:


Who is generally handles the Win32 Bacula builds?


Whoever it is has a lot of patience or luck, having tried to do it
myself :)

Does anyone know if it's actually possible to build it with TLS
support on Windows?


It's not currently possible, but this is why I asked who the win32  
maintainer is.
I have some of the work done to support Win32  TLS support; I need to  
coordinate on adding the appropriate buttons and knobs to the MSVC++  
projects.


-landonf


PGP.sig
Description: This is a digitally signed message part


[Bacula-users] Stupid file set question.

2006-03-01 Thread AltGrendel

I have this in my bacula-dir.conf:


FileSet {
  Name= "Full Win Set"
  Include {
Options {
   signature = MD5
   Exclude = yes
   IgnoreCase = yes
# Exclude Mozilla-based programs' file caches
  WildDir = "[A-Z]:/Documents and Settings/*/Application 
Data/*/Profiles/*/*/Cache"
  WildDir = "[A-Z]:/Documents and Settings/*/Application 
Data/*/Profiles/*/*/Cache.Trash"
  WildDir = "[A-Z]:/Documents and Settings/*/Application 
Data/*/Profiles/*/*/ImapMail"


# Exclude ISO Images
  WildFile = "*.iso"


Will the IgnoreCase=yes allow the WildFile="*.iso" to exclude *.iso, 
*.ISO, *.Iso, etc...


The reason I'm asking is that in the bacula docs, I saw where someone 
had to use WildFile="*.[Ii][Ss][Oo]" to cover this.


Just not sure what's going on.

TIA.


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] list job= and related broader question

2006-03-01 Thread Gregory Orange

Christopher Mills wrote:
The bconsole command 'list jobs' gives me a list of runs from all jobs. 
I want to narrow it to all job runs from a particular job. The bconsole 
doc under "list" seems to imply that would be done with:


  list job=My-Job

This doesn't work (I am running mysql under Gentoo Linux). I tried every 
combination that I could think of-- quotes, tics, etc. to no avail. 
'list jobs' works fine but is just painfully cluttered. I even guessed at:


  list jobs job=My-Job



I'm not sure if this will help:
bconsole 

Re: [Bacula-users] Incremental Pool and day-specific filenames

2006-03-01 Thread Dan Langille
On 2 Mar 2006 at 0:08, Arno Lehmann wrote:

> Just as a furher hint - I haven't implemented something like this 
> because I prefer volume names not be related to the contents - the way 
> I'd do this is as follows:
> 
> 1. Search the catalog for pruned volumes
> 2. Send the commands to delete the volumes from the catalog using bconsole
> 3. If (2) succeeds, delete the corresponding file
> 
> This, done as an admin job or a cron job should work fine.
> 
> You don't reuse volumes, you replace them, but the outcome should be 
> identical for pracical purposes.

In this context, "you" refers to the original poster, not the "you" 
as in this is how everyone should do it.


-- 
Dan Langille : Software Developer looking for work
my resume: http://www.freebsddiary.org/dan_langille.php




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Incremental Pool and day-specific filenames

2006-03-01 Thread Arno Lehmann

Hello,

On 3/1/2006 10:54 PM, Dan Langille wrote:

On 1 Mar 2006 at 16:42, Matthew Butt wrote:



I thought that may be the case.  Bacula is a great system but every
solution I try with a disk-based backup fails for one reason or another
:( I'm sure it's perfect for tapes but I'm struggling to make it work
successfully with disks.



tapes/disks, bacula doesn't care.


That's (one of) the problem(s) for disk-based backups... wanting to 
rename the volume files seems to be more common than I'd have guessed.



All I have is about 6 backup locations and I need to do a full monthly,
diff weekly and inc daily system.  I have three USB drives - a 1TB unit
for fulls, a .5TB unit for diffs and a 250MB unit for incrementals.

It can't be this difficult!



Usually it's not.

I am not following this thread and have no idea what the problems 
are.  It sounds like you want to have date-specific filenames.  Many 
others have done this.


Bacula, by design, neither renames nor deletes Volumes.  That is a 
security issue.


If you want to delete older volumes, why not create a cronjob to do 
that?


Just as a furher hint - I haven't implemented something like this 
because I prefer volume names not be related to the contents - the way 
I'd do this is as follows:


1. Search the catalog for pruned volumes
2. Send the commands to delete the volumes from the catalog using bconsole
3. If (2) succeeds, delete the corresponding file

This, done as an admin job or a cron job should work fine.

You don't reuse volumes, you replace them, but the outcome should be 
identical for pracical purposes.


Arno

--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


RE: [Bacula-users] Incremental Pool and day-specific filenames

2006-03-01 Thread Dan Langille
On 1 Mar 2006 at 16:42, Matthew Butt wrote:

> I thought that may be the case.  Bacula is a great system but every
> solution I try with a disk-based backup fails for one reason or another
> :( I'm sure it's perfect for tapes but I'm struggling to make it work
> successfully with disks.

tapes/disks, bacula doesn't care.

> All I have is about 6 backup locations and I need to do a full monthly,
> diff weekly and inc daily system.  I have three USB drives - a 1TB unit
> for fulls, a .5TB unit for diffs and a 250MB unit for incrementals.
> 
> It can't be this difficult!

Usually it's not.

I am not following this thread and have no idea what the problems 
are.  It sounds like you want to have date-specific filenames.  Many 
others have done this.

Bacula, by design, neither renames nor deletes Volumes.  That is a 
security issue.

If you want to delete older volumes, why not create a cronjob to do 
that?

-- 
Dan Langille : Software Developer looking for work
my resume: http://www.freebsddiary.org/dan_langille.php




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


RE: [Bacula-users] Incremental Pool and day-specific filenames

2006-03-01 Thread Matthew Butt
I thought that may be the case.  Bacula is a great system but every
solution I try with a disk-based backup fails for one reason or another
:( I'm sure it's perfect for tapes but I'm struggling to make it work
successfully with disks.

All I have is about 6 backup locations and I need to do a full monthly,
diff weekly and inc daily system.  I have three USB drives - a 1TB unit
for fulls, a .5TB unit for diffs and a 250MB unit for incrementals.

It can't be this difficult!

Matt

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:bacula-users-
> [EMAIL PROTECTED] On Behalf Of Arno Lehmann
> Sent: Wednesday, March 01, 2006 4:17 PM
> To: bacula-users
> Subject: Re: [Bacula-users] Incremental Pool and day-specific
filenames
> 
> Second try... blacklisted again...
> 
> 
> Hello,
> 
> On 3/1/2006 3:55 PM, Matthew Butt wrote:
> > I'm trying to setup a backup system with Full on the first Sunday of
> > each month, Diff on subsequent Sundays and Incrementals daily.
Backups
> > are written to external USB hard drives.
> >
> > I'm following quite closely the example given at
> > http://www.bacula.org/rel-manual/Automated_Disk_Backup.html.  The
change
> > I'm making is that I need to backup multiple servers.  I've amended
the
> > pools and jobs as needed but I have one problem.  The pool file is
not
> > being renamed on the disk drive I'm using.
> 
> Correct.
> 
> Volume files are never renamed in normal operation. Once they are
> created, they keep their name (I never tried relabelin file volumes).
> 
> You should keep in mind that Bacula is also a tape backup program, and
> the volume label is more or less equivalent of the tape name. Think of
a
> sticker or a bar code label - you don't change these that often...
> 
> Arno
> 
> >  Ie if I run an incremental
> > backup on Feb 24th the file created is Inc-2006-02-24.  The next
> > incremental backup on the next day uses the same filename, not
> > Inc-2006-02-25 as expected, which is messing up the volume
recycling.
> > Configuration snippets are below
> >
> > Any pointers please?
> >
> > JobDefs {
> >   Name = "DefaultJob"
> >   Type = Backup
> >   Schedule = "WeeklyCycle"
> >   Storage = File
> >   Messages = Standard
> >   Pool = Default
> >   Full Backup Pool = Full-Pool
> >   Incremental Backup Pool = Inc-Pool
> >   Differential Backup Pool = Diff-Pool
> >   Priority = 10
> > }
> >
> > Job {
> >   Name = "Server1"
> >   Client = server1-fd
> >   JobDefs = "DefaultJob"
> >   Write Bootstrap = "/var/bacula/Server1.bsr"
> >   FileSet = "Server1"
> > }
> >
> > Job {
> >   Name = "Server2"
> >   Client = server2-fd
> >   JobDefs = "DefaultJob"
> >   Write Bootstrap = "/var/bacula/ Server2.bsr"
> >   FileSet = " Server2"
> > }
> >
> > Pool {
> >   Name = Inc-Pool
> >   Pool Type = Backup
> >   Recycle = yes
> >   AutoPrune = yes
> >   Volume Retention = 20 days
> >   Accept Any Volume = yes
> >   Label Format = "Inc-${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}"
> >   Maximum Volumes = 5
> > }
> >
> >
> > Matt
> >
> >
> >
> > ---
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> > that extends applications into web and mobile media. Attend the live
> webcast
> > and join the prime developer group breaking into this new coding
> territory!
> > http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642
> > ___
> > Bacula-users mailing list
> > Bacula-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
> >
> 
> --
> IT-Service Lehmann[EMAIL PROTECTED]
> Arno Lehmann  http://www.its-lehmann.de
> 
> 
> 
> 
> --
> IT-Service Lehmann[EMAIL PROTECTED]
> Arno Lehmann  http://www.its-lehmann.de
> 
> 
> ---
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
>
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Incremental Pool and day-specific filenames

2006-03-01 Thread Arno Lehmann

Second try... blacklisted again...


Hello,

On 3/1/2006 3:55 PM, Matthew Butt wrote:

I'm trying to setup a backup system with Full on the first Sunday of
each month, Diff on subsequent Sundays and Incrementals daily.  Backups
are written to external USB hard drives.

I'm following quite closely the example given at
http://www.bacula.org/rel-manual/Automated_Disk_Backup.html.  The change
I'm making is that I need to backup multiple servers.  I've amended the
pools and jobs as needed but I have one problem.  The pool file is not
being renamed on the disk drive I'm using.


Correct.

Volume files are never renamed in normal operation. Once they are
created, they keep their name (I never tried relabelin file volumes).

You should keep in mind that Bacula is also a tape backup program, and
the volume label is more or less equivalent of the tape name. Think of a
sticker or a bar code label - you don't change these that often...

Arno


 Ie if I run an incremental
backup on Feb 24th the file created is Inc-2006-02-24.  The next
incremental backup on the next day uses the same filename, not
Inc-2006-02-25 as expected, which is messing up the volume recycling.
Configuration snippets are below

Any pointers please?

JobDefs {
  Name = "DefaultJob"
  Type = Backup
  Schedule = "WeeklyCycle"
  Storage = File
  Messages = Standard
  Pool = Default
  Full Backup Pool = Full-Pool
  Incremental Backup Pool = Inc-Pool
  Differential Backup Pool = Diff-Pool
  Priority = 10
}

Job {
  Name = "Server1"
  Client = server1-fd
  JobDefs = "DefaultJob"
  Write Bootstrap = "/var/bacula/Server1.bsr"
  FileSet = "Server1"
}

Job {
  Name = "Server2"
  Client = server2-fd
  JobDefs = "DefaultJob"
  Write Bootstrap = "/var/bacula/ Server2.bsr"
  FileSet = " Server2"
}

Pool {
  Name = Inc-Pool
  Pool Type = Backup
  Recycle = yes
  AutoPrune = yes
  Volume Retention = 20 days
  Accept Any Volume = yes
  Label Format = "Inc-${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}"
  Maximum Volumes = 5
}


Matt



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de




--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] list job= and related broader question

2006-03-01 Thread Helmut Raubenheimer

Hi,

or do you know of any 
good reverse engineering tools for mysql that will build me a nice 
graphical picture of the data model?

http://fabforce.net/dbdesigner4/
open source available for Linux/Win

Regards

Helmut


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re: Bacula & ADIC 1000

2006-03-01 Thread Mark L. Weindling
I'm using an ADIC 1000 with 4 DLT7000 drives under Linux; haven't had  
a single issue since I configured it in July. It's been a great library.


-Mark

On Mar 1, 2006, at 1:08 PM, Ryan Sizemore wrote:


Joshua Kugler wrote:


On Tuesday 28 February 2006 08:17, Marc Patino Gómez wrote:



Hi floks,

has anyone exprience with Bacula & ADIC 1000. It's this library  
fully

supported by bacula.




If it helps, we use an ADIC Faststor 22 with a Quantum DLT8000  
drive.  Works

great.  What drive does the ADIC 1000 use?

j- k-



I also use an ADIC Scalar 220 at home, and it works great. From  
what it
looks like online, the 1000 can use either AIT or DLT media. I  
would say

that it is a strong possability that the 1000 will work with bacula.

Ryan


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting  
language
that extends applications into web and mobile media. Attend the  
live webcast
and join the prime developer group breaking into this new coding  
territory!
http://sel.as-us.falkag.net/sel? 
cmd=lnk&kid=110944&bid=241720&dat=121642

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




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] list job= and related broader question

2006-03-01 Thread Arno Lehmann

Hello,

On 3/1/2006 7:26 PM, Christopher Mills wrote:

Arno,

Thank you for taking the time to review my long post, and for steering 
me on course. I checked the bug tracker page, which I just discovered. 
The bug was reported and fixed, so I will wait for a future release (bug 
339). I will check the buglist next time, not just the user posts.


A few follow-up questions:

1) I didn't follow your blacklist comment at the beginning.


That referred not to a blacklist on my side or the lists, but rather to 
a problem my mail provider seems to have. They managed to get at least 
one of their outgoing mail servers onto a blacklist sf.net queries and 
so lots of my list mail was refused and I had to resend it and complain 
to my provider. Just to keep track of which message I tried to resend I 
addrd something to the top of it :-)


Other than 
length, have I violated any etiquette?


Not as far as I'm concerned. And, just to make this more clear, the 
length is in my opinion not a problem. It's merely an observation that 
shorter posts get more responses on many mailing lists, even if it takes 
quite a lengthy exchange to get all the facts you need to actually 
understand what is asked or reported.



2) Is there a repository of queries written by others?


The best one I know is in query.sql - seriously, I don't think so. There 
is something in there that I contributed, I think, but I suppose that 
many others work similar to the way I do: Create an SQL hack, tweak it 
until it does what we want, and unfortunately, at that point, it's 
definitely not portable, elegant or even readable an more, so we keep 
this in our installation and don't share it. (Might be something for the 
wiki, I think).



3) Is there a pictorial view of the data-model,


You might find something in the development manual, but personally, I 
never needed such an overview. Given the table names and the 
corresponding Bacula terminology, half the stuff I needed was already 
there, and the other half are the links between tables. These are 
usually an as far as I know not managed by database keys, but purely in 
the application logic. The naming helps a lot to understand these 
connections: For example the links to the Job table are done by a column 
called JobId which contains the calue of the primary key of the Job 
table, which is also called - you guessed it - JobId.


Once I got that far I could work my way through the data model as far as 
necessary.


or do you know of any 
good reverse engineering tools for mysql that will build me a nice 
graphical picture of the data model?


Don't know nothing about such stuff, and I suppose it would need lots of 
user knowledge anyway, because all the links are managed in Bacula, not 
the database backend.


I have a reasonable amount of 
experience in relational data modeling. Unfortunately, my experience is 
in a proprietary (albeit robust) relational database. Consequently, I am 
lukewarm on sql queries from a practical standpoint, and almost 
completely unfamiliar with any mysql tools that are out there. Any 
must-haves?


I always use mysql, the simple command-line shell. As a graphical 
management tool I prefer MySQL Administrator, freely available from the 
MySQL web site. But I prefer doing "real" work in a terminal window or 
similar, so YMMV.


Arno



Arno Lehmann wrote:


Once more, again blacklisted...

this gets interesting ;-)

And once more because I sent this to the wrong list...

resend, because my mail provider managed to get one of his mailers onto
a blacklist...

Hello,

you wrote a very nice mail - only I think many list-readers will not
bother to read that long text ;-)

On 2/28/2006 11:39 PM, Christopher Mills wrote:

I searched the archive for an answer to this question. I found it 
asked but never answered:


The bconsole command 'list jobs' gives me a list of runs from all 
jobs. I want to narrow it to all job runs from a particular job. The 
bconsole doc under "list" seems to imply that would be done with:


  list job=My-Job

This doesn't work (I am running mysql under Gentoo Linux).




The same here. Either the manual is wrong or this is a bug, I say.


I tried ...
Alas, my suspicion is this query just doesn't function.




By now, I suspect the same.

Since I believe that this is a very fundemental query, and since out 
of the corner of my eye while searching the archives for an answer I 
seem to have noticed questions about formulating sql queries against 
the Bacula database tables, I have a broader question in regard to 
what I should expect in diving into Bacula:


Should I expect that the Bacula development community is focusing on 
the more critical areas of this highly complex and powerful  
opensource project?




That's what it looks like, and even though I understand the question
behind what you wrote :-) I don't think this should remain unfixed.

Should I bite the bullet, and bone up on my sql skills on the 
assumption that these relatively beni

Re: [Bacula-users] list job= and related broader question

2006-03-01 Thread Christopher Mills
It is looking like mysqlnavigator is reasonablly effective for a db of 
the size of Bacula's. I had forgotten, but I ran across this tool when 
coming up to speed on mysql (for Bacula) and so installed the package. 
Hopefully, this will save me much query writing. As much as I would love 
to come up to speed on writing sql, right now I have more interest in 
getting my Bacula implimentation up and running. Once it is running, I 
suspect there will be some custom queries I will need for monitoring.


I am really excited about Bacula. This is looking like the perfect 
solution-- highly professional features available for my modest network. 
When this implimentation is complete, I am going to be breathing easier.


Christopher Mills wrote:


Arno,

Thank you for taking the time to review my long post, and for steering 
me on course. I checked the bug tracker page, which I just discovered. 
The bug was reported and fixed, so I will wait for a future release 
(bug 339). I will check the buglist next time, not just the user 
posts.


A few follow-up questions:

1) I didn't follow your blacklist comment at the beginning. Other than 
length, have I violated any etiquette?

2) Is there a repository of queries written by others?
3) Is there a pictorial view of the data-model, or do you know of any 
good reverse engineering tools for mysql that will build me a nice 
graphical picture of the data model? I have a reasonable amount of 
experience in relational data modeling. Unfortunately, my experience 
is in a proprietary (albeit robust) relational database. Consequently, 
I am lukewarm on sql queries from a practical standpoint, and almost 
completely unfamiliar with any mysql tools that are out there. Any 
must-haves?


Arno Lehmann wrote:


Once more, again blacklisted...

this gets interesting ;-)

And once more because I sent this to the wrong list...

resend, because my mail provider managed to get one of his mailers onto
a blacklist...

Hello,

you wrote a very nice mail - only I think many list-readers will not
bother to read that long text ;-)

On 2/28/2006 11:39 PM, Christopher Mills wrote:

I searched the archive for an answer to this question. I found it 
asked but never answered:


The bconsole command 'list jobs' gives me a list of runs from all 
jobs. I want to narrow it to all job runs from a particular job. The 
bconsole doc under "list" seems to imply that would be done with:


  list job=My-Job

This doesn't work (I am running mysql under Gentoo Linux).




The same here. Either the manual is wrong or this is a bug, I say.


I tried ...
Alas, my suspicion is this query just doesn't function.




By now, I suspect the same.

Since I believe that this is a very fundemental query, and since out 
of the corner of my eye while searching the archives for an answer I 
seem to have noticed questions about formulating sql queries against 
the Bacula database tables, I have a broader question in regard to 
what I should expect in diving into Bacula:


Should I expect that the Bacula development community is focusing on 
the more critical areas of this highly complex and powerful  
opensource project?




That's what it looks like, and even though I understand the question
behind what you wrote :-) I don't think this should remain unfixed.

Should I bite the bullet, and bone up on my sql skills on the 
assumption that these relatively benign (but from a practical 
perspective of a Bacula implimentation, important) queries may not 
be fully debugged and tested as of yet? Should I assume that I will 
"become one" with the product more quickly if I just accept this, 
and learn to write my own queries as needed?




Well, if you want to get more fluent in SQL this could be just the right
project :-)

I am really hoping the answer is "no." But I can understand if it is 
"yes," as I certainly haven't been the one contributing to this 
monumental project :) (Although, if it is "yes" I will confess to 
being a little disappointed as I was hoping query writing would only 
come up in future fine-tuning of my implimentation).




I'd even say that in many cases you don't need to write any SQL at all.

If this is the case, then I am just wondering where I should start. 
I haven't really tried to delve into the source although I have 
taken a peek at "query.sql." What is not clear to me is where all 
the queries forming the 'list' commands are hiding. Do I need to get 
my hands on some source to get started on examples of useful 
queries? Should the task be to simply tack new queries onto 
query.sql as I need them?




Yes and no.

The SQL behind the commands like list is indeed hiding in the source
code. You can, however, achieve what you want by using queries in
query.sql, which I'd recommend.

Parameter passing is done in a dialog there, but it's obviously much
easier to try out queries - no need to recompile, install and restart
the binaries, only saving the file and issueing the query command from
bconsole.

Or am

Re: [Bacula-users] Re: Bacula & ADIC 1000

2006-03-01 Thread Ryan Sizemore
Joshua Kugler wrote:

>On Tuesday 28 February 2006 08:17, Marc Patino Gómez wrote:
>  
>
>>Hi floks,
>>
>>has anyone exprience with Bacula & ADIC 1000. It's this library fully
>>supported by bacula.
>>
>>
>
>If it helps, we use an ADIC Faststor 22 with a Quantum DLT8000 drive.  Works 
>great.  What drive does the ADIC 1000 use?
>
>j- k-
>
>  
>
I also use an ADIC Scalar 220 at home, and it works great. From what it
looks like online, the 1000 can use either AIT or DLT media. I would say
that it is a strong possability that the 1000 will work with bacula.

Ryan


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Win32 Version 1.38.5

2006-03-01 Thread Arno Lehmann

Hello,

On 3/1/2006 5:20 PM, kernel[consulting] info wrote:
...

Thanks all,

we found it.
But now i am in real trouble. I tried some de_DE.UTF-8 setting, but all
i get is trouble with the linux console display of charsets.
I assume my ext3 filesystem is now written with iso-8859-15 (AFAIK the
same as the @euro thingy) .


Yes, should be so.


So i get ? instead of umlauts when i change to UTF-8.
Does anyone know how convert the filesystem to UTF-8?


CONVMV(1) 




NAME
   convmv - converts filenames from one encoding to another

SYNOPSIS
   convmv [options] FILE(S) ... DIRECTORY(S)


Or is there a way to convert filename to UTF-8 BEFORE they are written
to the db in bacula?


Not as far as I know. You might try converting the database, though... 
but see below for some things to consider.



hmmm.. looks like i am in a pinch now...


Yes, definitely.

First, I wonder, because I did back up many pre-UTF-8 linux systems, but 
as these were mainly servers without user files it's possible that there 
never were any non-ASCII characters in filenames. Anyway, I never saw 
your problem myself.


Second, changing the encoding is a difficult task - you've also got to 
think about

A) NFS clients
B) Samba clients (samba can handle different codings itself, though)
C) File names contained in file contents, e.g. configuration files or 
links in html-files

D) Terminal settings of your users
E) charset-settings of web servers...

I'm sure you could extend that list yourself :-)

Anyway, I'd be very careful changing existing file names. On the other 
hand, I'd be very unhappy without a working Bacula, too.


Arno


Sebastian Hültenschmidt



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] list job= and related broader question

2006-03-01 Thread Christopher Mills

Arno,

Thank you for taking the time to review my long post, and for steering 
me on course. I checked the bug tracker page, which I just discovered. 
The bug was reported and fixed, so I will wait for a future release (bug 
339). I will check the buglist next time, not just the user posts.


A few follow-up questions:

1) I didn't follow your blacklist comment at the beginning. Other than 
length, have I violated any etiquette?

2) Is there a repository of queries written by others?
3) Is there a pictorial view of the data-model, or do you know of any 
good reverse engineering tools for mysql that will build me a nice 
graphical picture of the data model? I have a reasonable amount of 
experience in relational data modeling. Unfortunately, my experience is 
in a proprietary (albeit robust) relational database. Consequently, I am 
lukewarm on sql queries from a practical standpoint, and almost 
completely unfamiliar with any mysql tools that are out there. Any 
must-haves?


Arno Lehmann wrote:


Once more, again blacklisted...

this gets interesting ;-)

And once more because I sent this to the wrong list...

resend, because my mail provider managed to get one of his mailers onto
a blacklist...

Hello,

you wrote a very nice mail - only I think many list-readers will not
bother to read that long text ;-)

On 2/28/2006 11:39 PM, Christopher Mills wrote:

I searched the archive for an answer to this question. I found it 
asked but never answered:


The bconsole command 'list jobs' gives me a list of runs from all 
jobs. I want to narrow it to all job runs from a particular job. The 
bconsole doc under "list" seems to imply that would be done with:


  list job=My-Job

This doesn't work (I am running mysql under Gentoo Linux).



The same here. Either the manual is wrong or this is a bug, I say.


I tried ...
Alas, my suspicion is this query just doesn't function.



By now, I suspect the same.

Since I believe that this is a very fundemental query, and since out 
of the corner of my eye while searching the archives for an answer I 
seem to have noticed questions about formulating sql queries against 
the Bacula database tables, I have a broader question in regard to 
what I should expect in diving into Bacula:


Should I expect that the Bacula development community is focusing on 
the more critical areas of this highly complex and powerful  
opensource project?



That's what it looks like, and even though I understand the question
behind what you wrote :-) I don't think this should remain unfixed.

Should I bite the bullet, and bone up on my sql skills on the 
assumption that these relatively benign (but from a practical 
perspective of a Bacula implimentation, important) queries may not be 
fully debugged and tested as of yet? Should I assume that I will 
"become one" with the product more quickly if I just accept this, and 
learn to write my own queries as needed?



Well, if you want to get more fluent in SQL this could be just the right
project :-)

I am really hoping the answer is "no." But I can understand if it is 
"yes," as I certainly haven't been the one contributing to this 
monumental project :) (Although, if it is "yes" I will confess to 
being a little disappointed as I was hoping query writing would only 
come up in future fine-tuning of my implimentation).



I'd even say that in many cases you don't need to write any SQL at all.

If this is the case, then I am just wondering where I should start. I 
haven't really tried to delve into the source although I have taken a 
peek at "query.sql." What is not clear to me is where all the queries 
forming the 'list' commands are hiding. Do I need to get my hands on 
some source to get started on examples of useful queries? Should the 
task be to simply tack new queries onto query.sql as I need them?



Yes and no.

The SQL behind the commands like list is indeed hiding in the source
code. You can, however, achieve what you want by using queries in
query.sql, which I'd recommend.

Parameter passing is done in a dialog there, but it's obviously much
easier to try out queries - no need to recompile, install and restart
the binaries, only saving the file and issueing the query command from
bconsole.

Or am I getting paranoid, all documented queries work great, and I am 
just being clueless, having missed the obvious (which wouldn't be the 
first time)? :)



Not this time, I'm afraid...


Thanks in advance for any help and advice.


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting 
language
that extends applications into web and mobile media. Attend the live 
webcast
and join the prime developer group breaking into this new coding 
territory!

http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-u

[Bacula-users] Re: Bacula & ADIC 1000

2006-03-01 Thread Joshua Kugler
On Tuesday 28 February 2006 08:17, Marc Patino Gómez wrote:
> Hi floks,
>
> has anyone exprience with Bacula & ADIC 1000. It's this library fully
> supported by bacula.

If it helps, we use an ADIC Faststor 22 with a Quantum DLT8000 drive.  Works 
great.  What drive does the ADIC 1000 use?

j- k-

-- 
Joshua Kugler PGP Key: http://pgp.mit.edu/
CDE System Administrator ID 0xDB26D7CE
http://distance.uaf.edu/


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Win32 Version 1.38.5

2006-03-01 Thread Helmut Raubenheimer



Thanks all,

we found it.
But now i am in real trouble. I tried some de_DE.UTF-8 setting, but all
i get is trouble with the linux console display of charsets.
I assume my ext3 filesystem is now written with iso-8859-15 (AFAIK the
same as the @euro thingy) .
So i get ? instead of umlauts when i change to UTF-8.
Does anyone know how convert the filesystem to UTF-8?


convmv converts the filenames to another encoding.
iconv converts the encoding in files.

Regards

Helmut



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] build bacula-sd client-only?

2006-03-01 Thread Harald A. Irmer

CASE CLOSED

Solution: You have to patch topmost Makefile.in: Add @STORED_DIR@ to the 
client-only case.




Hi,

is there a way to build bacula-sd client-only because the computers 
having storage devices connected to do not run SQL DBs and the server 
running the director is of different OS.


Yours,

Harald Artur Irmer


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] build bacula-sd client-only?

2006-03-01 Thread Ryan Novosielski
My apologies -- I got -fd confused with -sd (which actually, I'm
guessing in your original "been there done that" e-mail, you did too! :)).

 _  _ _  _ ___  _  _  _
|Y#| |  | |\/| |  \ |\ |  |  | Ryan Novosielski - User Support Spec. III
|$&| |__| |  | |__/ | \| _|  | [EMAIL PROTECTED] - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent. | IST/ACS - NJMS Medical Science Bldg - C630 

- Original Message -
From: "Harald A. Irmer" <[EMAIL PROTECTED]>
Date: Wednesday, March 1, 2006 10:57 am
Subject: Re: [Bacula-users] build bacula-sd client-only?

> Hi,
> 
> this configuration does not build bacula-sd
> 
> ./configure --prefix=/usr --enable-client-only --with-mon-dir-
> password= 
> --with-mon-fd-password= --with-mon-sd-password= --with-sd-password= 
> --with-fd-password= --with-dir-password= --with-dir-user=bacula 
> --with-fd-user=bacula --with-sd-user=bacula --with-dir-group=bacula 
> --with-fd-group=bacula --with-sd-group=bacula --enable-smartalloc 
> --sbindir=/usr/sbin --sysconfdir=/etc/bacula 
> --with-scriptdir=/etc/bacula --with-working-dir=/var/bacula 
> --with-pid-dir=/var/run --with-subsys-dir=/var/lock/subsys 
> --enable-build-stored
> 
> (with "--enable-build-stored").
> 
> > Hi,
> > 
> > is there a way to build bacula-sd client-only because the 
> computers 
> > having storage devices connected to do not run SQL DBs and the 
> > server running the director which has of course DB connection is 
> of different OS?
> 
> Yours,
> 
> Harald Artur Irmer
> 
> 
> ---
> This SF.Net email is sponsored by xPML, a groundbreaking scripting 
> languagethat extends applications into web and mobile media. Attend 
> the live webcast
> and join the prime developer group breaking into this new coding 
> territory!http://sel.as-
>
us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Win32 Version 1.38.5

2006-03-01 Thread kernel[consulting] info
Kern Sibbald schrieb:

>On Tuesday 28 February 2006 19:04, kernel[consulting] info wrote:
>  
>
>>Kern Sibbald schrieb:
>>
>>
>>>On Tuesday 28 February 2006 14:59, kernel[consulting] info wrote:
>>>  
>>>
Kern Sibbald schrieb:


>On Tuesday 28 February 2006 13:24, Dan Langille wrote:
>  
>
>>On 27 Feb 2006 at 15:13, kernel[consulting] info wrote:
>>
>>
>>>I have a problem restoring files from the wx-console running on WinXP.
>>>I was told to use bacula version 1.38.5, but i am unable to find the
>>>binary win32 release of 1.38.5. Can anyone please be so kind to point
>>>me in the right direction?
>>>  
>>>
>>It does not exist AFAIK. You'll be OK with the Windows 1.38.4
>>version.
>>
>>
>Yes, except that there is an embarrassing little problem here. He is
>reporting a bug against Win32 1.38.4, which I cannot produce, and, being
>confused with some changes we made to 1.38.3, I told him to upgrade to
>1.38.5, which doesn't exist. :-(
>  
>
Maybe i can send you my bacula database.
Perhaps you will be able to reprocude the error?

I would be glad to help in any way.


>>>The easiest way to work around the problem at the moment is either to use
>>>bconsole from you Win32 machine, or use any console from any Linux
>>>machine.
>>>
>>>
>>>
>>>---
>>>This SF.Net email is sponsored by xPML, a groundbreaking scripting
>>>language that extends applications into web and mobile media. Attend the
>>>live webcast and join the prime developer group breaking into this new
>>>coding territory!
>>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>>>___
>>>Bacula-users mailing list
>>>Bacula-users@lists.sourceforge.net
>>>https://lists.sourceforge.net/lists/listinfo/bacula-users
>>>  
>>>
>>Hello kern,
>>
>>i tried. Too bad, the filenames are not shown correctly even in the
>>bconsole running windows. The  umlauts are missing.
>>Only the characters, the filenames are there.
>>
>>I use :
>>
>>cat /etc/sysconfig/i18n
>>LANG="[EMAIL PROTECTED]"
>>COUNTRY="de"
>>LANGUAGE="de"
>>CHARSET="iso8859-15"
>>XMODIFIERS=""
>>
>>
>
>I never thought to ask you for your sysconfig -- good idea!, because:
>
>Hmm. This may well be your problem. I'm not an expert in Linux character sets, 
>but Bacula uses utf-8, which is the default on Linux. It looks like you have 
>turned off utf-8, which will create a database that is incompatible with the 
>Win32 consoles, which expect all Bacula database information to be in utf-8 
>format (Unicode).
>
>my /etc/sysconf/i18n looks like the following:
>
>LANG="en_US.UTF-8"
>SUPPORTED="en_US.UTF-8:en_US:en"
>
>I imagine (but don't really know) that you should not have the CHARSET, and 
>that you should have a .UTF-8 on the end of your LANG definition.  I've never 
>seen the @euro, so I'm not sure where that really fits in ...
>
>Perhaps a couple of German users could provide the output of 
>their /etc/sysconfig/i18n files -- especially those who have had success 
>using the Win32 version of wx-console with German accents.
>
>Best regards, Kern
>
>  
>
>>on my server running: Debian GNU/Linux 3.1 with 2.6.4-1-686
>>
>>i hope this is useful,
>>
>>Thanks all and especially kern for considering my case.
>>
>>Sebastian Hültenschmidt
>>
>>
>>
>>
>>
>>
>>
>>
>>---
>>This SF.Net email is sponsored by xPML, a groundbreaking scripting language
>>that extends applications into web and mobile media. Attend the live
>>webcast and join the prime developer group breaking into this new coding
>>territory!
>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>>___
>>Bacula-users mailing list
>>Bacula-users@lists.sourceforge.net
>>https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>
>  
>
Thanks all,

we found it.
But now i am in real trouble. I tried some de_DE.UTF-8 setting, but all
i get is trouble with the linux console display of charsets.
I assume my ext3 filesystem is now written with iso-8859-15 (AFAIK the
same as the @euro thingy) .
So i get ? instead of umlauts when i change to UTF-8.
Does anyone know how convert the filesystem to UTF-8?
Or is there a way to convert filename to UTF-8 BEFORE they are written
to the db in bacula?

hmmm.. looks like i am in a pinch now...

Sebastian Hültenschmidt



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
__

Re: [Bacula-users] build bacula-sd client-only?

2006-03-01 Thread Arno Lehmann

Hello,

On 3/1/2006 4:29 PM, Harald A. Irmer wrote:

Hi Ryan,

Been there, done that - it did not work!

Only bacula-sd has been build and that's the reason of my question ;-)


Have you tried --disable-build-dird ? This should create an FD and SD 
and bconsole which shouldn't hurt.


Arno


Ryan Novosielski wrote:


configure --help

You will see "--enable-client-only"

 _  _ _  _ ___  _  _  _
|Y#| |  | |\/| |  \ |\ |  |  | Ryan Novosielski - User Support Spec. III
|$&| |__| |  | |__/ | \| _|  | [EMAIL PROTECTED] - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent. | IST/ACS - NJMS Medical Science Bldg - C630
- Original Message -
From: "Harald A. Irmer" <[EMAIL PROTECTED]>
Date: Wednesday, March 1, 2006 10:05 am
Subject: [Bacula-users] build bacula-sd client-only?

 


Hi,

is there a way to build bacula-sd client-only because the computers 
having storage devices connected to do not run SQL DBs and the server 
running the director is of different OS.


Yours,

Harald Artur Irmer
--
Harald A. Irmer
ATIS - Abteilung Technische Infrastruktur

University of KarlsruheEmail: [EMAIL PROTECTED]
karlsruhe.deFaculty of Computer ScienceWWW  : 
http://atiswww.ira.uka.deBuilding 50.34 Room-No. 009

Am Fasanengarten 5 Fon  : +49 (721) 608-6963
D-76131 Karlsruhe / Germany Fax  : +49 (721) 608-6699



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting 
languagethat extends applications into web and mobile media. Attend 
the live webcast
and join the prime developer group breaking into this new coding 
territory!http://sel.as-


  


us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642___ 

 


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

  




Harald Artur Irmer


--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] build bacula-sd client-only?

2006-03-01 Thread Harald A. Irmer

Hi,

this configuration does not build bacula-sd

./configure --prefix=/usr --enable-client-only --with-mon-dir-password= 
--with-mon-fd-password= --with-mon-sd-password= --with-sd-password= 
--with-fd-password= --with-dir-password= --with-dir-user=bacula 
--with-fd-user=bacula --with-sd-user=bacula --with-dir-group=bacula 
--with-fd-group=bacula --with-sd-group=bacula --enable-smartalloc 
--sbindir=/usr/sbin --sysconfdir=/etc/bacula 
--with-scriptdir=/etc/bacula --with-working-dir=/var/bacula 
--with-pid-dir=/var/run --with-subsys-dir=/var/lock/subsys 
--enable-build-stored


(with "--enable-build-stored").


Hi,

is there a way to build bacula-sd client-only because the computers 
having storage devices connected to do not run SQL DBs and the 
server running the director which has of course DB connection is of different OS?


Yours,

Harald Artur Irmer


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] build bacula-sd client-only?

2006-03-01 Thread Ryan Novosielski
configure --help

You will see "--enable-client-only"

 _  _ _  _ ___  _  _  _
|Y#| |  | |\/| |  \ |\ |  |  | Ryan Novosielski - User Support Spec. III
|$&| |__| |  | |__/ | \| _|  | [EMAIL PROTECTED] - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent. | IST/ACS - NJMS Medical Science Bldg - C630 

- Original Message -
From: "Harald A. Irmer" <[EMAIL PROTECTED]>
Date: Wednesday, March 1, 2006 10:05 am
Subject: [Bacula-users] build bacula-sd client-only?

> Hi,
> 
> is there a way to build bacula-sd client-only because the computers 
> having storage devices connected to do not run SQL DBs and the 
> server 
> running the director is of different OS.
> 
> Yours,
> 
> Harald Artur Irmer
> -- 
> Harald A. Irmer
> ATIS - Abteilung Technische Infrastruktur
> 
> University of Karlsruhe   Email: [EMAIL PROTECTED]
> karlsruhe.deFaculty of Computer Science   WWW  : 
> http://atiswww.ira.uka.deBuilding 50.34 Room-No. 009
> Am Fasanengarten 5Fon  : +49 (721) 608-6963
> D-76131 Karlsruhe / Germany   Fax  : +49 (721) 608-6699
> 
> 
> 
> ---
> This SF.Net email is sponsored by xPML, a groundbreaking scripting 
> languagethat extends applications into web and mobile media. Attend 
> the live webcast
> and join the prime developer group breaking into this new coding 
> territory!http://sel.as-
>
us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] build bacula-sd client-only?

2006-03-01 Thread Harald A. Irmer

Hi Ryan,

Been there, done that - it did not work!

Only bacula-sd has been build and that's the reason of my question ;-)

Ryan Novosielski wrote:


configure --help

You will see "--enable-client-only"

 _  _ _  _ ___  _  _  _
|Y#| |  | |\/| |  \ |\ |  |  | Ryan Novosielski - User Support Spec. III
|$&| |__| |  | |__/ | \| _|  | [EMAIL PROTECTED] - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent. | IST/ACS - NJMS Medical Science Bldg - C630 


- Original Message -
From: "Harald A. Irmer" <[EMAIL PROTECTED]>
Date: Wednesday, March 1, 2006 10:05 am
Subject: [Bacula-users] build bacula-sd client-only?

 


Hi,

is there a way to build bacula-sd client-only because the computers 
having storage devices connected to do not run SQL DBs and the 
server 
running the director is of different OS.


Yours,

Harald Artur Irmer
--
Harald A. Irmer
ATIS - Abteilung Technische Infrastruktur

University of Karlsruhe Email: [EMAIL PROTECTED]
karlsruhe.deFaculty of Computer Science	WWW  : 
http://atiswww.ira.uka.deBuilding 50.34 Room-No. 009

Am Fasanengarten 5  Fon  : +49 (721) 608-6963
D-76131 Karlsruhe / Germany Fax  : +49 (721) 608-6699



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting 
languagethat extends applications into web and mobile media. Attend 
the live webcast
and join the prime developer group breaking into this new coding 
territory!http://sel.as-


   


us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642___
 


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

   




Harald Artur Irmer
--
Harald A. Irmer
ATIS - Abteilung Technische Infrastruktur

University of Karlsruhe Email: [EMAIL PROTECTED]
Faculty of Computer Science WWW  : http://atiswww.ira.uka.de
Building 50.34 Room-No. 009
Am Fasanengarten 5  Fon  : +49 (721) 608-6963
D-76131 Karlsruhe / Germany Fax  : +49 (721) 608-6699



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] build bacula-sd client-only?

2006-03-01 Thread Harald A. Irmer

Hi,

is there a way to build bacula-sd client-only because the computers 
having storage devices connected to do not run SQL DBs and the server 
running the director is of different OS.


Yours,

Harald Artur Irmer
--
Harald A. Irmer
ATIS - Abteilung Technische Infrastruktur

University of Karlsruhe Email: [EMAIL PROTECTED]
Faculty of Computer Science WWW  : http://atiswww.ira.uka.de
Building 50.34 Room-No. 009
Am Fasanengarten 5  Fon  : +49 (721) 608-6963
D-76131 Karlsruhe / Germany Fax  : +49 (721) 608-6699



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Incremental Pool and day-specific filenames

2006-03-01 Thread Matthew Butt
I'm trying to setup a backup system with Full on the first Sunday of
each month, Diff on subsequent Sundays and Incrementals daily.  Backups
are written to external USB hard drives.

I'm following quite closely the example given at
http://www.bacula.org/rel-manual/Automated_Disk_Backup.html.  The change
I'm making is that I need to backup multiple servers.  I've amended the
pools and jobs as needed but I have one problem.  The pool file is not
being renamed on the disk drive I'm using.  Ie if I run an incremental
backup on Feb 24th the file created is Inc-2006-02-24.  The next
incremental backup on the next day uses the same filename, not
Inc-2006-02-25 as expected, which is messing up the volume recycling.
Configuration snippets are below

Any pointers please?

JobDefs {
  Name = "DefaultJob"
  Type = Backup
  Schedule = "WeeklyCycle"
  Storage = File
  Messages = Standard
  Pool = Default
  Full Backup Pool = Full-Pool
  Incremental Backup Pool = Inc-Pool
  Differential Backup Pool = Diff-Pool
  Priority = 10
}

Job {
  Name = "Server1"
  Client = server1-fd
  JobDefs = "DefaultJob"
  Write Bootstrap = "/var/bacula/Server1.bsr"
  FileSet = "Server1"
}

Job {
  Name = "Server2"
  Client = server2-fd
  JobDefs = "DefaultJob"
  Write Bootstrap = "/var/bacula/ Server2.bsr"
  FileSet = " Server2"
}

Pool {
  Name = Inc-Pool
  Pool Type = Backup
  Recycle = yes
  AutoPrune = yes
  Volume Retention = 20 days
  Accept Any Volume = yes
  Label Format = "Inc-${Year}-${Month:p/2/0/r}-${Day:p/2/0/r}"
  Maximum Volumes = 5
}


Matt



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Upgrade from 1.36.3 to the latest version

2006-03-01 Thread Michel Meyers

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Arunav Mandal wrote:

On Tuesday 28 February 2006 17:19, Arno Lehmann wrote:

Hello,

On 2/28/2006 2:14 PM, Arunav Mandal wrote:

We are running Bacula 1.36.3 in both director and storage daemon and on
clients as well. We are now planning to upgrade the director and storage
daemon do I have to upgrade the client as well or just the director and
storage daemon will work?

No, you'll have to upgrade all machines involved.


Is there any easy way to upgrade a lot of client
machines at the same time?

None that I know of. The simple solution might be to prepare packages
tailored to your needs and install them as you do in your organization.
The windows package is, as far as I know, created using an open source
installation program, so t shold be possible to adapt it to your needs
(paths mainly, I think).


The Windows package uses the Nullsoft Scriptable Install System
(http://nsis.sf.net) and I think I'm the original author of the install
script. I initially integrated some 'silent-install' functionality into
my version and unless that got removed when it went into the main
project, it should still be there (at least with winbacula-1.38.4.exe I
can still use it).

Example: winbacula-1.38.4.exe /S /service
It only works if you use the default path of c:\bacula though.

See http://tcnnet.dyndns.org/winbacula/ for some documentation on the
installer. You can also find the original script there (The newer
versions are in CVS at
http://cvs.sourceforge.net/viewcvs.py/bacula/bacula/src/win32/ . Look
for .nsi and .nsh files.)


Creating .rpms or .debs for linux should also be possible, but that's
nothing I know much about.


What about the client name and password in the bacula-fd.conf as if I make a
generic package I have to manually change it.


Just don't overwrite it. I don't think there was a change there and the
normal behaviour of the installer leaves bacula-fd.conf alone as well
(if it detects presence of the .conf file, it writes out the default
ones with extension .conf.new).

If you search the ML archives, you should also find a script that I
wrote that uses Samba-TNG and Windows' RPC Service to remotely stop the
FD, push the upgrades and then restart the FD afterwards. I still use
that method to maintain Bacula on the 6 machines that I have.

I don't have any particular advice for Unix/Linux systems but those are
easily scriptable anyway.

Hope that helps.

Greetings,
   Michel
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (MingW32) - GPGrelay v0.959

iD8DBQFEBa5O2Vs+MkscAyURAl8GAKDahf2tnru/QSgSP63cGbfkjro/lQCeNNJZ
XqXKDvlqduaEA3HvkPJV6eg=
=0r3z
-END PGP SIGNATURE-


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] list job= and related broader question

2006-03-01 Thread Arno Lehmann

Once more, again blacklisted...

this gets interesting ;-)

And once more because I sent this to the wrong list...

resend, because my mail provider managed to get one of his mailers onto
a blacklist...

Hello,

you wrote a very nice mail - only I think many list-readers will not
bother to read that long text ;-)

On 2/28/2006 11:39 PM, Christopher Mills wrote:
I searched the archive for an answer to this question. I found it asked 
but never answered:


The bconsole command 'list jobs' gives me a list of runs from all jobs. 
I want to narrow it to all job runs from a particular job. The bconsole 
doc under "list" seems to imply that would be done with:


  list job=My-Job

This doesn't work (I am running mysql under Gentoo Linux).


The same here. Either the manual is wrong or this is a bug, I say.


I tried ...
Alas, my suspicion is this query just doesn't function.


By now, I suspect the same.

Since I believe 
that this is a very fundemental query, and since out of the corner of my 
eye while searching the archives for an answer I seem to have noticed 
questions about formulating sql queries against the Bacula database 
tables, I have a broader question in regard to what I should expect in 
diving into Bacula:


Should I expect that the Bacula development community is focusing on the 
more critical areas of this highly complex and powerful  opensource 
project?


That's what it looks like, and even though I understand the question
behind what you wrote :-) I don't think this should remain unfixed.

Should I bite the bullet, and bone up on my sql skills on the 
assumption that these relatively benign (but from a practical 
perspective of a Bacula implimentation, important) queries may not be 
fully debugged and tested as of yet? Should I assume that I will "become 
one" with the product more quickly if I just accept this, and learn to 
write my own queries as needed?


Well, if you want to get more fluent in SQL this could be just the right
project :-)

I am really hoping the answer is "no." But I can understand if it is 
"yes," as I certainly haven't been the one contributing to this 
monumental project :) (Although, if it is "yes" I will confess to being 
a little disappointed as I was hoping query writing would only come up 
in future fine-tuning of my implimentation).


I'd even say that in many cases you don't need to write any SQL at all.

If this is the case, then I am just wondering where I should start. I 
haven't really tried to delve into the source although I have taken a 
peek at "query.sql." What is not clear to me is where all the queries 
forming the 'list' commands are hiding. Do I need to get my hands on 
some source to get started on examples of useful queries? Should the 
task be to simply tack new queries onto query.sql as I need them?


Yes and no.

The SQL behind the commands like list is indeed hiding in the source
code. You can, however, achieve what you want by using queries in
query.sql, which I'd recommend.

Parameter passing is done in a dialog there, but it's obviously much
easier to try out queries - no need to recompile, install and restart
the binaries, only saving the file and issueing the query command from
bconsole.

Or am I getting paranoid, all documented queries work great, and I am 
just being clueless, having missed the obvious (which wouldn't be the 
first time)? :)


Not this time, I'm afraid...


Thanks in advance for any help and advice.


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live 
webcast

and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users



--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de




--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/bacula-devel


--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de




--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de


---

Re: [Bacula-users] Upgrade from 1.36.3 to the latest version

2006-03-01 Thread Arunav Mandal
On Tuesday 28 February 2006 17:19, Arno Lehmann wrote:
> Hello,
>
> On 2/28/2006 2:14 PM, Arunav Mandal wrote:
> > We are running Bacula 1.36.3 in both director and storage daemon and on
> > clients as well. We are now planning to upgrade the director and storage
> > daemon do I have to upgrade the client as well or just the director and
> > storage daemon will work?
>
> No, you'll have to upgrade all machines involved.
>
> > Is there any easy way to upgrade a lot of client
> > machines at the same time?
>
> None that I know of. The simple solution might be to prepare packages
> tailored to your needs and install them as you do in your organization.
> The windows package is, as far as I know, created using an open source
> installation program, so t shold be possible to adapt it to your needs
> (paths mainly, I think).
>
> Creating .rpms or .debs for linux should also be possible, but that's
> nothing I know much about.

What about the client name and password in the bacula-fd.conf as if I make a 
generic package I have to manually change it.

> Arno
>
> > Client machines include both windows and linux.
> >
> > Thanks in advance,

-- 
Arunav Mandal - amandal at trolltech.com
Trolltech AS - Sandakerveien 116, Postboks 4332 Nydalen, 0402 Oslo, Norway
Phone: +47 21 60 27 22, Fax: +47 21 60 48 02


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula & ADIC 1000

2006-03-01 Thread Marc Patino Gómez

Hi floks,

has anyone exprience with Bacula & ADIC 1000. It's this library fully 
supported by bacula.


Thanks in advance

--


Marc Patino Gómez
Dpto. Sistemas

Claranet España. Servicios Internet
C/General Almirante 2-28, Torres Cerdá
08014 Barcelona
Tel: +34 93 445 26 50
Fax: +34 93 445 19 20
www.claranet.es

Claranet Group: United Kingdom - Spain - France - Germany - Portugal - 
Netherlands - USA





---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Tape format

2006-03-01 Thread Kai Matla
Hi all,

> > I got a little problem. We had a DLT4000 Lib and
used
> > several tapes to backup data. Now we upgraded the
lib
> > to DLT8000 and want to use the same tapes (DLT
IV).
> > The backup works fine with old an new tapes, but
the
> > old ones (formated with the DLT4000 drive) are
used as
> > DLT4000. The drive just packs half the data on
them
> > compared to a completly new tape and it takes the
same
> > time as before on DLT4000.
> > 
> > I tried to find an option in Bacula, at the lib or
in
> > mt. But with all tries it would only erase the
data on
> > the tape and not the format.
> > How can I format the old DLT4000 tapes to DLT8000?
> 
> 
> This isn't a Bacula option.  It's a tape drive
option.
> 
> When you put the tape into the drive, the drive
tries to determine 
> the density already on the tape.  It likes to keep
it the same as the 
> exsiting tape.  What you need to do is tell the
drive to do something 
> else.
> 
> I've never tried it.  On the panel of your DLT
drive, there should be 
> a button to set the density and override the setting
that it found.  
> Try that.  Let us know.

I tried to do it at the Library/Drive, but with no
success, so I worked my way to a solution with mt.
Hope it helps others, but no guarantee..

1. "umount Tape" in Bacula
2. load the old (DLT4000) tape in the drive 
3. look at the status: # mt -f /dev/nst0 status (nst0
is my drive, my result is "Density code 0x83 (DLTtape
IV 4000 compressed (40GB))" or "Density code 0x1a
(DLTtape IV (81633 bpi))")
4. set the new density: # mt -f /dev/nst0 setdensity
0x89 ("0x89" for DLT8000)
5. rewind the tape: # mt -f /dev/nst0 rewind
6. write End of File: # mt -f /dev/nst0 weof
7. check status: # mt -f /dev/nst0 status (my result
is "Density code 0x89 (DLTtape IV 8000 compressed
(80GB))")
8. delete tape in Bacula
9. label tape in Bacula (same name as before is
possible)
10. don´t forget to update the volume information in
Bacula about the slot the tape came from, in case you
have a library, since Bacula lost that info when
deleting the old tape

Maybe some of these steps are obsolete, but it worked
that way for me.

Thanks for the tips that got me in the right
direction.

Bye,
Kai






___ 
Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Win32 Version 1.38.5

2006-03-01 Thread Chris Crowther
Landon Fuller wrote:

> Who is generally handles the Win32 Bacula builds?

Whoever it is has a lot of patience or luck, having tried to do it
myself :)

Does anyone know if it's actually possible to build it with TLS
support on Windows?

> Cheers,
> -landonf

-- 
hikari


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] DB problems due to character set encoding

2006-03-01 Thread John Kodis
On Wed, Mar 01, 2006 at 09:08:43AM +0100, Kern Sibbald wrote:

> It looks like you have turned off utf-8, which will create a
> database that is incompatible with the Win32 consoles, which expect
> all Bacula database information to be in utf-8 format (Unicode).

A few weeks ago I mentioned another problem that this same character
set mismatch caused for me (see "[Bacula-devel] A Pair of Postgres
Issues", Jan 14).  There I suggest the use of the --encoding option
when creating the database tables as a work-around for the problems
that I encountered.

Given that the UTF-8 character set is a requirement for Bacula, it
seems like it would be a good idea to force this by adding "--encoding
utf-8" to the Postgres database creation script, and whatever the
equivalent is to the scripts for the other databases.

-- John Kodis.


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] tape throughput

2006-03-01 Thread Rudolf Cejka
Sebastian Stark wrote (2006/03/01):
> >>I never get more than ~28MB/s backing up to an HP Ultrium-3 drive. I
> >Yes, if you use LTO-2 cartridges, you can get max. LTO-2 speeds.
> Then 28MB/s looks pretty good, right? 30 is the most you can get out  
> of LTO-2 cartridges if I remember correctly.

Sorry - yes, 28 MB/s is good for LTO-2. I have read two-zero instead
of two-eight (I have not very good terminal font :o/).

Regards.

-- 
Rudolf Cejka  http://www.fit.vutbr.cz/~cejkar
Brno University of Technology, Faculty of Information Technology
Bozetechova 2, 612 66  Brno, Czech Republic


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] tape throughput

2006-03-01 Thread Sebastian Stark


On 01.03.2006, at 12:56, Rudolf Cejka wrote:


Sebastian Stark wrote (2006/03/01):

I never get more than ~28MB/s backing up to an HP Ultrium-3 drive. I


Momentary speed or overall speed including data spooling, tape write
and database update? For momentary it is slow, for overall it is
relatively fast.


I measured with iostat -x because the speed measured by bacula does  
reflect more then just tape I/O. So these 28MB/s are tape write  
performance, excluding network/disk/database overhead.


Overhead included I get something around 5-10 MB/s usually.




configured spooling to a locally attached raid that allows for much
faster througput, bonnie++ says ~160MB/s when reading block-wise.
Could this be a problem with my bacula configuration or rather a
problem with my OS configuration? Maybe because both, thhe disk used
for spooling and the tape drive are sharing the same FibreChannel
bus?


It is hard to say. The another reason would be slow processor
or slow machine at all.


It's not NEAR a load of 1 (dual Sparc) and if I query the bacula  
database manually it's blazingly fast.





Could it be because I'm using LTO-2 cartridges?


Yes, if you use LTO-2 cartridges, you can get max. LTO-2 speeds.


Then 28MB/s looks pretty good, right? 30 is the most you can get out  
of LTO-2 cartridges if I remember correctly.


Thanks for your reply.



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Big RAID solutions and bacula

2006-03-01 Thread dogfart big
Thanks a lot!Juan Luis Frances <[EMAIL PROTECTED]> wrote:  If you choose iscsi option don't use 2.4.x kernels. Only the 2.6 drivers work with a decent throughput.The iscsi device is as another scsi drive under linux and because of that it is transparently for bacula.You must use "Media Type = File" under "Device" (bacula-sd.conf).Best regards,Juan LuisPS: I don't recomend you the EMC AX100 ;-)El Miércoles 01 Marzo 2006 12:41, dogfart big escribió:> Did anyone implement some storage (SAN) solution with bacula like fibre> chenel or scsi raid solution for storage purpose. Have any documents about> this? Any recomended Raid Solution?>> Best regards and THANKS!>>> -> Yahoo! Mail> Bring photos 
 to life!
 New PhotoMail makes sharing a breeze.---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcastand join the prime developer group breaking into this new coding territory!http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642___Bacula-users mailing listBacula-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/bacula-users__Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com 

Re: [Bacula-users] Big RAID solutions and bacula

2006-03-01 Thread Juan Luis Frances
If you choose iscsi option don't use 2.4.x kernels. Only the 2.6 drivers work 
with a decent throughput.

The iscsi device is as another scsi drive under linux and because of that it 
is transparently for bacula.

You must use "Media Type = File" under "Device" (bacula-sd.conf).

Best regards,
Juan Luis


PS: I don't recomend you the EMC AX100 ;-)

El Miércoles 01 Marzo 2006 12:41, dogfart big escribió:
> Did anyone implement some storage (SAN) solution with bacula like fibre
> chenel or scsi raid solution for storage purpose. Have any documents about
> this? Any recomended Raid Solution?
>
>   Best regards and THANKS!
>
>
> -
> Yahoo! Mail
> Bring photos to life! New PhotoMail  makes sharing a breeze.


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] tape throughput

2006-03-01 Thread Rudolf Cejka
Sebastian Stark wrote (2006/03/01):
> I never get more than ~28MB/s backing up to an HP Ultrium-3 drive. I

Momentary speed or overall speed including data spooling, tape write
and database update? For momentary it is slow, for overall it is
relatively fast.

> configured spooling to a locally attached raid that allows for much
> faster througput, bonnie++ says ~160MB/s when reading block-wise.
> Could this be a problem with my bacula configuration or rather a
> problem with my OS configuration? Maybe because both, thhe disk used
> for spooling and the tape drive are sharing the same FibreChannel
> bus?

It is hard to say. The another reason would be slow processor
or slow machine at all.

> Could it be because I'm using LTO-2 cartridges?

Yes, if you use LTO-2 cartridges, you can get max. LTO-2 speeds.

Regards.

-- 
Rudolf Cejka  http://www.fit.vutbr.cz/~cejkar
Brno University of Technology, Faculty of Information Technology
Bozetechova 2, 612 66  Brno, Czech Republic


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Big RAID solutions and bacula

2006-03-01 Thread dogfart big
Did anyone implement some storage (SAN) solution with bacula like fibre chenel or scsi raid solution for storage purpose. Have any documents about this?  Any recomended Raid Solution?     Best regards and THANKS!
		Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze. 


Re: [Bacula-users] Negative test of bacula-dir.

2006-03-01 Thread Sebastian Stark


On 01.03.2006, at 11:09, Erik P. Olsen wrote:

What happens when you enter 'use bacula'?

mysql> use bacula;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
Apparently I can open and use bacula database from the command line  
and bacula can't. I don't see any "no permission" messages so I  
believe the necessary permissions are in place. Could it be that a  
special link between bacula and mysql has not been set up and thus  
is missing?


I am a total loss on this problem and don't know what to do other  
than a total reinstall of both bacula and mysql. Insidentally, both  
bacula-fd and bacula-sd start up without problems it is "only"  
bacula-dir which causes problems.


Any chance that you linked bacula to a different libmysqlclient? I  
can see you're using mysqld 4.1, if you used 4.0 headers/libs to  
compile bacula this could be the problem.



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] tape throughput

2006-03-01 Thread Sebastian Stark


What tape throughput are people seeing under Solaris (10)?

I never get more than ~28MB/s backing up to an HP Ultrium-3 drive. I  
configured spooling to a locally attached raid that allows for much  
faster througput, bonnie++ says ~160MB/s when reading block-wise.  
Could this be a problem with my bacula configuration or rather a  
problem with my OS configuration? Maybe because both, thhe disk used  
for spooling and the tape drive are sharing the same FibreChannel  
bus? Could it be because I'm using LTO-2 cartridges?



Thanks for any pointers.
-Sebastian


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Why is this job regarded as canceled ?

2006-03-01 Thread Daniel Holtkamp

Hi !

--- SNIP --
28-Feb 21:05 backup-dir: Prior failed job found. Upgrading to Full.
28-Feb 21:05 backup-dir: RunBefore: Connecting to Director backup:9101
28-Feb 21:05 backup-dir: RunBefore: 1000 OK: backup-dir Version: 1.38.4 
(14 January 2006)

28-Feb 21:05 backup-dir: RunBefore: Enter a period to cancel a command.
28-Feb 21:05 backup-dir: RunBefore: mount storage=leibniz-storage
28-Feb 21:05 backup-dir: RunBefore: Using default Catalog name=MyCatalog 
DB=bacula
28-Feb 21:05 backup-dir: RunBefore: 3001 Device "leibniz-sd" (/dev/nst3) 
is mounted with Volume "leibniz.full.0003"

28-Feb 21:05 backup-dir: RunBefore: You have messages.
28-Feb 21:05 backup-dir: RunBefore: quit
28-Feb 21:05 backup-dir: Start Backup JobId 4069, 
Job=Leibniz.2006-02-28_21.05.03
28-Feb 21:05 backup-sd: Recycled volume "leibniz.full.0003" on device 
"leibniz-sd" (/dev/nst3), all previous data lost.

28-Feb 21:05 backup-sd: Spooling data ...
leibniz-fd:  Filesystem change prohibited. Will not descend into /dev
leibniz-fd:  Filesystem change prohibited. Will not descend into /export
leibniz-fd:  Filesystem change prohibited. Will not descend into /home
leibniz-fd:  Filesystem change prohibited. Will not descend into /var
leibniz-fd:  Filesystem change prohibited. Will not descend into /usr
leibniz-fd:  Filesystem change prohibited. Will not descend into /sys
leibniz-fd:  Filesystem change prohibited. Will not descend into 
/var/lib/nfs/rpc_pipefs
01-Mar 07:27 backup-sd: Committing spooled data to Volume 
"leibniz.full.0003". Despooling 74,622,400,511 bytes ...
01-Mar 08:57 backup-dir: Max Volume jobs exceeded. Marking Volume 
"leibniz.full.0003" as Used.
01-Mar 08:57 backup-sd: Alert: mtx: cannot open SCSI device '*None*' - 
No such file or directory
01-Mar 08:57 backup-sd: Sending spooled attrs to the Director. 
Despooling 338,831,806 bytes ...

01-Mar 09:31 backup-dir: Bacula 1.38.4 (14Jan06): 01-Mar-2006 09:31:41
  JobId:  4069
  Job:Leibniz.2006-02-28_21.05.03
  Backup Level:   Full (upgraded from Incremental)
  Client: "leibniz-fd" 
i686-redhat-linux-gnu,redhat,Enterprise release

  FileSet:"Leibniz" 2005-10-19 20:05:02
  Pool:   "leibniz-full-pool"
  Storage:"leibniz-storage"
  Scheduled time: 28-Feb-2006 21:05:02
  Start time: 28-Feb-2006 21:05:04
  End time:   01-Mar-2006 09:31:41
  Priority:   10
  FD Files Written:   1,107,563
  SD Files Written:   1,107,563
  FD Bytes Written:   74,304,949,609
  SD Bytes Written:   74,481,407,723
  Rate:   1658.7 KB/s
  Software Compression:   37.3 %
  Volume name(s): leibniz.full.0003
  Volume Session Id:  5
  Volume Session Time:1141142006
  Last Volume Bytes:  74,608,522,428
  Non-fatal FD errors:0
  SD Errors:  0
  FD termination status:  OK
  SD termination status:  OK
  Termination:Backup Canceled
--- SNIP --

Why is this job reported as canceled ? I can see no reason as it spooled 
fine and put everything on tape ?


Best Regards,
--
Daniel HoltkampRiege Software International GmbH
System Administration   Mollsfeld 10
40670 Meerbusch, Germany Phone: +49-2159-9148-41
mail: holtkamp [at] riege.comFax:   +49-2159-9148-11



---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Negative test of bacula-dir.

2006-03-01 Thread Erik P. Olsen

Erik P. Olsen wrote:

Arno Lehmann wrote:


Hello,

On 2/26/2006 8:30 PM, Erik P. Olsen wrote:


Dan Langille wrote:



...


[EMAIL PROTECTED] conf]# ../bin/bacula-dir -d 99 -t -c bacula-dir.conf
bacula-dir: dird.c:128 Debug level = 99
bacula-dir: mysql.c:142 mysql_init done
bacula-dir: mysql.c:162 mysql_real_connect done
bacula-dir: mysql.c:164 db_user=bacula db_name=bacula db_password=
26-Feb 20:18 bacula-dir:  Fatal error: Could not open database "bacula".
26-Feb 20:18 bacula-dir:  Fatal error: mysql.c:170 Unable to connect 
to MySQL server.

Database=bacula User=bacula
It is probably not running or your password is incorrect.
26-Feb 20:18 bacula-dir ERROR TERMINATION
Please correct configuration file: bacula-dir.conf



Is MySQL running?





Yes



Please show us the Catalog resource from bacula-dir.conf





Catalog {
  Name = MyCatalog
  dbname = bacula; user = bacula; password = ""
}



Can you connect to mysql on the command line using the parameters in 
the Catalog resource?



Yes:

[EMAIL PROTECTED] ~]$ mysql -u bacula
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 4.1.18-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>




What happens when you enter 'use bacula'?



mysql> use bacula;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

Apparently I can open and use bacula database from the command line and 
bacula can't. I don't see any "no permission" messages so I believe the 
necessary permissions are in place. Could it be that a special link 
between bacula and mysql has not been set up and thus is missing?


I am a total loss on this problem and don't know what to do other than a 
total reinstall of both bacula and mysql. Insidentally, both bacula-fd 
and bacula-sd start up without problems it is "only" bacula-dir which 
causes problems.


--
Regards,
Erik P. Olsen


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] LabelFormat is deprecated?

2006-03-01 Thread Kern Sibbald
On Tuesday 28 February 2006 20:01, Georg Lutz wrote:
> On 2006-02-26, Felix Schwarz wrote:
> > I just noticed that the directive LabelFormat is deprecated in 1.38 -
> > at least according to the manual:
> > "Please note that this directive is deprecated and is replaced in
> > version 1.37 and greater with a Python script for creating volume
> > names."
>
> Does this mean that I have to write a python script in order to
> automatically label new monthly archive tapes like Month-001, Month-002,
> ... ?

Actually, I should be a bit more specific:  the variable substitution used in 
LabelFormat is depreciated, which means that in a year or two it will be 
removed.  If you are using a LabelFormat such as "Month-", which will 
automatically generate the above, that code will remain as it is quite 
simple, easy to understand, and easy to maintain.

Best regards, Kern

PS: Programming Python is easy. If you take the default DirStartUp.py script, 
delete a few example print/JobReport statements and change:

job.VolumeName="TestA-%d" % numvol

to

job.VolumeName="Month-%d" % numvol

you will most likely have what you do now.


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Win32 Version 1.38.5

2006-03-01 Thread Kern Sibbald
On Tuesday 28 February 2006 19:04, kernel[consulting] info wrote:
> Kern Sibbald schrieb:
> >On Tuesday 28 February 2006 14:59, kernel[consulting] info wrote:
> >>Kern Sibbald schrieb:
> >>>On Tuesday 28 February 2006 13:24, Dan Langille wrote:
> On 27 Feb 2006 at 15:13, kernel[consulting] info wrote:
> >I have a problem restoring files from the wx-console running on WinXP.
> >I was told to use bacula version 1.38.5, but i am unable to find the
> >binary win32 release of 1.38.5. Can anyone please be so kind to point
> > me in the right direction?
> 
> It does not exist AFAIK. You'll be OK with the Windows 1.38.4
> version.
> >>>
> >>>Yes, except that there is an embarrassing little problem here. He is
> >>>reporting a bug against Win32 1.38.4, which I cannot produce, and, being
> >>>confused with some changes we made to 1.38.3, I told him to upgrade to
> >>>1.38.5, which doesn't exist. :-(
> >>
> >>Maybe i can send you my bacula database.
> >>Perhaps you will be able to reprocude the error?
> >>
> >>I would be glad to help in any way.
> >
> >The easiest way to work around the problem at the moment is either to use
> >bconsole from you Win32 machine, or use any console from any Linux
> > machine.
> >
> >
> >
> >---
> >This SF.Net email is sponsored by xPML, a groundbreaking scripting
> > language that extends applications into web and mobile media. Attend the
> > live webcast and join the prime developer group breaking into this new
> > coding territory!
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> > ___
> >Bacula-users mailing list
> >Bacula-users@lists.sourceforge.net
> >https://lists.sourceforge.net/lists/listinfo/bacula-users
>
> Hello kern,
>
> i tried. Too bad, the filenames are not shown correctly even in the
> bconsole running windows. The  umlauts are missing.
> Only the characters, the filenames are there.
>
> I use :
>
> cat /etc/sysconfig/i18n
> LANG="[EMAIL PROTECTED]"
> COUNTRY="de"
> LANGUAGE="de"
> CHARSET="iso8859-15"
> XMODIFIERS=""

I never thought to ask you for your sysconfig -- good idea!, because:

Hmm. This may well be your problem. I'm not an expert in Linux character sets, 
but Bacula uses utf-8, which is the default on Linux. It looks like you have 
turned off utf-8, which will create a database that is incompatible with the 
Win32 consoles, which expect all Bacula database information to be in utf-8 
format (Unicode).

my /etc/sysconf/i18n looks like the following:

LANG="en_US.UTF-8"
SUPPORTED="en_US.UTF-8:en_US:en"

I imagine (but don't really know) that you should not have the CHARSET, and 
that you should have a .UTF-8 on the end of your LANG definition.  I've never 
seen the @euro, so I'm not sure where that really fits in ...

Perhaps a couple of German users could provide the output of 
their /etc/sysconfig/i18n files -- especially those who have had success 
using the Win32 version of wx-console with German accents.

Best regards, Kern

>
> on my server running: Debian GNU/Linux 3.1 with 2.6.4-1-686
>
> i hope this is useful,
>
> Thanks all and especially kern for considering my case.
>
> Sebastian Hültenschmidt
>
>
>
>
>
>
>
>
> ---
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live
> webcast and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Win32 Version 1.38.5

2006-03-01 Thread Kern Sibbald
On Wednesday 01 March 2006 07:00, Landon Fuller wrote:
> Arno Lehmann wrote:
> > Hello,
> >
> > On 2/27/2006 3:13 PM, kernel[consulting] info wrote:
> >> I have a problem restoring files from the wx-console running on WinXP.
> >> I was told to use bacula version 1.38.5, but i am unable to find the
> >> binary win32 release of 1.38.5. Can anyone please be so kind to point me
> >> in the right direction?
> >
> > Unfortunately not.
> >
> > I don't think there's a released version of winbacula 1.38.5.
>
> Who is generally handles the Win32 Bacula builds?

Until 1.38.5 it was Scott, but for 1.38.5 Scott didn't have the appropriate 
Micro$oft license so I built the Win32 Bacula.  In the future, it will be 
Scott as we have corrected the license problem thanks to Bacula 
contributions.

Regards, Kern


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Changing the Files.Lstat to something readable format

2006-03-01 Thread Kern Sibbald
On Tuesday 28 February 2006 19:37, James Ray wrote:
> I'm after changing the Files.Lstat field in the bacula database into
> something that is more humanly readable. Does any one have any ideas how
> to do this from with in SQL itself (using mysql here) or from within a
> perl script that I can pass the values to by hand if needed...
>
> Thanks very much for any help you can give.

If you look at the perl script recover.pl written by Karl Hakimian you will 
find a very nice implementation of the necessary functions. 


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users