Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cannot open documents (An error has occurred while opening the file) #146

Closed
smirkybg opened this issue Sep 28, 2019 · 8 comments
Closed

Cannot open documents (An error has occurred while opening the file) #146

smirkybg opened this issue Sep 28, 2019 · 8 comments
Labels
installation question Further information is requested

Comments

@smirkybg
Copy link

Hello!

Since a few months I can't open any document with onlyoffice-nextcloud.
I've been getting this error from the screenshot.

image

The setup is:
OS - Arch Linux
onlyoffice-documentserver - 5.4.0 (https://aur.archlinux.org/cgit/aur.git/tree/PKGBUILD?h=onlyoffice-documentserver)
Reverse Proxy: nginx (with its own subdomain and https://)
NC App: 3.0.0
Nextcloud: 16.0.5
redis: 5.0.6
rabbitmq: 3.7.17

Nextcloud, NGINX and onlyoffice are all on the same host.

I tried permission granting on "/var/lib/onlyoffice/documentserver" and all of its folders/files, but it doesn't seem to help.
Healthcheck seems fine:

$ curl https://onlyoffice.DOMAIN.TLD/healthcheck/
true

The services are working fine:

systemctl status onlyoffice-docservice.service onlyoffice-spellchecker.service onlyoffice-fileconverter.service                                                                                                 INT ↵ | root@archy 
● onlyoffice-docservice.service - Onlyoffice documentserver
   Loaded: loaded (/usr/lib/systemd/system/onlyoffice-docservice.service; enabled; vendor preset: disabled)
   Active: active (running) since Sat 2019-09-28 20:13:34 EEST; 1h 17min ago
 Main PID: 560739 (node)
    Tasks: 22
   Memory: 109.8M
   CGroup: /system.slice/onlyoffice-docservice.service
           ├─560739 /usr/bin/node /usr/share/webapps/onlyoffice/documentserver/server/DocService/sources/server.js
           └─560750 /usr/bin/node /usr/share/webapps/onlyoffice/documentserver/server/DocService/sources/server.js

сеп 28 20:13:34 archy systemd[1]: Started Onlyoffice documentserver.
сеп 28 20:13:34 archy node[560739]: [2019-09-28T20:13:34.284] [WARN] nodeJS - Plugins watch exception (https://nodejs.org/docs/latest/api/fs.html#fs_availability).
сеп 28 20:13:34 archy node[560739]: [2019-09-28T20:13:34.291] [WARN] nodeJS - update cluster with 1 workers
сеп 28 20:13:34 archy node[560739]: [2019-09-28T20:13:34.295] [WARN] nodeJS - worker 560750 started.
сеп 28 20:13:34 archy node[560739]: [2019-09-28T20:13:34.295] [WARN] nodeJS - update cluster with 1 workers
сеп 28 20:13:34 archy node[560739]: [2019-09-28T20:13:34.525] [WARN] nodeJS - Express server starting...
сеп 28 20:13:34 archy node[560739]: [2019-09-28T20:13:34.762] [WARN] nodeJS - Express server listening on port 8001 in production-linux mode

● onlyoffice-spellchecker.service - Onlyoffice documentserver
   Loaded: loaded (/usr/lib/systemd/system/onlyoffice-spellchecker.service; enabled; vendor preset: disabled)
   Active: active (running) since Sat 2019-09-28 20:13:05 EEST; 1h 17min ago
 Main PID: 560611 (node)
    Tasks: 18
   Memory: 55.7M
   CGroup: /system.slice/onlyoffice-spellchecker.service
           ├─560611 /usr/bin/node /usr/share/webapps/onlyoffice/documentserver/server/SpellChecker/sources/server.js
           └─560625 /usr/bin/node /usr/share/webapps/onlyoffice/documentserver/server/SpellChecker/sources/server.js

сеп 28 20:13:05 archy systemd[1]: Started Onlyoffice documentserver.
сеп 28 20:13:05 archy node[560611]: [2019-09-28T20:13:05.877] [WARN] nodeJS - start cluster with 1 workers
сеп 28 20:13:05 archy node[560611]: [2019-09-28T20:13:05.882] [WARN] nodeJS - worker 560625 started.
сеп 28 20:13:06 archy node[560611]: [2019-09-28T20:13:06.218] [WARN] nodeJS - Express server starting...
сеп 28 20:13:06 archy node[560611]: [2019-09-28T20:13:06.243] [WARN] nodeJS - Express server listening on port 8080 in production-linux mode

● onlyoffice-fileconverter.service - Onlyoffice documentserver
   Loaded: loaded (/usr/lib/systemd/system/onlyoffice-fileconverter.service; enabled; vendor preset: disabled)
   Active: active (running) since Sat 2019-09-28 20:13:05 EEST; 1h 17min ago
 Main PID: 560612 (node)
    Tasks: 22
   Memory: 84.0M
   CGroup: /system.slice/onlyoffice-fileconverter.service
           ├─560612 /usr/bin/node /usr/share/webapps/onlyoffice/documentserver/server/FileConverter/sources/convertermaster.js
           └─560636 /usr/bin/node /usr/share/webapps/onlyoffice/documentserver/server/FileConverter/sources/convertermaster.js

сеп 28 20:13:05 archy systemd[1]: Started Onlyoffice documentserver.
сеп 28 20:13:06 archy node[560612]: [2019-09-28T20:13:06.052] [WARN] nodeJS - update cluster with 1 workers
сеп 28 20:13:06 archy node[560612]: [2019-09-28T20:13:06.057] [WARN] nodeJS - worker 560636 started.
сеп 28 20:13:06 archy node[560612]: [2019-09-28T20:13:06.057] [WARN] nodeJS - update cluster with 1 workers

Output from all the logs I can think of, after reproducing the issue:

# tail -f /var/log/nginx/onlyoffice_*log /var/log/nginx/nextcloud.log /var/log/nginx/cloud-*log -n0
==> /var/log/nginx/onlyoffice_access.log <==

==> /var/log/nginx/onlyoffice_error.log <==

==> /var/log/nginx/nextcloud.log <==

==> /var/log/nginx/cloud-access.log <==

==> /var/log/nginx/cloud-error.log <==

==> /var/log/nginx/nextcloud.log <==
{"reqId":"HAh6PdTVAjqXMgYT7cLA","level":0,"time":"2019-09-28T18:15:29+00:00","remoteAddr":"192.168.1.1","user":"smirky","app":"onlyoffice","method":"GET","url":"\/index.php\/apps\/onlyoffice\/425?filePath=%2Fdumps%2Ftest_doc.odt","message":"Open: 425 \/dumps\/test_doc.odt","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/77.0.3865.90 Safari\/537.36","version":"16.0.5.1"}

==> /var/log/nginx/cloud-access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:29 +0300] "GET /index.php/apps/onlyoffice/425?filePath=%2Fdumps%2Ftest_doc.odt HTTP/2.0" 200 28559 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:29 +0300] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/2.0" 200 74 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"

==> /var/log/nginx/nextcloud.log <==
{"reqId":"uukdiU2SwQh8Jh5bstpK","level":0,"time":"2019-09-28T18:15:29+00:00","remoteAddr":"192.168.1.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Run OC\\Command\\CommandJob job with ID 3191","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/77.0.3865.90 Safari\/537.36","version":"16.0.5.1"}
{"reqId":"uukdiU2SwQh8Jh5bstpK","level":0,"time":"2019-09-28T18:15:29+00:00","remoteAddr":"192.168.1.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Finished OC\\Command\\CommandJob job with ID 3191 in 0 seconds","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/77.0.3865.90 Safari\/537.36","version":"16.0.5.1"}

==> /var/log/nginx/cloud-access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:29 +0300] "GET /cron.php HTTP/2.0" 200 20 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"

