[Bacula-users] Cacheing and consistent security copies

2005-03-24 Thread DAVID BROOK



We are currently implementing Bacula to secure a 
network of 5/6 Linux and Windows hosts.
 
If we run our backups while there are other jobs 
running on the client machine, can we be sure we will get a consistent data 
backup?
 
It might well be my lack of understanding of the 
cacheing process, but as several applications use Delayed writes and the 
operating systems themselves use cacheing, we are having difficulty seeing how 
consistency can be guaranteed if there are any files on the system opened 
for writing.
 
As far as we can see, for 100% certainty of data 
consistency, nothing else should be running on the client - is this the 
case?
 
 
Would be very grateful for comments
 
Thanks in advance
 
David
 
 


[Bacula-users] Send mail report to other users

2005-03-24 Thread Jonas Björklund
Hello,
I want to send the bakup report to a different address for one client.
I tried with the "Messages" resource on the client (bacula-fd.conf) 
without any luck.

Is this possible?
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Cacheing and consistent security copies

2005-03-24 Thread Jonas Björklund

On Thu, 24 Mar 2005, DAVID BROOK wrote:

 > If we run our backups while there are other jobs running on the client 
 > machine, can we be sure we will get a consistent data backup?

It depends your software on your clients.
Bacula will backup everything in the file sets.
If your software on the clients have things in their memory that they 
haven't written to disk Bacula will not be able to store that data.


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Send mail report to other users

2005-03-24 Thread Michael Scherer
Moin.
Add a new "Message" block to the director config and use that in the job.
Messages {
name = new_message_to_diff_user
[...]
}
Job {
[...]
Messages = new_message_to_diff_user
}
Greetings,
 Michael
Jonas Björklund wrote:
Hello,
I want to send the bakup report to a different address for one client.
I tried with the "Messages" resource on the client (bacula-fd.conf) 
without any luck.

Is this possible?
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  
Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

--
   GiS - Gesellschaft fuer integrierte Systemplanung mbH
+==+
  Michael Scherer   [EMAIL PROTECTED]  Tel: 06201-503-74
  Junkersstr.2  69469 Weinheim  Fax: 06201-503-66
+==+
I am root. If you see me laughing, you better have a backup.

---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Cacheing and consistent security copies

2005-03-24 Thread Michel Meyers
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
DAVID BROOK wrote:
It might well be my lack of understanding of the cacheing process, but
as several applications use Delayed writes and the operating systems
themselves use cacheing, we are having difficulty seeing how consistency
can be guaranteed if there are any files on the system opened for writing.
My guess would be that Bacula uses the OS's read functions, so its up to
the OS to return the data, even the part that is still in the write
cache. Alternatively, the OS could flush the cache before reading the data.
As far as we can see, for 100% certainty of data consistency, nothing
else should be running on the client - is this the case?
That is definitely true. You can never guarantee consistency on a moving
target. There are ways to reduce chances of backing up an inconsistent
state (for Windows there's St Bernards Open File Manager with its
caching/snapshotting algorythms, for Linux you can try to snapshot stuff
while your app is up, hoping that there were no changes at the moment
you took the snapshot) but if you really need to be 100% sure, my advice
would be to shut down the applications whose data you're backing up.
To reduce downtime on Linux systems, you can shut down the applications,
snapshot the volume with LVM (provided you use LVM volumes of course),
start up your apps again and run the backup on the LVM snapshot in the
background.
Also note, that the Bacula-FD cannot back up open files on Windows (it
will simply skip them). You will need St Bernards Open File Manager for
that.
Hope that helps.
Greetings,
Michel
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.0 (MingW32) - GPGrelay v0.955
iD8DBQFCQogo2Vs+MkscAyURAgJFAKDAdCXbOzSU6+nMIM6IZI/PEopbgwCgxXrN
GF7PCoh6ybfzmOSZwn9PDts=
=y+yR
-END PGP SIGNATURE-
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Send mail report to other users

2005-03-24 Thread Jonas Björklund

On Thu, 24 Mar 2005, Michael Scherer wrote:

 > Add a new "Message" block to the director config and use that in the job.
 > 
 > Messages {
 > name = new_message_to_diff_user
 > [...]
 > }
 > 
 > Job {
 > [...]
 > Messages = new_message_to_diff_user
 > }

Thanks!!


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Road Map for Next Release

2005-03-24 Thread Kern Sibbald
On Thursday 24 March 2005 00:13, Arno Lehmann wrote:
> Rick,
>
> Rick Meyer wrote:
> > Hi Kern,>
> > Do you have any idea on the release date for Bacula 1.37?
>
> 1.37 is already available.
> 1.37 is the development version. You get it via cvs from sourceforge.
>
> That said, your question might fit better into the developers list.
>
> 1.38 might be available sometime this summer (on the northern hemisphere).
>
> Kern did not, to my knowledge, give any fixed date, and I guess he knows
> why.

I'm doing this for the pleasure and have no "boss" so why put myself under 
pressure and possibly release a poor product by specifying a fixed date?

-- 
Best regards,

Kern


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


RE: [Bacula-users] Road Map for Next Release

2005-03-24 Thread Rick Meyer

> -Original Message-
> From: Kern Sibbald [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 24, 2005 5:34 AM
> To: bacula-users@lists.sourceforge.net
> Cc: Arno Lehmann; [EMAIL PROTECTED]
> Subject: Re: [Bacula-users] Road Map for Next Release
> 
> On Thursday 24 March 2005 00:13, Arno Lehmann wrote:
> > Rick,
> >
> > Rick Meyer wrote:
> > > Hi Kern,>
> > > Do you have any idea on the release date for Bacula 1.37?
> >
> > 1.37 is already available.
> > 1.37 is the development version. You get it via cvs from sourceforge.
> >
> > That said, your question might fit better into the developers list.
> >
> > 1.38 might be available sometime this summer (on the northern
> hemisphere).
> >
> > Kern did not, to my knowledge, give any fixed date, and I guess he knows
> > why.
> 
> I'm doing this for the pleasure and have no "boss" so why put myself under
> pressure and possibly release a poor product by specifying a fixed date?

:)
 
Rick

> --
> Best regards,
> 
> Kern






---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Road Map for Next Release

2005-03-24 Thread Ludovic Strappazon
Kern Sibbald wrote:
On Thursday 24 March 2005 00:13, Arno Lehmann wrote:
 

Rick,
Rick Meyer wrote:
   

Hi Kern,>
Do you have any idea on the release date for Bacula 1.37?
 

1.37 is already available.
1.37 is the development version. You get it via cvs from sourceforge.
That said, your question might fit better into the developers list.
1.38 might be available sometime this summer (on the northern hemisphere).
Kern did not, to my knowledge, give any fixed date, and I guess he knows
why.
   

I'm doing this for the pleasure and have no "boss" so why put myself under 
pressure and possibly release a poor product by specifying a fixed date?

 

And it's why we like it !
Ludovic Strappazon.
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Road Map for Next Release

2005-03-24 Thread Michael 'buk' Scherer
Kern Sibbald wrote:
I'm doing this for the pleasure and have no "boss" so why put myself 
under pressure and possibly release a poor product by specifying a 
fixed date?
You don't have a boss, yes.
You have something more evil, users. :)
Greetings,
 Michael
--
 I am root. If you see me laughing, you better have a backup.

---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


AW: [Bacula-users] Road Map for Next Release

2005-03-24 Thread Masopust Christian
Title: AW: [Bacula-users] Road Map for Next Release







Kern Sibbald wrote:
> I'm doing this for the pleasure and have no "boss" so why put myself 
> under pressure and possibly release a poor product by specifying a 
> fixed date?
You don't have a boss, yes.
You have something more evil, users. :)


Greetings,
  Michael




i totally agree both of you ;-))   yes kern, you're right. take all
the time you'll need to make it stable and as good as the previous 
versions were !


and for michael  yes the most evil thing to someone can happen
is that your programs are used ;-))


chris





[Bacula-users] Website Feature Request

2005-03-24 Thread Rick Meyer
I wasn't sure where to ask this, so I'm posting it here.

