[SOGo] Web UI base URL
Greetings, Is a setting for the base URL for the SOGo web interface. It might be possible to rewrite everything from the Apache config, but it would be nice to have the pages linking to the correct URLs. For now I'll just put a redirect for / to /SOGo. Simon -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Thursday, October 18 2012
Title: BTS activities for Thursday, October 18 2012 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Thursday, October 18 2012 idlast updatestatus (resolution)categorysummary 2048 2012-10-18 16:15:20 new (open) SOGo Native Outlook Compatibility Samba4 crash when changing permissions on Calender in Outlook 2010 2049 2012-10-18 16:34:20 new (open) SOGo Native Outlook Compatibility Cannot create item in shared Calendar from Outlook 2010 2044 2012-10-18 08:19:06 new (open) Backend Calendar event integrity problem with caldav 2047 2012-10-18 14:53:19 new (open) Backend Calendar Invites sent to Outlook 2042 2012-10-18 05:04:20 updated (open) i18n Wrong subject in invitation email for an event in Spanish (Spain) 2046 2012-10-18 12:38:37 updated (open) Packaging (RedHat) optimized debugging builds 2043 2012-10-18 07:56:14 new (open) Web Address Book show members of groups in address book 2045 2012-10-18 12:38:08 assigned (open) Packaging (Debian) optimized debugging builds 1999 2012-10-18 11:40:49 resolved (fixed) Backend Calendar sogod crashes on some (not all) PROPFIND requests to shared calendars; resulting in 502 proxy errors 1980 2012-10-18 10:42:38 resolved (fixed) SOPE incompatibilities with libobjc2 on amd64 2030 2012-10-18 09:17:42 resolved (fixed) SOPE SOPE libNGExtensions unconditionally links against libobjc -- with patch 1956 2012-10-18 11:59:09 resolved (fixed) Web Calendar empty attendee showing up when booking an appointment
[SOGo] Installation on Mobile Devices
Hi, I just installed Sogo...Zeg to test out the install..see if this groupware can do what we need we are a non-proft and we have a small mobile device management population.We use a solution called Mobileiron which reallly sucks. I would think if you centrally manage your mobile device infrastructure there would be a way to setup , Contacts for Emergency purposes and push them to the selected mobile devices. In other words, I need a way to have a Alerts Contacts pushed to iOS and Android devices. Is this possible through Sogo..if so I need some serious help. I thought this was just a matter of having a CardDav that everyone could access..but I cant seem to figure itout and am running into a brick wall as to how to setup a carddav. bottom line is that i need to setup up a way to have shared contacts in the event of an emergency. thanks for your help kat -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] samba4 error
When I setup the user u...@domain.tld I get the error: /usr/sbin/samba: Uncaught exception MAPIStoreIOException, reason: could not create special table 'socfs_usern...@domain.tld' If I just username it works, but that won't register with my mail server. Also is there a way to via the ldap directory of openchange/samba4? If so what is the default administrator dn and password? Thanks,-Eric -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
Hi all, i also installed the Activesync Sogo successful. Contact synchronization works fine with my HTC Desire Android phone, but when I try to add new appointments in the "Exchange" calendar I get double entries. Best regards, Sebastian Am 17.10.2012 12:45, schrieb Devinder Singh: Hi All, Just wanted to let you all know that Mobile Sync with Z-push Activsync was successful with the below php library. https://github.com/xbgmsharp/sogosync [1] 1. Android Based phones - Native Support for 2 way sync with Calendards, Tasks and Address Book 2. Apple IOS TAB and IPhone - Native Support for 2 way sync for Calendards and Tasks. One way sync with Address Book to Apple IOS. Need to figure out further on Carddav integration issue with Apple IOS. I would recommend SOGo team to do further Testing and recommend this method as well on the below url. http://www.sogo.nu/english/downloads/frontends.html [2] Did anyone try it on Blackberry or we can only sync through Funambol ? Looking forward to your reply. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
Hi Peter, My objective is to have all Mobile devices sync with SOGo. Z-push is a good replacement for Funambol due to its native compatibility with Andriod and Apple IOS with version 6. However, Z-push do not support Blackberry Devices and so we require Funambol. I am working on making it work for me :). But you can say it got Z-sync topic got hijacked by Funambol. By the way, Funambol setup is complete and looking forward to test with Blackberry tomorrow. Thanks & Regards, Devinder Singh Birdi On 10/18/2012 6:03 PM, Peter Schmidt wrote: I'm curious about the Z-Push Active Sync method and have 2 questions: * Is it necessary, when SOGo is configured for Outlook compatibility? (I guess so, because Exchange != Active Sync) * Why does it need Funambol? (Or are your questions about Funambol not related to Z-Push and you "hijacked" your own thread?) Best regards, Peter On 2012-10-18 13:39, Michal Kminek wrote: 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, invalidchar, internal char, messageid varchar(700) binary, headerdate varchar(20) binary, received varchar(20) binary, subjectvarchar(700) binary, sender varchar(300) binary, isemailchar, 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/
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
Hi Michael, I was able to resolve the issue. I ran the ./bin/install to reconfigure the Funambol setup and it created the tables properly this time along with the SOGO Connector. Thanks & Regards, Devinder Singh Birdi On 10/18/2012 4:50 PM, Devinder Singh wrote: 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, invalidchar, internal char, messageid varchar(700) binary, headerdate varchar(20) binary, received varchar(20) binary, subjectvarchar(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
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
On Thu, 2012-10-18 at 14:33 +0200, Peter Schmidt wrote: > I'm curious about the Z-Push Active Sync method and have 2 questions: > > * Is it necessary, when SOGo is configured for Outlook compatibility? (I > guess so, because Exchange != Active Sync) yes -- you're right -- exchange protocol is not the same as activesync protocol (what z-push is doing) > * Why does it need Funambol? (Or are your questions about Funambol not > related to Z-Push and you "hijacked" your own thread?) there are two principal use cases for Funambol - you want to sync from outlook to sogo/funambol and you are _not_ using the "outlook compatibility" sogo version - the mobile device doesn't support activesync, but does support syncML (Funambol's protocol) cheers m -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
I'm curious about the Z-Push Active Sync method and have 2 questions: * Is it necessary, when SOGo is configured for Outlook compatibility? (I guess so, because Exchange != Active Sync) * Why does it need Funambol? (Or are your questions about Funambol not related to Z-Push and you "hijacked" your own thread?) Best regards, Peter On 2012-10-18 13:39, Michal Kminek wrote: 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, invalidchar, internal char, messageid varchar(700) binary, headerdate varchar(20) binary, received varchar(20) binary, subjectvarchar(700) binary, sender varchar(300) binary, isemailchar, 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
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
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, invalidchar, internal char, messageid varchar(700) binary, headerdate varchar(20) binary, received varchar(20) binary, subjectvarchar(700) binary, sender varchar(300) binary, isemailchar, 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
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
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, isemailchar, 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
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
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
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
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 On 10/18/2012 2:46 PM, mayak-cq wrote: On Wed, 2012-10-17 at 16:15 +0530, Devinder Singh wrote: Hi All, Just wanted to let you all know that Mobile Sync with Z-push Activsync was successful with the below php library. https://github.com/xbgmsharp/sogosync 1. Android Based phones - Native Support for 2 way sync with Calendards, Tasks and Address Book 2. Apple IOS TAB and IPhone - Native Support for 2 way sync for Calendards and Tasks.One way sync with Address Book to Apple IOS. Need to figure out further on Carddav integration issue with Apple IOS. I would recommend SOGo team to do further Testing and recommend this method as well on the below url. http://www.sogo.nu/english/downloads/frontends.html Did anyone try it on Blackberry or we can only sync through Funambol ? Looking forward to your reply. -- Thanks & Regards, Devinder Singh Birdi hi devinder, thanks for your report :-) One way sync with Address Book to Apple IOS. i'm getting the same thing apple and contacts -- keeping my fingers crossed for a fix as for BB -- only funambol is working now -- i have not tried astrasync sync against z-push and sogo. when rim gets around to releasing their new phone, and if they remain in business, the new version will natively support actyivesync (exchange) for the first time. cheers m -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
On Thu, 2012-10-18 at 15:22 +0530, Devinder Singh wrote: > 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 ? hi devinder, yea -- setting up funambol with sogo is a pain ... my install.properties looks like this: # == # Funambol Data Synchronization Server # == # Installation properties # == server-uri= # The context path to use to access SyncServer context-path=/funambol dbms=mysql jdbc.classpath=/opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.22-bin.jar jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost/funambol jdbc.user=funambol jdbc.password=superSecretPassword # Modules definitions 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 and, you need to set the securityOfficer to sogo -- the config file should look likeL cat /opt/Funambol/config/ca/inverse/sogo/security/SOGoOfficer.xml SOGOSERVER_IP_ADDRESS SOGOSERVER_PORT and you need to link the mysql jat into the java directory: ln -s /opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.22-bin.jar /opt/Funambol/tools/jre-1.6.0/jre/lib/ext cheers m -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
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 On 10/18/2012 2:46 PM, mayak-cq wrote: On Wed, 2012-10-17 at 16:15 +0530, Devinder Singh wrote: Hi All, Just wanted to let you all know that Mobile Sync with Z-push Activsync was successful with the below php library. https://github.com/xbgmsharp/sogosync 1. Android Based phones - Native Support for 2 way sync with Calendards, Tasks and Address Book 2. Apple IOS TAB and IPhone - Native Support for 2 way sync for Calendards and Tasks.One way sync with Address Book to Apple IOS. Need to figure out further on Carddav integration issue with Apple IOS. I would recommend SOGo team to do further Testing and recommend this method as well on the below url. http://www.sogo.nu/english/downloads/frontends.html Did anyone try it on Blackberry or we can only sync through Funambol ? Looking forward to your reply. -- Thanks& Regards, Devinder Singh Birdi hi devinder, thanks for your report :-) One way sync with Address Book to Apple IOS. i'm getting the same thing apple and contacts -- keeping my fingers crossed for a fix as for BB -- only funambol is working now -- i have not tried astrasync sync against z-push and sogo. when rim gets around to releasing their new phone, and if they remain in business, the new version will natively support actyivesync (exchange) for the first time. cheers m -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
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 On 10/18/2012 2:46 PM, mayak-cq wrote: On Wed, 2012-10-17 at 16:15 +0530, Devinder Singh wrote: Hi All, Just wanted to let you all know that Mobile Sync with Z-push Activsync was successful with the below php library. https://github.com/xbgmsharp/sogosync 1. Android Based phones - Native Support for 2 way sync with Calendards, Tasks and Address Book 2. Apple IOS TAB and IPhone - Native Support for 2 way sync for Calendards and Tasks.One way sync with Address Book to Apple IOS. Need to figure out further on Carddav integration issue with Apple IOS. I would recommend SOGo team to do further Testing and recommend this method as well on the below url. http://www.sogo.nu/english/downloads/frontends.html Did anyone try it on Blackberry or we can only sync through Funambol ? Looking forward to your reply. -- Thanks & Regards, Devinder Singh Birdi hi devinder, thanks for your report :-) One way sync with Address Book to Apple IOS. i'm getting the same thing apple and contacts -- keeping my fingers crossed for a fix as for BB -- only funambol is working now -- i have not tried astrasync sync against z-push and sogo. when rim gets around to releasing their new phone, and if they remain in business, the new version will natively support actyivesync (exchange) for the first time. cheers m -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] "defaults write.." / "defaults -u sogo write.."overwriting complete .GNUstepDefaults
Francis > I've seen strange behaviours of "defaults" with recent versions of > GNUstep. Avoid using "-u "; you better run "defaults" as the > proper user. I'm sure Adam and co would love a bug report if someone can make it misbehave consistently... http://savannah.gnu.org/bugs/?group=gnustep Thanks, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
On Wed, 2012-10-17 at 16:15 +0530, Devinder Singh wrote: > Hi All, > > Just wanted to let you all know that Mobile Sync with Z-push Activsync > was successful with the below php library. > > https://github.com/xbgmsharp/sogosync > > 1. Android Based phones - Native Support for 2 way sync with > Calendards, Tasks and Address Book > 2. Apple IOS TAB and IPhone - Native Support for 2 way sync for > Calendards and Tasks.One way sync with Address Book to Apple IOS. > > Need to figure out further on Carddav integration issue with Apple > IOS. > > I would recommend SOGo team to do further Testing and recommend this > method as well on the below url. > http://www.sogo.nu/english/downloads/frontends.html > > Did anyone try it on Blackberry or we can only sync through > Funambol ? > > Looking forward to your reply. > > > -- > Thanks & Regards, > Devinder Singh Birdi hi devinder, thanks for your report :-) > One way sync with Address Book to Apple IOS. i'm getting the same thing apple and contacts -- keeping my fingers crossed for a fix as for BB -- only funambol is working now -- i have not tried astrasync sync against z-push and sogo. when rim gets around to releasing their new phone, and if they remain in business, the new version will natively support actyivesync (exchange) for the first time. cheers m -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo 2.0 ZEG strange timezone behavior
Hi, do you have correctly set your time zone in ZEG system and in SOGo? You can adjust the ZEG system time zone by running the following command (it's interractive): sudo dpkg-reconfigure tzdata the default password is "sogo" Modify the SOGo time zone too: sudo service sogo stop defaults write sogod SOGoTimeZone "Europe/Prague" sudo service sogo start Use your time zone name you have set in previous step. Just to share the experience, what Windows do you use and what MS Outlook version? Regards, Michal Dne 17.10.2012 12:56, Burkart Orlowski | Onlinehelp24 napsal(a): Almost the same for me. An all-day event is shown over 2 days in the web interface but is correctly displayed in Thunderbird. If I create an all-day event for the 16th Oct it is shown on the 16th and on the 17th Oct in the web interface. Any help is appreciated, Burkart Orlowski On 10/09/2012 03:13 PM, Michal Kminek wrote: I had problems with all-day events created by MS Outlook using the MS Exchange connection on my SOGo server. Therefore I decided to test it on the latest ZEG edition but the problem persist. I setup SOGo, system and Windows to use the same timezone in ZEG. I found a strange behavior - if the timezone is GMT or any other GMT +h zone then all all-day events created with MS Outlook (2007, 2010) go one day back in the web interface. For example if I create an all-day event to happen on 25th Oct in Outlook it is displayed as an all-day event on 24th Oct in SOGo. If I setup the time zone as any GMT -h zone everything works fine. Regards, Michal Kminek -- users@sogo.nu https://inverse.ca/sogo/lists