Recovery of passwords from Draytek Vigor routers

Recently, I needed to recover a DSL password that only persisted in an oldĀ router (Draytek Vigor 2500/We). Since the web interface only shows the username, I tried the backup feature that dumps the entire configuration to a file that you can download. Unfortunately, this data comes in an encrypted form… which makes an excellent exercise […]

Remove items from Ubuntu’s indicator applet

Ubuntu 10.04 (Lucid Lynx) features new panel applets called “indicator applets”. If you want to get rid of some of them, they can be removed by removing the corresponding package(s) using your favourite tool (Synaptic, aptitude, apt-get, …): indicator-me provides the menu with your avatar and your availability status indicator-messages provides the menu for email/Evolution, […]

Automated MySQL backup for shared webhosting

What to do if you want to use mysqldump in a shared hosting environment without being able to access the shell (SSH…)? Use a Perl CGI script: #!/usr/bin/perl -w use strict; use CGI::Carp qw(fatalsToBrowser); print “Content-type: text/plain\nContent-disposition: attachment; filename=\”db_backup.sql\”\n\n”; print qx(mysqldump -uUSERNAME -pPASSWORD DATABASE 2>&1); Replace USERNAME, PASSWORD and DATABASE with the configuration data for […]

Clean MySQL backup using mysqldump

If you need to configure a backup of a MySQL database server, you shouldn’t simply copy it’s database files from /var/lib/mysql since they might be inconsistent (due to simultaneous changes). mysqldump is a safe choice for this task. I wrote a simple script for Debian that uses the pre-configured “debian-sys-maint” account and compresses the output: […]