References:
http://mail.opengroupware.org/pipermail/users/2006-September/016806.html
http://comalies.citadel.org/~matt/funambol/pre-rc1/

Opengroupware install

vi /etc/apt/sources.list

add

deb http://download.opengroupware.org/nightly/packages/debian sarge releases/opengroupware-1.1.6-yummy
deb http://download.opengroupware.org/nightly/packages/debian sarge releases/sope-4.5.9-maple
deb http://download.opengroupware.org/nightly/packages/debian sarge releases/ThirdParty

apt-get update
apt-get install libsope-core4.5 libfoundation1.1
apt-get dist-upgrade

some dependancies will be missing, as we are running on etch, not sarge.

wget http://http.us.debian.org/debian/pool/main/r/readline4/libreadline4_4.3-11_i386.deb
wget http://http.us.debian.org/debian/pool/main/p/pilot-link/libpisock8_0.11.8-10_i386.deb
wget http://security.debian.org/debian-security/pool/updates/main/p/postgresql/libpq3_7.4.7-6sarge4_i386.deb

dpkg -i libreadline4_4.3-11_i386.deb
dpkg -i libpisock8_0.11.8-10_i386.deb
dpkg -i libpq3_7.4.7-6sarge4_i386.deb

apt-get install postgresql libapache-mod-ngobjweb

apt-get install opengroupware.org1.1*

apt-get install libfoundation-tools

apt-get install daemon

hacks to fix up the broken install

wget http://svn.opengroupware.org/viewcvs/*checkout*/releases/1.1.6-yummy/debian/ogo-create-instance?rev=1759

chmod 700 ogo-create-instance?rev=1759

./ogo-create-instance?rev=1759

wget http://svn.opengroupware.org/viewcvs/*checkout*/releases/1.1.6-yummy/debian/opengroupware.org-environment.opengroupware.org?rev=1759

mv opengroupware.org-environment.opengroupware.org\?rev\=1759 opengroupware

chmod 700 opengroupware

mv opengroupware /etc/init.d/

cd /etc/rc2.d

ln -s ../init.d/opengroupware S92opengroupware

cd ../rc3.d/

ln -s ../init.d/opengroupware S92opengroupware

cd ../rc4.d/

ln -s ../init.d/opengroupware S92opengroupware

cd ../rc5.d/

ln -s ../init.d/opengroupware S92opengroupware


Configure postgress to allow access to database.

need to allow local machine access to postgress

/etc/postgresql/7.4/main# vi pg_hba.conf

looks like this...

# Database administrative login by UNIX sockets
local all postgres ident sameuser

# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

local all all ident sameuser
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 md5
# IPv6-style local connections:
host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff md5

Funombal install

This is not an apt-get install procedure.

Required Files


* http://sourceforge.net/project/showfiles.php?group_id=22866&package_id=16942&release_id=416591 jBoss 4.0.4GA Installer (jboss-4.0.4.GA-Patch1-installer.jar

* http://www.funambol.com/opensource/download_form.html?file_id=funambol-ds-server-5.0.10.zip Funambol DS Server 5.0.10 archive

* http://comalies.citadel.org/~matt/funambol/latest/

GroupDAV? Funambol s4j (groupdav-1.x.xxxx.s4j)

JGroupDAV?.jar

gdav_libs.tar.bz2

* http://www.funambol.com/opensource/download_form.html?file_id=funambol-admin-3.0.9.tgz Funambol Administration Tool 3.0.9

* www.java.com java5 sdk (bambam\apps\oe10) note - sdk, not jre

Install java

reference: LinuxJava

Get the java 5 sdk from www.java.com

extract the contents to (eg) /usr/lib/jdk1.5.0_11

ln -s /usr/lib/jdk1.5.0_11 /usr/lib/java

ln -s /usr/bin/java /usr/lib/java/bin/java

add to /etc/profile and any scripts that need java

export JAVA_HOME=/usr/lib/java

Install Jboss

References:
http://comalies.citadel.org/~matt/funambol/pre-rc1/install-guide/x47.html

Installing jBoss is fairly easy. The installer is a runable java archive, and can be executed by double clicking on it in your GUI or manually by:

$ java -jar jboss-4.0.4.GA-Patch1-installer.jar

If you don't have graphical access to your system and can't run the installer, try either one of the other archives from the download site, or perhaps a jBoss package from your system vendor

Take note of the location on your system which you install jBoss to. When asked, choose the default install profile

jboss installs to
/usr/local/jboss-4.0.4.ga

Install funambol

cd ~
unzip funambol-ds-server-5.0.10.zip
this is an old version you want the latest version from Matts download site.

cd /usr/local

mv ~/Funambol .

4. Funambol DS Server

Unzip the Funambol archive and move its contents to a permanent place on your system. Then open up a terminal and export the following environment variables:

$ export JAVA_HOME=/usr/lib/java

$ export J2EE_HOME=/usr/local/jboss-4.0.4.ga

(Suggestion: save the exports as a shell script so you can source them when needed - put them in any scripts that start the jboss)

Copy the groupdav-1.x.xxxx.s4j archive to modules in the Funambol/ds-server directory.

I am using mysql for funambol, need the jdbc connector. My server accepts login from localhost as root with a password

cd ~ wget http://dev.mysql.com/downloads/connector/j/5.0.html

gunzip the file, untar it.

find the file

mysql-connector-java-5.0.4-bin.jar

and copy it to the jboss default server lib folder

cp mysql-connector-java-5.0.4-bin.jar /usr/local/jboss-4.0.4.GA/server/default/lib

Open up install.properties in Funambol/ds-server,

dbms=mysql

further down... My server accepts login from localhost as root with a password

jdbc.classpath=/usr/local/jboss-4.0.4.GA/server/default/lib/mysql-connector-java-5.0.4-bin.jar
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost/funambol
jdbc.user=root
jdbc.password=......

Just below the SQL definitions there is a modules-to-install line:

modules-to-install=foundation-3.0.9,pdi-3.0.5,pimweb-3.0.8,funambol-db-3.0.7

Add the GroupDAV? connector to the end of it, like so:

modules-to-install=foundation-3.0.9,pdi-3.0.5,pimweb-3.0.8,funambol-db-3.0.7,groupdav-1.x.xxxx

Next, make the install scripts executable, and install Funambol:

$ chmod +x bin/install.sh $ chmod +x bin/install-modules.sh $ bin/install.sh jboss40

The script will ask you if you wish to replace the database for each module. Answer Y (yes) to each one.

ATTENTION! If you already have services running on port 8080, edit the jBoss tomcat configuration in /server/default/deploy/jbossweb-tomcat55.sar/server.xml

Before we start Funambol, the server needs all the dependencies for the connector in its classpath. Copy JGroupDAV?.jar, and the contents of gdav_libs.tar.bz2 to /server/funambol/lib. Then, start Funambol with:

$ bin/start.sh

prove the point, hitting the site...

http://emailvm:8080/funambol/