The main author of Bweb is Eric Bollengier.
The main author of Bacula is Kern Sibbald, with contributions from
many others, a complete list can be found in the file AUTHORS.
-
This program is Free Software; you can redistribute it and/or
- modify it under the terms of version two of the GNU General Public
- License as published by the Free Software Foundation plus additions
- that are listed in the file LICENSE.
+ modify it under the terms of version three of the GNU Affero General Public
+ License as published by the Free Software Foundation and included
+ in the file LICENSE.
This program is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
- General Public License for more details.
+ Affero General Public License for more details.
- You should have received a copy of the GNU General Public License
+ You should have received a copy of the GNU Affero General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
02110-1301, USA.
- Bacula® is a registered trademark of John Walker.
+ Bacula® is a registered trademark of Kern Sibbald.
The licensor of Bacula is the Free Software Foundation Europe
- (FSFE), Fiduciary Program, Sumatrastrasse 25, 8006 Zurich,
+ (FSFE), Fiduciary Program, Sumatrastrasse 25, 8006 Zürich,
Switzerland, email:ftf@fsfeurope.org.
=head1 VERSION
# Job table keep use Media or Job retention, so it's quite enought
# for good statistics
-# CREATE TABLE job_old (LIKE Job);
-# INSERT INTO job_old
-# (SELECT * FROM Job WHERE JobId NOT IN (SELECT JobId FROM job_old) );
-my $jobt = $conf->{stat_job_table} || 'Job';
+# CREATE TABLE JobHistory (LIKE Job);
+# INSERT INTO JobHistory
+# (SELECT * FROM Job WHERE JobId NOT IN (SELECT JobId FROM JobHistory) );
+my $jobt = $bweb->get_stat_table();
my $graph = CGI::param('graph') || 'job_size';
my $legend = CGI::param('legend') || 'on' ;
$legend = ($legend eq 'on')?1:0;
my $arg = $bweb->get_form(qw/width height limit offset age where jobid
- jfilesets level status jjobnames jclients/);
+ jfilesets level status jjobnames jclients jclient_groups/);
my ($limitq, $label) = $bweb->get_limit(age => $arg->{age},
limit => $arg->{limit},
offset=> $arg->{offset},
- order => "$jobt.StartTime ASC",
+ order => "Job.StartTime ASC",
);
my $statusq='';
if ($arg->{status} and $arg->{status} ne 'Any') {
- $statusq = " AND $jobt.JobStatus = '$arg->{status}' ";
+ $statusq = " AND Job.JobStatus = '$arg->{status}' ";
}
my $levelq='';
-if ($arg->{level} and $arg->{level} ne 'Any') {
- $levelq = " AND $jobt.Level = '$arg->{level}' ";
+if ($arg->{level} and $arg->{level} !~ 'All|Any') {
+ $levelq = " AND Job.Level = '$arg->{level}' ";
}
my $filesetq='';
my $jobnameq='';
if ($arg->{jjobnames}) {
- $jobnameq = " AND $jobt.Name IN ($arg->{jjobnames}) ";
+ $jobnameq = " AND Job.Name IN ($arg->{jjobnames}) ";
} else {
$arg->{jjobnames} = 'all'; # skip warning
}
$arg->{jclients} = 'all'; # skip warning
}
+my $groupf=''; # from clause
+my $groupq=''; # where clause
+if ($arg->{jclient_groups}) {
+ $groupf = " JOIN client_group_member ON (Client.ClientId = client_group_member.clientid)
+ JOIN client_group USING (client_group_id)";
+ $groupq = " AND client_group_name IN ($arg->{jclient_groups}) ";
+}
+
+$bweb->can_do('r_view_stat');
+my $filter = $bweb->get_client_filter();
+
my $gtype = CGI::param('gtype') || 'bars';
+
+# in this mode, we generate an image and an imagemap
+if ($gtype eq 'balloon') {
+ use Digest::MD5 qw(md5_hex);
+ use GBalloon;
+
+ my $b = new GBalloon(width=>$arg->{width},
+ height =>$arg->{height});
+
+ my $order;
+ my %legend = (x_title => 'Time',
+ x_func => sub {
+ POSIX::strftime('%H:%M', gmtime($_[0]))
+ }
+ ) ;
+ if ($graph eq 'job_time_size') {
+ $order = 'JobFiles,JobBytes';
+
+ $legend{y_title} = 'Nb files';
+ $legend{y_func} = sub { int(shift)};
+ $legend{z_title} = 'Size';
+ $legend{z_func} = \&Bweb::human_size;
+ } else {
+ $order = 'JobBytes,JobFiles';
+
+ $legend{y_title} = 'Size';
+ $legend{y_func} = \&Bweb::human_size;
+ $legend{z_title} = 'Nb files';
+ $legend{z_func} = sub { int(shift)};
+ }
+
+ $b->set_legend_axis(%legend);
+
+ my $all = $dbh->selectall_arrayref("
+SELECT $bweb->{sql}->{SEC_TO_INT}( $bweb->{sql}->{UNIX_TIMESTAMP}(EndTime)
+ - $bweb->{sql}->{UNIX_TIMESTAMP}(StartTime))
+ AS duration, $order, JobId, Job.Name
+
+ FROM $jobt AS Job, Client $filter $groupf
+WHERE Job.ClientId = Client.ClientId
+ AND Job.Type = 'B'
+ $clientq
+ $statusq
+ $levelq
+ $jobnameq
+ $groupq
+$limitq
+");
+
+ foreach my $a (@$all) {
+ $b->add_point($a->[0], $a->[1], $a->[2],
+ "?action=job_zoom;jobid=$a->[3]",
+ "$a->[4] $legend{z_title} " . $legend{z_func}($a->[2]));
+ }
+
+ $b->init_gd();
+ $b->finalize();
+
+ my $md5_rep = md5_hex(join(":", map { $arg->{$_} } sort keys %$arg));
+
+ # need to cleanup this path
+ open(FP, ">$conf->{fv_write_path}/$md5_rep.png");
+ print FP $GBalloon::gd->png;
+ close(FP);
+
+ print $b->get_imagemap("Job overview", "/bweb/fv/$md5_rep.png");
+
+ exit 0;
+}
+
print CGI::header('image/png');
sub get_graph
{
my (@options) = @_;
my $graph;
+ use GD::Graph::colour qw(:colours);
+
if ($gtype eq 'lines') {
use GD::Graph::lines;
$graph = GD::Graph::lines->new ( $arg->{width}, $arg->{height} );
$graph->set('x_label' => 'Time',
'x_number_format' => sub { strftime('%D', localtime($_[0])) },
- 'x_tick_number' => 1,
+ 'x_tick_number' => 5*$arg->{width}/800,
+ 'overwrite' => 1,
+ dclrs => [ "lred", add_colour("#008e8e"),
+ add_colour("#afd8f8"), add_colour("#f6bd0f"),
+ add_colour("#8bba00"), add_colour("#ff8e46"),
+ add_colour("#d64646"),
+ add_colour("#8e468e"), add_colour("#588526"),
+ add_colour("#b3aa00"), add_colour("#008ed6"),
+ add_colour("#9d080d"), add_colour("#a186be"),
+ ],
@options,
);
-
+ if ($conf->{graph_font} && -f $conf->{graph_font}) {
+ $graph->set_title_font([$conf->{graph_font}], 12);
+ $graph->set_legend_font([$conf->{graph_font}], 11);
+ }
return $graph;
}
foreach my $row (@$all_row) {
my $label = $row->[1] . "/" . $row->[2] ; # client/backup name
+ if ($arg->{level} && $arg->{level} eq 'All') { # can separate level
+ $label = $row->[4] . ': ' . $label; # if users ask for
+ }
+
$ret->{date}->[$i] = $row->[0];
$ret->{$label}->[$i] = $row->[3];
$i++;
my $query = "
SELECT
- UNIX_TIMESTAMP($jobt.StartTime) AS starttime,
- Client.Name AS clientname,
- $jobt.Name AS jobname,
- $jobt.JobBytes AS jobbytes
-FROM $jobt, Client, FileSet
-WHERE $jobt.ClientId = Client.ClientId
- AND $jobt.FileSetId = FileSet.FileSetId
- AND $jobt.Type = 'B'
+ UNIX_TIMESTAMP(Job.StartTime) AS starttime,
+ Client.Name AS clientname,
+ Job.Name AS jobname,
+ Job.JobBytes AS jobbytes,
+ Job.Level AS joblevel
+FROM $jobt AS Job, FileSet, Client $filter $groupf
+WHERE Job.ClientId = Client.ClientId
+ AND Job.FileSetId = FileSet.FileSetId
+ AND Job.Type = 'B'
$clientq
$statusq
$filesetq
$levelq
$jobnameq
+ $groupq
$limitq
";
my $query = "
SELECT
- UNIX_TIMESTAMP($jobt.StartTime) AS starttime,
- Client.Name AS clientname,
- $jobt.Name AS jobname,
- $jobt.JobFiles AS jobfiles
-FROM $jobt, Client, FileSet
-WHERE $jobt.ClientId = Client.ClientId
- AND $jobt.FileSetId = FileSet.FileSetId
- AND $jobt.Type = 'B'
+ UNIX_TIMESTAMP(Job.StartTime) AS starttime,
+ Client.Name AS clientname,
+ Job.Name AS jobname,
+ Job.JobFiles AS jobfiles,
+ Job.Level AS joblevel
+FROM $jobt AS Job, FileSet, Client $filter $groupf
+WHERE Job.ClientId = Client.ClientId
+ AND Job.FileSetId = FileSet.FileSetId
+ AND Job.Type = 'B'
$clientq
$statusq
$filesetq
$levelq
$jobnameq
+ $groupq
$limitq
";
}
# it works only with postgresql at this time
-# we dont use $jobt because we use File, so job is in Job table
+# we don't use $jobt because we use File, so job is in Job table
elsif ($graph eq 'file_histo' and $arg->{where}) {
my $dir = $dbh->quote(dirname($arg->{where}) . '/');
SELECT UNIX_TIMESTAMP(Job.StartTime) AS starttime,
Client.Name AS client,
Job.Name AS jobname,
- base64_decode_lstat(8,LStat) AS lstat
+ base64_decode_lstat(8,LStat) AS lstat,
+ Job.Level AS joblevel
-FROM Job, Client, FileSet, Filename, Path, File
+FROM Job, FileSet, Filename, Path, File, Client $filter
WHERE Job.ClientId = Client.ClientId
AND Job.FileSetId = FileSet.FileSetId
AND Job.Type = 'B'
SELECT UNIX_TIMESTAMP(Job.StartTime) AS starttime,
Client.Name AS client,
Job.Name AS jobname,
- brestore_pathvisibility.size AS size
+ brestore_pathvisibility.size AS size,
+ Job.Level AS joblevel
-FROM Job, Client, FileSet, Path, brestore_pathvisibility
+FROM Job, Client $filter, FileSet, Path, brestore_pathvisibility
WHERE Job.ClientId = Client.ClientId
AND Job.FileSetId = FileSet.FileSetId
AND Job.Type = 'B'
my $query = "
SELECT
- UNIX_TIMESTAMP($jobt.StartTime) AS starttime,
- Client.Name AS clientname,
- $jobt.Name AS jobname,
- $jobt.JobBytes /
+ UNIX_TIMESTAMP(Job.StartTime) AS starttime,
+ Client.Name AS clientname,
+ Job.Name AS jobname,
+ Job.JobBytes /
($bweb->{sql}->{SEC_TO_INT}(
$bweb->{sql}->{UNIX_TIMESTAMP}(EndTime)
- $bweb->{sql}->{UNIX_TIMESTAMP}(StartTime)) + 0.01)
- AS rate
+ AS rate,
+ Job.Level AS joblevel
-FROM $jobt, Client, FileSet
-WHERE $jobt.ClientId = Client.ClientId
- AND $jobt.FileSetId = FileSet.FileSetId
- AND $jobt.Type = 'B'
+FROM $jobt AS Job, FileSet, Client $filter $groupf
+WHERE Job.ClientId = Client.ClientId
+ AND Job.FileSetId = FileSet.FileSetId
+ AND Job.Type = 'B'
$clientq
$statusq
$filesetq
$levelq
$jobnameq
+ $groupq
$limitq
";
my $query = "
SELECT
- UNIX_TIMESTAMP($jobt.StartTime) AS starttime,
- Client.Name AS clientname,
- $jobt.Name AS jobname,
+ UNIX_TIMESTAMP(Job.StartTime) AS starttime,
+ Client.Name AS clientname,
+ Job.Name AS jobname,
$bweb->{sql}->{SEC_TO_INT}( $bweb->{sql}->{UNIX_TIMESTAMP}(EndTime)
- $bweb->{sql}->{UNIX_TIMESTAMP}(StartTime))
- AS duration
-FROM $jobt, Client, FileSet
-WHERE $jobt.ClientId = Client.ClientId
- AND $jobt.FileSetId = FileSet.FileSetId
- AND $jobt.Type = 'B'
+ AS duration,
+ Job.Level AS joblevel
+
+FROM $jobt AS Job, FileSet, Client $filter $groupf
+WHERE Job.ClientId = Client.ClientId
+ AND Job.FileSetId = FileSet.FileSetId
+ AND Job.Type = 'B'
$clientq
$statusq
$filesetq
$levelq
$jobnameq
+ $groupq
$limitq
";
limit => $arg->{limit},
offset=> $arg->{offset},
groupby => "A",
+ order => "A",
);
my @arg; # arg for plotting
}
my $stime = $bweb->{sql}->{"STARTTIME_$d"};
- $stime =~ s/Job\./$jobt\./;
my $query = "
SELECT
" . ($per_t?"":"UNIX_TIMESTAMP") . "($stime) AS A,
$t(JobBytes) AS nb
-FROM $jobt, Client, FileSet
-WHERE $jobt.ClientId = Client.ClientId
- AND $jobt.FileSetId = FileSet.FileSetId
- AND $jobt.Type = 'B'
+FROM $jobt AS Job, FileSet, Client $filter $groupf
+WHERE Job.ClientId = Client.ClientId
+ AND Job.FileSetId = FileSet.FileSetId
+ AND Job.Type = 'B'
$clientq
$statusq
$filesetq
$levelq
$jobnameq
+ $groupq
$limit
";
);
my $all = $dbh->selectall_arrayref($query) ;
+# print STDERR Data::Dumper::Dumper($all);
my ($ret) = make_tab_sum($all);
print $obj->plot([$ret->{date}, $ret->{nb}])->png;
-}
+}
+
+$dbh->disconnect();