Download reports from Bugzilla

Question

We habe a password protected Bugzilla instance and I would like to download a report in CSV form.

Using

wget $URL

or

curl $URL

I do not get any error, no authentication request. Bugzilla just delivers a 0 bytes file

The same happens with a browser. If I type the URL in I get the empty file. If I log in on any Bugzilla page before than the Bugilla will deliver the file.

Is there a way to authenticate from the command line, store the cookie and then fetch the report using the same cookies?

Answer 1

Ok maybe there are better solutions but it can be done with a little Perl script

#!/usr/bin/perl

use strict;
use warnings;

use WWW::Mechanize;
use Readonly;

Readonly::Scalar my $base_url => 'https://example.org';
Readonly::Scalar my $url      => "$base_url/bugzilla/report.cgi?...&ctype=csv&format=table";

# just as an example: put them in a property file
Readonly::Scalar my $username => 'USERNAME';
Readonly::Scalar my $password => 'PASSWORD';

my $mech = WWW::Mechanize->new();

$mech->get("$url&GoAheadAndLogIn=1");

my %login = (
    "Bugzilla_login"=> $username,
    "Bugzilla_password"=> $password
);
$mech->set_fields(%login);
$mech->submit( 'GoAheadAndLogIn' );
$mech->get( $url );
$mech->save_content( 'name.csv' );

1;