Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Server \ On FreeBSD 10.2 Bugzilla how to install and configure Apache SSL     - Sublime Text 3 practical functions and shortcut keys used to collect (Linux)

- Thinking in Java study notes - everything is an object (Programming)

- Emacs install clojure development environment (Linux)

- Using Python and OpenCV detecting image barcode (Programming)

- ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] (Database)

- Linux 6 install Oracle 11g (64bit) (Database)

- Debian (Wheezy) Install Redmine 2.6 (Programming)

- Use ldap implement Windows Remote Desktop Ubuntu Linux (Linux)

- Java thread pool: ExecutorService, Executors (Programming)

- Compiled version of Android Opus audio codec library method (Programming)

- MySQL IO SSD attempt at optimization (Database)

- How wifi-linux AP signal strength detection (Linux)

- Seven kinds of DDoS attack methods and techniques Defensive (Linux)

- Linux use glibc2 library and crypt () function to generate the user password (Programming)

- Single-node Hadoop installation notes distributed pseudo & (Server)

- Deep understanding of C # generics (Programming)

- Ubuntu 12.04 installation instructions under GAMIT10.40 (Linux)

- Oracle and MySQL5.6 DDL comparison (Database)

- Linux system started to learn: the Linux syslog (Linux)

- Relationship between Linux permissions with the 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.
- Learn to read the source code of vmstat (Linux)
- Linux the best download manager uGet (Linux)
- Shell scripts to copy all directories under the current directory of a certain type of file to the same directory (Linux)
- Nginx-1.9.7 TCP reverse proxy (Server)
- Shell script to delete empty folders recursively (Linux)
- Use GNU / Linux broadcasting of television programs (Linux)
- AppCode developed Mac OS X application or shared library experience summary (Programming)
- MySQL log from the library than the main library (Database)
- Redis data types Introduction (Database)
- C ++ handling text input (Programming)
- Docker knowledge base (Server)
- Android annotation support (Support Annotations) (Programming)
- Ceph Source Analysis: Network Module (Server)
- IOS interview questions Summary (Programming)
- Testing Oracle 11g RMAN replicate database (Database)
- ImportTsv-HBase data import tool (Database)
- Linux installed PCRE (Linux)
- Hadoop upload files error solved (Server)
- Linux systems use logwatch log file monitoring (Linux)
- CentOS7 installation configuration (Server)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.