==> /var/log/nginx/nextcloud.log <==
{"reqId":"t331FIWZpLvU8Jikrsh7","level":0,"time":"2019-09-28T18:15:29+00:00","remoteAddr":"192.168.1.1","user":"smirky","app":"onlyoffice","method":"GET","url":"\/index.php\/apps\/onlyoffice\/ajax\/config\/425?filePath=%2Fdumps%2Ftest_doc.odt","message":"Config is generated for: 425 with key ocm3hqz4zgva_425_1449572126","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/77.0.3865.90 Safari\/537.36","version":"16.0.5.1"}

==> /var/log/nginx/cloud-access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:29 +0300] "GET /index.php/apps/onlyoffice/ajax/config/425?filePath=%2Fdumps%2Ftest_doc.odt HTTP/2.0" 200 2377 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"

==> /var/log/nginx/onlyoffice_access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:29 +0300] "GET /doc/1180996202/c/info?t=1569694529986 HTTP/2.0" 200 79 "https://onlyoffice.DOMAIN.TLD/web-apps/apps/documenteditor/main/index.html?_dc=0&lang=en&customer=ONLYOFFICE&frameEditorId=iframeEditor" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"

==> /var/log/nginx/nextcloud.log <==
{"reqId":"io84g3GWLlEuiX1vqoNg","level":0,"time":"2019-09-28T18:15:30+00:00","remoteAddr":"192.168.1.1","user":"--","app":"onlyoffice","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJmaWxlSWQiOjQyNSwib3duZXJJZCI6InNtaXJreSIsInRva2VuIjpudWxsLCJhY3Rpb24iOiJ0cmFjayJ9.-LfBggWeffIy1QDPnb-wYg09ETChnutP1SY7ZMP5SVM","message":"Track: 425 status 1","userAgent":"--","version":"16.0.5.1"}
{"reqId":"io84g3GWLlEuiX1vqoNg","level":0,"time":"2019-09-28T18:15:30+00:00","remoteAddr":"192.168.1.1","user":"--","app":"onlyoffice","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJmaWxlSWQiOjQyNSwib3duZXJJZCI6InNtaXJreSIsInRva2VuIjpudWxsLCJhY3Rpb24iOiJ0cmFjayJ9.-LfBggWeffIy1QDPnb-wYg09ETChnutP1SY7ZMP5SVM","message":"Track: 425 status 1 result 0","userAgent":"--","version":"16.0.5.1"}

