This is an internal document about how to build the ]po[ Windows installer. This document should not be publicly linked on www.project-open.com. The information provided may be incomplete or even incorrect.
The instructions below are for creating the ]po[ V5.0 Windows installer on 2017-02-27.
Do a standard 64bit install of CygWin in C:\project-open\.
First do a standard install with the base packages only. In a second step select and install the following:
Package selection:
We are currently using version 3.0.1
You need to install the following plug-ins:
Plugin not found, cannot call registry::_KeyExists
There is a "binary distribution" of PG available for win64 as a ZIP. We currently use:
Unzip into C:\project-open\pgsq.
Please note that more recent PostgreSQL versions are incompatible with Windows 2008 Server and Windows 7.
Now install PostgreSQL with the commands from the installer:
net user postgres "Qwer.1234" /add /fullname:"PostgreSQL" # ToDo: UF_PASSWD_NOTREQD, UF_DONT_EXPIRE_PASSWD, SeBatchLogonRight, SeServiceLogonRight chown -R postgres "/pgsql" chmod -R go=u "/pgsql" chgrp" -R Users "/pgsql" sc create postgresql-9.2 \ binpath= "$INSTDIR\pgsql\bin\pg_ctl.exe runservice -N \ postgresql-9.2 -D $INSTDIR/pgsql/data -w" \ DisplayName= "]po[ PostgreSQL 9.2" start= "delayed-auto" \ type= own obj= ".\postgres" password= "Qwer.1234" sc start postgresql-9.2
You can manually run PostgreSQL with the following command (from within a CygWin shell):
/pgsql/bin/pg_ctl.exe -D "C:\project-open\pgsql\data" start
Some error messages that you might encounter then and how to fix them:
Finally initialize the database and load a database backup from the ]po[ product master:
initdb -D "c:/project-open/pgsql/data" --encoding=utf8 --locale=en_US chown -R postgres:Users /pgsql chmod -R go=u /pgsql psql -f pgback.project-open-v50.projop.20170223.0529.sql projop > import.log 2>&1 & psql -c "select count(*) from persons" projop
Java is used to run the "Service Panel" for starting/stoping/show the status of the ]po[ server. We currently use:
This installer starts off with the OpenACS installer from Maurizio Martignani from SpazioIT.
However, we have decided for a different layout of files:
/usr/local/tcl8.5.18 Official TCL source distribution /usr/local/ns/bin nscgi.dll nscp.dll nsd.dll nsdb.dll nsdbpg.dll nslog.dll nsoracle.dll nsperm.dll nssock.dll nsssl.dll nsthread.dll /usr/local/ns/lib nsf2.0.0 XoTcl libraries tcllib1.18 TCLLib nfs2.0.0 XoTcl libraries tdom0.8.3 XML parser libraries Thread thread2.8.0 threads libxotcl1.6.7.dll XoTcl DLL /usr/local/ns/tcl TCL Library
Manually Testing PostgreSQL
There is a known issue with Windows Server 2012 R2 causing an installation failure of the Visual Studio 2015 vcredist_x64.exe. Please make sure Microsoft updates KB2919442 and KB2919355 are installed (in this order), before starting with the installation of ]project-open[.
- Cleanup unused DLLs in /usr/local/ns/bin
Calle Aprestadora 19, 12o-2a
E-08907 Hospitalet de Llobregat (Barcelona)
Tel Europe: +34 932 202 088
Tel US: +1 415 429 5995
Mail: info@project-open.com