Can't edit in Confluence 8.6.2

[Thomas Reilly]

I recently upgraded my confluence version from 5.7 to 8.6.2. Since then I have been unable to edit any documents. 

I tried to do some progressive updates, move to 6.0 and 7.0 first, and those were fine. It seems that once collaborative editing came in the editing broke for my system. I can still create and delete pages, but there is no way to edit. 

I've tried disabling collaborative editing, to see if that would resolve it, but the issue remains. Also confirmed that the port wasn't being used by any other service. At this point, I'm out of ideas for why this is happening and am hoping somebody else might have some suggestions.

[Jonathan Smith]

Thomas,

  We ran into something similar after upgrading Confluence to 6.6.2. Our sys admin needed to modify the confluence.cfg.xml to include the following:

<property name="synchrony.encryption.disabled">true</property>
    <property name="synchrony.proxy.enabled">true</property>

Not saying this will resolve your sitatuion; you should check the logs to see what error message is throwing.

[Thomas Reilly]

Unfortunately that didn't do the trick.

As for the logs. The edit button isn't even visible within Confluence so I'm not sure it would even throw an error. I checked the synchrony log and this was the only thing that stood out:

2018-05-07 10:25:02,291 DEBUG [286:StdErrHandler [C:\Program Files\Atlassian\Confluence\jre\bin\java.exe]] Mon May 07 10:25:02 PDT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

[Nic Brough -Adaptavist-]

The log is clear in what you need to do on the surface, but useless in guiding you how to do it (I can't blame Atlassian for that, there are a lot of ways of doing SSL and it has nothing to do with their software)

First question is what is throwing the error you see.  Is it the database or the proxy server (if you have one)?

[Thomas Reilly]

This error is from the atlassian-synchrony.log file, so I would assume it's from the database.

I've taken over management of this from a departed colleague so I'm still familiarizing myself with how Confluence is setup.

[Nic Brough -Adaptavist-]

Ok, that suggests that while Confluence might be set up for an SSL connection to the database, Synchrony is not, so it's throwing errors. 

But, I think that's a red-herring, as you still have the problem when not using Synchrony.  I'd want to check the atlassian-confluence log to see what is going wrong on edits

[Thomas Reilly]

Thanks Nic. Nothing immediately pops up as a cause. I've added the log to OneDrive, hopefully you might see something.

Really appreciate the assistance, this has confounded me for a couple weeks.

https://panoramaresortbc-my.sharepoint.com/:u:/g/personal/thomas_reilly_panoramaresort_com/EWDIu8O_fQFIpodxxfwBPicBlybFarweBRwrWwZzN0xcag