Forum OpenACS Q&A: Re: Painful progress

6: Re: Painful progress (response to 1)
Posted by Andrew Grumet on
Just did a fresh install after not having touched
infrastructure for a few years, seems like as good a place
as any to do a brain dump, should it be useful to Chris or
anyone else 😊

-- CentOS 5.x

-- AOLserver 4.0.10
  -- mod aolserver/include/
    -- -nostartfiles to CFLAGS_EXTRA
    -- see
  -- mod aolserver/nsd/unix.c
    -- see
  -- mod aolserver/nsd/conn.c
    -- see 
  -- When making modules
    -- Set both NSHOME and AOLSERVER to the installdir
    -- Remember to set ACS=1 when making nspostgres

-- Oracle 11g
  -- nsoracle: HEAD of CVS at Sourceforge
    -- Set these manually in Makefile...autodetection doesn't work
      -- OCI_VERSION=11.1

-- Postgres 8.3
  -- tsearch2 is integrated, no need to install it
     unless you're migrating in an existing pre 8.3. db.
  -- if you're migrating in a pre pg8.3 openacs, you need
     to define this

     create or replace function bitfromint4 (integer)
     returns bit varying as '
     return $1::bit(32);
     end;' language 'plpgsql' immutable strict;

-- Other random stuff
  -- If want to run behind a reverse proxy, e.g. apache, and 
you're running on something other than port 80, older 
versions of openacs (and newer?), util_current_location 
needs a patch to support the "apparent port" which may be 
different from the port aolserver is listening on:

--- utilities-procs.tcl 6 Nov 2004 05:04:47 -0000
+++ utilities-procs.tcl 25 Feb 2008 08:00:03 -0000
@@ -2727,7 +2727,7 @@
     switch [ad_conn driver] {
         nssock {
             set proto http
-            set port [ns_config -int "ns/server/[ns_info server]/module/nssock" Port]
+            set port [ns_config -int "ns/server/[ns_info server]/module/nssock" ApparentPort [ns_config -int "ns/server/[ns_info server]/module/nssock" Port]]
         nsunix {
             set proto http