Try the fastest and simplest way to install ONLYOFFICE

Nextcloud integration doesn't work

Tech support for Enterprise Version

Nextcloud integration doesn't work

Postby budy » Sat Jun 24, 2017 7:11 am

Hi,

I am trying out OnlyOffice Enterprise on our NC12 setup. I have followed the detailed instructions to install the integration app from guthub and configure it, but I am not able to get it to work correctly. Whenever I open a document from within NC12 via the "Open in OnlyOffice", I am getting an error that OnlyOffice was not able to save the document. The logs on the document server and NC read like this:

Nextcloud:

{"reqId":"WU4PPNM6afRb7NzkOhr@ZQAAAAg","level":0,"time":"2017-06-24T07:05:32+00:00","remoteAddr":"10.11.31.20","user":"--","app":"onlyoffice","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=cEJYVTEzZmduV2pWTDM0TDRhZHdyWVN2VHh4TlFYWm1NeHcrejJYYkxpZz0\/eyJmaWxlSWQiOjQwNzI4Niwib3duZXJJZCI6InN0ZXBoYW4uYnVkYWNoIiwiYWN0aW9uIjoidHJhY2sifQ%3D%3D","message":"Track HEADER : {\"payload\":{\"key\":\"4072861498287785\",\"status\":1,\"users\":[\"stephan.budach\"],\"actions\":[{\"type\":1,\"userid\":\"stephan.budach\"}]},\"iat\":1498287932,\"exp\":1498288232}","userAgent":"--","version":"12.0.0.29"}
{"reqId":"WU4PYyMGhphfSQAgdke4kQAAAAk","level":0,"time":"2017-06-24T07:06:11+00:00","remoteAddr":"10.11.31.20","user":"--","app":"onlyoffice","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=cEJYVTEzZmduV2pWTDM0TDRhZHdyWVN2VHh4TlFYWm1NeHcrejJYYkxpZz0\/eyJmaWxlSWQiOjQwNzI4Niwib3duZXJJZCI6InN0ZXBoYW4uYnVkYWNoIiwiYWN0aW9uIjoidHJhY2sifQ%3D%3D","message":"Track HEADER : {\"payload\":{\"key\":\"4072861498287785\",\"status\":2,\"url\":\"https:\\\/\\\/onlyoffice.jvm.de\\\/cache\\\/files\\\/4072861498287785_3436\\\/output.docx\\\/output.docx?md5=y1kylHXRADVqGHcQnqZzaw==&expires=1500879972&disposition=attachment&ooname=output.docx\",\"changesurl\":\"https:\\\/\\\/onlyoffice.jvm.de\\\/cache\\\/files\\\/4072861498287785_3436\\\/changes.zip\\\/changes.zip?md5=ofN9KA2Tyd3TYUdVQApe9g==&expires=1500879972&disposition=attachment&ooname=output.zip\",\"history\":{\"serverVersion\":\"4.3.6\",\"changes\":[{\"created\":\"2017-06-24 07:03:45\",\"user\":{\"id\":\"stephan.budach\",\"name\":\"Stephan Budach\"}}]},\"users\":[\"stephan.budach\"],\"actions\":[{\"type\":0,\"userid\":\"stephan.budach\"}],\"lastsave\":\"2017-06-24T07:05:56.042Z\",\"notmodified\":false},\"iat\":1498287971,\"exp\":1498288271}","userAgent":"--","version":"12.0.0.29"}
{"reqId":"WU4PYyMGhphfSQAgdke4kQAAAAk","level":0,"time":"2017-06-24T07:06:11+00:00","remoteAddr":"10.11.31.20","user":"--","app":"onlyoffice","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=cEJYVTEzZmduV2pWTDM0TDRhZHdyWVN2VHh4TlFYWm1NeHcrejJYYkxpZz0\/eyJmaWxlSWQiOjQwNzI4Niwib3duZXJJZCI6InN0ZXBoYW4uYnVkYWNoIiwiYWN0aW9uIjoidHJhY2sifQ%3D%3D","message":"Replace in track from https:\/\/onlyoffice.jvm.de\/ to https:\/\/onlyoffice.jvm.de\/","userAgent":"--","version":"12.0.0.29"}
{"reqId":"WU4PYyMGhphfSQAgdke4kQAAAAk","level":3,"time":"2017-06-24T07:06:11+00:00","remoteAddr":"10.11.31.20","user":"--","app":"PHP","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=cEJYVTEzZmduV2pWTDM0TDRhZHdyWVN2VHh4TlFYWm1NeHcrejJYYkxpZz0\/eyJmaWxlSWQiOjQwNzI4Niwib3duZXJJZCI6InN0ZXBoYW4uYnVkYWNoIiwiYWN0aW9uIjoidHJhY2sifQ%3D%3D","message":"file_get_contents(): SSL operation failed with code 1. OpenSSL Error messages:\nerror:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed at \/var\/www\/nextcloud\/apps\/onlyoffice\/controller\/callbackcontroller.php#376","userAgent":"--","version":"12.0.0.29"}
{"reqId":"WU4PYyMGhphfSQAgdke4kQAAAAk","level":3,"time":"2017-06-24T07:06:11+00:00","remoteAddr":"10.11.31.20","user":"--","app":"PHP","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=cEJYVTEzZmduV2pWTDM0TDRhZHdyWVN2VHh4TlFYWm1NeHcrejJYYkxpZz0\/eyJmaWxlSWQiOjQwNzI4Niwib3duZXJJZCI6InN0ZXBoYW4uYnVkYWNoIiwiYWN0aW9uIjoidHJhY2sifQ%3D%3D","message":"file_get_contents(): Failed to enable crypto at \/var\/www\/nextcloud\/apps\/onlyoffice\/controller\/callbackcontroller.php#376","userAgent":"--","version":"12.0.0.29"}
{"reqId":"WU4PYyMGhphfSQAgdke4kQAAAAk","level":3,"time":"2017-06-24T07:06:11+00:00","remoteAddr":"10.11.31.20","user":"--","app":"PHP","method":"POST","url":"\/index.php\/apps\/onlyoffice\/track?doc=cEJYVTEzZmduV2pWTDM0TDRhZHdyWVN2VHh4TlFYWm1NeHcrejJYYkxpZz0\/eyJmaWxlSWQiOjQwNzI4Niwib3duZXJJZCI6InN0ZXBoYW4uYnVkYWNoIiwiYWN0aW9uIjoidHJhY2sifQ%3D%3D","message":"file_get_contents(https:\/\/onlyoffice.jvm.de\/cache\/files\/4072861498287785_3436\/output.docx\/output.docx?md5=y1kylHXRADVqGHcQnqZzaw==&expires=1500879972&disposition=attachment&ooname=output.docx): failed to open stream: operation failed at \/var\/www\/nextcloud\/apps\/onlyoffice\/controller\/callbackcontroller.php#376","userAgent":"--","version":"12.0.0.29"}


