LoadModule authn_socache_module libexec/apache24/mod_authn_socache.so
LoadModule socache_shmcb_module libexec/apache24/mod_socache_shmcb.so
LoadModule expires_module libexec/apache24/mod_expires.so
LoadModule ssl_module libexec/apache24/mod_ssl.so
LoadModule cgi_module libexec/apache24/mod_cgi.so
LoadModule rewrite_module libexec/apache24/mod_rewrite.so

root@ns1:~ # cd /usr/local/etc/apache24/
root@ns1:/usr/local/etc/apache24 # mkdir ssl && cd ssl
root@ns1:/usr/local/etc/apache24/ssl # 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
Generating a RSA private key
.....................................................................................+++++
...................................+++++
writing new private key to '/usr/local/etc/apache24/ssl/bugzilla.key'
-----
You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter '.', the field will be left blank.
-----
Country Name (2 letter code) [AU]:id
State or Province Name (full name) [Some-State]:jawa barat
Locality Name (eg, city) []:bekasi
Organization Name (eg, company) [Internet Widgits Pty Ltd]:mediatama
Organizational Unit Name (eg, section) []:networking
Common Name (e.g. server FQDN or YOUR name) []:unixexplore.com
Email Address []:datainchi@gmail.com
root@ns1:/usr/local/etc/apache24/ssl # chmod 600 *

<VirtualHost *:80>
ServerName unixexplore.com
ServerAlias www.unixexplore.com
DocumentRoot /usr/local/www/bugzilla
Redirect permanent / https://unixexplore.com/
</VirtualHost>


Listen 443
<VirtualHost _default_:443>
ServerName unixexplore.com
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

<Directory "/usr/local/www/bugzilla">
AddHandler cgi-script .cgi
Options +ExecCGI
DirectoryIndex index.cgi index.html
AllowOverride Limit FileInfo Indexes Options
Require all granted
</Directory>
</VirtualHost>

root@ns1:~ # mysql -u root -p -e "create database bugzilla_database"
Enter password: router
root@ns1:~ # mysql -u root -p -e "show databases"
Enter password: router
+--------------------+
| Database           |
+--------------------+
| bugdb              |
| bugzilla_database  |
| bugzilla_demo      |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

root@ns1:~ # mysql -u root -p
Enter password: router
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 8.0.33 Source distribution

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> create user 'userzilla'@'localhost' IDENTIFIED BY 'userzilla@123';
Query OK, 0 rows affected (0.05 sec)

root@localhost [(none)]> grant all privileges on bugzilla_database.* to 'userzilla'@'localhost';
Query OK, 0 rows affected (0.04 sec)

root@localhost [(none)]> flush privileges;
Query OK, 0 rows affected (0.01 sec)

root@localhost [(none)]> \q
Bye

root@ns1:~ # cd /usr/ports/devel/bugzilla50
root@ns1:/usr/ports/devel/bugzilla50 # make install clean
====> Compressing man pages (compress-man)
===>  Installing for bugzilla50-5.0.4_3
===>  Checking if bugzilla50 is already installed
===>   Registering installation for bugzilla50-5.0.4_3
Installing bugzilla50-5.0.4_3...
  Bugzilla has now been installed.  To quick setup you have to:

  1. Create database user who has rights on bugs database manipulation
     by following mysql commands (for MySQL 4.0 or later):

     GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES,
           CREATE TEMPORARY TABLES, DROP, REFERENCES
	   ON <database>.* TO <dbuser>@<host>
	   IDENTIFIED BY '<password>';
     FLUSH PRIVILEGES;

     where <database> is a bugs database name; <dbuser> is a bugs database
           owner; <host> is a host there bugzilla is being setup;
           <password> is a database owner's password;

  2. Change working directory to /usr/local/www/bugzilla
  3. Run "./checksetup.pl" script as root user
  4. Read output carefully and follow all instructions

  For more complete database setup and post-installation instructions
  and security tips/notes please read "Bugzilla Guide" in
  /usr/local/share/doc/bugzilla/en/html/ (chapter 2: "Installing Bugzilla")
For upgrades:
  0. Back up your data.

  1. Run the command inside /usr/local/www/bugzilla
      find . -mindepth 2 -name .htaccess -exec rm -f {} \;

  2. Run "./checksetup.pl" inside /usr/local/www/bugzilla.  You may need to
     run it several times.

  3. Restart your Web server, especially if you're using mod_perl: this
     will save you from a number of troubles.

$db_host = 'localhost';
$db_name = 'bugzilla_database';
$db_user = 'userzilla'@'localhost';
$db_pass = 'userzilla@123';