The Bacula mailing list are great and very active.  Some of the posts are
also fairly large - especially the replies.  I would like to bounce the idea
of adding a discussion system to the current website something like phpBB (
http://www.phpbb.com/index.php )

It would be an easy setup and make it easier for those of us that don't have
access to our mail at all times.

Just an idea.

Rick





---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Website Feature Request

2005-03-24 Thread marius popa
Rick Meyer wrote:
I wasn't sure where to ask this, so I'm posting it here.
The Bacula mailing list are great and very active.  Some of the posts are
also fairly large - especially the replies.  I would like to bounce the idea
of adding a discussion system to the current website something like phpBB (
http://www.phpbb.com/index.php )
Good idea , don't know if is worth it (someone have to keep it secure)
It would be an easy setup and make it easier for those of us that don't have
access to our mail at all times.
There is one blog interface for bacula users
http://blog.gmane.org/gmane.comp.bacula.user
--
Regards,
Marius - flamerobin.org
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


RE: [Bacula-users] Website Feature Request

2005-03-24 Thread Rick Meyer
Thanks!

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:bacula-users-
> [EMAIL PROTECTED] On Behalf Of marius popa
> Sent: Thursday, March 24, 2005 6:50 AM
> To: bacula-devel
> Subject: Re: [Bacula-users] Website Feature Request
> 
> Rick Meyer wrote:
> > I wasn't sure where to ask this, so I'm posting it here.
> >
> > The Bacula mailing list are great and very active.  Some of the posts
> are
> > also fairly large - especially the replies.  I would like to bounce the
> idea
> > of adding a discussion system to the current website something like
> phpBB (
> > http://www.phpbb.com/index.php )
> Good idea , don't know if is worth it (someone have to keep it secure)
> >
> > It would be an easy setup and make it easier for those of us that don't
> have
> > access to our mail at all times.
> 
> There is one blog interface for bacula users
> http://blog.gmane.org/gmane.comp.bacula.user
> 
> 
> --
> Regards,
> 
> Marius - flamerobin.org
> 
> 
> ---
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.
> Register
> by 3/29 & save $300
> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users






---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Website Feature Request

2005-03-24 Thread Michael 'buk' Scherer
Hi.
marius popa wrote:
Rick Meyer wrote:
I wasn't sure where to ask this, so I'm posting it here.
Good. :)
The Bacula mailing list are great and very active.  Some of the posts are
also fairly large - especially the replies.  I would like to bounce 
the idea
of adding a discussion system to the current website something like 
phpBB (
http://www.phpbb.com/index.php )
Good idea , don't know if is worth it (someone have to keep it secure)
Not so good idea I think.
The maillists are Baculas way-of-support. They are very active and people 
response quite fast. I don't think you will and can achive that with some 
webbased-forum or board.
For myself I can say that I won't monitor a forum/board on a regular basis.

It would be an easy setup and make it easier for those of us that 
don't have access to our mail at all times.
Having access to mail isn't that much of a problem if you have access to
the internet at all.
There are plenty of mailproviders with a webmail-interface.
If you need a gmail-invitation let me know. ;^)
There is one blog interface for bacula users
http://blog.gmane.org/gmane.comp.bacula.user
What a perfect way to capture email-addresses for spam. Yugh.
Anyway, besides the webmail-interfaces thats a good way to read/write to the 
maillist.

From my point of view we don't need a board/forum atm, maybe the 'boss' thinks
different?
Greetings,
 Michael
--
 I am root. If you see me laughing, you better have a backup.

---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Road Map for Next Release

2005-03-24 Thread Kern Sibbald
On Thursday 24 March 2005 10:50, Michael 'buk' Scherer wrote:
> Kern Sibbald wrote:
> > I'm doing this for the pleasure and have no "boss" so why put myself
> > under pressure and possibly release a poor product by specifying a
> > fixed date?
>
> You don't have a boss, yes.
> You have something more evil, users. :)

Oh no :-), the Bacula users are really a super group.  In 5 years (well, 3 
public if I remember right), I have only been flamed twice.  Who could 
complain about such a nice record (really!). 

-- 
Best regards,

Kern


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Website Feature Request

2005-03-24 Thread Kern Sibbald
On Thursday 24 March 2005 12:28, Michael 'buk' Scherer wrote:
> Hi.
>
> marius popa wrote:
> > Rick Meyer wrote:
> >> I wasn't sure where to ask this, so I'm posting it here.
>
> Good. :)
>
> >> The Bacula mailing list are great and very active.  Some of the posts
> >> are also fairly large - especially the replies.  I would like to bounce
> >> the idea
> >> of adding a discussion system to the current website something like
> >> phpBB (
> >> http://www.phpbb.com/index.php )
> >
> > Good idea , don't know if is worth it (someone have to keep it secure)
>
> Not so good idea I think.
> The maillists are Baculas way-of-support. They are very active and people
> response quite fast. I don't think you will and can achive that with some
> webbased-forum or board.
> For myself I can say that I won't monitor a forum/board on a regular basis.
>
> >> It would be an easy setup and make it easier for those of us that
> >> don't have access to our mail at all times.
>
> Having access to mail isn't that much of a problem if you have access to
> the internet at all.
> There are plenty of mailproviders with a webmail-interface.
>
> If you need a gmail-invitation let me know. ;^)
>
> > There is one blog interface for bacula users
> > http://blog.gmane.org/gmane.comp.bacula.user
>
> What a perfect way to capture email-addresses for spam. Yugh.
> Anyway, besides the webmail-interfaces thats a good way to read/write to
> the maillist.
>
>  From my point of view we don't need a board/forum atm, maybe the 'boss'
> thinks different?

Gee. Have I become the "boss" :-)  Oh well, but I really prefer to be the 
arbitrator of last resort.

I can see how a web-based forum could be very useful -- perhaps blog.gmane 
already responds to that request at least in part.  However,
my personal preference is email, and it is all I can handle at the current 
time. Email is a bit of a problem when I go on vacation, but I am working on 
that.

Like you (Michael), I really couldn't affort to "monitor" a forum, and for me 
that would be a real pity. I am responding to fewer and fewer emails because 
there are now very capable people who can respond, and if I try to just give 
a quick answer I often another question to my response (groan).  

However, I do read all the emails and often cull out problems and suggestions 
and add them to the todo list even if I do not respond to a particular item. 
Also, more frequently than I would like, someone emails a simple question, 
and I realize that there is a bug lurking behind it.  With a forum, I would 
miss all these things.

-- 
Best regards,

Kern


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: AW: [Bacula-users] sql_create.c:663 More than one Filename! Warni ngs

2005-03-24 Thread Alan Brown
On Tue, 22 Mar 2005, Jeff McCune wrote:
Index creation took 20 minutes, and dbcheck -f ran for 27 hours before I 
killed it and wiped the entire machine to upgrade to RHEL4.
Soething's wrong with your setup then.
Currently, a Full backup of my /home volume is 480GB in just over 4 million 
files.  That's just /home.  In addition, I have 15 other servers doing 
special things and about 40 workstations to backup.  I'll estimate a full 
backup of our site at 2500 to 3000 GB of data in 10 *million* files.
I'm currently backing up about 10TB across 2 servers with around 8 
million files, plus another 16 machines with relatively trivial amounts 
(less than 500Gb and 2 million files). Dbcheck takes about 15-20 minutes, 
even with ~90 million record in there.

Have you tried a MySQL check database command?
The bacula/MySQL server has 2GB ram and dual 2GHz xeons but for the most 
part would be happy on 1Gb. i have made it hit swap _once_

I do recommend you increase your /etc/my.cnf deafults though. DBcheck is 
_painfully_ slow if you don't allowcate enough memory for sort buffers, 
and may die altogether (whcih is what clued me to increasing it)

The usual distributed default my.cnf limits are for a 128Mb multipurpose 
machine. I multiplied everything by 50 for the server here - it's not 
really an issue for us to have MySQL instances growing to 600Mb RSS as the 
box is Bacula and NFS serving only.

AB


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Speed up backup of small files

