Skip to content

Category Archives: Applications

Removing Messages from Mailman Archives

15-Jan-09

To remove messages from Mailman archives, do the following: Stop mailman, to prevent the mailbox file from being written to while you’re editing it. Edit the .mbox file for the list. Rerun bin/arch from the Mailman installation: sudo -u mailman bin/arch –wipe mailinglist

MySQL Ports Installation Checklist

30-Dec-08

A brief summary of after-installation MySQL configuration when using FreeBSD’s ports system. Log into the database as root, and run the following commands to remove anonymous accounts: use mysql; delete from user where User=”; delete from db where User=”; flush privileges; SET PASSWORD FOR root@localhost=PASSWORD(‘newgoodstrongpassword’); SET PASSWORD FOR root@127.0.0.1=PASSWORD(‘newgoodstrongpassword’); SET PASSWORD FOR root@host.example.com=PASSWORD(‘newgoodstrongpassword’);

Suexec’ed PHP-FastCGI on Apache2

30-Dec-08

Code Snippets has an example post on how to do Suexec’ed PHP-FastCGI on Apache2.

Quickly Remove IP Addresses from spamdb

30-Dec-08

To remove all whitelisted entries in – for example - 69.6.0.0/16 run: # spamdb | grep WHITE | egrep ‘\|69\.6\.’ | \ cut -f 2 -d ‘|’ | xargs -L 1 spamdb -d

Using GNU tar to create and restore incremental backups

30-Dec-08

The GNU tar manual has a very complete section on how to use tar to both create and restore from incremental backups: http://www.gnu.org/software/tar/manual/html_node/Incremental-Dumps.html.

Download a GPG Key From a Public Keyserver

29-Dec-08

If you have a keyserver already set: > gpg –recv-key CA6CDFB2 Otherwise: > gpg –keyserver hkp://subkeys.pgp.net –recv-key CA6CDFB2 In these examples, CA6CDFB2 is the key ID of the key being downloaded.

Overriding DHCP Server-Provided Settings with ISC’s dhclient

28-Dec-08

To override settings offered by a DHCP server, use /etc/dhclient.conf. For instance, to prepend a DNS server to the server-provided list and change the domain name, use: prepend domain-name-servers 127.0.0.1; supersede domain-name “int.hurricane-ridge.com”;