Activities Sync - Meetings, Task and Calls

The Opacus Activities Sync allows for a full bi-directional synchronisation between SugarCRM and your native calendar on your favorite device to synchronise calls, meetings and tasks. Works with Apple (iOS), Android, Outlook and Thunderbird/Lightning.

Free Trial

By clicking you consent to share your profile with the developer

#3306 - Unable to get working with Ent 7.9

Closed Bug? created by Sugabyte 6 years ago

Hi, despite claiming this works with Ent 7.9, we have been completely unable to install.

____**Here are some comments from our customer: We performed a fresh install rule out the possibility that our custom code could interfere with the module, then started dissecting the code and found that it was failing because it could not load this file: include/parsecsv.lib.php

However, this file lives only on community edition. Anyway copying this file from a community edition at least got us a login prompt but still no meetings synchronising which suggest that there might be some other dependencies from community edition, however, I did not have enough time to dissect further.

As a quick test I tried installing this on latest suitecrm which is sugarcrmCE and all worked like a charm.

I really cant understand how they can claim that it works on sugar 7.9

My only explanation would be someone had a CE then upgraded to sugar commercial version. (As i know from my experience during upgrades sugar leaves unnecessary files behind rather than clean them up) so they had a commercial sugar with some leftover lib files from CE that opacus requires and this way it worked.__ __**

Have you tested this module with a fresh 7.9 Enterprise system?

Thanks, Sugabyte

Sugabyte
6 years ago

Hi, I forgot to add the version of Opacus we are testing with:

'version' => '2.0.8',

Thanks, SB

reply
Opacus Provider
6 years ago

Please try version 2.0.9 (the latest zip file, uploaded today)

reply
Sugabyte
6 years ago

Thanks, just installed this and reconfigured Thunderbird.

Getting the exact same error in Thunderbird: [calCachedCalendar] replay action failed: null, uri=https://system-url/sas.php/calendars/admin/default, result=2147500037, operation=[xpconnect wrapped calIOperation]

Any ideas?

Thanks, SB

reply
Sugabyte
6 years ago

In addition to my last message, the module was tested in Suite CRM on the same server config, and worked fine. Just cant get it to work with Enterprise 7.9.

reply
- Opacus Provider
  6 years ago
  
  Hi, the error must be different as we've removed the require_once statement.
  
  I believe the compatibility update was automatic but we'll remove support for 7.9 until we've resolved the issue.
  
  reply
Sugabyte
6 years ago

OK. We are now testing 7.8.2.1 - has this been confirmed as working OK? Thanks, SB

reply
Sugabyte
6 years ago

Hi, as an update, we have installed this on a fresh 7.8.2.1 ENT.

This time, we are able to access a username/password window in Thunderbird. However, it wont accept the credentials. (tried with two seperate users).

These are the two errors in Thunderbird: [calCachedCalendar] replay action failed: null, uri=https://caldav.server.com/sas.php/calendars/james/default, result=2147500037, operation=[xpconnect wrapped calIOperation] calCachedCalendar.js:330:29 PROPFIND https://caldav.server.com/sas.php/calendars/james/default/ [HTTP/1.1 401 Unauthorized 720ms] NS_ERROR_FAILURE: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [nsIInterfaceRequestor.getInterface] network-monitor.js:299

One thing I have noticed is that after running a quick repair in Sugar, it suggests some code to execute. However, after executing, its displayed again in the next repair summary. Every time. We've tried several systems, too. The code it asks to execute is:

/COLUMNS/ /MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' */ / VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' / ALTER TABLE principals modify COLUMN id integer NOT NULL auto_increment; /COLUMNS/ /MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' / / VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' / /MISMATCH WITH DATABASE - ctag - ROW [name] => 'ctag' [type] => 'int' [len] => '11' / / VARDEF - ctag - ROW[name] => 'ctag' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' / /MISMATCH WITH DATABASE - calendarorder - ROW [name] => 'calendarorder' [type] => 'int' [len] => '11' / / VARDEF - calendarorder - ROW[name] => 'calendarorder' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' / ALTER TABLE calendars modify COLUMN id integer NOT NULL auto_increment, modify COLUMN ctag integer NULL , modify COLUMN calendarorder integer NULL ; /COLUMNS/ /MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' / / VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' / /MISMATCH WITH DATABASE - calendarid - ROW [name] => 'calendarid' [type] => 'int' [len] => '11' / / VARDEF - calendarid - ROW[name] => 'calendarid' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' / /MISMATCH WITH DATABASE - lastmodified - ROW [name] => 'lastmodified' [type] => 'int' [len] => '11' / / VARDEF - lastmodified - ROW[name] => 'lastmodified' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' / ALTER TABLE calendarobjects modify COLUMN id integer NOT NULL auto_increment, modify COLUMN calendarid integer NULL , modify COLUMN lastmodified integer NULL ; /COLUMNS/ /MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' / / VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' / /MISMATCH WITH DATABASE - principal_id - ROW [name] => 'principal_id' [type] => 'int' [len] => '11' / / VARDEF - principal_id - ROW[name] => 'principal_id' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' / /MISMATCH WITH DATABASE - member_id - ROW [name] => 'member_id' [type] => 'int' [len] => '11' / / VARDEF - member_id - ROW[name] => 'member_id' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' / ALTER TABLE groupmembers modify COLUMN id integer NOT NULL auto_increment, modify COLUMN principal_id integer NULL , modify COLUMN member_id integer NULL ; /COLUMNS/ /MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' / / VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' / /MISMATCH WITH DATABASE - timeout - ROW [name] => 'timeout' [type] => 'int' [len] => '11' / / VARDEF - timeout - ROW[name] => 'timeout' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' / /MISMATCH WITH DATABASE - created - ROW [name] => 'created' [type] => 'int' [len] => '11' / / VARDEF - created - ROW[name] => 'created' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' / /MISMATCH WITH DATABASE - scope - ROW [name] => 'scope' [type] => 'int' [len] => '11' / / VARDEF - scope - ROW[name] => 'scope' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' / /MISMATCH WITH DATABASE - depth - ROW [name] => 'depth' [type] => 'int' [len] => '11' / / VARDEF - depth - ROW[name] => 'depth' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' */ ALTER TABLE locks modify COLUMN id integer NOT NULL auto_increment, modify COLUMN timeout integer NULL , modify COLUMN created integer NULL , modify COLUMN scope integer NULL , modify COLUMN depth integer NULL ;

Any ideas?

reply
- Opacus Provider
  6 years ago
  
  I'd double check you're using the calendar publish key rather than the Sugar password, and that your username is entered in the same case as it is stored in Sugar.
  
  As regards the SQL queries, that's a known issue but does not cause any other problems other than appearing in the R&R SQL editor.
  
  reply
- Sugabyte
  6 years ago
  
  Confirmed using the correct username and calendar key. (Sugar username case sensitive, and PW is the calendar publish key in Users > Advanced).
  
  Still not working.
  
  reply
Sugabyte
6 years ago

Hi Opacus, what else can we do to troubleshoot this and get it working with 7.8/7.9?
We do need this working asap. Are there any server dependencies that we have missing?

Thanks, SB

reply
- Opacus Provider
  6 years ago
  
  Just tested on fresh 7.9.2.0 without issue. PHP libraries installed: ["php5-mysql", "php5-imap", "php5-gd", "php5-curl", "php5-common", "php5-intl", "php5-mcrypt", "php5-xsl", "php5-ldap"]
  
  reply
- Sugabyte
  6 years ago
  
  Ive checked and we have all of these.
  
  What else can we check? We're able to connect to Sugar through Thunderbird, but it doesnt accept any credentials for the Sugar username or calendar key. Just keeps asking for the creds.
  
  Thanks, SB
  
  reply
Opacus Provider
6 years ago

Are you using standard LAMP? PHP-CGI?

reply
- Sugabyte
  6 years ago
  
  Yes, all standard. Php V5.6.30. MySQL 5.7. Apache 2.4. Forced SSL.
  
  reply
- Sugabyte
  6 years ago
  
  Also tried in seperate environments. And Sugar On Demand.
  
  reply
Sugabyte
6 years ago

Can you try this on an on-demand instance? Because it's clearly not working from our end.

reply
- Sugabyte
  6 years ago
  
  Hi, have you managed to confirm installation works OK on a fresh OD system?
  
  reply
- Opacus Provider
  6 years ago
  
  Unfortunately we do not have an on-demand instance with Sugar. Would it be possible for you to create a login on an on-demand instance and email the details to support@opacus.co.uk ?
  
  reply
Sugabyte
6 years ago

Thanks for getting back to me. Let's keep this ticket open while you test. I will email the details of the On Demand system to you tomorrow referencing this case in the subject.

Kind regards, SB

reply