Changes

4,713 bytes added , 01:53, 10 November 2010

→‎Download & Install Funambol

Line 1: Line 1:

−

~~{{Note box|This HOWTO is still under development.}}~~

== Introduction ==

The Funambol middleware allows you to synchronize mobile devices with [http://wiki.contribs.org/Sogo SOGo] through the

use of the Funambol [http://wiki.contribs.org/Sogo SOGo] Connector. The connector allows any SyncML enabled devices to

fully synchronize contacts, events and tasks with [http://wiki.contribs.org/Sogo SOGo].

−

This ~~is a very preliminary writeup on~~ the installation of Funambol ~~on an SME8b5 installation for use~~ with [[Sogo]]

This HOWTO describes the installation procedure for installing Funambol with the [http://wiki.contribs.org/Sogo SOGo] Connector on an SME8b5 installation.

−

~~Use only for testing~~ on ~~non production machines and when you find~~ an ~~error, please correct it right here :-)~~

== Download & Install Funambol ==

−

Goto https://www.forge.funambol.org/DomainHome.html

−

to download Funambol 8.0. The latest GNU/Linux 32bit funambol server is 8.5, but this has not been confirmed yet for use with SOGO.

to download Funambol 8.5. The latest GNU/Linux 32bit funambol server is 8.7, but this has not been confirmed yet for use with SOGO.

−

~~cd /opt~~

wget http://download.forge.objectweb.org/sync4j/funambol-8.5.2.bin

−

wget http://download.forge.objectweb.org/sync4j/funambol-8.0.2.bin

Run the binary to install:

−

chmod +x funambol-8.0.2.bin

chmod +x funambol-8.5.2.bin

−

./funambol-8.0.2.bin

./funambol-8.5.2.bin

−

Agree on the licence terms and accept ''/opt'' as the directory to extract Funambol. This will install it in:

Agree on the licence terms and accept '''/opt''' as the directory to extract Funambol. This will install it in:

/opt/Funambol

Line 27: Line 25:

At the end of the install, answer '''NO''' on the question if you want to start the server.

−

== ~~Download Apache Commons components ==~~

== Setup Funambol to use MySQL ==

−

~~Download components from here~~

−

~~http://commons.apache.org/~~

−

~~Copy components in the following directory~~

−

~~cd /opt/~~Funambol~~/tools/tomcat/lib/~~

−

~~=== collections (v3.2.1) ===~~

−

~~wget http://www.apache.org/dist/commons/collections/binaries/commons-collections-3.2.1-bin.zip~~

−

~~unzip commons-collections-3.2.1-bin.zip~~

−

~~cp -p commons-collections-3.2.1/commons-collections-3.2.1.jar /opt/Funambol/tools/tomcat/lib/~~

−

~~rm -rf commons-collections-3.2.1~~

−

~~=== confguration (v1.6) ===~~

−

~~wget http://www.apache.org/dist/commons/configuration/binaries/commons-configuration-1.6.zip~~

−

~~unzip commons-configuration-1.6.zip~~

−

~~cp -p commons-configuration-1.6/commons-configuration-1.6.jar /opt/Funambol/tools/tomcat/lib/~~

−

~~rm -rf commons-configuration-1.6~~

−

~~=== logging (v1.1) ==~~=

−

~~wget http://www.apache.org/dist/commons/logging/binaries/commons-logging-1.1.1-bin.zip~~

−

~~unzip commons-logging-1.1.1-bin.zip~~

−

~~cp -p commons-logging-1.1.1/commons-logging-1.1.1.jar /opt/Funambol/tools/tomcat/lib/~~

−

~~rm -rf commons-logging-1.1.1~~

−

=~~== lang (v2.4) ===~~

−

~~wget http://www.apache.org/dist/commons/lang/binaries/commons-lang-2.5-bin.zip~~

−

~~unzip commons-lang-2.5-bin.zip~~

−

~~cp -p commons-lang-2.5/commons-lang-2.5.jar /opt/Funambol/tools/tomcat/lib/~~

−

~~rm -rf commons-lang-2.5~~

−

~~=== json-simple ===~~

−

~~cd /opt/Funambol/tools/tomcat/lib/~~

−

~~wget http://json-simple.googlecode.com/files/json_simple.jar~~

−

~~== Download & Configure Funambol SOGO Connector ==~~

−

~~Check here: http://www.scalableogo.org/english/downloads/backend.html for the latest version of the~~

−

~~'''Funambol SOGo Connector'''~~

−

~~cd /opt/Funambol/ds-server/modules~~

−

~~wget http://www.scalableogo.org/uploads/Funambol/funambol-sogo-1.0.7.s4j~~

−

~~Then, open the '''/opt/Funambol/ds-server/install.properties''' file~~

−

~~vim /opt/Funambol/ds-server/install.properties~~

−

~~and add '''funambol-sogo-1.0.7''' at the end of the "modules-to-install" line.~~

−

== Download & Configure MySQL JDBC driver ==

=== Download & Configure MySQL JDBC driver ===

−

Funambol by installation defaults to use the Hypersonic DB engine, but ~~SOGO requires~~ the use of MySQL.

Funambol by installation defaults to use the Hypersonic DB engine, but [http://wiki.contribs.org/Sogo SOGo] uses MySQL and for Funambol to access the [http://wiki.contribs.org/Sogo SOGo] databases it needs to be setup to also use MySQL for the Funambol database.

−

Goto http://dev.mysql.com/downloads/connector/j/5.0.html to download the JDBC driver for MySQL. The current version is '''mysql-connector-java-5.0.8.zip~~'''. Download it to '''/opt~~'''.

Goto http://dev.mysql.com/downloads/connector/j/5.0.html to download the JDBC driver for MySQL. The current version is '''mysql-connector-java-5.0.8.zip'''.

−

~~cd /opt~~

unzip mysql-connector-java-5.0.8.zip

mkdir -p /opt/Funambol/tools/mysql/lib

Line 92: Line 41:

vim /opt/Funambol/ds-server/install.properties

−

Comment out the existing jdbc driver for Hypersonic and add:

Change the line with '''dbms=''' to:

# The DBMS name. One of:

# - hypersonic

# - postgresql

# - mysql

dbms=mysql

Comment out the existing jdbc driver for Hypersonic and add the MySQL connection information:

# MySQL

Line 102: Line 60:

jdbc.password=yourpassword

−

== ~~Creating MYSQL user~~ and ~~database~~ ==

=== Reconfigure MySQL for InnoDB and access from the local network ===

Funambol uses MySQL with the InnoDB engine and uses networking for access.

/sbin/e-smith/config setprop mysqld InnoDB enabled

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no

/sbin/e-smith/expand-template /etc/my.cnf

/etc/rc.d/rc7.d/S50mysqld restart

=== Creating MYSQL user and database ===

To create the Funambol Database, you'll need to perform each of the following steps:

−

mysqladmin create funambol --default-character-set=utf8

mysql -e "grant all privileges on funambol.* to funambol@localhost identified by 'yourpassword'"

mysql -e "flush privileges"

−

{{Warning box|You may wish to alter the "funambol" and "yourpassword" information in the grant privileges line above. Be sure to configure it correctly in '''/opt/Funambol/ds-server/install.properties''' !}}

−

~~== Reconfigure MySQL for InnoDB and access from the local network ==~~

−

~~Funambol uses MySQL wit the InnoDB engine and uses networking for access.~~

−

~~/sbin/e-smith/config setprop mysqld InnoDB enabled~~

−

~~/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no~~

−

~~/sbin/e-smith/expand-template /etc/my.cnf~~

−

~~/etc/rc.d/rc7.d/S50mysqld restart~~

== Disable Hypersonic JDBC driver ==

−

Edit '''/opt/Funambol/bin/funambol''' and change '''COMED=true''' to '''COMED=false''' somewhere around line 44.

Line 129: Line 82:

Optionally you can ''rm -rf /opt/Funambol/tools/hypersonic'' to save a bit of disk space.

−

== ~~Install Modules in~~ Funambol ==

== Create Funambol user and group ==

−

~~Start the Funambol server using:~~

groupadd funambol

−

useradd -g funambol -d /opt/Funambol funambol

−

/opt/Funambol~~/bin/~~funambol ~~start~~

chmod 770 /opt/Funambol/

−

~~Next, install the Funambol SOGo Connector within Funambol server by issuing the following commands :~~

−

cd /opt/Funambol/

−

~~./bin/install~~

−

~~Answer 'yes' to all questions.~~

−

~~See also:~~

−

~~[https://core.forge.funambol.org/wiki/HOWTOFunambolMySQLFedora10 https://core.forge.funambol.org/wiki/HOWTOFunambolMySQLFedora10]~~

−

~~== Auto start Funambol on startup ==~~

== Set Funambol to start on system startup ==

To make Funambol start automagically, create

Line 157: Line 98:

# funambol Start the funambol services

−

NAME="~~funambol~~"

NAME="Funambol 8.0 with SOGO Connector"

FUNAMBOL_HOME=/opt/Funambol/bin

−

FUNAMBOL_USER=~~root~~

FUNAMBOL_USER=funambol

case "$1" in

start)

Line 178: Line 119:

exit 0

−

complete with

complete it with:

chmod 755 /etc/init.d/funambol

ln -s /etc/init.d/funambol /etc/rc.d/rc7.d/S98funambol

ln -s /etc/init.d/funambol /etc/rc.d/rc6.d/K02funambol

ln -s /etc/init.d/funambol /etc/rc.d/rc2.d/K02funambol

ln -s /etc/init.d/funambol /etc/rc.d/rc1.d/K02funambol

ln -s /etc/init.d/funambol /etc/rc.d/rc0.d/K02funambol

== Add the SOGo Connector ==

''At this stage the core Funambol installation is complete with the exception of the creation of the Funambol database tables. The sections below add the [http://wiki.contribs.org/Sogo SOGo] parts before doing so.''

=== Apache Commons Components ===

The Funambol [http://wiki.contribs.org/Sogo SOGo] Connector requires Apache commons collections (v3.2.1), confguration (v1.6), logging (v1.1), lang (v2.4) and the JSON.simple package. The following subsections have the command required to download and insert the .jar files into the Funambol installation.

These components can be downloaded from here:

http://commons.apache.org/

and are copied into the following directory

cd /opt/Funambol/tools/tomcat/lib/

==== collections (v3.2.1) ====

wget http://www.apache.org/dist/commons/collections/binaries/commons-collections-3.2.1-bin.zip

unzip commons-collections-3.2.1-bin.zip

cp -p commons-collections-3.2.1/commons-collections-3.2.1.jar /opt/Funambol/tools/tomcat/lib/

rm -rf commons-collections-3.2.1

==== confguration (v1.6) ====

wget http://www.apache.org/dist/commons/configuration/binaries/commons-configuration-1.6.zip

unzip commons-configuration-1.6.zip

cp -p commons-configuration-1.6/commons-configuration-1.6.jar /opt/Funambol/tools/tomcat/lib/

rm -rf commons-configuration-1.6

==== logging (v1.1) ====

wget http://www.apache.org/dist/commons/logging/binaries/commons-logging-1.1.1-bin.zip

unzip commons-logging-1.1.1-bin.zip

cp -p commons-logging-1.1.1/commons-logging-1.1.1.jar /opt/Funambol/tools/tomcat/lib/

rm -rf commons-logging-1.1.1

==== lang (v2.4) ====

wget http://www.apache.org/dist/commons/lang/binaries/commons-lang-2.5-bin.zip

unzip commons-lang-2.5-bin.zip

cp -p commons-lang-2.5/commons-lang-2.5.jar /opt/Funambol/tools/tomcat/lib/

rm -rf commons-lang-2.5

==== json-simple ====

wget http://json-simple.googlecode.com/files/json_simple.jar

cp json_simple.jar /opt/Funambol/tools/tomcat/lib/

=== Download & Configure Funambol [http://wiki.contribs.org/Sogo SOGo] Connector ===

Check here: http://www.sogo.nu/english/downloads/backend.html for the latest version of the

'''Funambol SOGo Connector'''

wget http://www.sogo.nu/uploads/Funambol/funambol-sogo-1.0.8.s4j

cp funambol-sogo-1.0.8.s4j /opt/Funambol/ds-server/modules

Then, open the '''/opt/Funambol/ds-server/install.properties''' file

vim /opt/Funambol/ds-server/install.properties

and add '''funambol-sogo-1.0.8''' at the end of the "modules-to-install" line.

== Install Modules and Create Funambol Database Tables ==

With Funambol ready to go and the SOGo modules in place, Funambol needs to be configured and the database tables created by issuing the following commands :

cd /opt/Funambol/

./bin/install

Answer 'yes' to all questions.

Once complete, update file ownerships for all files in the '''/opt/Funambol''' tree (''the install creates a couple of configuration and log files in the /opt/Funambiol tree''):

chown -R funambol:funambol /opt/Funambol/

Funambol is now installed. Start the Funambol server as the '''funambol''' user using:

/etc/init.d/funambol start

== Verify Funambol Installation ==

Have a quick look if Funambol is running correctly by accessing the web page on:

http://<server_domain_name>:8080/funambol/ds

if the server is running, a web page with Funambol Data Synchronization Service information will appear.

== Change Funambol Admin Password ==

The default Funambol admin password is '''sa'''. This can be changed with the '''admin-passwd''' utility but it needs a small fix to load the MySQL connector correctly.

Edit '''/opt/Funambol/bin/admin-passwd'''

vim /opt/Funambol/bin/admin-passwd

and change the line with '''JDBC_JAR''' near the top of the file to:

JDBC_JAR=/opt/Funambol/tools/mysql/lib/mysql-connector-java-5.0.8-bin.jar

Save and run:

cd /opt/Funambol

./bin/admin-passwd

and follow the prompts.

== Public Access to Funambol ==

And if you want to access Funambol outside your local network, you must open port 8080:

config set funambol service access public status enabled TCPPort 8080

signal-event remoteaccess-update

{{Warning box|Port 8080 may conflict with other software installations!}}

{{Note box|TODO: work out where the Funambol port is configured and template it for easy change.}}

== Create SOGo Sync Sources ==

The SOGo-Funambol documentation describes how to create the '''sogo-cal''', '''sogo-card''' and '''sogo-todo''' sync sources through the Funambol administration tool. There are Windows versions of this tool that can be run from a PC and connect to the Funambol server we just installed.

However, the commands below emulate this process and creates entries in the funambol database and the sections below create templated versions of the required XML files, as this allows the [http://wiki.contribs.org/Sogo SOGo] database password to be inserted into these XML files.

The section below inserts the required entries into the funambol database. The next sections create and expand the template files as needed to complete the configuration for [http://wiki.contribs.org/Sogo SOGo].

=== Create Funambol Database Sync Source Entries ===

Create a temporary SQL file:

vim sogo-sync-source-insert.sql

−

~~== SOGO Sync Sources ==~~

and insert:

−

~~The sync sources as described in the SOGO Installation Guide were created by means of the Funambol Admin interface~~ (~~remote from a PC~~). ~~The files that were created were used a~~ the ~~source of~~ the ~~templates we are creating below. The templates allow us to pull in~~ the database password ~~for SOGO from the SOGO installation~~.

INSERT INTO `fnbl_sync_source` (`uri`, `config`, `name`, `sourcetype`) VALUES

('sogo-cal', 'sogo/sogo/sogo/sogo-cal.xml', 'sogo-cal', 'sogo'),

('sogo-card', 'sogo/sogo/sogo/sogo-card.xml', 'sogo-card', 'sogo'),

('sogo-todo', 'sogo/sogo/sogo/sogo-todo.xml', 'sogo-todo', 'sogo');

save the file and then insert the SQL into the funambol database:

mysql funambol --user=funambol --password=yourpassword < sogo-sync-source-insert.sql

=== Configuring the Calendar Sync connection ===

mkdir -p /opt/Funambol/config/sogo/sogo/sogo

mkdir -p /etc/e-smith/templates/opt/Funambol/config/sogo/sogo/sogo/sogo-cal.xml

cd /etc/e-smith/templates/opt/Funambol/config/sogo/sogo/sogo/sogo-cal.xml

touch template-begin

−

Note the ''$sogod{'DbPassword'}'' in the scripts below. This pulls in the the database password that SOGO uses to access the MySQL database.

Edit a new file with:

vim sogo-cal.xml

And insert the following. Note the ''$sogod{'DbPassword'}'' in the scripts below. This pulls in the the database password that SOGO uses to access the MySQL database.

Line 353: Line 432:

vim /opt/Funambol/config/ca/inverse/sogo/security/SOGoOfficer.xml

−

and insert

and insert or update to:

Line 366: Line 445:

== Cleanup and Restart ==

Once complete, update file ownerships for all files again in the '''/opt/Funambol''' tree

chown -R funambol:funambol /opt/Funambol/

Stop and Start the Funambol server as the '''funambol''' user using:

/etc/init.d/funambol stop

/etc/init.d/funambol start

== Funambol Client Configuration ==

−

The URL for accessing the Funambol server is:

The URL for accessing the Funambol server from mobile devices is:

http://<server_domain_name>:8080/funambol/ds

Line 379: Line 469:

* Tasks: sogo-todo

== References ==

* Funambol Documentation: https://www.forge.funambol.org/download/documentation.html

* SOGo Documentation: http://www.sogo.nu/english/downloads/documentation.html

----

[[Category: Howto]]

Thf

374

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/14601...15247"

Changes

Funambol (view source)

Revision as of 01:53, 10 November 2010

Navigation menu

Search