Tt-rss install

Base Install

pkg install mysql
pkg install tt-rss

# /etc/rc.conf

mysql_enable="YES"
php_fpm_enable="YES"
nginx_enable="YES"
ttrssd_enable="YES"

mysql

create database user

# Also your DB_USER must be granted to ALTER any tables of your DB_NAME.
CREATE DATABASE ttrss CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'ttrss'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';  
GRANT ALL PRIVILEGES ON ttrss.* TO 'ttrss'@'localhost';
FLUSH PRIVILEGES;
EXIT;

php

tt-rss appears to have hard-coded /usr/bin/php. Create a symlink to satisfy it.

ln -s /usr/local/bin/php /usr/bin/php

php-fpm

# /usr/local/etc/php-fpm.d/www.conf

[www]
listen=/var/run/php-fpm/php-fpm.sock;

service php-fpm start
chown -Ra www:www /var/run/php-fpm

nginx

user www;
worker_processes auto;
worker_cpu_affinity auto;

events {
  multi_accept on;
  worker_connections 1024;
}

http {
  default_type application/octet-stream;

  server {
    listen 80;
    server_name servername;
    include /usr/local/etc/nginx/mime.types;
    root /usr/local/www/tt-rss;
    index index.php;
    charset utf-8;
    client_max_body_size 100m;
    client_body_timeout 60;

    location / {
      index index.php
      try_files $uri $uri/ =404;
    }

    location ~ \.php$ {
      include /usr/local/etc/nginx/fastcgi_params;
      fastcgi_pass unix:/var/run/php-fpm/php-fpm.sock;
      fastcgi_index index.php;
      fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
      try_files $uri @servername;
    }
  }
}

service nginx start

tt-rss web ui setup

rm /usr/local/www/tt-rss/config.php

xdg-open http://x.x.x.x/install/index.php

• tt-rss does not support mysql over a socket, configure your firewall accordingly
• Default user is admin, with the password password

refresh feeds

Daemon Method

# /etc/rc.conf

ttrssd_enable="YES"

service ttrssd start

Old Method

# crontab -e  (user www)
*/30 * * * * /usr/local/bin/php /usr/local/www/tt-rss/update.php --feeds --quiet