On 14/06/10 16:06, Martin Lehmann wrote:
Yes, it's the svn version (you can get the sources from the homepage).
But if I remember right 1.0.7 worked also for me.
My 1st try didn't work, I got no sogo menues in funambol. After a 2nd
try, following the manual step-by-step, it worked for me.
I've tried again from scratch... and I've even written a script to
repeat what I'm doing automatically so there's no room for error (unless
it's programmed in). I guess at least it will fail consistently. Does
any of this look wrong at all? :
apt-get update
apt-get install wget postgresql
# See http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=560044 .
# Apparently a fix is in the pipeline, but until then a change
# in /etc/sysctl.d/bindv6only.conf is required (ie. changing the
# net.ipv6.bindv6only config option from 1 to 0).
sed -i 's/net.ipv6.bindv6only\ =\ 1/net.ipv6.bindv6only\ =\ 0/'
/etc/sysctl.d/bindv6only.conf && invoke-rc.d procps restart
# Allow database logins from our local IP, and show how to allow
connections from a network.
sed -i 's...@host.*all.*all.*127\.0\.0\.1/32.*md5'\
'@host all all 127.0.0.1/32 md5\
# ...the following allows access from the local IP\
host all all '`hostname --ip-address`'/32 md5\
# ...for an entire network do something like the following :\
# host all all 192.168.1.0/24 md5@' /etc/postgresql/8.4/main/pg_hba.conf
# Listen for database connections on all interfaces, and use password
encryption
sed -i "s...@#listen_addresses = 'localhost'@listen_addresses = '*'@"
/etc/postgresql/8.4/main/postgresql.conf
sed -i "s...@#password_encryption = o...@password_encryption = on@"
/etc/postgresql/8.4/main/postgresql.conf
/etc/init.d/postgresql-8.4 restart
# We randomly generate a password which we use to create our database user
POSTGRES_PW=`openssl rand -base64 30`
sudo -u postgres psql -c "CREATE ROLE funambol ENCRYPTED PASSWORD
'$POSTGRES_PW' CREATEDB CREATEROLE INHERIT LOGIN;"
sudo -u postgres createdb -E UTF8 -O funambol funambol
cd /usr/src
echo "Should Funambol be downloaded?"
echo "If you already have downloaded funambol-8.0.2-bin and copied it to"
echo "/usr/src choose 'n', otherwise choose 'y' - after your choice hit
<enter>"
read download_funambol
if [ "$download_funambol" == "yes" ]; then
wget http://download.forge.objectweb.org/sync4j/funambol-8.0.2.bin
else
echo "Assuming Funambol is already downloaded... continuing..."
fi
# ...to suit my local environment...
echo "IMPORTANT!!! - When prompted install Funambol into the /srv
directory."
echo " NOTE::Do NOT start Funambol. Hit <enter> to
continue..."
read dummy_val
sh ./funambol-8.0.2.bin
# We need to remove the hypersonic database and its config options and
# replace with PostgreSQL.
sed -i 's...@^dbms=hypersonic@dbms=postgresql@'
/srv/Funambol/ds-server/install.properties
sed -i
's...@^jdbc.classpath=../tools/hypersonic...@jdbc.classpath=/usr/share/java/postgresql.jar@'
/srv/Funambol/ds-server/install.properties
sed -i
's...@^jdbc.driver=org.hsqldb.jdbcdriver@jdbc.driver=org.postgresql.Driver@' /srv/Funambol/ds-server/install.properties
sed -i
's...@^jdbc.url=jdbc:hsqldb:hsql://localhost/funam...@jdbc.url=jdbc:postgresql://'`hostname
--fqdn`'/funambol@' /srv/Funambol/ds-server/install.properties
sed -i 's...@^jdbc.user=sa@jdbc.user=funambol@'
/srv/Funambol/ds-server/install.properties
sed -i 's...@^jdbc.password=@jdbc.password='$POSTGRES_PW'@'
/srv/Funambol/ds-server/install.properties
# Copy the SOGo connector and dependencies to the required locations
cd /srv/Funambol/ds-server/modules
wget http://www.sogo.nu/uploads/Funambol/funambol-sogo-1.0.7.s4j
# Add the SOGo connector to the modules-to-install option in the config.
sed -i 's...@webdemo-8.0.1@webdemo-8.0.1,funambol-sogo-1.0.7@'
/srv/Funambol/ds-server/install.properties
# We need to copy required JARs to the tomcat directory
cd /tmp
wget
http://apache.mirror.aussiehq.net.au/commons/collections/binaries/commons-collections-3.2.1-bin.tar.gz
tar -zxvf commons-collections-3.2.1-bin.tar.gz
commons-collections-3.2.1/commons-collections-3.2.1.jar
cp collections-3.2.1/commons-collections-3.2.1.jar
/srv/Funambol/tools/tomcat/lib
wget
http://apache.wildit.net.au/commons/logging/binaries/commons-logging-1.1.1-bin.tar.gz
tar -zxvf commons-logging-1.1.1-bin.tar.gz
commons-logging-1.1.1/commons-logging-1.1.1.jar
cp commons-logging-1.1.1/commons-logging-1.1.1.jar
/srv/Funambol/tools/tomcat/lib
wget
http://apache.mirror.aussiehq.net.au/commons/lang/binaries/commons-lang-2.5-bin.tar.gz
tar -zxvf commons-lang-2.5-bin.tar.gz commons-lang-2.5/commons-lang-2.5.jar
cp commons-lang-2.5/commons-lang-2.5.jar /srv/Funambol/tools/tomcat/lib
cd /srv/Funambol/tools/tomcat/lib/
wget http://jdbc.postgresql.org/download/postgresql-8.4-701.jdbc3.jar
wget http://json-simple.googlecode.com/files/json_simple-1.1.jar
# Install Funambol
cd /srv/Funambol
echo "Time to run the Funambol install process."
echo "Hit <enter> to continue..."
read dummy_val
./bin/install
./bin/funambol start
./bin/install-modules
# Configure the port and hostname of the SOGo plugin
sed -i 's...@31000@20000@'
/srv/Funambol/config/ca/inverse/sogo/security/SOGoOfficer.xml
sed -i 's...@localhost@'`hostname --fqdn`'@'
/srv/Funambol/config/ca/inverse/sogo/security/SOGoOfficer.xml
echo ""
echo "Now, confgure the data sources for SOGo. To do so, start the
Funambol Administration Tool
using the following command :
/opt/Funambol/admin/bin/funamboladmin
Log in.
Go in Modules > sogo > FunambolSOGoConnector > SOGo SyncSource and add a
source for
each data type you would like to synchronize. For example, to
synchronize an address book,
you would specify:
Source URI: sogo-card
Name: sogo-card
Supported type: text/x-vcard
Database URL: jdbc:postgresql://localhost/sogo
Database username: sogo
Database password: qwerty
You can then do the same (and specify the same database connection
information) for events
and tasks using sogo-cal and sogo-todo as sync source names and URI.
"
--
Mark Pavlichuk
Strategic IT
ph. (07)47795932
m. 0409 124577
--
users@sogo.nu
https://inverse.ca/sogo/lists
