Skip to main content

Learning the Hard Way: Installing Drupal on XP

Open Source on Closed Source. Probably a bad idea from the start.

Installing Drupal hearkened back to the old days of computing. Way too much jargon and far too little push-a-button-and-it-works. But I'm sold on the Drupal. If I wasn't, I wouldn't have made it through the past two hours trying to install it (I'm tempted to say her here, which suggests a certain love-hate relationship is already evolving).

Drupal installations should be straight forward. Lullbot manages the whole install in one five minute video that I would highly recommend. My installation took significantly longer.

MySQL - At least in my instance the directions for setting permissions given in INSTALL.mySQL.txt were not sufficient to allow the database creation scripts to run.

Command provided in INSTALL.mysql.txt:
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';

Command that fixed it:
  GRANT ALL PRIVILEGES ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';

Maybe I mistyped, but if I did, I mistyped several times as I repeated the directions more than once.

This one was painful. I use Firefox almost exclusively, but in hoping to find a Windows-specific permissions error messages I switched over to IE in the previous step. Because when you create the first super-administrator account IE7's firewall blocks Drupal's reply with the default super-administrator password. As a result I was stuck on this screen for 90 minutes. I'd enter the information and screen would just postback blank.

I googled everything I could think of:
  • first user account nothing happens drupal
  • cannot get password for first account drupal
  • can't get password for administration account drupal 5
  • can't create first user drupal
  • show users mysql
  • http://localhost/drupal/index.php?q=user/register
  • cannot admin account drupal
NOTE: Included here in hope this may lead another lost soul to the light.

And finally I found the answer on the drupal Forums in one of tens of entries on roughly the same problem. It wasn't base URLs, it wasn't Apache settings (I'm on IIS)... it was Internet Explorer 7!

Internet Explorer blocking open source software. There's some irony in here somewhere I'm sure.


Popular posts from this blog

Simple HTTP Redirect with Querystring in IIS7

HTTP Redirect seems simple enough. Always was in IIS6 and in IIS7 there's even a button labeled HTTP Redirect that promises relative redirects.  It looks like it'll be as easy Apache finally.  That is until you try to redirect a querystring.  Then everything bombs.

Turns out it still is relatively easy, except you have to know that Microsoft changed $S$Q to $V$Q. Why? $Ss and $Gs I suspect.

And How.
In our example we'll redirect all pages under to
Pick the virtual directory you want to redirect. e.g. Click HTTP Redirect under IIS in the IIS management console.In the HTTP Redirect Dialog:
Check Redirect requests to this destinationEnter your new path ending with $V$Q.  e.g.$V$QCounter-intuitively check Redirect all request to exact destination (instead of relative destination)Choose the appropriate Status Code (Permanent or Temporary)Apply Changes and Test

ArcGIS One-to-Many Labeling

ArcGIS is just plain lousy at dealing with any relationship that isn't one-to-one.

We all have a slew of hacks just to deal with this limitation. I for one regularly am creating temporary cross-tab queries so I can represent multiple sample results at a collection point, fish surveyed at a cross-section and a host of other relationships.

The classic example for mapping comes from the cadastral community and condominium lots. It's an odd situation where more than one person has title to the same piece of ground. How do you represent this?

I've got a new trick thanks to Mohammed Hoque's article in ArcUser Magazine.

We're going to do a database query inside a label expression, loop through the results and output the entire list to label.

For our example we'll use Outfitting Areas in Idaho and we'll label them with the Outfitters and Guide License Numbers and Outfitter Names.

1.) Open ArcGIS and add your spatial layer with the unique identifier shared with your d…

Serving up KML in IIS 6

To serve up KML in IIS 6, you have to add a few MIME Types. The easiest way to do this is to apply new MIME Type settings globally by changing the properties on your server's "Web Sites" folder in IIS.

Google Earth reads KML and KMZ files. The MIME type for KML files is

* application/

The MIME type for KMZ files is

* application/

Source: Google KML Tutorial

To add a MIME type to a Web site or directory

1. In IIS Manager, right-click the Web site or Web site directory for which you want to add a MIME type, and click Properties.

2. Click the HTTP Headers tab.

3. Click MIME Types.

4. Click New.

5. In the Extension box, type the file name extension.

6. In the MIME type box, type a valid MIME type. If you define a MIME type that has already been defined at a higher level, you are prompted to select the level where the MIME type should reside.

To create a MIME type for an undefined MIME type, type an asterisk (*) in the Extension box, an…