phpMyAdmin

Always do these two commands first:

sudo apt-get update
sudo apt-get upgrade

To install phpmyadmin you have two options
1. install from the source:

sudo apt-get install phpmyadmin

That’s it, but the version is not so up-to-date.

2. Manually install:
download it last edition from the homepage. Select the “all language version” if you want to use it in other than English later.
update it to the root folder of your website.
unzip it

unzip phpMyAdmin*.zip

then follow the official docs to install it.

This will give you the last version.

Tips:
To remove the warning: mcrypt module is missing (something like that…)

sudo apt-get install php5-mcrypt
sudo /etc/init.d/apache2 restart

To remove the warning: The configuration file now needs a secret passphrase (blowfish_secret).

cd /the_path_to_your_phpmyadmin_folder/
sudo nano config.ini.php

add the follow codes before the ?> replace the password to your own random password.

$cfg[‘blowfish_secret’] = ‘password

To remove the warning:The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

creat a datebase named phpmyadmin, create a user in the privileges tab. Username should be phpmyadmin, choose the option of “Create database with same name and grant all privileges”.

Then import the create_tables.sql from the example folder of phpmyadmin.

replace the config.inc.php with the config.sample.inc.php from the sample folder.

remove the // from the start of the following lines, change the red part with phpmyadmin and its password.

/* User used to manipulate with storage */
// $cfg[‘Servers’][$i][‘controlhost’] = ”;
// $cfg[‘Servers’][$i][‘controluser’] = ‘pma‘;
// $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass‘;

/* Storage database and tables */
// $cfg[‘Servers’][$i][‘pmadb’] = ‘phpmyadmin’;
// $cfg[‘Servers’][$i][‘bookmarktable’] = ‘pma__bookmark’;
// $cfg[‘Servers’][$i][‘relation’] = ‘pma__relation’;
// $cfg[‘Servers’][$i][‘table_info’] = ‘pma__table_info’;
// $cfg[‘Servers’][$i][‘table_coords’] = ‘pma__table_coords’;
// $cfg[‘Servers’][$i][‘pdf_pages’] = ‘pma__pdf_pages’;
// $cfg[‘Servers’][$i][‘column_info’] = ‘pma__column_info’;
// $cfg[‘Servers’][$i][‘history’] = ‘pma__history’;
// $cfg[‘Servers’][$i][‘table_uiprefs’] = ‘pma__table_uiprefs’;
// $cfg[‘Servers’][$i][‘tracking’] = ‘pma__tracking’;
// $cfg[‘Servers’][$i][‘designer_coords’] = ‘pma__designer_coords’;
// $cfg[‘Servers’][$i][‘userconfig’] = ‘pma__userconfig’;
// $cfg[‘Servers’][$i][‘recent’] = ‘pma__recent’;

To force using phpmyadmin with SSL (https):
Put this following line at the bottom of config.inc.php(before ?>)

$cfg[‘ForceSSL’] = true;

Tiny Tiny RSS

Install the TTRSS
Download the ttrss files from github.
https://github.com/gothfox/Tiny-Tiny-RSS
Unzip the files to the /var/www/

cd /var/www/
unzip tiny*.zip

crate the ttrss database by the phpmyadmin.
Open the http://raspberrypi.address/tt-rss/install to finish the installation.

If the installation guide mentioned that the curl function is recommended. Install it for the the auto update of rss feeds.

sudo apt-get install curl libcurl3 libcurl3-dev php5-curl

Set a cron job
as the user pi:

crontab -e

add the follow line at the bottom of crontab.

*/15 * * * * php /home/pi/public/dipper.me/public/tt-rss/update.php –feeds –quite

Save the change.
Reboot the Raseberry Pi.

sudo reboot