Note: Apparently it works fine with Windows too! See comments.

I'm pretty excited right now. I just tried drush make for the first time. Download it here:
http://drupal.org/project/drush_make

That's an order! You'll need drush too, if you don't have it yet (in which case, shame on you ... call yourself a Drupal developer?!)
http://drupal.org/project/drush

Here's another one of my little Linux admin scripts for all you Drupal developers out there. It's a Linux shell script requiring Drush, MySQL and Subversion, but could be easily modified to work with other databases and repositories and should work fine on a Mac, I think.

Those familiar with Windows (and I guess Mac OSX too) will probably be aware that you can get an é character from your keyboard by pressing AltGr + E. You may not be aware that in Linux you can't. This was a bit of a problem for me, as I live in France, a country who's native language relies rather heavily on the accents in the special character set. For example, the town I'm in is called Uzès and my daughter is called Moïra. It's also been driving my wife bananas, since she actually needs to write emails and letters in French but we have British keyboard layouts.

Quick post today, no politics *whatsoever*. ;-)

I just wrote another little batch script for deploying my Drupal sites from local to stage. Before I post the code, here's the workflow here in our office at CMS Professionals:

• Code is stored in Subversion away on the Internet (svn.cmspros.co.uk)
• Each developer has a working copy on their laptop
• Database during development is held on central (dedicated) CentOS/MySQL machine on our office LAN

A few weeks ago I wrote a post about how to bring a stock CentOS 5 server up to spec to run Drupal 6. It seems only fair I do the same for Debian and Ubuntu, since it seems they too are not without their little issues when a stock install. This quick post was written after configuring a server running Ubuntu 8.04.2 (or Hardy Heron, as it was codenamed).

The first (and main) problem with a stock Debian install is it does not include the necessary GD support for manipulating images. There is a long internal squabble in the Debian ticketing system here:

This is more a bookmark for my reference than anything, but if you have a stock CentOS 5.x installation (maybe from a VPS image or a clean install on a dedicated box) you're going to have issues with Drupal 6.x.

It comes down to PHP version. It ships with PHP 5.1.6 and Drupal these days pretty much depends on PHP 5.2.x upwards to work. Utilities like Drush do too, so leaving PHP as it is, you'll find, is not really an option. To confirm you will have this problem, execute this command to check your PHP version:

Ok, here I am at DrupalCon Paris blogging about Linux. WTF? Sorry, sorry, but I'm blogging this before I forget how I did it.

Note: This is written with Fedora 10 and Gnome. Apparently KDE has a desktop zoom feature which sounds like it achieves the same thing more easily. Although this is Fedora 10, I guess it should work for any Gnome desktop.

If you have a small-screened laptop or netbook (in my case, an EEE PC 901) and you want to "zoom out" your desktop and applications but can't go to a larger screen resolution, what do you do? With Gnome it's a two step process:

Very quick post today. I rather foolishly didn't look at a back-up of a MySQL database someone sent to me this morning. I didn't realise it contained a copy of *their* mysql table. So when I restored it, all my user data got replaced with their user data.

Frack.

Worse. Their setup did not have a root user. I'm not sure how that works out for them, but it properly stumped me! Anyway, after a good degree of poking around on Google and trying various techniques, I finally found a restore for the MySQL root user that actually works:

Just thought I'd throw this one up there. It's a Linux bash shell script I wrote this morning. You know when you want to take a copy of your production database down to localhost for testing? Not rocket science, but a bit of a pain. This dramatically speeds things up.

In the past I've copied and pasted an old shell script that's been kicking around on my hard disk for years, changed the details and run it. Well this morning I thought "Enough!" I tidied it up so it accepts arguments and even has a --help argument response. This is the code:

if [ $1 = "--help" ];

I didn't know how to get Evolution's auto-complete feature to behave, so I Googled around. The most useful HOWTO was here:
http://www.sigmundvoid.com/2007/07/evolution-mail-client-and-auto-comple...

But it's down for now. Google still has a cache of the page, so I thought I'd take it while I still can. It's too useful to die!

Evolution mail client and auto complete addresses.

Evolution is a wonderful mail client based around Gnome, you can think of it as the Outlook alternative for Linux users, it can even connect to Microsoft Exchange server.