Git Product home page Git Product logo

officeonline's Introduction

Office Online integration

Branches

We currently maintain two branches for compatibility with Nextcloud versions:

  • main (Nextcloud 24 upwards)
  • stable1 (Nextcloud 22-23)

Development setup

Just clone this repo into your apps directory (Nextcloud server installation needed). Additionally, npm and Node.js are needed for installing JavaScript dependencies and building the frontend code.

Once npm and Node.js are installed, this can be done by running:

npm ci
npm run dev

Installation

Server

You will need an working on-premise Office Online server which has added the Nextcloud server as a trusted host for WOPI. The cloud-based Office 365 is not supported.

Support

Enterprise users who need a more reliable and scalable solution can take advantage of Nextcloud GmbH's optional support contract for Office Online integration. Find out more about Enterprise support over here: https://nextcloud.com/enterprise/

Known problems

officeonline's People

Contributors

adityab avatar ashod avatar blizzz avatar butonic avatar christophwurst avatar deepdiver1975 avatar dependabot-preview[bot] avatar dependabot[bot] avatar georgehrke avatar hcvcastro avatar jancborchardt avatar juliushaertl avatar kendy avatar lukasreschke avatar mariusbluem avatar mihai-varga avatar morrisjobke avatar mrkara avatar nextcloud-bot avatar nickvergessen avatar pedropintosilva avatar pranavk avatar pvince81 avatar rakekniven avatar rullzer avatar skjnldsv avatar timar avatar vgezer avatar vicdeo avatar xklonx avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

officeonline's Issues

It seems that at first try the document doesn't open

Describe the bug
Recently I tried opening an .odt file that I've never opened before, and the screen just got stuck in loading. This has happened multiple times since I use Collabora/Nextcloud Office, though after some attempts the file does load.

The errors do refer to the File Access Control app, but it shouldn't matter because the condition to block the files isn't satisfied.

To Reproduce
Steps to reproduce the behavior:

  1. Go to one .docx or .odt file in your Nextcloud Files.
  2. Click on
  3. See error

Expected behavior
The files should obviosuly succesfully open even if I haven't opened it before.

Screenshots
The screen is stuck here:
immagine

These are the error that appear in the logging section:
immagine

Client details:

  • OS: KDE Neon
  • Browser: Firefox
  • Version: 97.0.1
  • Device: Lenovo B51-30

Server details

Operating system: Ubuntu 18.04

Web server: Apache2

Database: MySQL

PHP version: 8.0.15

Nextcloud version: 23.0.2

Version of the officeonline app: Nextcloud Office 5.0.3

Version of Office Online server: Collabora Online - Built-in CODE Server 21.11.204

Logs

Nextcloud log (data/nextcloud.log)

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"Flow activation: rules were requested for operation Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"No flow configurations is going to run Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"Flow activation: rules were requested for operation Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"No flow configurations is going to run Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"Flow activation: rules were requested for operation Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"No flow configurations is going to run Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"Flow activation: rules were requested for operation Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"No flow configurations is going to run Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"Flow activation: rules were requested for operation Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

{"reqId":"wC4CExFql12o4dkZW6gr","level":0,"time":"2022-03-05T11:57:11+00:00","remoteAddr":"79.35.211.79","user":"Samuele","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/Samuele/Istruzione/Lavori/Giornata%20di%20facolt%C3%A0/Synodos%20come%20Methodos%20-%20Zappal%C3%A0.odt","message":"No flow configurations is going to run Blocca accesso a un file","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:97.0) Gecko/20100101 Firefox/97.0","version":"23.0.2.1"}

These are the errors visibile in the logging section of Nextcloud:
Error 1/3:

[PHP] Errore: Trying to access array offset on value of type null at /var/www/nextcloud.samuelezappala.it/public/apps/richdocuments/lib/WOPI/DiscoveryManager.php#123

GET /apps/richdocuments/index?fileId=437156&requesttoken=%2FT%2FM2uCKKY7htd6Z0XJOo7ZzxTA2jjgpkTf%2FhZNk%2FIU%3D%3AqQyE9a7%2BaP%2BV7e7wmhEf8%2F4yjEMHpXVTo3WVycFLkdE%3D&path=%2FIstruzione%2FLavori%2FGiornata%20di%20facolt%C3%A0%2FSynodos%20come%20Methodos%20-%20Zappal%C3%A0.odt
from 79.35.211.79 by Samuele at 2022-03-05T11:57:26+00:00

Error 2/3:

[PHP] Errore: Trying to access array offset on value of type null at /var/www/nextcloud.samuelezappala.it/public/apps/richdocuments/lib/WOPI/DiscoveryManager.php#124

GET /apps/richdocuments/index?fileId=437156&requesttoken=%2FT%2FM2uCKKY7htd6Z0XJOo7ZzxTA2jjgpkTf%2FhZNk%2FIU%3D%3AqQyE9a7%2BaP%2BV7e7wmhEf8%2F4yjEMHpXVTo3WVycFLkdE%3D&path=%2FIstruzione%2FLavori%2FGiornata%20di%20facolt%C3%A0%2FSynodos%20come%20Methodos%20-%20Zappal%C3%A0.odt
from 79.35.211.79 by Samuele at 2022-03-05T11:57:26+00:00

Error 3/3:

[PHP] Errore: Trying to access array offset on value of type null at /var/www/nextcloud.samuelezappala.it/public/apps/richdocuments/lib/WOPI/DiscoveryManager.php#125

GET /apps/richdocuments/index?fileId=437156&requesttoken=%2FT%2FM2uCKKY7htd6Z0XJOo7ZzxTA2jjgpkTf%2FhZNk%2FIU%3D%3AqQyE9a7%2BaP%2BV7e7wmhEf8%2F4yjEMHpXVTo3WVycFLkdE%3D&path=%2FIstruzione%2FLavori%2FGiornata%20di%20facolt%C3%A0%2FSynodos%20come%20Methodos%20-%20Zappal%C3%A0.odt
from 79.35.211.79 by Samuele at 2022-03-05T11:57:26+00:00

Browser log

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

a) The javascript console log:
immagine

File Save As Error

Describe the bug
Open an existing file and save as. The following error message appears at this time.
save_as_error
There are no error messages in the NextCloud log files.
But there is the following error message in the Office Online server event log:
could not contact wopi end point filenotfound url

WOPI_ERROR

Client details:

  • OS: Windows 10 1909
  • Browser [Microsoft Edge]
  • Version [98.0.1108.43]

Server details

