[GroupDAV] GroupDAV connector 1.1.1818 installation problems

[Samuli Seppänen]

I'm having problems installing GroupDAV 1.1.1818 on latest Funambol
bundle. Here's the error message, but I'll post all the steps I went
through to the bottom of this message. Hope somebody has a clue of
what's happening.

bash> bin/install.sh tomcat50

--- snip ---

[echo] funambol-email-3.0.15 installation successfully completed
[echo] has.install: ${has.install}
[echo] groupdav-1.1.1818 installation...
[available] DEPRECATED - <available> used to override an existing property.
[available]   Build file should not reuse the same property name for
different values.
[echo] Database installation for module groupdav-1.1.1818 on hypersonic
(/opt/Funambol/ds-server)

[iterate] The Funambol Data Synchronization Server installation program
can now create
[iterate] the database required by the module groupdav-1.1.1818 (if any
is needed).
[iterate] You can skip this step if you have already a valid database
created
[iterate] or the module does not require a database.

[iterate] If you choose 'y' your existing data will be deleted.

[iterate] Do you want to recreate the database?
[iterate]       (y,n)
y

[sql] Failed to execute:  insert into
fnbl_sync_source_type(id,description, class, admin_class) values
('groupdavContacts','GroupDAV Contacts',
'net.bionicmessage.funambol.source.filteredAddrGroupDAVConnector',
'net.bionicmessage.funambol.admin.filteredAddrSourceAdminPanel')

BUILD FAILED
/opt/Funambol/ds-server/install/install.xml:278: The following error
occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:93: The following
error occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:159: The following
error occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:199: The following
error occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:245: The following
error occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:289:
java.sql.SQLException: Unique constraint violation:

Total time: 15 seconds

-----

HSQLDB logs this during the error:

/*C36*/CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO FNBL_SYNC_SOURCE_TYPE VALUES('groupdavvCal','GroupDAV
Calendar','net.bionicmessage.funambol.source.vCalGroupDAVConnector
','net.bionicmessage.funambol.admin.vCalSourceAdminPanel')
INSERT INTO FNBL_SYNC_SOURCE_TYPE VALUES('groupdavTasks','GroupDAV
Tasks','net.bionicmessage.funambol.source.taskGroupDAVConnector',
'net.bionicmessage.funambol.admin.taskSourceAdminPanel')
INSERT INTO FNBL_SYNC_SOURCE_TYPE VALUES('groupdavContacts','GroupDAV
Contacts','net.bionicmessage.funambol.source.addrGroupDAVConne
ctor','net.bionicmessage.funambol.admin.addrSourceAdminPanel')
DISCONNECT
ROLLBACK

Line 278 in install.xml seems to point to problem with ant, but I've
tried setting ANT_HOME to /usr/share/ant as well as the ant bundled with
Funambol. Neither works.

JAVA_HOME has been set to point to the Funambol's builting JRE, as well
as Debian's Sun-java JRE's home.

HSQLDB is running (ps ax|grep hsqldb)

12734 pts/6    Sl     0:01 /opt/Funambol/tools/jre-1.5.0/jre/bin/java
org.hsqldb.Server -database.0
/opt/Funambol/tools/hypersonic/data/funambol -dbname.0 funambol

The database name is also correct.

-----

These are the steps I've taken so far:

* Unzipped jgroupdav-for-1818.zip and copied the contents of the
directory jgroupdav/gdav_libs to $FUNAMBOL_HOME/tools/tomcat/server/lib
* Copied JGroupDAV.jar to the same place
* Copied groupdav-1.1.1818.s4j to $FUNAMBOL_HOME/ds-server/modules/
* Changed the owner and permissions of the copied files to 500:500 and
rw-rw-r-- (they were broken by default)
* Edited the $FUNAMBOL_HOME/ds-server/install.properties:

server-uri=
context-path=/funambol
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=

modules-to-install=foundation-3.0.9,pdi-3.0.5,pimweb-3.0.8,funambol-db-3.0.7,funambol-email-3.0.15,groupdav-1.1.1818
modules-to-uninstall=

* Launched Funambol: $FUNAMBOL_HOME/tools/bin/
* Changed the directory $FUNAMBOL_HOME/ds-server
* Tried installing the modules with bin/install.sh tomcat50 (and
bin/install-modules.sh tomcat50)

This procedure _should_ produce the error message shown above.