[Bacula-users] btape dumps core

2005-10-21 Thread John Kodis
I'm trying to install bacula on a 64-bit version of Red Hat Linux, 
and cannot get past the btape tests when I use an autochanger storage
configuration.  I am able to operate the changer manually using the
mtx program, and the btape test command will test the tape drive
successfully so long as I omit the autochanger part of the storage
configuration file.  The only changes that I've made to the
autoconf-generated storage config file are to eliminate the file
storage section and to instead uncomment the autochanger and two tape
drive sections.

Here are the series of commands that I issued to run the btape program:

[EMAIL PROTECTED] sbin]# LD_ASSUME_KERNEL=2.4.19
[EMAIL PROTECTED] sbin]# export LD_ASSUME_KERNEL
[EMAIL PROTECTED] sbin]# ulimit -c unlimited
[EMAIL PROTECTED] sbin]# ./btape -c ../etc/bacula-sd.conf /dev/nst0
Tape block granularity is 1024 bytes.
btape: butil.c:264 Using device: /dev/nst0 for writing.
21-Oct 13:48 btape: 3301 Issuing autochanger loaded drive 0 command.
21-Oct 13:48 btape: Fatal Error because: Bacula interrupted by signal
11: Segmentation violation
Kaboom! btape, btape got signal 11. Attempting traceback.
Kaboom! exepath=/opt/bacula/sbin
Calling: /opt/bacula/sbin/btraceback /opt/bacula/sbin/btape 0
Traceback complete, attempting cleanup ...
Segmentation fault (core dumped)

A backtrace of the resulting core file provides the following enlightenment:

(gdb) bt
#0  dequeue_messages (jcr=0x0) at message.c:1268
#1  0x0042c89e in b_free_jcr (file=0x572078 \001, line=0, jcr=0x0) at 
jcr.c:392
#2  0x00404aff in terminate_btape (stat=11) at btape.c:302
#3  0x00437026 in signal_handler (sig=11) at signal.c:162
#4  0x002a9558f2e8 in __pthread_sighandler () from /lib64/libpthread.so.0
#5  signal handler called
#6  edit_device_codes (dcr=0x579808, omsg=0x589e88 , imsg=0x0, cmd=0x43ddc8 
loaded) at autochanger.c:444
#7  0x0041b6c8 in get_autochanger_loaded_slot (dcr=0x579808) at 
autochanger.c:159
#8  0x004115ef in DEVICE::open_tape_device (this=0x578de8, 
dcr=0x579808, omode=3) at dev.c:338
#9  0x0041184e in DEVICE::open (this=0x578de8, dcr=0x579808, omode=3) 
at dev.c:281
#10 0x00414933 in first_open_device (dcr=0x579808) at device.c:267
#11 0x0040ed69 in setup_jcr (name=0x578098 '\u' repeats 200 
times..., dev_name=0x579808 , bsr=0x0, VolumeName=0x0, mode=0) at butil.c:173
#12 0x00409c3d in main (margc=0, margv=0x7fb9e0) at btape.c:260

I also receive an email with the Subject: Bacula GDB traceback of btape

Using host libthread_db library /lib64/libthread_db.so.1.
ptrace: Operation not permitted.
/tmp/0: No such file or directory.
$1 = '\0' repeats 29 times
$2 = 0x0
$3 = 0x0
$4 = PostgreSQL
$5 = 0x449e53 1.37.40 (01 October 2005)
$6 = 0x449e3a x86_64-unknown-linux-gnu
$7 = 0x449e33 redhat
$8 = 0x449e20 Enterprise release
No stack.
/opt/bacula/etc/btraceback.gdb:11: Error in sourced command file:
No stack.

I'd welcome any suggestions about what further steps I can take to
track down what's going wrong here.

-- 
John KodisGoddard Space Flight Center
[EMAIL PROTECTED]  Greenbelt, Maryland, USA
Phone: 301-286-7376 Fax: 301-286-1771


---
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] btape dumps core

2005-10-21 Thread John Kodis
On Fri, Oct 21, 2005 at 09:29:04PM +0200, Arno Lehmann wrote:

 I've seen that... I could work around that by using my older 
 bacula-sd.conf file - one without the autochanger resource. I supposte 
 that btape is simply not yet developed to know about the newer 
 configuration file format.

Yes, that would explain it.  I was fooled by the section of the
Testing Your Tape Drive With Bacula web page that says that If you
have an autochanger and it is configured, Bacula will automatically
use it.

It looks like the guys writing the documentation just got a bit ahead
of the guys writing the btape code.  Since I've verified that the tape
drives themselves pass the btape tests, I'll just proceed with setting
up Bacula and not worry about this test code failure.

Thanks for the suggestion.  It saved me a potentially painful session
with gdb trying to figure out what was going wrong.

-- 
John KodisGoddard Space Flight Center
[EMAIL PROTECTED]  Greenbelt, Maryland, USA
Phone: 301-286-7376 Fax: 301-286-1771


---
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backup across filesystems

2005-11-01 Thread John Kodis
On Tue, Nov 01, 2005 at 02:36:08PM -0500, Pete J. O'Hara wrote:

 Is there a configuration option where everything under / 
 would be backed up regardless of not being in the / filesystem?

