Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Server \ On FreeBSD 10.2 Bugzilla how to install and configure Apache SSL     - CentOS / Linux restart active NIC connection paths / network configure error Error Resolution (Linux)

- In addition to wget and curl, what better alternatives (Linux)

- DM9000 timing settings (Programming)

- Archive log file size and redo log file size relationship (Database)

- NET Developers need to know some Linux commands (Linux)

- HomeKit User Interface Guidelines (Linux)

- SQLite (Database)

- Python context managers (Programming)

- Linux disk and File System Concepts (Linux)

- Merge Sort (Programming)

- Create several practical points of high security PHP site (Linux)

- Notebook computer forget password solution (Linux)

- Ubuntu Thunderbird 24.4.0 (Linux)

- Construction of Android and iOS apps use Jenkins Automation (Programming)

- Using nmcli commands to manage network in RedHat / CentOS 7.x (Linux)

- Add local search to your Android app (Programming)

- C ++ 11 smart pointers (Programming)

- TL-WR703N to install OpenWrt process notes (Linux)

- Install Ubuntu open source drawing program MyPaint 1.2.0 (Linux)

- Use the top command (Linux)

  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.
- Oracle View Object Information (Database)
- Java development specifications summary (Programming)
- How to install Gnome 3.10 in Ubuntu 13.10 (Linux)
- MongoDB3.0.x version of the user authorization profile (stand-alone environment) (Database)
- Oracle GoldenGate encryption (Database)
- Python method to traverse folders and file read and write (Programming)
- SSH without password Definitive Guide (Linux)
- How to install and use the malware detection tool LMD and ClamAV antivirus engine on Linux (Linux)
- Android source code compiled fatal error solutions (Programming)
- Log4j configuration file Explanation (Linux)
- Linux Getting Started Tutorial: / var / spool / clientmqueue fill the root directory (Linux)
- Install FFmpeg compiling from source in Mac OS X environment (Linux)
- Linux firewall to prevent external network attacks (Linux)
- Use Visual Studio 2015 to develop Android program (Programming)
- Sturdy build secure Linux server (Linux)
- Go Languages Reviews (Programming)
- After SSH change the default port, how to use Git (Linux)
- GitHub multiplayer co-development configuration (Linux)
- Use Vagrant build cross-platform development environment for Python (Server)
- Linux 6 use UDEV binding shared storage (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.