Install the following packages:
pkg install php5-extensions pkg install php5-xmlrpc pkg install php5-gettext pkg install php5-mcrypt pkg install php5-mbstring pkg install php5-zip pkg install php5-gd pkg install php5-zlib pkg install php5-curl pkg install php5-mysql pkg install php5-openssl pkg install php5-pdo_mysql pkg install php5-mysqli pkg install php5-pgsql pkg install php5-pdo_pgsql pkg install php5-ftp pkg install mysql55-server pkg install lighttpd pkg install git
Execute the following commands:
echo 'lighttpd_enable="YES"' >> /etc/rc.conf echo 'mysql_enable="YES"' >> /etc/rc.conf echo '[mysqld]' >> /var/db/mysql/my.cnf echo 'skip-networking' >> /var/db/mysql/my.cnf /usr/local/etc/rc.d/mysql-server start
Configure MySQL:
mysql_secure_installation mysql -u root --password="YOURPASSWORD" -e "CREATE DATABASE spotweb;" mysql -u root --password="YOURPASSWORD" -e "CREATE USER 'spotweb'@'localhost' IDENTIFIED BY 'spotweb';" mysql -u root --password="YOURPASSWORD" -e "GRANT ALL PRIVILEGES ON spotweb.* TO spotweb @'localhost' IDENTIFIED BY 'spotweb';"
Configure Lighthttpd:
vi /usr/local/etc/lighttpd/lighttpd.conf
Edit the following:
var.server_root = "/usr/local/www/spotweb" server.use-ipv6 = "disable" server.bind = "192.168.178.6" server.document-root = "/usr/local/www/spotweb" $SERVER["socket"] == "192.168.178.6:80"
Add this to the bottom of the file:
$HTTP["url"] =~ "^/data/" {
url.access-deny = ("")
}
$HTTP["url"] =~ "^($|/)" {
dir-listing.activate = "disable"
}
cgi.assign = ( ".php" => "/usr/local/bin/php-cgi" )Enable fast-cgi module by removing #:
vi /usr/local/etc/lighttpd/modules.conf
#include "conf.d/fastcgi.conf"
Edit fastcgi.conf:
vi /usr/local/etc/lighttpd/conf.d/fastcgi.conf
fastcgi.server = ( ".php" =>
((
"socket" => "/tmp/php.socket",
"bin-path" => "/usr/local/bin/php-cgi",
"bin-environment" => (
"PHP_FCGI_CHILDREN" => "16",
"PHP_FCGI_MAX_REQUESTS" => "10000"
),
"min-procs" => 1,
"max-procs" => 1,
"idle-timeout" => 20
))
)Edit the lighttpd mime configuration by adding the following to the array:
vi /usr/local/etc/lighttpd/conf.d/mime.conf
".svg" => "image/svg+xml", ".xht" => "application/xhtml+xml", ".xhtml" => "application/xhtml+xml", ".woff" => "application/x-font-woff", ".svgz" => "image/svg+xml",
Optional, enable the API
vi /usr/local/etc/lighttpd/modules.conf
Change server.modules to:
server.modules = ( "mod_access", "mod_alias", "mod_compress", "mod_redirect", "mod_rewrite", # "mod_auth", # "mod_evasive", # "mod_setenv", # "mod_usertrack", )
vi /usr/local/etc/lighttpd/lighttpd.conf
Add, somewhere under "## Filename/File handling"
url.rewrite-once = ( "^/api\?(.*)" => "/index.php?page=newznabapi&$1" )
END Optional, enable the API
Test the Lighthttpd config:
lighttpd -t -f /usr/local/etc/lighttpd/lighttpd.conf
Edit php.ini-development and save as php.ini
vi /usr/local/etc/php.ini-development
date.timezone = "Europe/Amsterdam"
cp /usr/local/etc/php.ini-development /usr/local/etc/php.ini
Start Ligthttpd
/usr/local/etc/rc.d/lighttpd start
Spotweb installation
mkdir /usr/local/www cd /usr/local/www git clone https://github.com/spotweb/spotweb.git chown -R www:www spotweb
Run Spotweb installation and configuration:
http://192.168.178.6/install.php
Install php5-extensions using ports:
cd /usr/ports/lang/php5-extensions make install clean
Add the following extensions to the default selection:
CURL GD GETTEXT MBSTRING MYSQL OPENSSL ZIP ZLIB
Run retrieve for the first time:
cd /usr/local/www/spotweb php retrieve.php --force
To update to latest version and run upgrade-db:
cd /usr/local/www/spotweb git pull php bin/upgrade-db.php php retrieve.php