Yup.  In your fileset resource, use something like this:

fileset {
  name = standard-set
  include {
options {
  signature = MD5
  onefs = no
  fstype = ext2
}
file = /
  }
}

The onefs = no directive causes bacula to decend into other
filesystems.  The fstype = ext2 limits this decent to filesystems of
type ext2.  On a typical Linux setup, this will cause bacula to back
up all the local disk-based file systems, while preventing bacula from
trying to back up NFS mounted filesystems or the /proc and /sysfs
filesystems.

-- 
John Kodis


---
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42 plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Tape positioning oddity

2005-11-09 Thread John Kodis
I have a Quantum SDLT tape drive that seems to have changed behavior
recently, and I don't understand why.  In the past, our developers
were able to write a file, then issue a mt bsf 2 command to back up
the tape so that they could read back the file that they had just
written.

Following a reboot, this no longer works.  They now get an immediate
EOF condition after an mt bsf 2, and need to use an mt bsfm 2
command to backspace two filemarks and then skip forward over the next
filemark to get the tape positioned as used to happen in response to
an mt bsf 2 command.

My first thought was that this was caused by a change in the new Linux
2.6 kernel version that went into effect at the reboot, but I see the
same behavior with all kernels that have ever been installed.  The mt
command itself hasn't changed since the OS was installed, and none of
the mt setoption commands seem like they could cause this change in
behavior.

This change in behavior isn't causing any problems for Bacula, and
since the new behavior matches what is documented in the mt man page I
can't report this as a bug, but the inexplicable change in behavior
bothers me.  I'd rest easier if I knew why this change happened.  

Has anyone seem anything like this, or know what might cause it or
where I could look to investigate further?  Thanks for any suggestions.

-- John Kodis.


---
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42 plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Ignore FileSet Changes being ignored

2005-11-11 Thread John Kodis
I recently set up Bacula and did a full backup about a week ago, and a
number of incremental since.  I then added an additional directory to
the exclude section of the file set resource, and as would be
expected, this caused Bacula to upgrade the next backup from
incremental to full.  I don't want this to happen, so I canceled the
job, shut down Bacula, added a Ignore FileSet Changes = yes
directive to the fileset (which I understand is dangerous, and which
will be removed shortly).

After restarting Bacula and rerunning the just canceled job, Bacula
still wants to upgrade this job to full.  Is there anything else that
I have to do to avoid this full backup, or any other way to work
around the problem?

-- John Kodis.


---
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42 plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] A scheduling quirk

2005-12-12 Thread John Kodis
On Mon, Dec 12, 2005 at 02:05:16PM +0100, Jo wrote:

 I'm not so sure this is a waste of resources. Only the files that were 
 changed will be in those incrementals. The first one will catch all the 
 files that changed while the full was running. The second one will be 
 virtually empty.

In my case, these would get run Sunday night, and so both would
contain little beyond the log files that have changed.  I'd rather not
bother saving these twice, and could certainly do without the three
near-identical copies of the catalog backup.  In addition to the waste
of tape, this creates a bunch of job entries that I don't care about.

 If you skip these backups and then a problem occurs the 
 following day, you won't be able to restore to the most current 
 situation, but only to the situation at the moment of the full backup.

That's a good reason to leave the default action as is, although in my
situation I'd still like to be able to override it.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] A scheduling quirk

2005-12-12 Thread John Kodis
On Mon, Dec 12, 2005 at 03:23:39PM +0100, Jo wrote:

 Why don't you change the schedule so no backups are made on Saturday
 and Sunday?

I may end up doing something like that (I'd only skip incrementals on
the first Saturday and Sunday of the month), although I was hoping for
a more general solution.

 Sorry for not being able to actually answer the question.

That's quite alright.  It at least tells me that there's not an
obvious solution that I've just overlooked, and I'm grateful for that
alone.  Thanks!

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] A scheduling quirk

2005-12-12 Thread John Kodis
On Mon, Dec 12, 2005 at 08:33:17PM +0100, Arno Lehmann wrote:

 Unfortunately, you did miss something :-P
 
 From the maual, section Configuring the Director, subsection Jobs:
 
 Max Start Delay = time

Yes, that looks like it should do what I need.  I'm pretty sure that I
read through that section of the documentation when I began setting up
Bacula, but it didn't occur to me that this could be used to eliminate
the back to back incremental and catalog backups that I've noticed.

Thanks once more for the excellent and insightful advice.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Filesystem change prohibited

2005-12-19 Thread John Kodis
On Mon, Dec 19, 2005 at 10:19:08AM +0200, Timo Neuvonen wrote:
 Is there any way to disable warning Filesystem change prohibited, that
 appears in 1.38.x while onefs=yes is in use?

Just to show that needs vary, I wish that there were a way to get a
similar warning when a directory tree is omitted from the backup due
to being listed in a fileset exclude list.

 While this message can be very informational during debugging, I would
 prefer this kind of warnings not to appear in regular production run -now it
 may be more tough to notice real warnings that might appear some day.

