Talk:Bugzilla
Contents |
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)
success with 3.6.3, on 2011.01.01
dvb@omino.com here. Reporting it went quite smoothly following
==> wget http://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-STABLE.tar.gz ==> untar ==> cd into it ==> ./checksetup.pl and, to attempt installing all missing modules ==> /usr/bin/perl install-module.pl --all
Had to run install-module.pl --all a couple of times, no changes, til it finally said all done.
--dvb 12:03, 1 Jan 2011 (PDT)