2005-03-24 Thread Michael 'buk' Scherer
Good day.
Me happy. :)
Arno Lehmann wrote:
No need to try - just use it ;-)
Spooling creates one big file which is written to tape in big chunks.
The last backup this morning put ~1.5 millions files with a speed of 500kb/s 
onto the tape, urgh.
I activated spooling and rerun the job now.
Spooling into that mentioned file runs with ~5MB/s at the moment.
I guess the backup of that big file onto tape wont be any slower than the 
usual 10MB/s.

Conclusion: Spool tiny files :)
Btw. whats the syntax for the "Maximum Spool Size" setting?
I used "= 40G" to set it to 40gb, thats ok?
Cheers,
 Michael
--
 I am root. If you see me laughing, you better have a backup.

---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Road Map for Next Release

2005-03-24 Thread Arno Lehmann
Kern Sibbald wrote:
On Thursday 24 March 2005 00:13, Arno Lehmann wrote:
...
1.38 might be available sometime this summer (on the northern hemisphere).
Kern did not, to my knowledge, give any fixed date, and I guess he knows
why.

I'm doing this for the pleasure and have no "boss" so why put myself under 
pressure and possibly release a poor product by specifying a fixed date?
I just wanted to point out that I did not want to critcize your 
schedule... or lack of one ;-)

Arno
--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Road Map for Next Release

2005-03-24 Thread Kern Sibbald
On Thursday 24 March 2005 14:42, Arno Lehmann wrote:
> Kern Sibbald wrote:
> > On Thursday 24 March 2005 00:13, Arno Lehmann wrote:
>
> ...
>
> >>1.38 might be available sometime this summer (on the northern
> >> hemisphere).
> >>
> >>Kern did not, to my knowledge, give any fixed date, and I guess he knows
> >>why.
> >
> > I'm doing this for the pleasure and have no "boss" so why put myself
> > under pressure and possibly release a poor product by specifying a fixed
> > date?
>
> I just wanted to point out that I did not want to critcize your
> schedule... or lack of one ;-)

I was just being cute and didn't in the slightest feel criticized :-)

In any case, it was a good question.

-- 
Best regards,

Kern


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] bacula

2005-03-24 Thread Dwayne Hottinger
I got bacula up and running and performed a good backup and restore of a mac
server.  Thanks for all the help and such an excellent product.  Of course I
have another question.  When I start adding additional clients to backup, where
and how do add the filesets that need to be backed up?  For example, now File =
/Volumes/Data1
File = /Volumes/Data2
File = /Volumes/Data2
File = /Volumes/Data3

which works great for the server that I have set up.  I want to add 6 more jobs
to the list, thus six more clients and 6 more filesets.  How do I specify the
files for each client?

thanks,

ddh

--
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Speed up backup of small files

2005-03-24 Thread Arno Lehmann
Michael 'buk' Scherer wrote:
Good day.
Me happy. :)
Me too. Go out. Look sun. :-)
Arno Lehmann wrote:
No need to try - just use it ;-)
Spooling creates one big file which is written to tape in big chunks.

The last backup this morning put ~1.5 millions files with a speed of 
500kb/s onto the tape, urgh.
I activated spooling and rerun the job now.
Spooling into that mentioned file runs with ~5MB/s at the moment.
I guess the backup of that big file onto tape wont be any slower than 
the usual 10MB/s.

Conclusion: Spool tiny files :)
Btw. whats the syntax for the "Maximum Spool Size" setting?
I used "= 40G" to set it to 40gb, thats ok?
That's the way I do it.
I never tried to find out what happens if you set a spool size bigger 
than the space available (which _might_ happen with multiple jobs to 
different devices) or no spool size at all... I'm having enought trouble 
with my bacula playground already :-)

Arno
Cheers,
 Michael

--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Road Map for Next Release

2005-03-24 Thread Arno Lehmann
Kern Sibbald wrote:
On Thursday 24 March 2005 14:42, Arno Lehmann wrote:
Kern Sibbald wrote:
On Thursday 24 March 2005 00:13, Arno Lehmann wrote:
...

1.38 might be available sometime this summer (on the northern
hemisphere).
Kern did not, to my knowledge, give any fixed date, and I guess he knows
why.
I'm doing this for the pleasure and have no "boss" so why put myself
under pressure and possibly release a poor product by specifying a fixed
date?
I just wanted to point out that I did not want to critcize your
schedule... or lack of one ;-)

I was just being cute and didn't in the slightest feel criticized :-)
In any case, it was a good question.
Sure, that's why I answerded it...
Arno
--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula

2005-03-24 Thread Arno Lehmann
Hello.
Dwayne Hottinger wrote:
I got bacula up and running and performed a good backup and restore of a mac
server.  Thanks for all the help and such an excellent product.  Of course I
have another question.  When I start adding additional clients to backup, where
and how do add the filesets that need to be backed up?  For example, now File =
/Volumes/Data1
File = /Volumes/Data2
File = /Volumes/Data2
File = /Volumes/Data3
which works great for the server that I have set up.  I want to add 6 more jobs
to the list, thus six more clients and 6 more filesets.  How do I specify the
files for each client?
You create the jobs you need.
Each job refers to one client and one fileset.
The filesets may be the same, of course. (The clients could, too, but 
you probably wouldn't want that ;-)
You define the filesets and the clients in bacula-dir.conf or a file 
included by it.

You can use the xiting setup as a template, of course.
More detailed information can be found in the manual, which is worth 
reading. Indeed, you will need to read some parts of it to get bacula 
working correctly...

Arno
thanks,
ddh
--
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
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 Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Suggestions for solution with backup to disk and cloning to tape?

2005-03-24 Thread Jonte Norman
Hi,

At the place where I work we are planning to change parts of the
backup solution we use today because we have grown out of it...

We are planning to use Bacula to backup about 20 Windows servers to a
large disk storage and then use Legato Networker in a different
installation to clone the disk backups to tape once a month. We have
done a few successful tests with Bacula backing up files to disk.

Everything have worked just fine but we have one question... 

Are there any built in capabilities that allows us to backup
everything to disk and then after a month after the files are moved to
tape automatically delete the disk backups?

If anyone have done something similar with Bacula or have any valuable
suggestions to share regarding how to best setup and configure Bacula
for this task it would be very nice to hear from you.

Best regards,

Jonte Norman


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula

2005-03-24 Thread Dwayne Hottinger
I have been reading through the manual.  I was just wondering if I need to
specifiy for example:
}client applehhs fileset
File = /Volumes/Data2
> > File = /Volumes/Data2
> > File = /Volumes/Data3
Or something similiar to specify what each fileset went to.

thanks,

ddh



Quoting Arno Lehmann <[EMAIL PROTECTED]>:

> Hello.
>
> Dwayne Hottinger wrote:
>
> > I got bacula up and running and performed a good backup and restore of a
> mac
> > server.  Thanks for all the help and such an excellent product.  Of course
> I
> > have another question.  When I start adding additional clients to backup,
> where
> > and how do add the filesets that need to be backed up?  For example, now
> File =
> > /Volumes/Data1
> > File = /Volumes/Data2
> > File = /Volumes/Data2
> > File = /Volumes/Data3
> >
> > which works great for the server that I have set up.  I want to add 6 more
> jobs
> > to the list, thus six more clients and 6 more filesets.  How do I specify
> the
> > files for each client?
>
> You create the jobs you need.
> Each job refers to one client and one fileset.
> The filesets may be the same, of course. (The clients could, too, but
> you probably wouldn't want that ;-)
> You define the filesets and the clients in bacula-dir.conf or a file
> included by it.
>
> You can use the xiting setup as a template, of course.
>
> More detailed information can be found in the manual, which is worth
> reading. Indeed, you will need to read some parts of it to get bacula
> working correctly...
>
> Arno
>
> > thanks,
> >
> > ddh
> >
> > --
> > Dwayne Hottinger
> > Network Administrator
> > Harrisonburg City Public Schools
> >
> >
> > ---
> > This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
> > Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> > Embedded(r) & Windows Mobile(tm) platforms, applications & content.
> Register
> > by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> > ___
> > 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
>


--
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools


---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] error message in RunBefore