One problem with making things like this configurable is that it adds
to the already substantial complexity of the configuration files.
Another approach to solving this problem would be to add an email
filtering script that reduces bacula messages to a summary of the job.
For example, here's a little Ruby script that takes a bacula mail
message, produces a three-line summary if the job completed
successfully, or passes the entire report through if an error
occurred.

The summary:

Successful backup of bonzai-fd
From 13-Dec-2005 00:38:33 to 13-Dec-2005 00:46:55
Wrote 7,237 files, 6,548,719,080 (6.548 GB) bytes at 13045.3 KB/s

The script, for your hacking enjoyment:

#! /usr/bin/ruby -w

val = {}
msg = []
while line = ARGF.gets
  msg.push(line)
  kv = line.split(:, 2)
  val[kv[0].strip] = kv[1].strip if kv.size == 2
end

if val[Termination] != Backup OK
  print msg[msg.index(\n)..-1]
else
  puts
  print Successful backup of , val['Client'].gsub(/ .*/,''), \n
  print From , val['Start time'],  to , val['End time'], \n
  print Wrote , val['FD Files Written'],  files, , \
   val['FD Bytes Written'],  bytes at , val['Rate'], \n
end

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula-web: a status request

2005-12-19 Thread John Kodis
I have a couple of questions about the current status of bacula-web:

- I understand that there's been some recent development work on this
  package, and Google finds a reference to bacula-web 1.2, but I can't
  find this newer release on the web.  What is the current release,
  and where can I find a copy?

- I've tried to use version 1.1 of bacula-web, since I had grabbed a
  copy prior to the great Sourceforge rearrangement, but can't get it
  working.  The test page displays correctly and shows that I have all
  the prerequisites installed, but all I can get from the main
  bacula-web page is an error saying that a database error has
  occurred.  Has anyone gotten this to work with a Postgres database?
  Is there any way to get further debugging information?

As always, thanks for any assistance that anyone can offer.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula-web: a status request

2005-12-20 Thread John Kodis
On Mon, Dec 19, 2005 at 11:14:20PM +0100, Kern Sibbald wrote:
 On Monday 19 December 2005 20:41, John Kodis wrote:

  - Although the web page itself doesn't give any information beyond DB
Connect error, there is excellent diagnostic information in the web
server log files.
 
 Can you give me an example of what information you found, and are
 you talking about the apache (httpd) server log files?

Yes, that's right, the apache we server error log file.  The message
that got me past my initial hurdle was:

PHP Warning: pg_connect(): Unable to connect to PostgreSQL server:
could not connect to server: Connection refused\n\tIs the server
running on host quot;localhostquot; and accepting\n\tTCP/IP
connections on port 5432? in /usr/share/pear/DB/pgsql.php on line
124

This looks as though it was meant to be displayed as part of a web
page, but instead ends up in the web server's error.log file.

  My current stumbling block is this error:
 
  PHP Fatal error:  Call to undefined method DB_Error::numRows()
  in /home/kodis/public_html/classes.inc on line 158
 
  I do seem to have the dbsize Postgres extension module installed, so I
  don't think that that's the problem.  Does this look familiar?
 
 Probably you need to update your version of pear.

Nope.  Thanks for the suggestion, as it's probably worth doing anyway,
but even after using pear upgrade pear archive_tar to bring pear up
to version 1.4.5 and restarting the web server I'm still seeing the
same error message.  This is on a PC running the current release of
Fedora Core Linux, so shouldn't be an uncommon setup and none of the
software should be too far out of date.  At this point, I suspect that
this is related to my use of Postgres rather than the apparently more
common Mysql setup.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Experience summaries

2006-01-04 Thread John Kodis
Someone asked me what types of installations are using Bacula as their
main backup system.  I didn't know of any such experience reports, and
so I thought I'd describe the installation where I'm using Bacula, and
see what other types of setups are in use.  Here goes...

I've been using Bacula for a few months now to back up a couple dozen
Linux and Solaris servers and workstations holding about 4TB of data.
We perform daily backups to a changer holding two LTO tape drives.
The tapes are rated at 400GB each, and we actually get between 400 and
700 GB on each, depending on the compressibility of the data.  The
only problems that I've encountered have all been of the climbing the
learning curve variety, and I hope that those days are behind me.
We're currently considering expanding to another similar installation,
and moving our Mac and MS backups over to Bacula.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] invalid byte sequence for encoding

2006-01-14 Thread John Kodis
This note describes a problem that I recently encountered and worked
around, posted here for ease of Googling to help anyone who hits the
same problem in the future.

I wanted to set up a copy of my Bacula Postgres database on another
machine.  I used the make-catalog-backup script to generate a
bacula.sql file which I then copied to the target machine where I had
created a bacula database.  Trying to load the database using:

psql bacula.sql

produced this error message:

ERROR:  invalid byte sequence for encoding UNICODE: 0xe6736d
CONTEXT:  COPY filename, line 119616, column name: l\usmig

The Postgres documentation explained that this was due to the strict
type-checking that was added to recent versions of Postgres, and
suggested stripping these invalid Unicode sequences from the database
tables using the iconv utility.  There are two problems with this:
first, it will alter the contents of the database; second, the iconv
utility works by reading the entire file that it's converting into
memory, which doesn't work too well with a 3GB SQL file.

