A Step-by-Step Guide to installing Tiny Tiny RSS v1.5.6 on CentOS 5.7 + Apache + PHP + MySQL

I’m writing this guide because the official guide on the wiki and the Linux.com article really couldn’t guide me well :-(

Anyway, here we go. A little about Tiny Tiny RSS(tt-rss), for those who don’t know what it is: http://tt-rss.org/redmine/

The following installation guide assumes you have not configured you LAMP environment, but has got a working yum repository.

1. Install MySQL, Apache and PHP

shell> yum install mysql mysql-server

shell> yum install httpd php php-common

You would need some php modules. I’m not sure what is required other than php-xmlrpc, so you might want to install all the common stuffs:

shell> yum install php-pear php-pdo php-mysql php-pgsql php-pecl-memcache php-gd php-mbstring php-mcrypt php-xml php-xmlrpc

2. Start services

shell> service mysql start

shell> service httpd start

Do your security initialization if you haven’t done it yet:

shell> /usr/bin/mysqlsecureinstallation

3. Download the latest version of tt-rss (which is v1.5.6 in this case)

shell> wget http://tt-rss.org/download/tt-rss-1.5.6.tar.gz

4. Unzip it

shell> tar -zxvf tt-rss-1.5.6.tar.gz -C /var/www/html

5. Create you database and user

First, enter you MySQL as root:

shell> mysql -u root -p

The password should have been setup upon initialization.

Create database:

mysql> CREATE DATABASE ttrssdb;

Create a user to access this database:

mysql> GRANT ALL ON ttrssdb.* TO ttrssuser IDENTIFIED BY “SomePassword”;

And you are done here.

mysql> quit;

  1. Create all the tables – with the script that came along with the source file!

shell> cd /var/www/html/tt-rss

shell tt-rss> mysql -u ttrssuser -D ttrssdb -p < schema/ttrssschemamysql.sql

  1. Configuration file

shell tt-rss> cp config.php-dist config.php

shell tt-rss> vi config.php

There are several things you need to specify:

define(‘DB_TYPE’, “mysql”); 

define(‘DB_HOST’, “localhost”);

define(‘DB_USER’, “ttrssuser”);

define(‘DB_NAME’, “ttrssdb”);

define(‘DB_PASS’, “SomePassword”);

define(‘SELF_URL_PATH’, ‘http://your.domain.com/tt-rss&#8217;);

Make sure your password is correct or you’ll get Connection Failed warnings.

And there is one more thing, which you’ll find at the end of all pages:

define(‘ISCONFIGURED’, false);

// Please set this to true if you have read everything above and

// finished setting configuration options.

(Well, I was stuck here for one whole night…)

  1. Test it

Run an auto-check in your web browser:

http://your.domain.com/tt-rss/sanity_check.php

There might be some permission issues with the “icons” directory, which could be resolved by 

shell tt-rss> chmod -R 777 icons

Now we can already see our pages showing up, but you can’t see any contents yet. One last step to go:

  1. Update feeds

You’ll need to update feeds at the background, so setup a screen first:

shell tt-rss> screen -S updaterss

(Do a yum install screen if you haven’t got it)

Under this screen, do

shell tt-rss> php ./update.php -daemon

if you are under single-user mode, or

shell tt-rss> php ./update_daemon2.php

if you are under multi-user mode.

And now you can detach from the screen with CTRL+A+D shortcut.

Now go to http://your.domain.com/tt-rss/ to try it out!

Advertisements
This entry was posted in IT and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s