Simple Groupware Installation SyncML Server

SyncML is a platform-independent Synchronization Markup Language. SyncML communicates on top of the HTTP protocol and can be used with a normal network or internet connection. This means that you can synchronize all kinds of information between Simple Groupware and your mobile devices. Some mobile devices support SyncML natively, others are used in combination with a special client software on the device to make it SyncML ready.

Simple Groupware itself does not include the SyncML protocol, therefore it communicates with the free SyncML server from Funambol (former Sync4j). The interface between Simple Groupware and Funambol is described here.

Funambol also offers free SyncML clients for: Windows Mobile, Blackberry, iPod, iPhone, Outlook, Evolution, Palm, Thunderbird, Gmail, Yahoo, Lotus Domino, Exchange and a J2ME client

All files from Funambol (server, clients and manuals) are available here.


Installation with Windows and MySQL (Funambol v7/v8)

  • Funambol v7/v8 requires at least Simple Groupware 0.420 and MySQL 5.0
  • Download the package "PIM & E-Mail Bundle" for Windows from Funambol
    (latest version tested is 8.0.1, all files are here)
  • Install the setup package (e.g. funambol-8.0.1.exe)
  • Open your browser and go to http://localhost:8080/. You should now see a page with the title "The Funambol Data Synchronization Server".
  • Copy the file "<sgs-dir>\bin\tools\funambolv7_syncML\mysql\mysql-connector-java-5.1.6-bin.jar" to "C:\Program Files\Funambol\tools\" (or another location where your Funambol server was installed to).
  • Edit the file "C:\Program Files\Funambol\ds-server\install.properties" and replace:

dbms=hypersonic
...
jdbc.classpath=../tools/hypersonic/lib/hsqldb.jar
jdbc.driver=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://localhost/funambol
jdbc.user=sa
jdbc.password=

with:

dbms=mysql

jdbc.classpath=../tools/mysql-connector-java-5.1.6-bin.jar
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://<host>/<database>?characterEncoding=UTF-8
jdbc.user=<username>
jdbc.password=<password>

Make sure to replace <host>, <database>, <username> and <password> with your MySQL credentials (same as those used in Simple Groupware).
  • Execute the file "C:\Program Files\Funambol\bin\install.cmd" (double-click in Windows Explorer) and confirm the questions with "y"
  • Start the Funambol Data Synchronization Server:
    Right-click the icon in the taskbar and choose "Start Server" and wait a bit until the icon turns into green color.
  • Make sure that Simple Groupware is installed on the same machine
  • Open your browser and go to http://localhost/<sgs-dir>/bin/index.php.
  • Log in as super administrator
  • Navigate to "/Workspace/System" and choose "Change setup settings".
  • Click the checkbox "Enable Sync4j / Funambol"
  • Then click "Save" and you're done.
  • Read more about the SyncML integration.
  • Enjoy Simple Groupware!


Installation with Windows and PostgreSQL (Funambol v7/v8)

  • Funambol v7/v8 requires at least Simple Groupware 0.420
  • Download the package "PIM & E-Mail Bundle" for Windows from Funambol
    (latest version tested is 8.0.1, all files are here)
  • Install the setup package (e.g. funambol-8.0.1.exe)
  • Open your browser and go to http://localhost:8080/. You should now see a page with the title "The Funambol Data Synchronization Server".
  • Copy the file "<sgs-dir>\bin\tools\funambolv7_syncML\postgresql\postgresql-8.3-603.jdbc3.jar" to "C:\Program Files\Funambol\tools\" (or another location where your Funambol server was installed to).
  • Edit the file "C:\Program Files\Funambol\ds-server\install.properties" and replace:

dbms=hypersonic
...
jdbc.classpath=../tools/hypersonic/lib/hsqldb.jar
jdbc.driver=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://localhost/funambol
jdbc.user=sa
jdbc.password=

with:

dbms=postgresql

jdbc.classpath=../tools/postgresql-8.3-603.jdbc3.jar
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbc:postgresql://<host>/<database>
jdbc.user=<username>
jdbc.password=<password>

Make sure to replace <host>, <database>, <username> and <password> with your PostgreSQL credentials (same as those used in Simple Groupware).
  • Execute the file "C:\Program Files\Funambol\bin\install.cmd" (double-click in Windows Explorer) and confirm the questions with "y"
  • Start the Funambol Data Synchronization Server:
    Right-click the icon in the taskbar and choose "Start Server" and wait a bit until the icon turns into green color.
  • Make sure that Simple Groupware is installed on the same machine
  • Open your browser and go to http://localhost/<sgs-dir>/bin/index.php.
  • Log in as super administrator
  • Navigate to "/Workspace/System" and choose "Change setup settings".
  • Click the checkbox "Enable Sync4j / Funambol"
  • Then click "Save" and you're done.
  • Read more about the SyncML integration.
  • Enjoy Simple Groupware!