2005-03-24 Thread Carlos Molina M.
Hi all,
I have runing bacula 1.32d version with no problem, well... I
re-install the server with fedora core 3 and when I try to run some
jobs, send me the next message...

AZOG: RunBefore: /usr/bin/mysqldump: Got error: 1044: Access denied for
user: '@localhost' to database 'bacula' when selecting the database
AZOG: VRVS-Backup.2005-03-24_12.01.27 Fatal error: RunBeforeJob returned
non-zero status=2

the file call make_catalog_backup that I call in RunBefore have the
next:
#!/bin/sh
#
# This script dumps your Bacula catalog in ASCII format
#  It works for either MySQL or SQLite
#
mt -f /dev/nst0 rewind
mt -f /dev/nst0 weof

cd /etc/bacula/bin
rm -f bacula.sql
if test xsqlite = xmysql ; then
  echo ".dump" | /usr/bin/sqlite bacula.db >bacula.sql
else
  /usr/bin/mysqldump $* -f --opt bacula >bacula.sql
fi


Can you give me a hand?

Regards..

--

Carlos Molina M.
Ing. en Informática
Red Universitaria Nacional
Teléfono : (56-2)-3370332
E-mail   : [EMAIL PROTECTED]




---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Website Feature Request

2005-03-24 Thread Alexey Toptygin
On Thu, 24 Mar 2005, Rick Meyer wrote:
I would like to bounce the idea of adding a discussion system to the 
current website something like phpBB ( http://www.phpbb.com/index.php )
Even if a bulletin board is a good idea, phpbb is IMO not. grep php 
[EMAIL PROTECTED] or ask any bugtraq reader to find out how many 
serious php bugs come out on a daily basis.

Alexey
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] error message in RunBefore

2005-03-24 Thread David Clymer
On Thu, 2005-03-24 at 12:07 -0400, Carlos Molina M. wrote:
> Hi all,
> I have runing bacula 1.32d version with no problem, well... I
> re-install the server with fedora core 3 and when I try to run some
> jobs, send me the next message...
> 
> AZOG: RunBefore: /usr/bin/mysqldump: Got error: 1044: Access denied for
> user: '@localhost' to database 'bacula' when selecting the database
> AZOG: VRVS-Backup.2005-03-24_12.01.27 Fatal error: RunBeforeJob returned
> non-zero status=2
> 

mysqldump is trying to connect to your database server using no username
or password. Because of this, mysql is not letting you connect.

> the file call make_catalog_backup that I call in RunBefore have the
> next:
> #!/bin/sh
> #
> # This script dumps your Bacula catalog in ASCII format
> #  It works for either MySQL or SQLite
> #
> mt -f /dev/nst0 rewind
> mt -f /dev/nst0 weof
> 
> cd /etc/bacula/bin
> rm -f bacula.sql
> if test xsqlite = xmysql ; then
>   echo ".dump" | /usr/bin/sqlite bacula.db >bacula.sql
> else
>   /usr/bin/mysqldump $* -f --opt bacula >bacula.sql
> fi
> 

the symbol $*  after /usr/bin/mysqldump means that it is passing any
arguments that you give to the wrapping script (make_catalog_backup)
directly on to mysqldump.

mysqldump --help

that will show you a whole list of arguments and switches that you can
use with mysqldump. The ones you probably want to use are:

--user  (the user that mysqldump should use to connect to
mysql)
--password  (the password for user that you specified)

so, in your RunBeforeJob directive, do something like this:  

RunBeforeJob = "/etc/bacula/scripts/make_catalog_backup --user bacula
--password=yourfavoritepassword"


Hope that helps,

-davidc

--
The illiterate of the 21st century will not be those who cannot read and
write, but those who cannot learn, unlearn, and relearn. -Alvin Toffler



---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula

2005-03-24 Thread Arno Lehmann
Hi
Dwayne Hottinger wrote:
I have been reading through the manual.  I was just wondering if I need to
specifiy for example:
}client applehhs fileset
File = /Volumes/Data2
File = /Volumes/Data2
File = /Volumes/Data3
Or something similiar to specify what each fileset went to.

Sorry, but I can't follow you here... I just don't understand your problem.
The example you give above doesn't sound like anything from a bacula 
configuration file.

I'd expect something like
Job {
Name="G5-A"
Client="G5-A-fd"
FileSet="OSX-standard"
}
FileSet {
Name="OSX-standard"
Include {
File = /
File = /Volumes/Data2
}
}
Client {
Name="G5-A-fd"
Address="G5-A.mynetwork.de"
}
Arno
thanks,
ddh

Quoting Arno Lehmann <[EMAIL PROTECTED]>:

Hello.
Dwayne Hottinger wrote:

I got bacula up and running and performed a good backup and restore of a
mac
server.  Thanks for all the help and such an excellent product.  Of course
I
have another question.  When I start adding additional clients to backup,
where
and how do add the filesets that need to be backed up?  For example, now
File =
/Volumes/Data1
File = /Volumes/Data2
File = /Volumes/Data2
File = /Volumes/Data3
which works great for the server that I have set up.  I want to add 6 more
jobs
to the list, thus six more clients and 6 more filesets.  How do I specify
the
files for each client?
You create the jobs you need.
Each job refers to one client and one fileset.
The filesets may be the same, of course. (The clients could, too, but
you probably wouldn't want that ;-)
You define the filesets and the clients in bacula-dir.conf or a file
included by it.
You can use the xiting setup as a template, of course.
More detailed information can be found in the manual, which is worth
reading. Indeed, you will need to read some parts of it to get bacula
working correctly...
Arno

thanks,
ddh
--
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.
Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
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

--
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools
--
IT-Service Lehmann[EMAIL PROTECTED]
Arno Lehmann  http://www.its-lehmann.de
---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] error message in RunBefore

2005-03-24 Thread Carlos Molina M.
Thank's...
I change the user, and give him the access to the database and now
work...

Thank's a lot...

Regards...

David Clymer ha escrito:

> On Thu, 2005-03-24 at 12:07 -0400, Carlos Molina M. wrote:
> > Hi all,
> > I have runing bacula 1.32d version with no problem, well... I
> > re-install the server with fedora core 3 and when I try to run some
> > jobs, send me the next message...
> >
> > AZOG: RunBefore: /usr/bin/mysqldump: Got error: 1044: Access denied for
> > user: '@localhost' to database 'bacula' when selecting the database
> > AZOG: VRVS-Backup.2005-03-24_12.01.27 Fatal error: RunBeforeJob returned
> > non-zero status=2
> >
>
> mysqldump is trying to connect to your database server using no username
> or password. Because of this, mysql is not letting you connect.
>
> > the file call make_catalog_backup that I call in RunBefore have the
> > next:
> > #!/bin/sh
> > #
> > # This script dumps your Bacula catalog in ASCII format
> > #  It works for either MySQL or SQLite
> > #
> > mt -f /dev/nst0 rewind
> > mt -f /dev/nst0 weof
> >
> > cd /etc/bacula/bin
> > rm -f bacula.sql
> > if test xsqlite = xmysql ; then
> >   echo ".dump" | /usr/bin/sqlite bacula.db >bacula.sql
> > else
> >   /usr/bin/mysqldump $* -f --opt bacula >bacula.sql
> > fi
> >
>
> the symbol $*  after /usr/bin/mysqldump means that it is passing any
> arguments that you give to the wrapping script (make_catalog_backup)
> directly on to mysqldump.
>
> mysqldump --help
>
> that will show you a whole list of arguments and switches that you can
> use with mysqldump. The ones you probably want to use are:
>
> --user  (the user that mysqldump should use to connect to
> mysql)
> --password  (the password for user that you specified)
>
> so, in your RunBeforeJob directive, do something like this:
>
> RunBeforeJob = "/etc/bacula/scripts/make_catalog_backup --user bacula
> --password=yourfavoritepassword"
>
> Hope that helps,
>
> -davidc
>
> --
> The illiterate of the 21st century will not be those who cannot read and
> write, but those who cannot learn, unlearn, and relearn. -Alvin Toffler
>
> ---
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
> by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

