X-Git-Url: http://git.grml.org/?a=blobdiff_plain;f=docs%2Fgrml-live-db.txt;fp=docs%2Fgrml-live-db.txt;h=0000000000000000000000000000000000000000;hb=019fbefe5b29bb4e95808163f0cd645640cad30c;hp=88c6bfca85de6864d3887b601cb7e8568b330805;hpb=9a1ee76bc3fa423968d666e36422000e4ee979d6;p=grml-live-grml.git diff --git a/docs/grml-live-db.txt b/docs/grml-live-db.txt deleted file mode 100644 index 88c6bfc..0000000 --- a/docs/grml-live-db.txt +++ /dev/null @@ -1,107 +0,0 @@ -grml-live-db(8) -=============== - -Name ----- -grml-live-db - log package build information of grml-live to database - -Synopsis --------- -dpkg-to-db [ options ] || db-to-fai /path/to/grml-live.db - -Introduction ------------- - -The grml-live-db Debian package provides a simple way to put build information -of grml-live into a database. By default you have to do nothing but install -grml-live-db and during each invocation of grml-live you'll get an additional -entry in the sqlite3 database /var/log/grml-live.db. If you want to customize -the database logging check out the following sections in this manpage. - -Provided scripts ----------------- - -/usr/share/grml-live-db/scripts/dpkg-to-db adds grml-live build information -(output of 'dpkg --list') and a logfile into a sqlite3 database. This script is -used by default if grml-live-db is installed (no configuration needed by -default). - -/usr/share/grml-live-db/scripts/db-to-fai converts output of grml-live's sqlite -database for use within FAI. This script is useful if you want to reproduce a -certain build with specific package versions. Please note that you need the -according Debian mirrors providing all the specific package versions of course. - -Options -------- - -dpkg-to-db supports the following options (and all except for --help -are mandatory!): - - --help - -Print help message and exit. - - --database - -Use specified database file. - - --dpkg - -Use specified dpkgfile as `dpkg --list` output file of grml-live build. - - --logfile - -Logfile thath should be added to the database entry. - - --flavour - -Name of the grml-live flavour that was being built. - -The db-to-fai script does not support any options but needs to be invoked with -path to the grml-live database and the build id. - -Configuration and using custom database wrapper scripts -------------------------------------------------------- - -The following configuration variables are available and can be adjusted: - - DPKG_DATABASE=/var/log/grml-live.db - -Path to the database file that should be used for storing the build information. -This database is used within dpkg-to-db by default. - - DPKG_DBSCRIPT=/usr/share/grml-live-db/scripts/dpkg-to-db - -The database wrapper script that's used for storing the build information. -If you do not want to log to the sqlite3 database but instead use your own -abstraction layer just point this variable to your favourite script. - - DPKG_DBOPTIONS="--database $DPKG_DATABASE --logfile $LOGFILE --flavour $GRML_NAME --dpkg $DPKG_LIST" - -If the database script ($DPKG_DBSCRIPT) requires any command line options -specify it through this variable. - -Usage Examples --------------- - -How dpkg-to-db is being used inside grml-live: - - /usr/share/grml-live-db/scripts/dpkg-to-db --database /var/log/grml-live.db --logfile /var/log/grml-live.log --flavour $GRML_NAME --dpkg /var/log/fai/$HOSTNAME/last/dpkg.list - -Manually insert data to database: - - # /usr/share/grml-live-db/scripts/dpkg-to-db --database ./grml-live.db --logfile /tmp/logfile --flavour grml-full --dpkg ./dpkg.list - -Retrieve build information of a specific build for use within FAI: - - # /usr/share/grml-live-db/scripts/db-to-fai /var/log/grml-live.db 6 > /etc/grml/fai/config/package_config/REPRODUCE - -Describe schema of database: - - # echo '.schema' | sqlite3 /var/log/grml-live.db - -Database queries: - - # echo 'SELECT package,version,status,build.flavour,build.identifier FROM packages, build WHERE build.identifier = "grml-full-20091213012517" AND packages.build = build.id ; ' | sqlite3 /var/log/grml-live.db - - # echo 'SELECT package,version,status,build.flavour,build.identifier FROM packages, build WHERE build.id = 7 AND packages.build = build.id ; ' | sqlite3 /var/log/grml-live.db