Re: [Bacula-users] Unmount command (Re: eSATA / USB disks as media for Bacula)

2009-11-14 Thread Michael FIG
"Timo Neuvonen"  writes:

> Does anyone have any more up-to-date information of this disk
> unmount issue?

IMHO, "mount/unmount" are very different operations for disk and
tapes.  For tapes, it is acceptable to leave them "mounted" in the
drive, because a "rm -rf /" won't touch them.  For disks, they are
made part of the filesystem namespace when they are mounted, so their
contents will get blown away by "rm -rf /".

That's scary to me... the only reason I'm using Bacula instead of just
RAID mirroring is that accidental or naive malicious attacks can wipe
out all my data.  I realize that moving my backups to a secure offsite
location is the only way to prevent this fully, but I'm looking for
middle ground with convenience and some measure of safety.

I'm currently using the patches mentioned by Cedric Tefft at:

http://bugs.bacula.org/view.php?id=1361

in conjunction with:

Device {
  Name = FileStorage
  Media Type = File
  Archive Device = /MY-DIR/volumes
  Mount Point = /MY-DIR
  Mount Command = "/bin/mount %m"
  Unmount Command = "/bin/umount %m"
  Requires Mount = yes
  LabelMedia = yes;   # lets Bacula label unlabeled
  media
  Random Access = Yes;
  AutomaticMount = yes;   # when device opened, read it
  RemovableMedia = yes;
  AlwaysOpen = no;
  Offline On Unmount = yes
}

-- 
Michael FIG  //\
   http://michael.fig.org/\//


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] simple (?) mount/unmount of USB storage device

2009-11-02 Thread Michael FIG
Hi,

Cedric Tefft  writes:

> An autochanger config is probably overkill.  You can implement autofs as 
> John already suggested, or you can use the "Mount Command", "Unmount 
> Command" (et. al.) directives in your Device resource:

Thanks for this advice... autofs wouldn't work for me, as I don't want
a "rm -rf /" to touch my backup device when it's not in use.

I'll look into what I can do with your sd config.

-- 
Michael FIG  //\
   http://michael.fig.org/\//

--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] simple (?) mount/unmount of USB storage device

2009-10-30 Thread Michael FIG
Hi,

I'm a long-term Bacula user, having used it for file and DVD volume
backups in the past.  I'm scratching my head over what seems like a
really simple requirement, but I can't for the life of me figure it
out right now.

I have a large external USB drive on which I want to write file
volumes, by mounting it as /var/lib/bacula/media

I have everything working to create and rotate files in the
/var/lib/bacula/media directory, but I want to leave the drive
unmounted (and thereby less liable to corruption) as often as
possible, so that bacula-sd "mount"s it as /var/lib/bacula/media to do
the backup, and "umount"s it when the backup is finished.

I've been messing around with the autochanger scripts, but just don't
understand them enough to put something this simple together.

Anybody out there have a suggestion for what to do?

Thanks,

-- 
Michael FIG  //\
   http://michael.fig.org/\//


--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] long waits for "status dir" to complete and *unknown* volumes

2007-04-24 Thread Michael FIG
Martin Simmons writes:

>It depends on the size of the database.  You could try setting
>log_slow_queries and long_query_time in your my.cnf to see which queries are
>causing the problems.

Thanks for your reply.  I'll use your advice to look into this further.

-- 
Michael FIG <[EMAIL PROTECTED]>, PMP
MarkeTel Multi-Line Dialing Systems, Ltd.
Phone: (306) 359-6893 ext. 528


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] long waits for "status dir" to complete and *unknown* volumes

2007-04-19 Thread Michael FIG
Hi, all...

I have Bacula 1.38.11-5ubuntu1 installed.

Just recently, I believe our Bacula setup hit its first year 
anniversary, and so now our 365 day volume retention period goes into 
effect.

It now takes a long time (several minutes) to complete a "status dir" 
command.  To try to speed it up, I've run "myisamchk -o *.MYI" on all 
the Bacula tables on our MySQL server.  I've also added the following 
indices (based on watching what queries bacula-dir was issuing via 
MySQLAdmin):

mysql> alter table File ADD INDEX(JobId);
Query OK, 2679492 rows affected (59.59 sec)
Records: 2679492  Duplicates: 0  Warnings: 0

mysql> alter table JobMedia ADD INDEX(MediaId);
Query OK, 13895 rows affected (0.15 sec)
Records: 13895  Duplicates: 0  Warnings: 0

mysql>

This has helped a little, but I'm wondering if there's anything else 
that I can do to make it snappier.

My second question is that I just noticed "*unknown*" being returned for 
the volume on the scheduled jobs.  Is this normal?  I don't remember 
seeing this before.

Here is the output I get from running bconsole.

# bconsole
Connecting to Director bacula-dir:9101
1000 OK: bacula-dir Version: 1.38.11 (28 June 2006)
Enter a period to cancel a command.
*status dir
Using default Catalog name=MyCatalog DB=bacula
bacula-dir Version: 1.38.11 (28 June 2006) i486-pc-linux-gnu debian 
testing/unstable
Daemon started 13-Apr-07 17:40, 0 Jobs run since started.

Scheduled Jobs:
Level  Type Pri  Scheduled  Name   Volume
===
Differential   Backup10  13-Apr-07 22:05server1 
*unknown*
Full   Backup10  13-Apr-07 22:05server2 
*unknown*
Full   Backup10  13-Apr-07 22:05server3 
*unknown*
[...]
Full   Backup10  13-Apr-07 22:05client1 *unknown*
Differential   Backup10  13-Apr-07 22:05client2 
*unknown*
Full   Backup10  13-Apr-07 22:05client3 
*unknown*
[...]


Running Jobs:
No Jobs running.

No Terminated Jobs.

*

Thanks for any help you can offer,

-- 
Michael FIG <[EMAIL PROTECTED]>, PMP
MarkeTel Multi-Line Dialing Systems, Ltd.
Phone: (306) 359-6893 ext. 528

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users