==> /var/log/nginx/cloud-access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:30 +0300] "POST /index.php/apps/onlyoffice/track?doc=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJmaWxlSWQiOjQyNSwib3duZXJJZCI6InNtaXJreSIsInRva2VuIjpudWxsLCJhY3Rpb24iOiJ0cmFjayJ9.-LfBggWeffIy1QDPnb-wYg09ETChnutP1SY7ZMP5SVM HTTP/1.1" 200 11 "-" "-"

==> /var/log/nginx/onlyoffice_access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:30 +0300] "GET /spellchecker/doc/1180996202/c/info?t=1569694530438 HTTP/2.0" 404 173 "https://onlyoffice.DOMAIN.TLD/web-apps/apps/documenteditor/main/index.html?_dc=0&lang=en&customer=ONLYOFFICE&frameEditorId=iframeEditor" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:30 +0300] "GET /spellchecker/doc/1180996202/c/info?t=1569694530948 HTTP/2.0" 404 173 "https://onlyoffice.DOMAIN.TLD/web-apps/apps/documenteditor/main/index.html?_dc=0&lang=en&customer=ONLYOFFICE&frameEditorId=iframeEditor" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"

==> /var/log/nginx/cloud-access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /index.php/apps/files/?dir=/dumps&scrollto=test_doc.odt HTTP/2.0" 200 48081 "https://onlyoffice.DOMAIN.TLD/web-apps/apps/documenteditor/main/index.html?_dc=0&lang=en&customer=ONLYOFFICE&frameEditorId=iframeEditor" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"

==> /var/log/nginx/onlyoffice_access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /doc/1180996202/c/146/f1q0eujm/websocket HTTP/1.1" 101 1338 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"

==> /var/log/nginx/nextcloud.log <==
{"reqId":"KQIbTv1WbmnK60N5Seeq","level":0,"time":"2019-09-28T18:15:31+00:00","remoteAddr":"192.168.1.1","user":"--","app":"onlyoffice","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJmaWxlSWQiOjQyNSwib3duZXJJZCI6InNtaXJreSIsInRva2VuIjpudWxsLCJhY3Rpb24iOiJ0cmFjayJ9.-LfBggWeffIy1QDPnb-wYg09ETChnutP1SY7ZMP5SVM","message":"Track: 425 status 4","userAgent":"--","version":"16.0.5.1"}
{"reqId":"KQIbTv1WbmnK60N5Seeq","level":0,"time":"2019-09-28T18:15:31+00:00","remoteAddr":"192.168.1.1","user":"--","app":"onlyoffice","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJmaWxlSWQiOjQyNSwib3duZXJJZCI6InNtaXJreSIsInRva2VuIjpudWxsLCJhY3Rpb24iOiJ0cmFjayJ9.-LfBggWeffIy1QDPnb-wYg09ETChnutP1SY7ZMP5SVM","message":"Track: 425 status 4 result 0","userAgent":"--","version":"16.0.5.1"}