Installation with Linux and MySQL (Funambol v7/v8)

  • Funambol v7/v8 requires at least Simple Groupware 0.420 and MySQL 5.0
  • Download the package "PIM & E-Mail Bundle" for Linux from Funambol
    (latest version tested is 8.0.1, all files are here)
  • Install the setup package (e.g. funambol-8.0.1.bin)
  • Open your browser and go to http://localhost:8080/. You should now see a page with the title "The Funambol Data Synchronization Server".
  • Copy the file "<sgs-dir>/bin/tools/funambolv7_syncML/mysql/mysql-connector-java-5.1.6-bin.jar" to "<funambol-dir>/tools/" (or another location where your Funambol server was installed to).
  • Edit the file "<funambol-dir>/ds-server/install.properties" and replace:

dbms=hypersonic
...
jdbc.classpath=../tools/hypersonic/lib/hsqldb.jar
jdbc.driver=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://localhost/funambol
jdbc.user=sa
jdbc.password=

with:

dbms=mysql

jdbc.classpath=../tools/mysql-connector-java-5.1.6-bin.jar
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://<host>/<database>?characterEncoding=UTF-8
jdbc.user=<username>
jdbc.password=<password>

Make sure to replace <host>, <database>, <username> and <password> with your MySQL credentials (same as those used in Simple Groupware).
  • Execute the file "<funambol-dir>/bin/install" and confirm the questions with "y"
  • Start the Funambol Data Synchronization Server from the terminal, and wait a bit:
    <funambol-dir>/bin/funambol start
  • Make sure that Simple Groupware is installed on the same machine
  • Open your browser and go to http://localhost/<sgs-dir>/bin/index.php.
  • Log in as super administrator
  • Navigate to "/Workspace/System" and choose "Change setup settings".
  • Click the checkbox "Enable Sync4j / Funambol"
  • Then click "Save" and you're done.
  • Read more about the SyncML integration.
  • Enjoy Simple Groupware!


Installation with Linux and PostgreSQL (Funambol v7/v8)

  • Funambol v7/v8 requires at least Simple Groupware 0.420
  • Download the package "PIM & E-Mail Bundle" for Linux from Funambol
    (latest version tested is 8.0.1, all files are here)
  • Install the setup package (e.g. funambol-8.0.1.bin)
  • Open your browser and go to http://localhost:8080/. You should now see a page with the title "The Funambol Data Synchronization Server".
  • Copy the file "<sgs-dir>\bin\tools\funambolv7_syncML\postgresql\postgresql-8.3-603.jdbc3.jar" to "<funambol-dir>/tools/" (or another location where your Funambol server was installed to).
  • Edit the file "<funambol-dir>/ds-server/install.properties" and replace:

dbms=hypersonic
...
jdbc.classpath=../tools/hypersonic/lib/hsqldb.jar
jdbc.driver=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://localhost/funambol
jdbc.user=sa
jdbc.password=

with:

dbms=postgresql

jdbc.classpath=../tools/postgresql-8.3-603.jdbc3.jar
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbc:postgresql://<host>/<database>
jdbc.user=<username>
jdbc.password=<password>

Make sure to replace <host>, <database>, <username> and <password> with your PostgreSQL credentials (same as those used in Simple Groupware).
  • Execute the file "<funambol-dir>/bin/install" and confirm the questions with "y"
  • Start the Funambol Data Synchronization Server from the terminal, and wait a bit:
    <funambol-dir>/bin/funambol start
  • Make sure that Simple Groupware is installed on the same machine
  • Open your browser and go to http://localhost/<sgs-dir>/bin/index.php.
  • Log in as super administrator
  • Navigate to "/Workspace/System" and choose "Change setup settings".
  • Click the checkbox "Enable Sync4j / Funambol"
  • Then click "Save" and you're done.
  • Read more about the SyncML integration.
  • Enjoy Simple Groupware!


Start Funambol automatically with Linux (v7/v8)

The Funambol Data Synchronization Service won’t start automatically when you start the host server. You can follow these steps to automate server startup on Linux:

  • Open a terminal with root privileges:

ln -s <FUNAMBOL_HOME>/bin/funambol /etc/init.d/funambol

e.g.
ln -s /opt/Funambol/bin/funambol /etc/init.d/funambol

  • Open the funambol script with a text editor and repalce the following line:

FUNAMBOL_HOME=`(cd .. ; pwd)`

with:
FUNAMBOL_HOME=`(cd <FUNAMBOL_HOME> ; pwd)`

e.g.
FUNAMBOL_HOME=`(cd /opt/Funambol ; pwd)`

This points the script to the absolute location of your Funambol installation.
  • Finally create a symbolic link to your rc3.d directory using this command:

ln -s /etc/init.d/funambol /etc/rc3.d/S30funambol

See this installation manual for older Funambol versions.