ebl update regress script

[bacula/bacula] / gui / bweb / INSTALL

diff --git a/gui/bweb/INSTALL b/gui/bweb/INSTALL
index 4ef27bc559da3b34f7c0639ffb8e805d33657de6..b1c71eef66864ef8ebc3805970b2b89df4a9ada7 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
@@ -16,6 +16,8 @@ Bweb works well with 1.39 release or later.
 10) accessing to bweb
 11) setting mysql read-only account
 12) get more statistics
+13) use groups with bweb
+14) setup restoration in bweb (not yet working)
 
 ################ FILE COPY #####################################
  # you must get bweb svn files
@@ -68,6 +70,7 @@ Simply use lang/fr/tpl/*.tpl files instead of tpl/*.tpl
 
  - perl modules
     - DBI (with mysql or postgresql support DBD::Pg and DBD::mysql)
+          (SQLite is not supported)
     - GD::Graph
     - GD
     - HTML::Template
@@ -99,11 +102,11 @@ Simply use lang/fr/tpl/*.tpl files instead of tpl/*.tpl
 
  That should show you if any of the pre-requisites are missing.
  On SuSE 10.2, I was able to load all the appropriate modules via rpms,
-  with the exception of Expect and Time::ParseDate, which I loaded manually
-  using perl.
+ with the exception of Expect and Time::ParseDate, which I loaded manually
+ using perl.
 
-  If you experience problems, always consult the Apache error_log
-  file.
+ If you experience problems, always consult the Apache error_log
+ file.
 
 ################ APACHE CONFIGURATION ##########################
 
@@ -180,16 +183,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
@@ -252,8 +263,8 @@ chown www-data /var/spool/bweb
 You have to remove "<!-- Remove this to activate bfileview" and "-->" from
 tpl/display_job_zoom.tpl.
 
-You must use brestore.pl -b to initialize the database, and
-you can use bfileview.pl mode=batch jobid=xxx where=/ to compute tree size.
+You MUST use brestore.pl -b to initialize the database, and
+you CAN use bfileview.pl mode=batch jobid=xxx where=/ to compute tree size.
 
 At this time, it's a good idea to schedule brestore.pl -b after your 
 BackupCatalog job.
@@ -294,8 +305,6 @@ GRANT INSERT,UPDATE,DELETE ON bacula.Location
   TO 'bweb'@'%' IDENTIFIED BY 'password';
 GRANT INSERT,UPDATE,DELETE ON bacula.LocationLog 
   TO 'bweb'@'%' IDENTIFIED BY 'password';
-GRANT UPDATE (LocationId,Comment,RecyclePoolId) ON bacula.Media 
-  TO 'bweb'@'%'  IDENTIFIED BY 'password';
 
 ################ GET MORE STATISTICS ###########################
 
@@ -308,6 +317,36 @@ And run this on crontab when you want :
 INSERT INTO job_old 
   (SELECT * FROM Job WHERE JobId NOT IN (SELECT JobId FROM job_old) );
 
+################ USE GROUPS WITH BWEB ##########################
+
+It works with postgresql and mysql5 (4 not tested).
+With mysql, load bweb/script/bweb-mysql.sql into your catalog
+For postgresql, it will be done with bweb/script/bweb-postgresql.sql (already done)
+
+################ MADE RESTORATION WITH BWEB ####################
+
+Warning, this function is not for production use at this time !
+It will do some basics things on a working bweb/brestore setup.
+
+1) Go to http://extjs.com and download their toolkit (last 1.X release)
+
+2) Install files in /bweb/ext web root 
+ example on debian : 
+  root@localhost:~# mv ext-1.1.1 /usr/share/bweb/html/ext
+
+3) Make sure that brestore cache tables are updated with brestore.pl
+  bacula@localhost:~$ brestore.pl -b
+
+4) Enable bresto.pl cgi. 
+  edit the bweb/cgi/bresto.pl script and change $bresto_enable=0; to $bresto_enable=1;
+  on the top of the file.
+
+5) Use the last Bweb.pm
+  If you are trying bresto in a working bweb/brestore setup, you must make sure that you use 
+  the last Bweb.pm SVN version.
+
+6) Go on http://you-director/bweb/bresto.html
+
 ################################################################
 
 Enjoy !