Monday, March 19, 2012 Uncategorized

There’s a nifty tool called Swftools out there which enables you to extract resource files out of an swf file (Adobe Flash). This little bash one-liner will extract all sounds from an swf file: for i in swfextract soundboard.swf |grep Sounds:|cut -c 24-|sed ’s/,//g’; do swfextract -s $i soundboard.swf

Monday, January 30, 2012 Uncategorized bsod, windows

Just another blue screen of death.

Thursday, September 15, 2011 Uncategorized

You may wish group_concat while working with MS SQL Server. Here’s a solution! Say you have these tables: a: id, content b: id, val rel_a_b: a_id, b_id The SQL query [default]select a.*, stuff( ( select cast(’;’ as varchar(max)) + b.val from b inner join rel_a_b on b.id = rel_a_b.b_id and rel_a_b.a_id = a.id for xml path(’’) ),1,1,’’) as vals_combined from a[/default]

Wednesday, February 24, 2010 Uncategorized

Today I’ve had some serious battles with Dovecot running on a wild cpu time spending spree. I recently made an apt-get upgrade on my Debian system. Somwhere in there things went awkward. An imap process simply wouldn’t stop on /etc/init.d/dovecot stop nor kill -9 [dovecot-pid] The process took 100% cpu and eventually the whole system, including kernel, froze. Had to cold reboot it via IPMI three times! Thank god for IPMI.. Anyways I found this mailing thread with the same issue. What seems to have solved to problem for me was to upgrade Debian from lenny to unstable, including the latest Debian kernel (2.6.32.2-686) and Dovecot 1:1.2.10-1 and keeping my fingers crossed while rebooting. I also noticed some complaints for a missing “cpusieve” plugin. Uncommenting plugin = cmusieve in dovecot.conf was necessary.