==> /var/log/nginx/cloud-access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "POST /index.php/apps/onlyoffice/track?doc=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJmaWxlSWQiOjQyNSwib3duZXJJZCI6InNtaXJreSIsInRva2VuIjpudWxsLCJhY3Rpb24iOiJ0cmFjayJ9.-LfBggWeffIy1QDPnb-wYg09ETChnutP1SY7ZMP5SVM HTTP/1.1" 200 11 "-" "-"
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/2.0" 200 74 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"

==> /var/log/nginx/nextcloud.log <==
{"reqId":"Zq1fREqmS2vcmZuei6BJ","level":0,"time":"2019-09-28T18:15:31+00:00","remoteAddr":"192.168.1.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Run OC\\Command\\CommandJob job with ID 3192","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/77.0.3865.90 Safari\/537.36","version":"16.0.5.1"}
{"reqId":"Zq1fREqmS2vcmZuei6BJ","level":0,"time":"2019-09-28T18:15:31+00:00","remoteAddr":"192.168.1.1","user":"--","app":"cron","method":"GET","url":"\/cron.php","message":"Finished OC\\Command\\CommandJob job with ID 3192 in 0 seconds","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/77.0.3865.90 Safari\/537.36","version":"16.0.5.1"}

==> /var/log/nginx/cloud-access.log <==
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /cron.php HTTP/2.0" 200 20 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /index.php/apps/gallery/config?extramediatypes=1 HTTP/2.0" 200 130 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /ocs/v2.php/apps/spreed/api/v1/signaling/settings HTTP/2.0" 200 666 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /index.php/apps/onlyoffice/ajax/settings HTTP/2.0" 200 2967 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "PROPFIND /remote.php/dav/files/smirky/dumps HTTP/2.0" 207 39700 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /ocs/v2.php/core/whatsnew?format=json HTTP/2.0" 204 0 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /index.php/apps/systemtags/lastused HTTP/2.0" 200 9 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:31 +0300] "GET /index.php/apps/files/ajax/getstoragestats.php?dir=%2Fdumps HTTP/2.0" 200 299 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:32 +0300] "GET /index.php/core/preview?fileId=416&c=ec23296eb855abe4f45ba6632fe1e273&x=250&y=250&forceIcon=0 HTTP/2.0" 404 0 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:32 +0300] "GET /ocs/v2.php/apps/activity/api/v2/activity/filter?format=json&object_type=files&object_id=425 HTTP/2.0" 304 0 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
192.168.1.1 - - [28/Sep/2019:21:15:32 +0300] "PROPFIND /remote.php/dav/systemtags-relations/files/425 HTTP/2.0" 207 425 "https://cloud.DOMAIN.TLD/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"

My default.json is:

