by Opacus

Full CalDAV bi-directional sync for SugarCRM. Use your native calendar on your favorite device to synchronise calls, meetings and tasks. Works with Apple (iOS), Android, and Thunderbird/Lightning.

Free 30 day trial
Try it Now

#3306 - Unable to get working with Ent 7.9

Open Bug? created by Sugabyte 2 months 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

  1. sugabyte member avatar

    Sugabyte

    2 months ago

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

    'version' => '2.0.8',

    Thanks, SB

  2. Opacus member avatar

    Opacus Provider

    2 months ago

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

  3. sugabyte member avatar

    Sugabyte

    2 months 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

  4. sugabyte member avatar

    Sugabyte

    2 months 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.

    • Opacus member avatar

      Opacus Provider

      2 months 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.

  5. sugabyte member avatar

    Sugabyte

    2 months ago

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

  6. sugabyte member avatar

    Sugabyte

    2 months 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?

    • Opacus member avatar

      Opacus Provider

      2 months 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.

    • sugabyte member avatar

      Sugabyte

      2 months 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. sugabyte member avatar

    Sugabyte

    2 months 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

    • Opacus member avatar

      Opacus Provider

      2 months 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"]

    • sugabyte member avatar

      Sugabyte

      2 months 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

  8. Opacus member avatar

    Opacus Provider

    2 months ago

    Are you using standard LAMP? PHP-CGI?

    • sugabyte member avatar

      Sugabyte

      2 months ago

      Yes, all standard. Php V5.6.30. MySQL 5.7. Apache 2.4. Forced SSL.

    • sugabyte member avatar

      Sugabyte

      2 months ago

      Also tried in seperate environments. And Sugar On Demand.

  9. sugabyte member avatar

    Sugabyte

    2 months ago

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

    • sugabyte member avatar

      Sugabyte

      2 months ago

      Hi, have you managed to confirm installation works OK on a fresh OD system?

    • Opacus member avatar

      Opacus Provider

      2 months 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 ?

  10. sugabyte member avatar

    Sugabyte

    2 months 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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "Fantastic Product. The support from Opacus was amazing. Basically for the price I could not think of a single thing that should/could be improved."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.