Logging client IP of reverse proxied web traffic

Thursday, 05. 18. 2006  –  Category: all, sw

‘Cos I always forget: LogFormat       "%{X-Forwarded-For}i %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" proxy This just makes Apache log the IP in the X-F-F HTTP header instead of %h in reverse-proxy scenarios.

MySQL 4.0 -> 5.0, unicode

Thursday, 03. 2. 2006  –  Category: all, sw

Things: Loading a ISO-8559-1 encoded dump into a UTF-8 database breaks, fields are truncated at the first non-valid character. Not terribly surprising, but MySQL is silent about the breakage. Content which looks like, and is declared, ISO-8559-1 might actually get rendered by browsers as CP1252 (aka MS-ANSI WINDOWS-1252) The difference between these two are that […]

FreeBSD GEOM mirroring

Friday, 02. 3. 2006  –  Category: all, sw

‘Cos I keep losing it, here‘s a link to mirroring your new FreeBSD install without all the fiddly scripts of the other Google hits :)