OXDebianSargeFromPackage

Installing Open-Xchange on Debian Sarge from .deb packages.

Development stopped, see http://www.open-xchange.org/pipermail/user/2006-November/059403.html for details

Configure APT

Add the following lines to your /etc/apt/sources.list file, using this script:

cat >> /etc/apt/sources.list <<EOFile
#######################################################################
# Blackdown java packages
deb http://www.tux.org/pub/java/debian sarge non-free

# Open-Xchange and JavaMail packages
# Sorry, you have to build the package for yourself from the subversion repository:
# http://svn.debian.org/wsvn/pkg-openxchange 
 

#######################################################################
EOFile

Make sure you have contrib and non-free after your pre-existing debian sources

Update package database

apt-get update

Install and configure packages Open-Xchange depends on / recommends

Installation:

Please choose the defaults if you are not sure how to answer any questions, but do answer yes to enable tomcat web administration.

apt-get install postgresql tomcat4 tomcat4-webapps apache2 libapache2-mod-jk2 slapd courier-base courier-ldap courier-imap db4.2-util 

Configure packages Open-Xchange depend on

Configure Tomcat4

• Open-Xchange installer uses the tomcat administration webapp to deploy itself. You have to add a user with manager role to /var/lib/tomcat4/conf/tomcat-users.xml, or to the user database you configured for tomcat4.

<tomcat-users>
...
   <role rolename="manager"/>
   <user username="tomcat" password="somepassword" roles="tomcat,manager"/>
...
</tomcat-users>

• Share the username and password you use for administering tomcat4 with debconf when it is asked in open-xchange configuration process.

• Set in /etc/default/tomcat4

TOMCAT4_SECURITY=no

• Restart tomcat

/etc/init.d/tomcat4 restart

Configure Apache2

• Enable mod_jk2

a2enmod jk2
cp /usr/share/doc/libapache2-mod-jk2/examples/workers2.properties.minimal /etc/apache2/workers2.properties

• Activate mod_jk2 uncommenting the followin line in /etc/apache2/mods-enabled/jk2.conf:

    JkSet config.file /etc/apache2/workers2.properties

• Add the followig lines to your /etc/apache2/workers2.properties using this script::

