Talk:Bugzilla

Vote for 1-click install!

Subdomain mapping?
The main article suggests creating a new subdomain (bugs.mydomain.com) to use for bugzilla, but there aren't any additional instructions on how to point the subdomain to bugzilla's location in the file system once it's installed. Also missing is how to modify bugzilla's config to allow the subdomain to be used. I can probably figure this stuff out myself, but it'd be nice to have it here.

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, of which I am not a member, but allowing someone to run arbitrary perl code in this group sure seems like a bad idea.


 * It was a moot point at the time because of Dreamhost's setup, as it uses suexec so that the webserver runs as YOU instead of having its own user to run as, and there were instructions further down in the page to adjust the permissions to more appropriately lock it down for suexec. Current versions of Bugzilla can natively handle suexec though, so that entire part of the setup process is now moot. --Justdave 15:59, 29 May 2012 (PDT) (Bugzilla developer)


 * Setting webservergroup to the output of `group` (presumably the user doing the installing is the one the CGI runs as) seems to get rid of the world-readable attribute on localconfig, which helps me sleep a bit easier. Is there any problem with this? --Russ1 (talk) 01:25, 15 August 2012 (PDT)

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), 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... Software error: 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 For help, please send mail to this site's webmaster, giving this error message and the time and date of the error.

[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)

Installing Perl modules
Do the instructions here require the user to follow the instructions at Perl_modules first, or are they independent of each other?

--RytoEX (talk) 20:58, 25 August 2013 (PDT)