[GroupDAV] GroupDAV connector 1.1.1818 installation problems

[Mathew McBride]

For those that are experiencing this problem while trying to install 1818,
it can be worked around by changing the database type in install.properties
to postgresql temporarily, while doing the initial install. You can then
switch it back if you want to clean install another funambol module - the
SQL for hypersonic, postgresql and even others is the same in the case of
the connector so you don't actually have to change backend databases.


On 3/4/07 8:54 PM, "Samuli Sepp=E4nen" <samuli.seppanen@tietoteema.fi> wrote:

> 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.
>=20
> bash> bin/install.sh tomcat50
>=20
> --- snip ---
>=20
> [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 propert=
y.
> [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)
>=20
> [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.
>=20
> [iterate] If you choose 'y' your existing data will be deleted.
>=20
> [iterate] Do you want to recreate the database?
> [iterate]       (y,n)
> y
>=20
> [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')
>=20
> 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:
>=20
> Total time: 15 seconds
>=20
> -----
>=20
> HSQLDB logs this during the error:
>=20
> /*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
>=20
> 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.
>=20
> JAVA_HOME has been set to point to the Funambol's builting JRE, as well
> as Debian's Sun-java JRE's home.
>=20
> HSQLDB is running (ps ax|grep hsqldb)
>=20
> 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
>=20
> The database name is also correct.
>=20
> -----
>=20
> These are the steps I've taken so far:
>=20
> * 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:
>=20
> server-uri=3D
> context-path=3D/funambol
> dbms=3Dhypersonic
>=20
> jdbc.classpath=3D../tools/hypersonic/lib/hsqldb.jar
> jdbc.driver=3Dorg.hsqldb.jdbcDriver
> jdbc.url=3Djdbc:hsqldb:hsql://localhost/funambol
> jdbc.user=3Dsa
> jdbc.password=3D
>=20
> modules-to-install=3Dfoundation-3.0.9,pdi-3.0.5,pimweb-3.0.8,funambol-db-3.=
0.7,f
> unambol-email-3.0.15,groupdav-1.1.1818
> modules-to-uninstall=3D
>=20
> * 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)
>=20
> This procedure _should_ produce the error message shown above.