Operating system:
Linux 4.14.173-137.229.amzn2.x86_64 x86_64
Web server:
AWS ALB
Database:
PostgreSQL 11.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit
PHP version:
7.4.27
Nextcloud version:
21.0.5
Version of the officeonline app
1.1.2
Version of Office Online server
16.0.10338.20039

File Conversion Sorry, we can into a problem

Describe the bug
Open a doc file and convert it into docx. once you open the file and conver it get an error. Please see below screen record.

2021-12-03.13-00-14.mp4

If dev need a test server to connect ill be more then happy to give you Online office server url.

Server details

Operating system:
Ubuntu 20.04
Web server:
Apache
Database:
MariaDB 10.5.13
PHP version:
8.0.13
Nextcloud version:
23.0.0
Version of the officeonline app
1.1.1
Version of Office Online server
2019

always connecting to internal ip

Hi,
i am trying to set up office online app. The Office Onlline Server is answering on /hosting/discovery. In nextcloud the url is configured and it says "server is reachable". Now i am trying to open a word document, it is loading but the browser says "connecting with 10.xxx.xxx.xxx". it shows the internal ip of OOS.
Does anybody knows why? The internal and external ip in office online server is set to the external domain.

THX

russian language

The online office interface does not open in russian language, despite the fact that the language of the system and profile is set to russian

`npm run dev` got error

Describe the bug
It seems missing package after ran npm run dev

And front end GUI shows error when open office file

Error
cURL error 3: <url> malformed (see https://curl.haxx.se/libcurl/c/libcurl-errors.html)

To Reproduce
Steps to reproduce the behavior:

  1. Go to '/var/www/html/nextcloud/apps/officeonline'
  2. ran npm ci
    npm run dev
  3. Direclty open office file in web GUI
  4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
image

Client details:

  • OS: [e.g. iOS] macOS 10.14.6
  • Browser [e.g. chrome, safari] chrome
  • Version [e.g. 22] 85
  • Device: [e.g. iPhone6, desktop] desktop

Server details

Operating system: CentOS Linux release 8.2.2004 (Core)

Web server: Apache/2.4.37 (centos)

Database: mysql Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86_64) using readline 5.1

**PHP version:**PHP 7.4.10 (cli) (built: Sep 1 2020 13:58:08) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.10, Copyright (c), by Zend Technologies

Nextcloud version: Next Cloud 19.0.3

Version of the officeonline app 1.0.0

Version of Office Online server
npm -v 6.14.6
node -v v12.18.3

Logs

Nextcloud log (data/nextcloud.log)

{"reqId":"X3LgU-fyx7CBA@8JBbxwxAAAAM0","level":3,"time":"2020-09-29T07:20:51+00:00","remoteAddr":"58.x.x.x","user":"bft","app":"officeonline","method":"GET","url":"/apps/officeonline/index?fileId=9&requesttoken=8hdfSK8%2BrmUiFzRG3L66YlEKKVOurZfaBd4tCE2pVs0%3D%3Ap1s%2Bcfx44TdHdHkIi8jTCSMlBgDly8e3RvUCeD3hbrc%3D&path=/Documents/Welcome%20to%20Nextcloud%20Hub.docx","message":{"Exception":"GuzzleHttp\\Exception\\RequestException","Message":"cURL error 3: <url> malformed (see https://curl.haxx.se/libcurl/c/libcurl-errors.html)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php","line":155,"function":"createRejection","class":"GuzzleHttp\\Handler\\CurlFactory","type":"::"},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php","line":105,"function":"finishError","class":"GuzzleHttp\\Handler\\CurlFactory","type":"::"},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/CurlHandler.php","line":43,"function":"finish","class":"GuzzleHttp\\Handler\\CurlFactory","type":"::"},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/Proxy.php","line":28,"function":"__invoke","class":"GuzzleHttp\\Handler\\CurlHandler","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/Proxy.php","line":51,"function":"GuzzleHttp\\Handler\\{closure}","class":"GuzzleHttp\\Handler\\Proxy","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php","line":37,"function":"GuzzleHttp\\Handler\\{closure}","class":"GuzzleHttp\\Handler\\Proxy","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Middleware.php","line":29,"function":"__invoke","class":"GuzzleHttp\\PrepareBodyMiddleware","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/RedirectMiddleware.php","line":70,"function":"GuzzleHttp\\{closure}","class":"GuzzleHttp\\Middleware","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Middleware.php","line":59,"function":"__invoke","class":"GuzzleHttp\\RedirectMiddleware","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/HandlerStack.php","line":71,"function":"GuzzleHttp\\{closure}","class":"GuzzleHttp\\Middleware","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Client.php","line":361,"function":"__invoke","class":"GuzzleHttp\\HandlerStack","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Client.php","line":163,"function":"transfer","class":"GuzzleHttp\\Client","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Client.php","line":183,"function":"requestAsync","class":"GuzzleHttp\\Client","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Http/Client/Client.php","line":228,"function":"request","class":"GuzzleHttp\\Client","type":"->"},{"file":"/var/www/html/nextcloud/apps/officeonline/lib/WOPI/DiscoveryManager.php","line":106,"function":"get","class":"OC\\Http\\Client\\Client","type":"->"},{"file":"/var/www/html/nextcloud/apps/officeonline/lib/WOPI/DiscoveryManager.php","line":78,"function":"fetchFromRemote","class":"OCA\\Officeonline\\WOPI\\DiscoveryManager","type":"->"},{"file":"/var/www/html/nextcloud/apps/officeonline/lib/WOPI/Parser.php","line":77,"function":"get","class":"OCA\\Officeonline\\WOPI\\DiscoveryManager","type":"->"},{"file":"/var/www/html/nextcloud/apps/officeonline/lib/WOPI/Parser.php","line":99,"function":"getParsed","class":"OCA\\Officeonline\\WOPI\\Parser","type":"->"},{"file":"/var/www/html/nextcloud/apps/officeonline/lib/TokenManager.php","line":208,"function":"getUrlSrcForFile","class":"OCA\\Officeonline\\WOPI\\Parser","type":"->"},{"file":"/var/www/html/nextcloud/apps/officeonline/lib/Controller/DocumentController.php","line":245,"function":"getToken","class":"OCA\\Officeonline\\TokenManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"index","class":"OCA\\Officeonline\\Controller\\DocumentController","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/App.php","line":137,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Route/Router.php","line":297,"function":"call_user_func"},{"file":"/var/www/html/nextcloud/lib/base.php","line":1012,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/html/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/html/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php","Line":201,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36","version":"19.0.3.1","id":"5f72e0f35236a"}

Browser log

