Sharepoint integration - modifications are not saved

Connectors
,
1

I’d like to report a bug
Document Server version: 6.4.1
Connector version: 2.0
OS: Windows Server 2012 R2
SharePoint 2019

Hello,

From my sharepoint site, I can open documents for modifications in onlyoffice, but the modifications are saved only if I open the documents with onlyoffice, if I open with MS Office I can’t see the modifications, and the date/time are not updated in sharepoint library.

So it seems that the document server can’t save back to sharepoint, and keep only temp files with modifications from user.

In the out.log I can only see some [WARN] nodeJS - storeForgotten: docId = …
error.log is empty

Thanks for your help

2

Hello infobc.

In the out.log I can only see some [WARN] nodeJS - storeForgotten: docId = …

These entries may mean Sharepoint accessibility issue. Please go to Document server and check this folder:

For Linux /var/lib/onlyoffice/documentserver/App_Data/cache/files/forgotten

Docker - same path inside the container

Windows - %ProgramFiles%\ONLYOFFICE\DocumentServer\server\App_Data\cache\files\forgotten

Does this folder contain modified files?

Also provide us with additional information about your installation:

  1. Document server installation type and guide which you used.
  2. How you perform integration with SharePoint. Point me to the guide which you used.
  3. Make a simple test. Edit any file via ONLYOFFICE > close the file > go to SharePoint and download the file locally. Does local copy contain changes made?
  4. Provide us with whole Document server logs folder.
3

Hello Alexandre

Yes there is modified files here

  1. Document server installation type and guide which you used.

Community edition on windows server 2012, I followed this guide : Installer ONLYOFFICE Docs sous Windows sur un serveur local - ONLYOFFICE

  1. How you perform integration with SharePoint. Point me to the guide which you used.

With this solution : GitHub - ONLYOFFICE/onlyoffice-sharepoint: The solution which enables the users to edit office documents from SharePoint using ONLYOFFICE Document Server, allows multiple users to collaborate in real time and to save back those changes to SharePoint

  1. Make a simple test. Edit any file via ONLYOFFICE > close the file > go to SharePoint and download the file locally. Does local copy contain changes made?

No the local copy doesn’t contain changes

4
  1. Provide us with whole Document server logs folder.

Link to a zip file of the directory %ProgramFiles%\ONLYOFFICE\DocumentServer\Log

https://we.tl/t-QgU8huMmY9

Thank you

5

Hello infobc.

Thank you for provided data.

We are trying to reproduce the issue on our side but without any result at the moment.

Please provide us with additional information:

  1. Is Document server installed on the same server as SharePoint?
  2. Does the issue reproduce with any file?
  3. Please make a test. Open a file for editing with open browser console:

  • Open browser console (for example, F12 in Chrome) → choose ‘Network’ tab in browser console → open file for editing → check if there are any error entries in console and send us a screenshot;

  • Choose ‘Console’ tab in browser console → open file for editing → check if there are any error entries in console and send us a screenshot.

Did you face any errors in web-interface while you were editing a file?

  1. Did you run all steps in this title when you performed the integration? https://github.com/ONLYOFFICE/onlyoffice-sharepoint#installing-sharepoint-onlyoffice-integration-solution

  2. Did you compile wsp file by yourself or did you load it from our site? If you compiled it, please try to use this one from our repository: https://github.com/ONLYOFFICE/onlyoffice-sharepoint/releases

  3. Is the issue reproducible for all users?

6

Hello,

  1. No, document server is installed on another (virtual) server
  2. Yes with any file it’s the same
  3. Yes there is some POST 403 errors, screenshots :
    img
    img1289×679 50.6 KB

No on Onlyoffice editing web-interface, there is no errors

  1. Yes I ran all the steps
  2. I use the one from your repository
  3. Yes for all users

So I guess it is this part the problem : “ONLYOFFICE Document Server must also be able to POST to SharePoint directly” ?

Thank you

7

Some other details,
My sharepoint server is accessible on https : // mydomainname /
My onlyoffice document server is on https : // mydomainname:XXXX /
→ with custom port https installation following the guide

8

So I guess it is this part the problem : “ONLYOFFICE Document Server must also be able to POST to SharePoint directly” ?

You are absolutely right. Document server should be able to send POST to SharePoint.

This is necessary for the mechanism for final file version saving back to the storage (SharePoint). We have information about it here in ‘How it works’ category: ONLYOFFICE Api Documentation - ONLYOFFICE SharePoint integration solution

We think that your issue is probably related to your DNS\network settings. Something interrupts POST from DS to SP, so DS cannot sent final version of file to storage.

9

I don’t know what could be wrong, here is my actual configuration

Server 1 - Windows server 2019 - DC, AD, DNS, SharePoint
Server 2 - Windows server 2012 - Virtual on Server 1’s virtualbox, OO, domain member, fixed IP with Server 1 as DNS

