Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Server \ On FreeBSD 10.2 Bugzilla how to install and configure Apache SSL     - Hadoop2.6.3 build clusters and the development of MapReduce WIN7 by Eclipse on Linux demo (Server)

- Ubuntu disable graphics card (Linux)

- grub boot error resolution examples (Linux)

- Ubuntu firewall installation and configuration (Linux)

- MySQL query plan key_len know all (Database)

- CV: Linux command displays the progress of the run command (Linux)

- C ++ CBitmap, HBitmap, Bitmap difference and contact (Programming)

- Linux command Detailed chpasswd bulk edit user password (Linux)

- Linux Apache server configure to protect system security (Linux)

- Ubuntu set Swap Space Tutorial (Linux)

- Examples of testing and installation Mesos on CentOS (Linux)

- Ceph single / multi-node installation summary Powered by CentOS 6.x (Server)

- Ubuntu: HDF5 error: HDF5 header version does not match with the HDF5 library (Linux)

- CentOS 6.5 three ways to configure the IP address (Linux)

- Oracle 11g RMAN cross-platform transfer table space (Database)

- Zabbix monitoring different versions of RAID installation and monitoring and MySQL master-slave monitor (Server)

- Linux kernel update error, update-initramfs: failed Solution (Linux)

- Three binary tree traversal (recursive, non-recursive traversal and Morris) (Programming)

- Java is simple to read and write HDFS Demo (Programming)

- Android LayoutInflater source parsing (Programming)

  On FreeBSD 10.2 Bugzilla how to install and configure Apache SSL
  Add Date : 2018-11-21      
  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.


FreeBSD 10.2 - 64 Wei
Root privileges

The first step - Update System

Freebsd server with ssh login and update software library:

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

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;
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
Until all are completed, which takes time.

Next, perform the "checksetup.pl" file in bugzilla installation directory to generate configuration files "localconfig".

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":

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.
- dd command: do hard disk IO performance test (Linux)
- JavaScript function definition mode (Programming)
- Linux find command detailing (Linux)
- Web server security policy (Linux)
- Workaround CentOS error message during compilation PHP5 common (Linux)
- Actual custom yum repository ---- gem commands commonly used parameters (Linux)
- To install Ganglia (Linux)
- Mac OS X 10.10 Yosemite compiling OpenJDK 9 (Linux)
- Linux beginners to develop the seven habits (Linux)
- MongoDB uses aggregate, group, match mysql achieve in having (count (1)> 1) features (Database)
- Why do I prefer Git (Linux)
- Ceph tuning --Journal and tcmalloc (Server)
- Redis configuration file interpretation (Database)
- Java data structures - order linear form of table ArrayList (Programming)
- Shell array: Define Shell array, the array length (Programming)
- MongoDB data replication and data slices (Database)
- Mumble installation source VoIP application on Ubuntu (Linux)
- Build Docker based MongoDB replication cluster environment (Database)
- Tsunami-udp accelerated network transmission (Linux)
- How to install OpenOffice Ubuntu or Linux Mint (Linux)
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.