Opening viewer for file  /Documents/Welcome to Nextcloud Hub.docx
globals.js:61 moment is deprecated: please ship your own, this will be removed in Nextcloud 20
$ @ globals.js:61
get @ globals.js:92
updateLastSavedStatus @ EditorWrapper.vue:252
(anonymous) @ EditorWrapper.vue:230
vue.runtime.esm.js:6785 GET /apps/officeonline/index?fileId=9&requesttoken=8hdfSK8%2BrmUiFzRG3L66YlEKKVOurZfaBd4tCE2pVs0%3D%3Ap1s%2Bcfx44TdHdHkIi8jTCSMlBgDly8e3RvUCeD3hbrc%3D&path=/Documents/Welcome%20to%20Nextcloud%20Hub.docx

Session times-out after 30 minutes

Describe the bug
After 30 minutes, whether it's being used or not, Office Online reports "your session has expired" and you can no longer edit the document. Any edits in the last minute are lost.

This causes chaos when multiple users are working on a document together and they start timing out right after each other.

I can't find a setting in either Office Online or NextCloud to control this.

From the WOPI docs it looks like this is the expected behavior, except it should be using RefreshLock() to extend the work time. That doesn't appear to be happening.

To Reproduce

  1. Open a document.
  2. Wait 30 minutes

Expected behavior
You should be able to keep working until you close the document.

Client details:

  • OS: Any OS
  • Browser Any Browser (tested firefox, opera, safari, and chrome)
  • Version: Any version
  • Device: Any device (failed on desktops and phones)

Server details

CentOS 7, apache 2.24, php 7.3
Windows Server 2016, IIS & Office Online. All recent patches.

Operating system:
CentOS 7, apache 2.24, php 7.3
Windows Server 2016, IIS & Office Online. All recent patches.

Web server:
Apache 2.24
IIS

Database:
MariaDB 10.5

PHP version:
7.3.24

Nextcloud version:
20.0.6

Version of the officeonline app
1.0.2

Version of Office Online server
16.0.10338.20039

Could not find urlsrc in WOPI

Describe the bug
After trying to open the document, got the following error:
Could not find urlsrc in WOPI

To Reproduce
Steps to reproduce the behavior:

  1. Go to install plugin for office online.
  2. Entered the http url
  3. After opening the the document, got the error.
  4. See error

Screenshots
image

Client details:

  • OS: Windows 10
  • Browser - chrome
  • Version 85.0.4183.121
  • Device: desktop

Server details

Operating system:
Ubuntu 18.04.3
Web server:
nginx
Database:
MySQL
PHP version:
7.2
Nextcloud version:
18.0.6
Version of the officeonline app
1.0
Version of Office Online server
2018

Cannot find module '/var/www/nextcloud/apps/officeonline/webpack.js'

Describe the bug
npm run dev failed

To Reproduce
Steps to reproduce the behavior:

Type npm run dev after npm ci

Expected behavior

Not sure what will happen next after typing npm run dev .

Server details

Operating system:
CentOS 7.4.1708

PHP version:
7.2.23

Nextcloud version:
19.0.4

npm 6.14.4

node.js 10.21.0

Logs ` # npm run dev

[email protected] dev /var/www/nextcloud/apps/officeonline
NODE_ENV=development webpack --progress --config webpack.js

/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/cli.js:93
throw err;
^

Error: Cannot find module '/var/www/nextcloud/apps/officeonline/webpack.js'
at Function.Module._resolveFilename (internal/modules/cjs/loader.js:636:15)
at Function.Module._load (internal/modules/cjs/loader.js:562:25)
at Module.require (internal/modules/cjs/loader.js:692:17)
at require (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/node_modules/v8-compile-cache/v8-compile-cache.js:161:20)
at WEBPACK_OPTIONS (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/utils/convert-argv.js:114:13)
at requireConfig (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/utils/convert-argv.js:116:6)
at /var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/utils/convert-argv.js:123:17
at Array.forEach ()
at module.exports (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/utils/convert-argv.js:121:15)
at yargs.parse (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/cli.js:71:45)
at Object.parse (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/node_modules/yargs/yargs.js:576:18)
at /var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/cli.js:49:8
at Object. (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/cli.js:366:3)
at Module._compile (internal/modules/cjs/loader.js:778:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)
at Module.load (internal/modules/cjs/loader.js:653:32)
at tryModuleLoad (internal/modules/cjs/loader.js:593:12)
at Function.Module._load (internal/modules/cjs/loader.js:585:3)
at Module.require (internal/modules/cjs/loader.js:692:17)
at require (internal/modules/cjs/helpers.js:25:18)
at Object. (/var/www/nextcloud/apps/officeonline/node_modules/webpack/bin/webpack.js:156:2)
at Module._compile (internal/modules/cjs/loader.js:778:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)
at Module.load (internal/modules/cjs/loader.js:653:32)
at tryModuleLoad (internal/modules/cjs/loader.js:593:12)
at Function.Module._load (internal/modules/cjs/loader.js:585:3)
at Function.Module.runMain (internal/modules/cjs/loader.js:831:12)
at startup (internal/bootstrap/node.js:283:19)
at bootstrapNodeJSCore (internal/bootstrap/node.js:623:3)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] dev: NODE_ENV=development webpack --progress --config webpack.js
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] dev script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2020-11-16T00_45_32_577Z-debug.log

`

PDF Reading Bug

If Nextcloud PDF viewer (Nextcloud Featured module) and Office Online integration are activated, you will receive an error message when opening the PDF.

Client details:

  • OS: Windows 10, 1909
  • Browser: MS Edge (Chrome based), 87.0.664.75
  • Device: laptop

Server details

  • Operating system: CentOS Linux 8, Linux 4.18.0-193.19.1.el8_2.x86_64
  • Web server: Apache/2.4.37 (centos)
  • Database: MariaDB, 10.2.32
  • PHP version: PHP 7.3.25 (cli) with Zend Engine v3.3.25 and Zend OPcache v7.3.25
  • Nextcloud version: 20.0.4
  • Version of the officeonline app: 1.0.2
  • Version of Office Online server: Office Online Server, 16

Nextcloud log (data/nextcloud.log)

[officeonline] Error: OCP\Files\NotFoundException: /*************/files/****************/******************.pdf at <<closure>>

0. /var/www/html/nextcloud/lib/private/Files/Node/Folder.php line 140
   OC\Files\Node\Root->get("/*********** ... f")
1. /var/www/html/nextcloud/apps/officeonline/lib/Controller/DocumentController.php line 228
   OC\Files\Node\Folder->get("/******** ... f")
