OpenGroupWare on Fedora Core 3
OpenGroupware (http://www.opengroupware.org is
a OpenSource (GPL) Groupware solution. Most of the other solutions that are
available and are OpenSource are PHP based solutions. These do not provide the
possibility to use handhelde devices, or external programs to use/manipulate
the data (Calendar,Contacts, etc)...
Functionality wise, ogo seems to be a better an more mature solution. In this document
I will attempt to install the server, and use mail and calendaring functions via external
applications (Mozilla, Evolution, Outlook ... etc), as well as try to syncronize
with PDA's
The Installation
Fedora Core, being the distribution I used, I was happy to hear the ogo is
being developed on Fedora, and that
apt-rpm repositories where being supplied by the ogo team. So a
"apt-get install opengroupware" should be enough, and I could be on my way.
However, documentation is a bit old, wrong, confusing and well missing. The installation
section has a link
for fedora, however, all it gives is the apt sources-list entry that needs to be added, but
no information on what packages need to be installed. After digging trough the website a bit
more I found this list of
RPMs that will need installation.
So I added the source for apt-rpm, did a 'apt-get update' and tried to do a
'apt-get install opengroupware-gstep-make', which did not work. After looking
closer I noticed that the retreival of the package lists from opengroupware.org
have had failed.
Looking at the location where the packages are supposed to reside, I noticed
that what was in the documentation was all outdated. So I wrote this
script to generate the correct sources-list
line. Aaaand at this point we would expect that a 'apt-get update' and
'apt-get install opengroupware-env' would be enough ... apparently
the packages all have been renamed to 'ogo-xyz' so no joy ... so far.
The good news is though that 'apt-cache search opengroupware' does now
find related packages ...
[root@xyz ~]# apt-cache search opengroupware
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 ~]#
Well there seems to be a META package "ogo-meta - OpenGroupware.org META package"
that 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
I found the following document that
describes the installation for fedora core 2. So I'll follow the configuration steps from there ...
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
After a clean install and upgrade of FC3 it seems that the config
files are not there by default ... so you have to:
su - postgress
initdb
#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
From the RPM there are some init script templates available
however, you do not want to use those ....
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 *