docserver:
[2017-06-24 07:06:11.158] [ERROR] nodeJS - sendServerRequest error: docId = 4072861498287785;url = https://cloudnine.jvm.de/index.php/apps ... 3D%3D;data = {"key":"4072861498287785","status":2,"url":"https://onlyoffice.jvm.de/cache/files/4072861498287785_3436/output.docx/output.docx?md5=y1kylHXRADVqGHcQnqZzaw==&expires=1500879972&disposition=attachment&ooname=output.docx","changesurl":"https://onlyoffice.jvm.de/cache/files/4072861498287785_3436/changes.zip/changes.zip?md5=ofN9KA2Tyd3TYUdVQApe9g==&expires=1500879972&disposition=attachment&ooname=output.zip","history":{"serverVersion":"4.3.6","changes":[{"created":"2017-06-24 07:03:45","user":{"id":"stephan.budach","name":"Stephan Budach"}}]},"users":["stephan.budach"],"actions":[{"type":0,"userid":"stephan.budach"}],"lastsave":"2017-06-24T07:05:56.042Z","notmodified":false}
Error: Error response: statusCode:400 ;body:
{"error":1}
at Request._callback (/var/www/onlyoffice/documentserver/server/Common/sources/utils.js:260:18)
at Request.self.callback (/var/www/onlyoffice/documentserver/server/Common/node_modules/request/request.js:188:22)
at emitTwo (events.js:106:13)
at Request.emit (events.js:191:7)
at Request.<anonymous> (/var/www/onlyoffice/documentserver/server/Common/node_modules/request/request.js:1171:10)
at emitOne (events.js:96:13)
at Request.emit (events.js:188:7)
at IncomingMessage.<anonymous> (/var/www/onlyoffice/documentserver/server/Common/node_modules/request/request.js:1091:12)
at IncomingMessage.g (events.js:292:16)
at emitNone (events.js:91:20)


When I reopen the file via the OnlyOffice editor, I can see my changes in a new file, but the file doesn't makes it back to the Nextcloud instance.
budy
 
Posts: 4
Joined: Sat Jun 24, 2017 6:43 am

Re: Nextcloud integration doesn't work

Postby Maxim » Tue Jun 27, 2017 9:10 am

Hello budy!
There is an error in nextcoud with SSL validation.
See here and here
Maxim
 
