Faux' blog

Google Earth "offline installer"

Google seem to be of the incorrect opion that you want your machine infected with Google Update.

The Google Earth download is actually just a cunningly disguised Google Update installer, and it seems to think it needs elevation.

It extracts %TEMP%\GUXXXXX.tmp\GoogleUpdate.exe, then tries to run:

GoogleUpdate.exe /install "appguid={74AF07D8-FB8F-4d51-8AC7-927721D56EBB}&appname=Google%20Earth&needsadmin=true" /installelevated

Instead of this,

GoogleUpdate.exe /install "appguid={74AF07D8-FB8F-4d51-8AC7-927721D56EBB}&appname=Google%20Earth"

..will happily download and extract Google Earth to %TEMP%\7ZipSfx.XXX. This is the unpacked offline installer, but the installer itself still attempts to elevate. Luckily, it's already unpacked, in:

%TEMP%\7ZipSfx.XXX\program files\Google\Google Earth

Just copy this folder to somewhere convenient and run googleearth.exe.

--

For reference for other apps, the quoted argument to GoogleUpdate.exe is the last "line" in the downloaded GoogleEarthSetup.exe.

Noelevate

In Windows Vista, Microsoft added manifests, a way for developers to require that their applications run as administrator, or not at all. This takes control away from the user, me, who I trust, and gives it to some developer (who I might not). While it's possible to edit the file to remove these manifests, this is hard to do safely and automatically.

I thought it'd be fun to directly fix the problem.

It seems that, like some other things, as far as I can see, there's no support for this.

Luckily, it's an even smaller patch than last time. I won't show it, it's simply erasure of a jmp. It's a terrible solution to the problem, and the binary only contains fixes for kernel32.dll as seen on x64 SP1 and x32 SP1 as of now, it could break at any point. I implore nobody to use this utility seriously.

noelev (asc) (cpp) (pdb) works much like the reverse of the unix "sudo" command, running a command via. it makes it run without elevation.

It's not infectious, so it won't work for all applications (like some setup applications that unpack other installers), and, of course, some applications actually don't work without elevation.

A lot of Windows components actually appear to cope relatively gracefully with the unexpected lack of permissions, unlike, say, the nVidia components. I was hoping to find an entertaining failure to screenshot, but they're all boring. :(

Ergonomics

I decided on Thursday that I don't actually use my right-thumb for any keys whilst typing, my left exclusively operates the space-bar, and there are no useful modifier keys on the right-hand side of a Microsoft Ergonomic 4000 Keyboard.

I decided to add something useful:

If you can't tell by the head, it's the remains of an xbox 360 controller:

This, combined with a modified version of mousex gives you an almost usable mouse.

Now I just need to train myself to use it.

As an aside, I used to be worried about damaging the wrist wrests and the other pieces of the body (both of which you can see mutilated above). I am no longer, they're almost indestructable. I had to switch from a craft knife to a stanley knife to get through the faux-leather on the wrist wrest.

Eclipse and database deadlocks

I encountered an interesting issue today.

I work with some code that relies heavily on the database it backs on to. Today, it was backed onto Microsoft SQL Server. Right after starting, it would deadlock.

Looking at the stack of randomly picked threads I found that one was waiting indefinitly for the server to return.

A quick glance at the SQL Server's Activity Monitor revealed that "process id" 3, was waiting for "process id" 1. "Process id" 1 was sleeping, but in a transaction.

That's helpful, I thought, I now know the problem, "process id" 1. So, where's it happening in code? Uh oh.

I poked around, and noticed that com.microsoft.sqlserver.jdbc.SQLServerConnection (no, not com.microsoft.jdbc.sqlserver.SQLServerConnection) has a piece of private implementation called transactionDescriptor, an 8-byte array including the process id on the SQL Server. I set a detail formatter to show just this value.

Following this, Eclipse's find all instances command comes into play, allowing you to search for all instances of SQLServerConnection, then all references to the specified connection. Both of these are only available in Java 6 and above, otherwise the command will be greyed out.

From here, you can (manually, as far as I know) search through the stack trace and hopefully find that one of your threads has the above class (or a class that refers to the class, or a class that refers to a class that...) in it's trace; the culprit.

A mere hour of my day, gone. :|

Taglib Property Handler

Tonight marks the first public release of Taglib Property Handler, an Explorer extension for Vista that allows it to read metadata from many audio file types:

Currently, it's fully read-only, so there's minimal risk to your data, and the default install doesn't cause you to lose any existing functionality.

The list of supported properties shows what the default handler supports for MP3 and WMA, and what TLPH supports so far.

This release comes after four months of swearing at Microsoft for the entire property handler system being impossible to debug. Four months ago I had the handler working in Windows Explorer, but Windows Search would refuse to show any properties it provided. There're plenty of articles on debugging this situation, which I ran through hundreds of times, in the end this turned out to be caused by:

1. Explorer accepting VT_BSTR and Windows Search not; solved by switching to InitPropVariantFromString.
2. Stupid mistakes with pointers. Oh, how I hate you.

Yay, productivity

I (finally) have a job, and, suddenly, (I'm sure it's unrelated) start feeling relatively productive outside of work.

I'm trying to learn the Colemak keyboard layout again, I've produced a version of Colemak with more UK symbol keys (self extractor) (.asc) on (for example, ", @, ¬ in the right places). MSKLC 1.4 source included, should work on XP and Vista.

I wrote a tool a while ago for a friend show whether drives were spun up or not. I just changed it to a little tray applet:

It also notifies you when drives spin down and up. Currently it operates by polling, at a hardcoded 15s interval. Feel free to change the source.

powerstatustray.exe (.asc) (.cpp) (.pdb).