Hi,
Trying to install the Funambol-SOGo Connector v.1.0.8 (Ubuntu 10.4 /
MySQL 5.1 / Funambol 8.7)
When I run './bin/install-modules' I get the following errors:
[sql] Failed to execute: create table fnbl_email_cache (
guid varchar(200) binary not null, source_uri varchar(128) binary
not null, principal bigint not null, last_crc bigint,
invalid char, internal char, messageid varchar(700) binary,
headerdate varchar(20) binary, received varchar(20) binary,
subject varchar(700) binary, sender varchar(300) binary,
isemail char, constraint pk_cache primary key (guid, source_uri,
principal), constraint fk_principal_email_cache foreign key (principal)
references fnbl_principal (id) on delete cascade )ENGINE = InnoDB
CHARACTER SET utf8
BUILD FAILED
/opt/Funambol/ds-server/install/install.xml:238: The following error
occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:120: The following
error occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:168: The following
error occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:240: The following
error occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:285: The following
error occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:369:
java.sql.SQLException: Can't create table 'funambol.fnbl_email_cache'
(errno: 150)
FYI, here's the relevent settings in my
'/opt/Funambol/ds-server/install.properties' file:
dbms=mysql
## Added to enable MySQL
jdbc.classpath=/opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.13-bin.jar
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/funambol?characterEncoding=UTF-8
jdbc.user=funambol
jdbc.password=funambol
#
# Modules definitions
#
modules-to-install=content-provider-8.7.0,email-connector-8.7.0,foundation-8.7.0,phones-support-8.7.0,webdemo-8.7.0,funambol-sogo-1.0.8
The MySQL database 'funambol' exists and I have been able to create a
test table in the db using the above login/password.
MySQL is listening :
tcp 0 0 127.0.0.1:3306 0.0.0.0:*
LISTEN 15081/mysqld
Any suggestions?
Regards,
Ian Jones
--
[email protected]
https://inverse.ca/sogo/lists
