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.
#3306 - Unable to get working with Ent 7.9
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
-
"The program was working great for about 2 months and then it quit working. We have attempted to contact them numerous times and no one is responding. ..." - senia
Read More Reviews
- Most Recent Love from Users
Juan Antonio Longas- jobvector GmbH
- johanbrady
7 years ago
Hi, I forgot to add the version of Opacus we are testing with:
'version' => '2.0.8',
Thanks, SB
7 years ago
Please try version 2.0.9 (the latest zip file, uploaded today)
7 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
7 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.
7 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.
7 years ago
OK. We are now testing 7.8.2.1 - has this been confirmed as working OK? Thanks, SB
7 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?
7 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.
7 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.
7 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
7 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"]
7 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
7 years ago
Are you using standard LAMP? PHP-CGI?
7 years ago
Yes, all standard. Php V5.6.30. MySQL 5.7. Apache 2.4. Forced SSL.
7 years ago
Also tried in seperate environments. And Sugar On Demand.
7 years ago
Can you try this on an on-demand instance? Because it's clearly not working from our end.
7 years ago
Hi, have you managed to confirm installation works OK on a fresh OD system?
7 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 ?
7 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