Why? Because Feed on Feeds was made with software used on Debian 5 so everything should be compatible
Why not? Security issues. Later more about this in the IPtables and ssh setup part

• Install Debian 5 Lenny without Windowmanager / Desktopmanager on a PC. See also Installing Debian to get some help
  • Set the network to a fixed IP address
• Remove with aptitude
  • vim-tiny
  • reportbug
• Install with aptitude
  • When it shows up, unselect portmap
  • powertop (to check system load on slow computers)
  • powermgmt-base
  • apache2 this also will install, among other dependencies
    • apache2-utils
    • apache2.2-common
    • mysql-common
  • curl
  • fail2ban
  • libapache2-mod-php5
  • mysql-server this also will install, among other dependencies
    • mysql-server-5.0 (Give the mysql database a password)
    • mysql-client-5.0
  • mysqltuner
  • mysql-admin
  • openssh-server
  • php-pear
  • php-xml-parser
  • php5
  • php5-cli
  • php5-common
  • php5-curl
  • php5-mysql
  • unzip
  • vim

Based on the powertop advice we did

• echo 1 > /sys/module/snd_ac97_codec/parameters/power_save
• echo 1500 > /proc/sys/vm/dirty_writeback_centisecs

See keypairs

• setup IP tables so only acceptable access to the PC is granted
• Restart the network /etc/init.d/networking restart
• iptables-restore < /etc/iptables.up.rules
• mkdir /etc/our_iptables_rules
• Create /etc/our_iptables_rules/iptables.up.rules t.b.d.
• Create a link in /etc/rc2.d with the command ln -s /etc/our_iptables_rules/iptables.up.rules /etc/rc2.d/S96iptables

Some mysql commands
Login as root in a terminal
Start MySQL with the command mysql -h localhost -u root

• To remove a database DROP DATABASE db_name;
• To remove a user DROP USER 'user'@'localhost';
• To create a database CREATE DATABASE db_name;
• To show all databases SHOW DATABASES;
• To show the datebase being used at this moment SELECT DATABASE();
• To show all users SELECT User, Host, Password FROM mysql.user;
• To show active users SELECT USER();
• To use a database USE db_name;
• Some more
  • UPDATE user SET Password=PASSWORD('my_password') WHERE USER='root';
  • SELECT User, Host, Password FROM mysql.user; Show all users
  • SELECT * FROM mysql.user; Show all information from all users
  • FLUSH PRIVILEGES;
  • SHOW GRANTS fof_user;
  • SHOW ENGINES;

Some more from others
My simply MySQL Command Line Cheatsheet
Handy MySQL Commands
Set up the mysql data base

• As root start enter a terminal mysql and do ENTER
• Login to mysql: mysql -u root -p
• Enter password: [The mysql password you entered when mysql was installed]
• CREATE DATABASE feedonfeeds;
• SHOW DATABASES; You should get something like

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| feedonfeeds        | 
| mysql              | 
+--------------------+
3 rows in set (0.00 sec)

• USE feedonfeeds;
• CREATE USER 'fof_user'@'localhost' IDENTIFIED BY 'the fof_user password'; The ' are needed
• To change the password SET PASSWORD FOR fof_user@localhost = PASSWORD('new_fof_user password');
• GRANT ALL PRIVILEGES ON * . * TO 'fof_user'@'localhost';
• EXIT; (leave mysql)
• In a bash terminal check with mysql -u fof_user -p if you can login to the mysql database. If not check the password for invalid characters like \. To directly login to the right database use mysql -h localhost -u fof_user -p feedonfeeds. The localhost part can be ommitted
• cd /etc/apache2/mods-enabled/
• ls -l and check if php5.conf and php5.load are present

• CREATE TABLE test (a INT NOT NULL, b CHAR(10));
• SHOW TABLES;
• DROP TABLE test;
• SHOW WARNINGS; (and errors)

To restart mysql do /etc/init.d/mysql restart. On a systemd system use systemctl restart mysqld
To restart apache do /etc/init.d/apache2 restart. On a systemd system use systemctl restart apache2
If mysql did not have a password or you forgot your mysqld root password do mysqld --skip-grant-tables
See:
How to reset your root MySQL password
Mysql how to fix access denied for user rootlocalhost
How to create a new user and grant permissions in mysql

Get Feed on feeds from the Feed on Feeds github page
Do:

• mkdir /var/www/feedonfeeds
• mkdir /var/www/feedonfeeds/cache
• cd /var/www/feedonfeeds
• cp /home/user/downloads/feed-on-feeds-master.zip /var/www/feedonfeeds
• unzip feed-on-feeds-master.zip
• chmod -R 775 /var/www/feedonfeeds
• chown -R root:www-data /var/www/feedonfeeds
• cp fof-config-sample.php fof-config.php
• Do vi fof-config.php and make the changes described on the FeedOnFeeds about page
• On a remote machine do, via ssh, http://IPofFoFserver/feedonfeeds/install.php

Then you get something like

Checking compatibility... PHP ok... XML ok... PCRE ok... MySQL ok...
Your PHP installation is either missing the cURL extension, or it is too old! cURL version 7.10.5 or later is required to be able to subscribe to https or digest authenticated feeds.
Zlib ok... iconv ok... mbstring ok...
Minimum requirements met!
Creating tables... Tables exist.
Inserting initial data... Done.
Checking cache directory... Cache directory exists and is writable.
You now need to choose an initial password for the 'admin' account:
Password:	
Password again:	

• /etc/init.d/mysql restart
• chmod 644 install.php

Error: cURL error 35: Unknown SSL protocol error in connection to www.example.com:443
Error: cURL error 35: error:14077410:SSL routines:SSL23_GET_SERVER_HELLO:sslv3 alert handshake failure
Error: cURL error 35: error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version

Main subjects on this wiki: Linux, Debian, HTML, Microcontrollers, Privacy

RSS
Disclaimer
Privacy statement
Bugs statement
Cookies
Copyright © : 2014 - 2022 Webevaluation.nl and the authors
Changes reserved.