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

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Damiano Distante]

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

Comment 1

[Dave Miller [:justdave]]

Liz: not sure who this should go to... Julie (who's no longer here) used to handle these.

Comment 2

[Gervase Markham [:gerv]]

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

Comment 3

[Gervase Markham [: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:

Comment 4

[Damiano Distante]

(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: [e-mail]

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

Comment 5

[Gervase Markham [:gerv]]

OK, I have verified that the owner of [e-mail] 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

Comment 6

[Damiano Distante]

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

Comment 7

[Damiano Distante]

Attachment: Signed copy of agreement

Comment 8

[Gervase Markham [:gerv]]

This all seems in order :-) justdave/dkl/glob: who can handle getting Damiano a data dump?

Gerv

Comment 9

[:glob ✱]

(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.

Comment 10

[Gervase Markham [:gerv]]

Over to server-ops: please supply a copy of the sanitized nightly Bugzilla database dump to Damiano (contactable via this bug).

Gerv

Comment 11

[Shyam Mani [:fox2mike]]

Fixing assignee.

Comment 12

[Gervase Markham [:gerv]]

Database team: ping?

Gerv

Comment 13

[Dave Miller [:justdave]]

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.

Comment 14

[Dave Miller [: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.

Comment 15

[Damiano Distante]

Thanks a lor for your work Dave. I really appreciate.

Comment 16

[Dave Miller [:justdave]]

Dump has completed, see your email for access instructions.