Richard's Log

Public notepad about stuff I am currently playing with...

Install Nginx PHP and MySQL on Raspberry Pi

Previously we have installed Raspbian, now we can do some actual work and install Nginx, PHP and MySQL on our Raspberry Pi. Afterwards we can use our Raspberry Pi as full-fledged home webserver.

Install Raspbian on Raspberry Pi

Raspbian “wheezy” is optimized version of Debian for Raspberry Pi. We will talk about how to install Raspbian on SD card so it is bootable on Raspberry Pi. This guide is almost identical with official wiki, but we will also upgrade firmware and run some comparison tests. We will do all the work in Linux terminal, if you are looking for graphical environment or Windows installer I suggest oficial wiki.

How to get back free space after deleting MySQL database

One of the MySQL characteristics when using InnoDB is, if you delete database, MySQL is not able to return empty space back. If you have small databases you probably didnt even noticed it. However if your databases have several GB, you probably wish to get it back.

How to start Django project correctly

To start project on solid foundation, we have to do several things. In this article we will talk about what is required to be done to have Django project that is independent on packages in operating system, is versioned with Git, has database migrations. We will also scratch how to easily create our own functions for automatic deployment and testing on local or remote server.

PHPNW 2012

I have been lucky and during the weekend I attended PHPNW 2012 in Manchester. I would like to express my feelings and shortly describe what it was about. Conference has started on Friday with workshops and probably most interesting was Rob Allen and Evan Coury with: Building a Zend Framework 2 Application.

Serving static files in production environment with Django and Apache

Launching Django project in production environment, sometimes can end up in a state where pictures, css, javastript and other things might not load. Mostly this is result of wrong static files setup. In this article we will show how to set it up correctly.

How to start with virtualenv?

As the name virtualenv implies, it is isolated virtual environment, which allows us install multiple versions of python applications and libraries on one system.

EXT3/EXT2 filesystem in Mac OS X Lion

While ago I needed to mount EXT3 file system in Mac OS X Lion, it doesn’t seems as a big problem as there is plenty of manuals how to do it. Unfortunately most of them are out of date. So I have decided to write down how to do it.


  1. CentOS
  2. Mac OS X
  3. Nginx
  4. Conference
  5. Django
  6. Python
  7. virtualenv
  8. Zabbix
  9. Asuswrtn
  10. SNMP
  11. Raspbian
  12. EXT3
  13. Raspberry Pi
  14. PostgreSQL
  15. PHP
  16. git
  17. Ludolph
  18. Apache
  19. MySQL
  20. backups