{
	"statsd": {
		"useMetrics": false,
		"host": "localhost",
		"port": "8125",
		"prefix": "ds."
	},
	"log": {
		"filePath": "",
		"options": {
			"replaceConsole": true
		}
	},
	"queue": {
		"type": "rabbitmq",
		"visibilityTimeout": 300,
		"retentionPeriod": 900
	},
	"storage": {
		"name": "storage-fs",
		"fs": {
			"folderPath": "",
			"urlExpires": 900,
			"secretString": "onlyoffice"
		},
		"region": "",
		"endpoint": "http://localhost/s3",
		"bucketName": "cache",
		"storageFolderName": "files",
		"urlExpires": 604800,
		"accessKeyId": "AKID",
		"secretAccessKey": "FOR_GITHUB",
		"useRequestToGetUrl": false,
		"useSignedUrl": false,
		"externalHost": ""
	},
	"rabbitmq": {
		"url": "amqp://guest:guest@localhost:5672",
		"socketOptions": {},
		"exchangepubsub": "ds.pubsub",
		"queueconverttask": "ds.converttask",
		"queueconvertresponse": "ds.convertresponse",
		"exchangeconvertdead": "ds.exchangeconvertdead",
		"queueconvertdead": "ds.convertdead",
		"queuedelayed": "ds.delayed"
	},
	"activemq": {
		"connectOptions": {
			"port": 5672,
			"host": "localhost",
			"name": "admin",
			"reconnect": false
		},
		"queueconverttask": "ds.converttask",
		"queueconvertresponse": "ds.convertresponse",
		"queueconvertdead": "ActiveMQ.DLQ",
		"queuedelayed": "ds.delayed",
		"topicpubsub": "ds.pubsub"
	},
	"dnscache": {
		"enable" : true,
		"ttl" : 300,
		"cachesize" : 1000
	},
	"services": {
		"CoAuthoring": {
			"server": {
				"port": 8001,
				"workerpercpu": 1,
				"mode": "development",
				"limits_tempfile_upload": 104857600,
				"limits_image_size": 26214400,
				"limits_image_download_timeout": {
					"connectionAndInactivity": "10s",
					"wholeCycle": "2m"
				},
				"callbackRequestTimeout": {
					"wholeCycle": "2m"
				},
				"healthcheckfilepath": "../public/healthcheck.docx",
				"savetimeoutdelay": 5000,
				"edit_singleton": false,
				"forgottenfiles": "forgotten",
				"forgottenfilesname": "output",
				"maxRequestChanges": 20000,
				"openProtectedFile": true
			},
			"requestDefaults": {
				"headers": {
					"userAgent": "Node.js/6.13"
				},
				"rejectUnauthorized": true
			},
			"autoAssembly": {
				"enable": false,
				"interval": "5m",
				"step": "1m"
			},
			"utils": {
				"utils_common_fontdir": "null",
				"utils_fonts_search_patterns": "*.ttf;*.ttc;*.otf",
				"resource_expires": 31536000,
				"limits_image_types_upload": "jpg;png;gif;bmp"
			},
			"sql": {
				"type": "postgres",
				"tableChanges": "doc_changes",
				"tableResult": "task_result",
				"dbHost": "localhost",
				"dbPort": 5432,
				"dbName": "onlyoffice",
				"dbUser": "onlyoffice",
				"dbPass": "onlyoffice",
				"charset": "utf8",
				"connectionlimit": 10,
				"max_allowed_packet": 1048575
			},
			"redis": {
				"name": "redis",
				"prefix": "ds:",
				"host": "localhost",
				"port": 6379
			},
			"pubsub": {
				"name": "pubsubRabbitMQ",
				"maxChanges": 1000
			},
			"expire": {
				"saveLock": 60,
				"presence": 300,
				"locks": 604800,
				"changeindex": 86400,
				"lockDoc": 30,
				"message": 86400,
				"lastsave": 604800,
				"forcesave": 604800,
				"saved": 3600,
				"documentsCron": "0 */2 * * * *",
				"files": 86400,
				"filesCron": "00 00 */1 * * *",
				"filesremovedatonce": 100,
				"sessionidle": "0",
				"sessionabsolute": "30d",
				"sessionclosecommand": "2m",
				"pemStdTTL": "1h",
				"pemCheckPeriod": "10m",
				"updateVersionStatus": "5m"
			},
			"ipfilter": {
				"rules": [{"address": "*", "allowed": true}],
				"useforrequest": false,
				"errorcode": 403
			},
			"secret": {
				"browser": {"string": "FOR_GITHUB", "file": "", "tenants": {}},
				"inbox": {"string": "FOR_GITHUB", "file": "", "tenants": {}},
				"outbox": {"string": "FOR_GITHUB", "file": ""},
				"session": {"string": "FOR_GITHUB", "file": ""}
			},
			"token": {
				"enable": {
					"browser": true,
					"request": {
						"inbox": true,
						"outbox": true
					}
				},
				"browser": {
					"secretFromInbox": true
				},
				"inbox": {
					"header": "Authorization",
					"prefix": "Bearer ",
					"inBody": false
				},
				"outbox": {
					"header": "Authorization",
					"prefix": "Bearer ",
					"algorithm": "HS256",
					"expires": "5m",
					"inBody": false
				},
				"session": {
					"algorithm": "HS256",
					"expires": "30d"
				}
			},
			"plugins": {
				"uri": "/sdkjs-plugins",
				"autostart": []
			},
			"editor":{
				"spellcheckerUrl": "/spellchecker",
				"reconnection":{
					"attempts": 50,
					"delay": "2s"
				}
			},
			"sockjs": {
				"sockjs_url": "",
				"websocket": true
			},
			"callbackBackoffOptions": {
				"retries": 0,
				"timeout":{
					"factor": 2,
					"minTimeout": 1000,
					"maxTimeout": 2147483647,
					"randomize": false
				},
				"httpStatus": "429,500-599"
			}
		}
	},
	"license" : {
		"license_file": "",
		"warning_limit_percents": "70"
	},
	"FileConverter": {
		"converter": {
			"maxDownloadBytes": 104857600,
			"downloadTimeout": {
				"connectionAndInactivity": "10s",
				"wholeCycle": "2m"
			},
			"downloadAttemptMaxCount": 3,
			"downloadAttemptDelay": 1000,
			"maxprocesscount": 1,
			"fontDir": "null",
			"presentationThemesDir": "null",
			"x2tPath": "null",
			"docbuilderPath": "null",
			"docbuilderAllFontsPath": "null",
			"args": "",
			"spawnOptions": {},
			"errorfiles": "",
			"streamWriterBufferSize": 8388608,
			"maxRedeliveredCount": 2,
			"inputLimits": [
				{
				"type": "docx;dotx;docm;dotm",
				"zip": {
					"uncompressed": "50MB",
					"template": "*.xml"
				}
				},
				{
				"type": "xlsx;xltx;xlsm;xltm",
				"zip": {
					"uncompressed": "300MB",
					"template": "*.xml"
				}
				},
				{
				"type": "pptx;ppsx;potx;pptm;ppsm;potm",
				"zip": {
					"uncompressed": "50MB",
					"template": "*.xml"
				}
				}
			]
		}
	},
	"FileStorage": {
		"host": "",
		"port": 4567,
		"directory": "",
		"silent": true
	},
	"SpellChecker": {
		"server": {
			"port": 8080,
			"mode": "development"
		}
	}
}

