Running Bugzilla - Webaccess required

As I spent some time figuring out how to get Bugzilla running on the on our NAS (2100) I would like to share the actions I had to take to get it working.
Again this is provided as-is. I had to install some packages which also upgraded existing packages so you probably loose support when you do this.

Maybe someone can convert it into a supported add-on…

I had to start from a factory default installation and upgraded to the latest release (4.2.21)

Install official ReayNAS photos so MySQL is configured correctly !!!

install build tools
apt-get upgrade
apt-get install build-essential

Switch to lenny distribution in /etc/apt/sources.list

deb http://archive.debian.org/debian lenny main  

Update keys

gpg --keyserver pgpkeys.mit.edu --recv-key AED4B06F473041FA
gpg -a --export  AED4B06F473041FA|apt-key add -

Retrieve aptitude as it resolves better the dependencies than apt-get (only way I could install libmysqlclient15-dev which is required by one of the perl packages)

apt-get install aptitude
aptitude update
aptitude install libmysqlclient15-dev
aptitude install libgd2-xpm-dev

Switch to back to etch distribution in /etc/apt/sources.list

deb http://archive.debian.org/debian etch main  

Install bugzilla

useradd –g admin Bugzilla 
passwd Bugzilla (Choose your password)
mkdir /home/bugzilla
chown bugzilla:admin /home/bugzilla 

mkdir /c/.bugzilla
ln -s /c/.bugzilla /opt/bugzilla
chown – R bugzilla:admin /c/.bugzilla

su - bugzilla
cd /opt/bugzilla

wget http://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-4.2.1.tar.gz
tar xvfz bugzilla-4.2.1.tar.gz
ln -s bugzilla bugzilla-4.2.1

cd bugzilla-4.2.1

/usr/bin/perl install-module.pl --all

./checksetup.pl --check-modules

Edit the localconfig

$webservergroup = 'admin';
$db_pass = 'bugs';
$index_html = 1;       

Add the MySQL user

mysql

CREATE USER 'bugs'@'localhost' IDENTIFIED BY 'bugs';
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES, CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.*  TO bugs@localhost IDENTIFIED BY 'bugs';
FLUSH PRIVILEGES;

SHOW GRANTS FOR 'bugs'@'localhost';

Launch Install

./checksetup.pl

Add Bugzilla as an addon to frontview Apache

echo "Alias /bugzilla /opt/bugzilla/bugzilla" >/etc/frontview/apache/addons/BUGZILLA.conf
echo "<Location /bugzilla>" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "</Location>" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "<Directory /opt/bugzilla/bugzilla>" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "    AddHandler cgi-script .cgi" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "    AllowOverride       All" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "    Options             +Indexes +ExecCGI" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "    Order               allow,deny" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "    Allow               from all" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "    DirectoryIndex      index.html index.cgi" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "    AllowOverride Limit FileInfo Indexes" >>/etc/frontview/apache/addons/BUGZILLA.conf
echo "</Directory>" >>/etc/frontview/apache/addons/BUGZILLA.conf

chown admin:admin /etc/frontview/apache/addons/BUGZILLA.conf
chown -R bugzilla:admin /opt/bugzilla

Restart apache

apache-ssl -f /etc/frontview/apache/httpd.conf -k restart

Additionally setup polling of an email account

apt-get install fetchmail
apt-get install postfix

echo "poll mail.xyz-c.com" > ~/.fetchmailrc
echo "        proto pop3" >> ~/.fetchmailrc
echo "        auth password" >> ~/.fetchmailrc
echo "        user \"bugreport\"" >> ~/.fetchmailrc
echo "        pass \"mypassword \"" >> ~/.fetchmailrc
echo "        is bugzilla" >> ~/.fetchmailrc
echo "        keep" >> ~/.fetchmailrc

echo "\"| /opt/bugzilla/bugzilla/email_in.pl --default component=UI --default op_sys=All --default product=MyProduct --default rep_platform=All --default version=1.0 -vvvvvvvvv >> /home/bugzilla/email-import.log 2>&1\"" > ~/.forward

chmod 710 .fetchmailrc