cat >> /etc/apache2/workers2.properties <<'EOFile'
[uri:/servlet/*]
worker=ajp13:localhost:8009

[uri:/umin/*]
worker=ajp13:localhost:8009
EOFile

• It is strongly suggested to configure Apache2 for HTTPS access. For details see http://www.open-xchange.org/oxwiki/OXDebianSargeApache2SSL which is based upon http://www.open-xchange.org/oxwiki/OXInstallApacheSSL, but changed to debian sarge configuration.

• Restart apache:

/etc/init.d/apache2 restart

Configure PostgreSQL

Enable password based authentication, add the following line to /etc/postgresql/pg_hba.conf:

# added line :
  host    all    all    127.0.0.1   255.255.255.255   md5
# original line: (you can keep it, just insert the new line before it)
  host    all         all         127.0.0.1         255.255.255.255   ident sameuser

• Restart postgresql:

/etc/init.d/postgresql restart

Disable vacuumdb in /etc/cron.d/postgresql (causes login failures). Attention: you may need this cron job to keep your database stable. Additional comments appriciated!

# Run VACUUM ANALYSE on all databases every 5 hours
#2 0,5,10,15,20 * * 1-6 postgres        if ! pidof /usr/lib/postgresql/bin/pg_autovacuum > /dev/null && [ -x /usr/lib/postgresql/bin/do.maintenance ]; then /usr/lib/postgresql/bin/do.maintenance -a; fi

Courier Configuration

You can get some configuration tips for Courier and other IMAP servers here: MailServerSetup

Database creation (optional)

If you use a remote database or just want to create the database for yourself (not recommended!) follow these steps:

• Create the database user you've chosen

(See /etc/open-xchange/admintools.conf for details of database connection)

         postgres@yourhost:~$ /usr/bin/psql template1" <<-EOF
         CREATE USER < db user > WITH PASSWORD '< password >';
         EOF

• Create the database owned by the db user:

        postgres@yourhost:~$ createdb -O openexchange -E UNICODE openexchange

• The package installation script will fill your database with initial values

Install and configure Open-Xchange

Javamail Download

When you will install open-Xchange, the debian package libsunmail-java will be installed.

This one require that you download the file javamail-1_3_3_01-upd.zip, and debconf suggest you a http location from where you can get it after accepting it's license.

Open-Xchange installation

Install the Open-Xchange Debian package, and read after how to answer to the other debconf packages questions:

apt-get install open-xchange open-xchange-theme-top-zenith # OR open-xchange-theme-top-crystal OR open-xchange-theme-top-crystal-boxed

Configure LDAP

This step should be performed while open-xchange postinst script is running, when the script asks you:

 =================== Configuring open-xchange ===================
|                                                                |
| Read carefully /usr/share/doc/open-xchange/README.Debian NOW!  |
|                                                                |
|                             <Ok>                               |
|                                                                |
 ================================================================

• add Open-Xchange schema to /etc/ldap/slapd.conf :

       include         /etc/ldap/schema/open-xchange.schema

• Set ACLs in /etc/ldap/slapd.conf

For details see /usr/share/doc/open-xchange/openLDAP2.2.conf.example. Don't forget to replace "dc=example,dc=org" to reflect your configuration!

If the example configuration file does not match your needs check http://www.open-xchange.org/oxwiki/DirectorySetup, you cab find additional configuration samples.

• Set HOST and BASE in /etc/ldap/ldap.conf if it was not set up by installation script.

• Restart slapd

/etc/init.d/slapd stop; /etc/init.d/slapd start;

Now continue with the Open-Xchange installation selecting [OK]

After Installation

Restart OpenLDAP server by running:

/etc/init.d/slapd restart

It is possible that you have to restart Tomcat4 and Apache2 after installing/upgrading open-xchange:

/etc/init.d/tomcat4 restart  # should be restarted 1st
/etc/init.d/apache2 restart

Alternatively you can try deploying the installed servlets through Tomcat's manager interface by accessing the following URLs:

http://localhost:8180/manager/install?path=/servlet&war=servlet
http://localhost:8180/manager/install?path=/umin&war=umin

Using Open-Xchange

You can create users by running adduser_ox:

adduser_ox --username=testuser \
           --passwd=test \
           --name=John \
           --sname=Doe \
           --maildomain=test.org \
           --lang=EN \
           --mail_enabled=OK \
           --ox_timezone=Europe/Budapest \
           --write_global_address=TRUE

and you need to add the user to a group

addusertogroup_ox --user=testuser --group=users

After finishing installation You can login to Open-Xchange at https://yourhostname/cgi-bin/login.pl

Differences between the official Open-Xchange source and Debian packages

• adduser_ox and deluser_ox do not ask for SQL database password

• available languages are shown on login page

• patch level independent language packs

• default spellcheck configuration for aspell

• default configuration of webmail creates IMAP folders automatically

• default configuration of webmail uses "." as IMAP folder name separator

• fix for invalid iCal generation on WebDAV interface (0.8.1.4-1 < )

• fix for LDAP authentication error introduced in 0.8.1.6 (0.8.1.5-1 < )

Migration

Under construction, do not try that on production machine yet! Feedbacks and corrections are welcome!

Migration from .tar.gz to .deb based install

Stop open-xchange server

Prerequisites

Move files to it's new location

mkdir /var/lib/open-xchange
mv /usr/local/openxchange/var/filespool /var/lib/open-xchange/
mv /usr/local/openxchange/var/settings /var/lib/open-xchange/
mv /usr/local/openxchange/var/drafts /var/lib/open-xchange/
mv /usr/local/openxchange/var/webmailupload /var/lib/open-xchange/
mv /usr/local/openxchange/var/dictionary /var/lib/open-xchange/

Removing files

rm -r /usr/local/openxchange

Cleaning up after failed .deb install

apt-get remove --purge open-xchange slapd postgresql postgresql-client
rm -r /var/log/open-xchange /var/lib/open-xchange /var/lib/postgres /etc/postgresql
apt-get install slapd postgresql postgresql-client
apt-get install open-xchange

FAQ

Question: What is the state of the Debian package?

Question: What is your email address?

Question: I got error code 403 when installing servlets on Tomcat4:

tomcatdeploy:

BUILD FAILED
/usr/share/open-xchange/tomcat.xml:40: java.io.IOException: Server
returned
HTTP response code: 403 for URL:
http://localhost:8180/manager/deploy?path=%2Fservlet

Answer: 403 HTTP Response code means Forbidden, check your Tomcat administration account settings.

Question: Kontact can not upload/download meetings/contacts

WebDAV file access willfail if the user does not belong to any group.

/usr/sbin/addusertogroup_ox --user=testuser --group=users

will solve that for the testuser.

Question: How can I change configuration values?

Answer: Just run:

dpkg-reconfigure open-xchange

Question: How do I install translation packages?.

apt-get install open-xchange-groupware-i18n-it open-xchange-webmail-i18n-it

Question: I get this errors when I start/stop apache2:

[error] config.update(): Can't create channel.jni:jni
[error] env.createBean2(): Factory error creating vm: ( vm, )
[error] config.update(): Can't create vm:
[error] env.createBean2(): Factory error creating worker.jni:onStartup ( worker.jni, onStartup)
[error] config.update(): Can't create worker.jni:onStartup
[error] env.createBean2(): Factory error creating worker.jni:onShutdown ( worker.jni, onShutdown)
[error] config.update(): Can't create worker.jni:onShutdown

Answer: I took the wrong workers2.properties:

/usr/share/doc/libapache2-mod-jk2/examples/workers2.properties <-- the one where the above errors occure /usr/share/doc/libapache2-mod-jk2/examples/workers2.properties.minimal <-- this one works for me

Question: I get this error when I try to adduser_ox:

sudo adduser_ox --username=mjb \
                --passwd=mypassword \
                 --name=Mal \
                 --sname=Beaton \
                  --maildomain=mydomaink.com.au \
                  --lang=EN_AU \
                 --mail_enabled=OK \
                 --ox_timezone=Australia/Brisbane \
                  --write_global_address=TRUE

invalid per syntax

Answer: "EN_AU" is not a valid language code in Open-Xchange, use "EN" instead.

Question: I get this error while open-xchange postinst script is running:

Error, entries missing!
  entry 1: dc=example,dc=org

Question: I get this error when I try to send mail:

MessagingException in ComposeMessage/sendMessage
Unable to send message.
Details: javax.mail.MessagingException: IOException while sending message;
  nested exception is:
        javax.activation.UnsupportedDataTypeException: no object DCH for MIME type text/plain; charset=us-ascii

Wish list

I Wish: that we could seperate out the error resolutions from the faq section, and and into its own section, further divide that section up into types of errors like ldap, postgres, webmail etc. panman AT widewire DOT net

Known Bugs in current package version

upgrade to new version fails when using Tomcat5

Upgrade fails with :

File
exists
replace /var/lib/tomcat5/webapps/umin/META-INF/MANIFEST.MF? [y]es, 
[n]o,
[A]ll, [N]one, [r]ename: y

dpkg: error processing open-xchange (--configure):
 subprocess post-installation script killed by signal (Interrupt)

The cause is a bug in prerm script in .deb versions < 0.8.0.6-3 ( < 0.8.1.3-3 for development branch).

Fix: run:

rm -rf /var/lib/tomcat5/webapps/umin/
rm -rf /var/lib/tomcat5/webapps/servlet/

adduser_ox gives an SQL-error

When adding a user and you get

LDAP Success
SQL Error
Deleting User from LDAP

ERROR: column "creating_date" is of type timestamp with time zone but expression is of type character varying

~# cd /var/lib/tomcat5/webapps/umin/WEB-INF/lib
/var/lib/tomcat5/webapps/umin/WEB-INF/lib# mv postgresql-jdbc3.jar postgresql-jdbc3.jar.old
/var/lib/tomcat5/webapps/umin/WEB-INF/lib# ln -s pg74.215.jdbc3.jar postgresql-jdbc3.jar
/var/lib/tomcat5/webapps/umin/WEB-INF/lib# cd /usr/share/java
/usr/share/java# mv postgresql-jdbc3.jar postgresql-jdbc3.jar.old
/usr/share/java# ln -s pg74.215.jdbc3.jar postgresql-jdbc3.jar

Old (Resolved) Bugs

WebDAV is not working

After following the installation procedure here, the webdav isn't working. If you try to access webdav.documents you get "javax.servlet.ServletException: Load of configuration failed." This also happens when you try to access webdav.ical,...

Fix: It is a bug in pre-0.8.0.5-7 package versions, thanks to Tommie Van Mechgelenfor for submitting it. Use the last version to avoid it. Similar exceptions can happen when you do not wait enough for Tomcat4 to start up completely and try to access WebDAV too early. Just try again a bit later.

Installation hangs

Fix: It is a bug in pre-0.8.0.5-7 package versions, thanks to Markus Schulz for hint about fix. Use the last version to avoid it.

Icons are just colored squares.

apt-get install open-xchange-theme-top-zenith # OR open-xchange-theme-top-crystal OR open-xchange-theme-top-crystal-boxed

It was a lack of feature in pre-0.8.0.5-6 package versions.

Database is not initialized correctly

dbinit_ox

MoinMoin Powered

Immutable page (last edited 2006-11-13 22:11:19 by BalintReczey)

Or try one of these actions: AttachFile, LikePages, LocalSiteMap, SpellCheck