Installing bugzilla

Download Bugzilla latest

Before installing bugzilla
Install Perl 5.8:
-----------------
check by perl –v

one of the difficult modules are:
perl-GD-1.41-1.rh90.dag.i386.rpm
perl-GD-Text-Util-0.86-1.0.rh9.rf.noarch.rpm
perl-GD-Graph-1.43-1.noarch.rpm
perl-DBD-MySQL-2.1021-3.i386.rpm

perl-DBD-Pg-1.21-2
perl-DBD-SQLite-1.08-1.0.rh9.rf


Install MySQL Server:
---------------------

Follow this doc
http://www.idevelopment.info/data/MySQL/DBA_tips/Installing/LINUX4020_3.shtml

check by mysql –V
Also start mysql server
export LANG='C'
mysql-standard-4.1.14-pc-linux-gnu-i686.tar.gz

==============================================
Backing MYSQL
==============================================

Example:
mysqldump -u root -p --databases bugs > bugs.db.backup

-->To back up MySQL, log on as the root user and run:
mysqldump --opt -u user -p dbname > {path}/backup.sql

-->To restore the database run:
mysql -u user -p dbname < {path}/backup.sql

-->deleting a database
musqladmin drop


-->scripts to backup mysql database
mysqldump -u root --password='' --databases bugs > /backups/bugs.backup-11-14-06
10 22 * * * /root/bin/backup.sh /data01/bugzilla /apps/bugzilla.bkup

==============================================
Important:

While granting user permission for bugs
Make sure you change the $db_pass with your own password

==============================================
How to change passwd for user bugs?
use mysql
UPDATE user SET password=password('ClearTextHere')
WHERE
usser="dbUSER" AND
host="localhost";
flush privileges;

==============================================
# su -
# cp mysql-standard-4.0.20-pc-linux-i686.tar.gz /usr/local
# cd /usr/local
# gunzip mysql-standard-4.0.20-pc-linux-i686.tar.gz
# tar xvf mysql-standard-4.0.20-pc-linux-i686.tar
# ln -s mysql-standard-4.0.20-pc-linux-i686 mysql
# cd mysql
# scripts/mysql_install_db --user=mysql

./mysqld_safe --user=root &



Install Apache:
--------------

Install perl modules:
--------------------
to check if all perl modules are installed correctly
run ./checksetup.pl

it will show you how to install other perl modules

Example:
[root@remendit2 bugzilla]# ./checksetup.pl

Checking perl modules ...
Checking for AppConfig (v1.52) ok: found v1.56
Checking for CGI (v2.93) ok: found v3.11
Checking for Data::Dumper (any) ok: found v2.12
Checking for Date::Format (v2.21) ok: found v2.22
Checking for DBI (v1.36) ok: found v1.48
Checking for DBD::mysql (v2.1010) ok: found v3.0002
Checking for File::Spec (v0.82) ok: found v0.83
Checking for File::Temp (any) ok: found v0.13
Checking for Template (v2.08) ok: found v2.14
Checking for Text::Wrap (v2001.0131) ok: found v2001.0929

The following Perl modules are optional:
Checking for GD (v1.20) ok: found v1.41
Checking for Chart::Base (v1.0) ok: found v2.3
Checking for XML::Parser (any) ok: found v2.31
Checking for GD::Graph (any) ok: found v1.43
Checking for GD::Text::Align (any) ok: found v1.18
Checking for PatchReader (v0.9.4) ok: found v0.9.5

Checking user setup ...

This version of Bugzilla contains some variables that you may want
to change and adapt to your local settings. Please edit the file
'./localconfig' and rerun checksetup.pl

The following variables are new to localconfig since you last ran
checksetup.pl: index_html cvsbin interdiffbin diffpath create_htaccess webservergroup db_host db_pass db_sock db_check severities priorities opsys platforms

All perl modeules are important for bugzilla


Install MTA Agent:
------------------

Once you install bugzilla
you can change the template files to make customization of bugzilla look and feel
By chaning the template files.

/usr/local/bugzilla/template/en/default

/bug/create

==============================================