What I ended up doing instead was to drop the database and create it
with a character encoding of SQL_ASCII rather than the apparent
default of UNICODE.  

$ dropdb bacula
DROP DATABASE
$ createdb -E sql_ascii bacula
CREATE DATABASE

This allowed the database to be reloaded successfully, and seems to
have worked although I'm not sure of what effect this may have on sort
order, or weather that even matters.  I'll send a related note to the
-devel list to discuss this and another Postgres-related issue.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Extensions to query.sql (was: problems with update slots)

2006-01-16 Thread John Kodis
On Mon, Jan 16, 2006 at 10:27:17AM +0100, Arno Lehmann wrote:

 Ok, here is what I added to my query.sql file. Note that it works with 
 MySQL only - the only PostgreSQL installation I have available uses file 
 based backups, so there never was much need to make these queries 
 portable. And doing this by simply writing portable SQL is, 
 unfortunately, beyond my SQL capabilities :-)

These queries are more portable than you're giving yourself credit
for.  I ran all of these queries against a Postgres database and they
work as expected except for #17, which gives the notice and error
message shown below.  Even in this case, the fix is simple, albeit
non-obvious: just change FROM Media,Storage to FROM Storage,Media,
and all is well.

 # 17: List which media bacula thinks is in changer:
 SELECT MediaId,VolumeName,VolBytes/(1024*1024*1024) AS GB,Storage.Name 
 AS Storage,Slot,Pool.Name AS Pool,MediaType,VolStatus
  FROM Media,Storage
  LEFT JOIN Pool ON Media.PoolId=Pool.PoolId
  WHERE (Slot  0) AND (InChanger=1)
  AND Media.StorageId=Storage.StorageId
  ORDER BY MediaType ASC, Slot ASC;
NOTICE:  adding missing FROM-clause entry for table media
ERROR:  JOIN/ON clause refers to media, which is not part of JOIN

bacula= SELECT MediaId,VolumeName,VolBytes/(1024*1024*1024) 
bacula- AS GB,Storage.Name
bacula- AS Storage,Slot,Pool.Name AS Pool,MediaType,VolStatus
bacula-  FROM Storage,Media
bacula-  LEFT JOIN Pool ON Media.PoolId=Pool.PoolId
bacula-  WHERE (Slot  0) AND (InChanger=1)
bacula-  AND Media.StorageId=Storage.StorageId
bacula-  ORDER BY MediaType ASC, Slot ASC;
 mediaid | volumename | gb  | storage | slot | pool | mediatype | 
volstatus
-++-+-+--+--+---+---
   9 | A1L3   | 755 | Tape|1 | LTO3-backups | LTO-3 | Full
... snip ...
  58 | A00050L3   |   0 | tape|   50 | LTO3-backups | LTO-3 | Append
(49 rows)

Thanks for the contribution Arno.  I can see these queries coming in
handy.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Unlisted fstype on MS-XP

2006-02-03 Thread John Kodis
On Thu, Feb 02, 2006 at 07:56:22PM +0100, Arno Lehmann wrote:

 This option is not implemented in Win32 systems. 
 
 Or, in other words, you can't do that with windows.

Ouch!  I'm sorry for not having read the fine manual far enough to
have spotted that, but it never occurred to me that the fstype=ntfs
option would only work with non-Microsoft clients!

 Usually you don't have the related problems, though - typically, all
 partitions on a windows machine do have their own drive letters, so
 it's unlikely you will accidentally backup too much stuff.

What I'm really after is some simple way to identify and back up all
the local, disk-backed files on each machine.  On Linux machines, I
can do this by putting file = /, onefs = no, and fstype = ext2 in a
fileset, and that will pick up all the local disk partitions while
skipping NFS imports, CDs, /proc, /sysfs, and the like.

I was hoping to be able to do something similar with Microsoft
clients, using a single fileset for all these machines and using the
fstype = ntfs option used to screen out CDs and SMB shares.  That way
I wouldn't have to modify the backup configuration when someone added
a new disk to their PC.

It looks like it may be best to just manually track the drive letters
though.  That won't be a great deal of effort, I was just looking for
an easy way to automate it.  Thanks again for the clarification and
help.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Schedule and Director question

2006-02-18 Thread John Kodis
On Sat, Feb 18, 2006 at 07:23:36PM +0100, Torsten Uhlmann wrote:

 1) Can I specify a schedule that says: Backup at 12:00 midnight OR
 THE NEXT POSSIBLE OCCASION? My notebook is not always connected to
 the server, so the backup is likely to fail often if I specify a
 rigid date. Is this possible?

In the Configuring the Director section of the documentation, under
The Job Resource, see the descriptions of the directives reschedule
on error, reschedule interval, and reschedule times.
Additionally, the directives rerun failed levels and max wait time
may also be useful.

 Might be obvious to answer but I didn't find it in the manual
 explicitely...