--

Carlos Molina M.
Ing. en Informática
Red Universitaria Nacional
Teléfono : (56-2)-3370332
E-mail   : [EMAIL PROTECTED]




---
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula

2005-03-24 Thread David Clymer
On Thu, 2005-03-24 at 11:00 -0500, Dwayne Hottinger wrote:
> I have been reading through the manual.  I was just wondering if I need to
> specifiy for example:
> }client applehhs fileset
> File = /Volumes/Data2
> > > File = /Volumes/Data2
> > > File = /Volumes/Data3
> Or something similiar to specify what each fileset went to.

Are you trying to specify which files are to be backed up on each
client, or what volume the files that are backed up from each client get
written to?

-davidc

--
The end of the human race will be that it will eventually die of
civilization. -Ralph Waldo Emerson, writer and philosopher (1803-1882)



---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Speed up backup of small files

2005-03-24 Thread Joshua Kugler
On Thursday 24 March 2005 06:44, Arno Lehmann wrote:
> That's the way I do it.
> I never tried to find out what happens if you set a spool size bigger
> than the space available (which _might_ happen with multiple jobs to
> different devices) or no spool size at all... I'm having enought trouble
> with my bacula playground already :-)

I've never set a maximum spool size.  I have a 67GB partition that I use for 
spool.  When it gets full, Bacula just waits until the file(s) gets written 
tot the tape before continuing.

j- k-

-- 
Joshua Kugler
CDE System Administrator
http://distance.uaf.edu/


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] FreeBSD and onstream configuration

2005-03-24 Thread Noah


Hi there,

can somebody please suggest a configuration for bacula use on a FreeBSD 4.9
machine?  anybody got this running well?  tips for initial setup are welcome.

cheers,

Noah



---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] base level saves?

2005-03-24 Thread Brent.Nesbitt



Hi there, 

 
I am wanting to make 
a "Mondo" image of my firewall, which changes very little, in order to 
facilitate very speedy restores.  In addition to the Mondo image, I would 
like to use Bacula to backup any changes since that image was 
made.
 
Can Bacula currently 
do this?  Is this the idea behind "base level saves"?  What actually 
takes place when I set the backup level for a job to "base"?
 
Brent.
 


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005
 


Re: [Bacula-users] base level saves?

2005-03-24 Thread Tobias Barth




Hi there,

Interesting topic.
I tested this "base level" thing some weeks ago and wrote 4 DLT tapes
full of data, and after this, the next "incremental" backup upgraded
itself to "full" because it "couldn't find a former full backup".
What did I get wrong?

Greetings,

Tobias Barth
Web Arts AG
Max-Planck-Str. 9
61381 Friedrichsdorf
---
Tel.: +49.6172.599833
Fax : +49.6172.599830
[EMAIL PROTECTED]
www.web-arts.com
---
Content Management für den Mittelstand:
http://cira.web-arts.de
 




[EMAIL PROTECTED] schrieb:

  
  
  Hi
there, 
   
  I
am wanting to make a "Mondo" image of my firewall, which changes very
little, in order to facilitate very speedy restores.  In addition to
the Mondo image, I would like to use Bacula to backup any changes since
that image was made.
   
  Can
Bacula currently do this?  Is this the idea behind "base level saves"? 
What actually takes place when I set the backup level for a job to
"base"?
   
  Brent.
   
  
  --
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005
   





Re: [Bacula-users] HP Ultrium 460 1/8 Autochanger

2005-03-24 Thread Erik Pinzon




I don't know if this answers your question (or if you even have the question still, your post is quite old), but here it goes.

Make sure you have the sg3-utils package.

run sginfo -l
this will list your SCSI devices   I get something like this on my Bacula server:

infra2:~# sginfo -l
/dev/sda
/dev/sg0 [=/dev/sda  scsi0 ch=0 id=0 lun=0]
/dev/sg1 [scsi0 ch=0 id=8 lun=0]
/dev/sg2 [scsi1 ch=0 id=0 lun=0]
/dev/sg3 [scsi1 ch=0 id=5 lun=0]

Then you can run sginfo for each device that is obviously not an HD. In my case, sginfo /dev/sg2 gives me this (HP Ultrium):

infra2:~# sginfo /dev/sg2
INQUIRY reponse (cmd: 0x12)
---
Device Type    8
Vendor:    HP
Product:   ThinStor AutoLdr
Revision level:    H43r

Now that I know that this is my autoloader (not the drive, the actual robot. The tape drive is /dev/nst0 in my case), make sure you (bacula-sd) have access to the robot.

# chmod 660 /dev/sg2 (give rw permissions to the group)
# chgrp tape /dev/sg2 (Debian's bacula user is part of the tape group, by default, the sg[x] devices are owned by root.root)

Lastly, make sure you also have the mtx package to handle your autoloader. There is a lot of info on their (mtx) website.

as long as the mtx tools are able to drive the robot, bacula should not have a problem with it.

Hope it helps,
Erik.

On Thu, 2005-03-10 at 18:47 -0800, June Snedecor wrote:


Hello Everyone!
I know this is a bit of a long shot, but has anyone had any success with 
this particular model of autochanger with Bacula?
*http://tinyurl.com/5ktun*

The mtx site (http://mtx.badtux.net/compatibility.php) says that mtx 
works with this autochanger, even though they were using an older 
ultrium tape drive. It seems like Bacula's scripts for autochangers 
should work, I just wanted to check to see if anyone had managed to get 
it working before. We currently have Bacula working fine with an Ultrium 
215 drive, but I'm very tired of being the tape changing monkey. The HP 
tape libraries that have been proven to work with Bacula are a little 
too big for our needs, and we're running out of space in our server 
cabinet for something that size.

We're using Debian Sarge with Bacula version 1.36.1.
June


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users






[Bacula-users] bacula with onstream configuration for FreeBSD

2005-03-24 Thread Noah


Hi there,

can somebody please suggest a configuration for bacula use on a FreeBSD 4.9
machine?  anybody got this running well?  tips for initial onstream setup are
welcome.

cheers,

Noah



---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Build from source errors

2005-03-24 Thread Tom Plancon
Hi all,
I'm attempting to build 1.36.2 on RH9 from source. Very green at this so 
bear with me. Here is my configure script:

#!/bin/sh
# Tom's config script on Emperor
CFLAGS="-g -Wall" ./configure \
   --prefix=/usr \
   --sbindir=/usr/sbin \
   --sysconfdir=/etc/bacula \
   --with-scriptdir=/etc/bacula \
   --enable-smartalloc \
   --enable-gnome \
   --with-postgresql \
   --with-working-dir=/var/bacula \
   --with-pid-dir=/var/run \
   --with-subsys-dir=/var/lock/subsys \
   --enable-conio
Above was modified from the sample "traditional RedHat Linux install" 
script in the manual.

Everything seemed OK until "make install" when I got the following 
errors, culled from the whole log:

make[1]: *** No rule to make target `../findlib/libfind.a', needed by 
`bacula-fd'.  Stop.

make[1]: *** No rule to make target `../lib/libbac.a', needed by 
`bconsole'.  Stop.
make[1]: Leaving directory `/bacula-1.36.2/src/console'

make[1]: *** No rule to make target `../lib/libbac.a', needed by 
`bacula-dir'.
Stop.

make[1]: *** No rule to make target `../lib/libbac.a', needed by 
`bacula-sd'.  Stop.
...
make[1]: Entering directory `/bacula-1.36.2/src/tools'
g++   -c  -I. -I..  -g -Wall  bsmtp.c
make[1]: *** No rule to make target `../lib/libbac.a', needed by 
`bsmtp'.  Stop.make[1]: Leaving directory `/bacula-1.36.2/src/tools'
make: *** [install] Error 1

Any suggestions are appreciated! Thanks.
--
Tom Plancon
CAD/IS Manager
BKA Architects, Inc.
142 Crescent St.
Brockton, MA 02302
508-583-5603
[EMAIL PROTECTED]
---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] bacula-1.36.2-1.src.rpm & RHEL4

