Articles by Tris Forster

Arch Linux

Tue 22 April 2014

Arch linux cribsheet

Australian 250K Maps

Wed 09 April 2014

KMZ raster versions of Geoscience Australia's NatMap 250 dataset.

Shoddynet upgrade

Thu 03 April 2014

As part of a server upgrade I've done a general clearout of all the useless really crappy posts. The less crappy posts have been cleaned up and migrated to Pelican.

As you were...

Linux, EFS and rsync

Fri 16 November 2012

Though the linux ntfs-3g driver can't decrypt EFS files, it can copy them if you use the right flags and options.

# vol needs to be mounted with the efs_raw options
sudo mount -t ntfs-3g -o efs_raw /dev/sdX1 /mnt/src
sudo mount -t ntfs-3g -o efs_raw /dev/sdY1 /mnt/dst …

Resetting VBA passwords

Wed 26 May 2010

Dont waste your money on 'Password Recovery Tools'!

The following perl oneliner will change the password to 'unlocked'.

perl -pe 's/DPB="[A-F0-9]+"/DPB="B4B6182718713571358ECB723594D9F51AEB7F0E3ECB35E389309035ADD32D4F47176BF5ECD2"/' locked.xls > unlocked.xls

Tested with Excel and Word (2003). Note this is just for VBA passwords, not sheet/document protection, though I'm sure there …

Spliting strings in Bash

Tue 28 April 2009

Using string modifiers to extract part of a string

$ x=a:b:c
$ echo ${x%:*}
a:b
$ echo ${x%%:*}
a
$ echo ${x#*:}
b:c
$ echo ${x##*:}
c