he1ix' blog

Monitor All SQL Queries in MySQL is a very nice (though short) posting about how to debug and monitor what’s going on inside your DBMS. There’s supposed to exist a similar tool for MSSQL called “Profiler”.

That’s just a few records on my personal experience regarding the hot-swapping/hot-plugging capabilities of SATA… Continue reading ‘hotplugging SATA harddisks in Linux’ »

approximately since forever the default look of a directory listing by the apache web-server gave me the creeps, so today I googled a bit around and checked how to make them look more up-to-date.

here’s a nice post describing a pretty simple way: CSS Styling Apache Directory Listings

if you want to make them more usable with an iPhone/iPod touch, simply add something like this to the header-section of your HTML:

<!-- iPod/iPhone Safari support -->
<meta name="viewport" content="width=400" />

This sets the default viewport to a specific width, instead of Mobile Safari’s default of 960, where you can’t read a single letter…

ever wondered where TSM stores its passwords? Documentation and lots of websites are talking about the file TSM.PWD, but where is it?

Voilà: /etc/adsm/TSM.PWD

to create a user for doing automated backups of a MySQL installation that doesn’t have more than the necessary privileges, use the following statement:

GRANT RELOAD, SELECT, LOCK TABLES ON *.* TO 'backup'@'localhost' IDENTIFIED BY 'some_reasonable_password';

for mail in $(sudo mailq | grep frozen | cut -c 11-26) ; do
    sudo exim4 -Mrm $mail
done

extend or adjust the grep-pattern as required by your situation…

required packages: qemu-arm-static
see: binfmt

sudo debootstrap --foreign --verbose \
    --variant=buildd --arch arm \
    lenny `pwd`/lenny_arm \
    http://ftp.de.debian.org/debian/

Ever got messages like this in your Apache logfiles, wondering why setting properties via a client on your (otherwise working) WebDAV is failing?

Could not open the property database.  [500, #205]
(2)No such file or directory: Could not open property database.  [500, #1]
(2)No such file or directory: Attempted to set/remove a property without a valid, open, read/write property database.  [500, #202]

Well, simply add a directory called “.DAV“ (note the leading dot!) to your WebDAV base-directory, that is writeable to the webserver. That’s where the corresponding information will be stored by Apache. Note that this is “somehow” mentioned by the mod_dav documentation at webdav.org, but not by Apache’s documentation itself. Yes, that’s bad and pretty annoying.

finally, CalDAV evolves to a pretty common standard. sun microsystems is about to contribute a client for symbian: blog.symbian.org.

Links:

psw.net
SSL Direct

CAcert (Eintrag auf Wikipedia)