2005-03-24 Thread Jeff McCune
I'm trying to compile bacula binary RPMS for RedHat Enterprise Linux 4, 
which looks a lot like Fedora Core 3, so I'm using that platform as my 
target.

  [EMAIL PROTECTED] rhel-as-x86-4]# rpmbuild --target i686 \
 --define 'build_fc3 1' \
 --define 'build_mysql 1' \
 --rebuild bacula-1.36.2-1.src.rpm
  Installing bacula-1.36.2-1.src.rpm
  Building target platforms: i686
  Building for target i686
  error: line 96: Empty tag: Distribution:
The problematic spec file section looks like:
  # check what distribution we are
  %if %{rh7} || %{rh8} || %{rh9}
  %define _dist %(grep Red /etc/redhat-release)
  %endif
  %if %{fc1} || %{fc3}
  %define _dist %(grep Fedora /etc/redhat-release)
  %endif
  %if %{wb3}
  %define _dist %(grep White /etc/whitebox-release)
  %endif
  %if %{su9}
  %define _dist %(grep SuSE /etc/SuSE-release)
  %endif
  %if %{mdk}
  %define _dist %(grep Mandrake /etc/mandrake-release)
  %endif
On a RHEL box, there's no "Fedora" string in /etc/redhat-release so 
_dist is undefined.  I fixed this by changing the check for fc3 to the 
following:

  %if %{fc1} || %{fc3}
  %define _dist %(cat /etc/redhat-release)
Now, when I try and build, I get:
  [EMAIL PROTECTED] SPECS]# rpmbuild --target i386 \
--define 'build_fc3 1' \
--define 'build_mysql 1' bacula.spec
  Building target platforms: i386
  Building for target i386
  [EMAIL PROTECTED] SPECS]#
rpmbuild simply drops back to a shell silently...
Has anyone had luck compiling bacula for RHEL4?  Suggestions?
Regards,
--
Jeff McCune
OSU Department of Mathematics System Support
(614) 292-4962
gpg --keyserver pgp.mit.edu --recv-key BAF3211A


signature.asc
Description: OpenPGP digital signature


Re: [Bacula-users] bacula-1.36.2-1.src.rpm & RHEL4

2005-03-24 Thread Jeff McCune
Jeff McCune wrote:
  [EMAIL PROTECTED] SPECS]# rpmbuild --target i386 \
--define 'build_fc3 1' \
--define 'build_mysql 1' bacula.spec
  Building target platforms: i386
  Building for target i386
  [EMAIL PROTECTED] SPECS]#
rpmbuild simply drops back to a shell silently...
As it should...  I forgot to tell it to do anything.
rpmbuild -ba with the options above produces the binary RPM's on RHEL4.
On a related note, is there a need for RHEL4 support in the spec file, 
or is it not a supported platform yet.

I'm walking on the edge in that I'll be running bacula using MySQL 4.1 
in the hopes that I can work through any incompatibilities myself and 
contribute my efforts back upstream.

Regards,
--
Jeff McCune
OSU Department of Mathematics System Support
(614) 292-4962
gpg --keyserver pgp.mit.edu --recv-key BAF3211A


signature.asc
Description: OpenPGP digital signature


[Bacula-users] Thanks

2005-03-24 Thread Dwayne Hottinger
I got a good backup and restore from an OS 10 server.  However when I added the
next server files and restarted bacula I got kaboom.  I took those server files
out and it started fine.  Is there a limit on the size or number of lines in
the director.conf file, and if so, how do I get around it.  I read where you
could reference file lists, but havent been able to find an example of it. 
Thanks again for such a fine piece of software.

ddh


--
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Build from source errors

2005-03-24 Thread Kern Sibbald
On Thursday 24 March 2005 21:45, Tom Plancon wrote:
> Hi all,
>
> I'm attempting to build 1.36.2 on RH9 from source. Very green at this so
> bear with me. Here is my configure script:
>
> #!/bin/sh
> # Tom's config script on Emperor
> CFLAGS="-g -Wall" ./configure \
> --prefix=/usr \
> --sbindir=/usr/sbin \
> --sysconfdir=/etc/bacula \
> --with-scriptdir=/etc/bacula \
> --enable-smartalloc \
> --enable-gnome \
> --with-postgresql \
> --with-working-dir=/var/bacula \
> --with-pid-dir=/var/run \
> --with-subsys-dir=/var/lock/subsys \
> --enable-conio
>
> Above was modified from the sample "traditional RedHat Linux install"
> script in the manual.

> Everything seemed OK until "make install" when I got the following
> errors, culled from the whole log:

Well, you skipped over the "make" step.

>
> make[1]: *** No rule to make target `../findlib/libfind.a', needed by
> `bacula-fd'.  Stop.
> 
> make[1]: *** No rule to make target `../lib/libbac.a', needed by
> `bconsole'.  Stop.
> make[1]: Leaving directory `/bacula-1.36.2/src/console'
> 
> make[1]: *** No rule to make target `../lib/libbac.a', needed by
> `bacula-dir'.
> Stop.
> 
> make[1]: *** No rule to make target `../lib/libbac.a', needed by
> `bacula-sd'.  Stop.
> ...
> make[1]: Entering directory `/bacula-1.36.2/src/tools'
> g++   -c  -I. -I..  -g -Wall  bsmtp.c
> make[1]: *** No rule to make target `../lib/libbac.a', needed by
> `bsmtp'.  Stop.make[1]: Leaving directory `/bacula-1.36.2/src/tools'
> make: *** [install] Error 1
>
> Any suggestions are appreciated! Thanks.

-- 
Best regards,

Kern


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Build from source errors

2005-03-24 Thread Tobias Barth




"make install" always does a "make" when the things that should be
installed are not there. This is why the compiler errors occur. On my
SuSE system I also encountered this problem and I installed the
"ncurses-devel" and "termcap" packets and then bacula was compiled
without errors.

Greetings,

Tobias Barth
Web Arts AG
Max-Planck-Str. 9
61381 Friedrichsdorf
---
Tel.: +49.6172.599833
Fax : +49.6172.599830
[EMAIL PROTECTED]
www.web-arts.com
---
Content Management für den Mittelstand:
http://cira.web-arts.de
 




Kern Sibbald schrieb:

  On Thursday 24 March 2005 21:45, Tom Plancon wrote:
  
  
Hi all,

I'm attempting to build 1.36.2 on RH9 from source. Very green at this so
bear with me. Here is my configure script:

#!/bin/sh
# Tom's config script on Emperor
CFLAGS="-g -Wall" ./configure \
--prefix=/usr \
--sbindir=/usr/sbin \
--sysconfdir=/etc/bacula \
--with-scriptdir=/etc/bacula \
--enable-smartalloc \
--enable-gnome \
--with-postgresql \
--with-working-dir=/var/bacula \
--with-pid-dir=/var/run \
--with-subsys-dir=/var/lock/subsys \
--enable-conio

Above was modified from the sample "traditional RedHat Linux install"
script in the manual.

  
  
  
  
Everything seemed OK until "make install" when I got the following
errors, culled from the whole log:

  
  
Well, you skipped over the "make" step.

  
  
make[1]: *** No rule to make target `../findlib/libfind.a', needed by
`bacula-fd'.  Stop.

make[1]: *** No rule to make target `../lib/libbac.a', needed by
`bconsole'.  Stop.
make[1]: Leaving directory `/bacula-1.36.2/src/console'

make[1]: *** No rule to make target `../lib/libbac.a', needed by
`bacula-dir'.
Stop.

make[1]: *** No rule to make target `../lib/libbac.a', needed by
`bacula-sd'.  Stop.
...
make[1]: Entering directory `/bacula-1.36.2/src/tools'
g++   -c  -I. -I..  -g -Wall  bsmtp.c
make[1]: *** No rule to make target `../lib/libbac.a', needed by
`bsmtp'.  Stop.make[1]: Leaving directory `/bacula-1.36.2/src/tools'
make: *** [install] Error 1

Any suggestions are appreciated! Thanks.

  
  
  





Re: [Bacula-users] bacula-1.36.2-1.src.rpm & RHEL4