I know the feeling.  There's a lot of material there.

 Is it possible that a client can add to this information, so that
 users can have a file on their notebooks (or PC's) that lists
 additional ressources that should be saved to the storage pool? I
 would not want to keep the information for all the clients in a
 single place.

A bit further along in the same section, under The FileSet Resource,
see the description of the file-list directive, especially the
part about using \ to read the file list from a file on the client
machine.

Best of luck.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Announcing Bacuview, a Bacula monitoring web application

2006-02-20 Thread John Kodis
I've written an application called Bacuview that provides a
web-based view of a Bacula system, similar to the the Bacula-Web
project.  I've been using it to monitor a Postgres based installation
of Bacula for the past couple of months, found it quite useful for my
purposes, and now I think it's ready for a wider audience.

If you'd like to see what the application provides, there are
descriptions and screen shots on the Bacuview home page at
http://bacuview.rubyforge.org/.  If this seems useful to you, you
can look through the INSTALL document and pull down a tar file or do a
subversion checkout to get a copy of the code.

I'd be happy to answer any questions that you have, and to hear of any
suggestions that you have for this project.  I hope that you find it
useful.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Spooling can slow Bacula

2006-02-20 Thread John Kodis
There was some discussion last week about tape write speeds, including
one message that said something like I guess if you're using an LTO-3
drive, you must have spooling turned on.  Since I'm using an LTO-3
drive and had not been using a spool file, I thought I'd enable this
and see what effect it had on performance.

To my surprise, it took over twice as long to perform a full backup
when spooling was enabled.  The numbers for two full backups made two
weeks apart are:

Without spooling: 3.8 TB in 24:57 at 44.8 MB/s
With spool file:  3.9 TB in 55:43 at 20.4 MB/s

Both jobs were on the same hardware, with everything -- the client,
director, storage server, console, and database -- on the same
machine, and with no other backup jobs running.  The only significant
difference was the addition of a 60 GB spool file on the fastest RAID
array on the system just prior to the second run.

What seems to happen is that without a spool file, Bacula does a very
good job of overlapping the read of data with the write to tape and
the update of the database.  When spooling is in use, these three
operations are performed sequentially, significantly slowing down the
speed of the job.  On the other hand, I did notice a speed improvement
in the concurrent backup of several remote clients with the spool file
enabled.

So while there are many good reasons for using a spool file listed in
the Data Spooling section of the manual, speed isn't always one of
them.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Spooling can slow Bacula

2006-02-20 Thread John Kodis
On Mon, Feb 20, 2006 at 11:36:45PM +0100, Ludovic Strappazon wrote:
 Wolfgang Denk wrote:

 And assuming you are backing up some  big  RAID  array  it  might  be
 difficult to provide big enough spool files.

That's certainly the case in my situation.  I don't have 4 TB sitting
idle that I can dedicate to spool space, and even if I did, it
wouldn't help performance any because of the sequential nature of
spooled backup jobs.

 So the only real advantage of data spooling as I see it  is  that  it
 helps  to  reduce  tape  (drive) wear by avoiding frequent start-stop
 sequences - which is only  a  problem  if  your  file  system  cannot
 provide  the  data  faster  than the tape can write. In my experience
 this is only the case for differential and incremental backups -  and
 then the data size might be small enough to fit in a spool file.

Yes, I think that that's right, but it wasn't obvious from the
documentation.  That's what lead me to give this a try.

 Ideally I'd like to be able to turn spooling  off  for  level  full
 backups   while   leaving   it  turned  on  for  differential  and
 incremental ones.
 
 You can override your job's default in the schedule, something like :
 
 Schedule {
  Name = MySchedule
  Run = pool=MyPool Full fri at 20:30
  Run = SpoolData=yes pool=MyPool Storage=LTOdrive Differential mon-thu at 
 20:30
  Run = SpoolData=yes pool=MyPool Storage=LTOdrive Incremental fri at 11:35
 }
 
 Ludovic Strappazon.

This looks like the way to go.  If I leave spooling enabled at all, it
will be with a setup like this where its use can be limited to the
remote clients that stand to benefit.

-- John Kodis.


---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Announcing Bacuview-1.2, a Bacula monitoring web application

2006-02-28 Thread John Kodis
I've just released version 1.2 of the Bacuview web application to
its home on RubyForge, http://bacuview.rubyforge.org/, where you can
go for screen shots and to read the NEWS, ChangeLog, and INSTALL files.

In addition to the usual minor bug fixes, this release...

- Adds media expiration time and retention period columns to the
  media view.

- Automates the client to host name mapping needed to check client
  status by reading these mappings from Bacula config files at
  server startup time.

- Made the web pages more standards-compliant, and avoids setting
  cookies so as to not upset the powers that be.

Currently planned for the next release...

- MySQL support.

I'd be happy to answer any questions that you have, and to hear of any
suggestions that you have for this project.  I hope that you find it
useful.

-- 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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] appending position

2006-03-02 Thread John Kodis
On Thu, Mar 02, 2006 at 02:03:59PM +0100, Thomas Franz wrote:

 In the case of a backup run it takes a long time ( up to hours )
 until the storage daemon is finding the end-of-data position . ( Of
 course only if the tape is nearly full).  We are using bacula 1.36.3
 on a FreeBSD 4.11 machine.  The backup hardware is an EXABYTE
 Changer with an IBM LTO-3 drive.

