Tentative fix for missing digest signature in bug 807.

[bacula/bacula] / gui / bweb / INSTALL

diff --git a/gui/bweb/INSTALL b/gui/bweb/INSTALL
index a45582757d44cde6d54b7e7bd040227859cc34b6..e80e9fce4314d9782b36e0906493eeb11c8c936a 100644 (file)
--- a/gui/bweb/INSTALL
+++ b/gui/bweb/INSTALL
@@ -7,7 +7,7 @@ Bweb works well with 1.39 release or later.
 1) install Perl lib
 2) copy your files
 3) initialize your configuration file
-4) do some sql stuff (for postgresql users)
+4) do some sql stuff (for postgresql or mysql 5 users)
 5) use the -n option on bconsole so that it works with Expect
 6) get bacula log more useful
 7) bweb limitation
@@ -15,6 +15,7 @@ Bweb works well with 1.39 release or later.
 9) using bfileview.pl
 10) accessing to bweb
 11) setting mysql read-only account
+12) get more statistics
 
 ################ FILE COPY #####################################
  # you must get bweb svn files
@@ -179,16 +180,24 @@ If you want to use brestore with bweb, you must associate a mime type
 text/brestore with your brestore.pl, and you must install brestore.
 See gui/brestore/README for instructions on installing brestore.pl.
 
-################ POSTGRESQL NOTES ##############################
+################ POSTGRESQL AND MYSQL5 NOTES ####################
 
 If you want to use PostgreSQL instead of MySQL, you must add
 a function to the PostgreSQL Bacula database to get Bweb to work.
 
 psql -U bacula bacula < script/bweb-postgresql.sql
 
-Tips: PL must be enable in your cluster, you can do this with postgres user
+Tips: PL must be enabled in your cluster, you can do this with postgres user
 postgres:~$ echo 'CREATE PROCEDURAL LANGUAGE plpgsql;' | psql bacula 
 
+
+To get database size with mysql5, edit Bweb.pm and change the DB_SIZE macro
+
+ # with mysql < 5, you have to play with the ugly SHOW command
+ DB_SIZE => " SELECT 0 ",
+ # works only with mysql 5
+ # DB_SIZE => " SELECT sum(DATA_LENGTH) FROM INFORMATION_SCHEMA.TABLES ",
+
 ################ BCONSOLE NOTES ################################
 
 You must use bconsole without conio/readline support. For that, use
@@ -271,12 +280,12 @@ To upgrade from an old installation, you can use :
 ALTER TABLE brestore_pathvisibility ADD Size int8;
 ALTER TABLE brestore_pathvisibility ADD Files int4;
 
-################ ACCESSING TO BWEB ###############################
+################ ACCESSING TO BWEB ############################
 
 Now, you are able to launch firefox/mozilla and go on
 http://your-server/bweb
 
-################ SETTING MYSQL ACCOUNT ###########################
+################ SETTING MYSQL ACCOUNT ########################
 
 At this time, Bweb needs a write access to :
 - Location 
@@ -296,6 +305,17 @@ GRANT INSERT,UPDATE,DELETE ON bacula.LocationLog
 GRANT UPDATE (LocationId,Comment,RecyclePoolId) ON bacula.Media 
   TO 'bweb'@'%'  IDENTIFIED BY 'password';
 
-###################################################################
+################ GET MORE STATISTICS ###########################
+
+You keep Jobs informations across retention into a job_old table.
+You have to setup stat_job_table = job_old in bweb configuration.
+
+CREATE TABLE job_old (LIKE Job);
+
+And run this on crontab when you want :
+INSERT INTO job_old 
+  (SELECT * FROM Job WHERE JobId NOT IN (SELECT JobId FROM job_old) );
+
+################################################################
 
 Enjoy !