Forum OpenACS Q&A: Intranet module problem

Hi,

I recently decided to try out OpenACS, and so far it seems rather
impressive. Except being dog slow with only 48MB RAM and X running 
too...maybe i should try reducing my db caches...
Anyway, I can't get the intranet module to work. Yesterday i 
installed 3.2.2 and dumped my old acs db. The new installation went 
without any errors, also during the loading of the data model (I 
followed the new installation instructions quite closely). When I try 
to access the intranet module it just gives me a HTTP 500 error 
(=internal server error). As a weird sidenote, trying to access the 
intranet module from localhost results in a "You are not an emplyee" 
message. Yes, I have added my user to the employee group in User 
Groups -> Intranet. But this shouldn't matter anyway, because my user 
is also a system wide admin. It gives the same error message for the 
system user too. My guess is that there is some kind of db error 
because my connection attempt is listed in the access log and 
postgres churns for a while before I receive the http 500 response. 
Also the same thing happens when i copy a vanilla index.html file to 
the /intranet directory and try to access it, so apparently aolserver 
never gets to evaluating the standard index.tcl file. Maybe some 
error during permission checking in the db? I did the data model 
loading as nsadmin (aolserver user) instead of as postgres as someone 
in this forum suggested a while ago. If that is wrong maybe update 
dox? Also I cannot access the employee administration page which is 
linked from /admin/intranet, it gives me the same http 500 response 
(and "Not employee" when trying from localhost).
Apparently there are similar problems with the bookmarks module (most 
of the modules seem to work fine), but I haven't studied that any 
closer yet. I got mailed the following:

    Error: nsd.tcl: Database operation "select" failed (exception 
NSDB, "Query was not a statement returning rows.")
    Database operation "select" failed (exception NSDB, "Query was 
not a statement returning rows.")
        while executing
    "ns_db select $db $bookmark_query"
        invoked from within
    "set selection [ns_db select $db $bookmark_query]..."
        (file "/var/web/mytestsite/www/bookmarks/index.tcl" line 77)
        invoked from within
    "source $ad_conn(file)"
        invoked from within
    "if { $extension == ".tcl" } {
    	# Tcl file - use source.
    	source $ad_conn(file)
        } elseif { $extension == ".adp" } {
    	# ADP file - parse and return  ..."
        (procedure "ad_handle_abstract_url" line 65)
        invoked from within
    "ad_handle_abstract_url cns51 {}"

    Notice: Querying 'select ad_group_member_p(3, 
system_administrator_group_id()) from dual;'

Some hopefully helpful info:
OS: Red hat 6.1 with 2.2.16 kernel
AOLServer 3.0 (binary tar.gz from www.aolserver.com)
PostgreSQL 7.0.2 (installed from rpm:s)
OpenACS 3.2.2 (tar.gz from OpenACS.org)
OpenACS Pg driver 1.01 (also openacs.org)