Forum OpenACS Q&A: xowiki install, which prerequisites?

I have a fresh installation OpenAcs 5.4.1, which is presented as the latest stable.
I have issues installing various packages, xowiki install for example comes up with errors.
Reading the forum it appears that PostgreSQL 8.3 is not yet supported. I therefore installed 8.2 like in here:
http://cognovis.de/developer/en/pg82
still couldn't install xowiki.
I considered installing Postgres 7.4, but in the compatibility matrix it appears no longer supported from Openacs 5.3 upwards.

In the bugtracker, OpenAcs 5.4.1 does not appear as a version, although clearly has been released.

I am therefore a little bit confused and asking your opinion, which version OpenAcs, Aolserver, PostgreSQL do you recommend?

thanks,

Collapse
Posted by Gustaf Neumann on
xowiki works with postgres 7.4, 8.* and oracle. xowiki requires xotcl-core, which requires XOTcl (see https://openacs.org/xowiki/xotcl-core).
Collapse
Posted by Maurizio Martignano on
Dear Pavel,
I've installed, tested and validated the following configuration on both Linux (OpenSuse 10.3) and Windows (XP, and Vista) both with PostgreSQL 8.2.7 and with Oracle 10g and Oracle 11g.

Applications:
<table border="1">
<tr><td>Package</td><td>Version</td></tr>
<tr><td>Openacs</td><td>5.4.1</td></tr>
<tr><td>File Storage</td><td>5.4.0d6</td></tr>
<tr><td>General Comments</td><td>5.2.0</td></tr>
<tr><td>Notifications</td><td>5.4.1</td></tr>
<tr><td>Search</td><td>5.4.1</td></tr>
<tr><td>xowiki</td><td>0.83</td></tr>
</table>

Services:
<table border="1">
<tr><td>Package</td><td>Version</td></tr>
<tr><td>ACS Events</td><td>0.6d2</td></tr>
<tr><td>ACS Reference Data</td><td>5.4.1</td></tr>
<tr><td>ACS Translation Storage</td><td>5.4.1</td></tr>
<tr><td>API Browser</td><td>5.4.1</td></tr>
<tr><td>Authentication</td><td>5.4.1</td></tr>
<tr><td>Automated Testing</td><td>5.4.1</td></tr>
<tr><td>Bootstrap Installer</td><td>5.4.1</td></tr>
<tr><td>Categories</td><td>1.1.2d3</td></tr>
<tr><td>Content Repository</td><td>5.4.1</td></tr>
<tr><td>Date and Time Utilities</td><td>5.2.2</td></tr>
<tr><td>Documentation</td><td>5.4.1</td></tr>
<tr><td>Kernel</td><td>5.4.1</td></tr>
<tr><td>Localization</td><td>5.4.1</td></tr>
<tr><td>Mail Services Lite</td><td>5.4.1</td></tr>
<tr><td>Messaging</td><td>5.4.1</td></tr>
<tr><td>RSS Support</td><td>0.3</td></tr>
<tr><td>Reference Data - Timezone</td><td>5.4.1</td></tr>
<tr><td>Service Contracts</td><td>5.4.1</td></tr>
<tr><td>Site-Wide Administration</td><td>5.4.1</td></tr>
<tr><td>Subsite</td><td>5.4.1</td></tr>
<tr><td>Tcl Library</td><td>5.4.1</td></tr>
<tr><td>Templating</td><td>5.4.1</td></tr>
<tr><td>Tsearch2 Driver</td><td>5.4.1</td></tr>
<tr><td>XOTcl Core</td><td>0.83</td></tr>
<tr><td>webDAV Support</td><td>1.1b1</td></tr>
</table>

Operating system and related packages

Linux:
<table border="1">
<tr><td>Package</td><td>Version</td></tr>
<tr><td>OpenSUSE</td><td>10.3</td></tr>
<tr><td>Aolserver</td><td>4.5.0</td></tr>
<tr><td>Oracle Instant Client + OCI Client</td><td>10.2</td></tr>
<tr><td>PostgreSQL</td><td>8.2.7</td></tr>
<tr><td>tDOM</td><td>0.8.2</td></tr>
<tr><td>tcl</td><td>8.5.1</td></tr>
<tr><td>tcllib</td><td>1.10</td></tr>
<tr><td>thread</td><td>2.6.5</td></tr>
<tr><td>tk</td><td>8.5.1</td></tr>
<tr><td>xotcl</td><td>1.6.0</td></tr>
</table>

Windows:
<table border="1">
<tr><td>Package</td><td>Version</td></tr>
<tr><td>Visual Studio</td><td>Visual Studio 2008 SP1 its runtime</td></tr>
<tr><td>Aolserver</td><td>4.5.0</td></tr>
<tr><td>Oracle Instant Client + OCI Client</td><td>10.2</td></tr>
<tr><td>PostgreSQL</td><td>8.2.7</td></tr>
<tr><td>tDOM</td><td>0.8.2</td></tr>
<tr><td>tcl</td><td>8.5.1</td></tr>
<tr><td>tcllib</td><td>1.10</td></tr>
<tr><td>thread</td><td>2.6.5</td></tr>
<tr><td>tk</td><td>8.5.1</td></tr>
<tr><td>xotcl</td><td>1.6.0</td></tr>
</table>

For Windows the source code (which I had to modify in very few places) as well as all the precompiled binaries are available here:

http://www.friendlybits.com/en/inf_tec_en/win32openacs_en/

For Linux I've generated at work an OpenSUSE 10.3 VMware Appliance containing all the above software (plus other) already precompiled and tested again with both PostgreSQL 8.2.7 and Oracel 10g and 11g. This appliance has proven to be incredibly useful both as developer machine and as testing and production environment. When we need to produce a new installation we just copy the appliance: no painful installations any longer.

I believe it would be nice to:

1. create an Installer for Windows (starting from my Win32-OpenACS port) able to automatically build example/toys databases for OpenACS, .LRN and Project-Open;

2. create a smaller VMware Appliance (the one I created at work is too big) with the bare minimum to demonstrate OpenACS, .LRN and Project-Open.

Anybody interested?

Hope it helps,
Maurizio

Collapse
Posted by Pavel Boghita on
wow, that' great. thanks a lot for this. It is exactly what I was trying to do with Centos 4.6 Final (the OS provided on my virtual server with acewebhosting) - validating applications and services.
I'll have shot at sorting out a VMware appliance instead