2. /var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 169
   OCA\Officeonline\Controller\DocumentController->index("118758", "/************ ... f")
3. /var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 100
   OC\AppFramework\Http\Dispatcher->executeController(OCA\Officeonline ... {}, "index")
4. /var/www/html/nextcloud/lib/private/AppFramework/App.php line 152
   OC\AppFramework\Http\Dispatcher->dispatch(OCA\Officeonline ... {}, "index")
5. /var/www/html/nextcloud/lib/private/Route/Router.php line 308
   OC\AppFramework\App::main("OCA\\Officeonli ... r", "index", OC\AppFramework\ ... {}, {action: null,_r ... "})
6. /var/www/html/nextcloud/lib/base.php line 1008
   OC\Route\Router->match("/apps/officeonline/index")
7. /var/www/html/nextcloud/index.php line 37
   OC::handleRequest()

GET /index.php/apps/officeonline/index?fileId=118758&requesttoken=zjs0HtiKOlUFsDvDggFws3hvyCrL5jZAaWCdadPIk3A%3D%3ApllnRpH4eR1j4GGn2HgT2jEg8AGnkQMpMVWtPKOm9UU%3D&path=/*********/********************.pdf
from **************** by ****************** at 2021-01-08T11:25:14+02:00

Browser log

oos

Enable full screen view or to open on diffrent tab

  1. have an option under the admin settings to select an option to open the file on a different tab "onlyoffice app has this option".
    or

  2. Make the view open in full screen like callobora dose

If dev need a test server to connect ill be more then happy to give you Online office server url.

Web consle error

Please see below image this happens every time i open up a document
21-12-03 22-15-54 6065

Operating system:
Ubuntu 20.04
Web server:
Apache
Database:
MariaDB 10.5.13
PHP version:
8.0.13
Nextcloud version:
23.0.0
Version of the officeonline app
1.1.1
Version of Office Online server
2019

Cannot open files with ampersand in path

Describe the bug
Error when trying to open a file that has an ampersand in the path (either folder or filename). Error message shows the path truncated at the ampersand.

To Reproduce
Steps to reproduce the behavior:

  1. Create a document, spreadsheet, or presentation with an ampersand in the name (or in a folder with an ampersand)
  2. Click the file to open in Office Online
  3. Error message in the editor window, showing path cut off

Expected behavior
File opens in the Office Online editor

Client details:

  • OS: Windows 10
  • Browser: Firefox 78esr, Chrome 87
  • Device: Desktop

Server details

Operating system: CentOS 7

Web server: Nginx

Database: MariaDB

PHP version: 7.4.13

Nextcloud version: 20.0.2.2

Version of the officeonline app 1.0.1

Version of Office Online server 16.0.10338.20039

Logs

Nextcloud log (data/nextcloud.log)

{
	"reqId": "O5xd6R67XRmvvRZxD4Sd",
	"level": 0,
	"time": "2020-12-07T17:16:50+00:00",
	"remoteAddr": "10.0.3.8",
	"user": "admin",
	"app": "officeonline",
	"method": "PROPFIND",
	"url": "/remote.php/dav/files/admin/Test%20%26%20troubleshoot/TestDoc.docx",
	"message": "/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.",
	"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0",
	"version": "20.0.2.2"
}{
	"reqId": "3GQMF5CBs2Fb3i2aHAkH",
	"level": 0,
	"time": "2020-12-07T17:16:51+00:00",
	"remoteAddr": "10.0.3.8",
	"user": "admin",
	"app": "officeonline",
	"method": "GET",
	"url": "/apps/officeonline/index?fileId=3176297&requesttoken=TOKEN&path=/Test%20&%20troubleshoot/TestDoc.docx",
	"message": "/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.",
	"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0",
	"version": "20.0.2.2"
}{
	"reqId": "3GQMF5CBs2Fb3i2aHAkH",
	"level": 3,
	"time": "2020-12-07T17:16:51+00:00",
	"remoteAddr": "10.0.3.8",
	"user": "admin",
	"app": "officeonline",
	"method": "GET",
	"url": "/apps/officeonline/index?fileId=3176297&requesttoken=TOKEN&path=/Test%20&%20troubleshoot/TestDoc.docx",
	"message": {
		"Exception": "OCP\\Files\\NotFoundException",
		"Message": "/admin/files/Test ",
		"Code": 0,
		"Trace": [{
				"file": "/var/www/html/lib/private/Files/Node/Folder.php",
				"line": 140,
				"function": "get",
				"class": "OC\\Files\\Node\\Root",
				"type": "->",
				"args": ["/admin/files/Test "]
			}, {
				"file": "/var/www/html/custom_apps/officeonline/lib/Controller/DocumentController.php",
				"line": 228,
				"function": "get",
				"class": "OC\\Files\\Node\\Folder",
				"type": "->",
				"args": ["/Test "]
			}, {
				"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
				"line": 169,
				"function": "index",
				"class": "OCA\\Officeonline\\Controller\\DocumentController",
				"type": "->",
				"args": ["3176297", "/Test "]
			}, {
				"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
				"line": 100,
				"function": "executeController",
				"class": "OC\\AppFramework\\Http\\Dispatcher",
				"type": "->",
				"args": [{
						"__class__": "OCA\\Officeonline\\Controller\\DocumentController"
					}, "index"]
			}, {
				"file": "/var/www/html/lib/private/AppFramework/App.php",
				"line": 152,
				"function": "dispatch",
				"class": "OC\\AppFramework\\Http\\Dispatcher",
				"type": "->",
				"args": [{
						"__class__": "OCA\\Officeonline\\Controller\\DocumentController"
					}, "index"]
			}, {
				"file": "/var/www/html/lib/private/Route/Router.php",
				"line": 308,
				"function": "main",
				"class": "OC\\AppFramework\\App",
				"type": "::",
				"args": ["OCA\\Officeonline\\Controller\\DocumentController", "index", {
						"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
					}, {
						"action": null,
						"_route": "officeonline.document.index"
					}
				]
			}, {
				"file": "/var/www/html/lib/base.php",
				"line": 1008,
				"function": "match",
				"class": "OC\\Route\\Router",
				"type": "->",
				"args": ["/apps/officeonline/index"]
			}, {
				"file": "/var/www/html/index.php",
				"line": 37,
				"function": "handleRequest",
				"class": "OC",
				"type": "::",
				"args": []
			}
		],
		"File": "/var/www/html/lib/private/Files/Node/Root.php",
		"Line": 205,
		"CustomMessage": "--"
	},
	"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0",
	"version": "20.0.2.2"
}

Browser log

Here are the network requests made by the browser:

PROPFIND http://server.name/remote.php/dav/files/admin/Test%20%26%20troubleshoot/TestDoc.docx
GET http://server.name/apps/officeonline/index?fileId=3176297&requesttoken=TOKEN&path=/Test%20&%20troubleshoot/TestDoc.docx

Each time I open a document, I get added as another co-author

Describe the bug
Every time I close out of a document and re-open it, I get added again as a co-author. It doesn't matter if I click the X or go to File ⇾ exit, I still get added again as an additional co-author every time I open a document. I opened and closed a document and got up to 30 co-authors before it started crashing.

I am also not sure if there is a way to set an idle time or not. I tried waiting 40 minutes, but all the co-authors are still there. I let it run overnight and they did disappear then.

The issue is kind of 2 fold. 1, Nextcloud is not telling Office Online that I am the same user, and 2 - when you close the document, the users are not dropping from the document.

This happens on all document types.

To Reproduce
Steps to reproduce the behavior:

  1. Open a document
  2. Close the document
  3. Reopen the document.

Expected behavior
NextCloud needs to tell Office Online I am the same author, even if I close and reopen the document. ALso, when I do close (or there is a timeout) it should log me out of the document.

Screenshots
image

Client details:

  • OS: Windows 10
  • Browser Chrome
  • Version 86.0.4240.111
  • Device: Desktop

Server details

Operating system:

Web server: Not sure - Using the Hansson IT Nextcloud VM

Database: PostgreSQL 12.4

PHP version: 7.4.3

Nextcloud version: 20.0.1

Version of the officeonline app 1.0

Version of Office Online server
2019

Run 'npm run dev' See error

run 'npm run dev' See error

root@luyaocloud:/var/www/nextcloud/apps/officeonline# npm run dev

[email protected] dev /var/www/nextcloud/apps/officeonline
NODE_ENV=development webpack --progress --config webpack.js
/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/cli.js:93
throw err;
^
Error: Cannot find module '/var/www/nextcloud/apps/officeonline/webpack.js'
at Function.Module._resolveFilename (internal/modules/cjs/loader.js:636:15)
at Function.Module._load (internal/modules/cjs/loader.js:562:25)
at Module.require (internal/modules/cjs/loader.js:692:17)
at require (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/node_modules/v8-compile-cache/v8-compile-cache.js:161:20)
at WEBPACK_OPTIONS (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/utils/convert-argv.js:114:13)
at requireConfig (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/utils/convert-argv.js:116:6)
at /var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/utils/convert-argv.js:123:17
at Array.forEach ()
at module.exports (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/utils/convert-argv.js:121:15)
at yargs.parse (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/cli.js:71:45)
at Object.parse (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/node_modules/yargs/yargs.js:576:18)
at /var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/cli.js:49:8
at Object. (/var/www/nextcloud/apps/officeonline/node_modules/webpack-cli/bin/cli.js:366:3)
at Module._compile (internal/modules/cjs/loader.js:778:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)
at Module.load (internal/modules/cjs/loader.js:653:32)
at tryModuleLoad (internal/modules/cjs/loader.js:593:12)
at Function.Module._load (internal/modules/cjs/loader.js:585:3)
at Module.require (internal/modules/cjs/loader.js:692:17)
at require (internal/modules/cjs/helpers.js:25:18)
at Object. (/var/www/nextcloud/apps/officeonline/node_modules/webpack/bin/webpack.js:156:2)
at Module._compile (internal/modules/cjs/loader.js:778:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)
at Module.load (internal/modules/cjs/loader.js:653:32)
at tryModuleLoad (internal/modules/cjs/loader.js:593:12)
at Function.Module._load (internal/modules/cjs/loader.js:585:3)
at Function.Module.runMain (internal/modules/cjs/loader.js:831:12)
at startup (internal/bootstrap/node.js:283:19)
at bootstrapNodeJSCore (internal/bootstrap/node.js:623:3)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] dev: NODE_ENV=development webpack --progress --config webpack.js
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] dev script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2021-05-20T15_34_32_753Z-debug.log

