Support #757
Updated by Daniel Curtis over 9 years ago
{{>toc}}
This is a guide on setting up Piwik with Nginx on FreeBSD 9.
h1. Prepare the Environment
* Before installation of the components, make sure everything is up to date using the following command:
<pre>
pkg update -f && pkg upgrade
</pre>
* Install portmaster:
<pre>
cd /usr/ports/ports-mgmt/portmaster
make install clean
pkg2ng
</pre>
* Create the piwik user:
<pre>
pw user add -n piwik -m -s /sbin/nologin -c "Piwik"
</pre>
---
h1. Install Nginx
* Install Nginx
<pre>
pkg install nginx
</pre>
* Start and enable nginx at boot:
<pre>
echo 'nginx_enable="YES"' >> /etc/rc.conf
service nginx start
</pre>
* Create a configuration directory to make managing individual server blocks easier
<pre>
mkdir /usr/local/etc/nginx/conf.d
</pre>
* Edit the main nginx config file:
<pre>
vi /usr/local/etc/nginx/nginx.conf
</pre>
#* And strip down the config file and add the include statement at the end to make it easier to handle various server blocks:
<pre>
worker_processes 1;
error_log /var/log/nginx-error.log;
events {
worker_connections 1024;
}
http {
include mime.types;
default_type application/octet-stream;
sendfile on;
keepalive_timeout 65;
# Load config files from the /etc/nginx/conf.d directory
include /usr/local/etc/nginx/conf.d/*.conf;
}
</pre>
---
h1. Install MySQL Server
* Start by installing the mysql56-server and mysql56-client packages:
<pre>
pkg install mysql56-{server,client}
</pre>
* Copy a base MySQL configuration to use:
<pre>
cp /usr/local/share/mysql/my-default.cnf /usr/local/share/mysql/my-small.cnf /var/db/mysql/my.cnf
</pre>
* Edit the mariadb config to change the max packet size:
<pre>
vi /var/db/mysql/my.cnf
</pre>
#* and modify @max_allowed_packet@ to 32M
<pre>
max_allowed_packet = 32M
</pre>
* Enable and start mysql at boot: MariaDB
<pre>
echo 'mysql_enable="YES"' >> /etc/rc.conf
service mysql-server start
</pre>
* Prepare the database for use by running the secure installation:
<pre>
mysql_secure_installation
</pre>
#* *NOTE*: +Choose a strong root password+ and answer +yes+ to all questions.
h2. Create MySQL Databases and Users
* Login to MySQL and create appropriate databases and users.
<pre>
mysql -u root -p
</pre>
#* and run the following SQL queries to create the *piwikdb* database and *piwikuser* user:
<pre>
CREATE DATABASE piwikdb CHARACTER SET utf8;
CREATE USER 'piwikuser'@'localhost' IDENTIFIED BY 'SuperSecretPassword';
GRANT ALL PRIVILEGES ON piwikdb.* TO 'piwikuser'@'localhost';
FLUSH PRIVILEGES;
quit
</pre>
---
h1. Install PHP
* Install PHP 5.6 and a few extensions:
<pre>
pkg install php56 php56-mbstring php56-simplexml php56-openssl
</pre>
* Configure the default PHP settings
<pre>
cp /usr/local/etc/php.ini-production /usr/local/etc/php.ini
</pre>
* Create a directory for the php-fpm configs:
<pre>
mkdir /usr/local/etc/php-fpm.d
</pre>
* Edit @/usr/local/etc/php-fpm.conf@:
<pre>
vi /usr/local/etc/php-fpm.conf
</pre>
#* Make the following changes:
<pre>
include=/usr/local/etc/php-fpm.d/*.conf
</pre>
* Enable PHP-FPM at boot:
<pre>
echo 'php_fpm_enable="YES"' >> /etc/rc.conf
</pre>
* Restart nginx:
<pre>
service nginx restart
</pre>
---
h1. Install Piwik
* Install piwik:
<pre>
pkg install piwik
</pre>
* Create an *piwik.example.com server block* config file:
<pre>
vi /usr/local/etc/nginx/conf.d/piwik.example.com.conf
</pre>
#* Add the following:
<pre>
upstream piwik-handler {
server unix:/var/run/piwik.example.com-php-fpm.sock;
}
server {
listen 80;
server_name piwik.example.com;
root /usr/local/www/piwik/;
index index.php;
location = /robots.txt {
allow all;
log_not_found off;
access_log off;
}
location ~ ^/(?:CHANGELOG\.md|config|README.md){
deny all;
}
location / {
try_files $uri $uri/ =404;
}
location ~ \.php(?:$|/) {
fastcgi_split_path_info ^(.+\.php)(/.+)$;
include fastcgi_params;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_param PATH_INFO $fastcgi_path_info;
fastcgi_pass piwik-handler;
fastcgi_intercept_errors on;
}
}
</pre>
* Create the piwik php-fpm pool config file:
<pre>
vi /usr/local/etc/php-fpm.d/piwik.example.com.conf
</pre>
#* And add the following:
<pre>
[piwik.example.com]
user = piwik
group = www
listen = /var/run/piwik.example.com-php-fpm.sock
listen.owner = piwik
listen.group = www
pm = dynamic
pm.max_children = 5
pm.start_servers = 2
pm.min_spare_servers = 1
pm.max_spare_servers = 3
php_admin_value[session.save_path] = "/usr/local/www/piwik/tmp"
php_admin_value[always_populate_raw_post_data] = "-1"
</pre>
* Change the ownership of the piwik directory:
<pre>
chown -R piwik:www /usr/local/www/piwik
</pre>
* Restart nginx and start php-fpm:
<pre>
service nginx restart
service php-fpm start
</pre>
* Now open up a web browser and go to http://piwik.example.com to finish the setup process.