das ist mal interessant

Filed under: logging — jj at 9:17 am on Thursday, February 19, 2009

het nederlandse wooord van het jaar : zwaffelen

bei ubuntu shutdown: cifs vfs: no response for cmd 114 mid 25

Filed under: logging — jj at 10:03 pm on Friday, January 2, 2009

root@haddock:/etc/rc6.d# mv S31umountnfs.sh S14umountnfs.sh

root@haddock:/etc/rc0.d# mv S31umountnfs.sh S14umountnfs.sh

siehe hier:

http://blog.avirtualhome.com/2008/03/10/ubuntu-shutdown-problem-cifs-related/

Order By Comma List MySQL, Kommalisten in Listenreihenfolge zurueckgeben

Filed under: logging — jj at 7:25 pm on Wednesday, December 31, 2008

You can have your sql query return the records with order by “a list of commaseparated values” which is very handy if you have do deal with lists of records stored as lists of ids. sorting in typo3 would be an example.

SELECT col1, col2, col3
FROM table1
WHERE col1 IN ('z', 'x', 'y')
ORDER BY find_in_set(col1, 'z,x,y');

how to unzip self extracting exe under ubuntu

Filed under: logging — jj at 8:52 pm on Tuesday, September 9, 2008

if you happen to having bought hardware from idiot companies packing their firmware files as self extracting exe files, don’t feel stupid. we all do and we will all continue to do so. unfortunately.

usually: no problem:
unzip idiot-companies-stupid-firmware.exe
enjoy

now CANON.

f.ing stupid idiot company packing their f.ing firmware update into a self extracting exe that cannot be unpacked by unzip. ok, we are used to that, is that so stupid? well, you can unzip it with wine.

do:
mv e5kr4109.exe ~/.wine/drive_c/ficken.exe
cd ~/.wine/drive_c/
wine ficken.exe
[select where tu unzip it in one of those typical dialogs…]

now let’s get back to the stupid idiot part of it:

jj@haddock:~/.wine/drive_c/eosfirmware$ ls -l
total 14620
-rw-r–r– 1 jj jj 7397084 2008-06-25 11:11 e5kr4109.fir
-rw-r–r– 1 jj jj 7547856 2008-09-09 20:31 ficken.exe

yes.

one file.

one f’ing file that actually got larger by packing it into a stupid format that makes it inaccessible to parts of your customers. thank you stupid canon. thanks a lot stupid idiot canon. they even provide dmgs rotfl. i don’t want to know what’s in there hahahahaahaha;)

Einige Arbeiten, die beim synchronisieren von GPS Tracks und EXIF Daten in Fotos anfallen

Filed under: history repeating — jj at 1:40 am on Sunday, September 7, 2008

Exif Datum anzeigen:

506 exiftool -d ‘%d.%M.%Y’ -DateTimeOriginal -S -s *.JPG
507 exiftool -d ‘%Y-%m-%d’ -DateTimeOriginal -S -s *.JPG

Ggf. korrigieren
512 exiftool -DateTime +=’0:1:0 0:0:0′ 2008-08-08-exifcorrection/

519 exiftool -AllDates+=718:30 -if ‘$make eq “Canon”‘ test
520 exiftool -AllDates+=24 -if ‘$make eq “Canon”‘ test

Timestamps in Tracklogs korrigieren
gpsbabel -t -i gpx -f in.gpx -x track,move=+1h -o gpx -F out.gpx

Next Page »