Talk:Bugzilla

From DreamHost

Vote for 1-click install!

Contents 1 Security problems? 2 Error running queries 2.1 Software error: 2.2 Solution 2.3 Problem installing 2.22

Security problems?

The main article advises you to set the bugzilla's group entry to an empty string (""). However, the bugzilla checksetup.pl script seems to advice against this in no uncertain terms:

This means that _anyone_ who can obtain
local access to this machine can do whatever they want to your Bugzilla
installation, and is probably also able to run arbitrary Perl code as the
user that the webserver runs as. 

You really, really, really need to change this setting.

So, is this something I need to worry about, or is this point moot because of the setup on dreamhost? I don't know what group DH's webserver runs in, but I think it is dhapache, of which I am not a member, but allowing someone to run arbitrary perl code in this group sure seems like a bad idea.

Error running queries

I get the following error when I run any query. Everything else seems to work just fine, and I also don't understand the error, because the column it complains about (bugs.qa_contact) exists in the database. I tried running the same query inside phpmysql, and I get the same error.

Software error:

SELECT DISTINCT bugs.bug_id, bugs.groupset, bugs.bug_severity, bugs.priority, bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc FROM bugs, profiles map_assigned_to, profiles map_reporter LEFT JOIN profiles map_qa_contact ON bugs.qa_contact = map_qa_contact.userid LEFT JOIN cc selectVisible_cc ON 
                     bugs.bug_id = selectVisible_cc.bug_id AND 
                     selectVisible_cc.who = 2 WHERE ((bugs.groupset & 127) = bugs.groupset OR (bugs.reporter_accessible = 1 AND bugs.reporter = 2) OR (bugs.cclist_accessible = 1 AND selectVisible_cc.who = 2 AND not isnull(selectVisible_cc.who)) OR (bugs.assigned_to = 2)) AND bugs.assigned_to = map_assigned_to.userid AND bugs.reporter = map_reporter.userid AND bugs.assigned_to = map_assigned_to.userid AND bugs.reporter = map_reporter.userid AND (bugs.bug_status = 'NEW' OR bugs.bug_status = 'ASSIGNED' OR bugs.bug_status = 'REOPENED') AND (map_assigned_to.login_name = 'xxxx@xxx' OR map_reporter.login_name = 'xxxx@xxxxx'): Unknown column 'bugs.qa_contact' in 'on clause' at globals.pl line 276.

For help, please send mail to the webmaster, giving this error message and the time and date of the error.

Solution

After adding the above, I found this post in the discussion forums, which addresses exactly my issue. So I went about installing Bugzilla 2.20, which ultimately solved my problems. However, that was not entirely straightforward, either. When running checksetup.pl (step 10 in Bugzilla#Configuring_Bugzilla), the script would invariably die complaining that it could not rename the column votes.count to votes.vote_count.

Populating duplicates table...
Changing column count in table votes to be named vote_count...
DBD::mysql::db do failed: Unknown column 'count' in 'votes' at Bugzilla/DB.pm line 600
        Bugzilla::DB::bz_rename_column('Bugzilla::DB::Mysql=HASH(0x8ca72e4)', 'votes', 'count', 'vote_count') called at ./checksetup.pl line 3729

The hack I used to get around this was to comment out line 3729 in checksetup.pl:

   $dbh->bz_rename_column('votes', 'count', 'vote_count');

and manually rename the aforementioned column using phpmyadmin.

Then everything worked fine. --Fulvio 15:44, 24 Sep 2006 (PDT)

Problem installing 2.22

Note: I moved this from the article page. It had been there a long time and 3.0 is out now... --Merit 18:26, 28 June 2007 (PDT)

I have a problem installing 2.22 on my dreamhost account:

Resizing attachments.filename from mediumtext to varchar(100). Updating column filename in table attachments ... Old: mediumtext NOT NULL New: varchar(100) NOT NULL Dropping table shadowlog... Changing column count in table votes to be named vote_count... <h1>Software error:</h1> <pre>DBD::mysql::db do failed: Invalid default value for 'vote_count' at Bugzilla/DB.pm line 611 Bugzilla::DB::bz_rename_column('Bugzilla::DB::Mysql=HASH(0xa39662c)', 'votes', 'count', 'vot e_count') called at ./checksetup.pl line 3777 </pre> <p> For help, please send mail to this site's webmaster, giving this error message and the time and date of the error. </p> [Wed Jul 19 04:04:36 2006] checksetup.pl: DBD::mysql::db do failed: Invalid default value for 'vote_ count' at Bugzilla/DB.pm line 611 [Wed Jul 19 04:04:36 2006] checksetup.pl: Bugzilla::DB::bz_rename_column('Bugzilla::DB::Mysql= HASH(0xa39662c)', 'votes', 'count', 'vote_count') called at ./checksetup.pl line 3777

--Bschiett 04:18, 19 Jul 2006 (PDT)