Installation on FreeBSD 12.2

[VersusBG]

Installation of Snipe-IT on FreeBSD 12.2

Here is short guide for Snipe-IT / Apache24 / PHP74 / MariaDB

First read the main documentation from
https://snipe-it.readme.io/docs

This is clean install of FreeBSD 12.2-RELEASE. The guide is using packages to speed up the installation proccess but if you are using ports you can build all needed php extension by installing meta-port php74-extension and select required extensions there. Before installation you need to have a working DNS registration of your host with A or CNAME record resolving snipe-it.example.com to the ip address of your server.(replace example.com with your real domain name)

All commands are executed as root except the installation of composer which is installed with unprivileged user.

Installation of all required software and runtime dependencies

#git, apache, curl, MySQL/MariaDB, unzip

pkg install git curl unzip apache24 mariadb104-server

#php74, mod_php, PHP Extensions

In additional of official required PHP extensions you need php74-posix, php74-xmlreader, php74-xmlwriter required by some of the functions in upgrade.php file and during installation of composer

pkg install php74 mod_php74 php74-pear php74-composer php74-xmlreader php74-xmlwriter php74-iconv \
php74-dom php74-posix php74-mysqli php74-bcmath php74-gd php74-mbstring php74-pecl-mcrypt \
php74-ldap php74-json php74-simplexml php74-phar php74-filter php74-openssl php74-zlib php74-fileinfo \
php74-tokenizer php74-curl php74-pdo php74-xml php74-ctype php74-session php74-pdo_mysql php74-zip

MariaDB

Default mysql socket file in /usr/local/etc/mysql/my.cnf is set to /var/run/mysql/ and the mysql deamon is running under mysql user so this user need to have write permission to /var/run/mysql in order to create the socket file. In the past this socket was in /tmp which was globaly writable. Installation of mariadb via packages doesn't change the correct permissions of /var/run/mysql

sysrc mysql_enable=YES
chown mysql /var/run/mysql
service mysql-server start
mysql_secure_installation

Creating the database and user

mysql -u root -p
CREATE DATABASE snipeit;
CREATE USER snipe_user;
GRANT ALL ON snipeit.* TO 'snipe_user'@'localhost' IDENTIFIED BY 'P@ssw0rd';
\q

Edit /usr/local/etc/apache24/httpd.conf

#uncomment mod_rewrite.so
ee /usr/local/etc/apache24/httpd.conf

LoadModule rewrite_module libexec/apache24/mod_rewrite.so

Create /usr/local/etc/apache24/Includes/php.conf

ee /usr/local/etc/apache24/Includes/php.conf

<FilesMatch "\.php$">
    SetHandler application/x-httpd-php
</FilesMatch>
<FilesMatch "\.phps$">
    SetHandler application/x-httpd-php-source
</FilesMatch>

Create VirtalHost config file /usr/local/etc/apache24/Includes/snipeit.conf

Note: instead of having dir_module in your VirtualHost config you can edit httpd.conf DirectoryIndex and include index.php there.

ee /usr/local/etc/apache24/Includes/snipeit.conf

<VirtualHost *:80>
    ServerAdmin admin@example.com
    DocumentRoot "/usr/local/www/apache24/data/snipeit/public"
    ServerName snipe-it.example.com
    ErrorLog "/var/log/snipeit-error_log"
    CustomLog "/var/log/snipeit-access_log" common

<Directory /usr/local/www/apache24/data/snipeit/public>
        Require all granted
        AllowOverride All
        Options +Indexes
</Directory>

<IfModule dir_module>
    DirectoryIndex index.html index.php
</IfModule>

</VirtualHost>

copy php.ini and edit the timezone and if you need bigger file upload edit 'post_max_size'

cp /usr/local/etc/php.ini-production /usr/local/etc/php.ini
ee /usr/local/etc/php.ini

https://www.php.net/manual/en/timezones.php

;date.timezone =

enable apache24 and start it

sysrc php_fpm_enable="yes"
sysrc apache24_enable="yes"
service php-fpm start
service apache24 start

Download Snipe-IT using git and set the permissions

mkdir /usr/local/www/apache24/data/snipeit
git clone https://github.com/snipe/snipe-it /usr/local/www/apache24/data/snipeit

Change the owner of /usr/local/www/apache24/data/snipeit to unprivileged user in this example i will use "user" then log in with that "user" and install composer. It's not recomended to use root for installation of composer.

chown -R user:www /usr/local/www/apache24/data/snipeit

log in as unprivileged "user" and install composer

$ cd /usr/local/www/apache24/data/snipeit
$ composer install --no-dev --prefer-source

log in back to root and change again the owner of the snipeit to www so the apache can access it

chown -R www:www /usr/local/www/apache24/data/snipeit
chmod -R 755 /usr/local/www/apache24/data/snipeit/storage
chmod -R 755 /usr/local/www/apache24/data/snipeit/public/uploads

Copy the configuration file and edit it.

cd /usr/local/www/apache24/data/snipeit
cp .env.example .env

#Edit .env according https://snipe-it.readme.io/docs/configuration
#FreeBSD mysqldump path is different so set DB_DUMP_PATH correctly
ee /usr/local/www/apache24/data/snipeit/.env

APP_ENV=production
APP_DEBUG=false
APP_KEY=
APP_URL=http://snipe-it.example.com
APP_TIMEZONE='UTC'
APP_LOCALE=en
MAX_RESULTS=500

# REQUIRED: DATABASE SETTINGS
# --------------------------------------------
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_DATABASE=snipeit
DB_USERNAME=snipe_user
DB_PASSWORD=P@ssw0rd
DB_PREFIX=null
DB_DUMP_PATH='/usr/local/bin'
DB_CHARSET=utf8mb4
DB_COLLATION=utf8mb4_unicode_ci

MAIL_DRIVER=smtp
MAIL_HOST=mail.example.com
MAIL_PORT=465
MAIL_USERNAME=no-reply@example.com
MAIL_PASSWORD=**************
MAIL_ENCRYPTION=SSL
MAIL_FROM_ADDR=no-reply@example.com
MAIL_FROM_NAME='Snipe-IT'
MAIL_REPLYTO_ADDR=admin@example.com
MAIL_REPLYTO_NAME='Snipe-IT'
MAIL_BACKUP_NOTIFICATION_ADDRESS=admin@example.com

generate the APP_KEY

cd /usr/local/www/apache24/data/snipeit
php artisan key:generate --force
php artisan migrate --force

Set up the artisan scheduler into crontab

crontab -e
* * * * * /usr/local/bin/php /usr/local/www/apache24/data/snipeit/artisan schedule:run > /dev/null

navigate to http://snipe-it.example.com and finish the installation.