If you have any clue what could be the cause of this, I would appreciate your time to share it.
@smirkybg smirkybg changed the title C Cannot open documents (An error has occurred while opening the file) Sep 28, 2019
@tnyeanderson
Copy link

I've had this happen because of wonky firewall rules. Have you tried disabling your firewall to see if that changes anything?

@smirkybg
Copy link
Author

I don't have firewall rules that could impact on this. The host doesn't have a firewall on it, since it's behind a router. I do have ports :80/:443 open, obviously, otherwise I wouldn't have any connection to nextcloud too.

@alexanderonlyoffice
Copy link

Hello @smirkybg, what message do you get when click on the 'Save' button on ONLYOFFICE integration app settings page in Nextcloud?

@smirkybg
Copy link
Author

Hi @alexanderonlyoffice. Nothing unusual, see below:

image

@gitjmrubio
Copy link

Hello everyone, I have similar issue but when opening any document it says documentserver refused to connect.
image

My settings on two separate CentOS 7 servers with letsencrypt ssl certificate:
NEXTCLOUD SERVER ( https://drive.palki-office.tk )

  • Server version: Apache/2.4.6 (CentOS)
  • PHP 7.2.22 (cli) (built: Sep 11 2019 18:11:52) ( NTS )
  • Nextcloud 16.0.4

ONLYOFFICE DOCUMENT SERVER ( https://office.obpht1062.tk )

  • Nodejs v8.16.1
  • Redis server v=3.2.12
  • Nginx version: nginx/1.16.1
  • RabbitMQ 3.3.5, Erlang R16B03-1

All basic test like connect nextcloud to onlyoffice works good, telnet, wget & curls test also good.

On Nextcloud server I see below erros:
/var/log/httpd/error_log
[Sun Sep 29 03:21:02.967268 2019] [lbmethod_heartbeat:notice] [pid 19638] AH02282: No slotmem from mod_heartmonitor
[Sun Sep 29 03:21:02.975315 2019] [ssl:warn] [pid 19638] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)[Sun Sep 29 19:01:39.783764 2019] [authz_core:error] [pid 17866] [client 181.174.107.206:45178] AH01630: client denied by server configuration: /var/www/html/nextcloud/config
[Mon Sep 30 05:55:07.661768 2019] [php7:error] [pid 18875] [client 188.0.96.49:42819] script '/var/www/html/nextcloud/adminer.php' not found or unable to stat, referer: https://5.189.161.79/adminer.php
[Mon Sep 30 11:57:32.876541 2019] [authz_core:error] [pid 22892] [client 181.174.107.206:59448] AH01630: client denied by server configuration: /var/www/html/nextcloud/config

/var/www/html/nextcloud/data/nextcloud.log
{"reqId":"XZJvJCEin8kfDQch5RI4cwAAAAQ","level":3,"time":"2019-09-30T21:09:56+00:00","remoteAddr":"181.174.107.206","user":"jrubio","app":"PHP","method":"GET","url":"
/index.php/apps/onlyoffice/ajax/config/475?filePath=%2FHoja2.xlsx","message":"Undefined index: download at /var/www/html/nextcloud/apps/onlyoffice/contr
oller/editorcontroller.php#959","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
,"version":"16.0.4.1"}

Any help is very appreciated.

@gitjmrubio
Copy link

Hello everyone, I have similar issue but when opening any document it says documentserver refused to connect.
image

My settings on two separate CentOS 7 servers with letsencrypt ssl certificate:
NEXTCLOUD SERVER ( https://drive.palki-office.tk )

  • Server version: Apache/2.4.6 (CentOS)
  • PHP 7.2.22 (cli) (built: Sep 11 2019 18:11:52) ( NTS )
  • Nextcloud 16.0.4

ONLYOFFICE DOCUMENT SERVER ( https://office.obpht1062.tk )

  • Nodejs v8.16.1
  • Redis server v=3.2.12
  • Nginx version: nginx/1.16.1
  • RabbitMQ 3.3.5, Erlang R16B03-1

All basic test like connect nextcloud to onlyoffice works good, telnet, wget & curls test also good.

On Nextcloud server I see below erros:
/var/log/httpd/error_log
[Sun Sep 29 03:21:02.967268 2019] [lbmethod_heartbeat:notice] [pid 19638] AH02282: No slotmem from mod_heartmonitor
[Sun Sep 29 03:21:02.975315 2019] [ssl:warn] [pid 19638] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)[Sun Sep 29 19:01:39.783764 2019] [authz_core:error] [pid 17866] [client 181.174.107.206:45178] AH01630: client denied by server configuration: /var/www/html/nextcloud/config
[Mon Sep 30 05:55:07.661768 2019] [php7:error] [pid 18875] [client 188.0.96.49:42819] script '/var/www/html/nextcloud/adminer.php' not found or unable to stat, referer: https://5.189.161.79/adminer.php
[Mon Sep 30 11:57:32.876541 2019] [authz_core:error] [pid 22892] [client 181.174.107.206:59448] AH01630: client denied by server configuration: /var/www/html/nextcloud/config

/var/www/html/nextcloud/data/nextcloud.log
{"reqId":"XZJvJCEin8kfDQch5RI4cwAAAAQ","level":3,"time":"2019-09-30T21:09:56+00:00","remoteAddr":"181.174.107.206","user":"jrubio","app":"PHP","method":"GET","url":"
/index.php/apps/onlyoffice/ajax/config/475?filePath=%2FHoja2.xlsx","message":"Undefined index: download at /var/www/html/nextcloud/apps/onlyoffice/contr
oller/editorcontroller.php#959","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36"
,"version":"16.0.4.1"}

Any help is very appreciated.

Forgot say after installation everything worked fine even opening and editing documents with OnlyOffice, the issue came a few days later with practicaly any modification made. Thanks

@smirkybg
Copy link
Author

smirkybg commented Oct 1, 2019 •
edited
Loading

It appears that new documents work just fine.
Old documents are not working for some reason.
However, copying an old document and opening the copy works!
Not sure how to troubleshoot this though.

What's even more strange is that when I open the old documents with the "testing" version of onlyoffice (the public one), it works.

@smirkybg
Copy link
Author

smirkybg commented Oct 1, 2019 •
edited
Loading

I fixed the problem. Turned out that the Postgres database table "task_result" was causing the issue.
Not sure why but I decided to truncate it and now even old documents are working just fine.

# su - onlyoffice -s /bin/sh -c "psql -c 'truncate table task_result'"

@smirkybg smirkybg closed this as completed Oct 1, 2019
@LinneyS LinneyS added installation question Further information is requested labels Oct 2, 2019
@hexitnz hexitnz mentioned this issue Oct 18, 2020
Closed
@codello codello mentioned this issue Feb 13, 2021
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
installation question Further information is requested
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@LinneyS @tnyeanderson @smirkybg @alexanderonlyoffice @gitjmrubio