It doesn't seem right that you should be seeing those types of
positioning delays.  I'm also using an LTO-3 drive, and have never
seen the drive spend more than a few minutes positioning the tape.  I
suspect that the problem is with the use of the Fast Forward Space
File = no directive.  With the type of delays that you're reporting,
I can easily believe that the drive is positioning to the end of data
by reading all the data written up to that point.

What happens if you use fast forward space file = yes?

 It seems to work well after testing with btape and using the following 
 parameters:
 ...
   Hardware End of Medium = no
   BSF at EOM = yes
   Backward Space Record = no
   Fast Forward Space File = no
   TWO EOF = yes
 
 
 Thanks.
 
 Thomas
 
 
 ---
 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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] bacula 1.38.x for mac osx 10.3

2006-03-08 Thread John Kodis
On Wed, Mar 08, 2006 at 09:43:28AM +0100, Stefan Schwietert wrote:

 Is there someone who has managed to start bacula-fd with launchd. I  
 tried it but launchd gets an error, tries to start it several times  
 and then gives up. If I start bacula-fd by hand everything is good.  
 So I think the problem is related to launchd and its mechanism to  
 manage ports and sockets.

You'll see that result if you use launchd to run the normal bacula
startup script, since the script runs bacula-fd as a daemon and
launchd interprets the daemonization as a sign that the program has
failed and has to be restarted.  

I've had success with the following launchd file.  It's written to use
the standard bacula file locations which run the command:

/sbin/bacula-fd -v -f -c /etc/bacula/bacula-fd.conf

As you've already figured out, you can just drop this big blob of XML
into the  /Library/LaunchDaemons/ directory with a filename of
net.bacula-fd.plist, and launchd will do the rest.

?xml version=1.0 encoding=UTF-8?
!DOCTYPE plist PUBLIC
  -//Apple Computer//DTD PLIST 1.0//EN
  http://www.apple.com/DTDs/PropertyList-1.0.dtd;
plist version=1.0
  dict
keyLabel/key
  stringnet.bacula-fd/string
keyOnDemand/key
  false/
keyProgramArguments/key
  array
string/sbin/bacula-fd/string
string-f/string
string-v/string
string-c/string
string/etc/bacula/bacula-fd.conf/string
  /array
  /dict
/plist

-- John Kodis.

PS:  It sure would have been nice if instead of 20 lines of fairly
illegible XML we could just write something like:

label   = net.bacula-fd
program = /sbin/bacula-fd -f -v -c /etc/bacula/bacula-fd.conf

Oh well.  I guess that even the XML version is easier to read and
write than the typical shell startup script, so at least it's a step
in the right direction.


---
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=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Announcing Bacuview-1.3, now with MySQL support

2006-03-20 Thread John Kodis
I've just released version 1.3 of the Bacuview web application to
its home on RubyForge, http://bacuview.rubyforge.org/, where you can
go for screen shots and to read the NEWS, ChangeLog, and INSTALL
files.

In addition to the usual minor bug fixes, this release has one fairly
major improvement: It now supports Bacula installations that use MySQL
as their database engine.  

All that's needed to support a MySQL database is to set the adapter to
mysql in the config/database.yml file.  Bacuview picks this up and
performs behind-the-scenes magic to deal with the naming differences
between Postgres and MySQL databases.

I'd be happy to answer any questions that you have, and to hear of any
suggestions that you have for this project.  I hope that you find it
useful.

-- 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=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Re: Announcing Bacuview-1.3, now with MySQL support

2006-03-22 Thread John Kodis
Thanks for the report Mark.  I'm glad to hear that Bacuview is working
well for you in a production installation, particularly since I don't
use MySQL in production, and so have only a small dummy MySQL database
to test against here.

Since Fedora Core 5 was released a couple days ago, I'll go through a
complete installation of Bacuview on that platform, and insure that
I've addressed the rough spots in the installation instructions that
you've reported.

I've had other requests for some type of query by filename feature.
I'll probably put this in place in the not-too-distant future, but I
have a few other query clean-ups in mind that I'd like to get to
first.  As for extending this into a complete front-end for the
restoration process, at this point I'd prefer to stick with query and
reporting functions, and as you suggest, let bconsole and friends
handle the restores (but then, prior to a few months ago, I had no
idea that I'd be developing an application like Bacuview to begin
with, so you never know!)

-- John Kodis.

