Author: halfgaar

http://www.halfgaar.net/

Halfgaar is Wiebe. Wiebe is a contributing author on this weblog. He also has a lot of stuff (such as long, in-depth articles) on his personal website.

Wiebe works at YTEC, where he is a senior developer of customer-specific tailor-made software (“klantspecifieke maatwerk software“) for clients in a few select markets: wholesale, printing and healthcare.

CUPS printer driver for my HP4050

My HP4050 has a million different drivers to choose from. Some don't have the maximum DPI, some don't have other options, like selecting paper output. The one that works the best seems to be "HP LaserJet 4050 Series Postscript (recommended) (grayscale, 2-sided printing)". However, I have no idea anymore if that came from hplip, foomatic, gutenprint, or whatever. Read More »
By halfgaar, 10 years ago, on August 17, 2011, at 23:08 | Comments closed

Converting a MySQL database from latin1 to utf8

mysqldump dbname > dbname_bak_before_messing_with_it.sql mysqldump --default-character-set=latin1 --skip-set-charset dbname > dump.sql sed -r 's/latin1/utf8/g' dump.sql > dump_utf.sql mysql --execute="DROP DATABASE dbname; CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;" mysql --default-character-set=utf8 dbname < dump_utf.sql Read More »
By halfgaar, 10 years ago, on August 16, 2011, at 15:08 | Comments closed

Setting up a postfix fallback MX

These are some short stepts and pointers to setup a postfix fallback MX. It does not describe postfix basics, nor how to install Mailscanner (a necessisity, because spammers like sending spam to fallback MX's because they're usually not as well protected). Read More »
By halfgaar, 1 decade ago, on May 22, 2011, at 09:05 | 2 comments

Postfix queue: sender and recipient address

I always seem to forget this, and the mailq command is not clear, so here it is: when you type mailq on a postfix server, the first address listed is the sender, the second the recipient. Read More »
By halfgaar, 1 decade ago, on May 04, 2011, at 11:05 | Comments closed

Adding SPF support to Postfix

(Hmm, this suggests the python version might be better). Read More »
By halfgaar, 1 decade ago, on April 28, 2011, at 15:04 | Comments closed

Tracking Xen domU’s with munin

To view statistics of your xen server with Munin (source): Read More »
By halfgaar, 1 decade ago, on April 21, 2011, at 10:04 | 2 comments

Getting a better MySQL prompt

When you want to see which user you are and which database you're working with, put this in .my.cnf: prompt=(\\u@\\h) [\\d]>\\_ Read More »
By halfgaar, 1 decade ago, on April 18, 2011, at 10:04 | Comments closed

Sending yourself a test virus

I found this handy little site to send yourself a harmless test virus. Read More »
By halfgaar, 1 decade ago, on April 14, 2011, at 11:04 | 2 comments

Installing a commercial SSL certificate in Zimbra

Edit: now in 2020, with Zimbra 8, and Startcom out of business, things have changed a bit. So, here are the steps now, for a Sectigo certificate (and referring to their directory structure): Read More »
By halfgaar, 1 decade ago, on April 12, 2011, at 20:04 | 3 comments

Installing Munin-node on a Debian or Ubuntu machine

If you want to gather statistics on a machine with a Munin server, install munin node: aptitude -P install munin-node munin-plugins-extra Read More »
By halfgaar, 1 decade ago, on April 06, 2011, at 14:04 | 4 comments