#
# Tcl Configuration
#
ns_section ns/server/${server}/tcl
    ns_param   Library            /web/${server}/tcl
    ns_param   autoclose              on
    ns_param   debug                  false

# ----> Add this line pointing to your aolserver tcl-modules 
#       directory
    ns_param SharedLibrary /usr/local/aolserver/modules/tcl

The parameter SharedLibrary used to appear in openacs-3.2.5 sample nsd.tcl. Maybe the sample openacs-4-nsd.txt in file-storage should be updated or is that an effect of the new bootstrap?

Download the latest version of ns_xml from sourceforge.net: http://acs-misc.sourceforge.net/nsxml.html

[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Querying 'begin transaction;'
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Ns_PgExec: Entering transaction
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: dbinit: sql(ljserv.local.leifjensen.com::leifjensen): 'begin transaction'
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Querying '

        select apm_package_version__add_file(
                NULL,
                '5',
                'acs-kernel.info',
                'package_spec',
                NULL
                );'
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Ns_PgExec: Trying to reopen database connection
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Opening leifjensen on ljserv.local.leifjensen.com, port
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Error: Ns_PgOpenDb(postgres):  Could not connect to ljserv.local.leifjensen.com::leifjensen:  The Data Base System is starting up

[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Ns_PgExec: In transaction, conn died, error retu
rned
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Error: dbinit: error(ljserv.local.leifjensen.com::leifje
nsen,pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
): '

        select apm_package_version__add_file(
                NULL,
                '5',
                'acs-kernel.info',
                'package_spec',
                NULL
                )

      '
[12/Sep/2001:00:09:56][19585.4101][-conn0-] Notice: Querying 'abort transaction;'
Killed
-----------------------------------------------------


  Looking in the postmaster log, yes, the postmaster had dropped out:

DEBUG:  connection: host=[local] user=leif database=leifjensen
DEBUG:  InitPostgres
DEBUG:  StartTransactionCommand
DEBUG:  query: SELECT usesuper FROM pg_user WHERE usename = 'leif'
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select apm_package_version__add_file(NULL, '5', 'acs-kernel.info', 'packaage_spec', N
ULL);
DEBUG:  ProcessQuery
DEBUG:  query: SELECT  file_id from apm_package_files where version_id =  $1  and path =  $2
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 2125 exited with status 139
Server process (pid 2125) exited with status 139 at Wed Sep 12 01:32:57 2001
Terminating any active server processes...
Server processes were terminated at Wed Sep 12 01:32:57 2001
Reinitializing shared memory and semaphores
invoking IpcMemoryCreate(size=1236992)
postmaster: ServerLoop:        handling reading 5
postmaster: ServerLoop:        handling reading 5
DEBUG:  database system was interrupted at 2001-09-12 01:31:33 CEST
DEBUG:  CheckPoint record at (0, 28229264)
DEBUG:  Redo record at (0, 28229264); Undo record at (0, 0); Shutdown TRUE
------------------------------------------------------------------


  I tried to execute this 'select apm_package_version__add_file...' thing manually in psql and quite right, the connection dropped out .

  I am using PostgreSQL  version 7.1.1. I tried this a couple of times, dropping/recreating the database with the same result. I scanned for the apm_package_version__add_file function, but I couldn't find it anywhere, though it must be there since it was in the database.

  Please help, what am I doing wrong?

Leif

>      Also you can do: "createlang plpgsql template1", which will automatically create the pgsql
>      language for every new database.

  Yes, that would make it a little easier to start all over