2008 June

Migrating mailman lists

# rsync -avz /usr/local/mailman/lists root@new-server:/var/lib/mailman/

Migrating mailman lists

By WladyX on 30 June, 2008 | General, Mail | A comment?

Truecrypt

Truecrypt HOWTO:

http://blog.gnu-designs.com/truecrypt-on-linux-with-xfs-and-ext2ext3-volumes

Format as ext3 FS:

Here’s how I created a Ext3-filesystem in a external Truecrypt device.

truecrypt -l

gives you information about your mounted Truecrypt drive. Typical output:

/dev/sde2 /dev/loop0 /media/truecrypt1

You need to unmount the volume using

sudo umount /media/truecrypt
1

Then you can format the volume (the encrypted volume that is):

sudo mke2fs -j -m0 /dev/loop0

This will format your encrypted volume into Ext3.

When finished, just Dismount it using the Truecrypt GUI, and then mount the whole thing again. Now, you’ll have an encrypted Ext3-formated volume!

Arctic Linux: Ext3 in Truecrypt 5.1a

Convert WordPress database from Latin1 to UTF-8

$ mysqldump –default-character-set=latin1 –databases wordpress > m.sql

$ replace “CHARSET=latin1″ “CHARSET=utf8″ \
“SET NAMES latin1″ “SET NAMES utf8″ < m.sql > m2.sql

$ mysql < m2.sql

wp-config.php:
define(‘DB_CHARSET’, ‘utf8′);
define(‘DB_COLLATE’, ”);

atppp’s Blog » Convert WordPress database from Latin1 to UTF-8

MySQL tunning

max_connections = 500
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 256M

key_buffer_size=512M
table_cache=2048
sort_buffer_size=32M
read_buffer_size=16M

http://www.profitpapers.com/papers/performance-tuning-mysql-for-load.php
http://www.professionalmiddleman.com/blog/2007/10/mysql-table-is-.html
http://rackerhacker.com/mysqltuner/

By WladyX on | Mysql | A comment?

MySQL table is full error

you’ll want to change this line in /etc/my.cnf from:

innodb_data_file_path = ibdata1:10M:autoextend:max:128M

to

innodb_data_file_path = ibdata1:10M:autoextend

Professional Middleman: MySQL table is full error on Gentoo Linux

Postfix and Postgrey

By WladyX on 10 June, 2008 | Mail | A comment?

Change mac address

By WladyX on 7 June, 2008 | General | A comment?

Firefox 3 extensions

By WladyX on 4 June, 2008 | Firefox | A comment?