Server details

Operating system:
Ubuntu20.04 Linux version 5.4.0-72-generic
Web server:
Apache/2.4.41
Database:
MariaDB 10.3.29
PHP version:
7.4.3
Nextcloud version:
21.0.1
Version of Office Online server
Office Online Server 2017

Logs

npm log (/root/.npm/_logs/2021-05-20T15_34_32_753Z-debug.log)

0 info it worked if it ends with ok
1 verbose cli [ '/usr/bin/node', '/usr/bin/npm', 'run', 'dev' ]
2 info using [email protected]
3 info using [email protected]
4 verbose run-script [ 'predev', 'dev', 'postdev' ]
5 info lifecycle [email protected]~predev: [email protected]
6 info lifecycle [email protected]~dev: [email protected]
7 verbose lifecycle [email protected]~dev: unsafe-perm in lifecycle true
8 verbose lifecycle [email protected]~dev: PATH: /usr/share/npm/node_modules/npm-lifecycle/node-gyp-bin:/var/www/nextcloud/apps/officeonline/node_modules/.bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
9 verbose lifecycle [email protected]~dev: CWD: /var/www/nextcloud/apps/officeonline
10 silly lifecycle [email protected]~dev: Args: [ '-c',
10 silly lifecycle   'NODE_ENV=development webpack --progress --config webpack.js' ]
11 silly lifecycle [email protected]~dev: Returned: code: 1  signal: null
12 info lifecycle [email protected]~dev: Failed to exec dev script
13 verbose stack Error: [email protected] dev: `NODE_ENV=development webpack --progress --config webpack.js`
13 verbose stack Exit status 1
13 verbose stack     at EventEmitter.<anonymous> (/usr/share/npm/node_modules/npm-lifecycle/index.js:332:16)
13 verbose stack     at EventEmitter.emit (events.js:198:13)
13 verbose stack     at ChildProcess.<anonymous> (/usr/share/npm/node_modules/npm-lifecycle/lib/spawn.js:55:14)
13 verbose stack     at ChildProcess.emit (events.js:198:13)
13 verbose stack     at maybeClose (internal/child_process.js:982:16)
13 verbose stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:259:5)
14 verbose pkgid [email protected]
15 verbose cwd /var/www/nextcloud/apps/officeonline
16 verbose Linux 5.4.0-72-generic
17 verbose argv "/usr/bin/node" "/usr/bin/npm" "run" "dev"
18 verbose node v10.19.0
19 verbose npm  v6.14.4
20 error code ELIFECYCLE
21 error errno 1
22 error [email protected] dev: `NODE_ENV=development webpack --progress --config webpack.js`
22 error Exit status 1
23 error Failed at the [email protected] dev script.
23 error This is probably not a problem with npm. There is likely additional logging output above.
24 verbose exit [ 1, true ]

