OpenGroupWare on Fedora Core 3
This is the step-by-step installation Guide
The Installation
The documentation is a bit old, wrong, confusing and well missing.
So here is what I did ...
I wrote this script to generate the correct sources-list
line. At this point we do 'apt-get update' and then 'apt-cache search ogo' does now
find related packages ...
[root@xyz ~]# apt-cache search ogo
mod_ngobjweb - mod_ngobjweb apache module
ogo-docapi-db-project - Database storage for OpenGroupware.org projects
ogo-docapi-fs-project - Filesystem storage for OpenGroupware.org projects
ogo-logic - OpenGroupware.org application logic
ogo-logic-devel - Development files for the OpenGroupware.org application logic
ogo-logic-tools - OpenGroupware.org application logic tools
ogo-meta - OpenGroupware.org META package
ogo-pda - PDA syncing framework for OpenGroupware.org
ogo-pda-devel - Development files for the PDA syncing framework of OpenGroupware.org
ogo-theme-blue - Blue theme for OpenGroupware.org's web UI.
ogo-theme-default - Default theme for OpenGroupware.org's web UI
ogo-theme-kde - KDE alike theme for OpenGroupware.org's web UI.
ogo-theme-ooo - OOo alike theme for OpenGroupware.org's web UI
ogo-theme-orange - Orange theme for OpenGroupware.org's web UI.
ogo-tools - Various commandline Tools for OpenGroupware.org
ogo-webui-app - Web UI application of OpenGroupware.org
ogo-webui-calendar - Calendar component of OpenGroupware.org's Web UI
ogo-webui-core - Core elements for OpenGroupware.org's Web UI
ogo-webui-core-devel - Development files for the core elements of OpenGroupware.org's Web UI
ogo-webui-mailer - Mailer component of OpenGroupware.org's Web UI
ogo-webui-mailer-devel - Development files for the mailer component of OpenGroupware.org's Web UI
ogo-webui-project - Project component of OpenGroupware.org's Web UI
ogo-webui-resource-basque - Basque translation for OpenGroupware.org's web UI
ogo-webui-resource-de - German translation for OpenGroupware.org's web UI
ogo-webui-resource-dk - Danish translation for OpenGroupware.org's web UI
ogo-webui-resource-en - English translation for OpenGroupware.org's web UI
ogo-webui-resource-es - Spanish translation for OpenGroupware.org's web UI
ogo-webui-resource-fr - French translation for OpenGroupware.org's web UI
ogo-webui-resource-hu - Hungarian translation for OpenGroupware.org's web UI
ogo-webui-resource-it - Italian translation for OpenGroupware.org's web UI
ogo-webui-resource-jp - Japanese translation for OpenGroupware.org's web UI
ogo-webui-resource-nl - Dutch translation for OpenGroupware.org's web UI
ogo-webui-resource-no - Norwegian translation for OpenGroupware.org's web UI
ogo-webui-resource-pl - Polish translation for OpenGroupware.org's web UI
ogo-webui-resource-pt - Portuguese translation for OpenGroupware.org's web UI
ogo-webui-resource-ptbr - Portuguese (Brazilian) translation for OpenGroupware.org's web UI
ogo-webui-resource-sk - Slovak translation for OpenGroupware.org's web UI
ogo-zidestore - ZideStore server for OpenGroupware.org
ogo-zidestore-devel - Development Files for the ZideStore server
[root@xyz ~]#
The package you want to install is META package "ogo-meta - OpenGroupware.org META package"
which should install everything necessary ...
[root@xyz ~]# apt-get install ogo-meta
Reading Package Lists... Done
Building Dependency Tree... Done
The following extra packages will be installed:
libfoundation10 libobjc-lf2 mod_ngobjweb ogo-docapi ogo-docapi-db-project ogo-docapi-fs-project ogo-environment
ogo-gnustep_make ogo-logic ogo-logic-tools ogo-pda ogo-theme-default ogo-tools ogo-webui-app ogo-webui-calendar
ogo-webui-contact ogo-webui-core ogo-webui-mailer ogo-webui-news ogo-webui-project ogo-webui-resource-de
ogo-webui-resource-en ogo-webui-task ogo-xmlrpcd ogo-zidestore sope44-appserver sope44-appserver-devel
sope44-appserver-tools sope44-core sope44-gdl1 sope44-gdl1-postgresql sope44-ical sope44-ldap sope44-ldap-devel
sope44-ldap-tools sope44-mime sope44-xml sope44-xml-devel sope44-xml-tools
The following NEW packages will be installed:
libfoundation10 libobjc-lf2 mod_ngobjweb ogo-docapi ogo-docapi-db-project ogo-docapi-fs-project ogo-environment
ogo-gnustep_make ogo-logic ogo-logic-tools ogo-meta ogo-pda ogo-theme-default ogo-tools ogo-webui-app
ogo-webui-calendar ogo-webui-contact ogo-webui-core ogo-webui-mailer ogo-webui-news ogo-webui-project
ogo-webui-resource-de ogo-webui-resource-en ogo-webui-task ogo-xmlrpcd ogo-zidestore sope44-appserver
sope44-appserver-devel sope44-appserver-tools sope44-core sope44-gdl1 sope44-gdl1-postgresql sope44-ical sope44-ldap
sope44-ldap-devel sope44-ldap-tools sope44-mime sope44-xml sope44-xml-devel sope44-xml-tools
0 upgraded, 40 newly installed, 0 removed and 6 not upgraded.
Need to get 24.0MB of archives.
After unpacking 84.7MB of additional disk space will be used.
Do you want to continue? [Y/n]
Get:1 http://download.opengroupware.org fedora-core3/releases/ThirdParty libobjc-lf2 2.95.3-r85.0 [96.3kB]
Get:2 http://download.opengroupware.org fedora-core3/releases/ThirdParty libfoundation10 1.0.67-r91.0 [1041kB]
Get:3 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-logic 1.0alpha10-r695.0 [2313kB]
Get:4 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-logic-tools 1.0alpha10-r695.0 [8521B]
Get:5 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-core 1.0alpha10-r695.0 [1426kB]
Get:6 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-theme-default 1.0alpha10-r695.0 [539kB]
Get:7 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-resource-en 1.0alpha10-r695.0 [66.0kB]
Get:8 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-resource-de 1.0alpha10-r695.0 [72.4kB]
Get:9 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-app 1.0alpha10-r695.0 [4923kB]
Get:10 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-environment 1.0a-0 [5243B]
Get:11 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-gnustep_make 1.10.0-0 [135kB]
Get:12 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-xml 4.4beta.2-r527.0 [542kB]
Get:13 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-xml-devel 4.4beta.2-r527.0 [24.7kB]
Get:14 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-xml-tools 4.4beta.2-r527.0 [19.2kB]
Get:15 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-core 4.4beta.2-r527.0 [876kB]
Get:16 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-mime 4.4beta.2-r527.0 [672kB]
Get:17 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-appserver 4.4beta.2-r527.0 [2798kB]
Get:18 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-appserver-devel 4.4beta.2-r527.0 [275kB]
Get:19 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-appserver-tools 4.4beta.2-r527.0 [17.6kB]
Get:20 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-ldap 4.4beta.2-r527.0 [110kB]
Get:21 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-ldap-devel 4.4beta.2-r527.0 [7341B]
Get:22 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-ldap-tools 4.4beta.2-r527.0 [16.9kB]
Get:23 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-ical 4.4beta.2-r527.0 [142kB]
Get:24 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-gdl1 4.4beta.2-r527.0 [417kB]
Get:25 http://download.opengroupware.org fedora-core3/releases/sope-4.4beta.2-voyager sope44-gdl1-postgresql 4.4beta.2-r527.0 [104kB]
Get:26 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-docapi 1.0alpha10-r695.0 [830kB]
Get:27 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-docapi-db-project 1.0alpha10-r695.0 [339kB]
Get:28 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-docapi-fs-project 1.0alpha10-r695.0 [89.9kB]
Get:29 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-pda 1.0alpha10-r695.0 [947kB]
Get:30 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-tools 1.0alpha10-r695.0 [126kB]
Get:31 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-calendar 1.0alpha10-r695.0 [882kB]
Get:32 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-contact 1.0alpha10-r695.0 [686kB]
Get:33 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-mailer 1.0alpha10-r695.0 [884kB]
Get:34 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-news 1.0alpha10-r695.0 [67.9kB]
Get:35 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-project 1.0alpha10-r695.0 [850kB]
Get:36 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-webui-task 1.0alpha10-r695.0 [220kB]
Get:37 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-xmlrpcd 1.0alpha10-r695.0 [127kB]
Get:38 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-zidestore 1.0alpha10-r695.0 [1228kB]
Get:39 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra mod_ngobjweb 2.0.52-r528.0 [34.1kB]
Get:40 http://download.opengroupware.org fedora-core3/releases/opengroupware-1.0alpha10-ultra ogo-meta 1.0alpha10-r695.0 [4310B]
Fetched 24.0MB in 56s (426kB/s)
Committing changes...
Preparing... ########################################### [100%]
1:libobjc-lf2 ########################################### [ 3%]
2:libfoundation10 ########################################### [ 5%]
3:ogo-logic ########################################### [ 8%]
4:ogo-logic-tools ########################################### [ 10%]
5:ogo-webui-core ########################################### [ 13%]
6:ogo-theme-default ########################################### [ 15%]
7:ogo-webui-resource-en ########################################### [ 18%]
8:ogo-webui-resource-de ########################################### [ 20%]
9:ogo-webui-app ########################################### [ 23%]
adding group skyrix.
adding user ogo.
10:ogo-environment ########################################### [ 25%]
pg_hba.conf needs to be edited - please refer to our FAQ
postgresql.conf needs to be edited - please refer to our FAQ
11:ogo-gnustep_make ########################################### [ 28%]
12:sope44-xml ########################################### [ 30%]
13:sope44-xml-devel ########################################### [ 33%]
14:sope44-xml-tools ########################################### [ 35%]
15:sope44-core ########################################### [ 38%]
16:sope44-mime ########################################### [ 40%]
17:sope44-appserver ########################################### [ 43%]
18:sope44-appserver-devel ########################################### [ 45%]
19:sope44-appserver-tools ########################################### [ 48%]
20:sope44-ldap ########################################### [ 50%]
21:sope44-ldap-devel ########################################### [ 52%]
22:sope44-ldap-tools ########################################### [ 55%]
23:sope44-ical ########################################### [ 58%]
24:sope44-gdl1 ########################################### [ 60%]
25:sope44-gdl1-postgresql ########################################### [ 63%]
26:ogo-docapi ########################################### [ 65%]
27:ogo-docapi-db-project ########################################### [ 68%]
28:ogo-docapi-fs-project ########################################### [ 70%]
29:ogo-pda ########################################### [ 73%]
30:ogo-tools ########################################### [ 75%]
31:ogo-webui-calendar ########################################### [ 78%]
32:ogo-webui-contact ########################################### [ 80%]
33:ogo-webui-mailer ########################################### [ 83%]
34:ogo-webui-news ########################################### [ 85%]
35:ogo-webui-project ########################################### [ 88%]
36:ogo-webui-task ########################################### [ 90%]
37:ogo-xmlrpcd ########################################### [ 93%]
38:ogo-zidestore ########################################### [ 95%]
39:mod_ngobjweb ########################################### [ 98%]
40:ogo-meta ########################################### [100%]
Done.
And its installed ...
The Configuration
Postgres Configuration
Just to make sure that we have postgress installed as well
[root@xyz ~]# rpm -qa | grep postgres
postgresql-tcl-7.4.6-1.FC3.2
postgresql-jdbc-7.4.6-1.FC3.2
postgresql-pl-7.4.6-1.FC3.2
postgresql-contrib-7.4.6-1.FC3.2
postgresql-odbc-7.3-8.FC3.1
postgresql-test-7.4.6-1.FC3.2
postgresql-python-7.4.6-1.FC3.2
postgresql-libs-7.4.6-1.FC3.2
postgresql-7.4.6-1.FC3.2
postgresql-server-7.4.6-1.FC3.2
postgresql-docs-7.4.6-1.FC3.2
sope44-gdl1-postgresql-4.4beta.2-r527.0
... yes we do.
First edit "/var/lib/pgsql/data/postgresql.conf" and change
#tcpip_socket = false
into the following
tcpip_socket = false
Next we have to edit "/var/lib/pgsql/data/pg_hba.conf" and add the following
two lines at the end of the file
host all all 127.0.0.1 255.255.255.255 trust
host all all 0.0.0.0 255.255.255.255 reject
This is assuming that you will use the postgres SQL database server on the same
machine as where you want to run OGo. For peformance/redundancy reasons you
might want to have a seperate machine running as a database, but this is
beyond the scope of this document.
Postgres Database Creation
Now we have to create the database for OGo. Lets first check if
postgres is running
[root@xyz ~]# service postgresql status
postmaster (pid 3921 3920 3919) is running...
Ok, now we ceate the database and database-user
[root@xyz ~]# su - postgres
-bash-3.00$ createdb OGo
CREATE DATABASE
-bash-3.00$ createuser -A -D OGo
CREATE USER
-bash-3.00$ exit
logout
Now we need the create the schema of OGo in postgress
[root@unused-200 ~]# su - ogo
[ogo@unused-200 ~]$ cd /usr/local/lib/opengroupware.org-1.0a/commands/OGo.model/Resources/
[ogo@unused-200 ~]$ psql OGo -U OGo
Welcome to psql 7.4.6, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
ogo=>
ogo=> \i pg-build-schema.psql
[... output cut ...]
ogo=> \q
Apache configuration
the RPM packages nicely creates the necessary
OGo.conf file into "/etc/httpd/conf.d", so there seems nothing
else to do but (re)starting apache.
[root@ ~]# chkconfig httpd on
[root@ ~]# chkconfig --list httpd
httpd 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@ ~]# service httpd start
Init scripts configuration
Get the ones at http://download.opengroupware.org/packages/fedora-core3/contrib/initscripts_fcore3/, and put them in "/etc/init.d". Next make sure they are executable ...
[root@xyz ~]# chmod 755 /etc/init.d/nhsd
[root@xyz ~]# chmod 755 /etc/init.d/opengroupware
[root@xyz ~]# chmod 755 /etc/init.d/xmlrpcd
[root@xyz ~]# chmod 755 /etc/init.d/zidestore
Next we have to make sure that these are started during a boot
[root@xyz ~]# chkconfig --add nhsd
[root@xyz ~]# chkconfig --add opengroupware
[root@xyz ~]# chkconfig --add xmlrpcd
[root@xyz ~]# chkconfig --add zidestore
Ok, lets start them ...
[root@xyz ~]# service nhsd start
[root@xyz ~]# service xmlrpcd start
[root@xyz ~]# service zidestore start
[root@xyz ~]# service opengroupware start
OpenGroupware Setup
Now you can login to http://localhost/OpenGroupware, and change the password for 'root'
Images for news
You have to edit "/etc/opengroupware/Defaults/NSGlobalDomain.plist" and add
LSNewsImagesPath = "/var/lib/opengroupware.org/news";
LSNewsImagesUrl = "/ArticleImages";
In "/etc/httpd/conf.d/OGo.conf" you need to add the following lines
<Directory "/var/lib/opengroupware.org/">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
<Directory>br />
... and then restart apache. You also need the change the group ownership, and
read permissions as follows ...
[root@xyz ~]# chmod -R g+rx /var/lib/opengroupware.org
[root@xyz ~]# cd /var/lib/opengroupware.org/
[root@xyz opengroupware.org]# chmod -R g+r documents/ news/
[root@xyz opengroupware.org]# chown -R ogo *
[root@xyz opengroupware.org]# chgrp -R apache *