PDA

Bekijk de volledige versie : [How-To] Tiny Tiny RSS (Google Reader)



ryzhov_al
25-03-2013, 06:19
[How-To] Get "Google Reader" working right on router

As you might know, Google Reader (https://www.google.com/reader) is to shutdown on summer (http://www.theverge.com/2013/3/13/4101144/google-shuts-down-reader-rss-aggregation-service). The goal of this How-To is to install Google Reader replacement
right to router - a Tiny Tiny RSS (http://tt-rss.org/redmine/projects/tt-rss/wiki) which Looks like Google Reader, Feels like Google Reader and so on:) Check out my video clip (http://www.youtube.com/watch?v=4hEl8qKEB2o).

http://tt-rss.org/images/site_shot_5.png
The positive side effect is a privacy — no one can see what feeds you are reading.

Pre-requirements: asuswrt-merlin firmware on board and a USB drive with Entware installation (http://github.com/RMerl/asuswrt-merlin/wiki/Entware).

Download and unpack preconfigured TT-RSS

cd /opt
wget http://files.ryzhov-al.ru/Routers/tt-rss/tt-rss_1.7.5.tgz
tar -xvzf ./tt-rss_1.7.5.tgz
rm ./tt-rss_1.7.5.tgz

Install necessary packages

opkg install \
dtach \
lighttpd-mod-fastcgi \
mc \
mysql-server \
php5-cgi \
php5-cli \
php5-mod-ctype \
php5-mod-curl \
php5-mod-dom \
php5-mod-hash \
php5-mod-iconv \
php5-mod-json \
php5-mod-mbstring \
php5-mod-mysql \
php5-mod-session \
php5-mod-simplexml \
php5-mod-xml \
wget

Start it!

/opt/etc/init.d/S70mysqld start
/opt/etc/init.d/S80lighttpd start
/opt/etc/init.d/S81ttrss-update start
All necessary stuff will be started automatically on reboot.

Point a browser to

http://192.168.1.1:81/tt-rss/
where 192.168.1.1 is an ip address of router, enter default credentials "admin"/"password" and enjoy using Tiny Tiny RSS.

That's an easy way of installing TT-RSS. If you want to know technical detail about it, see third post (http://forums.smallnetbuilder.com/showpost.php?p=65080&postcount=3).

ryzhov_al
25-03-2013, 07:24
First, export Google Reader subscription with help of Google Takeout (https://www.google.com/takeout/).

Select Services > Reader > Create Archive > Download.
Unpack reader/subscriptions.xml from downloaded archive.
Now, import subscriptions to Tiny Tiny RSS.

Open TT-RSS web interface and go to Actions > Preferencies > Feeds > OPML.
Select subscriptions.xml file and press "Import my OPML" button.
Ignore warning message, just press "Close > Exit Preferencies".
That it! All your subscription from Google Reader is here! :rolleyes:

ryzhov_al
27-03-2013, 07:37
Well, I've simplified TT-RSS installation in the first post to make it easier to use.

But my archive may get's older with time, so you may use this way to adopt a
fresh TT-RSS version, or if you trying to understand deeper installation process.

Pre-requirements: asuswrt-merlin firmware on board and a USB drive with Entware installation (http://github.com/RMerl/asuswrt-merlin/wiki/Entware).

Install necessary packages

opkg install \
dtach \
lighttpd-mod-fastcgi \
mc \
mysql-server \
php5-cgi \
php5-cli \
php5-mod-ctype \
php5-mod-curl \
php5-mod-dom \
php5-mod-hash \
php5-mod-iconv \
php5-mod-json \
php5-mod-mbstring \
php5-mod-mysql \
php5-mod-session \
php5-mod-simplexml \
php5-mod-xml \
wget
Donwload and unpack TT-RSS sources

cd /opt/share/www/
/opt/bin/wget --no-check-certificate https://github.com/gothfox/Tiny-Tiny-RSS/archive/1.7.5.tar.gz
tar -xvzf ./1.7.5.tar.gz
mkdir ./tt-rss
mv ./Tiny-Tiny-RSS-1.7.5/* ./tt-rss/
rm -fr ./Tiny-Tiny-RSS-1.7.5/
rm ./1.7.5.tar.gz
Configure MySQL server
Enter:

mcedit /opt/etc/my.cnf
and fix few strings, I'll show only those one, which need to be fixed:

datadir = /opt/var/mysql/
user = admin
Save changes by "F2", "Esc". Now initialize MySQL server by:

mysql_install_db --force
/opt/etc/init.d/S70mysqld start
mysqladmin -u root password 'P@ssw0rd'
Where P@ssw0rd is a new MySQL administrator's password. Enter to MySQL server by:

mysql -u root -p
type new password and execute this SQL-script:

create database ttrss;
use ttrss;
source /opt/share/www/tt-rss/schema/ttrss_schema_mysql.sql;
quit;
Configure web server

mcedit /opt/etc/lighttpd/lighttpd.conf
Fix this lines:

index-file.names = ( "index.html", "default.html", "index.htm", "default.htm", "index.php" )
...
server.port = 81
and add this ones to the end:

server.modules += ( "mod_fastcgi" )

fastcgi.server = (
".php" =>
( "localhost" =>
( "socket" => "/tmp/php-fcgi.sock",
"bin-path" => "/opt/bin/php-fcgi",
"max-procs" => 1,
"bin-environment" =>
( "PHP_FCGI_CHILDREN" => "2",
"PHP_FCGI_MAX_REQUESTS" => "1000"
)
)
)
)
Configure Tiny Tiny RSS
Copy default configuration file…

cp /opt/share/www/tt-rss/config.php-dist /opt/share/www/tt-rss/config.php
mcedit /opt/share/www/tt-rss/config.php
…and edit following lines:

define('DB_TYPE', "mysql"); // or mysql
define('DB_HOST', "127.0.0.1");
define('DB_USER', "root");
define('DB_NAME', "ttrss");
define('DB_PASS', "P@ssw0rd");
...
define('SELF_URL_PATH', 'http://www.asusnetwork.net/tt-rss/');
...
define('PHP_EXECUTABLE', '/opt/bin/php-fcgi');
Also, you need to replace "0" to "-1" in…

mcedit /opt/share/www/tt-rss/include/sanity_check.php

if (function_exists('posix_getuid') && posix_getuid() == -1) {

…to enable running TT-RSS with root priveleges.
Create start script for feeds update daemon

cp /opt/etc/init.d/S80lighttpd /opt/etc/init.d/S81ttrss-update
mcedit /opt/etc/init.d/S81ttrss-update
Edit this lines:

PROCS=php-cli
ARGS="/opt/share/www/tt-rss/update.php --daemon"
PREARGS="dtach -n /opt/var/ttrss_update.sock"
and start web server and feed updater:

/opt/etc/init.d/S80lighttpd start
/opt/etc/init.d/S81ttrss-update start
Command line exercises is finished:)

We've done all necessary steps to start all stuff automatically on boot.
Point a browser to

http://192.168.1.1:81/tt-rss/
where 192.168.1.1 is an ip address of router, enter default credentials admin"/"password" and enjoy using Tiny Tiny RSS.

!gm
29-03-2013, 14:43
thank you for that great How-To and showing an alternative to the google reader.