documentserver_community icon indicating copy to clipboard operation
documentserver_community copied to clipboard

Versioning not working with OnlyOffice documents

Open Disco1 opened this issue 5 years ago • 11 comments

Steps to reproduce

  1. Install OnlyOffice (Community Document Server)
  2. Install OnlyOffice connector and configure it
  3. Create document, put some stuff in there, let is save, then close via [X] at top-right
  4. Re-open. Edit it. Let is save.

Expected behaviour

A new version should appear when you right click and choose Details

Actual behaviour

No new version is created

Server configuration

Operating system: CentOS 7

Web server: Apache

Database: MySQL

PHP version: 7.3

Nextcloud version: (see Nextcloud admin page) NC18

Updated from an older Nextcloud/ownCloud or fresh install: Updated

Where did you install Nextcloud from: Nextcloud website

Signing status:

??? Signing status ???
Login as admin user into your Nextcloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results here.

This is the only thing I can see that might be relevant, but I don't think this is thrown when the issue occurs

```OCA\DocumentServer\Document\DocumentConversionException: Received signal 11 SEGV_MAPERR 00000000000f ==== C stack trace =============================== [0x7fbb2814b902] [0x7fbb2633f5f0] [0x7fbb27d2d298] [0x7fbb27b70ab1] [0x7fbb27b7db20] [0x7fbb27b85148] [0x7fbb27b85a36] [0x7fbb27b861b2] [0x7fbb27d61687] [0x7fbb27c0788d] [0x7fbb27d6968b] [0x7fbb279895e8] [0x7fbb2793f4ee] [0x7fbb279375c3] [0x000000649af0] [0x000000660cab] [0x000000668905] [0x00000066bc24] [0x00000046f15f] [0x7fbb25c82505] [0x0000006477ed] [end of stack trace]
</details>

**List of activated apps:**
<details>
<summary>App list</summary>
Accessibility	1.4.0	Featured	
Activities for shared file downloads	1.7.0		
Activity	2.11.0	Featured	
Brute-force settings	1.5.0	Featured	
Calendar	2.0.1	Featured	
Collaborative tags	1.8.0	Featured	
Comments	1.8.0	Featured	
Community Document Server	0.1.5		
Contacts	3.1.8	Featured	
Deleted files	1.8.0	Featured	
External storage support	1.9.0	Featured	
Extract	1.2.3		
Federation	1.8.0	Featured	
File access control	1.8.1	Featured	
File sharing	1.10.1	Featured	
First run wizard	2.7.0	Featured	
Log Reader	2.3.0	Featured	
Monitoring	1.8.0	Featured	
Nextcloud announcements	1.7.0	Featured	
Notes	3.1.5	Featured	
Notifications	2.6.0	Featured	
ONLYOFFICE	4.1.4	Featured	
Password policy	1.8.0	Featured	
Passwords	2020.2.1		
PDF viewer	1.7.0	Featured	
Photos	1.0.0	Featured	
Privacy	1.2.0	Featured	
RainLoop	6.1.0		
Recommendations	0.6.0	Featured	
Right click	0.15.2	Featured	
Share by mail	1.8.0	Featured	
Support	1.1.0	Featured	
Theming	1.9.0	Featured	
Two-Factor TOTP Provider	4.1.2	Featured	
Two-Factor U2F	5.0.2	Featured	
Update notification	1.8.0	Featured	
Usage survey	1.6.0	Featured	
Versions	1.11.0	Featured	
Video player	1.7.0	Featured	
Auditing / Logging	1.8.0	Featured	
Default encryption module	2.6.0	Featured	
Gallery	18.4.0		 
LDAP user and group backend	1.8.0	Featured	
Talk	8.0.4	Featured	 
Text	2.0.0	Featured

If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your Nextcloud installation folder

</details>

**Nextcloud configuration:**
<details>
<summary>Config report</summary>
{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "nextcloud.instanthousecall.com"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "18.0.1.3",
        "overwrite.cli.url": "https:\/\/nextcloud.instanthousecall.com",
        "overwriteprotocol": "https",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "tls",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "theme": "",
        "loglevel": 2,
        "updater.release.channel": "stable",
        "filelocking.enabled": true,
        "trashbin_retention_obligation": "auto, 30",
        "allowNightlyUpdates": []
    }
}

If you have access to your command line run e.g.: sudo -u www-data php occ config:list system from within your Nextcloud installation folder

or

Insert your config.php content here. Make sure to remove all sensitive content such as passwords. (e.g. database password, passwordsalt, secret, smtp password, …)

</details>

**Are you using external storage, if yes which one:** local/smb/sftp/...
S3, but the files in question are not stored on S3. They are stored on an NFS mount, specifically an EFS volume on AWS.

**Are you using encryption:** yes/no
SSL for the connection? Yes. At rest on disk? No.

**Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/...
No.

#### LDAP configuration (delete this part if not used)
<details>
<summary>LDAP config</summary>

With access to your command line run e.g.: sudo -u www-data php occ ldap:show-config from within your Nextcloud installation folder

Without access to your command line download the data/owncloud.db to your local computer or access your SQL server remotely and run the select query: SELECT * FROM oc_appconfig WHERE appid = 'user_ldap';

Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

</details>

### Client configuration
**Browser:**
Brave

**Operating system:**
Windows 10

### Logs
#### Web server error log
<details>
<summary>Web server error log</summary>

Insert your webserver log here

</details>

#### Nextcloud log (data/nextcloud.log)
<details>
<summary>Nextcloud log</summary>

Nothing of note. Only thing potentially of note pasted above

</details>

#### Browser log
<details>
<summary>Browser log</summary>

Insert your browser log here, this could for example include:

a) The javascript console log b) The network log c) ...

</details>

Disco1 avatar Feb 25 '20 21:02 Disco1

You can see modifications in OnlyOffice, but if you download the file from Nextcloud, these modifications are not present. It's like documents are updated in a Document Server cache, but there's an issue to sync this cache with Nextcloud File. Maybe an SSL issue / misconfiguration. I tried a : sudo -u www-data php /var/www/nextcloud/occ security:certificates:import /tmp/mycert.crt But without success.

And I think many issues are related to this problem.

jsuhm avatar Feb 26 '20 17:02 jsuhm

I guess it is the same issue then discussed already here #12 Does anyone know what can be done about it? Would it be a solution to use a non-integrated version of onlyoffice? This issue is really a big problem, as it leads to data loss in the end. Even with the cronjob workaround described in #12 we've seen issues that if one person works on a document, a second one is adding one sentence, the remaining version sometimes only contains the added sentences without all the rest and similar disasters...

tjareson avatar Feb 26 '20 19:02 tjareson

Especially the question if it works with the non-integrated version of onlyoffice (installing the server by myself) would be interesting.

EDIT: see https://github.com/nextcloud/documentserver_community/issues/12#issuecomment-592435586

q-wertz avatar Feb 28 '20 09:02 q-wertz

Especially the question if it works with the non-integrated version of onlyoffice (installing the server by myself) would be interesting.

EDIT: see #12 (comment)

I spun up a VM with a fresh install of NC 18.0.1, and OO docker based document server when I first encountered this problem. I think the problem is with the OO connector & versions, not the document server.

Darkknight33 avatar Mar 06 '20 01:03 Darkknight33

I can confirm that OO changes are not immediately visible in the Files app (and not synced to a client).

b-pfl avatar Mar 08 '20 00:03 b-pfl

Also confirmed and the Nextcloud files are not updated which leads them to not being synced either.

tk7936 avatar Mar 15 '20 04:03 tk7936

Same problem here with NextCloud 17.0.3 (snap install) on Ubuntu 18.04.4 LTS Onlyoffice 5.4.0 (snap install) document server on separate machine Ubuntu 18.04.4 LTS Nextcloud files are not updated which leads them to not being synced either.

Update: further testing show that:

  1. versioning is not working
  2. file sync is working for pptx and docx files
  3. file sync is not working for xlsx files

--- EDIT --- After hard work I did manage to get it work. My setup is:

  • Nextcloud 18.0.2 (manual install)
  • nginx/1.14.0 (Ubuntu)
  • Onlyoffice Document server docker (onlyoffice/documentserver: latest)

Certs by Let's Encrypt nginx configured as reverse proxy ssl in front of onlyoffice docker container

Sync working, versioning working with lazy update

Maybe this helps someone

lupant avatar Mar 15 '20 07:03 lupant

I have the same problem with a fresh install with Nextcloud VM (https://github.com/nextcloud/vm), 2 days ago.

I use: Ubuntu 18.04 Nextcloud 18.0.2 Community Document Server 0.1.5 OnlyOffice 5.4.2.46

webagil-kevin avatar Mar 17 '20 08:03 webagil-kevin

Same problem here. The version date always stays at the creation date even if the document is edited online. I use: Nextcloud 18.0.2 on a shared hosting - fresh install Community Document Server 0.1.5 ONLYOFFICE 4.1.4

Jolopu avatar Mar 17 '20 12:03 Jolopu

With my first installation Nextcloud 18.0.1 Community Document Server 0.1.5 ONLYOFFICE 4.1.4 it was possible to use the documentserver:flush With the update to Nextcloud 18.0.2 Community Document Server 0.1.5 ONLYOFFICE 4.1.4 that does not work anymore.

Bolli84 avatar Mar 22 '20 16:03 Bolli84

yeah they made it worse. Its unexplainable,they hyped Nextcloud 18 and now people are loosing data. The Problem has been known since January. Especially now with Covid allot of people are looking into Nextcloud for Home Office and turn to MS Teams from disappointment which wouldnt be the case if it werent for the data loss issues.

tk7936 avatar Mar 22 '20 22:03 tk7936