| |
Bugzilla is an open source Web application, bug tracking systems and testing tools used by mozilla development and use Mozilla Public License (MPL). It is often some high-tech companies such as mozilla, Red Hat and gnome use. Bugzilla originally developed by the Terry Weissman in 1998, it uses perl language, with MySQL as the backend database. It is designed to help manage a software development server software, which has a wealth of features, highly optimized database, excellent security, advanced search tools, integrated e-mail and much more.
In this tutorial, we will install bugzilla 5.0, using apache as a Web server, and enable SSL for it, and then install mysql 5.1 on freebsd 10.2 as a database system.
ready
FreeBSD 10.2 - 64 Wei
Root privileges
The first step - Update System
Freebsd server with ssh login and update software library:
sudosu
freebsd-update fetch
freebsd-update install
Step Two - Install and configure Apache
In this step we will use the pkg command to install apache freebsd software from the library, and then edit apache24 directory "httpd.conf" file to configure apache to enable SSL and CGI support.
Install apache with pkg command:
pkg install apache24
Into the apache directory and edit the "httpd.conf" file using nano editor:
cd / usr / local / etc / apache24
nano-c httpd.conf
Cancel line comments are listed below:
# Line 70
LoadModule authn_socache_module libexec / apache24 / mod_authn_socache.so
# 89th row
LoadModule socache_shmcb_module libexec / apache24 / mod_socache_shmcb.so
# Line 117
LoadModule expires_module libexec / apache24 / mod_expires.so
# 141 line, to enable SSL
LoadModule ssl_module libexec / apache24 / mod_ssl.so
# 162 line support cgi
LoadModule cgi_module libexec / apache24 / mod_cgi.so
# 174 line, enable mod_rewrite
LoadModule rewrite_module libexec / apache24 / mod_rewrite.so
# 219 line, the name of the server configuration
ServerName127.0.0.1: 80
Save and exit.
Next, we need to install the mod perl freebsd from the library, and enable it:
pkg install ap24-mod_perl2
Enable mod_perl, edit "httpd.conf" file and add "Loadmodule" line:
nano-c httpd.conf
Add the line:
# Line 175
LoadModule perl_module libexec / apache24 / mod_perl.so
Save and exit.
Before enabling apache, add the following line with sysrc command as a boot entry:
sysrc apache24_enable = yes
service apache24 start
Step Three - Install and configure the MySQL database
We use mysql 5.1 as the back-end database and supports perl module. Pkg install mysql 5.1 with the command:
pkg install p5-DBD-mysql51 mysql51-server mysql51-client
Now we have to mysql service is set to boot, and then configure the root password for the mysql.
Run the following command to complete all of these actions:
sysrc mysql_enable = yes
service mysql-server start
mysqladmin -u root password aqwe123
note:
Here mysql password: aqwe123
Configure MySQL Password
Configure MySQL Password
After the above steps are completed, we log mysql shell with root, then install the bugzilla database and create a new user.
Use the following command to log mysql shell:
mysql -u root -p
password: aqwe123
Add the database:
create database bugzilladb;
create user bugzillauser @ localhost identified by 'bugzillauser @';
. Grant all privileges on bugzilladb * to bugzillauser @ localhost identified by 'bugzillauser @';
flush privileges;
Q
Creating Database for Bugzilla
Creating Database for Bugzilla
bugzilla database created, named "bugzilladb", the user name and password are "bugzillauser" and "bugzillauser @".
Step 4 - generate a new SSL certificate
Generate "ssl" directory bugzilla site in a new self-signed SSL certificate.
Go apache24 directory and create a new directory "ssl" here:
cd / usr / local / etc / apache24 /
mkdir ssl; cd ssl
Next, generate a certificate file with the openssl command, and then change the permissions:
sudo openssl req -x509 -nodes -days 365-newkey rsa: 2048-keyout /usr/local/etc/apache24/ssl/bugzilla.key -out /usr/local/etc/apache24/ssl/bugzilla.crt
chmod600 *
Step 5 - Configuring virtual hosts
We will install bugzilla in "/ usr / local / www / bugzilla" directory, we must create a new virtual host configuration for it.
Go apache directory and create a new directory called "vhost" for the virtual host file:
cd / usr / local / etc / apache24 /
mkdir vhost; cd vhost
Now create a new file "bugzilla.conf" virtual host file:
nano-c bugzilla.conf
Paste into the following configuration:
ServerName mybugzilla.me
ServerAlias www.mybuzilla.me
DocumentRoot / usr / local / www / bugzilla
Redirect permanent / https://mybugzilla.me/
Listen 443
ServerName mybugzilla.me
DocumentRoot / usr / local / www / bugzilla
ErrorLog "/var/log/mybugzilla.me-error_log"
CustomLog "/var/log/mybugzilla.me-access_log" common
SSLEngine On
SSLCertificateFile /usr/local/etc/apache24/ssl/bugzilla.crt
SSLCertificateKeyFile /usr/local/etc/apache24/ssl/bugzilla.key
AddHandler cgi-script .cgi
Options + ExecCGI
DirectoryIndex index.cgi index.html
AllowOverride Limit FileInfo Indexes Options
Require all granted
Save and exit.
After the above are completed, create a new directory for the bugzilla install, and add a virtual host configuration file to enable bugzilla in httpd.conf virtual host.
Under "apache24" directory, run the following command:
mkdir-p / usr / local / www / bugzilla
cd / usr / local / etc / apache24 /
nano-c httpd.conf
End of the text, add the following configuration:
Include etc / apache24 / vhost / *. Conf
Save and exit.
Now with "apachectl" command to test the apache configuration and restart it:
apachectl configtest
service apache24 restart
Step Six - Install Bugzilla
We can download the source to manually install bugzilla, or may be installed from freebsd library. We will install bugzilla from freebsd library in this step with the pkg command:
pkg install bugzilla50
After the above steps are completed, go bugzilla installation directory and install all bugzilla perl modules required.
cd / usr / local / www / bugzilla
./install-module--all
Until all are completed, which takes time.
Next, perform the "checksetup.pl" file in bugzilla installation directory to generate configuration files "localconfig".
./checksetup.pl
You will see a message about database configuration errors, you must use the nano editor at "localconfig" file:
nano-c localconfig
Now add the third step is to create a database.
# Line 57
$ Db_name = 'bugzilladb';
# Line 60
$ Db_user = 'bugzillauser';
# Line 67
$ Db_pass = 'bugzillauser @';
Save and exit.
Then run again "checksetup.pl":
./checksetup.pl
You will be prompted to enter the mailbox name and administrator accounts, you just enter your email, username and password on the line.
Admin Setup
Admin Setup
Finally, we need to change the owner of the installation directory "www", and then use the service command to restart apache:
cd / usr / local / www /
chown-R www: www bugzilla
service apache24 restart
Now Bugzilla has been installed, you can access mybugzilla.me to view, and will be redirected to https connection.
in conclusion
Bugzilla is a web-based application, and can help you manage software development, it developed with perl and MySQL as the database system. Bugzilla help mozilla, RedHat, gnome and other companies to complete the software development work. Bugzilla has many features and is easy to configure and install. |
|
|
|