Posts: 1072
Joined: Tue Oct 11, 2016 2:34 pm

Re: Nextcloud integration doesn't work

Postby budy » Wed Jun 28, 2017 4:02 pm

HI Maxim,

thank you. I already discovered that thread on the weekend and I added the root and intermediate Thawte certificates to my CentOS7 install. Now, I am able to open most - but not all, files in the OnlyOffice editor from within Nextcloud. For one file though, this doesn't work. If I am trying to open a specific spreadsheet via "Open in OnlyOffice", I am still getting the same dialog, that the document couldn't be saved. After acknowledging that, I am presentet some "other" docdument.

The spreadsheet in my Nextcloud account is actually empty, but when opened in OnlyOffice, I can edit it and the contents is preserved until I open it next time in OnlyOffce, however it doesn't sync back to my Nextcloud, where the document remains empty.
budy
 
Posts: 4
Joined: Sat Jun 24, 2017 6:43 am

Re: Nextcloud integration doesn't work

Postby Maxim » Fri Jun 30, 2017 7:56 am

Hello budy!
Did you solve the problem?
Maxim
 
Posts: 1072
Joined: Tue Oct 11, 2016 2:34 pm

Re: Nextcloud integration doesn't work

Postby budy » Fri Jun 30, 2017 5:06 pm

Hi Maxim,

actually, no… Whenever I am trying to open this document via "Open in OnlyOffice", I am getting some 403-error in the document server logs.
Other documents seem to work fine. Although this is only a test file, I am curious, what causes this. This is the log from the document server:

Code: Select all
[2017-06-30 06:18:51.974] [ERROR] nodeJS - sendServerRequest error: docId = 3985551498132931;url = https://cloudnine.jvm.de/index.php/apps/onlyoffice/track?doc=MWIyUUZsMVkyQXcyTlpGVDdDRjV5VUx4Yk1TalUxZWpXcFdhLzY1VCtVcz0/eyJmaWxlSWQiOjM5ODU1NSwib3duZXJJZCI6InN0ZXBoYW4uYnVkYWNoIiwiYWN0aW9uIjoidHJhY2sifQ%3D%3D;data = {"key":"3985551498132931","status":3,"users":["stephan.budach"],"actions":[{"type":0,"userid":"stephan.budach"}],"lastsave":"2017-06-23T08:58:37.886Z","notmodified":false}
Error: Error response: statusCode:403 ;body:
{"message":"Access denied"}
    at Request._callback (/var/www/onlyoffice/documentserver/server/Common/sources/utils.js:260:18)
    at Request.self.callback (/var/www/onlyoffice/documentserver/server/Common/node_modules/request/request.js:188:22)
    at emitTwo (events.js:106:13)
    at Request.emit (events.js:191:7)
    at Request.<anonymous> (/var/www/onlyoffice/documentserver/server/Common/node_modules/request/request.js:1171:10)
    at emitOne (events.js:96:13)
    at Request.emit (events.js:188:7)
    at IncomingMessage.<anonymous> (/var/www/onlyoffice/documentserver/server/Common/node_modules/request/request.js:1091:12)
    at IncomingMessage.g (events.js:292:16)
    at emitNone (events.js:91:20)
    at IncomingMessage.emit (events.js:185:7)
[2017-06-30 06:35:46.743] [WARN] nodeJS - Plugins watch exception (https://nodejs.org/docs/latest/api/fs.html#fs_availability).
[2017-06-30 06:35:46.781] [WARN] nodeJS - update cluster with 1 workers
[2017-06-30 06:35:46.799] [WARN] nodeJS - worker 12181 started.
[2017-06-30 06:35:47.074] [WARN] nodeJS - Express server starting...
[2017-06-30 06:35:48.823] [WARN] nodeJS - Express server listening on port 8000 in production-linux mode
budy
 
Posts: 4
Joined: Sat Jun 24, 2017 6:43 am

Re: Nextcloud integration doesn't work

Postby Maxim » Mon Jul 24, 2017 8:30 am

Hello budy!
We need to see what errors in nextcloud's logs. Show us please.
Maxim
 
Posts: 1072
Joined: Tue Oct 11, 2016 2:34 pm

Re: Nextcloud integration doesn't work

Postby budy » Sat Jul 29, 2017 9:01 am

Hi Maxim,

I had to disable my OnlyOffice integration, since my test period was over. I will try to get another test drive and then I'll be right on it.
I will update this thread shortly.

Thanks,
Stephan
budy
 
Posts: 4
Joined: Sat Jun 24, 2017 6:43 am


Return to Enterprise Version

Who is online

Users browsing this forum: No registered users and 1 guest