Table of Contents
If you want to send us your comments, please do so. Thanks
More on comments
Installing Feed on Feeds on Debian 5 Lenny
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
- 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
Tune the system
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
Set up ssh with keypairs
See keypairs
Set up IPtables
- 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
Set up the mysql database
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
Some more mysql commands
- CREATE TABLE test (a INT NOT NULL, b CHAR(10));
- SHOW TABLES;
- DROP TABLE test;
- SHOW WARNINGS; (and errors)
Solving mysql issues
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
Install Feed on Feeds
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
Errors
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 - 2024 Webevaluation.nl and the authors
Changes reserved.