the reality tunnel

I’ve been playing around with Drupal for work and wanted to use mod_auth_kerb to authenticate Drupal users. The Webserver Auth module seemed helpful, but only worked in Drupal 4. I got the module working with Drupal 5.5 running on Apache 2.2.3 using mod_auth_kerb 5.1.

Link to my patch to make webserver_auth-4.7.x-1.x-dev work with Drupal 5.x
Link to documentation  on updating  Drupal 4.7 modules to Drupal 5.

I’ve been working on setting up a Drupal instance for work and have, for the first time been using Postgres for the database instead of MySQL. I was installing the Content Template module and got errors when the module tried to create the tables by default. I think the problem is with the fact that the CREATE statements in contemplate.install use MySQL-only data types.  It seems that others have reported this problem as there is an issue on the Drupal site at http://drupal.org/node/172775 .

I was able to create working tables manually with the following syntax:

CREATE TABLE contemplate (
    type character(32) DEFAULT '' NOT NULL,
    teaser text NOT NULL,
    body text NOT NULL,   rss text NOT NULL,
    enclosure character(128) NOT NULL,
    flags integer DEFAULT 0 NOT NULL,
    PRIMARY KEY (type)
);CREATE TABLE contemplate_files (
    site character(255) NOT NULL,
    data bytea NOT NULL,
    UNIQUE (site)
);

I made a patch to contemplate.install that fixed this issue. download

Once I got past the table creation, the module still returned SQL errors when I tried to update the template for a CCK content type. This seemed to be due to a problem with the SQL syntax. I made a patch to contemplate.module that fixes this in Postgres. I don’t know if it ends up breaking MySQL in the process. download

Oh yeah. I’m using Drupal 5.5 with contemplate 5.x-1.8 and Postgres 8.1.9

Helping out with the AMC website, I threw together a quick Drupal 4.7 module (haven’t tested it on newer version of Drupal yet) to export user profile data generated by the profile module to a CSV file suitable for import into a spreadsheet program.

UPDATE: After searching the Drupal website, I realized that someone had already invented this wheel.

Link