Powerpoint: Sorry we ran into a problem. Please try again

Steps to reproduce

  1. Nextcloud add OfficeOnlineServer
  2. create new powerpoint file
  3. or edit a existing

Expected behaviour

open powerpoint editor

Actual behaviour

error message

word and excel works well

see screenshot
officeerrorpowerpoint

Any Ideas?
Please help. seems be a bug in the plugin.
are there anybody using Nextcloud and PPTX from OOS via this Plugin?

Installation of app fails with exception

An exception occurred while executing 'CREATE UNIQUE INDEX rd_wopi_token_idx ON oc_officeonline_wopi (token)': SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "rd_wopi_token_idx" already exists

Nextcloud 18.0.10

Load Time Performance enhancement

When you first open up and document it takes a bit if you open it up again it instant. It would be nice to have that documents open up instant.

30 minutes limit on documents edition

Describe the bug

If a document is left open or being modified for more than 30 minutes we get an error (file not found or accessible, lost lock) and all modifications made after the 30 minutes mark are gone.

To Reproduce
Steps to reproduce the behavior:

  1. Create a new document
  2. Modify or leave it open for 30 minutes
  3. Try to modify it after the 30 minutes mark
  4. See error

Expected behavior
Document should be editable after 30 minutes

Client details:

  • OS: Linux Mint 20, Windows 10
  • Browser Chrome
  • Version 90.0.4430.93
  • Device: desktop

Server details

Operating system:

Nginx 1.19.6
10.5.9-MariaDB
PHP : 7.4.16
Nextcloud 20.0.9
Wopi app 3.5.6

Interface of configurationmenu not loading correctly

Describe the bug
I see a blank screen on the app, the HTML-Code ist:

--   |
  |

To Reproduce
Steps to reproduce the behavior:

  1. Go to Settings
  2. Click on Office Online

Expected behavior
See the settings for online office configruation.

Client details:

  • OS: Windows 10
  • Browser Chrome / Edge
  • Version 85.0.4183.102 / Version 85.0.564.51
  • Device: Webinterface

Server details

Operating system: Centos 7

Web server: Apache

Database: Postgres 9.6

PHP version: PHP 7.2.32

Nextcloud version: 19.0.1

Version of the officeonline app 1.0.0

Version of Collabora Online n/a

Logs

Nextcloud log (data/nextcloud.log)

Insert your Nextcloud log here
none

#### Browser log

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

a) Refused to execute inline script because it violates the following Content Security Policy directive: "script-src 'self'". Either the 'unsafe-inline' keyword, a hash ('sha256-abcdef'), or a nonce ('nonce-...') is required to enable inline execution. officeonline:24

.txt and newly created files

  • .txt file can’t be opened (no problems with .md) -> Exception: Could not find urlsrc in WOPI
  • No more icons next to the office documents in the " + " menu
  • Newly created files can’t be opened “Unable to open file”

Allow limitation to groups

In order to control the necessary licenses of the Office back-end, I'd like to be able to limit the app usage to certain user groups, just as it is possible for a lot of other apps in Nextcloud:

image

Error Sorry could not find the file via mobile browser

Describe the bug
This only happens when opening a word file via mobile browser. I tested it on iphone and had the issue i tested it on ipad did not have an issue. I also do have an issue via pc or mac web browser. I have attached a screen shot and video recording

If dev need a test server to connect ill be more then happy to give you Online office server url.
To Reproduce
Steps to reproduce the behavior:

  1. Open safari or chrome on iphone
  2. Click or create new document

Expected behavior
Should open the file

Screenshots

Untitled.mp4

2021-12-03 12_08_09-21-12-02 21-38-32 6056 jpg ‎- Photos

Server details

Operating system:
Ubuntu 20.04
Web server:
Apache
Database:
MariaDB 10.5.13
PHP version:
8.0.13
Nextcloud version:
23.0.0
Version of the officeonline app
1.1.1
Version of Office Online server
2019

Duplicate index rd_wopi_token_idx

An exception occurred while executing 'CREATE UNIQUE INDEX rd_wopi_token_idx ON oc_officeonline_wopi (token)': SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "rd_wopi_token_idx" already exists

An exception occurred while executing 'CREATE UNIQUE INDEX rd_wopi_token_idx ON oc_richdocuments_wopi (token)': SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "rd_wopi_token_idx" already exists

Hello,

Error: "An exception occurred while executing 'CREATE UNIQUE INDEX rd_wopi_token_idx ON oc_richdocuments_wopi (token)': SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "rd_wopi_token_idx" already exists"

im getting this error while trying to install the App on our Nextcloud.

