Setup bugzilla on Ubuntu

prepare:
1 apache
$sudo apt-get install apache2
2 mysqlserver
$sudo apt-get install mysql-server
ps: after installed, you need to input password for root(user of adminstrator group, not user group, please keep the password in mind)
3 sendmail
sudo apt-get install sendmail
4 download bugzilla package from http://www.bugzilla.org/



I downloaded  bugzilla-3.6.3.tar.gz

extract the package

$tar -C /var/www/ -xvf bugzilla-3.6.3.tar.gz
rename
$mv bugzilla-3.6.3 bugzilla & cd /var/www/bugzilla/
checkset up 
$sudo perl checksetup.pl 
$/usr/bin/perl install-module.pl --all

configure bugzillla with mysql

the default database name is "bugs", the default database root account is "bugs" too(empty password by default), all these are writed in localconfig


so let's create a admin user "bugs" via mysql
enter mysql
$mysql -u root -p 
input the password I mentened before
create bugs user
$grant all on *.* to bugs@localhost identified by '';flush privileges;
create bugs database
$CREATE DATABASE bugs;

configure bugzilla with apache
modify localconfig, let $webservergroup = 'www-data'
why 'www-data', it is apache env vars in
/etc/apache2/envvars
# settings are defined via environment variables and then used in apache2ctl,
# /etc/init.d/apache2, /etc/logrotate.d/apache2, etc.
export APACHE_RUN_USER=www-data
export APACHE_RUN_GROUP=www-data

and change the owner and group of bugzilla directory.
$sudo chgrp -R root.www-data bugzilla

then do check setup again.
$sudo perl checksetup.pl
please remember the root account and password that you input in this step. 

Above all, bugzilla install and configure are done.
The last step, we need to configure appach2 server for /var/www/bugzilla

$sudo vi /etc/apache2/httpd.conf
add below content
  <Directory "/var/www/bugzilla/">
        AddHandler cgi-script .cgi 
        Options +Indexs +ExecCGI +FollowSymLinks
        DirectoryIndex index.cgi
        AllowOverride None
        Order allow,deny
        Allow from all
    </Directory>

ok, configure done, let's restart appache2 server and mysql server
$sudo /etc/init.d/apache2 restart & sudo /etc/init.d/mysql restart

let's browser bugzilla index via firefox finally
$firefox http://localhost/bugzilla