On Tue, Mar 21, 2006 at 10:18:15AM -0800, Mark Nienberg wrote:
 John Kodis wrote:
 I've just released version 1.3 of the Bacuview web application to
 its home on RubyForge, http://bacuview.rubyforge.org/, where you can
 go for screen shots and to read the NEWS, ChangeLog, and INSTALL
 files.
 
 In addition to the usual minor bug fixes, this release has one fairly
 major improvement: It now supports Bacula installations that use MySQL
 as their database engine.  
 
 All that's needed to support a MySQL database is to set the adapter to
 mysql in the config/database.yml file.  Bacuview picks this up and
 performs behind-the-scenes magic to deal with the naming differences
 between Postgres and MySQL databases.
 
 I'd be happy to answer any questions that you have, and to hear of any
 suggestions that you have for this project.  I hope that you find it
 useful.
 
 Thank you for this.  I installed it yesterday from scratch.  Here are 
 some suggestions for the INSTALL page.
 
 
 RUBY
 
 
 In this section you should also describe installation of IRB.  I don't 
 know if this gets installed as part of building ruby from source, but in 
 Fedora Core 4 it is a separate rpm package and you need
 yum install irb.
 
 I don't know if it was necessary, but I also installed the rpms for 
 ruby-devel and ruby-mysql.
 
 GEM INSTALL
 ---
 
 For mysql users you can skip the gem install postgres and instead do 
 gem install mysql.  If that fails (it did for me) you can try
 gem install mysql --with-mysql-config=/usr/lib/mysql/mysql_config or 
 something similar.  Frankly, I tried so many things that I'm not sure 
 what finally worked.
 
 
 Is there any chance this program could be extended to allow file 
 searches within the database?  I'd love to be able to enter a partial 
 name of a file and get back a list of all occurrences of that name along 
 with the file dates and the jobs that contain it.  Then I could go to 
 bconsole and jump right to the correct job for restoration.
 
 Ultimately, could it be a complete front end for file restoration?
 
 Thanks again,
 Mark Nienberg
 
 
 
 ---
 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=lnkkid=110944bid=241720dat=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=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Bacula jobstatus codes

2006-03-30 Thread John Kodis
On Thu, Mar 30, 2006 at 12:32:23PM +0200, Giuseppe wrote:

 I'm looking for bacula codes about jobstatus, but I can't
 find them in the bacula online manual. (Am I blind? ehehe )

They're stored in the database:

bacula=# select * from status;

 jobstatus |  jobstatuslong
---+-
 C | Created, not yet running
 R | Running
 B | Blocked
 T | Completed successfully
 E | Terminated with errors
 e | Non-fatal error
 f | Fatal error
 D | Verify found differences
 A | Canceled by user
 F | Waiting for Client
 S | Waiting for Storage daemon
 m | Waiting for new media
 M | Waiting for media mount
 s | Waiting for storage resource
 j | Waiting for job resource
 c | Waiting for client resource
 d | Waiting on maximum jobs
 t | Waiting on start time
 p | Waiting on higher priority jobs
(19 rows)

-- 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=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Running Jobs simultaneously on two streamers of same type - Sorry to come back up ;-) with this again

2006-03-30 Thread John Kodis
On Thu, Mar 30, 2006 at 04:21:59PM +0200, Christoff Buch wrote:

 For me, it sounds like the whole concept of priorities is obsolete and job 
 order has to be managed all by schedules.
 Right?
 I mean if priorities are only respected correctly as long as jobs are 
 started (by schedules) in the according order (because bacula needs to 
 examine them in just this order to be able to respect those priorities 
 correctly) - what do I need priorities for

The one thing that I use schedules for is taken directly from the
example configuration: running a catalog backup immediately after all
the client backups have completed.  While jobs at the same priority
seem to normally run in the order in which they get queued up, there's
no guarantee of this.  There is such a guarantee with priorities.

-- 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=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Review of Bacula

2006-04-05 Thread John Kodis
There's a brief review of Bacula at:

http://osreviews.net/reviews/admin/bacula

It's fairly positive, but criticizes the tape selection algorithm as
being far from intuitive.

-- 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=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] New user questions

2006-04-15 Thread John Kodis
On Sat, Apr 15, 2006 at 12:09:18PM -0400, Francisco Reyes wrote:

 So far I have not found the following on the docs:

I'm far from the expert that several other list members are, but I'll
take a shot at these.

 * Difference between Full, Differential, Incremental in Bacula.
 I know the concepts, what I am interested is how these work in bacula.

 In particular I did a job/mod and changed a full to differental and then 
 did an estimate. The estimate showed a number very close to what the full 
 backup was. Does the estimate only works for full? Out of nearly 3 million 
 files it's hard to imagine that they all changed since a full backup 2 days 
 ago. :)

I'd guess that either you've changed something in your filesystem --
touched most of the files, or changed where a large filesystem is
mounted -- or that Bacula overrode your request.  Even if you specify
an incremental, Bacula will perform a full backup if there's no
suitable full backup found.  This can happen if you change the
fileset, if the last full backup didn't complete or was deleted, or
under a few other circumstances.

 How does bacula determines what has changed? By date/time/md5?
 Running bacula in FreeBSD (client/server)

By timestamp -- mtime, if I recall correctly.  It's the same for
Linux, the BSDs, and any other Unix-like platforms.

 * If I made a change to bacula-dir.conf is there a command to check the 
 syntax is correct? The consultant mentioned that if the syntax is wrong 
 that it may kill the bacula-dir (is that usually referred as the server?)

I've always thought of the server as everything that's not the console
or one of the clients: the director, the storage server, and the
database.  That is, all the stuff needed to service a client.

As for testing your configuration, this is taken directly from the
Testing your Configuration Files section of the online
documentation:

