Thanks Michael,
Agree that was the issue. I was able to proceed further.
However, now Create Table fails the build.
[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_sogo.fnbl_email_cache' (errno: 150)
When googled for ErrNo 150 found that we cannot create Foreign Key on
Table columns not existing and I guess this is correct functionality by
Mysql.
Any idea how to resolve or which files we can correct these queries ?
Thanks & Regards,
Devinder Singh Birdi
On 10/18/2012 4:04 PM, Michal Kminek wrote:
Maybe you should update your config
jdbc.classpath=/opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.13-bin.jar
isn't the listed file
Dne 18.10.2012 12:28, Devinder Singh napsal(a):
Hi Michael,
Yes the file do exists.
ls -l /opt/Funambol/tools/tomcat/lib/ | grep mysql
-rw-rw-r-- 1 root root 832960 Sep 6 05:51
mysql-connector-java-5.1.22-bin.jar
Any other reasons ?
Thanks & Regards,
Devinder Singh Birdi
On 10/18/2012 3:37 PM, Michal Kminek wrote:
Have you installed any mysql driver in /opt/Funambol/tools/tomcat/lib/?
provide contents
ls -l /opt/Funambol/tools/tomcat/lib/
you should have something like mysql-connector-java-5.1.22-bin.jar
there.
Michal
Dne 18.10.2012 11:52, Devinder Singh napsal(a):
Thanks Mayak,
Just would like to add that Apple sync works as well on IOS 6
version. I tried syncing with IOS 4 version on TAB and IPhone it
did not work untill I upgraded to newer versions.
Not sure if you are also looking toward building the backward
compatibility.
However, I am facing issue while installing the Funambol with SOGo
connector. I am following guidelines as given in the installation
document.
But receiving below error
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:284: The
following error occurred while executing this line:
/opt/Funambol/ds-server/install/install-modules.xml:358: Class Not
Found: JDBC driver com.mysql.jdbc.Driver could not be loaded
Install Property settings
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_sogo?characterEncoding=UTF-8
jdbc.user=mail
jdbc.password=mail
modules-to-install=content-provider-10.0.0,email-connector-10.0.0,foundation-10.0.0,phones-support-10.0.0,webdemo-10.0.0,funambol-sogo-1.0.9
Kindly guide what could be reason ? Is their a Funambol Setup
with SOGo connector configured ?
Thanks & Regards,
Devinder Singh Birdi
--
users@sogo.nu
https://inverse.ca/sogo/lists