2005-03-24 Thread D. Scott Barninger
Hello,

To build for RHEL4 and MySQL-4 do:

rpmbuild --rebuild \
--define "build_rhel3 1" \
--define "build_mysql 1" \
--define "build_mysql4 1" \
bacula-1.36.2-1.src.rpm

Let me know if this works for you.

On Fri, 2005-03-25 at 00:22 +0100, Kern Sibbald wrote:
> On Thursday 24 March 2005 22:40, Jeff McCune wrote:
> > I'm trying to compile bacula binary RPMS for RedHat Enterprise Linux 4,
> > which looks a lot like Fedora Core 3, so I'm using that platform as my
> > target.
> >
> >[EMAIL PROTECTED] rhel-as-x86-4]# rpmbuild --target i686 \
> >   --define 'build_fc3 1' \
> >   --define 'build_mysql 1' \
> >   --rebuild bacula-1.36.2-1.src.rpm
> >Installing bacula-1.36.2-1.src.rpm
> >Building target platforms: i686
> >Building for target i686
> >error: line 96: Empty tag: Distribution:
> >
> > The problematic spec file section looks like:
> >
> ># check what distribution we are
> >%if %{rh7} || %{rh8} || %{rh9}
> >%define _dist %(grep Red /etc/redhat-release)
> >%endif
> >%if %{fc1} || %{fc3}
> >%define _dist %(grep Fedora /etc/redhat-release)
> >%endif
> >%if %{wb3}
> >%define _dist %(grep White /etc/whitebox-release)
> >%endif
> >%if %{su9}
> >%define _dist %(grep SuSE /etc/SuSE-release)
> >%endif
> >%if %{mdk}
> >%define _dist %(grep Mandrake /etc/mandrake-release)
> >%endif
> >
> > On a RHEL box, there's no "Fedora" string in /etc/redhat-release so
> > _dist is undefined.  I fixed this by changing the check for fc3 to the
> > following:
> >
> >%if %{fc1} || %{fc3}
> >%define _dist %(cat /etc/redhat-release)
> >
> > Now, when I try and build, I get:
> >
> >[EMAIL PROTECTED] SPECS]# rpmbuild --target i386 \
> >  --define 'build_fc3 1' \
> >  --define 'build_mysql 1' bacula.spec
> >Building target platforms: i386
> >Building for target i386
> >[EMAIL PROTECTED] SPECS]#
> >
> > rpmbuild simply drops back to a shell silently...
> >
> > Has anyone had luck compiling bacula for RHEL4?  Suggestions?
> >
> > Regards,
> 



---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Help! "Duplicate entry" dbcheck doesn't fix it?!?

2005-03-24 Thread Jeff McCune
Michael Joyner wrote:
Did you recently upgrade to MySQL 4.0?  The solution I can see is to 
drop the index on Path and the index on Filename, then recreate them 
but create them on the full Path and the full Name rather than 
limiting it as is currently the case in the make_mysql_tables file.
I don't understand how the index on the Filename.Name and Path.Path 
fields change the constraints of records within the tables.  An index by 
itself solely provides a way to speed up queries against those fields. 
An index by itself has no uniqueness properties or constraints on data 
inserted into the table.

A PRIMARY KEY on the other hand, is a constraint on the data in order to 
uniquely identify each record in the table.  A PRIMARY KEY necessarily 
creates on index on the PRIMARY KEY field(s).  That index is in addition 
and unrelated to other defined indexes, though, such as INDEX(Path(50)).

IT IS THE INDEX. :(
Why would MySQL be giving me duplicate errors on a MULTIPLE KEY INDEX?
I ran the following:
use bacula;
alter table File drop index FilenameID;
alter table Path drop index Path;
Error messages gone.
IT ISN'T THE INDEX!
When you ran the statement:
  alter table File drop index FilenameID;
I think you REMOVED THE PRIMARY KEY from the File table.
The PRIMARY KEY(FilenameId) statement in make_mysql_tables was the only 
thing enforcing unique records within that table.  You're not getting 
the error because you've setup MySQL to allow duplicates within the File 
table.

But, you still have the problem!
I've spent a lot of time on this thread because I'm currently deploying 
bacula on RHEL4, which installs MySQL 4.1 by default and it seems like 
more work for me to backport and maintain mysql 3.23.51 than it is to 
work out issues with bacula and MySQL 4.1.  Comments about the keys and 
index scared me.

What you're saying and doing doesn't make any sense...
In your previous email, you posted this:
mysql> insert into Path(PathId,Path) values (47947,'C:/$VAULT$.AVG/');
ERROR 1062: Duplicate entry '47947' for key 1
mysql> insert into Path(PathId,Path) values (47948,'Z:/$VAULT$.AVG/');
ERROR 1062: Duplicate entry '47948' for key 1
mysql> insert into Path(Path) values (' ');
ERROR 1062: Duplicate entry '47946' for key 1
mysql> replace into Path(PathId,Path) values (47947,'C:/$VAULT$.AVG/');
ERROR 1062: Duplicate entry '47947' for key 1
mysql> update Path set Path='BOGUS PATH' where PathID=47947;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0
mysql>
MySQL is telling you that there's a duplicate entry for the PRIMARY KEY 
which uniquely identifies each record in the Path table.  If we look at 
the Path creation SQL in /etc/bacula/make_mysql_tables, we can see what 
the structure is:

CREATE TABLE Path (
  PathId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  Path BLOB NOT NULL,
  PRIMARY KEY(PathId),
  INDEX (Path(50))
  );
Since the PRIMARY KEY is solely on an AUTO_INCREMENT field, I don't see 
how the INDEX on Path has anything to do with anything, and I don't see 
how you could ever have a duplicate entry in that field, unless your 
table is fscked.

The index on Path should have no bearing whatsoever on the PRIMARY KEY, 
and hence the uniqueness of each row.

In fact, the index on the Path and Name fields has no behavioral bearing 
on anything if I understand MySQL correctly...  It only serves to speed 
up queries and doesn't functionally change anything.

I think Kern is right in that your database is fscked.
Kern, could you try and elaborate on this statement...  I'm really 
having trouble understanding what you mean:

It looks to me like MySQL 4.0 has changed the way they deal with indexing and 
keys since version 3.23.51.  It appears as if they are using *only* the index 
to decide if the key is unique or not. The index was setup on the first 50 
characters of the path. Previously, the index was used for indexing only and 
not to determine uniqueness.
I don't understand how INDEX (Path(50)) has any bearing on PRIMARY 
KEY(PathId), as we have 2 discrete indexes on the Path table, one for 
the PathId field which is necessary for the PRIMARY KEY, and another on 
Path...  They're not really related at all, and the index on Path has no 
uniqueness constraints.

Sorry for the length of this email, I just really want to understand 
what's going on with the table structure.  I've been pondering and 
testing these statements for 2 days now on MySQL 4.1, and I can't wrap 
my head around what you guys mean.

Regards,
--
Jeff McCune
OSU Department of Mathematics System Support
(614) 292-4962
gpg --keyserver pgp.mit.edu --recv-key BAF3211A
---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-u

Re: [Bacula-users] Build from source errors

2005-03-24 Thread Jeff McCune
Tobias Barth wrote:
"make install" always does a "make" when the things that should be 
installed are not there.
Depends on the Makefile...  So not always.
Regards,
--
Jeff McCune
OSU Department of Mathematics System Support
(614) 292-4962
gpg --keyserver pgp.mit.edu --recv-key BAF3211A
---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula-1.36.2-1.src.rpm & RHEL4

2005-03-24 Thread Jeff McCune
D. Scott Barninger wrote:
Hello,
To build for RHEL4 and MySQL-4 do:
rpmbuild --rebuild \
--define "build_rhel3 1" \
--define "build_mysql 1" \
--define "build_mysql4 1" \
bacula-1.36.2-1.src.rpm
Let me know if this works for you.
Sure doesn't...  Also please note that RHEL4 is more akin to FC2/FC3 
than it is to RHEL3.

  [EMAIL PROTECTED] rhel-as-x86-4]# rpmbuild --rebuild \