I have found the other BUG report (#6) related to this error, but i dont see a solution for me and how to install the App Successfully?!

Thanks!"

Office online error

Describe the bug
cURL error 6: Could not resolve host: https://hostname (see http://curl.haxx.se/libcurl/c/libcurl-errors.html)
After trying to open a document.

To Reproduce
Steps to reproduce the behavior:

  1. Go to install plugin for office online.
  2. i entered the https url
  3. after opening the the doc editor i recieved the error above.
  4. See error

Client details:

  • OS: win 10 pro
  • chrome newest version

Server details

Operating system: Ubuntu server 18 lts

Web server: nginx

**Database:**mysql

PHP version: 7.2.24

**Nextcloud version:18.0.3

Version of the officeonline app newest

Version of Office Online server newest

App locks Nextcloud server when Office Online Server is offline

So I noticed today that if the Online Server goes offline the web on the nextcloud will stop responding i was doing some updates on Online Office Server and then i found out that my Nextcloud server stop responding once the Office Online Server was back up then nextcloud started to work.

Desktop client edit shortcut

With Onlyoffice running on a Nextcloud instance, an attached desktop client adds an "edit" shortcut directly into the right-click menu of synchronized office files. On click, the browser opens directly in editing mode.

For MS Office Online however, there is only the standard "Open in browser" item.

I don't know if here is the right place or if this should be handled in the Desktop repo, but the same feature would be great also for MS Office Online.

Missing Document Icons

Screenshots
image

Client details:

  • OS: [e.g. iOS]
  • Browser [e.g. chrome, safari]
  • Version [e.g. 22]
  • Device: [e.g. iPhone6, desktop]

Server details

Operating system:
Web server:
Ubuntu 20.04
Database:
MariaDb
PHP version:
8.0
Nextcloud version:
23.0.0
Version of the officeonline app
1.1.1
Version of Office Online server
2019

App make Nextcloud extremly slow

Steps to reproduce

  1. Install the App
  2. Configure the app by adding the Office Online Server and tick the first option
  3. Click somewhere else

Expected behaviour

Nextcloud is running normal

Actual behaviour

Every click takes minutes until the page is actually loading. As soon as i deactivate the app everything is fine again.

Server configuration

Operating system:

Debian 10

Web server:

Apache/2.4.38

Database:

mariadb Ver 15.1 Distrib 10.3.23-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

PHP version:

PHP 7.3.19-1~deb10u1

Nextcloud version: (see Nextcloud admin page)

19.0.3

Signing status:

Signing status
no errors found

List of activated apps:

App list
Enabled:
  - accessibility: 1.5.0
  - activity: 2.12.0
  - bruteforcesettings: 2.0.1
  - calendar: 2.0.4
  - cloud_federation_api: 1.2.0
  - comments: 1.9.0
  - contacts: 3.4.0
  - contactsinteraction: 1.0.0
  - dav: 1.15.0
  - federatedfilesharing: 1.9.0
  - federation: 1.9.0
  - files: 1.14.0
  - files_external: 1.10.0
  - files_pdfviewer: 1.8.0
  - files_rightclick: 0.16.0
  - files_sharing: 1.11.0
  - files_trashbin: 1.9.0
  - files_versions: 1.12.0
  - files_videoplayer: 1.8.0
  - forms: 2.0.4
  - impersonate: 1.6.1
  - logreader: 2.4.0
  - lookup_server_connector: 1.7.0
  - nextcloud_announcements: 1.8.0
  - notifications: 2.7.0
  - oauth2: 1.7.0
  - password_policy: 1.9.1
  - photos: 1.1.0
  - polls: 1.4.3
  - privacy: 1.3.0
  - provisioning_api: 1.9.0
  - recommendations: 0.7.0
  - serverinfo: 1.9.0
  - settings: 1.1.0
  - sharebymail: 1.9.0
  - support: 1.2.1
  - survey_client: 1.7.0
  - systemtags: 1.9.0
  - text: 3.0.1
  - theming: 1.10.0
  - twofactor_backupcodes: 1.8.0
  - updatenotification: 1.9.0
  - user_ldap: 1.9.0
  - viewer: 1.3.0
  - workflowengine: 2.1.0
Disabled:
  - admin_audit
  - encryption
  - firstrunwizard
  - officeonline

The content of config/config.php:

Config report
{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "nextcloud.fqdn.com"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "19.0.3.1",
        "overwrite.cli.url": "https:\/\/nextcloud.fqdn.com\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "LOGIN",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "ldapIgnoreNamingRules": false,
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
        "ldapUserCleanupInterval": "20",
        "skeletondirectory": "",
        "lost_password_link": "",
        "htaccess.RewriteBase": "\/",
        "log_type": "file",
        "log_rotate_size": 10485760,
        "logtimezone": "Europe\/Berlin",
        "loglevel": 1,
        "theme": "",
        "share_folder": "\/shared_with_me",
        "updater.release.channel": "stable",
        "maintenance": false
    }
}

Are you using external storage, if yes which one: local/smb/sftp/...

smb

Are you using encryption: yes/no

no

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

yes LDAP

Client configuration

Browser:

FireFox 78.2.0 ESR

Operating system:

Windows 10

Logs

Web server error log

Web server error log ``` Nothing ```

Nextcloud log (data/nextcloud.log)

Nextcloud log ``` Nothing ```

Erro when opening existing Files with Officeonline

We are working with NC 21.0.9 and are facing the following Issue with OfficeOnline-App V1.1.3:

All our files are stored on external CIFS-storage.

We can normally creaty new files inside NC with OfficeOnline and work on them. But when we try to open a file that is stored on external-storage that has not been created inside nextcloud, we always get the following error-message:

image

In the log-file we always can see the following messages:

image

I think that the problem could be somehow related to the location, where the file is stored. I usually can solve the problem by copiing the file into another location inside NC and then open it from there. Then after copying it back to original location it can normaly also be opened correctly....

Do you have an idea where the problem could come from?

Thanks
rgl

Error for shared files - Could not find urlsrc in WOPI

Hi,

Describe the bug
We have 3 nextcloud servers.
When i share a file from 1 server to another, and want to open the file on the second i have this error:
"Could not find urlsrc in WOPI"

No problem with opening the local file

Expected behavior
File should be open

Screenshots
image

Client details:

  • OS: windows 10
  • Browser: chrome
  • Version :93
  • Device: desktop

Server details

Operating system: Ubuntu server 20.04

Web server: apache

Database: mysql 10.3.31

PHP version: 7.4.3

Nextcloud version: 22.1.1 & 21.0.4

Version of the officeonline app: 1.1.1 (same problem with 1.0.3)

Version of Office Online server : 16.0.10338.20039

Nextcloud log (data/nextcloud.log)

