New pages
Most visited
- collectNWData Overview
- Welcome
- raspiBackup - Raspberry backups itself
- How to find out which Linux distribution a script runs on
- collectNWData.sh version history
- Pydev unresolved import errors in Eclipse
- CND0240E: knetworkmanager for network configuration enabled but network card configuration for %1
- How to emulate Raspberry Pi with QEMU
- collectNWData Quickstart
- Distributions supported by collectNWData
raspiBackup - Raspberry backups itself
- Details
- Hits: 22367
raspiBackup allows to manually or automatically create backups of Raspberries. Raspberry doesn't have to be stopped. Instead important services have to be stopped just before starting the backup. When the backup has finished they have to be started again. Backups can be restored on any SD cards. An external rootfilesystem will be included in the backup. NOOBS images are supported.
If there are any questions or issues to report use the comment function at the end of the page.
raspiBackup - Restore a backup
- Details
- Hits: 5528
With raspiBackup you can create regular backups of your Raspberry. This script contains also code which restores the backup. It creates a new partition table on the target SD card and restores the backuped data.
SQL joins made easy
- Details
- Hits: 1938
SQL is not very easy to learn, in particular joins of multiiple tables are difficult to understand at a first glance. On the next pages it's explained for sql beginners how SQL joins work. Venn diagrams are used to explain how the tables are combined. In addition sample tables with sample data and sample joins are used to explain in detail the query input data results. SQL files to create the sample data and execute the queries can be downloaded. The samples are for mySQL and DB2.
 |
 |
 |
 |
 |
Docker in 5 minutes by example with a Wordpress- and MySQL-Installation
- Details
- Hits: 579
The german computer magazin c't periodical No 5 from 2/20/2016 has multiple interesting articles about docker and how to create a wordpress installation very fast. The following article explains how to install docker on Linux Mint 17.1 and summarizes the commands explained in c't about docker and how to setup a local wordpress via docker. Additional commands about docker are also explained in addition how to create your own nginx docker image. Other articles in the computer magazin explain in detail the way docker works and how to orchestrate containers.
Raspberry PI Trafficlight Sample Program written in Python with Threading
- Details
- Hits: 559
To learn to use threading in Python you have to have a concrete problem to solve. Just use Raspberry Pi to connet 6 LEDs and manage them via GIO. On the following pages I describe how to customize my sample program to simulate tarffic lights. You also find a video which shows the program in action and a download link for the sample program.
How to move a root partition of a Raspberry Pi to an external partition
- Details
- Hits: 325
There are various reasons (performance, space, ..) why you want to move your root partition from your Raspberry sd card to an external device like an USB disk or USB stick. You can do it manually or use a small script to achieve this.
Calculate geolocation (Longitude and latitude) and local sunrise and sunset time
- Details
- Hits: 957
It's very useful if your Raspberry can trigger events based on time and sunset and sunrise. That's why I did some investigations on this and finaly found two APIs in the internet which allowed me to write a Python script to calculate these values very fast. gneadr found another interesting variant which I modified a bit. The location calculated is the place where the internetprovider offers the IP address to the client and which can be far away from the actual client location. In my case it's approx 30 km.
Protect Raspberry Pi against internet attacks and disable attacks into the local network with a firewall using iptables
- Details
- Hits: 1305
The Raspberry Pi is a nice system which is used a lot of time to provide server services to be accessible from worldwirde. That's Owncloud, a HTTP server, seafile or other servcies..
A VPN ist the right way to access the server in a secure way. But if you want to give a lot of people access there is no way other than to allow access driect from the internet. Usually you use a DMZ for this but that's a feature a normal home router doesn't have. But now you should protect the pi from internet access as far as you can and also protect your home network from access from the pi server when an intruder managed to get access to the pi. But if an the intruder managed to get root access then the iptables firewall will be turned off very quickly. So it's very important so get SW updates on a regular base and to protect root access with w secure password.
Following article describes how to configure an iptables firewall to protect it from unauthorized access from the internet and to protect a local home network to be attacked from the server - just in case.
mySQL installation step by step
- Details
- Hits: 550
If you want to use the SQL example files from this website and execute them on your system you have to setup a mySQL database on your system. It's quite easy and the following steps describe how to setup and configure mySQL on Linux Mint11. On other Linux distributions the way to install mySQL will be the only different step.