| Russ Allbery > Software > AFS Reporting DB | afsdb-load Changes > |
(Load AFS volumes data into the AFS database)
afsdb-load [-hvV] [server ...]
afsdb-load loads AFS volumes data into the volumes table of the AFS
database, moving the previous day's data into previous_volumes for use
with nightly reports. The data loaded is taken from the output of
vos listvol -long. The list of active AFS servers is taken from
/afs/ir/service/afs/data/serverlist.afs.
A list of servers can be provided on the command line, but this should only be used for testing (since it will result in an incomplete volumes table in the database).
Unless the -V flag is given, this script will produce no output unless it fails, making it suitable to be run by cron.
Print out this documentation (which is done simply by feeding the script
to perldoc -t).
Print the version of afsdb-load and exit.
Print out each major action of the script as it's performed, useful for debugging.
The list of active AFS servers is taken from this file. To avoid errors
from attempting to run vos listvol -long, only currently running
AFS servers should be included in this file.
A temporary output file holding the results of the last vos listvol
command. This file will be created and removed as each server partition
is processed.
The log file used in loading the MySQL table. If the load fails, the contents of this log file will also be included in the output of this script.
Where the data to be loaded into the database is put. This file contains one line for each volume with fields separated by semicolons and is used as input to MySQL's LOAD DATA INFILE command.
If loading the data fails, this file will contain the first data line that MySQL didn't like.
Orignally written by Neil Crellin <neilc@stanford.edu>. Rewritten by
Susan Feng <sfeng@stanford.edu> to handle temporary failures of vos
listvol. Rewritten by Russ Allbery <rra@stanford.edu> and Jonathan Pilat
<jonpilat@stanford.edu> to use Oracle and the Stanford::LSDB::AFSDB
module, to no longer use the -extended flag of vos listvol,
and to be somewhat more parsimonious about its disk space consumption.
Rewritten by Jon Robertson <jonrober@stanford.edu> to use MySQL rather
than Oracle.
Copyright 1998, 1999, 2001, 2002, 2005, 2008 Board of Trustees, Leland Stanford Jr. University.
This program is free software; you may redistribute it and/or modify it under the same terms as Perl itself.
vos(1), vos_listvol(1)
The current version of this program is available from the AFS reporting database software page at <http://www.eyrie.org/~eagle/software/afsdb/>.
| Russ Allbery > Software > AFS Reporting DB | afsdb-load Changes > |