You can test if your configuration file is syntactically correct
by running the appropriate daemon with the -t option. The daemon
will process the configuration file and print any error messages
then terminate. For example, assuming you have installed your
binaries and configuration files in the same directory.

cd installation-directory
./bacula-dir -t -c bacula-dir.conf

 And if the bacula-dir did die, will running backups stop? 

Yup.  Even if you're sure that your configuration files are correct,
I'd be surprised if the Bacula director could survive the type of
mid-job restart the you seem to be contemplating.

 * Does Bacula summits one transaction for each file to PostgreSQL? Any way 
 to pool several files as to have them in a single transaction?

I have no idea, nor any reason to care as the database stuff has
always just worked.  Are you just curious, or is there some other
issue that you're chasing?

-- 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=lnkkid=110944bid=241720dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Backups too big, and other questions

2006-04-25 Thread John Kodis
On Mon, Apr 24, 2006 at 06:50:33PM -0700, Scott Ruckh wrote:

 I think I have found the culprit, /var/log/lastlog .  It is a sparse
 file and appears to be 1.2TB, which is way larger then the total
 space of the filesystem, In reality, this file only uses 64K of
 actual used disk space, but I am guessing bacula sees it as a 1.2TB
 file.

In the olden days, prior to the wide-spread use of 64 bit computers,
Unix user IDs were 32 bit integers, and the lastlog file had an entry
for each one.  There were few enough that the bit of wasted space
didn't matter.  At some point, Red Hat changed user IDs to 64 bit
integers on 64 bit platforms, and since the lastlog file still had an
entry for each one, there were now so many user IDs that the wasted
space does matter, bloating the lastlog file to 1.2TB as you've noted.
They've corrected this problem in recent releases of their
distribution.

$ uname -p
x86_64
$ ls -l /var/log/lastlog
-r  1 root root 11390920 Apr 25 07:49 /var/log/lastlog

Just FYI.

-- John Kodis.


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Huge/slow index in MySQL

2006-05-01 Thread John Kodis
On Mon, May 01, 2006 at 12:04:10PM +0200, Christoph Haas wrote:

 Now it's 12 hours after I started to restore the 2.4 GB dump file
 and MySQL still seems to be doing the /*!4 ALTER TABLE `File`
 ENABLE KEYS */ part of the dump. The disk is trashing like fury
 while the database is creating the indices.

That seems a bit slow.  For comparison, I've loaded a Postgres dump of
a system with about a million files and several TB of data on a 2 GHz
PC in about an hour.  The time seems roughly the same whether I'm
reading a 3 GB ASCII dump, or the 1 GB binary equivalent.  

 It also appears that while running a backup the database is
 extremely busy leaving little computing power for the actual
 backup. The disks are common IDE disks running in a Pentium 4/2.4
 GHz with 512 MB RAM.

You have more CPU than I do, but only about half the memory.  Since
you say that the disks are thrashing, I'd guess that the lack of
memory is more likely to be the culprit than the difference in
databases.  There have, however, been some messages posted here
indicating that MySQL needs more attention to tuning when backing up
this many files than a similar Postgres installation does.

-- John Kodis.


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Turning prompt off?

2006-07-01 Thread John Kodis
On Fri, Jun 30, 2006 at 07:37:36PM -0400, Francisco Reyes wrote:

 Alternatively is there are a way to specify multiple volumes or a
 range, for deletion? Tried comma separated and dash.

You could use a shell script to automate the task.  Something like:

  for n in $(seq 27 42); do
echo -e delete volume=junk-$n\nyes | bconsole
  done

Just make sure that you've got the range of volumes right first!

-- John Kodis.

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Turning prompt off?

2006-07-01 Thread John Kodis
On Sat, Jul 01, 2006 at 12:02:45PM -0400, Francisco Reyes wrote:
 John Kodis writes:
 
 You could use a shell script to automate the task.  Something like:
   for n in $(seq 27 42); do
 echo -e delete volume=junk-$n\nyes | bconsole
   done
 
 What does -e does?
 That option doesn't exist in FreeBSD.

The -e switch causes echo to interpret backslash escapes, similar to
how they're interpreted in C strings.  This causes the \n to output a
newline, generating two lines of output with one echo statement.  If
this isn't available, you can replace it with two echo statements in a
subshell, like so:

  ( echo -e delete volume=junk-$n; echo yes ) | bconsole

 Thanks!

Glad to be of assistance.

-- John Kodis.

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] [OFF-TOPIC] Bacula Web-based

2007-07-23 Thread John Kodis
On Mon, Jul 23, 2007 at 06:18:02PM +0300, Mantas M. wrote:
 there are two web based tools that allow you to _get info_ about the 
 backups from the database.
 
 bacula web: http://www.bacula.org/bacula-web/bacula-web.html
 and
 webacula: https://sourceforge.net/projects/webacula

Let me add a third to the list:

Bacuview -- a Bacula Status Monitor
http://bacuview.rubyforge.org/

This is written in Ruby using the Rails framework.  It's a small
application, weighing in at 650 lines of Ruby and 350 lines of
ruby-embedded html.

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now   http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users