Archive for June, 2007

Debian Sarge2Etch Upgrade

I have upgraded Debian from Sarge to Etch on various systems and did not run into any problems. Well done, Debian guys!
The following tutorial is based on Tim Bormann’s tutorial. I give you a quick-and-dirty insight how I have done it.
Before you start, make sure you got plenty of time (an upgrade may take anything between 30 minutes and 3 hrs) and backup at least your system configuration:
Read the rest of this entry »

ProFTPd xferlog via MySQL

Logging your FTP transfers to xferlog with ProFTPd is a nice thing. This can easily be done by a one-liner in /etc/proftpd/proftpd.conf:

TransferLog /var/log/proftpd/xferlog

This generates a nice transfer log which we could then parse for transfer statistics. But there is a much better way to accomplish this: MySQL. Let’s use MySQL for everything!
It’s pretty straightforwarded to get ProFTPd to log into a MySQL table.

Read the rest of this entry »