When this error occurs? During Funambol start? I would recommend reviewing SOGo Installation Guide - Funambol chapter. Make sure you have followed every step including install-modules command. Funambol is a big package, very self-sufficient as it includes its own Java RE. Check also file rights.

Michal

Dne 18.10.2012 13:20, Devinder Singh napsal(a):
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

Reply via email to