927338 - researcher want to know the bugzilla database information

Status: RESOLVED WONTFIX

(bugzilla.mozilla.org :: Administration, task)

Description

[louffyzhang]

User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.66 Safari/537.36

Steps to reproduce:

I am a master's student at Peking University, I want to help http://bugzilla.gnome.org, make the sanitized data open for researchers. Here are the relevant information of mozilla and gnome, https://bugzilla.mozilla.org/show_bug.cgi?id=838947. https://bugzilla.gnome.org/show_bug.cgi?id=693295 . I got the data and related scripts of mozilla and study them.
Now I have two problems.
1, I want to know Database programming API and related docs of bugzilla(such as version 4.4),I
want to know details of the database table and what is special, such as related to security, privacy and so on.
2, Gnome using bugzilla version = "3.4.13", mozilla using "4.2.6 +". I want to know the different aspects of the different versions of the database.

Here is the mozilla data: http://people.mozilla.org/ ~ mhoye / bugzilla /
Here is the mozilla script: http://bzr.mozilla.org/bmo/4.0/annotate/head:/contrib/sanitizeme.pl

Comment 1

[Frédéric Buclin]

(not sure how MoCo deals with such requests. bmo is not the right place for this, IMO)

Comment 2

[Andre Klapper]

(In reply to louffyzhang from comment #0)
> 1, I want to know Database programming API and related docs of bugzilla(such
> as version 4.4),I
> want to know details of the database table and what is special, such as
> related to security, privacy and so on.

Sourcecode is on bzr.mozilla.org and group permissions are explained in the docs on http://www.bugzilla.org/docs/ . Not sure what specificially you want to know.

> 2, Gnome using bugzilla version = "3.4.13", mozilla using "4.2.6 +". I want
> to know the different aspects of the different versions of the database.

Read the release notes between 3.4 and 4.2, and compare installed extensions? Again, not sure what you're asking for.

Comment 3

[Dave Miller [:justdave]]

If I'm reading the initial request correctly it sounds like he's trying to make the sanitizeme.pl script work on GNOME's Bugzilla database, and likely they've got schema differences or something.  I think Sheeri has worked on this on our side.  Andre is the GNOME maintainer, right? I see him CCed already.

As for the questions, it's not really clear from your request what information you actually need.  IIRC the script is pretty well documented in the comments within the script as to what data it's removing and why.  If you can explain better where you're actually confused (or confirm if I'm on the right track about what you're trying to accomplish) maybe we can help.

Comment 4

[Sheeri Cabral [:sheeri]]

I run the scripts against our backups to create sanitized information, but the bugzilla engineers (like :glob and :dkl) are the ones who maintain and develop the script...which is part of the source code, so it should be able to be read.

Comment 5

[louffyzhang]

Well,I think I am not a good student.I should read sanitizeme.pl more and run it on my test data.Many thanks!

Comment 6

[Andre Klapper]

(In reply to Dave Miller [:justdave] ([e-mail]) from comment #3)
> make the sanitizeme.pl script work on GNOME's Bugzilla database, and likely
> they've got schema differences or something.  I think Sheeri has worked on
> this on our side.  Andre is the GNOME maintainer, right?

GNOME Bugzilla has a lot of DB schema changes (which is one reason why it's complicated to upgrade though a GNOME sysadmin is now looking into that).

Comment 7

[David Lawrence [:dkl]]

Just closing as WONTFIX as reporter needs to make customizations to the sanitizeme.pl script to work with the gnome.org schema. 

dkl