From Server 2 (or Server 1, or another computer)
I access to SharePoint with http // server1 /
I configure OO server with http // server2 : XXXX /
I can edit documents, but it’s the same situation about save

I don’t know how else I could allow Server 2 to POST to Server 1

Thanks

10

Do you have any proxy server or firewall in front of DS?

11

No I don’t

12

Do I understand right, that both servers use https? If so, are you using CA-signed or self-signed certs?

13

Yes, for my final configuration, accessible over internet, both server use https with a CA-signed cert, they are on the same domain name with a different port for DS.

My previous post where I mention http // server1, etc, was just a test to see if with local intranet access the problem was the same.

For firewalls, I have only the Windows server one, and the one on the router.

14

Please run a few tests:

  1. Go to your SharePoint server > open browser and go to your SharePoint portal (open portal via domain name and via localhost). Please reproduce the issue through using browser from server where SharePoint is installed.
  2. Could you please try to install Document server on the same server as SharePoint and check the result?
    NB! We recommend to prepare whole server backup before any server side actions.
15

Some progress, in “full localhost/intranet mode” without SSL, now it works, from multiple users and clients computers.

So issue is only when DS server tries to POST back and upload to SP over internet with domain name and SSL, maybe something to allow in SP server windows firewall or IIS?

I’d like to keep DS server away from SP server, if I could.

16

IIS logs

in localhost/non-ssl mode

2021-11-15 09:09:32 [local IP SharePoint] POST /_layouts/15/Onlyoffice/CallbackHandler.ashx data=xxxxxxxxx 80 - [local IP DS] Node.js/6.13 - 200 0 0 48

2021-11-15 09:09:34 [local IP SharePoint] POST /_layouts/15/WsaUpload.ashx - 80 0#.w|[DOMAIN-NAME\ACCOUNT-NAME] [local IP SharePoint] Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/95.0.4638.69+Safari/537.36+Edg/95.0.1020.53 http://_local-url-to-sharepoint/library/Forms/AllItems.aspx 403 0 0 18

So POST seems to work with code 200 / WsaUpload error 403
And document modification work well

over-internet/ssl mode

2021-11-16 10:35:26 [local IP SharePoint] POST /_layouts/15/Onlyoffice/CallbackHandler.ashx data=xxxxxxxxx 443 - [PUBLIC IP] Node.js/6.13 - 200 0 0 97

2021-11-16 10:35:34 [local IP SharePoint] POST /_layouts/15/WsaUpload.ashx - 443 0#.w|[DOMAIN-NAME\ACCOUNT-NAME] [PUBLIC IP] Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/95.0.4638.69+Safari/537.36 https://_public-domain-name/library/Forms/AllItems.aspx 403 0 0 25

So POST seems to work with code 200 / WsaUpload error 403
And document modification doesn’t work

I also activated FailedReqLogFiles and restarted my website in IIS but folder is empty

17

Hello infobc.

We have run a bunch of tests, but we cannot reproduce the situation. All tests passed. DS works correctly with SSL cert.

It looks like the issue is related to your installation only. Probably there’s some error in IIS or SharePoint settings. Please point me to how exactly you got SSL cert for DS?

18

I have the same SSL cert for SharePoint and DS, it’s a free one from freessl (issued by CertCloud RSA TLS CA), and here is my ds.conf to use it :

include includes/http-common.conf;

server {
  listen 0.0.0.0:[CUSTOM-PORT] ssl;
  listen [::]:[CUSTOM-PORT] ssl default_server;
  server_tokens off;
  root /usr/share/nginx/html;

  error_page 497 https://[DOMAIN-NAME]:[CUSTOM-PORT]$request_uri;

  ssl on;
  ssl_certificate C:\\[PATH]\\[DOMAIN-NAME].pem;
  ssl_certificate_key C:\\[PATH]\\[DOMAIN-NAME].key;

  ssl_verify_client off;

  ssl_ciphers "EECDH+AESGCM:EDH+AESGCM:AES256+EECDH:AES256+EDH";

  ssl_protocols  TLSv1 TLSv1.1 TLSv1.2;
  ssl_session_cache  builtin:1000  shared:SSL:10m;

  ssl_prefer_server_ciphers   on;

  add_header Strict-Transport-Security max-age=31536000;
  add_header X-Content-Type-Options nosniff;

  include includes/ds-*.conf;

}
19

If everything works inside your local network, but issues arise with requests from outside, there may be an issue on the side of your DNS\proxy settings. Could you please double check it please.

20

I will, but now I’m getting a new strange problem… I have a root sites collection under the domain name, with URL like https://domain_name/ and other sites collection under https://domain_name/sites/…

Today I can’t open onlyoffice on the root sites collection, I have a 302 code instead of 200 when loading editorPage.aspx, and then a _layouts/15/error.aspx

But in the other sites collections it is still working well ?!