Installing OpenGroupware on RH9 - Unofficial HowTo

Note: I installed it on Redhat 9 with Apache 2, it could also work well in the same way on other Redhat versions. (Users reported that it's working well on Fedora 1/2 see Marius Andreiana's comment for info about OpenSSL libraries. RH8 works also, it's not working on 7.x cause of LIBC versions)
Please send comments to my email.

PLEASE don't send me question, ask on the mailing list here

Here are the instructions:

• Get all rpms (http or ftp)
• Get postgres RPMs (from redhat or from cds).
• Install all rpms by typing : rpm -iUvh *.rpm
  (or using Kelley Graham perl script - Note that his script can do a lot more like downloading installing and configuring)
• Edit postgres config files to work with tcpip socket. (from opengroupware faq http://www.opengroupware.org/en/users/faq/index.html)
  1. You need to configure your PostgreSQL server so that TCP connections are allowed. You can do this by setting the "tcpip_socket" variable to "true" in the postgresql.conf file (at /var/lib/pgsql/data/). Some older PostgreSQL daemons (prior 7.0) need to be started with the "-i" commandline option.
     
  2. You need to patch your pg_hba.conf (at /var/lib/pgsql/data/) to allow TCP host connections. Example:

     --snip--
     local   all         all                   trust
     host    all         all         127.0.0.1         255.255.255.255  trust
     host    all         all         0.0.0.0           255.255.255.255 reject
     --snap-- 
     

     To get a secure setup, replace trust with password, md5 or something else (depends on your PostgreSQL version) Don't forget to restart PostgreSQL after applying the changes ! (eg /etc/init.d/postgresql restart)
• Do the following commands

  $ su - Password: # su - postgres $ createdb ogo $ createuser -A -D ogo $ exit # su - opengroupware $ cd /opt/opengroupware.org/Database/PostgreSQL $ psql ogo -U ogo Welcome to psql 7.3.3, 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=> \i pg-build-schema.psql [output cut] ogo=> \q $ source $HOME/OpenGroupware.org.sh $ Defaults write NSGlobalDomain LSAdaptor PostgreSQL72 $ Defaults write NSGlobalDomain LSModelName OpenGroupware.org_PostgreSQL $ Defaults write NSGlobalDomain LSConnectionDictionary '{databaseName = ogo; hostName = localhost; password = ""; port = 5432; userName = ogo}' $ Defaults write NSGlobalDomain NGBundlePath /opt/opengroupware.org/Library/OpenGroupware.org $ Defaults write NSGlobalDomain LSAttachmentPath /opt/opengroupware.org/documents $ exit # mkdir /opt/opengroupware.org/documents # chown opengroupware.skyrix /opt/opengroupware.org/documents # ln -s ~opengroupware/WebServerResources/* ~opengroupware/WOApps/OpenGroupware.woa/WebServerResources/

• Edit /etc/ld.so.conf and add the following lines:

  /opt/opengroupware.org/Libraries/ix86/linux-gnu/gnu-fd-nil
  /opt/skyrix/system/Libraries/ix86/linux-gnu/gnu-fd-nil
  

• Run ldconfig to apply these changes
• get opengroupware SysV init script and copy it to /etc/init.d directory. (right click and save link target as)
• Change the init file rights to u+x
• As opengroupware (su - opengroupware) do these two commands:

  echo "source /opt/opengroupware.org/OpenGroupware.org.sh" >> ~/.bash_profile
  echo "export LD_ASSUME_KERNEL=2.4.1" >> ~/.bash_profile
  

• As root start opengroupware by typing:

  /etc/init.d/opengroupware start
  

  NOTE:The following script isn't needed if using SysV init script but it's another way of running OpenGroupware that is suggested by Helge Hess here.
  • create a startup script (i.e. start.shMarius Andreiana) based on Christoph Moeller workaround with this content:

    #!/bin/bash
    source $HOME/OpenGroupware.org.sh
    export LD_ASSUME_KERNEL=2.4.1
    
    while [ "1" = "1" ]; do 
    $HOME/WOApps/OpenGroupware.woa/ix86/linux-gnu/gnu-fd-nil/OpenGroupware \
    -WOPort 20000 -WOHttpAllowHost localhost.localdomain ; done &
    
    exit 0
    

  • Run your startup script as opengroupware - if you want to use this way. (change it's permissions to u+x before)
  
  
• Now you can test it from a browser - http://[OGo_machine_name]:20000/

setting up apache

There are more than one way to setup Apache, I'll mention two of them. (Helge Hess explanation of the differences)

• Using mod_proxy - thanks to Henrik Holmboe

  Note: maybe mod_rewrite could be a better way - but this is a working way.

  add at the end of /etc/httpd/conf/httpd.conf (or wherever you wish - should be in VirtualHost if used) the following lines

  ######################
  # OpenGroupware proxy
  ######################
  ProxyPass /OpenGroupware http://localhost:20000/OpenGroupware
  ProxyPassReverse /OpenGroupware http://localhost:20000/OpenGroupware
  
  ProxyPass /OpenGroupware.woa http://localhost:20000/OpenGroupware.woa
  ProxyPassReverse /OpenGroupware.woa http://localhost:20000/OpenGroupware.woa
  ProxyPass /OpenGroupware.org http://localhost:20000/OpenGroupware.org
  ProxyPassReverse /OpenGroupware.org http://localhost:20000/OpenGroupware.org
  

• Using mod_ngobjweb for Apache 2
  • Download it from OpenGroupware web site
  • Open the tar-gzipped file by typing tar -zxvf opengroupware.org-mod_ngobjweb-latest.tar.gz
  • cd to the created dir - cd opengroupware.org-mod_ngobjweb
  • Compile it by typing make (Note: You need httpd-devel package installed for it) - fetch it in this way : up2date httpd-devel
  • NOTE: If you get errors in the make procedure try this.
  • create a directory fot this apache module - type : mkdir /opt/opengroupware.org/WebServer
  • Move the compiled library to the right place in this way : mv ngobjweb*.so /opt/opengroupware.org/WebServer
  • Add this to the end of your /etc/httpd/conf/httpd.conf

    #######################################
    # mod_ngobjweb Apache 2 Configuration
    #######################################
    
    LoadModule ngobjweb_module /opt/opengroupware.org/WebServer/ngobjweb_2.0.40.so
    #OpenGroupware WebUI
    
    SetHandler ngobjweb-adaptor
    SetAppPort 20000
    
    
    Alias /OpenGroupware.woa/WebServerResources/ /opt/opengroupware.org/WebServerResources/
    
    #ZideStore
    
    SetHandler ngobjweb-adaptor
    SetAppPort 23000
    
    Alias /zidestore/so/images /opt/opengroupware.org/WOApps/ZideStore.woa/WebServerResources 
    
    
    

    Note : You should change ngobjweb_2.0.40.so on the 5th line to your appropriate Apache version.

Final settings

• After setting apache and restarting it you should be able to see http(s)://servername/OpenGroupware from the whole network.
• And your ZideStore is acessible at http(s)://servername/zidestore/so/[your_user_name]
• For having logon screen at startup you have to change root password.
• Start your server in your runing level by typing (as root):

  chkconfig --add opengroupware
  

Troubleshooting

The common error that people get is that nothing is working... if you can't get more info from logs (check /var/log/ogo.log) try the followings:

• Create the start.sh script that was mentioned before (here) then as root do "su - opengroupware" and start it manually (./start.sh), Then watch for errors on Console...
• If you are getting access denied error like this:

  Jul 20 11:58:21 OpenGroupware [28321]: WOHttpAdaptor: ACCESS DENIED: <InetSocketAddress: Your_Host_Name:61024>

  try changing (in start.sh or at /etc/init.d/opengroupware) -WOHttpAllowHost localhost.localdomain from localhost.localdomain to your host name.
• Here are some emails I got.. (I'm putting it here in case that it could help someone - Thanks a lot to the senders.)
  • Alain Williams's comment
  • Marc-Olivier Bernard's comment
  • Alon Weinstein's comment
  • Kris Buytaert's comment
  • Superniels's comment
  • Andreas Pfaffeneder's comment for Fedora users
  • Thomas Maschutznig Comments for ES3 (WS3 and AS3)
  • Thomas Linder interesting way of compiling mod_ngobjweb (usefull if you get errors while compiling mod_ngojweb)
  • Zdravko Stoychev mod_rewrite instructions
  • Marius Andreiana's comments about OpenSSL libraries on Fedora Core 1/2
• PLEASE don't send me question, ask on the mailing list here