Forum OpenACS Q&A: OpenACS on Win2k: again..

Collapse
Posted by Adam Farkas on
I'm attempting to write a "how-to" for OpenACS on Win2k.

Has anyone gotten the AOLserver/PG driver to work under Win2k?

There were a few threads a while back, but no resolution to the issue.

thanks.

Collapse
Posted by Alin Vaida on
I just did it on NT 4.0, and I suppose this should work on Win2k
Collapse
Posted by C. R. Oldham on
I'm trying to load the data model for OpenACS 3.2.5 on pg 7.1.1 under Win2k.  This is the latest postgresql from the cygwin distribution.  The following statement from homepage.sql is making the postgres backend terminate with status 139:

select hp_get_filesystem_root_node(1);

This seems to indicate there is some problem with the plpgsql function, but there doesn't appear to be anything wrong with it.  I tried commenting it out, but at the end of survsimp.sql there is this statement:

select administration_group_add ('Simple Survey System Staff', short_name_from_group_name('survsimp'), 'survsimp', '', 'f', '/survsimp/admin/');

And I discovered that 'select short_name_from_group_name('survsimp')' also will cause the backend to fail.

Has anyone seen this?

--cro

Collapse
Posted by Roberto Mello on
Don't run PG 7.1.1. It has a bug on PL/pgSQL functions returning NULLs IIRC. Use PG 7.1. When PG 7.1.2 comes out, use that instead.
Collapse
Posted by C. R. Oldham on
Thank you Roberto, that did it.  I'm back on 7.1 and I successfully created the data model.

--cro