DB_File 1.806 for SpamAssassin 2.60

SpamAssassin 2.60 requires the installation of DB_File for its Bayes filter.

Here's the problem I ran into when I compiled it. It happens during testing:

DB_File needs compatible versions of libdb & db.h

        you have db.h version 4.0.14 and libdb version 2.4.14

The README file tells me that I'm pretty much screwed since I use perl 5.6.0 and it includes a version of the Berkeley DB which is going to make it hard for me to match up with db.h.

I give up on this installation and wait for the day when my local perl installation will be magically updated to 5.6.1 or later. In the meantime, my spamassassin will run without Bayes.

Install: OpenFTS-tcl 0.3.2 (failed)

As per .LRN 1.0.1 installation instructions, ran:

./configure --with-aolserver-src=/tmp/src/aolserver/aolserver --with-tcl=/usr/lib/tcl8.3

But when running make, the build system couldn't find the tcl header files.
I found the easiest solution was to symlink all the files I could find in /usr/include/tcl8.3 into this source package's include directory. [NOTE: I later found that these header files are in the aolserver/aolserver/include directory]

Unfortunately, another step in the installation requires the building of supplemental modules which must be constructed from a PostgreSQL source tree that includes the contrib directory. These sources, I don't have available since I have a Debian package installed. But even if I had the corresponding sources, I don't even know if PostgreSQL 7.2.1 would even work for these installation instructions, which presuppose 7.2.4.

At this point, I'm going to postpone an attempt at installing this feature. When .LRN 2.0 comes out, it's possible that it will support PostgreSQL 7.3 in which case we can install the Debian package (of testing status) which might already include this contributed module pre-compiled.

Install: AOLserver 3.3oacs1

Just followed .LRN 1.0.1 installation directions.
I installed in /usr/local/aolserver as directed.

Modifications necessary:

• Contrary to my normal in-house installation procedure, I did not run my homegrown lnsrc script. The symlinks created by lnsrc make the installation create incorrect destination files.
  
• I had to modify conf-make to contain "make" instead of "gmake".
  

Compilation error encountered:
After compilation, I checked the build logs in the log directory and found that nspostgres did not compile right:
nspostgres.h:48: libpq-fe.h: No such file or directory
make: *** [nspostgres.o] Error 1
It turns out that I need the posgresql-dev Debian package installed, as per this AOLserver mailing list thread. I also had to unset POSGRES environment variable, unlike what the instructions say. And I had to fix the nspostgres Makefile, which has PGLIB and PGINC switched in one of their definitions. This will force the Makefile to figure out where the include files are.

I tested the AOLserver as per instructions (with one difference being to use the 'www-data' group instead of the 'web' group).

Install: PostgreSQL 7.2.1

This is my attempt at installing database PostgreSQL 7.2.1 on Linux Debian 3, as required by the Learning Management System .LRN 1.0.1 which is built on the web application server OpenACS 4.6.3. Apparently, on my machine someone has already installed the PostGreSQL 7.2.1-2woody2 package. But the post-installation script was not run; in other words, no functioning database is up and running.

Upgrade

There was a 7.1 database installed on the machine, which had not yet been updated and which no one was claiming. Instead of letting the postgresql post-installation script update this probably useless database, I just moved the /var/lib/postgresql/data directory out of the way.

Default database

Then I unleashed /var/lib/dpkg/info/postgresql.postinst configure, which created the default template1 database.

From now on, the database should be automatically restarted upon booting via /etc/init.d/postgresql start

.LRN/OpenACS installation instructions

I followed .LRN installation instructions with respect to postgresql.

Added plpgsql support to template1:
createlang plpgsql template1
createlang -l template1
Actually, it was already done.

Tested PostgreSQL by creating a temporary database.

Tuned PostgreSQL.

Install: .LRN 1.0.1

This is my attempt at installing the Learning Management System .LRN 1.0.1 on Linux Debian 3.

Prerequisiste Software

Software installed:

1. .LRN 1.0.1 which includes OpenACS 4.6.3
   
2. tcl8.3-dev Debian package (already installed on my machine)
   
3. libxml2 and libxml2-devel Debian packages (already installed)
   
4. AOLserver 3.3oacs1 (instead of the AOL server 3.4.2-1 package available because the offered version should have all the patches needed by OpenACS.)
   
5. OpenFTS TCL 0.3.2
   
6. Analog 5.23-0woody1 Debian package (already installed)
   
7. PostgreSQL 7.1.2-2woody2 Debian packages, including postgresql-contrib and postgresql-dev (partially installed)
   

To be installed later:

1. Analog 5.32 Debian testing package
   
2. Daemontools 0.76
   

.LRN installation

Created the lrn user.
Created a /usr/local/openacs/web directory for OpenACS services.
Created the lrn user with that directory as its home.
Did the CVS checkin and -out.
Created the appropriate directories.

Created postgresql user and database.

Configured AOLserver.

Configured the AOLserver service for .LRN by using the OpenACS Installer through the web, allowing the database to be initialized.

Backed up the database.
Updated CVS

Installed cron job to back up the database daily.

Set up analog.
Linked images with this command:
ln -s /usr/share/doc/analog/images /usr/local/openacs/web/lrn/www/log

Running through proxy

Because my machine already had an Apache server listening on port 80 and serving other users on the machine, I had to use a proxy to redirect to the OpenACS web server.

Here are my changes to the apache configuration:
<VirtualHost 25.219.351.34>
ServerName openyourmind.com
ServerAlias *.openyourmind.com
ServerPath /openyourmind
ProxyPass / http://127.0.0.1:8000/
ProxyPassReverse / http://127.0.0.1:8000/
</VirtualHost>

And I had to modify config.tcl in /usr/local/openacs/web/lrn/etc/config.tcl to set address 127.0.0.1. Don't know why I had to do that.

Note that 'localhost' didn't work in place of 127.0.0.1.

Of course, I also had to set up DNS to accept this virtual host.

Upgrade: Movable Type 2.21 -> 2.64 (failed)

After following version 2.64 upgrade instructions and pointing my browser to mt-upgrade25.cgi, I get:

Running 'alter table mt_author add column author_preferred_language varchar(50)'

An error occurred while upgrading the schema:

alter command denied to user: 'mt@localhost' for table 'mt_author' at /home/www/mt/mt-upgrade25.cgi line 61.

I give up.