my notes

Rsnapshot: backing up mysql databases

Install mysql-client if not installed, this will provide the mysqldump utility

# apt-get install mysql-client


# cp /usr/share/doc/rsnapshot/examples/utils/backup_mysql.sh /usr/local/bin/

Make sure your backup scripts are owned by root, and not writable by anyone else.

# chown root.root /usr/local/bin/backup_mysql.sh
# chmod o-w /usr/local/bin/backup_mysql.sh

This scripts is designed only to back up all databases to a single file.

Chroot SFTP Users on Debian

Check your openssh-server version as it must be over 4.8


# dpkg --list | grep openssh-server

Edit sshd_config file

# nano /etc/ssh/sshd_config

search for Subsystem sftp, comment it out and below add

Subsystem sftp internal-sftp

User Setup

Replace hadzo with your user name

# useradd -m -s /bin/false hadzo

or

# useradd --create-home --shell /bin/false hadzo

Tags

Automatic installation of security patches on Debian

If you plan to automatically upgrade your system you should only use the stable distribution with the security debian repository. For more info on Debian security read http://www.debian.org/security/

To easily get the latest security updates use repository below


deb http://security.debian.org/ squeeze/updates main contrib non-free

Add the security repository to cron-apt

Open con-apt config file

# nano /etc/cron-apt/config

Tags

Nginx Catch-All Host As Front End To Apache For ISPConfig 3 On Debian Lenny

Author: Nedim Hadzimahmutovic <nedim [at] inservio [dot] ba>

Version: v1.1

Last Change: May 19, 2010

Introduction

Apache has always been the web server of choice for me. It is a real beast when it comes to resources usage specially in a resource limited environment such as a VPS. I started playing with Nginx a lightweight, high performance web server. My area of interest was running Nginx as a reverse proxy and making it work in a Apache/ISPConfig 3 environment.

 

Tags