Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Server \ On FreeBSD 10.2 Bugzilla how to install and configure Apache SSL     - Using Vagrant to build multi-platform environment (Server)

- Make Linux more secure server tips (Linux)

- Iptables Instructions (Linux)

- Linux alpine use the command line to access Gmail (Linux)

- Oracle can not change the tablespace to backup mode in non-archive mode (Database)

- Ubuntu installation under Scrapy (Linux)

- Linux atomic operations and synchronization mechanisms (Programming)

- View and modify Linux machine name (Linux)

- Ora-00600 [fast hot Atkins soft _ that _ Oh, of course not _less_ profile] (Database)

- Linux C source code (sockettype: socket descriptor determination function) (Programming)

- How Mutt mail client to use cipher text password (Linux)

- Android judgment toward camera pictures (Programming)

- W and uptime command (Linux)

- CentOS ClamAV antivirus package updates (Linux)

- Linux cd command Detailed (Linux)

- Ubuntu install VMware Workstation 11 tutorials at 14.04 / 14.10 (Linux)

- Use Pylint regulate your Python code (Programming)

- Hutchison DG standby database CPU consumption reached bottleneck repair (Database)

- To install the Oracle process notes on Oracle Linux 4u4 (Database)

- Oracle ORA-01691 error message, a single data file size limit problem (Database)

  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.
- ctop: monitor container performance Linux command line artifact (Linux)
- To install Ganglia configuration of experience under CentOS 5.5 (Linux)
- Install the latest ATI / Nvidia graphics driver on Ubuntu (Linux)
- Introduction to thread pooling and simple implementation (Programming)
- Eclipse remove all comments and code spaces (Linux)
- Red Hat Linux security settings document (Linux)
- Logging information through the web GUI (LogAnalyzer) (Server)
- Linux System Getting Started Learning: After starting in Ubuntu or Debian, enter the command line (Linux)
- Python: Finding meet the conditions specified in the file directory (Programming)
- Use FFmpeg processing high quality GIF (Programming)
- Create RAID 1 (mirroring) with two disks (Linux)
- Java method to read and write files summary (Programming)
- MySQL / MariaDB database master-slave replication (Database)
- Android determine the device network connection status, and determine the connection (Programming)
- MongoDB start under Linux (Database)
- How to Install 3.16.7 CKT2 kernel in Ubuntu 14.10, Ubuntu 14.04 and its derivative versions (Linux)
- Python, and / or (Programming)
- Linux log management make the system more secure (Linux)
- Strategy Games Ubuntu installation of Wesnoth 1.12.1 (Linux)
- Ubuntu user use PPA to install Uget 2.0.5 (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.