{"reqId":"Sbxgoa32HnvXRe5vhILP","level":0,"time":"2021-09-28T09:39:44+00:00","remoteAddr":"192.168.1.5","user":"user1","app":"files_sharing","method":"GET","url":"/index.php/apps/officeonline/index?fileId=27370&requesttoken=nYal98j9%2FrozLaDEdMe%2FcMsZDwAAnyGkIKAZL4IqHq4%3D%3A9MvWsrHPm8lkBpmuNqjIQKFoPmZy0VPCZ9lTHuVDTsQ%3D&path=%2Ftest_file%C3%A9%20(2).docx","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36","version":"21.0.4.1"}
{"reqId":"Sbxgoa32HnvXRe5vhILP","level":0,"time":"2021-09-28T09:39:44+00:00","remoteAddr":"192.168.1.5","user":"user1","app":"extract","method":"GET","url":"/index.php/apps/officeonline/index?fileId=27370&requesttoken=nYal98j9%2FrozLaDEdMe%2FcMsZDwAAnyGkIKAZL4IqHq4%3D%3A9MvWsrHPm8lkBpmuNqjIQKFoPmZy0VPCZ9lTHuVDTsQ%3D&path=%2Ftest_file%C3%A9%20(2).docx","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36","version":"21.0.4.1"}
{"reqId":"Sbxgoa32HnvXRe5vhILP","level":3,"time":"2021-09-28T09:39:44+00:00","remoteAddr":"192.168.1.5","user":"user1","app":"officeonline","method":"GET","url":"/index.php/apps/officeonline/index?fileId=27370&requesttoken=nYal98j9%2FrozLaDEdMe%2FcMsZDwAAnyGkIKAZL4IqHq4%3D%3A9MvWsrHPm8lkBpmuNqjIQKFoPmZy0VPCZ9lTHuVDTsQ%3D&path=%2Ftest_file%C3%A9%20(2).docx","message":{"Exception":"Exception","Message":"Could not find urlsrc in WOPI","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/officeonline/lib/TokenManager.php","line":208,"function":"getUrlSrcForFile","class":"OCA\\Officeonline\\WOPI\\Parser","type":"->"},{"file":"/var/www/nextcloud/apps/officeonline/lib/TokenManager.php","line":277,"function":"getToken","class":"OCA\\Officeonline\\TokenManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/officeonline/lib/Service/FederationService.php","line":138,"function":"getRemoteToken","class":"OCA\\Officeonline\\TokenManager","type":"->"},{"file":"/var/www/nextcloud/apps/officeonline/lib/Controller/DocumentController.php","line":238,"function":"getRemoteRedirectURL","class":"OCA\\Officeonline\\Service\\FederationService","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"index","class":"OCA\\Officeonline\\Controller\\DocumentController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/apps/officeonline/lib/WOPI/Parser.php","Line":119,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36","version":"21.0.4.1"}
{"reqId":"Sbxgoa32HnvXRe5vhILP","level":0,"time":"2021-09-28T09:39:44+00:00","remoteAddr":"192.168.1.5","user":"user1","app":"scss_cacher","method":"GET","url":"/index.php/apps/officeonline/index?fileId=27370&requesttoken=nYal98j9%2FrozLaDEdMe%2FcMsZDwAAnyGkIKAZL4IqHq4%3D%3A9MvWsrHPm8lkBpmuNqjIQKFoPmZy0VPCZ9lTHuVDTsQ%3D&path=%2Ftest_file%C3%A9%20(2).docx","message":"SCSSCacher::process ordinary check follows","userAgent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36","version":"21.0.4.1"}
{"reqId":"Sbxgoa32HnvXRe5vhILP","level":0,"time":"2021-09-28T09:39:44+00:00","remoteAddr":"192.168.1.5","user":"user1","app":"scss_cacher","method":"GET","url":"/index.php/apps/officeonline/index?fileId=27370&requesttoken=nYal98j9%2FrozLaDEdMe%2FcMsZDwAAnyGkIKAZL4IqHq4%3D%3A9MvWsrHPm8lkBpmuNqjIQKFoPmZy0VPCZ9lTHuVDTsQ%3D&path=%2Ftest_file%C3%A9%20(2).docx","message":"SCSSCacher::process ordinary check follows","userAgent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36","version":"21.0.4.1"}
{"reqId":"Sbxgoa32HnvXRe5vhILP","level":0,"time":"2021-09-28T09:39:44+00:00","remoteAddr":"192.168.1.5","user":"user1","app":"scss_cacher","method":"GET","url":"/index.php/apps/officeonline/index?fileId=27370&requesttoken=nYal98j9%2FrozLaDEdMe%2FcMsZDwAAnyGkIKAZL4IqHq4%3D%3A9MvWsrHPm8lkBpmuNqjIQKFoPmZy0VPCZ9lTHuVDTsQ%3D&path=%2Ftest_file%C3%A9%20(2).docx","message":"SCSSCacher::process ordinary check follows","userAgent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36","version":"21.0.4.1"}

Thank you

Setup CI with WOPI validator

docker run --network nextcloud_default --add-host nextcloud.dev.local:192.168.21.1 -it --rm tylerbutler/wopi-validator -- -w http://nextcloud.dev.local/index.php/apps/richdocuments/wopi/files/950 -t secret1 -l 0

We couldn't find the file you wanted. It's possible the file was renamed, moved or deleted.

Describe the bug
As soon as I try to open a .xlsx or .docx file I get this error from Microsoft Excel / Word Online:
We couldn't find the file you wanted. It's possible the file was renamed, moved or deleted. // Something Went wrong and we couldn't load this content. Refreshing the browser may fix the problem.

Expected behavior
Microsoft Excel / Word Online is showing the file.

Screenshots
image

Client details:

  • OS: Windows 10 pro 64bit
  • Browser chrome
  • Version 85

Server details

Operating system:Ubuntu

SNAP-Installation (19.03)

Nextcloud version:

Version of the officeonline app
Excel / Word

Version of Office Online server
16.0.10338.20039

Logs #### Browser log a) The javascript console log: [ncchromeconsole.log](https://github.com/nextcloud/officeonline/files/5339942/ncchromeconsole.log)

Restrict group better solution

If you add viewing rights and editing rights other than the Office module then sharing the link will show the Office module not available. For example, wouldn't it be possible to develop it in such a way that those who do not have the right to view and edit it will be shown Nextcloud's own default view?

Can't edit 1 file .docx, you can't edit this document with other people.

Describe the bug
A clear and concise description of what the bug is.
Sorry, you can't edit this document with other people.
Session ID: .......
To Reproduce
Steps to reproduce the behavior:

  1. Go to SMB/CIFS external storage
  2. One file (.docx) has trouble with is issue. others working well.

Expected behavior
Please help me fix this.
I restart nextcloud server and Office Online Server. File lock for editing
Screenshots
If applicable, add screenshots to help explain your problem.
image

Client details:

  • OS: Windows 10
  • Browser [ chrome, edge ]
  • Version
  • Device: windows 10

Server details

**Operating system: Ubuntu 18.4

**Web server: Apache 2.4

**Database: Mariadb 10.3

**PHP version: 7.3

**Nextcloud version: 22.1.1

**Version of the officeonline app : Office Online Integration version: 1.1.1

**Version of Office Online server: Office online server 2019

PDF are opening under ms office

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

  1. Open PDF file

Expected behavior
Should open with pdf viewer

Screenshots
image

Server details

Server details

Operating system:
Web server:
Ubuntu 20.04
Database:
MariaDb
PHP version:
8.0
Nextcloud version:
23.0.0
Version of the officeonline app
1.1.1
Version of Office Online server
2019

External people can't open documents in read-write mode

Observed at c.cn.com (Nextcloud 23.0.0.10)

Steps to reproduce

  1. Share a folder with a office document as public link
  2. Set permissions to "can edit"
  3. Open the link in a browser window where you are not logged in

Result

document can't be opnened

grafik

If I remove the "can edit" open, Collabora Online can open the file in read-only mode.

Expected

external user can open the document and edit it

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.