Request of a sanitized copy of the Bugzilla database for research purposes

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
6 years ago
3 years ago

People

(Reporter: Damiano Distante, Assigned: justdave)

Tracking

Details

Attachments

(1 attachment)

(Reporter)

Description

6 years ago
User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.5; rv:10.0.2) Gecko/20100101 Firefox/10.0.2
Build ID: 20120215223356

Updated

6 years ago
Assignee: administration → nobody
Component: Administration → General
Product: Bugzilla → bugzilla.mozilla.org
QA Contact: default-qa → general
Version: unspecified → Current

Updated

6 years ago
Group: bugzilla-security → webtools-security

Updated

6 years ago
Component: General → Administration
QA Contact: general → administation
Liz: not sure who this should go to... Julie (who's no longer here) used to handle these.
Group: webtools-security
Status: UNCONFIRMED → NEW
Ever confirmed: true
I can handle standard requests.

Damiano: we'll need evidence that you are a researcher at a recognised academic institution. You've created your Bugzilla account with a Gmail address, so that doesn't help :-| Can you point us to a departmental web page on which you are listed, and give the academic email address of your supervisor so I can check with them?

After that, you'll need to print, sign, scan and attach a copy of the text in the next comment.

Gerv
Agreement for Receipt and Use of Bugzilla Data

Thank you for contacting us about using the Bugzilla database for the public
good. We are happy to work with you and provide access to you free of any
charge. 

In exchange for receipt and right to use data from Mozilla’s Bugzilla system,
you agree to the following:

*you will only use the data for purposes that benefit the public in some way
and will not use the data for a purpose that harms users or violates any
applicable laws;

* you will not use the data to exploit or sell security flaws in any Mozilla
product or potential product, and will disclose first to Mozilla any security
flaws you do identify;

*you will not attempt to identify the source of the data or
otherwise seek to extract any personal information from the data, such as
correlating the data with other non-Mozilla data sources or otherwise seeking to determine the names or other personal information of those whose data is provided to you;

*you will not share or transfer the data to any third party.  If you want to
share the data with a collaborator, please have her/him contact Mozilla and sign
this agreement first.

*In the event you are acquired or cease operations or have a change of control,
all your rights to the data cease.

* Mozilla does not make any representations or warranties about the data and
you receive it on an AS-IS basis and acknowledge that by its nature it contains
bugs, viruses, and errors. Mozilla expressly disclaims any implied warranties
of non-infringement, satisfactory quality, fitness for a particular purpose,
and merchantability.  The UN Convention on the International Sale of Goods is
expressly disclaimed.

* Mozilla’s total aggregate liability under this agreement shall not exceed
US$50.

* No agency or other relationship is created by this agreement.

* This Agreement shall be governed by California law without regard to its
conflict of law provisions. In the event of a dispute related to this
Agreement, you consent to the personal jurisdiction of California and agree not
to bring an action against Mozilla except in the state and federal courts of
California, USA.

Signed:  ______________________________
Name:    ______________________________
Date:      ______________________________

Nature and Purpose of Data Use:
Assignee: nobody → gerv
(Reporter)

Comment 4

6 years ago
(In reply to Gervase Markham [:gerv] from comment #2)
> I can handle standard requests.
> 
> Damiano: we'll need evidence that you are a researcher at a recognised
> academic institution. You've created your Bugzilla account with a Gmail
> address, so that doesn't help :-| Can you point us to a departmental web
> page on which you are listed, and give the academic email address of your
> supervisor so I can check with them?
> 
> After that, you'll need to print, sign, scan and attach a copy of the text
> in the next comment.
> 
> Gerv

Hi Gerv,

this is the url of the web page of my University Web site on which I'm listed (sorry, it is in Italian):  
http://www.unitelma.it/content/dott-damiano-distante
I work there as Assistant Professor in Computer Science.

I registered to the Mozilla BTS using my gmail email address for privacy concerns, but my institutional email address is: damiano.distante@unitelma.it

Let me know if you need o contact a supervisor of mines, in this case I'll send you the email address of the Faculty Dean or of the Rector.

Damiano
OK, I have verified that the owner of damiano.distante@unitelma.it is the guy who filed this bug :-) Now all we need is the agreement in comment #3.

What do you plan to use the data for?

Gerv
(Reporter)

Comment 6

6 years ago
Hi Gerv,
we mean to apply information retrieval and text mining techniques in order to possibly define methods and tools to support project leaders and software developers of the Mozilla open-source community during the bug triaging and assignment phases of the bugs life cycle.
I'm sending you a signed copy of the agreement in Comment #3 via email.
Thanks for your support,
Damiano
(Reporter)

Comment 7

6 years ago
Created attachment 599113 [details]
Signed copy of agreement
This all seems in order :-) justdave/dkl/glob: who can handle getting Damiano a data dump?

Gerv
(In reply to Gervase Markham [:gerv] from comment #8)
> This all seems in order :-) justdave/dkl/glob: who can handle getting
> Damiano a data dump?

neither dkl or i have access to the database, so it will have to be someone in IT.
Over to server-ops: please supply a copy of the sanitized nightly Bugzilla database dump to Damiano (contactable via this bug).

Gerv
Assignee: gerv → server-ops
Fixing assignee.
Assignee: server-ops → server-ops-database
Database team: ping?

Gerv
Component: Administration → Server Operations: Database
Product: bugzilla.mozilla.org → mozilla.org
QA Contact: administration → cshields
Version: Current → other
Our automatic sanitizer cron job appears to be busted again (the way the script works got changed upstream, and we apparently didn't fix the cron job to deal with the New Way since the last Bugzilla upgrade).

I've got one running by hand right now.
Assignee: server-ops-database → justdave
Just FYI it's still going... there's multiple steps to it and each step takes several hours to run, and since it's going manually, we're losing a few hours between steps since I don't know exactly when it'll finish and have to go back and look every so often.  Also took a while just to get it running because the code was out-of-date on that box.
(Reporter)

Comment 15

6 years ago
Thanks a lor for your work Dave. I really appreciate.
Dump has completed, see your email for access instructions.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.