installing Funambol on ubuntu 9.10 x86_64 using MySQL as a backend

NOTE: this posting is still very incomplete!!

make sure the 32-bit variants of Java and the corresponding MySQL-connector are installed:

sudo aptitude install ia32-sun-java6-bin libmysql-java

then, adjust the install.properties to use MySQL:

—- ds-server/install.properties.orig	2010-02-13 16:54:13.000000000 +0100

+++ ds-server/install.properties	2010-02-13 16:44:22.000000000 +0100

 -21,7 +21,8 
 #   – postgresql
 #   – mysql
 #

-dbms=hypersonic

+#orig# dbms=hypersonic

+dbms=mysql


 #
 # JDBC settings:
 -58,13 +59,20 
 # jdbc.user=funambol
 # jdbc.password=funambol
 #
+jdbc.classpath=/usr/share/java/mysql-connector-java.jar
+jdbc.driver=com.mysql.jdbc.Driver
+jdbc.url=jdbc:mysql://localhost/funambol?characterEncoding=UTF-8
+jdbc.user=funambol
+jdbc.password=funambol
+#
 #

	
-jdbc.classpath=../tools/hypersonic/lib/hsqldb.jar

-jdbc.driver=org.hsqldb.jdbcDriver

-jdbc.url=jdbc:hsqldb:hsql://localhost/funambol

-jdbc.user=sa

-jdbc.password=

+#orig# jdbc.classpath=../tools/hypersonic/lib/hsqldb.jar

+#orig# jdbc.driver=org.hsqldb.jdbcDriver

+#orig# jdbc.url=jdbc:hsqldb:hsql://localhost/funambol

+#orig# jdbc.user=sa

+#orig# jdbc.password=

 #
 # Modules definitions

next, disable (or delete if you like) the included Java and hypersonic-DBMS:

mv -v tools/jre-1.5.0 tools/jre-1.5.0.disabled
mv -v tools/hypersonic tools/hypersonic.disabled

export JAVA_HOME=/usr/lib/jvm/ia32-java-6-sun/jre
export JRE_HOME=$JAVA_HOME