summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTiziano Mueller <dev-zero@gentoo.org>2008-08-30 12:20:10 +0200
committerTiziano Mueller <dev-zero@gentoo.org>2008-08-30 12:20:10 +0200
commit58d85fa035bfe3c859fcbaf87f6af9de7ec6770f (patch)
tree4a5cef1f66d57e41bc41e93d6a1938a302f4122e /www-apps
parentUpdated protobuf ebuild (python works now and unbundled gtest) (diff)
downloaddev-zero-58d85fa035bfe3c859fcbaf87f6af9de7ec6770f.tar.gz
dev-zero-58d85fa035bfe3c859fcbaf87f6af9de7ec6770f.tar.bz2
dev-zero-58d85fa035bfe3c859fcbaf87f6af9de7ec6770f.zip
Added forgotten open-xchange packages
Diffstat (limited to 'www-apps')
-rw-r--r--www-apps/open-xchange-icons-crystal/Manifest8
-rw-r--r--www-apps/open-xchange-icons-crystal/files/digest-open-xchange-icons-crystal-03
-rw-r--r--www-apps/open-xchange-icons-crystal/open-xchange-icons-crystal-0.ebuild25
-rw-r--r--www-apps/open-xchange-icons-zenith/Manifest8
-rw-r--r--www-apps/open-xchange-icons-zenith/files/digest-open-xchange-icons-zenith-0.13
-rw-r--r--www-apps/open-xchange-icons-zenith/open-xchange-icons-zenith-0.1.ebuild26
-rw-r--r--www-apps/open-xchange-serverpack/ChangeLog92
-rw-r--r--www-apps/open-xchange-serverpack/Manifest17
-rw-r--r--www-apps/open-xchange-serverpack/files/88_mod_jk.ox.conf46
-rw-r--r--www-apps/open-xchange-serverpack/files/catalina.conf6
-rw-r--r--www-apps/open-xchange-serverpack/files/conf.d.open-xchange6
-rw-r--r--www-apps/open-xchange-serverpack/files/init.d.open-xchange74
-rw-r--r--www-apps/open-xchange-serverpack/files/open-xchange-htaccess7
-rw-r--r--www-apps/open-xchange-serverpack/files/ox-0.8.2.1-wrong_jdbc_usage.patch604
-rw-r--r--www-apps/open-xchange-serverpack/files/ox-0.8.2.1-wrong_jdbc_usage_conf.patch146
-rw-r--r--www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-build_fix.patch46
-rw-r--r--www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-umin_ssl.patch15
-rw-r--r--www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-wrong_jdbc_usage.patch299
-rw-r--r--www-apps/open-xchange-serverpack/files/ox_reminder.sql10
-rw-r--r--www-apps/open-xchange-serverpack/files/slapd.ox.inc49
-rw-r--r--www-apps/open-xchange-serverpack/files/webinterface.ox.include11
-rw-r--r--www-apps/open-xchange-serverpack/metadata.xml9
-rw-r--r--www-apps/open-xchange-serverpack/open-xchange-serverpack-0.8.6.0_beta.ebuild551
-rw-r--r--www-apps/open-xchange-webpack/Manifest23
-rw-r--r--www-apps/open-xchange-webpack/files/digest-open-xchange-webpack-0.8.6.0_beta66
-rw-r--r--www-apps/open-xchange-webpack/open-xchange-webpack-0.8.6.0_beta.ebuild111
26 files changed, 2261 insertions, 0 deletions
diff --git a/www-apps/open-xchange-icons-crystal/Manifest b/www-apps/open-xchange-icons-crystal/Manifest
new file mode 100644
index 0000000..d25bd6c
--- /dev/null
+++ b/www-apps/open-xchange-icons-crystal/Manifest
@@ -0,0 +1,8 @@
+DIST Crystal_OX_Theme.tgz 53788 RMD160 24d8b0501783f23b16f1a0b20800fcb59da7a464 SHA1 4edb81cd7ff3f44cd6bdd6dca17aac4d21db62fd SHA256 b864155899cf3526364dead79ffcd64f939c4f5a97bd36e2403a6d0e55342125
+EBUILD open-xchange-icons-crystal-0.ebuild 629 RMD160 4ca1ebed930e06e76f1fc41e8c0f5043e37f6946 SHA1 ef476c35a31837564043c57f512c2a7e6976ca47 SHA256 1248c912ecc6a15107a49610983be5e3e5ce3eb9c2da3679546b03a72b4882e4
+MD5 70bab35b12184801b6a1806ea3da48ac open-xchange-icons-crystal-0.ebuild 629
+RMD160 4ca1ebed930e06e76f1fc41e8c0f5043e37f6946 open-xchange-icons-crystal-0.ebuild 629
+SHA256 1248c912ecc6a15107a49610983be5e3e5ce3eb9c2da3679546b03a72b4882e4 open-xchange-icons-crystal-0.ebuild 629
+MD5 6a2ce08ad0bce3fbf509e97f9678f931 files/digest-open-xchange-icons-crystal-0 238
+RMD160 3fff09ab49af424e6ac66f9066ec89f125ebe89e files/digest-open-xchange-icons-crystal-0 238
+SHA256 42609bdde2bcf3de98887cde6aed533b9ce4f9c7291193ec1ab1d0cd9592165c files/digest-open-xchange-icons-crystal-0 238
diff --git a/www-apps/open-xchange-icons-crystal/files/digest-open-xchange-icons-crystal-0 b/www-apps/open-xchange-icons-crystal/files/digest-open-xchange-icons-crystal-0
new file mode 100644
index 0000000..2aff5d8
--- /dev/null
+++ b/www-apps/open-xchange-icons-crystal/files/digest-open-xchange-icons-crystal-0
@@ -0,0 +1,3 @@
+MD5 0c390658072367c892ce5ff423a02def Crystal_OX_Theme.tgz 53788
+RMD160 24d8b0501783f23b16f1a0b20800fcb59da7a464 Crystal_OX_Theme.tgz 53788
+SHA256 b864155899cf3526364dead79ffcd64f939c4f5a97bd36e2403a6d0e55342125 Crystal_OX_Theme.tgz 53788
diff --git a/www-apps/open-xchange-icons-crystal/open-xchange-icons-crystal-0.ebuild b/www-apps/open-xchange-icons-crystal/open-xchange-icons-crystal-0.ebuild
new file mode 100644
index 0000000..2e55964
--- /dev/null
+++ b/www-apps/open-xchange-icons-crystal/open-xchange-icons-crystal-0.ebuild
@@ -0,0 +1,25 @@
+# Copyright 1999-2006 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: $
+
+KEYWORDS="~amd64 ~x86"
+
+DESCRIPTION="Open-Xchange Crystal Top Navigation Icon Theme"
+HOMEPAGE="http://www.mikefetherston.ca/OX/"
+SRC_URI="http://www.mikefetherston.ca/OX/Crystal_OX_Theme.tgz"
+LICENSE="GPL-2"
+SLOT="0"
+IUSE=""
+
+DEPEND=""
+RDEPEND=">=www-apps/open-xchange-webpack-0.8.2.1
+ !www-apps/open-xchange-icons-zenith"
+
+S=${WORKDIR}
+
+src_install() {
+ insinto /usr/share/open-xchange/www/cfintranet/images/top/EN/
+ doins *.png
+ insinto /usr/share/open-xchange/www/cfintranet/images/top/DE/
+ doins *.png
+}
diff --git a/www-apps/open-xchange-icons-zenith/Manifest b/www-apps/open-xchange-icons-zenith/Manifest
new file mode 100644
index 0000000..80c06da
--- /dev/null
+++ b/www-apps/open-xchange-icons-zenith/Manifest
@@ -0,0 +1,8 @@
+DIST ox_zenith_iconset-0.1.tar.gz 29694 RMD160 8627c6186559a917fa7e33388f294e09c2f30da6 SHA1 296cca03a26cfd2837b92b8945784121e15df504 SHA256 e714a09e37fc93a6674b858f30fba4e8a6ac01b44b2e41fba2ec0f62f0704c83
+EBUILD open-xchange-icons-zenith-0.1.ebuild 758 RMD160 031d4469b53feb1afacb4d3810f04662e43478e7 SHA1 21e49acda0c76ba86cd43fb081f76784903574e2 SHA256 e47945ef397b97a9b011b5034ff1cdbc1685511ce6a8ed62dfa4654d1e9208db
+MD5 bea84820ebca8233c3f01256facc93a4 open-xchange-icons-zenith-0.1.ebuild 758
+RMD160 031d4469b53feb1afacb4d3810f04662e43478e7 open-xchange-icons-zenith-0.1.ebuild 758
+SHA256 e47945ef397b97a9b011b5034ff1cdbc1685511ce6a8ed62dfa4654d1e9208db open-xchange-icons-zenith-0.1.ebuild 758
+MD5 45fcf542d1c6f72ad2411c7c4f0d8da4 files/digest-open-xchange-icons-zenith-0.1 262
+RMD160 a2086d2d0ac8a90c2a23aaaaa7e8359e8761c7c0 files/digest-open-xchange-icons-zenith-0.1 262
+SHA256 b5cb7d1c64019b0700e9a24b6e16eebc9be12f41d0923eca2ccce668873d0097 files/digest-open-xchange-icons-zenith-0.1 262
diff --git a/www-apps/open-xchange-icons-zenith/files/digest-open-xchange-icons-zenith-0.1 b/www-apps/open-xchange-icons-zenith/files/digest-open-xchange-icons-zenith-0.1
new file mode 100644
index 0000000..da27b35
--- /dev/null
+++ b/www-apps/open-xchange-icons-zenith/files/digest-open-xchange-icons-zenith-0.1
@@ -0,0 +1,3 @@
+MD5 c45c42544ca9cf2b9efdf1525bb356ea ox_zenith_iconset-0.1.tar.gz 29694
+RMD160 8627c6186559a917fa7e33388f294e09c2f30da6 ox_zenith_iconset-0.1.tar.gz 29694
+SHA256 e714a09e37fc93a6674b858f30fba4e8a6ac01b44b2e41fba2ec0f62f0704c83 ox_zenith_iconset-0.1.tar.gz 29694
diff --git a/www-apps/open-xchange-icons-zenith/open-xchange-icons-zenith-0.1.ebuild b/www-apps/open-xchange-icons-zenith/open-xchange-icons-zenith-0.1.ebuild
new file mode 100644
index 0000000..e5d7ba5
--- /dev/null
+++ b/www-apps/open-xchange-icons-zenith/open-xchange-icons-zenith-0.1.ebuild
@@ -0,0 +1,26 @@
+# Copyright 1999-2006 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: $
+
+KEYWORDS="~amd64 ~x86"
+
+DESCRIPTION="Open-Xchange Zenith Top Navigation Icon Theme"
+HOMEPAGE="http://www.open-xchange.com/EN/developer/download.html
+ http://ladyorion.deviantart.com/"
+SRC_URI="http://www.open-xchange.com/oxcms/opencms/misc/developer-zone/themes/ox_zenith_iconset-${PV}.tar.gz"
+LICENSE="GPL-2"
+SLOT="0"
+IUSE=""
+
+DEPEND=""
+RDEPEND=">=www-apps/open-xchange-webpack-0.8.2.1
+ !www-apps/open-xchange-icons-crystal"
+
+S=${WORKDIR}/ox_zenith_iconset
+
+src_install() {
+ insinto /usr/share/open-xchange/www/cfintranet/images/top/EN/
+ doins top/*.png
+ insinto /usr/share/open-xchange/www/cfintranet/images/top/DE/
+ doins top/*.png
+}
diff --git a/www-apps/open-xchange-serverpack/ChangeLog b/www-apps/open-xchange-serverpack/ChangeLog
new file mode 100644
index 0000000..0e95251
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/ChangeLog
@@ -0,0 +1,92 @@
+# ChangeLog for www-apps/open-xchange
+# Copyright 1999-2006 Gentoo Foundation; Distributed under the GPL v2
+# $Header: /var/cvsroot/gentoo-x86/www-apps/open-xchange/ChangeLog,v 1.16 2006/11/23 17:21:52 vivo Exp $
+
+ 23 Nov 2006; Francesco Riosa <vivo@gentoo.org> open-xchange-0.8.2.ebuild:
+ dev-db/mysql => virtual/mysql
+
+*open-xchange-0.8.2 (05 Jun 2006)
+
+ 05 Jun 2006; Jeremy Huddleston <eradicator@gentoo.org>
+ -files/open-xchange-0.8.1.2-login.patch,
+ -files/open-xchange-0.8.1.5-oxFolder.patch,
+ +files/open-xchange-0.8.2-mysql.patch,
+ +files/open-xchange-0.8.2-mysql-2.patch,
+ +files/open-xchange-0.8.2-sieve.patch, -open-xchange-0.8.0.6.ebuild,
+ -open-xchange-0.8.1.5.ebuild, +open-xchange-0.8.2.ebuild:
+ Version bump and updates from Martin in bug #62197.
+
+ 27 Apr 2006; Alec Warner <antarus@gentoo.org>
+ files/digest-open-xchange-0.8.0.6, files/digest-open-xchange-0.8.1.5,
+ Manifest:
+ Fixing SHA256 digest, pass four
+
+ 01 Apr 2006; Jeremy Huddleston <eradicator@gentoo.org>
+ open-xchange-0.8.0.6.ebuild, open-xchange-0.8.1.5.ebuild:
+ Don't install INSTALL doc.
+
+ 29 Jan 2006; Jeremy Huddleston <eradicator@gentoo.org>
+ open-xchange-0.8.0.6.ebuild, open-xchange-0.8.1.5.ebuild:
+ Changed dev-perl/XML-SAX-Base to dev-perl/XML-SAX.
+
+*open-xchange-0.8.1.5 (30 Nov 2005)
+
+ 30 Nov 2005; Jeremy Huddleston <eradicator@gentoo.org>
+ -files/open-xchange-0.8.1.2-reply.patch,
+ +files/open-xchange-0.8.1.5-oxFolder.patch, +files/ox_reminder.sql,
+ open-xchange-0.8.0.6.ebuild, -open-xchange-0.8.1.2.ebuild,
+ -open-xchange-0.8.1.3.ebuild, -open-xchange-0.8.1.3-r1.ebuild,
+ +open-xchange-0.8.1.5.ebuild:
+ Version bump.
+
+ 20 Nov 2005; Stuart Herbert <stuart@gentoo.org> open-xchange-0.8.0.6.ebuild,
+ open-xchange-0.8.1.2.ebuild, open-xchange-0.8.1.3-r1.ebuild,
+ open-xchange-0.8.1.3.ebuild:
+ Fixed broken DEPEND
+
+*open-xchange-0.8.0.6 (22 Oct 2005)
+
+ 22 Oct 2005; Jeremy Huddleston <eradicator@gentoo.org>
+ +open-xchange-0.8.0.6.ebuild:
+ Added ebuild for upstream stable version.
+
+*open-xchange-0.8.1.3-r1 (22 Oct 2005)
+
+ 22 Oct 2005; Jeremy Huddleston <eradicator@gentoo.org>
+ +open-xchange-0.8.1.3-r1.ebuild:
+ Revbump with some further updates from Martin.
+
+ 03 Oct 2005; Jeremy Huddleston <eradicator@gentoo.org>
+ open-xchange-0.8.1.2.ebuild, open-xchange-0.8.1.3.ebuild:
+ Added missing DEPEND on zip.
+
+*open-xchange-0.8.1.3 (01 Oct 2005)
+
+ 01 Oct 2005; Jeremy Huddleston <eradicator@gentoo.org>
+ +open-xchange-0.8.1.3.ebuild:
+ Version bump.
+
+ 01 Oct 2005; Jeremy Huddleston <eradicator@gentoo.org>
+ open-xchange-0.8.1.2.ebuild:
+ Using tomcat servelet classpath.
+
+ 01 Oct 2005; Jeremy Huddleston <eradicator@gentoo.org>
+ +files/open-xchange-0.8.1.2-reply.patch, open-xchange-0.8.1.2.ebuild:
+ Fixed upstream bug #762 with buggy reply.
+
+ 24 Sep 2005; Jeremy Huddleston <eradicator@gentoo.org>
+ +files/open-xchange-0.8.1.2-login.patch, open-xchange-0.8.1.2.ebuild:
+ Added patch for login.pm when USE=ssl.
+
+ 24 Sep 2005; Jeremy Huddleston <eradicator@gentoo.org> files/slapd.ox.inc:
+ Fixed up the slapd permissions include.
+
+*open-xchange-0.8.1.2 (24 Sep 2005)
+
+ 24 Sep 2005; Jeremy Huddleston <eradicator@gentoo.org>
+ +files/88_mod_jk.ox.conf, +files/init.d.open-xchange,
+ +files/open-xchange-htaccess, +files/slapd.ox.inc, +metadata.xml,
+ +open-xchange-0.8.1.2.ebuild:
+ Initial ebuild for open-xchange. See bug #62197. There have been many
+ contributors and testers, so hats off to all involved.
+
diff --git a/www-apps/open-xchange-serverpack/Manifest b/www-apps/open-xchange-serverpack/Manifest
new file mode 100644
index 0000000..d9042d3
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/Manifest
@@ -0,0 +1,17 @@
+AUX 88_mod_jk.ox.conf 1228 RMD160 ac45be1d0824ab54728d5a304b59d5824297c974 SHA1 33e76d4dd9c2e5c719dc51e00248ed399cbac566 SHA256 f62c842769c9675968e9d1f3d6469315cf18b1802049e57d1dbfb39f66725a9a
+AUX catalina.conf 260 RMD160 8f200cde55640658fd55fdd6cc42fa697e6c2c13 SHA1 1b6c5d50bd27f73e3cefa6bcbbe3ffb317a1f20d SHA256 fc50fabec729ff26a2abbb14298c9a626f4c45e1402f73820cb8d96575930d75
+AUX conf.d.open-xchange 185 RMD160 eca8c4768c2e4aff0db194c7738c3a22130e4770 SHA1 542e80cd845f08b50260b3a23997c30cbafebdfb SHA256 f2e7c702f6fc6f7b19ae605958d850437e3b5d670b815037caba978d9e85ab39
+AUX init.d.open-xchange 1560 RMD160 548042850f72eb86126c7fd8d7384e0abf1185f1 SHA1 7604f27a297088bbab06f7564686c39ee2c6aee8 SHA256 54edd41b6511a3fb7fbbf1233289f871c3967388f616362ab0c394f116244d11
+AUX open-xchange-htaccess 174 RMD160 9fe2a5be9db7253351fa856994c237d867f7f2df SHA1 585f1a7bc774cfde620e4f4a03c02d77540cf15a SHA256 4596825adb0067148596ef7948b2f452457d0b43aff64b4ec3a3628e9fcbbaa5
+AUX ox-0.8.2.1-wrong_jdbc_usage.patch 30634 RMD160 9e57682cd92540448374107f6f7549185ec1003e SHA1 b502a95339b75a265e4a96bb1ebccd9e8a7a3a10 SHA256 d48e704a15010bd1aa005950f0eca0ccb7387b2c729c7ff1fbf2ea3f5680de9f
+AUX ox-0.8.2.1-wrong_jdbc_usage_conf.patch 7861 RMD160 0cffa55ca57e297cbc335b134cf5d7a3fd38d2d0 SHA1 9a7449cc1be131c17ab7a4e7b7d159ef7e119d5f SHA256 c6bcadaaee08b11f2b589f7f30b8076b7658effa5e3f2d351c8887b7feeb5052
+AUX ox-0.8.6.0_beta-build_fix.patch 2919 RMD160 d6127caee5c6079cfe2bebb3215f8b05ffb5eaa4 SHA1 58480c89a022217d5275b180b3e84fc6aebdbef7 SHA256 337517ad9993103066863a35c13f00a13af38e60dbbfc0b281e3e807eea548fa
+AUX ox-0.8.6.0_beta-umin_ssl.patch 825 RMD160 7c4a8704fa62d386bd437fd7349afc83dec5ef76 SHA1 82dd3a55c5ada86801735bf776a74044f3840a59 SHA256 e0143a8bff19b7c11e67f3a7889205f2be0b020d5183aed1265c66d66f74cddc
+AUX ox-0.8.6.0_beta-wrong_jdbc_usage.patch 16569 RMD160 ef287e5081dcd964165a8fc0cb39cfe4b2e9412a SHA1 60a35b9871b2a8a70f276934af9fea357735da96 SHA256 5be4214c48c53b1e9ad4c717025790e5e61f85802ece29e9215788283ea17a71
+AUX ox_reminder.sql 178 RMD160 0c80af0d7927debe4db383a6de08a3d662063829 SHA1 8e70f3cea2efc00f567584783d66593503507ed4 SHA256 41b640b0b1fdbb20ee8f108ca0e1bad69c494c8e6a0d351fe4904824e759a0fd
+AUX slapd.ox.inc 2019 RMD160 1c5bcb56d603f489da113fbfdd8b39adabcf4ad6 SHA1 0f58dd7a3ddc111343bb9f7e7c15bc5b5f6fe879 SHA256 08409d20efa9af517d52ae813de86d935b1eff07672566f0786f13475305aef4
+AUX webinterface.ox.include 260 RMD160 cb3c1557257b536dd5214f1988f10315a628156d SHA1 5cbbac08a7ea4008cdd8ae897bd166e3fe1d7f9a SHA256 b97e674dac48beaa0630f0b9e8ba2cd1838f1b123e74696688dd12656cb8d6a5
+DIST open-xchange-server-0.8.6-0_BETA.tar.gz 2016888 RMD160 091758fa5ac5bc586476950113ef553b4644854b SHA1 a3dc61c00f37894f9bdd96bb3e3443e6b2d57d8d SHA256 a0caf644deb2136215609b76e014b57b5019f895478b4aae0339a33ecc5f2c6b
+EBUILD open-xchange-serverpack-0.8.6.0_beta.ebuild 19976 RMD160 f332a1a667d21ae6563168a11459e87042eeb9b6 SHA1 417b4f6621a1456f9b32165ca547bdd8e85af89e SHA256 14a775e283dc06d6662663d39115caa582e38ab96a49a924e7b43507016e4ae8
+MISC ChangeLog 3451 RMD160 7470f8263d56416c2479efac74da2d14e47f7a9b SHA1 e28c8347ebf0cb79906ed2e8e122ac85defad958 SHA256 c994391e17120768a43c4558b73e5f234457f215510dcb09da2befdd582fecdf
+MISC metadata.xml 247 RMD160 d02acfac88a4c8bac4526154d2301306c9b11298 SHA1 03594ffbd30e504f419701bd2cc21a0699e15a72 SHA256 9031c04619455a61733317a87013fee0d9954581d358a097ae85714726d4bf71
diff --git a/www-apps/open-xchange-serverpack/files/88_mod_jk.ox.conf b/www-apps/open-xchange-serverpack/files/88_mod_jk.ox.conf
new file mode 100644
index 0000000..d6a092f
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/88_mod_jk.ox.conf
@@ -0,0 +1,46 @@
+<IfDefine JK>
+jkMount /manager ajp13
+jkMount /manager/* ajp13
+
+jkMount /servlet ajp13
+jkMount /servlet/* ajp13
+
+jkMount /umin ajp13
+jkMount /umin/* ajp13
+
+jkMount /servlet/webdav.contacts ajp13
+jkMount /servlet/webdav.contacts/* ajp13
+
+jkMount /servlet/webdav.calendar ajp13
+jkMount /servlet/webdav.calendar/* ajp13
+
+jkMount /servlet/webdav.ical ajp13
+jkMount /servlet/webdav.ical/* ajp13
+
+jkMount /servlet/webdav.documents ajp13
+jkMount /servlet/webdav.documents/* ajp13
+
+jkMount /servlet/webdav.tasks ajp13
+jkMount /servlet/webdav.tasks/* ajp13
+
+jkMount /servlet/webdav.folders ajp13
+jkMount /servlet/webdav.folders/* ajp13
+
+jkMount /servlet/webdav.projects ajp13
+jkMount /servlet/webdav.projects/* ajp13
+
+jkMount /servlet/webdav.groupuser ajp13
+jkMount /servlet/webdav.groupuser/* ajp13
+
+jkMount /servlet/webdav.attachments ajp13
+jkMount /servlet/webdav.attachments/* ajp13
+
+jkMount /servlet/webdav.freebusy ajp13
+jkMount /servlet/webdav.freebusy/* ajp13
+
+jkMount /servlet/webdav.vcard ajp13
+jkMount /servlet/webdav.vcard/* ajp13
+
+jkMount /servlet/webdav.bookmarks ajp13
+jkMount /servlet/webdav.bookmarks/* ajp13
+</IfDefine>
diff --git a/www-apps/open-xchange-serverpack/files/catalina.conf b/www-apps/open-xchange-serverpack/files/catalina.conf
new file mode 100644
index 0000000..17b2f52
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/catalina.conf
@@ -0,0 +1,6 @@
+
+# Source this file from conf.d/tomcat-*
+
+JAVA_OPTS="${JAVA_OPTS} -Dopenexchange.propfile=/etc/open-xchange/groupware/system.properties"
+CLASSPATH="${CLASSPATH}:/etc/open-xchange/umin"
+CATALINA_OPTS="${CATALINA_OPTS} -Djava.library.path=/usr/lib/open-xchange"
diff --git a/www-apps/open-xchange-serverpack/files/conf.d.open-xchange b/www-apps/open-xchange-serverpack/files/conf.d.open-xchange
new file mode 100644
index 0000000..7e3cd81
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/conf.d.open-xchange
@@ -0,0 +1,6 @@
+OX_USER=tomcat
+OX_GROUP=tomcat
+
+OX_SESSIOND_PID=/var/run/open-xchange/sessiond.pid
+OX_GROUPWARE_PID=/var/run/open-xchange/groupware.pid
+OX_WEBMAIL_PID=/var/run/open-xchange/webmail.pid
diff --git a/www-apps/open-xchange-serverpack/files/init.d.open-xchange b/www-apps/open-xchange-serverpack/files/init.d.open-xchange
new file mode 100644
index 0000000..d48e288
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/init.d.open-xchange
@@ -0,0 +1,74 @@
+#!/sbin/runscript
+
+depend() {
+ need net slapd tomcat-5.5 apache2
+ use postgresql mysql cyrus courier-imapd courier-imapd-ssl postfix
+ after postgresql mysql
+}
+
+start() {
+ local retval
+
+ ebegin "Starting Open-Xchange sessiond"
+ start-stop-daemon --start \
+ --startas /usr/bin/ox_sessiond \
+ --pidfile ${OX_SESSIOND_PID} \
+ --chuid ${OX_USER}:${OX_GROUP} \
+ --background --make-pidfile
+ retval=$?
+ eend $retval
+ [[ ${retval} -eq 0 ]] || return 1
+
+ sleep 1
+
+ ebegin "Starting Open-Xchange groupware"
+ start-stop-daemon --start \
+ --startas /usr/bin/ox_groupware \
+ --pidfile ${OX_GROUPWARE_PID} \
+ --chuid ${OX_USER}:${OX_GROUP} \
+ --background --make-pidfile
+ retval=$?
+ eend $retval
+ [[ ${retval} -eq 0 ]] || return 1
+
+ ebegin "Starting Open-Xchange webmail"
+ start-stop-daemon --start \
+ --startas /usr/bin/ox_webmail \
+ --pidfile ${OX_WEBMAIL_PID} \
+ --chuid ${OX_USER}:${OX_GROUP} \
+ --background --make-pidfile
+ retval=$?
+ eend $retval
+ [[ ${retval} -eq 0 ]] || return 1
+
+}
+
+stop() {
+ local retval
+ local failcnt=0
+
+ ebegin "Stopping Open-Xchange webmail"
+ start-stop-daemon --stop \
+ --pidfile ${OX_WEBMAIL_PID}
+ retval=$?
+ eend $retval
+ [[ ${retval} -eq 0 ]] || let failcnt++
+
+ ebegin "Stopping Open-Xchange groupware"
+ start-stop-daemon --stop \
+ --pidfile ${OX_GROUPWARE_PID}
+ retval=$?
+ eend $retval
+ [[ ${retval} -eq 0 ]] || let failcnt++
+
+ sleep 3
+
+ ebegin "Stopping Open-Xchange sessiond"
+ start-stop-daemon --stop \
+ --pidfile ${OX_SESSIOND_PID}
+ retval=$?
+ eend $retval
+ [[ ${retval} -eq 0 ]] || let failcnt++
+
+ return ${failcnt}
+}
diff --git a/www-apps/open-xchange-serverpack/files/open-xchange-htaccess b/www-apps/open-xchange-serverpack/files/open-xchange-htaccess
new file mode 100644
index 0000000..83c7cf0
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/open-xchange-htaccess
@@ -0,0 +1,7 @@
+<IfModule mod_rewrite.c>
+ RewriteEngine on
+
+ RewriteRule ^$ /cgi-bin/login.pl
+ RewriteRule ^/$ /cgi-bin/login.pl
+ RewriteRule ^/open-xchange/(.*)$ $1 [L,QSA]
+</IfModule>
diff --git a/www-apps/open-xchange-serverpack/files/ox-0.8.2.1-wrong_jdbc_usage.patch b/www-apps/open-xchange-serverpack/files/ox-0.8.2.1-wrong_jdbc_usage.patch
new file mode 100644
index 0000000..888fb33
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/ox-0.8.2.1-wrong_jdbc_usage.patch
@@ -0,0 +1,604 @@
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/CalendarAction.java src/com/openexchange/groupware/CalendarAction.java
+--- src.orig/com/openexchange/groupware/CalendarAction.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/CalendarAction.java 2007-01-28 16:38:35.000000000 +0100
+@@ -74,6 +74,7 @@
+ import com.openexchange.tools.date.FormatDate;
+ import com.openexchange.tools.html.Participants;
+ import com.openexchange.tools.sql.NasResultSet;
++import com.openexchange.tools.sql.TimestampNow;
+ import com.openexchange.event.UDPClient;
+ import com.openexchange.tools.versit.*;
+ import com.openexchange.tools.versit.converter.*;
+@@ -619,7 +620,7 @@
+
+ if (mu) {
+ PreparedStatement cc = writecon.prepareStatement("UPDATE del_dates SET changing_date = ?, changed_from = ? WHERE intfield01 = ?");
+- cc.setString(1, GlobalConfig.getParameter("SYSDATE"));
++ cc.setObject(1, new TimestampNow());
+ cc.setString(2, no.getUser());
+ cc.setInt(3, new Integer(uniqueID).intValue());
+ cc.addBatch();
+@@ -628,7 +629,7 @@
+ } else if (dmhs.size() > 0) {
+ PreparedStatement cc = writecon.prepareStatement("insert into del_dates (intfield01, creating_date, created_from, user_right, fid) values (?, ?, ?, 'd', -1)");
+ cc.setInt(1, new Integer(uniqueID).intValue());
+- cc.setString(2, GlobalConfig.getParameter("SYSDATE"));
++ cc.setObject(2, new TimestampNow());
+ cc.setString(3, no.getUser());
+ cc.addBatch();
+
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/CalendarDelete.java src/com/openexchange/groupware/CalendarDelete.java
+--- src.orig/com/openexchange/groupware/CalendarDelete.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/CalendarDelete.java 2007-01-28 16:38:35.000000000 +0100
+@@ -65,6 +65,7 @@
+ import com.openexchange.tools.html.Participants;
+ import com.openexchange.server.ComfireLogger;
+ import com.openexchange.tools.sql.NasResultSet;
++import com.openexchange.tools.sql.TimestampNow;
+ import com.openexchange.tools.tag.TagConvert;
+ import com.openexchange.event.UDPClient;
+
+@@ -383,7 +384,7 @@
+ }
+ no.user.put("rs1.prg_dates.field07", f7);
+ PreparedStatement pst = writecon.prepareStatement("UPDATE prg_dates SET changing_date = ?, field07 = '"+f7+"', changed_from = ? WHERE intfield02 = " + if2 + " AND intfield05 = 0");
+- pst.setString(1, GlobalConfig.getParameter("SYSDATE"));
++ pst.setObject(1, new TimestampNow());
+ pst.setString(2, no.getFullName());
+ if (writecon.getAutoCommit()) {
+ pst.addBatch();
+@@ -463,7 +464,7 @@
+
+ PreparedStatement de = writecon.prepareStatement("insert into del_dates (intfield01, creating_date, created_from, user_right, fid) values (?, ?, ?, 'd', -1)");
+ de.setInt(1, new Integer(vkn).intValue());
+- de.setString(2, GlobalConfig.getParameter("SYSDATE"));
++ de.setObject(2, new TimestampNow());
+ de.setString(3, no.getUser());
+ de.addBatch();
+
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/DeleteObjects.java src/com/openexchange/groupware/DeleteObjects.java
+--- src.orig/com/openexchange/groupware/DeleteObjects.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/DeleteObjects.java 2007-01-28 16:38:35.000000000 +0100
+@@ -81,6 +81,7 @@
+ import com.openexchange.tools.conf.GlobalConfig;
+ import com.openexchange.tools.consolidation.Consolidation;
+ import com.openexchange.tools.sql.NasResultSet;
++import com.openexchange.tools.sql.TimestampNow;
+
+ /**
+ * DeleteObjects
+@@ -902,7 +903,7 @@
+ */
+ try {
+ selectStr = "SELECT role FROM projects_participants WHERE intfield01 = ? AND id LIKE ?";
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, serial_id);
+ stmt.setString(2, no.getUser());
+ ResultSet userRoleResultSet = stmt.executeQuery();
+@@ -931,7 +932,7 @@
+ */
+ if (!projectDeleteAccess) {
+ selectStr = "SELECT user_right FROM projects WHERE intfield01 = ?";
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, serial_id);
+ ResultSet userRightResultSet = stmt.executeQuery();
+ try {
+@@ -1065,7 +1066,7 @@
+ Statement localStmt = null;
+ ResultSet localResultSet = null;
+ try {
+- localStmt = no.con.createStatement();
++ localStmt = no.con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ localResultSet = localStmt.executeQuery(sqlSelectStr);
+ emptyFolder = !localResultSet.first();
+ } finally {
+@@ -1103,7 +1104,7 @@
+
+ String updateStr = "UPDATE backup_projects SET changing_date = ?, changed_from = ? WHERE intfield01 = ?";
+ stmt = writecon.prepareStatement(updateStr);
+- stmt.setString(1, GlobalConfig.getParameter("SYSDATE"));
++ stmt.setObject(1, new TimestampNow());
+ stmt.setString(2, no.getFullName());
+ stmt.setInt(3, serial_id);
+ stmt.executeUpdate();
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/InsertHandler.java src/com/openexchange/groupware/InsertHandler.java
+--- src.orig/com/openexchange/groupware/InsertHandler.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/InsertHandler.java 2007-01-28 16:00:33.000000000 +0100
+@@ -64,6 +64,7 @@
+ import com.openexchange.thread.nasObject;
+ import com.openexchange.tools.conf.GlobalConfig;
+ import com.openexchange.tools.sql.NasResultSet;
++import com.openexchange.tools.sql.TimestampNow;
+
+ /**
+ InsertHandler
+@@ -243,10 +244,12 @@
+ pst.setNull(a+1, java.sql.Types.BINARY);
+ } else {
+ setBinaryStreamFromFile(pst, value, a+1);
+- }
+- } else if (type.indexOf("TIMESTAMP") != -1 && (value == null || !value.equals(GlobalConfig.getParameter("SYSDATE")))) {
++ }
++ } else if (type.indexOf("TIMESTAMP") != -1) {
+ if (value == null) {
+- pst.setNull(a+1, java.sql.Types.TIMESTAMP);
++ pst.setNull(a+1, java.sql.Types.TIMESTAMP);
++ } else if (value.equals(GlobalConfig.getParameter("SYSDATE"))) {
++ pst.setObject(a+1, new TimestampNow());
+ } else {
+ CalendarBase tsf = new CalendarBase();
+ tsf.setLangCode(no.getLanguage());
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/projects/Dependency.java src/com/openexchange/groupware/projects/Dependency.java
+--- src.orig/com/openexchange/groupware/projects/Dependency.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/projects/Dependency.java 2007-01-27 13:42:14.000000000 +0100
+@@ -49,14 +49,14 @@
+ String selectMilestones = "SELECT id FROM projects_milestones WHERE id = ?";
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+- stmt = no.con.prepareStatement(selectMilestones);
++ stmt = no.con.prepareStatement(selectMilestones, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, obj_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+ return DependencyObject.MILESTONE;
+ } else {
+ selectMilestones = "SELECT intfield01 FROM prg_tasks WHERE intfield01 = ?";
+- stmt = no.con.prepareStatement(selectMilestones);
++ stmt = no.con.prepareStatement(selectMilestones, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, obj_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/projects/ProjectData.java src/com/openexchange/groupware/projects/ProjectData.java
+--- src.orig/com/openexchange/groupware/projects/ProjectData.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/projects/ProjectData.java 2007-01-27 13:38:56.000000000 +0100
+@@ -176,7 +176,7 @@
+ ResultSet rs = null;
+ try {
+ String selectStr = "SELECT nextval ('serial_id')";
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+ return rs.getInt(1);
+@@ -377,7 +377,7 @@
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(sqlStr);
++ stmt = no.con.prepareStatement(sqlStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, projectUniqueID);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -2068,7 +2068,7 @@
+ try {
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setString(1, no.getUser());
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/projects/ProjectDependencyManagement.java src/com/openexchange/groupware/projects/ProjectDependencyManagement.java
+--- src.orig/com/openexchange/groupware/projects/ProjectDependencyManagement.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/projects/ProjectDependencyManagement.java 2007-01-27 13:38:15.000000000 +0100
+@@ -407,7 +407,7 @@
+ " OR ? IN (SELECT projects_participants.id FROM projects_participants WHERE projects_participants.role > ? AND projects_participants.intfield01 = prg_tasks.field03))" +
+ " OR (? IN (SELECT prg_tasks_members.member_uid FROM prg_tasks_members WHERE prg_tasks_members.object_id = prg_tasks.intfield01)))" +
+ " ORDER BY field01 ASC";
+- PreparedStatement stmt = no.con.prepareStatement(selectTaskSQL);
++ PreparedStatement stmt = no.con.prepareStatement(selectTaskSQL, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setString(1, (String) no.user.get("vkn"));
+ stmt.setString(2, no.getUser());
+ stmt.setString(3, no.getUser());
+@@ -491,7 +491,7 @@
+ String selectMilestoneSQL = "SELECT intfield01, id, name, mdate FROM projects_milestones" +
+ " WHERE (intfield01 = ?) AND ((? IN (SELECT projects.user_right FROM projects WHERE projects.intfield01 = ?) OR ? IN (SELECT projects_participants.id FROM projects_participants WHERE projects_participants.role > ? AND projects_participants.intfield01 = ?)))" +
+ " ORDER BY mdate ASC";
+- PreparedStatement stmt = no.con.prepareStatement(selectMilestoneSQL);
++ PreparedStatement stmt = no.con.prepareStatement(selectMilestoneSQL, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, new Integer((String) no.user.get("vkn")).intValue());
+ stmt.setString(2, no.getUser());
+ stmt.setInt(3, new Integer((String) no.user.get("vkn")).intValue());
+@@ -582,7 +582,7 @@
+ " OR ? IN (SELECT projects_participants.id FROM projects_participants WHERE projects_participants.role > ? AND projects_participants.intfield01 = prg_tasks.field03))" +
+ " OR (? IN (SELECT prg_tasks_members.member_uid FROM prg_tasks_members WHERE prg_tasks_members.object_id = prg_tasks.intfield01)))" +
+ " ORDER BY field01 ASC";
+- PreparedStatement stmt = no.con.prepareStatement(selectTaskSQL);
++ PreparedStatement stmt = no.con.prepareStatement(selectTaskSQL, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setString(1, (String) no.user.get("vkn"));
+ stmt.setString(2, no.getUser());
+ stmt.setString(3, no.getUser());
+@@ -666,7 +666,7 @@
+ String selectMilestoneSQL = "SELECT intfield01, id, name, mdate FROM projects_milestones" +
+ " WHERE (intfield01 = ?) AND ((? IN (SELECT projects.user_right FROM projects WHERE projects.intfield01 = ?) OR ? IN (SELECT projects_participants.id FROM projects_participants WHERE projects_participants.role > ? AND projects_participants.intfield01 = ?)))" +
+ " ORDER BY mdate ASC";
+- PreparedStatement stmt = no.con.prepareStatement(selectMilestoneSQL);
++ PreparedStatement stmt = no.con.prepareStatement(selectMilestoneSQL, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, new Integer((String) no.user.get("vkn")).intValue());
+ stmt.setString(2, no.getUser());
+ stmt.setInt(3, new Integer((String) no.user.get("vkn")).intValue());
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/projects/ProjectDrawing.java src/com/openexchange/groupware/projects/ProjectDrawing.java
+--- src.orig/com/openexchange/groupware/projects/ProjectDrawing.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/projects/ProjectDrawing.java 2007-01-27 13:41:55.000000000 +0100
+@@ -930,13 +930,13 @@
+ String selectMilestones = "SELECT COUNT(id) FROM projects_milestones WHERE intfield01 = ? AND mdate IS NULL";
+ PreparedStatement stmt = null;
+ try {
+- stmt = no.con.prepareStatement(selectTasks);
++ stmt = no.con.prepareStatement(selectTasks, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setString(1, String.valueOf(data.getProjectUniqueID()));
+ ResultSet countRS = stmt.executeQuery();
+ if (countRS.first() && countRS.getInt(1) > 0) {
+ return true;
+ }
+- stmt = no.con.prepareStatement(selectMilestones);
++ stmt = no.con.prepareStatement(selectMilestones, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, data.getProjectUniqueID());
+ countRS = stmt.executeQuery();
+ if (countRS.first() && countRS.getInt(1) > 0) {
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/projects/ProjectsChartManagement.java src/com/openexchange/groupware/projects/ProjectsChartManagement.java
+--- src.orig/com/openexchange/groupware/projects/ProjectsChartManagement.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/projects/ProjectsChartManagement.java 2007-01-27 13:39:39.000000000 +0100
+@@ -958,7 +958,7 @@
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(sqlSelect);
++ stmt = no.con.prepareStatement(sqlSelect, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, object_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -986,7 +986,7 @@
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(sqlSelect);
++ stmt = no.con.prepareStatement(sqlSelect, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, object_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -1016,7 +1016,7 @@
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(sqlSelect);
++ stmt = no.con.prepareStatement(sqlSelect, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, object_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -1041,7 +1041,7 @@
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(sqlSelect);
++ stmt = no.con.prepareStatement(sqlSelect, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, object_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -1065,7 +1065,7 @@
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(sqlSelect);
++ stmt = no.con.prepareStatement(sqlSelect, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, object_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/projects/ProjectsDependencyComposeManagement.java src/com/openexchange/groupware/projects/ProjectsDependencyComposeManagement.java
+--- src.orig/com/openexchange/groupware/projects/ProjectsDependencyComposeManagement.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/projects/ProjectsDependencyComposeManagement.java 2007-01-27 13:42:30.000000000 +0100
+@@ -630,7 +630,7 @@
+ sqlStr = "SELECT name FROM projects_milestones WHERE id = ?";
+ }
+ try {
+- stmt = no.con.prepareStatement(sqlStr);
++ stmt = no.con.prepareStatement(sqlStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, object_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/projects/ProjectsShowManagement.java src/com/openexchange/groupware/projects/ProjectsShowManagement.java
+--- src.orig/com/openexchange/groupware/projects/ProjectsShowManagement.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/projects/ProjectsShowManagement.java 2007-01-27 13:41:31.000000000 +0100
+@@ -111,7 +111,7 @@
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, project_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -1317,7 +1317,7 @@
+ PreparedStatement st = null;
+ try {
+ String selectStr = "SELECT project_name FROM projects WHERE intfield01 = ?";
+- st = no.con.prepareStatement(selectStr);
++ st = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ st.setInt(1, (int) id);
+ ResultSet rs = st.executeQuery();
+ if (rs.first()) {
+@@ -1403,7 +1403,7 @@
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(sqlSelect);
++ stmt = no.con.prepareStatement(sqlSelect, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, object_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -1431,7 +1431,7 @@
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+- stmt = no.con.prepareStatement(sqlString);
++ stmt = no.con.prepareStatement(sqlString, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, object_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/projects/ProjectUtilities.java src/com/openexchange/groupware/projects/ProjectUtilities.java
+--- src.orig/com/openexchange/groupware/projects/ProjectUtilities.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/projects/ProjectUtilities.java 2007-01-27 13:40:46.000000000 +0100
+@@ -184,7 +184,7 @@
+ PreparedStatement stmt = null;
+ boolean retval = false;
+ try {
+- stmt = con.prepareStatement(selectStr);
++ stmt = con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, vkn);
+ stmt.setString(2, user);
+ stmt.setInt(3, vkn);
+@@ -215,7 +215,7 @@
+ PreparedStatement stmt = null;
+ boolean retval = false;
+ try {
+- stmt = con.prepareStatement(selectStr);
++ stmt = con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, vkn);
+ stmt.setString(2, user);
+ stmt.setInt(3, vkn);
+@@ -601,7 +601,7 @@
+ PreparedStatement stmt = null;
+ String selectStr = "SELECT user_right FROM projects WHERE intfield01 = ?";
+ try {
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, project_id);
+ ResultSet rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -677,7 +677,7 @@
+ String selectStr = "SELECT fuid FROM projects WHERE intfield01 = ?";
+ PreparedStatement stmt = null;
+ try {
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, project_id);
+ ResultSet rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -725,7 +725,7 @@
+ String selectStr = "SELECT user_right FROM prg_tasks WHERE intfield01 = ?";
+ PreparedStatement stmt = null;
+ try {
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, task_id);
+ ResultSet rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -777,7 +777,7 @@
+ PreparedStatement stmt = null;
+ String selectStr = "SELECT user_right FROM projects WHERE intfield01 = ?";
+ try {
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, project_id);
+ ResultSet rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -900,7 +900,7 @@
+ PreparedStatement stmt = null;
+ String selectStr = "SELECT user_right FROM projects WHERE intfield01 = ?";
+ try {
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, project_id);
+ ResultSet rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -1255,7 +1255,7 @@
+ ResultSet rs = null;
+ try {
+ try {
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, project_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+@@ -1288,7 +1288,7 @@
+ ResultSet rs = null;
+ try {
+ try {
+- stmt = no.con.prepareStatement(selectStr);
++ stmt = no.con.prepareStatement(selectStr, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ stmt.setInt(1, task_id);
+ rs = stmt.executeQuery();
+ if (rs.first()) {
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/TasksNewEdit.java src/com/openexchange/groupware/TasksNewEdit.java
+--- src.orig/com/openexchange/groupware/TasksNewEdit.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/TasksNewEdit.java 2007-01-28 16:37:23.000000000 +0100
+@@ -84,6 +84,7 @@
+ import com.openexchange.tools.html.Participants;
+ import com.openexchange.tools.number.FormatNumber;
+ import com.openexchange.tools.sql.NasResultSet;
++import com.openexchange.tools.sql.TimestampNow;
+ import com.openexchange.tools.tag.TagConvert;
+ import com.openexchange.tools.versit.Versit;
+ import com.openexchange.tools.versit.VersitDefinition;
+@@ -1335,7 +1336,7 @@
+
+ if (mu) {
+ PreparedStatement cc = writeCon.prepareStatement("UPDATE del_tasks SET changing_date = ?, changed_from = ? WHERE intfield01 = ?");
+- cc.setString(1, GlobalConfig.getParameter("SYSDATE"));
++ cc.setObject(1, new TimestampNow());
+ cc.setString(2, no.getUser());
+ cc.setInt(3, new Integer(uniqueID).intValue());
+ cc.addBatch();
+@@ -1344,7 +1345,7 @@
+ } else if (dmhs.size() > 0) {
+ PreparedStatement cc = writeCon.prepareStatement("INSERT INTO del_tasks (intfield01, creating_date, created_from, user_right, fid) VALUES (?, ?, ?, 'd', -1)");
+ cc.setInt(1, new Integer(uniqueID).intValue());
+- cc.setString(2, GlobalConfig.getParameter("SYSDATE"));
++ cc.setObject(2, new TimestampNow());
+ cc.setString(3, no.getUser());
+ cc.addBatch();
+
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/groupware/UpdateHandler.java src/com/openexchange/groupware/UpdateHandler.java
+--- src.orig/com/openexchange/groupware/UpdateHandler.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/groupware/UpdateHandler.java 2007-01-28 16:00:21.000000000 +0100
+@@ -64,6 +64,7 @@
+ import com.openexchange.thread.nasObject;
+ import com.openexchange.tools.conf.GlobalConfig;
+ import com.openexchange.tools.sql.NasResultSet;
++import com.openexchange.tools.sql.TimestampNow;
+
+ /**
+ UpdateHandler
+@@ -250,9 +251,11 @@
+ } else {
+ setBinaryStreamFromFile(pst, value, a+1);
+ }
+- } else if (type.indexOf("TIMESTAMP") != -1 && (value == null || !value.equals(GlobalConfig.getParameter("SYSDATE")))) {
++ } else if (type.indexOf("TIMESTAMP") != -1) {
+ if (value == null) {
+- pst.setNull(a+1, java.sql.Types.TIMESTAMP);
++ pst.setNull(a+1, java.sql.Types.TIMESTAMP);
++ } else if (value.equals(GlobalConfig.getParameter("SYSDATE"))) {
++ pst.setObject(a+1, new TimestampNow());
+ } else {
+ CalendarBase tsf = new CalendarBase();
+ tsf.setLangCode(no.getLanguage());
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/thread/ComfireThread.java src/com/openexchange/thread/ComfireThread.java
+--- src.orig/com/openexchange/thread/ComfireThread.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/thread/ComfireThread.java 2007-01-27 13:33:23.000000000 +0100
+@@ -1210,7 +1210,7 @@
+ try {
+ if (free_stmt == null)
+ free_stmt = new HashSet();
+- Statement stmt = no.con.createStatement();
++ Statement stmt = no.con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+
+ try {
+ String mr = Aktuelles_SQL_Object.get("NAS_MR").toString().trim();
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/tools/oxfolder/OXFolderAction.java src/com/openexchange/tools/oxfolder/OXFolderAction.java
+--- src.orig/com/openexchange/tools/oxfolder/OXFolderAction.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/tools/oxfolder/OXFolderAction.java 2007-01-28 16:40:53.000000000 +0100
+@@ -78,6 +78,7 @@
+ import com.openexchange.tools.OXFolderTools;
+ import com.openexchange.tools.conf.GlobalConfig;
+ import com.openexchange.tools.sql.NasResultSet;
++import com.openexchange.tools.sql.TimestampNow;
+
+ /**
+ * @author benjamin.otterbach@open-xchange.org
+@@ -368,14 +369,14 @@
+ if (type.equals("private")) {
+ pst = writeCon.prepareStatement(sql_update_private);
+ pst.setString(1, fname);
+- pst.setString(2, GlobalConfig.getParameter("SYSDATE"));
++ pst.setObject(2, new TimestampNow());
+ pst.setString(3, fullname);
+ pst.setInt(4, fuid);
+ } else {
+ pst = writeCon.prepareStatement(sql_update_other);
+ pst.setString(1, fname);
+ pst.setString(2, owner);
+- pst.setString(3, GlobalConfig.getParameter("SYSDATE"));
++ pst.setObject(3, new TimestampNow());
+ pst.setString(4, fullname);
+ pst.setInt(5, fuid);
+ }
+@@ -523,7 +524,7 @@
+
+ pst.setInt(1, new Integer(targetFolderId).intValue());
+ pst.setString(2, no.getUser());
+- pst.setString(3, GlobalConfig.getParameter("SYSDATE"));
++ pst.setObject(3, new TimestampNow());
+ pst.setString(4, no.getFullName());
+ pst.setInt(5, new Integer(sourceFolderId).intValue());
+
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/tools/OXFolderTools.java src/com/openexchange/tools/OXFolderTools.java
+--- src.orig/com/openexchange/tools/OXFolderTools.java 2007-01-27 12:49:15.000000000 +0100
++++ src/com/openexchange/tools/OXFolderTools.java 2007-01-27 13:28:36.000000000 +0100
+@@ -481,7 +481,7 @@
+ row = "module_contact";
+ }
+
+- ResultSet rs = readCon.createStatement().executeQuery("select owner from oxfolder_standardfolders where owner like '"+userName+"'");
++ ResultSet rs = readCon.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE).executeQuery("select owner from oxfolder_standardfolders where owner like '"+userName+"'");
+ if (rs.next()) {
+ sql = "update oxfolder_standardfolders set " + row + " = "+folderId+" where owner like '" + userName + "'";
+ rs.last();
+@@ -490,7 +490,7 @@
+ sql = "insert into oxfolder_standardfolders (owner, "+row+") VALUES ('"+userName+"', "+folderId+")";
+ }
+ } else {
+- ResultSet rs = readCon.createStatement().executeQuery("select fuid from oxfolder_userfolders_standardfolders where owner like '"+userName+"' AND module like '"+module+"'");
++ ResultSet rs = readCon.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE).executeQuery("select fuid from oxfolder_userfolders_standardfolders where owner like '"+userName+"' AND module like '"+module+"'");
+ if (rs.next()) {
+ sql = "update oxfolder_userfolders_standardfolders set fuid = "+folderId+" where owner like '" + userName + "' AND module like '"+module+"'";
+ rs.last();
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/tools/sql/NasResultSet.java src/com/openexchange/tools/sql/NasResultSet.java
+--- src.orig/com/openexchange/tools/sql/NasResultSet.java 2007-01-27 11:59:55.000000000 +0100
++++ src/com/openexchange/tools/sql/NasResultSet.java 2007-01-27 13:55:01.000000000 +0100
+@@ -78,7 +78,7 @@
+ * @return ResultSet - Fertig generierter ResultSet
+ */
+ public ResultSet getResultSet(String sqlQuery) throws SQLException {
+- return(dataBaseConnection.createStatement().executeQuery(sqlQuery));
++ return(dataBaseConnection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY).executeQuery(sqlQuery));
+ }
+
+ /**
+@@ -93,7 +93,7 @@
+ if (maxCount <= 0) {
+ return(dataBaseConnection.createStatement().executeQuery(sqlQuery));
+ } else {
+- Statement st = dataBaseConnection.createStatement();
++ Statement st = dataBaseConnection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ st.setMaxRows(maxCount);
+
+ return(st.executeQuery(sqlQuery));
+@@ -121,7 +121,7 @@
+ if (firstResult >= resultNumber) {
+ return(dataBaseConnection.createStatement().executeQuery(sqlQuery));
+ }
+- Statement st = dataBaseConnection.createStatement();
++ Statement st = dataBaseConnection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY );
+ st.setMaxRows(resultNumber);
+
+ ResultSet rs = st.executeQuery(sqlQuery);
+@@ -243,7 +243,7 @@
+ */
+ public int getResultSetCount(String sqlQuery) throws SQLException {
+
+- ResultSet rs = dataBaseConnection.createStatement().executeQuery(sqlQuery);
++ ResultSet rs = dataBaseConnection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY).executeQuery(sqlQuery);
+ rs.last();
+ int retval = rs.getRow();
+ rs.close();
+diff --ignore-blank-lines -Naur src.orig/com/openexchange/tools/sql/TimestampNow.java src/com/openexchange/tools/sql/TimestampNow.java
+--- src.orig/com/openexchange/tools/sql/TimestampNow.java 1970-01-01 01:00:00.000000000 +0100
++++ src/com/openexchange/tools/sql/TimestampNow.java 2007-01-28 16:22:52.000000000 +0100
+@@ -0,0 +1,14 @@
++
++package com.openexchange.tools.sql;
++
++import org.postgresql.util.PGobject;
++
++public class TimestampNow extends PGobject {
++ public TimestampNow() {
++ setType("timestamp");
++ }
++ public String getValue() {
++ return "now()";
++ }
++}
++
diff --git a/www-apps/open-xchange-serverpack/files/ox-0.8.2.1-wrong_jdbc_usage_conf.patch b/www-apps/open-xchange-serverpack/files/ox-0.8.2.1-wrong_jdbc_usage_conf.patch
new file mode 100644
index 0000000..1457f26
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/ox-0.8.2.1-wrong_jdbc_usage_conf.patch
@@ -0,0 +1,146 @@
+diff -Naur conf.orig/groupware/METADB/bookmarks_folder_ins.md conf/groupware/METADB/bookmarks_folder_ins.md
+--- conf.orig/groupware/METADB/bookmarks_folder_ins.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/bookmarks_folder_ins.md 2007-01-28 19:00:48.000000000 +0100
+@@ -4,5 +4,5 @@
+ rs1.prg_bookmarks_folder.group_right, 4, text, 3, 1
+ rs1.prg_bookmarks_folder.tid, 5, text, 3, 1
+ rs1.prg_bookmarks_folder.field01, 6, text, 3, 0
+-rs1.prg_bookmarks_folder.intfield02, 7, text, 3, 1
+-rs1.prg_bookmarks_folder.intfield06, 8, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_bookmarks_folder.intfield02, 7, int8, 3, 1
++rs1.prg_bookmarks_folder.intfield06, 8, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur conf.orig/groupware/METADB/bookmarks_folder_upd.md conf/groupware/METADB/bookmarks_folder_upd.md
+--- conf.orig/groupware/METADB/bookmarks_folder_upd.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/bookmarks_folder_upd.md 2007-01-28 19:01:37.000000000 +0100
+@@ -4,4 +4,4 @@
+ rs1.prg_bookmarks_folder.group_right, 4, text, 3, 1
+ rs1.prg_bookmarks_folder.tid, 5, text, 3, 1
+ rs1.prg_bookmarks_folder.field01, 6, text, 3, 0
+-rs1.prg_bookmarks_folder.intfield06, 7, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_bookmarks_folder.intfield06, 7, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur conf.orig/groupware/METADB/bookmarks_ins.md conf/groupware/METADB/bookmarks_ins.md
+--- conf.orig/groupware/METADB/bookmarks_ins.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/bookmarks_ins.md 2007-01-28 19:01:37.000000000 +0100
+@@ -7,5 +7,5 @@
+ rs1.prg_bookmarks.field02, 7, text, 3, 0
+ rs1.prg_bookmarks.field03, 8, text, 3, 0
+ rs1.prg_bookmarks.field04, 9, text, 3, 1
+-rs1.prg_bookmarks.intfield02, 10, text, 3, 1
+-rs1.prg_bookmarks.intfield06, 11, text, 3, 1
++rs1.prg_bookmarks.intfield02, 10, int8, 3, 1
++rs1.prg_bookmarks.intfield06, 11, int8, 3, 1
+diff -Naur conf.orig/groupware/METADB/bookmarks_upd.md conf/groupware/METADB/bookmarks_upd.md
+--- conf.orig/groupware/METADB/bookmarks_upd.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/bookmarks_upd.md 2007-01-28 19:01:37.000000000 +0100
+@@ -7,4 +7,4 @@
+ rs1.prg_bookmarks.field02, 7, text, 3, 0
+ rs1.prg_bookmarks.field03, 8, text, 3, 0
+ rs1.prg_bookmarks.field04, 9, text, 3, 1
+-rs1.prg_bookmarks.intfield06, 10, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_bookmarks.intfield06, 10, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur conf.orig/groupware/METADB/forum_ins.md conf/groupware/METADB/forum_ins.md
+--- conf.orig/groupware/METADB/forum_ins.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/forum_ins.md 2007-01-28 19:01:37.000000000 +0100
+@@ -6,4 +6,4 @@
+ rs1.prg_forums.group_right, 6, text, 3, 1
+ rs1.prg_forums.field01, 7, text, 3, 0
+ rs1.prg_forums.archiv, 8, text, 3, 0
+-rs1.prg_forums.intfield06, 9, text, 3, 1
++rs1.prg_forums.intfield06, 9, int8, 3, 1
+diff -Naur conf.orig/groupware/METADB/forum_message_ins.md conf/groupware/METADB/forum_message_ins.md
+--- conf.orig/groupware/METADB/forum_message_ins.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/forum_message_ins.md 2007-01-28 19:01:37.000000000 +0100
+@@ -3,8 +3,8 @@
+ rs1.prg_forum_entries.changing_date, 3, text, 3, 1
+ rs1.prg_forum_entries.changed_from, 4, text, 3, 1
+ rs1.prg_forum_entries.user_right, 5, text, 3, 1
+-rs1.prg_forum_entries.intfield02, 6, text, 3, 0
+-rs1.prg_forum_entries.intfield03, 7, text, 3, 1
++rs1.prg_forum_entries.intfield02, 6, int8, 3, 0
++rs1.prg_forum_entries.intfield03, 7, int8, 3, 1
+ rs1.prg_forum_entries.field01, 8, text, 3, 0
+ rs1.prg_forum_entries.field02, 9, text, 3, 0
+ rs1.prg_forum_entries.field03, 10, text, 3, 1
+diff -Naur conf.orig/groupware/METADB/forum_upd.md conf/groupware/METADB/forum_upd.md
+--- conf.orig/groupware/METADB/forum_upd.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/forum_upd.md 2007-01-28 19:01:37.000000000 +0100
+@@ -4,4 +4,4 @@
+ rs1.prg_forums.group_right, 4, text, 3, 1
+ rs1.prg_forums.field01, 5, text, 3, 0
+ rs1.prg_forums.archiv, 6, text, 3, 0
+-rs1.prg_forums.intfield06, 7, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_forums.intfield06, 7, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur conf.orig/groupware/METADB/knowledge_folder_ins.md conf/groupware/METADB/knowledge_folder_ins.md
+--- conf.orig/groupware/METADB/knowledge_folder_ins.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/knowledge_folder_ins.md 2007-01-28 19:01:37.000000000 +0100
+@@ -4,5 +4,5 @@
+ rs1.prg_knowledge_folder.group_right, 4, text, 3, 1
+ rs1.prg_knowledge_folder.tid, 5, text, 3, 1
+ rs1.prg_knowledge_folder.field01, 6, text, 3, 0
+-rs1.prg_knowledge_folder.intfield02, 7, text, 3, 1
+-rs1.prg_knowledge_folder.intfield06, 8, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_knowledge_folder.intfield02, 7, int8, 3, 1
++rs1.prg_knowledge_folder.intfield06, 8, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur conf.orig/groupware/METADB/knowledge_folder_upd.md conf/groupware/METADB/knowledge_folder_upd.md
+--- conf.orig/groupware/METADB/knowledge_folder_upd.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/knowledge_folder_upd.md 2007-01-28 19:01:37.000000000 +0100
+@@ -4,4 +4,4 @@
+ rs1.prg_knowledge_folder.group_right, 4, text, 3, 1
+ rs1.prg_knowledge_folder.tid, 5, text, 3, 1
+ rs1.prg_knowledge_folder.field01, 6, text, 3, 0
+-rs1.prg_knowledge_folder.intfield06, 7, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_knowledge_folder.intfield06, 7, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur conf.orig/groupware/METADB/knowledge_ins.md conf/groupware/METADB/knowledge_ins.md
+--- conf.orig/groupware/METADB/knowledge_ins.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/knowledge_ins.md 2007-01-28 18:53:37.000000000 +0100
+@@ -6,5 +6,5 @@
+ rs1.prg_knowledge.field01, 6, text, 3, 0
+ rs1.prg_knowledge.field03, 7, text, 3, 0
+ rs1.prg_knowledge.field04, 8, text, 3, 1
+-rs1.prg_knowledge.intfield02, 9, text, 3, 1
+-rs1.prg_knowledge.intfield06, 10, text, 3, 1
++rs1.prg_knowledge.intfield02, 9, int8, 3, 1
++rs1.prg_knowledge.intfield06, 10, int8, 3, 1
+diff -Naur conf.orig/groupware/METADB/knowledge_upd.md conf/groupware/METADB/knowledge_upd.md
+--- conf.orig/groupware/METADB/knowledge_upd.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/knowledge_upd.md 2007-01-28 19:01:37.000000000 +0100
+@@ -6,4 +6,4 @@
+ rs1.prg_knowledge.field01, 6, text, 3, 0
+ rs1.prg_knowledge.field03, 7, text, 3, 0
+ rs1.prg_knowledge.field04, 8, text, 3, 1
+-rs1.prg_knowledge.intfield06, 9, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_knowledge.intfield06, 9, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur conf.orig/groupware/METADB/pin_board_ins.md conf/groupware/METADB/pin_board_ins.md
+--- conf.orig/groupware/METADB/pin_board_ins.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/pin_board_ins.md 2007-01-28 19:01:37.000000000 +0100
+@@ -9,4 +9,4 @@
+ rs1.prg_pin_board.field04, 9, text, 3, 0
+ rs1.prg_pin_board.timestampfield01, 10, timestamp, 3, 0
+ rs1.prg_pin_board.timestampfield02, 11, timestamp, 3, 0
+-rs1.prg_pin_board.intfield06, 12, text, 3, 0
++rs1.prg_pin_board.intfield06, 12, int8, 3, 0
+diff -Naur conf.orig/groupware/METADB/pin_board_upd.md conf/groupware/METADB/pin_board_upd.md
+--- conf.orig/groupware/METADB/pin_board_upd.md 2007-01-28 18:52:50.000000000 +0100
++++ conf/groupware/METADB/pin_board_upd.md 2007-01-28 19:01:37.000000000 +0100
+@@ -8,4 +8,4 @@
+ rs1.prg_pin_board.field03, 10, text, 3, 0
+ rs1.prg_pin_board.timestampfield01, 11, timestamp, 3, 0
+ rs1.prg_pin_board.timestampfield02, 12, timestamp, 3, 0
+-rs1.prg_pin_board.intfield06, 13, text, 3, 0
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_pin_board.intfield06, 13, int8, 3, 0
+\ Kein Zeilenumbruch am Dateiende.
diff --git a/www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-build_fix.patch b/www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-build_fix.patch
new file mode 100644
index 0000000..d24a5d6
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-build_fix.patch
@@ -0,0 +1,46 @@
+--- build.xml.in.orig 2007-01-24 20:54:29.000000000 +0100
++++ build.xml.in 2007-01-24 21:01:04.000000000 +0100
+@@ -14,7 +14,7 @@
+ <property name="builddir" value="build"/>
+ <property name="jardir" value="lib"/>
+ <property name="infodir" value="info"/>
+- <property name="build.compiler" value="@ANT_JAVAC@"/>
++ <property name="build.compiler" value="modern"/>
+ <property name="doc" value="@enabledoc@"/>
+
+ <target name="init">
+@@ -72,7 +72,11 @@
+ <target name="jar" depends="compile@webdav@">
+ <jar jarfile="${jardir}/comfiretools.jar"
+ basedir="${builddir}"
+- includes="com/openexchange/tools/**, com/openexchange/ssl/**, com/openexchange/api/**" />
++ includes="com/openexchange/tools/**, com/openexchange/api/**"
++ excludes="com/openexchange/ssl/" />
++ <jar jarfile="${jardir}/oxssl.jar"
++ basedir="${builddir}"
++ includes="com/openexchange/ssl/**" />
+ <jar jarfile="${jardir}/nas.jar"
+ basedir="${builddir}"
+ includes="**.class, com/openexchange/server/**, com/openexchange/thread/**, com/openexchange/lizenz/**, com/openexchange/event/**"
+
+--- javabuild/Makefile.am.orig 2007-01-24 21:16:58.000000000 +0100
++++ javabuild/Makefile.am 2007-01-24 21:17:35.000000000 +0100
+@@ -6,12 +6,12 @@
+ @ANT@ -f ../build.xml
+
+ misc:
+- @JAVAH@ -jni -classpath ../lib/comfiretools.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLCtx.h com.openexchange.ssl.SSLCtx
+- @JAVAH@ -jni -classpath ../lib/comfiretools.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLException.h com.openexchange.ssl.SSLException
+- @JAVAH@ -jni -classpath ../lib/comfiretools.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLServerSocket.h com.openexchange.ssl.SSLServerSocket
+- @JAVAH@ -jni -classpath ../lib/comfiretools.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLSocket.h com.openexchange.ssl.SSLSocket
+- @JAVAH@ -jni -classpath ../lib/comfiretools.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLInputStream.h com.openexchange.ssl.SSLInputStream
+- @JAVAH@ -jni -classpath ../lib/comfiretools.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLOutputStream.h com.openexchange.ssl.SSLOutputStream
++ @JAVAH@ -jni -classpath ../lib/oxssl.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLCtx.h com.openexchange.ssl.SSLCtx
++ @JAVAH@ -jni -classpath ../lib/oxssl.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLException.h com.openexchange.ssl.SSLException
++ @JAVAH@ -jni -classpath ../lib/oxssl.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLServerSocket.h com.openexchange.ssl.SSLServerSocket
++ @JAVAH@ -jni -classpath ../lib/oxssl.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLSocket.h com.openexchange.ssl.SSLSocket
++ @JAVAH@ -jni -classpath ../lib/oxssl.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLInputStream.h com.openexchange.ssl.SSLInputStream
++ @JAVAH@ -jni -classpath ../lib/oxssl.jar -o ../src/misc/ssl/com_openexchange_ssl_SSLOutputStream.h com.openexchange.ssl.SSLOutputStream
+
+ clean:
+ @ANT@ -f ../build.xml clean
diff --git a/www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-umin_ssl.patch b/www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-umin_ssl.patch
new file mode 100644
index 0000000..3275ffb
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-umin_ssl.patch
@@ -0,0 +1,15 @@
+diff -Naur src/com/openexchange/umin.orig/OXUsermin.java src/com/openexchange/umin/OXUsermin.java
+--- src/com/openexchange/umin.orig/OXUsermin.java 2007-01-03 16:38:14.000000000 +0100
++++ src/com/openexchange/umin/OXUsermin.java 2007-01-03 17:35:07.000000000 +0100
+@@ -404,7 +404,10 @@
+
+ Hashtable env = new Hashtable(4);
+ env.put(Context.INITIAL_CONTEXT_FACTORY, "com.sun.jndi.ldap.LdapCtxFactory");
+- env.put(Context.PROVIDER_URL, "ldap://"+host+":"+port+"/"+baseDN);
++ if (host.startsWith("ldaps://")) {
++ env.put("java.naming.ldap.factory.socket", "com.openexchange.tools.ssl.TrustAllSSLSocketFactory");
++ }
++ env.put(Context.PROVIDER_URL, host+":"+port+"/"+baseDN);
+ env.put(Context.SECURITY_AUTHENTICATION,"simple");
+ env.put(Context.SECURITY_PRINCIPAL, bindDN);
+ env.put(Context.SECURITY_CREDENTIALS, bindPW);
diff --git a/www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-wrong_jdbc_usage.patch b/www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-wrong_jdbc_usage.patch
new file mode 100644
index 0000000..8c4c217
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/ox-0.8.6.0_beta-wrong_jdbc_usage.patch
@@ -0,0 +1,299 @@
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/bookmarks_folder_ins.md open-xchange-0.8.6-0/conf/groupware/METADB/bookmarks_folder_ins.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/bookmarks_folder_ins.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/bookmarks_folder_ins.md 2007-04-03 23:27:43.000000000 +0200
+@@ -4,5 +4,5 @@
+ rs1.prg_bookmarks_folder.group_right, 4, text, 3, 1
+ rs1.prg_bookmarks_folder.tid, 5, text, 3, 1
+ rs1.prg_bookmarks_folder.field01, 6, text, 3, 0
+-rs1.prg_bookmarks_folder.intfield02, 7, text, 3, 1
+-rs1.prg_bookmarks_folder.intfield06, 8, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_bookmarks_folder.intfield02, 7, int8, 3, 1
++rs1.prg_bookmarks_folder.intfield06, 8, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/bookmarks_folder_upd.md open-xchange-0.8.6-0/conf/groupware/METADB/bookmarks_folder_upd.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/bookmarks_folder_upd.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/bookmarks_folder_upd.md 2007-04-03 23:27:43.000000000 +0200
+@@ -4,4 +4,4 @@
+ rs1.prg_bookmarks_folder.group_right, 4, text, 3, 1
+ rs1.prg_bookmarks_folder.tid, 5, text, 3, 1
+ rs1.prg_bookmarks_folder.field01, 6, text, 3, 0
+-rs1.prg_bookmarks_folder.intfield06, 7, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_bookmarks_folder.intfield06, 7, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/bookmarks_ins.md open-xchange-0.8.6-0/conf/groupware/METADB/bookmarks_ins.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/bookmarks_ins.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/bookmarks_ins.md 2007-04-03 23:27:43.000000000 +0200
+@@ -7,5 +7,5 @@
+ rs1.prg_bookmarks.field02, 7, text, 3, 0
+ rs1.prg_bookmarks.field03, 8, text, 3, 0
+ rs1.prg_bookmarks.field04, 9, text, 3, 1
+-rs1.prg_bookmarks.intfield02, 10, text, 3, 1
+-rs1.prg_bookmarks.intfield06, 11, text, 3, 1
++rs1.prg_bookmarks.intfield02, 10, int8, 3, 1
++rs1.prg_bookmarks.intfield06, 11, int8, 3, 1
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/bookmarks_upd.md open-xchange-0.8.6-0/conf/groupware/METADB/bookmarks_upd.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/bookmarks_upd.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/bookmarks_upd.md 2007-04-03 23:27:43.000000000 +0200
+@@ -7,4 +7,4 @@
+ rs1.prg_bookmarks.field02, 7, text, 3, 0
+ rs1.prg_bookmarks.field03, 8, text, 3, 0
+ rs1.prg_bookmarks.field04, 9, text, 3, 1
+-rs1.prg_bookmarks.intfield06, 10, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_bookmarks.intfield06, 10, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/forum_ins.md open-xchange-0.8.6-0/conf/groupware/METADB/forum_ins.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/forum_ins.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/forum_ins.md 2007-04-03 23:27:43.000000000 +0200
+@@ -6,4 +6,4 @@
+ rs1.prg_forums.group_right, 6, text, 3, 1
+ rs1.prg_forums.field01, 7, text, 3, 0
+ rs1.prg_forums.archiv, 8, text, 3, 0
+-rs1.prg_forums.intfield06, 9, text, 3, 1
++rs1.prg_forums.intfield06, 9, int8, 3, 1
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/forum_message_ins.md open-xchange-0.8.6-0/conf/groupware/METADB/forum_message_ins.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/forum_message_ins.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/forum_message_ins.md 2007-04-03 23:27:43.000000000 +0200
+@@ -3,8 +3,8 @@
+ rs1.prg_forum_entries.changing_date, 3, text, 3, 1
+ rs1.prg_forum_entries.changed_from, 4, text, 3, 1
+ rs1.prg_forum_entries.user_right, 5, text, 3, 1
+-rs1.prg_forum_entries.intfield02, 6, text, 3, 0
+-rs1.prg_forum_entries.intfield03, 7, text, 3, 1
++rs1.prg_forum_entries.intfield02, 6, int8, 3, 0
++rs1.prg_forum_entries.intfield03, 7, int8, 3, 1
+ rs1.prg_forum_entries.field01, 8, text, 3, 0
+ rs1.prg_forum_entries.field02, 9, text, 3, 0
+ rs1.prg_forum_entries.field03, 10, text, 3, 1
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/forum_upd.md open-xchange-0.8.6-0/conf/groupware/METADB/forum_upd.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/forum_upd.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/forum_upd.md 2007-04-03 23:27:43.000000000 +0200
+@@ -4,4 +4,4 @@
+ rs1.prg_forums.group_right, 4, text, 3, 1
+ rs1.prg_forums.field01, 5, text, 3, 0
+ rs1.prg_forums.archiv, 6, text, 3, 0
+-rs1.prg_forums.intfield06, 7, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_forums.intfield06, 7, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/knowledge_folder_ins.md open-xchange-0.8.6-0/conf/groupware/METADB/knowledge_folder_ins.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/knowledge_folder_ins.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/knowledge_folder_ins.md 2007-04-03 23:27:43.000000000 +0200
+@@ -4,5 +4,5 @@
+ rs1.prg_knowledge_folder.group_right, 4, text, 3, 1
+ rs1.prg_knowledge_folder.tid, 5, text, 3, 1
+ rs1.prg_knowledge_folder.field01, 6, text, 3, 0
+-rs1.prg_knowledge_folder.intfield02, 7, text, 3, 1
+-rs1.prg_knowledge_folder.intfield06, 8, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_knowledge_folder.intfield02, 7, int8, 3, 1
++rs1.prg_knowledge_folder.intfield06, 8, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/knowledge_folder_upd.md open-xchange-0.8.6-0/conf/groupware/METADB/knowledge_folder_upd.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/knowledge_folder_upd.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/knowledge_folder_upd.md 2007-04-03 23:27:43.000000000 +0200
+@@ -4,4 +4,4 @@
+ rs1.prg_knowledge_folder.group_right, 4, text, 3, 1
+ rs1.prg_knowledge_folder.tid, 5, text, 3, 1
+ rs1.prg_knowledge_folder.field01, 6, text, 3, 0
+-rs1.prg_knowledge_folder.intfield06, 7, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_knowledge_folder.intfield06, 7, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/knowledge_ins.md open-xchange-0.8.6-0/conf/groupware/METADB/knowledge_ins.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/knowledge_ins.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/knowledge_ins.md 2007-04-03 23:27:43.000000000 +0200
+@@ -6,5 +6,5 @@
+ rs1.prg_knowledge.field01, 6, text, 3, 0
+ rs1.prg_knowledge.field03, 7, text, 3, 0
+ rs1.prg_knowledge.field04, 8, text, 3, 1
+-rs1.prg_knowledge.intfield02, 9, text, 3, 1
+-rs1.prg_knowledge.intfield06, 10, text, 3, 1
++rs1.prg_knowledge.intfield02, 9, int8, 3, 1
++rs1.prg_knowledge.intfield06, 10, int8, 3, 1
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/knowledge_upd.md open-xchange-0.8.6-0/conf/groupware/METADB/knowledge_upd.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/knowledge_upd.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/knowledge_upd.md 2007-04-03 23:27:43.000000000 +0200
+@@ -6,4 +6,4 @@
+ rs1.prg_knowledge.field01, 6, text, 3, 0
+ rs1.prg_knowledge.field03, 7, text, 3, 0
+ rs1.prg_knowledge.field04, 8, text, 3, 1
+-rs1.prg_knowledge.intfield06, 9, text, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_knowledge.intfield06, 9, int8, 3, 1
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/pin_board_ins.md open-xchange-0.8.6-0/conf/groupware/METADB/pin_board_ins.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/pin_board_ins.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/pin_board_ins.md 2007-04-03 23:27:43.000000000 +0200
+@@ -9,4 +9,4 @@
+ rs1.prg_pin_board.field04, 9, text, 3, 0
+ rs1.prg_pin_board.timestampfield01, 10, timestamp, 3, 0
+ rs1.prg_pin_board.timestampfield02, 11, timestamp, 3, 0
+-rs1.prg_pin_board.intfield06, 12, text, 3, 0
++rs1.prg_pin_board.intfield06, 12, int8, 3, 0
+diff -Naur open-xchange-0.8.6-0.orig/conf/groupware/METADB/pin_board_upd.md open-xchange-0.8.6-0/conf/groupware/METADB/pin_board_upd.md
+--- open-xchange-0.8.6-0.orig/conf/groupware/METADB/pin_board_upd.md 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/conf/groupware/METADB/pin_board_upd.md 2007-04-03 23:27:43.000000000 +0200
+@@ -8,4 +8,4 @@
+ rs1.prg_pin_board.field03, 10, text, 3, 0
+ rs1.prg_pin_board.timestampfield01, 11, timestamp, 3, 0
+ rs1.prg_pin_board.timestampfield02, 12, timestamp, 3, 0
+-rs1.prg_pin_board.intfield06, 13, text, 3, 0
+\ Kein Zeilenumbruch am Dateiende.
++rs1.prg_pin_board.intfield06, 13, int8, 3, 0
+\ Kein Zeilenumbruch am Dateiende.
+diff -Naur open-xchange-0.8.6-0.orig/src/com/openexchange/groupware/CalendarAction.java open-xchange-0.8.6-0/src/com/openexchange/groupware/CalendarAction.java
+--- open-xchange-0.8.6-0.orig/src/com/openexchange/groupware/CalendarAction.java 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/src/com/openexchange/groupware/CalendarAction.java 2007-04-04 19:11:00.000000000 +0200
+@@ -54,6 +54,7 @@
+ import java.sql.PreparedStatement;
+ import java.sql.ResultSet;
+ import java.sql.SQLException;
++import java.sql.Timestamp;
+ import java.io.ByteArrayOutputStream;
+ import java.sql.Connection;
+ import java.util.Calendar;
+@@ -685,7 +686,7 @@
+
+ if (mu) {
+ PreparedStatement cc = writecon.prepareStatement("UPDATE del_dates SET changing_date = ?, changed_from = ? WHERE intfield01 = ?");
+- cc.setString(1, GlobalConfig.getParameter("SYSDATE"));
++ cc.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
+ cc.setString(2, no.getUser());
+ cc.setInt(3, new Integer(uniqueID).intValue());
+ cc.addBatch();
+@@ -694,7 +695,7 @@
+ } else if (dmhs.size() > 0) {
+ PreparedStatement cc = writecon.prepareStatement("insert into del_dates (intfield01, creating_date, created_from, user_right, fid) values (?, ?, ?, 'd', -1)");
+ cc.setInt(1, new Integer(uniqueID).intValue());
+- cc.setString(2, GlobalConfig.getParameter("SYSDATE"));
++ cc.setTimestamp(2, new Timestamp(System.currentTimeMillis()));
+ cc.setString(3, no.getUser());
+ cc.addBatch();
+
+@@ -920,8 +921,8 @@
+ no.user.put("rs1.prg_dates.created_from", no.getUser());
+ CalendarBase icb = new CalendarBase();
+ icb.setLangCode(no.getLanguage());
+- cdo.updateData("rs1.prg_dates.creating_date", GlobalConfig.getParameter("SYSDATE"));
++ cdo.updateData("rs1.prg_dates.creating_date", (new Timestamp(System.currentTimeMillis())).toString());
+
+ } else {
+ no.user.put("rs1.prg_dates.changed_from", no.getUser());
+diff -Naur open-xchange-0.8.6-0.orig/src/com/openexchange/groupware/CalendarDelete.java open-xchange-0.8.6-0/src/com/openexchange/groupware/CalendarDelete.java
+--- open-xchange-0.8.6-0.orig/src/com/openexchange/groupware/CalendarDelete.java 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/src/com/openexchange/groupware/CalendarDelete.java 2007-04-04 00:20:11.000000000 +0200
+@@ -52,6 +52,7 @@
+ import java.sql.ResultSet;
+ import java.sql.SQLException;
+ import java.sql.Connection;
++import java.sql.Timestamp;
+ import java.util.*;
+ import java.util.Iterator;
+ import java.util.StringTokenizer;
+@@ -580,7 +581,7 @@
+ }
+ no.user.put("rs1.prg_dates.field07", f7);
+ PreparedStatement pst = writecon.prepareStatement("UPDATE prg_dates SET changing_date = ?, field07 = '"+f7+"', changed_from = ? WHERE intfield02 = " + if2 + " AND intfield05 = 0");
+- pst.setString(1, GlobalConfig.getParameter("SYSDATE"));
++ pst.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
+ pst.setString(2, no.getFullName());
+ if (writecon.getAutoCommit()) {
+ pst.addBatch();
+@@ -663,7 +664,7 @@
+
+ PreparedStatement de = writecon.prepareStatement("insert into del_dates (intfield01, creating_date, created_from, user_right, fid) values (?, ?, ?, 'd', -1)");
+ de.setInt(1, new Integer(vkn).intValue());
+- de.setString(2, GlobalConfig.getParameter("SYSDATE"));
++ de.setTimestamp(2, new Timestamp(System.currentTimeMillis()));
+ de.setString(3, no.getUser());
+ de.addBatch();
+
+diff -Naur open-xchange-0.8.6-0.orig/src/com/openexchange/groupware/DeleteObjects.java open-xchange-0.8.6-0/src/com/openexchange/groupware/DeleteObjects.java
+--- open-xchange-0.8.6-0.orig/src/com/openexchange/groupware/DeleteObjects.java 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/src/com/openexchange/groupware/DeleteObjects.java 2007-04-04 00:20:38.000000000 +0200
+@@ -53,6 +53,7 @@
+ import java.sql.ResultSet;
+ import java.sql.SQLException;
+ import java.sql.Statement;
++import java.sql.Timestamp;
+ import java.util.HashSet;
+ import java.util.HashMap;
+ import java.util.Iterator;
+@@ -1139,7 +1140,7 @@
+
+ String updateStr = "UPDATE backup_projects SET changing_date = ?, changed_from = ? WHERE intfield01 = ?";
+ stmt = writecon.prepareStatement(updateStr);
+- stmt.setString(1, GlobalConfig.getParameter("SYSDATE"));
++ stmt.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
+ stmt.setString(2, no.getFullName());
+ stmt.setInt(3, serial_id);
+ stmt.executeUpdate();
+diff -Naur open-xchange-0.8.6-0.orig/src/com/openexchange/groupware/TasksNewEdit.java open-xchange-0.8.6-0/src/com/openexchange/groupware/TasksNewEdit.java
+--- open-xchange-0.8.6-0.orig/src/com/openexchange/groupware/TasksNewEdit.java 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/src/com/openexchange/groupware/TasksNewEdit.java 2007-04-04 00:21:06.000000000 +0200
+@@ -51,6 +51,7 @@
+ import java.sql.ResultSet;
+ import java.sql.SQLException;
+ import java.sql.Statement;
++import java.sql.Timestamp;
+ import java.text.ParseException;
+ import java.util.Calendar;
+ import java.util.Date;
+@@ -1363,7 +1364,7 @@
+
+ if (mu) {
+ PreparedStatement cc = writeCon.prepareStatement("UPDATE del_tasks SET changing_date = ?, changed_from = ? WHERE intfield01 = ?");
+- cc.setString(1, GlobalConfig.getParameter("SYSDATE"));
++ cc.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
+ cc.setString(2, no.getUser());
+ cc.setInt(3, new Integer(uniqueID).intValue());
+ cc.addBatch();
+@@ -1372,7 +1373,7 @@
+ } else if (dmhs.size() > 0) {
+ PreparedStatement cc = writeCon.prepareStatement("INSERT INTO del_tasks (intfield01, creating_date, created_from, user_right, fid) VALUES (?, ?, ?, 'd', -1)");
+ cc.setInt(1, new Integer(uniqueID).intValue());
+- cc.setString(2, GlobalConfig.getParameter("SYSDATE"));
++ cc.setTimestamp(2, new Timestamp(System.currentTimeMillis()));
+ cc.setString(3, no.getUser());
+ cc.addBatch();
+
+diff -Naur open-xchange-0.8.6-0.orig/src/com/openexchange/tools/oxfolder/OXFolderAction.java open-xchange-0.8.6-0/src/com/openexchange/tools/oxfolder/OXFolderAction.java
+--- open-xchange-0.8.6-0.orig/src/com/openexchange/tools/oxfolder/OXFolderAction.java 2007-04-03 23:24:39.000000000 +0200
++++ open-xchange-0.8.6-0/src/com/openexchange/tools/oxfolder/OXFolderAction.java 2007-04-04 00:21:37.000000000 +0200
+@@ -61,6 +61,7 @@
+ import java.sql.ResultSet;
+ import java.sql.SQLException;
+ import java.sql.Statement;
++import java.sql.Timestamp;
+ import java.util.HashMap;
+ import java.util.HashSet;
+ import java.util.Iterator;
+@@ -369,14 +370,14 @@
+ if (type.equals("private")) {
+ pst = writeCon.prepareStatement(sql_update_private);
+ pst.setString(1, fname);
+- pst.setString(2, GlobalConfig.getParameter("SYSDATE"));
++ pst.setTimestamp(2, new Timestamp(System.currentTimeMillis()));
+ pst.setString(3, fullname);
+ pst.setInt(4, fuid);
+ } else {
+ pst = writeCon.prepareStatement(sql_update_other);
+ pst.setString(1, fname);
+ pst.setString(2, owner);
+- pst.setString(3, GlobalConfig.getParameter("SYSDATE"));
++ pst.setTimestamp(3, new Timestamp(System.currentTimeMillis()));
+ pst.setString(4, fullname);
+ pst.setInt(5, fuid);
+ }
+@@ -531,7 +532,7 @@
+
+ pst.setInt(1, new Integer(targetFolderId).intValue());
+ pst.setString(2, no.getUser());
+- pst.setString(3, GlobalConfig.getParameter("SYSDATE"));
++ pst.setTimestamp(3, new Timestamp(System.currentTimeMillis()));
+ pst.setString(4, no.getFullName());
+ pst.setInt(5, new Integer(sourceFolderId).intValue());
+
diff --git a/www-apps/open-xchange-serverpack/files/ox_reminder.sql b/www-apps/open-xchange-serverpack/files/ox_reminder.sql
new file mode 100644
index 0000000..84e6c1e
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/ox_reminder.sql
@@ -0,0 +1,10 @@
+CREATE TABLE "reminder" (
+ "object_id" int,
+ "target_id" text,
+ "module" int,
+ "username" text,
+ "alarm" timestamp with time zone,
+ "description" text,
+ "folder" text
+);
+
diff --git a/www-apps/open-xchange-serverpack/files/slapd.ox.inc b/www-apps/open-xchange-serverpack/files/slapd.ox.inc
new file mode 100644
index 0000000..b09c7d4
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/slapd.ox.inc
@@ -0,0 +1,49 @@
+access to dn.base=""
+ by dn="uid=root,ou=Users,ou=OxObjects,@basedn@" write
+ by * read
+
+access to dn.base="cn=Subschema"
+ by dn="uid=root,ou=Users,ou=OxObjects,@basedn@" write
+ by * read
+
+# protect the userPassword attribute
+access to attrs=userPassword,shadowLastChange
+ by dn="uid=root,ou=Users,ou=OxObjects,@basedn@" write
+ by anonymous auth
+ by self write
+ by * none
+
+# global address book
+access to dn.subtree="o=AddressBook,ou=OxObjects,@basedn@"
+ by dn="uid=root,ou=Users,ou=OxObjects,@basedn@" write
+ by group.exact="cn=AddressAdmins,o=AddressBook,ou=OxObjects,@basedn@" write
+ by users read
+
+# personal address book
+access to dn.regex="^ou=addr,(uid=([^,]+),ou=Users,ou=OxObjects,@basedn@)$" attrs=children
+ by dn="uid=root,ou=Users,ou=OxObjects,@basedn@" write
+ by dn.exact,expand="$1" write
+access to dn.regex="^uid=([^,]+),ou=addr,(uid=([^,]+),ou=Users,ou=OxObjects,@basedn@)$" attrs=entry
+ by dn="uid=root,ou=Users,ou=OxObjects,@basedn@" write
+ by dn.exact,expand="$2" write
+
+# default rule allowing users full access to their own entries
+
+# In order to let users modify their attributes through OX, you must grant
+# users access to modify uid because of upstream bug #736:
+# http://www.open-xchange.org/cgi-bin/bugzilla/show_bug.cgi?id=736
+#
+# This is not secure and thus hasn't been set here. To enable it, add
+# uid to the following list
+access to attrs=birthDay,cn,description,facsimileTelephoneNumber,gecos,givenName,homePhone,initials,l,labeledURI,mobile,o,ou,OXAppointmentDays,OXDayViewInterval,OXDayViewEndTime,OXDayViewStartTime,OXTaskDays,OXTimeZone,pager,postalCode,preferredLanguage,sn,st,street,telephoneNumber,title,userCountry
+ by dn="uid=root,ou=Users,ou=OxObjects,@basedn@" write
+ by self write
+ by * read
+
+access to *
+ by dn="uid=root,ou=Users,ou=OxObjects,@basedn@" write
+ by * read
+
+# This is supposed to give a performance boose, but it just breaks things for
+# me -- eradicator
+#index uid,mailEnabled,cn,sn,givenname,lnetMailAccess,alias,loginDestination eq,sub
diff --git a/www-apps/open-xchange-serverpack/files/webinterface.ox.include b/www-apps/open-xchange-serverpack/files/webinterface.ox.include
new file mode 100644
index 0000000..3678a9a
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/files/webinterface.ox.include
@@ -0,0 +1,11 @@
+<Directory /usr/share/open-xchange/www>
+ AllowOverride None
+ Order allow,deny
+ Allow from all
+</Directory>
+<Directory /usr/share/open-xchange/www/cgi-bin>
+ Options ExecCGI
+ SetHandler cgi-script
+</Directory>
+
+Alias /open-xchange /usr/share/open-xchange/www
diff --git a/www-apps/open-xchange-serverpack/metadata.xml b/www-apps/open-xchange-serverpack/metadata.xml
new file mode 100644
index 0000000..440d993
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/metadata.xml
@@ -0,0 +1,9 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE pkgmetadata SYSTEM "http://www.gentoo.org/dtd/metadata.dtd">
+
+<pkgmetadata>
+ <maintainer>
+ <email>eradicator@gentoo.org</email>
+ <name>Jeremy Huddleston</name>
+ </maintainer>
+</pkgmetadata>
diff --git a/www-apps/open-xchange-serverpack/open-xchange-serverpack-0.8.6.0_beta.ebuild b/www-apps/open-xchange-serverpack/open-xchange-serverpack-0.8.6.0_beta.ebuild
new file mode 100644
index 0000000..55bd9c8
--- /dev/null
+++ b/www-apps/open-xchange-serverpack/open-xchange-serverpack-0.8.6.0_beta.ebuild
@@ -0,0 +1,551 @@
+# Copyright 1999-2007 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: $
+
+WANT_AUTOCONF=latest
+WANT_AUTOMAKE=latest
+
+inherit autotools eutils ssl-cert toolchain-funcs java-pkg-2 java-ant-2 versionator multilib depend.apache
+
+KEYWORDS="~x86 ~amd64"
+
+MY_PV=$(replace_version_separator 3 -)
+MY_P=open-xchange-server-${MY_PV/beta/BETA}
+
+DESCRIPTION="A Collaboration and Integration Server Environment"
+HOMEPAGE="http://www.open-xchange.com/header/community_area.html"
+SRC_URI="http://www.open-xchange.com/fileadmin/community/${MY_P}.tar.gz"
+LICENSE="GPL-2"
+SLOT="0"
+IUSE="doc java5 ssl webdav"
+
+S=${WORKDIR}/open-xchange-${MY_PV/_beta}
+
+CDEPEND=">=www-servers/tomcat-5.0.28-r4
+ dev-java/jdom
+ dev-java/sun-javamail
+ dev-java/sun-jaf
+ net-nds/openldap
+ app-text/aspell
+ dev-perl/XML-NamespaceSupport
+ dev-perl/Net-SSLeay
+ >=dev-perl/XML-SAX-0.11
+ dev-perl/Authen-SASL
+ dev-perl/Convert-ASN1
+ dev-perl/perl-ldap
+ dev-java/jdbc-postgresql
+ ssl? ( dev-libs/openssl dev-perl/IO-Socket-SSL )"
+
+DEPEND="${CDEPEND}
+ app-arch/zip
+ !java5? ( =virtual/jdk-1.4* )
+ java5? ( =virtual/jdk-1.5* )
+ dev-java/ant-core"
+
+RDEPEND="${CDEPEND}
+ www-apache/mod_jk
+ !java5? ( =virtual/jre-1.4* )
+ java5? ( =virtual/jre-1.5* )"
+
+ox_setup_tomcat() {
+ TOMCAT_CONF=${TOMCAT_CONF:-$(ls -1 /etc/conf.d/tomcat* | sort -r | head -n 1)}
+ einfo "Using tomcat configuration file: '${TOMCAT_CONF}'"
+ einfo "You can change this with:"
+ einfo " export TOMCAT_CONF=/etc/conf.d/tomcat-MYVERSION"
+ einfo "before starting the merge."
+ . ${TOMCAT_CONF}
+
+ SERVLETDIR=${CATALINA_BASE}/webapps
+}
+
+pkg_setup() {
+ if use java5 && ! built_with_use dev-java/jdbc-postgresql java5 ; then
+ eerror "If you want to build ${PN} with java5, jdbc-postgresql has to be"
+ eerror "built with it as well. Please enable the java5 USE-flag for it"
+ eerror "and re-emerge it."
+ die "Missing USE-flag for jdbc-postgresql."
+ elif ! use java5 && built_with_use dev-java/jdbc-postgresql java5 ; then
+ eerror "You can't build ${PN} with java-1.4 and having jdbc-postgresql built"
+ eerror "with java5. Please either enable java5 for ${PN} or disable it"
+ eerror "for jdbc-postgresql."
+ die "Non-matching USE-flags"
+ fi
+
+ java-pkg-2_pkg_setup
+ ox_setup_tomcat
+}
+
+src_unpack() {
+ unpack ${A}
+ cd "${S}"
+
+ epatch "${FILESDIR}/ox-${PV}-build_fix.patch"
+
+ AT_M4DIR=m4
+ eautoreconf
+
+ epatch "${FILESDIR}/ox-${PV}-umin_ssl.patch"
+
+ # This makes it possible to use newer versions of jdbc-postgresql
+ # instead of the old (unmaintained?) jdbc3-postgresql
+ epatch "${FILESDIR}/ox-${PV}-wrong_jdbc_usage.patch"
+
+ if use ssl; then
+ # change login.pm-script if ssl should be used
+ sed -i "s|connection_mode = 3;|connection_mode = 2;|g" src/misc/login/login.pm.in
+ fi
+
+ sed -i \
+ -e "s|/cfintranet/|/open-xchange/cfintranet/|g" \
+ conf/groupware/system.properties.in \
+ conf/webmail/system.properties.in
+
+ sed -i \
+ -e 's:/cgi-bin/:/open-xchange/cgi-bin/:' \
+ src/misc/login/login.pm.in
+
+ sed -i \
+ -e 's/@JAVA@/java/' \
+ -e 's#@JAVA_HOME@/bin/java#java#' \
+ -e "s/\(.*\) -classpath @.*@ \(.*\)/\1 -classpath \$(java-config -p open-xchange-serverpack):\$(java-config -p ${jdbc_db}) \2/" \
+ sbin/addusersql_ox.in sbin/delgroup_ox.in sbin/deluser_ox.in || die "sed failed"
+
+ mkdir jars
+ cd jars
+
+ java-pkg_jar-from jdbc-postgresql
+ java-pkg_jar-from sun-javamail
+ java-pkg_jar-from sun-jaf
+ java-pkg_jar-from jdom-1.0
+ java-pkg_jar-from xerces-2
+ java-pkg_jar-from servletapi-2.4 servlet-api.jar
+}
+
+src_compile() {
+ local myconf
+ local tempvar
+
+ myconf="${myconf} --with-jdbcjar=${S}/jars/jdbc-postgresql.jar"
+
+ econf \
+ $(use_enable doc) \
+ $(use_enable webdav) \
+ $(use_enable ssl) \
+ --with-servletdir="${SERVLETDIR}" \
+ --with-jsdkjar="${S}/jars/servlet-api.jar" \
+ --with-mailjar="${S}/jars/mail.jar" \
+ --with-activationjar="${S}/jars/activation.jar" \
+ --with-jdomjar="${S}/jars/jdom.jar" \
+ --with-xercesjar="${S}/jars/xercesImpl.jar" \
+ --with-jni-dir="$(java-config-2 -O)/include" \
+ --with-runuid=tomcat \
+ --with-rungid=tomcat \
+ --with-tomcatuser=tomcat \
+ --with-htdocsdir=/usr/share/open-xchange/www \
+ --with-cgibindir=/usr/share/open-xchange/www/cgi-bin \
+ --sysconfdir=/etc/open-xchange \
+ --datadir=/usr/share/open-xchange \
+ --includedir=/usr/include/open-xchange \
+ --libdir=/usr/$(get_libdir)/open-xchange \
+ --localstatedir=/var/open-xchange \
+ ${myconf} || die "econf failed"
+
+ EANT_BUILD_TARGET=war
+ java-pkg-2_src_compile
+
+ emake -C javabuild misc || die "emake failed"
+ emake -C src || die "emake failed"
+}
+
+src_install() {
+
+ dodoc AUTHORS ChangeLog NEWS README
+
+ emake DESTDIR="${D}" install || die "emake install failed"
+
+ java-pkg_dolauncher ox_sessiond \
+ --main com.openexchange.sessiond.Sessiond \
+ --java_args "-Xms20M -Xmx280M -Dopenexchange.propfile=/etc/open-xchange/groupware/system.properties -DappName=sessiondApp"
+ java-pkg_dolauncher ox_groupware \
+ --main ComfireServer \
+ --java_args "-Xms20M -Xmx280M -Djava.awt.headless=true -Dopenexchange.propfile=/etc/open-xchange/groupware/system.properties -DappName=groupwareApp"
+ java-pkg_dolauncher ox_webmail \
+ --main ComfireServer \
+ --java_args "-Xms20M -Xmx280M -Djava.awt.headless=true -Dopenexchange.propfile=/etc/open-xchange/webmail/system.properties -DappName=webmailApp"
+
+ dodir ${CATALINA_BASE}/shared/lib
+ dosym /usr/$(get_libdir)/open-xchange/oxssl.jar ${CATALINA_BASE}/shared/lib/oxssl.jar
+
+ java-pkg_regso "${D}/usr/$(get_libdir)/open-xchange/liboxssl.so"
+ java-pkg_regjar ${D}/usr/$(get_libdir)/open-xchange/*.jar
+
+ insinto /etc/open-xchange
+ doins "${FILESDIR}/catalina.conf"
+
+ # remove obsolete log-files they should be saved in /var/log/open-xchange
+ rm -rf "${D}/var/open-xchange/log/"
+ keepdir /var/log/open-xchange
+ dosym /var/log/open-xchange /var/open-xchange/log
+
+ # remove unessary war-files, they are needed for deploying application
+ rm -f "${D}/usr/lib/open-xchange"/*.war
+
+ # remove empty dirs
+ rm -rf \
+ "${D}/usr/include" \
+ "${D}/usr/share"/{info,man}
+
+ # remove unneeded init- and start-scripts - not used by gentoo
+ rm -rf "${D}/etc/open-xchange/init.d" "${D}/etc/open-xchange/initscript.conf"
+ rm -rf "${D}/usr/sbin"/openxchange-*
+
+ # Init script
+ newinitd "${FILESDIR}/init.d.open-xchange" open-xchange || die "newinitd failed"
+ newconfd "${FILESDIR}/conf.d.open-xchange" open-xchange || die "newconfd failed"
+
+ keepdir /var/run/open-xchange
+ fowners tomcat:tomcat /var/run/open-xchange
+
+ insinto "${SERVLETDIR}"
+ doins lib/servlet.war
+
+ # chown of war-files or tomcat gets problems with stopping itself
+ fowners tomcat:tomcat ${SERVLETDIR}/servlet.war
+
+ # open-xchange-webpack has to copy the html-files and images in and we want to change settings in oxuserminconfig.properties
+ unzip lib/umin.war -d "${D}/${SERVLETDIR}/umin"
+ dodir /etc/open-xchange/umin
+ mv "${D}/${SERVLETDIR}/umin/WEB-INF/classes/oxuserminconfig.properties" "${D}/etc/open-xchange/umin"
+
+ fowners -R tomcat:tomcat "${SERVLETDIR}/umin"
+ for f in umin/oxuserminconfig.properties groupware/server.conf webmail/server.conf ; do
+ fowners root:tomcat /etc/open-xchange/${f}
+ fperms 640 /etc/open-xchange/${f}
+ done
+
+ # Put the schema in etc and symlink. This way it's protected.
+ dodir /etc/openldap/schema
+ mv "${D}/usr/share/open-xchange/openxchange.schema" "${D}/etc/openldap/schema"
+ dosym /etc/openldap/schema/openxchange.schema /usr/share/open-xchange/openxchange.schema
+ dosym /etc/openldap/ldap.conf /etc/open-xchange/groupware/ldap.conf
+ dosym /etc/openldap/ldap.conf /etc/open-xchange/webmail/ldap.conf
+
+ if use ssl ; then
+ #create symlink to ssl directory for webmail
+ dosym /etc/open-xchange/groupware/sslcerts /etc/open-xchange/webmail/sslcerts
+ fi
+
+ for x in settings/intranet settings/webmail filespool drafts webmailupload dictionary ; do
+ keepdir /var/open-xchange/${x}
+ fowners tomcat:tomcat /var/open-xchange/${x}
+ done
+
+ insinto ${APACHE2_MODULES_CONFDIR}
+ doins "${FILESDIR}/88_mod_jk.ox.conf"
+
+ insinto ${APACHE2_VHOSTDIR}
+ doins "${FILESDIR}/webinterface.ox.include"
+
+ # copy ldap-aci-file
+ insinto /etc/openldap/
+ doins "${FILESDIR}/slapd.ox.inc"
+
+ # copy sql update file
+ insinto /usr/share/open-xchange/
+ doins "${FILESDIR}/ox_reminder.sql"
+
+ find "${D}/usr/share/open-xchange/" -iname "*.htm" -or -iname "*.lang" -or -iname "*.js" \
+ | xargs sed -i 's|"/cfintranet/|"/open-xchange/cfintranet/|g'
+
+}
+
+#parameter $1 == 1 for config part or == 0 for preinst
+ox_setup() {
+ local config=$1
+ local WORKINGBASE="${IMAGE}" #is used during pkg_*
+ if [[ $config -eq 1 ]]; then
+ #executed from in pkg_config
+ WORKINGBASE="${ROOT}"
+ fi
+ # Simple defaults
+ # some have to defined global
+ OX_DBNAME=${OX_DBNAME-"open_xchange"}
+ OX_DBUSER=${OX_DBUSER-"open_xchange"}
+ OX_DBPASS=${OX_DBPASS-"secret"}
+ OX_DOMAIN=${OX_DOMAIN-"example.org"}
+ # some just needed local
+ local OX_DBHOST=${OX_DBHOST-"localhost"}
+ local OX_ORG=${OX_ORG-"Example Organization"}
+ local OX_LDAPSERVER=${OX_LDAPSERVER-"localhost"}
+ local OX_BASEDN=${OX_BASEDN-"dc=example,dc=org"}
+ local OX_BASEDC=${OX_BASEDC-"example"}
+ local OX_ROOTDN=${OX_ROOTDN-"cn=Manager,${OX_BASEDN}"}
+ local OX_ROOTPW=${OX_ROOTPW-"secret"}
+
+ # Guess base on the installed config but only if it exists
+ if [[ -e "${ROOT}/etc/open-xchange/admintools.conf" ]] ; then
+ local temp_var
+ einfo "Installation of OX detected"
+
+ temp_var=$(get_oxvar DEFAULT_SQL_HOST)
+ [[ -n ${temp_var} ]] && OX_DBHOST=${temp_var}
+
+ temp_var=$(get_oxvar DEFAULT_SQL_DB)
+ [[ -n ${temp_var} ]] && OX_DBNAME=${temp_var}
+
+ temp_var=$(get_oxvar DEFAULT_SQL_USER)
+ [[ -n ${temp_var} ]] && OX_DBUSER=${temp_var}
+
+ temp_var=$(get_oxvar DEFAULT_SQL_PASS)
+ [[ -n ${temp_var} ]] && OX_DBPASS=${temp_var}
+
+ temp_var=$(get_oxvar ORGA)
+ [[ -n ${temp_var} ]] && OX_ORG=${temp_var}
+
+ temp_var=$(get_oxvar BINDDN)
+ [[ -n ${temp_var} ]] && OX_ROOTDN=${temp_var}
+
+ temp_var=$(get_oxvar BINDPW)
+ [[ -n ${temp_var} ]] && OX_ROOTPW=${temp_var}
+
+ if [[ -e "${ROOT}/etc/open-xchange/groupware/ldap.conf" ]] ; then
+ # taken from admintools.conf self
+ temp_var=`grep -v '^#' ${ROOT}/etc/open-xchange/groupware/ldap.conf | grep -i BASE | head -n 1 | awk {'print $2'}`
+ [[ -n ${temp_var} ]] && OX_BASEDN=${temp_var}
+ fi
+ fi
+
+ if [[ ${config} -eq 1 ]]; then
+ # Now asking the user
+ einfo "If values are correct just press enter else enter the new value"
+
+ OX_DBHOST=$(get_user_config "${OX_DBHOST}" "Database Host")
+ OX_DBNAME=$(get_user_config "${OX_DBNAME}" "Database Name")
+ OX_DBUSER=$(get_user_config "${OX_DBUSER}" "Database User")
+ OX_DBPASS=$(get_user_config "${OX_DBPASS}" "Database User's Password")
+ OX_ORG=$(get_user_config "${OX_ORG}" "Organization")
+ OX_DOMAIN=$(get_user_config "${OX_DOMAIN}" "Domain")
+ OX_LDAPSERVER=$(get_user_config "${OX_LDAPSERVER}" "LDAP Server")
+ OX_BASEDN=$(get_user_config "${OX_BASEDN}" "LDAP Base DN")
+ OX_ROOTDN=$(get_user_config "${OX_ROOTDN}" "LDAP Root DN")
+ OX_ROOTPW=$(get_user_config "${OX_ROOTPW}" "LDAP Root Password")
+ OX_BASEDC="`echo ${OX_BASEDN} | sed -n 's:dc=\([-A-Za-z_]*\).*:\1:p'|head -n 1`"
+ einfo "Finished - now writing config"
+ fi
+
+ einfo "Domain = ${OX_DOMAIN}"
+
+ ## now create configs with the right values
+ # starting with ldap
+ sed -i \
+ -e "s|dc=example,dc=org|${OX_BASEDN}|g" \
+ -e "s|example\.org|${OX_DOMAIN}|g" \
+ -e "s|Example Organization|${OX_ORG}|g" \
+ -e "s|example|${OX_BASEDC}|g" \
+ "${WORKINGBASE}/usr/share/open-xchange/init_ldap.ldif"
+
+ sed -i \
+ -e "s|ORGA=\".*\"|ORGA=\"${OX_ORG}\"|g" \
+ -e "s|BINDDN=\".*\"|BINDDN=\"${OX_ROOTDN}\"|g" \
+ -e "s|BINDPW=\".*\"|BINDPW=\"${OX_ROOTPW}\"|g" \
+ -e "s|DEFAULT_SQL_HOST=\".*\"|DEFAULT_SQL_HOST=\"${OX_DBHOST}\"|g" \
+ -e "s|DEFAULT_SQL_DB=\".*\"|DEFAULT_SQL_DB=\"${OX_DBNAME}\"|g" \
+ -e "s|DEFAULT_SQL_USER=\".*\"|DEFAULT_SQL_USER=\"${OX_DBUSER}\"|g" \
+ -e "s|DEFAULT_SQL_PASS=\".*\"|DEFAULT_SQL_PASS=\"${OX_DBPASS}\"|g" \
+ ${WORKINGBASE}/etc/open-xchange/admintools.conf
+
+ # setup correct ACIs
+ sed -i "s|@basedn@|${OX_BASEDN}|g" "${WORKINGBASE}/etc/openldap/slapd.ox.inc"
+
+ # groupware : server.conf
+ for f in /etc/open-xchange/groupware/server.conf /etc/open-xchange/webmail/server.conf ; do
+ sed -i "s|NAS_CON_CLASS_NAME: jdbc:\(.*\)://.*|NAS_CON_CLASS_NAME: jdbc:\1://${OX_DBHOST}/${OX_DBNAME}|g" ${WORKINGBASE}/${f}
+ sed -i \
+ -e "s|NAS_CON_USER:.*|NAS_CON_USER: ${OX_DBUSER}|g" \
+ -e "s|NAS_CON_PASS:.*|NAS_CON_PASS: ${OX_DBPASS}|g" \
+ -e "s|NAS_CON_PASS:.*|NAS_CON_PASS: ${OX_DBPASS}|g" \
+ ${WORKINGBASE}/${f}
+ done
+
+ sed -i \
+ -e "s|LDAP_SERVER=.*|LDAP_SERVER=${OX_LDAPSERVER}|g" \
+ -e "s|LDAP_BASEDN=.*|LDAP_BASEDN=${OX_BASEDN}|g" \
+ -e "s|SQL_SERVER_GROUPWARE=.*|SQL_SERVER_GROUPWARE=${OX_DBHOST}|g" \
+ -e "s|SQL_SERVER_GROUPWARE_DATABASE_NAME=.*|SQL_SERVER_GROUPWARE_DATABASE_NAME=${OX_DBNAME}|g" \
+ -e "s|SQL_SERVER_GROUPWARE_DATABASE_URL=.*|SQL_SERVER_GROUPWARE_DATABASE_URL=jdbc:postgresql://${OX_DBHOST}/${OX_DBNAME}|g" \
+ -e "s|SQL_SERVER_GROUPWARE_DATABASE_USERNAME=.*|SQL_SERVER_GROUPWARE_DATABASE_USERNAME=${OX_DBUSER}|g" \
+ -e "s|SQL_SERVER_GROUPWARE_DATABASE_PASSWORD=.*|SQL_SERVER_GROUPWARE_DATABASE_PASSWORD=${OX_DBPASS}|g" \
+ -e "s|CSS_PATH=/cfintranet/css/stylesheet.css|CSS_PATH=/open-xchange/cfintranet/css/stylesheet.css|g" \
+ "${WORKINGBASE}/etc/open-xchange/umin/oxuserminconfig.properties"
+
+}
+
+pkg_preinst(){
+ #execute ox_setup from preinst(0)
+ ox_setup_tomcat
+ ox_setup 0
+
+ # create user mailadmin, needed for mailsupport
+ enewuser mailadmin -1 -1 /dev/null users
+ _UID=`getent passwd mailadmin | awk -F : '{print $3}'`
+
+ # get the default guid of the group 'users'
+ OX_STDGID=`getent group users | awk -F : '{print $3}'`
+
+ # replace the SuSE group id 500 of users with the gentoo group id of the group 'users' for the mailadmin in ldif + uid
+ sed -i \
+ -e "s|500|${OX_STDGID}|g" \
+ -e "s|501|${_UID}|g" \
+ "${D}/usr/share/open-xchange/init_ldap.ldif"
+
+ # configuring admintools.conf
+
+ # replace the SuSE standard group id 500 with the gentoo group id of the group 'users'
+ sed -i "s|500|${OX_STDGID}|g" ${D}/etc/open-xchange/admintools.conf
+ OX_STDGID=`expr ${OX_STDGID} + 1`
+ sed -i "s|501|${OX_STDGID}|g" ${D}/etc/open-xchange/admintools.conf
+
+ if use ssl ; then
+ SSL_ORGANIZATION="${SSL_ORGANIZATION:-Open Xchange}"
+ insinto /etc/open-xchange/groupware/sslcerts/oxCERTS
+ docert groupware sessiond
+
+ # copying the CA-certificate
+ dodir /etc/open-xchange/groupware/sslcerts/oxCA
+ cp ${T}/*ca.crt ${D}/etc/open-xchange/groupware/sslcerts/oxCA/cacert.pem
+
+ # copying the groupware-key and -cert the way ox would like it to have
+ mv ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupware.key ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupwarekey.pem
+ mv ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupware.crt ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupwarecert.pem
+ mv ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiond.key ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiondkey.pem
+ mv ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiond.crt ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiondcert.pem
+ rm ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiond.pem \
+ ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupware.pem \
+ ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/sessiond.csr \
+ ${D}/etc/open-xchange/groupware/sslcerts/oxCERTS/groupware.csr
+
+ chown -R tomcat:apache ${D}/etc/open-xchange/groupware/sslcerts
+ find ${D}/etc/open-xchange/groupware/sslcerts -name '*.pem' -exec chmod 440 {} \;
+ fi
+}
+
+pkg_postinst() {
+ elog "Execute the following command"
+ elog " emerge --config =${CATEGORY}/${PF}"
+ elog "to setup the initial open-xchange environment."
+
+ ewarn "If you upgrade from a version prior 0.8.1.5 you should execute the following command:"
+ ewarn " psql -U ${OX_DBUSER} ${OX_DBNAME} < ${ROOT}usr/share/open-xchange/ox_reminder.sql"
+
+ ewarn "If you upgrade from a version prior 0.8.1.6 you should execute the following command:"
+ ewarn " psql -U ${OX_DBUSER} ${OX_DBNAME} < ${ROOT}usr/share/open-xchange/ox_project.sql"
+
+ if has_version '=net-nds/openldap-2.1*' ; then
+ ewarn "You have got OpenLDAP-2.1.* installed."
+ ewarn "Please make sure you've got enabled aci support for this package."
+ ewarn "For more information: http://gentoo-wiki.com/HOWTO_Open-Xchange#OpenLDAP"
+ ewarn
+ ewarn "If you already have this done, ignore this warning"
+ fi
+
+ ewarn "Please make sure that the tomcat-user has a valid login-shell and home-directory."
+}
+
+get_oxvar() {
+ sed -n "s:^\s*${1}=\"\(.*\)\":\1:p" ${ROOT}etc/open-xchange/admintools.conf | head -n 1
+}
+
+get_user_config() {
+ local default=$1
+ local desc=$2
+ local read_val;
+
+ echo -n "${desc}? [${default}] " 1>&2
+ read readval
+ if [[ -z ${readval} ]] ; then
+ echo ${default}
+ else
+ echo ${readval}
+ fi
+}
+
+pkg_config() {
+ ox_setup_tomcat
+ #execute ox_setup from pkg_config(1)
+ ## at first automatially change config in init_ldap.ldif and configuration-files
+ ox_setup 1
+
+ if use ssl ; then
+ chown -R tomcat:apache ${ROOT}/etc/open-xchange/groupware/sslcerts
+ find ${ROOT}/etc/open-xchange/groupware/sslcerts -name '*.pem' -exec chmod 440 {} \;
+ fi
+
+ #set correct user rights for ldap
+ chown ldap:ldap ${ROOT}/etc/openldap/slapd.ox.inc
+
+ einfo
+ einfo "================================"
+ einfo "Finished automatic configuration"
+ einfo "================================"
+
+ einfo
+ einfo "Add the following line to ${TOMCAT_CONF}:"
+ einfo " '. /etc/open-xchange/catalina.conf'"
+
+ einfo
+ einfo "Setup /etc/conf.d/apache2"
+ einfo "APACHE2_OPTS=\"-D JK\""
+
+ einfo "You have to add \"Include webinterface.ox.include\" inside a virtual host directive."
+
+ # Tell the user how to propegate ldap and the db
+ ## create ox-dbuser
+ einfo
+ einfo "HOWTO: Setup PostgreSQL database (following commands)"
+ einfo "++++++++++++++++++++++++++++++++++++++++++++++++"
+ einfo "echo \"CREATE USER ${OX_DBUSER} WITH PASSWORD '${OX_DBPASS}' CREATEDB NOCREATEUSER\" | psql -h localhost -U postgres template1 -f -"
+ einfo "echo \"CREATE DATABASE ${OX_DBNAME} WITH OWNER=${OX_DBUSER} ENCODING='UNICODE'\" | psql -h localhost -U postgres template1 -f -"
+ einfo "psql -U ${OX_DBUSER} ${OX_DBNAME} < ${ROOT}usr/share/open-xchange/init_database.sql"
+ einfo "/usr/sbin/dbinit_ox"
+
+ ## initialise database with ox, after configurations have been changed
+ einfo
+ einfo "HOWTO: Setup OpenLDAP"
+ ewarn "Please make sure to STOP slapd to maintain database consistency (from slapadd(8c))!!!"
+ einfo "+++++++++++++++++++++++++++++++++"
+ einfo "/etc/init.d/slapd stop"
+ einfo
+ einfo "Add this to /etc/openldap/slapd.conf:"
+ einfo "include /etc/openldap/schema/cosine.schema"
+ einfo "include /etc/openldap/schema/inetorgperson.schema"
+ einfo "include /etc/openldap/schema/misc.schema"
+ einfo "include /etc/openldap/schema/nis.schema"
+ einfo "include /etc/openldap/schema/openldap.schema"
+ einfo "include /etc/openldap/schema/openxchange.schema"
+ einfo
+ einfo "If you want an initial set of access rights (enables your user, editing their password, ...)"
+ einfo "you should also add the following line:"
+ einfo "include /etc/openldap/slapd.ox.inc"
+ einfo
+ einfo "slapadd -l /usr/share/open-xchange/init_ldap.ldif"
+ einfo
+ einfo "/etc/init.d/slapd start"
+
+ einfo
+ einfo "HOWTO: Add a group"
+ einfo "++++++++++++++++++"
+ einfo "This is suggested for correct webdav-access"
+ einfo "/usr/sbin/addgroup_ox --group=NEWGROUPNAME"
+
+ einfo
+ einfo "HOWTO: Add a user"
+ einfo "+++++++++++++++++"
+ einfo "/usr/sbin/adduser_ox --username=MYUSERNAME --passwd=MYPASSWORD --name=FORENAME --sname=SURENAME --maildomain=${OX_DOMAIN} --ox_timezone=\"Europe/Berlin\""
+ einfo "Now you can add the user to a group."
+ einfo "/usr/sbin/addusertogroup_ox --user=MYUSERNAME --group=NEWGROUPNAME"
+ einfo
+ einfo "If you encounter any problems with this commands probably your ldap or database configuration is not correct"
+ einfo
+ einfo "Web Access:"
+ einfo "To access open-xchange via the web, point your browser to: http://YOUR-HOST-NAME/open-xchange/cgi-bin/login.pl"
+}
diff --git a/www-apps/open-xchange-webpack/Manifest b/www-apps/open-xchange-webpack/Manifest
new file mode 100644
index 0000000..2396719
--- /dev/null
+++ b/www-apps/open-xchange-webpack/Manifest
@@ -0,0 +1,23 @@
+DIST OX-BR-Groupware-0.8.2.tar.gz 180772 RMD160 ee423ff00f8b2e140a8969d0149230410b6c79b2 SHA1 8d4bb5cdc927857bc4ce83f5059bd0d2c7377e4a SHA256 9bf41117a0b02de3eacdf9836c271cb3e8ef7ff24d6dac825b801c3cd3e34d52
+DIST OX-BR-Webmail.0.8.2.tar.gz 26475 RMD160 1035c0e8c23724ccf3f24f71ce286b59e9e61e46 SHA1 454f68119b7001197293906cb3899e52badb6f0b SHA256 1d4f581d44803ccede6ef589590b2bcf2f5218121f86e688a0b7fcd848111b0a
+DIST OX-CZ-Groupware.0.8.1-2.gz 126027 RMD160 c6007480b10826db453e6afd757c9d736f947353 SHA1 cf802ba5a17f534c7a3d8081c95b3146c0b32678 SHA256 14179b1640eda8889f0089a03792d68e37d8907c676fef9b4bf26c149fe3312f
+DIST OX-CZ-Webmail.0.8.1-2.gz 23408 RMD160 67adcd15cdc234978a3f84b6eff523528776c905 SHA1 a6bef5d490c9e43404a81215ebfd48fb1b9e103b SHA256 89a39dc6e89d44bc6a8d4ea80a694e97ab93bff0e963017308bdcca7b29f6288
+DIST OX-ES-Groupware_0.8.2.tar.gz 178081 RMD160 cbb680c42459b6bc3954871a069fa113139fd0b4 SHA1 12edf716e7ecd6dd6ef4c92b30f2eaf37786b53a SHA256 405e054de9d3d0d83d84148e105602b2bcf21de0b67cc3b5a8bef19a872c8356
+DIST OX-ES-WEBMAIL_0.8.2.tar.gz 26166 RMD160 0c311ea050ffd992b4670a44baabcef38e86d972 SHA1 11fc5bc3f11e9d4933658f9c67ef46017e838a78 SHA256 526fb18a10ba75c2457befad080977a5e3d0aad68b215473ba1e7896328f47c1
+DIST OX-FR-Groupware_0.8.2-RC2.tar.gz 160105 RMD160 4e8ab0f9e99c7dbe8177abe149e419f7152a8ee9 SHA1 eb880bc44e3152aaaed28081ac6e38a3e21b7606 SHA256 02f916e51be36f68fd38a472ed3d226c3a04778cfa5cb0a9bb698e4caacf9587
+DIST OX-FR-Webmail_0.8.2-RC2.tar.gz 24411 RMD160 b934728ef817729f6757355c627efa7ee7878702 SHA1 4bb5769a588df80c32330d29922fb329f7850d6b SHA256 7c3124a5fa2a804f5f80695a4c15e831bee83442da04885150241205d0d00e2c
+DIST OX-HU-Groupware.0.8.0-6.tar.gz 129222 RMD160 169a4ca06a9c94e994a2348153f4b44ba81a02e5 SHA1 7adbb7556bd31faf61254924fddca64cb00254a9 SHA256 c47e8cb8d490779d5fd8ccda8ab7ba3aeab5ec00dd496d6c584c570c5d413651
+DIST OX-HU-Webmail.0.8.0-6.tar.gz 24306 RMD160 9ca87a4279179c3f786503905123aaf5a32e3ee0 SHA1 f85881524ea8e1bc47478ab77978a42080fe1609 SHA256 76cc63dc4221f9a62de8edb1ce21d7ba2be4f9357b64c22f95d25035b0c67cfe
+DIST OX-IT-Groupware.0.8.2.tar.gz 181434 RMD160 e121f060f014e1952ad738ab02ffa75cbbbf0884 SHA1 16bd6c09a30b56015ad273b5e834a956e237a8cb SHA256 36e09edb4a6bd10b0b967cca6d2bae538d0f56e9cb2f7b5fb1bd57212e80b4fb
+DIST OX-IT-Webmail.0.8.2.tar.gz 25923 RMD160 e9255d704b1a2d221ecdf74dfa0d153322bdad1c SHA1 dd66ea37af412a8a2795386dee1de3ba45646eed SHA256 6489e8e151b632987afb1d9f8401343f7b6fbca26f4412a61478c1c7b51e42df
+DIST OX-NL-Groupware.0.8.0-5.tar.gz 121222 RMD160 86ce756f876a4c636e0f7718626ef204fa46132b SHA1 93e138a63f363e0de873c39bc54f928cb146aca5 SHA256 cda83e57f3ca26c5acbe2753cfa5870ae25d1f178593d6ff4bc6e71149e4472c
+DIST OX-NL-Webmail.0.8.0-5.tar.gz 23008 RMD160 a08ad4deca331579642059a78dbf74b76e336d2d SHA1 e5da924613cdb73b03273cdfff678903892291fc SHA256 1cb907a375e2c9fa07e8a87e136a9ba8cb9223528ce0155530934f606a568a4d
+DIST OX-NO-Groupware.0.8.0-5.tar.gz 120434 RMD160 35cb0328687a5559c6c08fc3d6a974f3bcaea1f4 SHA1 e4f0384b73fd0ce3932de3df51eb0e818320db3a SHA256 73fa07a91e442a90e533d81dc921e7ee39d4a6dfb0b2c9f20a1790d7b916fc8f
+DIST OX-NO-Webmail.0.8.0-5.tar.gz 22852 RMD160 81a6b679f221e860a01882b709cd6f97f9f55664 SHA1 27d8aeac57b89d632ec921c95cbc572eb401b6e2 SHA256 eef968f36661a301b73ce04778a744e820e2dfeccc00816f9e087d7657f3e3cd
+DIST OX-RU-Groupware.0.8.2.tar.gz 186835 RMD160 97daa2dfe7639c507004dc20b2131c59e8d7a6f2 SHA1 3dec296e5f92e83b6c02dc4e85a033869984d276 SHA256 a1adc6b5178236a8ebbda938c09c27e53c51d05dd7b7683245ff7326b4d0f9c1
+DIST OX-RU-Webmail.0.8.2.tar.gz 27974 RMD160 0dc002c90e36cd71fba290710d2e9e67d59b7a08 SHA1 e2abf83cf9a102d39be2222f72dc76d9ae30af3e SHA256 13e42504a5b14d07ad0d386567866ec225bf4cb6a027b3a8dac0d3161996d4f4
+DIST OX-VE-Groupware_0.8.0-6.tar.gz 121484 RMD160 296d545c69ea6333369e8445d23b289cb1aedb53 SHA1 5dd7b5507bb753fcafa53af8136df5e2ab2de6a9 SHA256 0b46113fd82ca83b68e0b40486f2cc69ad412e7e795c8f386c206ea83abf6067
+DIST OX-VE-Webmail_0.8.0-6.tar.gz 23044 RMD160 198ab3a90c96196412e7b9a5ca693ec073aa3506 SHA1 f357dee49f8aef66d622280b58d13b5b33c30409 SHA256 0cc877cd9bb751c4552594687b391bcda2003ceef12cf0dc80b0c8d3ea0733b3
+DIST open-xchange-0.8.6-0_BETA-WebAccessPack.tar.gz 383209 RMD160 f640c4a674bad51c6969351c5f96d9388ecb2f5e SHA1 588eb19f4a32751aba1b72aba5d55d61af7d8341 SHA256 2af5041502042710c4510425589105ad31ac78877c6f8f7a391e2d8990e4c12d
+DIST open-xchange-0.8.6-0_BETA-webpack_umin.tar.bz2 11147 RMD160 edcac896ef2806c496956891d3fe119052b8e29a SHA1 35f8fc95af105d3d101c71e963b72f3976a8f14e SHA256 fb72bdce0f6ae42c8d3c66060b7f64fb578833f315c56e1a819aab97ce1d7803
+EBUILD open-xchange-webpack-0.8.6.0_beta.ebuild 3524 RMD160 b273299c240830d45e65b6cd2880d45617e82198 SHA1 e82af882e84eb3696c1a899d30aec5bb950ae2a7 SHA256 7718842070dfc5f29e95349c49fc7f799cfbe16b138170b8a5e64db4a2b68627
diff --git a/www-apps/open-xchange-webpack/files/digest-open-xchange-webpack-0.8.6.0_beta b/www-apps/open-xchange-webpack/files/digest-open-xchange-webpack-0.8.6.0_beta
new file mode 100644
index 0000000..4f0da5b
--- /dev/null
+++ b/www-apps/open-xchange-webpack/files/digest-open-xchange-webpack-0.8.6.0_beta
@@ -0,0 +1,66 @@
+MD5 69d03f513d55e269a62afad30e65ebb5 OX-BR-Groupware-0.8.2.tar.gz 180772
+RMD160 ee423ff00f8b2e140a8969d0149230410b6c79b2 OX-BR-Groupware-0.8.2.tar.gz 180772
+SHA256 9bf41117a0b02de3eacdf9836c271cb3e8ef7ff24d6dac825b801c3cd3e34d52 OX-BR-Groupware-0.8.2.tar.gz 180772
+MD5 3cd7352ce5b884c7a7333f074f6f534b OX-BR-Webmail.0.8.2.tar.gz 26475
+RMD160 1035c0e8c23724ccf3f24f71ce286b59e9e61e46 OX-BR-Webmail.0.8.2.tar.gz 26475
+SHA256 1d4f581d44803ccede6ef589590b2bcf2f5218121f86e688a0b7fcd848111b0a OX-BR-Webmail.0.8.2.tar.gz 26475
+MD5 856865c5b8a28d0ce25ad3d139a5adac OX-CZ-Groupware.0.8.1-2.gz 126027
+RMD160 c6007480b10826db453e6afd757c9d736f947353 OX-CZ-Groupware.0.8.1-2.gz 126027
+SHA256 14179b1640eda8889f0089a03792d68e37d8907c676fef9b4bf26c149fe3312f OX-CZ-Groupware.0.8.1-2.gz 126027
+MD5 4c93cac088b848a9836728286a6277d1 OX-CZ-Webmail.0.8.1-2.gz 23408
+RMD160 67adcd15cdc234978a3f84b6eff523528776c905 OX-CZ-Webmail.0.8.1-2.gz 23408
+SHA256 89a39dc6e89d44bc6a8d4ea80a694e97ab93bff0e963017308bdcca7b29f6288 OX-CZ-Webmail.0.8.1-2.gz 23408
+MD5 a0cba65574cdea5ac34fa31c816527b1 OX-ES-Groupware_0.8.2.tar.gz 178081
+RMD160 cbb680c42459b6bc3954871a069fa113139fd0b4 OX-ES-Groupware_0.8.2.tar.gz 178081
+SHA256 405e054de9d3d0d83d84148e105602b2bcf21de0b67cc3b5a8bef19a872c8356 OX-ES-Groupware_0.8.2.tar.gz 178081
+MD5 48629ecfe1e8cbacec369049e996e525 OX-ES-WEBMAIL_0.8.2.tar.gz 26166
+RMD160 0c311ea050ffd992b4670a44baabcef38e86d972 OX-ES-WEBMAIL_0.8.2.tar.gz 26166
+SHA256 526fb18a10ba75c2457befad080977a5e3d0aad68b215473ba1e7896328f47c1 OX-ES-WEBMAIL_0.8.2.tar.gz 26166
+MD5 4698ba9e1f39e057ea6f3f888f3f14a9 OX-FR-Groupware_0.8.2-RC2.tar.gz 160105
+RMD160 4e8ab0f9e99c7dbe8177abe149e419f7152a8ee9 OX-FR-Groupware_0.8.2-RC2.tar.gz 160105
+SHA256 02f916e51be36f68fd38a472ed3d226c3a04778cfa5cb0a9bb698e4caacf9587 OX-FR-Groupware_0.8.2-RC2.tar.gz 160105
+MD5 079a1dff89194653b44d394ad5959f5e OX-FR-Webmail_0.8.2-RC2.tar.gz 24411
+RMD160 b934728ef817729f6757355c627efa7ee7878702 OX-FR-Webmail_0.8.2-RC2.tar.gz 24411
+SHA256 7c3124a5fa2a804f5f80695a4c15e831bee83442da04885150241205d0d00e2c OX-FR-Webmail_0.8.2-RC2.tar.gz 24411
+MD5 3db5ccb73ea6c86e55b290a39b48a2e8 OX-HU-Groupware.0.8.0-6.tar.gz 129222
+RMD160 169a4ca06a9c94e994a2348153f4b44ba81a02e5 OX-HU-Groupware.0.8.0-6.tar.gz 129222
+SHA256 c47e8cb8d490779d5fd8ccda8ab7ba3aeab5ec00dd496d6c584c570c5d413651 OX-HU-Groupware.0.8.0-6.tar.gz 129222
+MD5 edeeac285600e6c3003f735ad05be276 OX-HU-Webmail.0.8.0-6.tar.gz 24306
+RMD160 9ca87a4279179c3f786503905123aaf5a32e3ee0 OX-HU-Webmail.0.8.0-6.tar.gz 24306
+SHA256 76cc63dc4221f9a62de8edb1ce21d7ba2be4f9357b64c22f95d25035b0c67cfe OX-HU-Webmail.0.8.0-6.tar.gz 24306
+MD5 cd48b17c2e750e91a5c725ec92172117 OX-IT-Groupware.0.8.2.tar.gz 181434
+RMD160 e121f060f014e1952ad738ab02ffa75cbbbf0884 OX-IT-Groupware.0.8.2.tar.gz 181434
+SHA256 36e09edb4a6bd10b0b967cca6d2bae538d0f56e9cb2f7b5fb1bd57212e80b4fb OX-IT-Groupware.0.8.2.tar.gz 181434
+MD5 53feaa720ef882f9416cd37bef31265b OX-IT-Webmail.0.8.2.tar.gz 25923
+RMD160 e9255d704b1a2d221ecdf74dfa0d153322bdad1c OX-IT-Webmail.0.8.2.tar.gz 25923
+SHA256 6489e8e151b632987afb1d9f8401343f7b6fbca26f4412a61478c1c7b51e42df OX-IT-Webmail.0.8.2.tar.gz 25923
+MD5 35dbd7b910d2abab5bae692a03fe9a6f OX-NL-Groupware.0.8.0-5.tar.gz 121222
+RMD160 86ce756f876a4c636e0f7718626ef204fa46132b OX-NL-Groupware.0.8.0-5.tar.gz 121222
+SHA256 cda83e57f3ca26c5acbe2753cfa5870ae25d1f178593d6ff4bc6e71149e4472c OX-NL-Groupware.0.8.0-5.tar.gz 121222
+MD5 bb8b29a8ca21cc496c94e503a1a7e640 OX-NL-Webmail.0.8.0-5.tar.gz 23008
+RMD160 a08ad4deca331579642059a78dbf74b76e336d2d OX-NL-Webmail.0.8.0-5.tar.gz 23008
+SHA256 1cb907a375e2c9fa07e8a87e136a9ba8cb9223528ce0155530934f606a568a4d OX-NL-Webmail.0.8.0-5.tar.gz 23008
+MD5 ae126a8a381dc15aaea0c212e7d705f2 OX-NO-Groupware.0.8.0-5.tar.gz 120434
+RMD160 35cb0328687a5559c6c08fc3d6a974f3bcaea1f4 OX-NO-Groupware.0.8.0-5.tar.gz 120434
+SHA256 73fa07a91e442a90e533d81dc921e7ee39d4a6dfb0b2c9f20a1790d7b916fc8f OX-NO-Groupware.0.8.0-5.tar.gz 120434
+MD5 5a50aa7b91b88def7b50f12831d6ef7c OX-NO-Webmail.0.8.0-5.tar.gz 22852
+RMD160 81a6b679f221e860a01882b709cd6f97f9f55664 OX-NO-Webmail.0.8.0-5.tar.gz 22852
+SHA256 eef968f36661a301b73ce04778a744e820e2dfeccc00816f9e087d7657f3e3cd OX-NO-Webmail.0.8.0-5.tar.gz 22852
+MD5 d1e433c143c360f7c9b82387c12fbd3c OX-RU-Groupware.0.8.2.tar.gz 186835
+RMD160 97daa2dfe7639c507004dc20b2131c59e8d7a6f2 OX-RU-Groupware.0.8.2.tar.gz 186835
+SHA256 a1adc6b5178236a8ebbda938c09c27e53c51d05dd7b7683245ff7326b4d0f9c1 OX-RU-Groupware.0.8.2.tar.gz 186835
+MD5 41e4990cac8321562c62bd2a74b852ad OX-RU-Webmail.0.8.2.tar.gz 27974
+RMD160 0dc002c90e36cd71fba290710d2e9e67d59b7a08 OX-RU-Webmail.0.8.2.tar.gz 27974
+SHA256 13e42504a5b14d07ad0d386567866ec225bf4cb6a027b3a8dac0d3161996d4f4 OX-RU-Webmail.0.8.2.tar.gz 27974
+MD5 3a9db5b6ab59a7bf3d367b55da84bf17 OX-VE-Groupware_0.8.0-6.tar.gz 121484
+RMD160 296d545c69ea6333369e8445d23b289cb1aedb53 OX-VE-Groupware_0.8.0-6.tar.gz 121484
+SHA256 0b46113fd82ca83b68e0b40486f2cc69ad412e7e795c8f386c206ea83abf6067 OX-VE-Groupware_0.8.0-6.tar.gz 121484
+MD5 d0197bbf3f341229e8c8d59f26bebeb0 OX-VE-Webmail_0.8.0-6.tar.gz 23044
+RMD160 198ab3a90c96196412e7b9a5ca693ec073aa3506 OX-VE-Webmail_0.8.0-6.tar.gz 23044
+SHA256 0cc877cd9bb751c4552594687b391bcda2003ceef12cf0dc80b0c8d3ea0733b3 OX-VE-Webmail_0.8.0-6.tar.gz 23044
+MD5 30a79a5cd4d9bb8a2fffd78514ffd549 open-xchange-0.8.2-1-webpack.tar.bz2 336319
+RMD160 81ae21962c5f171df777047da9e75dbf8cb7e2aa open-xchange-0.8.2-1-webpack.tar.bz2 336319
+SHA256 27026130a3ccb3186083e46709abd83c290ac18091a47585ed9d120901491a30 open-xchange-0.8.2-1-webpack.tar.bz2 336319
+MD5 28a34027629d30398a809466208f00e0 open-xchange-0.8.2-1-webpack_umin.tar.bz2 6330
+RMD160 b3208dba7084b5ac91f05aafb87db1b5df507bc0 open-xchange-0.8.2-1-webpack_umin.tar.bz2 6330
+SHA256 435254d218cb268a6e18cf0493f3efa932eb5feacec42bfd84141df59ca8a82c open-xchange-0.8.2-1-webpack_umin.tar.bz2 6330
diff --git a/www-apps/open-xchange-webpack/open-xchange-webpack-0.8.6.0_beta.ebuild b/www-apps/open-xchange-webpack/open-xchange-webpack-0.8.6.0_beta.ebuild
new file mode 100644
index 0000000..e3d8dea
--- /dev/null
+++ b/www-apps/open-xchange-webpack/open-xchange-webpack-0.8.6.0_beta.ebuild
@@ -0,0 +1,111 @@
+# Copyright 1999-2006 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: $
+
+inherit versionator
+
+KEYWORDS="~x86 ~amd64"
+
+MY_P=open-xchange-$(replace_version_separator 3 -)
+MY_P=${MY_P/beta/BETA}
+
+DESCRIPTION="A Collaboration and Integration Server Environment"
+HOMEPAGE="http://www.open-xchange.org/"
+SRC_URI="http://www.open-xchange.com/fileadmin/community/${MY_P}-WebAccessPack.tar.gz
+ http://dev.gentoo.org/~dev-zero/distfiles/${MY_P}-webpack_umin.tar.bz2"
+LICENSE="Artistic"
+SLOT="0"
+IUSE=""
+
+BASE_URI="http://www.open-xchange.com/oxcms/opencms/misc/developer-zone/archive/i18n/"
+available_packs="
+es:ES/OX-ES-Groupware_0.8.2.tar.gz;ES/OX-ES-WEBMAIL_0.8.2.tar.gz
+br:BR/OX-BR-Groupware-0.8.2.tar.gz;BR/OX-BR-Webmail.0.8.2.tar.gz
+fr:FR/OX-FR-Groupware_0.8.2-RC2.tar.gz;FR/OX-FR-Webmail_0.8.2-RC2.tar.gz
+ru:RU/OX-RU-Groupware.0.8.2.tar.gz;RU/OX-RU-Webmail.0.8.2.tar.gz
+cz:CZ/OX-CZ-Groupware.0.8.1-2.gz;CZ/OX-CZ-Webmail.0.8.1-2.gz
+ve:VE/OX-VE-Groupware_0.8.0-6.tar.gz;VE/OX-VE-Webmail_0.8.0-6.tar.gz
+it:IT/OX-IT-Groupware.0.8.2.tar.gz;IT/OX-IT-Webmail.0.8.2.tar.gz
+hu:HU/OX-HU-Groupware.0.8.0-6.tar.gz;HU/OX-HU-Webmail.0.8.0-6.tar.gz
+no:NO/OX-NO-Groupware.0.8.0-5.tar.gz;NO/OX-NO-Webmail.0.8.0-5.tar.gz
+nl:NL/OX-NL-Groupware.0.8.0-5.tar.gz;NL/OX-NL-Webmail.0.8.0-5.tar.gz
+"
+
+for pack in ${available_packs[*]}; do
+ lang=${pack%:*}
+ sources=${pack#*:}
+ IUSE="${IUSE} linguas_${lang}"
+ SRC_URI="${SRC_URI} linguas_${lang}? ( ${BASE_URI}${sources%;*} ${BASE_URI}${sources#*;} )"
+done
+
+
+DEPEND=""
+RDEPEND=""
+
+S=${WORKDIR}/${MY_P}
+
+pkg_setup() {
+ TOMCAT_CONF=${TOMCAT_CONF:-$(ls -1 /etc/conf.d/tomcat* | sort -r | head -n 1)}
+ einfo "Using tomcat configuration file: '${TOMCAT_CONF}'"
+ einfo "You can change this by doing 'export TOMCAT_CONF=/etc/conf.d/tomcat-MYVERSION' before starting the merge."
+ . ${TOMCAT_CONF}
+}
+
+src_unpack() {
+ unpack ${MY_P}-WebAccessPack.tar.bz2 ${MY_P}-webpack_umin.tar.bz2
+ cd "${S}"
+
+ # We get those icons with one of the icon-packages
+ rm system/www/groupware/images/top/{DE,EN}/*
+
+ mkdir groupware_locales webmail_locales
+
+ for lang in ${LINGUAS} ; do
+ for pack in ${available_packs} ; do
+ if [[ "${pack%:*}" == "${lang}" ]] ; then
+ sources=${pack#*:}
+ groupware=${sources%;*}
+ webmail=${sources#*;}
+ unpack ${groupware#*/}
+ mv opt/html/* groupware
+ mv opt/locales/* groupware_locales
+ unpack ${webmail#*/}
+ mv opt/html/* webmail
+ mv opt/locales/* webmail_locales
+ fi
+ done
+ done
+
+ find . -name logout.htm \
+ | xargs sed -i -e 's#/cgi-bin/#/open-xchange/cgi-bin/#'
+
+ find -iname "*.htm" -or -iname "*.lang" -or -iname "*.js" \
+ | xargs sed -i "s|/cfintranet/|/open-xchange/cfintranet/|g"
+ sed -i -e "s|/cfintranet/|/open-xchange/cfintranet/|g" system/www/webmail/css/main.css
+}
+
+src_install() {
+ insinto /usr/share/open-xchange/groupware/data/templates/
+ doins -r groupware/*
+ insinto /usr/share/open-xchange/webmail/data/templates/
+ doins -r webmail/*
+
+ insinto /usr/share/open-xchange/www/cfintranet/
+ doins -r system/www/groupware/*
+
+ insinto /usr/share/open-xchange/www/cfintranet/webmail/
+ doins -r system/www/webmail/*
+
+ insinto /etc/open-xchange/groupware/locales/
+ doins -r groupware_locales/*
+
+ insinto /etc/open-xchange/webmail/locales/
+ doins -r webmail_locales/*
+
+ insinto ${CATALINA_BASE}/webapps/umin/WEB-INF/classes
+ doins -r umin/i18n/*
+ insinto ${CATALINA_BASE}/webapps/umin/web/templates/
+ doins -r umin/html/*
+ insinto ${CATALINA_BASE}/webapps/umin/web/images/
+ doins -r system/www/umin/images/*
+}