martinmurphy.com – Martin Murphy

Saw this on TUAW, I’ve been looking for that functionality since I switched to Mac. Although it’s useful to be able to specify a folder path and avoid having to traverse the folder lists, a bigger benefit for me is being able to specify a directory that you can’t reach normally in an open/save dialog, /tmp for example.

Thanks TUAW, I should probably read all the Mac 101 posts

TUAW Article.

I just noticed the mysql client “--i-am-a-dummy” parameter in the help output (from mysql --help)
This interestingly named synonym for “--safe-updates” looks like it should be set as the default on any live mysql database. The command is supposed to block updates and deletes that don’t use keys. As an example, it could be used to protect against the proverbial (but not uncommon) “dummy” entering a command like:
UPDATE users SET password = PASSWORD('secret');
instead of the intended command:
UPDATE users SET password = PASSWORD('secret') WHERE user_id = 521;

Following on from my previous post Installing Ruby on Ubuntu, I tried to install/compile Ruby (and rubygems, rake) on Ubuntu server 7.04. Since Ubuntu Server is a “minimal” installation for use on a server, various development tools need to be installed, I used the following commands:
apt-get install build-essential autoconf manpages-dev
and also
apt-get build-dep ruby1.8
Without doing the last step you get errors building rubygems
/usr/local/lib/ruby/site_ruby/1.8/rubygems/remote_fetcher.rb:4:in `require': no such file to load -- zlib (LoadError)

Yes, I realise it’s a bit of a cheat to take the dependencies of the Ubuntu ruby package.

Saw this on mocoNews.net this morning: Symbian Slingplayer In Private Beta
Looks interesting, even with the number of operators making video available on mobile, this allows an individual get the video content that they have available, in their home or office, delivered to their phone.
So, while they’re on a train, or waiting in an airport, etc. they can get the news, the latest soap, or the view from the security cameras at home/office. This is obviously subject to bandwidth availability and cost. (uploading from home and downloading to phone).

The Past:
I’m a long-time user of SSH. I presume that I was typical in my initial use of it for secure access to remote servers. But I quickly became familiar with its port-forwarding capabilities, and have often set up intricate webs of connected and nested tunnels, in order to negotiate the problems of multiple NAT servers and firewalls. I even considered myself a power-user.

The Present:
Today, while checking out A Defcon survival guide on The Register, I noticed that they had mentioned the -D parameter to SSH. It was that kind of “in-passing” reference, where you know they think they’re stating the obvious. You’ve probably guessed though, that it was not obvious to me.
Enter the Ubuntu SSH Howto, and in particular the “SSH as a Proxy” section. How could I not know that a SSH could run as a SOCKS proxy, tunnelled to a remote server? Now I’ll be able to run SOCKS capable client applications (including web browsers) across lots of network configurations, without having to identify and forward individual ports. Brilliant!

The Future:
Wait, what’s that I see? At the bottom of the page there’s a link to SSH VPN. It can’t be. Not full networking access (routing,UDP,etc) over an SSH tunnel using the “tun” driver. Yes it is, it’s amazing. I can’t try this one out at the moment, but it will be a definite must-have for me (very soon).
Anywhere, on any network, once I have SSH access, I can get full access to my home network. (Or, if I wanted, an Amazon EC2 node that I could start when I needed full Internet access)

What lessons I’ve learned today, and not just about SSH. It’s important to check out the features and updates of software and networking tools that you use. Especially, if you already consider them important and useful. Don’t fall into the trap of thinking you already know how to use them, even if, like me, you’ve been using the tools for too many years to remember.

Now, I’ve also been using Ethereal for a long time, but a colleague has recommended WireShark, I must find out which one is better

Excellent tip here to Create an in-cell bar graph with Excel
from the Lifehacker Shortcut Screencast Contest. Really handy for quick graph, and it works in OpenOffice.org also.

Screencasts look like a good way to distribute tips like this, so I’ll have to look into that for the future, maybe using Jing for screenshots and screen recordings as suggested by Paul Watson. I wonder if there’s something to add a voiceover.

Well, after my earlier problems with the automated Fantastico upgrade, I did the “manual” upgrade to my Wordpress installation. I was moving from 2.0.6 to 2.2.1 following the instructions from Wordpress.

It all went perfectly. Well done on the instructions (and the software).

At the end of the upgrade instructions, there’s a section called
Special note for Fantastico Upgrades, which mentions removing the DB_CHARSET and DB_COLLATE parameters if upgrading with Fantistico. Presumably the DB_CHARSET parameter is what affected the accented characters in my earlier upgrade attempt. So, if upgrading Wordpress using Fantistico, read the manual instructions! (pity I didn’t see this earlier.) I expect this will soon find itself into the Fantastico procedures, or at least the documentation, however I think I’ll stick with the manual upgrade in future.

• Don’t upgrade just because there is a newer version available.
• Check the release notes and other documentation for any problems with the new software.
• Verify the upgrade in a test environment first. This is not always a realistic option, but if you don’t do it then backups become even more important.
• Backup your current live system (and verify the backup).
• Allow enough time for the upgrade of the live system.
• Verify everything is working correctly after the upgrade. This is the point where the problems appeared for me. However, I was able to revert to the earlier version – which had luckily been backed up by the software doing the installation and not me (I should learn to follow my own advice.)

In case you’re wondering, the problem was “just” a visual, where accented characters were not being displayed correctly in Wordpress 2.2, hopefully 2.2.1 fixes it. I’ll have to wait until I get some more time to do a test and a hand install, rather than the automated Fantastico install.

This is an interesting introduction to Flash Lite – including getting data from the network – in the current issue of Dr. Dobbs Journal. Well it’s probably only interesting if, like me, the only thing you already know about Flash Lite, is that some people can make nice looking demos with it
Dr. Dobbs | Flash Lite: Graphics for Mobile Devices | June 8, 2007

Just saw this post on TUAW: RubyCocoa 0.11.0 released – The Unofficial Apple Weblog TUAW

Looks interesting for anyone wanting to develop Mac applications in Ruby.