--define "build_rhel3 1" \
--define "build_mysql 1" \
--define "build_mysql4 1" \
bacula-1.36.2-1.src.rpm
  Installing bacula-1.36.2-1.src.rpm
  error:  You must specify a platform. Please examine the spec file.
  error: line 45: Unknown tag: exit 1
Note, there's no build_rhel3 in the spec file...  There's wb3, which 
contrary to the comment "This should work for RHEL3" won't work because 
it specifically greps for "White" in /etc/whitebox-release which will 
never exist on a RHEL box.

On a side note, I'm really confused why there's such a heavy dependency 
on the /etc/*release files.  If you don't have the right files and the 
right words in the files, builds fail completely.

Would you accept a patch to the spec file that populates _dist more 
robustly?

Here's a snippet from the current spec file that shows why build_rhel3 
won't work:

# platform defines - set one below or define the build_xxx on the 
command line
# RedHat builds
%define rh7 0
%{?build_rh7:%define rh7 1}
%define rh8 0
%{?build_rh8:%define rh8 1}
%define rh9 0
%{?build_rh9:%define rh9 1}
# Fedora Core build
%define fc1 0
%{?build_fc1:%define fc1 1}
%define fc3 0
%{?build_fc3:%define fc3 1}
# Whitebox Enterprise build
# this should also work for RHEL
%define wb3 0
%{?build_wb3:%define wb3 1}
# SuSE build
# this is known to build on SuSE 8.2 and 9.0
%define su9 0
%{?build_su9:%define su9 1}
# Mandrake build
%define mdk 0
%{?build_mdk:%define mdk 1}

# test for a platform definition
%if ! %{rh7} && ! %{rh8} && ! %{rh9} && ! %{fc1} && ! %{fc3} && ! %{wb3} 
&& ! %{su9} && ! %{mdk}
%{error: You must specify a platform. Please examine the spec file.}
exit 1
%endif

Regards,
--
Jeff McCune
OSU Department of Mathematics System Support
(614) 292-4962
gpg --keyserver pgp.mit.edu --recv-key BAF3211A


signature.asc
Description: OpenPGP digital signature


Re: [Bacula-users] bacula-1.36.2-1.src.rpm & RHEL4

2005-03-24 Thread D. Scott Barninger
Hello,

Attached is the current spec file that was released with 1.36.2. The
snip you have below is older. I don't have access to RHEL4 so if you can
get it to build my next question would be to tell me the versions
shipped of certain packages. I realize it is probably closer to FC3, but
I think it will build working binaries with the build string I gave you
below. If you can get it to build and supply the version information I
can add an explicit target for RHEL4. If you have other ideas for the
Distribution tag please let me know.

Regards,
Scott

On Thu, 2005-03-24 at 19:19 -0500, Jeff McCune wrote:
> D. Scott Barninger wrote:
> > Hello,
> > 
> > To build for RHEL4 and MySQL-4 do:
> > 
> > rpmbuild --rebuild \
> > --define "build_rhel3 1" \
> > --define "build_mysql 1" \
> > --define "build_mysql4 1" \
> > bacula-1.36.2-1.src.rpm
> > 
> > Let me know if this works for you.
> > 
> 
> Sure doesn't...  Also please note that RHEL4 is more akin to FC2/FC3 
> than it is to RHEL3.
> 
>[EMAIL PROTECTED] rhel-as-x86-4]# rpmbuild --rebuild \
>  --define "build_rhel3 1" \
>  --define "build_mysql 1" \
>  --define "build_mysql4 1" \
>  bacula-1.36.2-1.src.rpm
>Installing bacula-1.36.2-1.src.rpm
>error:  You must specify a platform. Please examine the spec file.
>error: line 45: Unknown tag: exit 1
> 
> Note, there's no build_rhel3 in the spec file...  There's wb3, which 
> contrary to the comment "This should work for RHEL3" won't work because 
> it specifically greps for "White" in /etc/whitebox-release which will 
> never exist on a RHEL box.
> 
> On a side note, I'm really confused why there's such a heavy dependency 
> on the /etc/*release files.  If you don't have the right files and the 
> right words in the files, builds fail completely.
> 
> Would you accept a patch to the spec file that populates _dist more 
> robustly?
> 
> Here's a snippet from the current spec file that shows why build_rhel3 
> won't work:
> 
> # platform defines - set one below or define the build_xxx on the 
> command line
> # RedHat builds
> %define rh7 0
> %{?build_rh7:%define rh7 1}
> %define rh8 0
> %{?build_rh8:%define rh8 1}
> %define rh9 0
> %{?build_rh9:%define rh9 1}
> # Fedora Core build
> %define fc1 0
> %{?build_fc1:%define fc1 1}
> %define fc3 0
> %{?build_fc3:%define fc3 1}
> # Whitebox Enterprise build
> # this should also work for RHEL
> %define wb3 0
> %{?build_wb3:%define wb3 1}
> # SuSE build
> # this is known to build on SuSE 8.2 and 9.0
> %define su9 0
> %{?build_su9:%define su9 1}
> # Mandrake build
> %define mdk 0
> %{?build_mdk:%define mdk 1}
> 
> # test for a platform definition
> %if ! %{rh7} && ! %{rh8} && ! %{rh9} && ! %{fc1} && ! %{fc3} && ! %{wb3} 
> && ! %{su9} && ! %{mdk}
> %{error: You must specify a platform. Please examine the spec file.}
> exit 1
> %endif
> 
> Regards,
# Bacula RPM spec file
# Copyright (C) 2004 Kern Sibbald

# Platform Build Configuration

# basic defines for every build
%define depkgs ../depkgs
%define depkgs_version 29Oct04
%define tomsrtbt tomsrtbt-2.0.103
%define sqlite_bindir /usr/lib/sqlite
%define working_dir /var/bacula
%define daemon_user root
%define daemon_group bacula
%define group_file /etc/group
%define groupadd /usr/sbin/groupadd

# platform defines - set one below or define the build_xxx on the command line
# RedHat builds
%define rh7 0
%{?build_rh7:%define rh7 1}
%define rh8 0
%{?build_rh8:%define rh8 1}
%define rh9 0
%{?build_rh9:%define rh9 1}
# Fedora Core build
%define fc1 0
%{?build_fc1:%define fc1 1}
%define fc3 0
%{?build_fc3:%define fc3 1}
# Whitebox Enterprise build
%define wb3 0
%{?build_wb3:%define wb3 1}
# RedHat Enterprise build
%define rhel3 0
%{?build_rhel3:%define rhel3 1}
%{?build_rhel3:%define wb3 1}
# SuSE build
%define su9 0
%{?build_su9:%define su9 1}
# Mandrake build
%define mdk 0
%{?build_mdk:%define mdk 1}

# test for a platform definition
%if ! %{rh7} && ! %{rh8} && ! %{rh9} && ! %{fc1} && ! %{fc3} && ! %{wb3} && ! 
%{su9} && ! %{mdk}
%{error: You must specify a platform. Please examine the spec file.}
exit 1
%endif

# database defines
# set for database support desired or define the build_xxx on the command line
%define mysql 0
%{?build_mysql:%define mysql 1}
# if using mysql 4.x define this and mysql above
# currently only Mandrake 10.1 uses this
%define mysql4 0
%{?build_mysql4:%define mysql4 1}
%define sqlite 0
%{?build_sqlite:%define sqlite 1}
%define postgresql 0
%{?build_postgresql:%define postgresql 1}

# test for a database definition
%if ! %{mysql} && ! %{sqlite} && ! %{postgresql}
%{error: You must specify database support. Please examine the spec file.}
exit 1
%endif

# check what distribution we are
%if %{rh7} || %{rh8} || %{rh9} || %{rhel3}
%define _dist %(grep Red /etc/redhat-release)
%endif
%if %{fc1} || %{fc3}
%define _dist %(grep Fedora /etc/redhat-release)
%endif
%if %{wb3} && ! %{rhel3}
%define _dist %(grep White /etc/whitebox-release)
%endif
%if %{su9}
%define _dist %(grep