Error when creating document

DmDS commented 4 years ago

Describe the bug Whenever I create a Document, I get following error: Failed to load the document. Please ensure the filetype is supported and not corrupted, and try again.

To Reproduce

You must use https
Try to create new document or table file via the web interface.

Expected behavior The new document should open in Collabora

Screenshots error

Server details

Operating system: Nextcloud: Ubuntu 18.04.4 LTS Collabora: Ubuntu 18.04.4 LTS; Debian GNU/Linux 10 (buster)

Web server: Apache/2.4.29 (cerificates generated by let's encrypt)

Database: mysqld 10.1.44-MariaDB-0ubuntu0.18.04.1

PHP version: PHP 7.2.24, 7.4.6

Nextcloud version: 18.04

Version of the richdocuments app 3.7.0

Version of Collabora Online 4.2.*

Actual behaviour

When I create a new document I get this in logs:

Jun  3 11:39:00 libre30 loolwsd[958]: wsd-00958-00965 2020-06-03 08:39:00.436089 [ websrv_poll ] WRN  FileServerRequestHandler: File not found: Invalid URI request: [/loleaflet/0a581c0e2/branding.css].| wsd/FileServer.cpp:487
Jun  3 11:39:00 libre30 loolwsd[958]: wsd-00958-00965 2020-06-03 08:39:00.716074 [ websrv_poll ] WRN  FileServerRequestHandler: File not found: Invalid URI request: [/loleaflet/0a581c0e2/branding-desktop.css].| wsd/FileServer.cpp:487
Jun  3 11:39:01 libre30 loolwsd[958]: kit-01135-00961 2020-06-03 08:39:01.169664 [ kit_010 ] ERR  Failed to load: file:///user/docs/c1fdgRdboOoWAiSY/sxfgt43ws.docx, error: Unsupported URL <https://*mydomain*/index.php/apps/richdocuments/wopi/template/433?access_token=HHu0zXMQHJGlB9ejpYnVDEqpwnL8Kq0n>: "type detection failed"| kit/Kit.cpp:1725
Jun  3 11:39:01 libre30 loolwsd[958]: kit-01135-00961 2020-06-03 08:39:01.169751 [ kit_010 ] ERR  Failed to get LoKitDocument instance for [file:///user/docs/c1fdgRdboOoWAiSY/sxfgt43ws.docx].| kit/ChildSession.cpp:632
Jun  3 11:39:01 libre30 loolwsd[958]: kit-01135-00961 2020-06-03 08:39:01.169766 [ kit_010 ] ERR  error: cmd=load kind=faileddocloading| ./common/Session.hpp:125
Jun  3 11:39:01 libre30 loolwsd[958]: kit-01135-00961 2020-06-03 08:39:01.169800 [ kit_010 ] WRN  Document::ViewCallback. Session [-1] is no longer active to process [LOK_CALLBACK_ERROR] [{
Jun  3 11:39:01 libre30 loolwsd[958]:     "classification": "error",
Jun  3 11:39:01 libre30 loolwsd[958]:     "cmd": "load",
Jun  3 11:39:01 libre30 loolwsd[958]:     "kind": "network",
Jun  3 11:39:01 libre30 loolwsd[958]:     "code": "0x6b03(Error Area:Inet Class:Read Code:3)",
Jun  3 11:39:01 libre30 loolwsd[958]:     "message": "Server certificate verification failed: issuer is not trusted"
Jun  3 11:39:01 libre30 loolwsd[958]: }
Jun  3 11:39:01 libre30 loolwsd[958]: ] message to Master Session.| kit/Kit.cpp:2025
Jun  3 11:39:01 libre30 loolwsd[958]: wsd-00958-01144 2020-06-03 08:39:01.169884 [ docbroker_010 ] WRN  Document load failed: faileddocloading| wsd/ClientSession.cpp:1127
Jun  3 11:39:01 libre30 loolwsd[958]: kit-01135-00961 2020-06-03 08:39:01.203698 [ kit_010 ] WRN  Skipping unload on incomplete view.| kit/ChildSession.cpp:105
Jun  3 11:39:01 libre30 loolwsd[958]: wsd-00958-01144 2020-06-03 08:39:01.203754 [ docbroker_010 ] WRN  Client session [04f] not found to forward message: o6657 disconnected:| wsd/DocumentBroker.cpp:2123
Jun  3 11:39:03 libre30 loolwsd[958]: wsd-00958-00960 2020-06-03 08:39:03.203958 [ prisoner_poll ] WRN  Prisoner connection disconnected but without valid socket.| wsd/LOOLWSD.cpp:1951
Jun  3 11:39:58 libre30 loolwsd[958]: wsd-00958-00965 2020-06-03 08:39:58.315464 [ websrv_poll ] WRN  FileServerRequestHandler: File not found: Invalid URI request: [/loleaflet/0a581c0e2/branding.css].| wsd/FileServer.cpp:487
Jun  3 11:39:58 libre30 loolwsd[958]: wsd-00958-00965 2020-06-03 08:39:58.544785 [ websrv_poll ] WRN  FileServerRequestHandler: File not found: Invalid URI request: [/loleaflet/0a581c0e2/branding-desktop.css].| wsd/FileServer.cpp:487
Jun  3 11:39:59 libre30 loolwsd[958]: kit-01145-00961 2020-06-03 08:39:59.553171 [ kit_011 ] WRN  Document::ViewCallback. Session [-1] is no longer active to process [LOK_CALLBACK_STATUS_INDICATOR_START] [(nil)] message to Master Session.| kit/Kit.cpp:2025

but edit it again work. tried loolwsd 4.2. and Collabora OfficeDev 6.2-10 to 14 loolwsd 4.1. works correctly i tried reverse proxy: apache, nginx, haproxy if i use http, then documents are creating without errors

Workaround

in ../nextcloud/apps/richdocuments/lib/Controller/WopiController.php comment out this block (lines 213-218. app ver 3.7.0)

/**             if ($wopi->hasTemplateId()) {
                        $templateUrl = 'index.php/apps/richdocuments/wopi/template/' . $wopi->getTemplateId() . '?access_token=' . $wopi->getToken();
                        $templateUrl = $this->urlGenerator->getAbsoluteURL($templateUrl);
                        $response['TemplateSource'] = $templateUrl;
                }*/

BornToBeRoot commented 4 years ago

Same issue on NC 19 / Ubuntu 20.04 / MariaDB

If i open the document again... i can edit the document but i can't save it.

Edit: The document is saved. But the message still appears.

GR0Y commented 4 years ago

hello, some additional elements relating to the (strange) creation of child-roots on this post : https://help.nextcloud.com/t/collabora-new-document-creation-doesn-t-work-but-editing-again-work/81959/4?u=gr0y

juliushaertl commented 4 years ago

Jun 3 11:39:01 libre30 loolwsd[958]: "message": "Server certificate verification failed: issuer is not trusted"

Seems like collabora cannot verify your Nextclouds certificate. That would also explain why it works with http only.

DmDS commented 4 years ago

Seems like collabora cannot verify your Nextclouds certificate. That would also explain why it works with http only.

yes. only when a new document is created. that's strange... curl from collabora server to nextcloud:

 curl -vvI https://nc.gormost.mos.ru
....
* Server certificate:
*  subject: CN=gormost.mos.ru
*  start date: May 28 11:58:29 2020 GMT
*  expire date: Aug 26 11:58:29 2020 GMT
*  subjectAltName: host "nc.gormost.mos.ru" matched cert's "nc.gormost.mos.ru"
*  issuer: C=US; O=Let's Encrypt; CN=Let's Encrypt Authority X3
*  SSL certificate verify ok.

richdocuments v 3.7 and 3.6 have an issue with "disable certificate verification" option. it's not working. i tried v 3.5.3 (disable verification option is working). same error with creating. I tried self-signed certificates on local servers with verification disabled (ver 3.5), tried adding certificates to trusted storage (ver 3.7). I used reverse proxy with enabled and disabled termination. nothing helped except commenting out this block, which seems to be responsible for forming a link to templates or some kind of templates verification... i'm not sure..

Unsupported URL <https://nc.gormost.mos.ru/index.php/apps/richdocuments/wopi/template/433?access_token=HHu0zXMQHJGlB9ejpYnVDEqpwnL8Kq0n>

but without this block in WopiController.php, there are no problems with creating files, and no errors with certificates.

GR0Y commented 4 years ago

to complete, for me the error is not the same. there is no question of a certificate.

     loolwsd[1632]: kit-02307-01645 2020-05-20 09:16:01.179598 [ kit_014 ] ERR  Failed to get LoKitDocument instance for [file:///user/docs/PK5SFRTEtMmOFRja/aaaqqq.odt].| kit/ChildSession.cpp:632
     loolwsd[1632]: kit-02307-01645 2020-05-20 09:16:01.179614 [ kit_014 ] ERR  error: cmd=load kind=faileddocloading| ./common/Session.hpp:125
     loolwsd[1632]: kit-02307-01645 2020-05-20 09:16:01.179655 [ kit_014 ] WRN  Document::ViewCallback. Session [-1] is no longer active to process [LOK_CALLBACK_ERROR] [{
    [ kit_014 ]     "classification": "error",
    server loolwsd[1632]:     "cmd": "load",
    server loolwsd[1632]:     "kind": "network",
    server loolwsd[1632]:     "code": "0x6b03(Error Area:Inet Class:Read Code:3)",
    server loolwsd[1632]:     "message": ""
    server loolwsd[1632]: }

In any case, commenting on this block (wopicontroller.php 213-218) solves the problem.

In addition, i no longer observe a shift in child-roots when creating a new document. the behavior, before commenting it's block :

my observations if it can help:

restart of loolwsd, only one child-roots:

/opt/lool/child-roots/
└── [May 20 15:52]  EStM4jm0SY3FJXsk
    ├── [May 20 15:52]  dev
    ├── [May 20 15:52]  etc
    ├── [May 20 15:52]  lib
    ├── [May 20 15:52]  lib64
    ├── [May 20 15:52]  lo
    ├── [May 20 15:52]  opt
    ├── [May 20 15:52]  tmp
    ├── [May 20 15:52]  user
    ├── [May 20 15:52]  usr
    └── [May 20 15:52]  var

opening an existing file (existing.odt) -> OK:

so creation of a second "child-roots" (9O5r97z9dqGyLaDk) but the file will go into the first "child-roots" (EStM4jm0SY3FJXsk) strange already, why create a second "child-roots" to use the first? but hey it works ...

/opt/lool/child-roots/
├── [May 20 15:58]  9O5r97z9dqGyLaDk
│   ├── [May 20 15:58]  dev
│   ├── [May 20 15:58]  etc
│   ├── [May 20 15:58]  lib
│   ├── [May 20 15:58]  lib64
│   ├── [May 20 15:58]  lo
│   ├── [May 20 15:58]  opt
│   ├── [May 20 15:58]  tmp
│   ├── [May 20 15:58]  user
│   ├── [May 20 15:58]  usr
│   └── [May 20 15:58]  var
└── [May 20 15:52]  EStM4jm0SY3FJXsk
    ├── [May 20 15:52]  dev
    ├── [May 20 15:52]  etc
    ├── [May 20 15:52]  lib
    ├── [May 20 15:52]  lib64
    ├── [May 20 15:52]  lo
    ├── [May 20 15:52]  opt
    ├── [May 20 15:52]  tmp
    ├── [May 20 15:58]  user
        ├── docs
        └── EStM4jm0SY3FJXsk
            └── existing.odt
    ├── [May 20 15:52]  usr
    └── [May 20 15:52]  var

Now creation of a new file and automatic opening in error -> NOK.

when closing the document (existing.odt) the child-roots (EStM4jm0SY3FJXsk) is deleted, remains on (9O5r97z9dqGyLaDk)

/opt/lool/child-roots/
└── [May 20 15:58]  9O5r97z9dqGyLaDk
    ├── [May 20 15:58]  dev
    ├── [May 20 15:58]  etc
    ├── [May 20 15:58]  lib
    ├── [May 20 15:58]  lib64
    ├── [May 20 15:58]  lo
    ├── [May 20 15:58]  opt
    ├── [May 20 15:58]  tmp
    ├── [May 20 15:58]  user
    ├── [May 20 15:58]  usr
    └── [May 20 15:58]  var

Creation of the new document (new.odt) and automatic opening in failure. So already delete the previous child-roots and create a new one (1emvd6MMfKcFXs4L):

/opt/lool/child-roots/
└── [May 20 16:17]  1emvd6MMfKcFXs4L
    ├── [May 20 16:17]  dev
    ├── [May 20 16:17]  etc
    ├── [May 20 16:17]  lib
    ├── [May 20 16:17]  lib64
    ├── [May 20 16:17]  lo
    ├── [May 20 16:17]  opt
    ├── [May 20 16:17]  tmp
    ├── [May 20 16:17]  user
        ├── [May 20 16:17]  autotext
        ├── [May 20 16:17]  basic
        ├── [May 20 16:17]  config
        ├── [May 20 16:17]  database
        ├── [May 20 16:17]  extensions
        └── [May 20 16:17]  gallery

but it can't work, because it will look for it in the old child-root deleted when the new document (new.odt) was created: so here -> "/opt/lool/child-roots/EStM4jm0SY3FJXsk"/user/docs/9O5r97z9dqGyLaDk/new.odt

May 20 16:17:28 server loolwsd[6978]: kit-07063-06980 2020-05-20 14:17:28.940839 [ kit_002 ] ERR  Failed to load: file:///user/docs/9O5r97z9dqGyLaDk/new.odt, error: Unsupported URL <https://nextcloud.example.com/index.php/apps/richdocuments/wopi/template/1531?access_token=J4wdnRSynDf24RDMKXiqUfsRCkqu6cPh>: "type detection failed"| kit/Kit.cpp:1725

so we validate the error in the browser "Failed to load the document. Please ensure the file type is supported and not corrupted, and try again.", we close lool, and we open the file new.odt there a new child-root is created (dmGJytwk9apufiap) but the document is still this time in the previously created child-root (1emvd6MMfKcFXs4L) as it should have been when opened automatically.

/opt/lool/child-roots/
├── [May 20 16:17]  1emvd6MMfKcFXs4L
│   ├── [May 20 16:17]  dev
│   ├── [May 20 16:17]  etc
│   ├── [May 20 16:17]  lib
│   ├── [May 20 16:17]  lib64
│   ├── [May 20 16:17]  lo
│   ├── [May 20 16:17]  opt
│   ├── [May 20 16:17]  tmp
│   ├── [May 20 16:31]  user
        ├── [May 20 16:31]  docs
│           └── [May 20 16:31]  1emvd6MMfKcFXs4L
│               └── [May 20 16:31]  new.odt
│   ├── [May 20 16:17]  usr
│   └── [May 20 16:17]  var
└── [May 20 16:31]  dmGJytwk9apufiap
    ├── [May 20 16:31]  dev
    ├── [May 20 16:31]  etc
    ├── [May 20 16:31]  lib
    ├── [May 20 16:31]  lib64
    ├── [May 20 16:31]  lo
    ├── [May 20 16:31]  opt
    ├── [May 20 16:31]  tmp
    ├── [May 20 16:31]  user
    ├── [May 20 16:31]  usr
    └── [May 20 16:31]  var

DmDS commented 4 years ago

commenting out not just the whole block, but one line 216 solves the problem

$response['TemplateSource'] = $templateUrl;

something is wrong with $templateUrl and i guess this is the value of the variable:

https://*domain*/index.php/apps/richdocuments/wopi/template/433?access_token=HHu0zXMQHJGlB9ejpYnVDEqpwnL8Kq0n

GR0Y commented 4 years ago

commenting out not just the whole block, but one line 216 solves the problem
$response['TemplateSource'] = $templateUrl;
Confirmed !

perkins1724 commented 4 years ago

I was seeing identical issues including:

Jun 3 11:39:01 libre30 loolwsd[958]: "classification": "error", Jun 3 11:39:01 libre30 loolwsd[958]: "cmd": "load", Jun 3 11:39:01 libre30 loolwsd[958]: "kind": "network", Jun 3 11:39:01 libre30 loolwsd[958]: "code": "0x6b03(Error Area:Inet Class:Read Code:3)", Jun 3 11:39:01 libre30 loolwsd[958]: "message": "Server certificate verification failed: issuer is not trusted"

and

v011063 loolwsd[1632]: "cmd": "load", v011063 loolwsd[1632]: "kind": "network", v011063 loolwsd[1632]: "code": "0x6b03(Error Area:Inet Class:Read Code:3)", v011063 loolwsd[1632]: "message": ""

These appear to be symptoms of timeouts in php-fpm processing. I made two changes to resolve: 1) change the nextcloud virus scanner from pointing to the binary to point to the socket. The documentation notes that pointing to the binary can exhibit slow and unreliable performance. 2) fixing the resolv.conf file (/opt/lool/systemplate/etc/resolv.conf) picked up by libreoffice-online. Mine had an incorrect nameserver IP address as the first entry due to an incorrect resolv.conf file on my VPS.

Fixing the php-fpm timeouts fixed this for me. Turning on the slow php-fpm logs helped debug.

joergmschulz commented 4 years ago

not sure - even with good performance and correct resolv.conf I have this error; commenting out line 216 lets me create a doc but it will not have the template. The URL Failed to load: file:///user/docs/KL2CcLPULhXsXwrW/jaja.odt, error: Unsupported URL https://...de/index.php/apps/richdocuments/wopi/template/266543?access_token=...: "type detection failed"| kit/Kit.cpp:1725 does return the correct template document.

This only happens with certain recent CODE versions, like loolwsd 4.2.4 but not with 4.0.4

GR0Y commented 4 years ago

collaboraoffice6.2/inconnu 6.2.10.17-17 amd64 loolwsd/inconnu 4.2.4-6 amd64 richdocuments 3.7.2

I just updated and with the above versions the problem is gone. it is no longer necessary to comment on line 216

joergmschulz commented 4 years ago

where did you get the /inconnu version from?

GR0Y commented 4 years ago

where did you get the /inconnu version from?

it's just the debian branch that provides the package (stable, oldstable, testing, unknown) in this case unknown because I don't use the packages provided by debian

joergmschulz commented 4 years ago

you have a .deb package for loolwsd? Ok....

juliushaertl commented 4 years ago

@joergmschulz https://www.collaboraoffice.com/code/linux-packages/

Could anyone who encountered the issue check if updating to the latest loolwsd solved the issue? Then I'd assume this was some collabora bug with the templatesource handling that got fixed.

joergmschulz commented 4 years ago

I see; I'm using self compliled versions; as said, until something like code 4.0.4 it worked, but I'm still having issues in 4.2.4-6 (lool) and 6.2.17 (core).

DmDS commented 4 years ago

core 6.2.17 lool 4.2.4-6 issue is present....

GR0Y commented 4 years ago

core 6.2.17 lool 4.2.4-6 issue is present....

@DmDS weird, have you updated your loolwsd.xml with the new settings for this version? it's the only thing I did except update. (core+lool+richdocument) try to compare with the "loolwsd.xml.dpkg-dist", as far as I'm concerned I add a few lines ... I don't know which ones anymore.

joergmschulz commented 4 years ago

the lines concerning certificate locations had to be duplicated to another place, yes.

joergmschulz commented 4 years ago

@juliushaertl latest version: just compiled 4.2.5-1 but the same here. The combo of 6.2-17 and 4.2.5.1 seems to work nicely otherwise; only the creation of documents using a template doesn't work.

DmDS commented 4 years ago

core 6.2.17 lool 4.2.5-1 same error when creating new document (compiled from sources)

joergmschulz commented 4 years ago

just saw this: https://git.libreoffice.org/core/+/459134ea842ad8238ab3c4efffef26843a3853c9 / does this ring a bell?

joergmschulz commented 4 years ago

had some minutes to try the latest LOOL master. Same issue here, but other than that the 7,0 version seems to work fine. Failed to load: file:///user/docs/QqPuVr2B2XGJ9Agw/lo-seven.odt, error: Unsupported URL <https://nctest.somewhere.de/index.php/apps/richdocuments/wopi/template/266543?access_token=blablabla>: "type detection failed" /opt/libreoffice/framework/source/loadenv/loadenv.cxx:190| kit/Kit.cpp:1725 kit-24543-24513 2020-07-07 21:33:17.760630 [ kit_003 ] ERR Failed to get LoKitDocument instance for [file:///user/docs/QqPuVr2B2XGJ9Agw/lo-seven.odt].| kit/ChildSession.cpp:632 kit-24543-24513 2020-07-07 21:33:17.760648 [ kit_003 ] ERR error: cmd=load kind=faileddocloading| ./common/Session.hpp:125 kit-24543-24513 2020-07-07 21:33:17.760698 [ kit_003 ] WRN Document::ViewCallback. Session [-1] is no longer active to process [LOK_CALLBACK_ERROR] [{ "classification": "error", "cmd": "load", "kind": "network", "code": "0x6b03(Error Area:Inet Class:Read Code:3)", "message": "Server certificate verification failed: issuer is not trusted" }

I'm pretty sure the certificate works otherwise: curl (above URL) --output 1.bin from the OO machine: file 1.bin --> 1.bin: OpenDocument Text Template

do the processes in the jails lack ca-certificates????

Chadarius commented 4 years ago

Your work around fixed the problem for me. I commented out the following

/**             if ($wopi->hasTemplateId()) {
                        $templateUrl = 'index.php/apps/richdocuments/wopi/template/' . $wopi->getTemplateId() . '?access_token=' . $wopi->getToken();
                        $templateUrl = $this->urlGenerator->getAbsoluteURL($templateUrl);
                        $response['TemplateSource'] = $templateUrl;
                }*/

ti-guru commented 4 years ago

commenting out not just the whole block, but one line 216 solves the problem
$response['TemplateSource'] = $templateUrl;
something is wrong with $templateUrl and i guess this is the value of the variable:
https://*domain*/index.php/apps/richdocuments/wopi/template/433?access_token=HHu0zXMQHJGlB9ejpYnVDEqpwnL8Kq0n

Just adding to this: After commenting out line 216 as per your suggestion I'm able to create documents, spreadsheets and presentations in the browser. However, when trying to create spreadsheets and presentations through the android app Richdocuments defaults to creating documents. I'm running Nextcloud 19.0.0 (PHP 7.4) with Richdocuments 3.7.3 and Loolwsd 4.2.5-6 on separate subdomains (cloud.mydomain.tld and office.mydomain.tld) in LXD containers (ubuntu 20.04 images) with nginx 1.17.10 reverse proxy doing SSL termination.

GR0Y commented 4 years ago

I just updated, and the problem seems to be definitely gone to me.

Debian 10.4
nginx/stable 1.19.1-1~buster amd64
collaboraoffice6.2/inconnu 6.2.10.20-20 amd64
loolwsd/inconnu 4.2.5-6 amd64
nextcloud 18.0.7
richdocuments 3.7.3

For those who still have problems, the only thing that could still differ with you from my case would be the loolwsd.xml that I had updated with the new settings in 4.2.4-6. I haven't changed anything at this level in 4.2.5-6. if it helps try to compare with mine : my_loolwsd.xml.txt

juliushaertl commented 4 years ago

Everyone please check if this is still an issue with the latest loolwsd version, as I highly suspect this was a bug in Collabora when it was trying to fetch the template with the new TemplateSource mechanism.

joergmschulz commented 4 years ago

which loolwsd version would you suggest to test? All I have tested until a week ago, including master, have failed.

Chadarius commented 4 years ago

I just upgraded to

loolwsd/unknown,now 4.2.5-6 amd64 [installed]

It did not change the WopiController.php where I commented out the "if ($wopi->hasTemplateId())" section. When I added that section back in I still had the problem. Commenting out that section allowed me to create documents from a template again without error.

On Mon, Jul 27, 2020 at 7:13 AM joergmschulz notifications@github.com wrote:

which loolwsd version would you suggest to test? All I have tested until a week ago, including master, have failed.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/nextcloud/richdocuments/issues/1014#issuecomment-664359185, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJ3HEBR5L6NM3Q4PERAD53R5VVNZANCNFSM4NR5IF7Q .

-- Regards, Chad Sutton

joergmschulz commented 4 years ago

allowed me to create documents from a template again without error.

did the content of the template show up in the new document?

Chadarius commented 4 years ago

No. I only get a blank document when I have those lines commented out

On Mon, Jul 27, 2020 at 2:41 PM joergmschulz notifications@github.com wrote:

allowed me to create documents from a template again without error.

did the content of the template show up in the new document?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/nextcloud/richdocuments/issues/1014#issuecomment-664598846, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJ3HEHC3IXZNPFZPE5KUYDR5XJ63ANCNFSM4NR5IF7Q .

-- Regards, Chad Sutton

joergmschulz commented 4 years ago

loolwsd 4-2-4 and core 6.2.4-20 don't work any better. @timar would you have an idea?

juliushaertl commented 4 years ago

I'm still wondering about the error message as the url should definitely be ok to obtain the template.

 Failed to load: file:///user/docs/QqPuVr2B2XGJ9Agw/lo-seven.odt, error: Unsupported URL <https://nctest.somewhere.de/index.php/apps/richdocuments/wopi/template/266543?access_token=blablabla>: "type detection failed" /opt/libreoffice/framework/source/loadenv/loadenv.cxx:190| kit/Kit.cpp:1725 kit-24543-24513 2020-07-07 21:33:17.760630 [ kit_003 ] ERR Failed to get LoKitDocument instance for [file:///user/docs/QqPuVr2B2XGJ9Agw/lo-seven.odt].| kit/ChildSession.cpp:632 kit-24543-24513 2020-07-07 21:33:17.760648 [ kit_003 ] ERR error: cmd=load kind=faileddocloading| ./common/Session.hpp:125 kit-24543-24513 2020-07-07 21:33:17.760698 [ kit_003 ] WRN Document::ViewCallback. Session [-1] is no longer active to process [LOK_CALLBACK_ERROR] [{ "classification": "error", "cmd": "load", "kind": "network", "code": "0x6b03(Error Area:Inet Class:Read Code:3)", "message": "Server certificate verification failed: issuer is not trusted" }

juliushaertl commented 4 years ago

Ah

Server certificate verification failed: issuer is not trusted

Could all of you check if they can properly connect back to the Nextcloud server from your Collabora host with curl and don't get a certificate error there?

GR0Y commented 4 years ago

it's ok for me but but in my case I never had an explicit certificate error. my old error :

     loolwsd[1632]: kit-02307-01645 2020-05-20 09:16:01.179598 [ kit_014 ] ERR  Failed to get LoKitDocument instance for [file:///user/docs/PK5SFRTEtMmOFRja/aaaqqq.odt].| kit/ChildSession.cpp:632
     loolwsd[1632]: kit-02307-01645 2020-05-20 09:16:01.179614 [ kit_014 ] ERR  error: cmd=load kind=faileddocloading| ./common/Session.hpp:125
     loolwsd[1632]: kit-02307-01645 2020-05-20 09:16:01.179655 [ kit_014 ] WRN  Document::ViewCallback. Session [-1] is no longer active to process [LOK_CALLBACK_ERROR] [{
    [ kit_014 ]     "classification": "error",
    server loolwsd[1632]:     "cmd": "load",
    server loolwsd[1632]:     "kind": "network",
    server loolwsd[1632]:     "code": "0x6b03(Error Area:Inet Class:Read Code:3)",
    server loolwsd[1632]:     "message": ""
    server loolwsd[1632]: }

joergmschulz commented 4 years ago

see above: curl (above URL) --output 1.bin from the OO machine: file 1.bin --> 1.bin: OpenDocument Text Template This means that curl can access the file, and the command file recognizes it as template. No error on nextcloud side so far as I see. would there be a possibility to do the same from inside that jail?

By the way: when I try to open a template file from nc, file type is unknown as well - maybe we have a mimetype issue?

Chadarius commented 4 years ago

I don't see any SSL errors. The only errors I see with the original code are as follows. Jul 28 13:41:39 nextcloud loolwsd[27937]: kit-28128-27940 2020-07-28 18:41:39.457416 [ kit_spare_004 ] ERR mknod(/opt/lool/child-roots/bVNdgNjfTOyQimHu//dev/random) failed. Mount must not use nodev flag. (EPERM: Operation not permitted)| kit/Kit.cpp:2574 Jul 28 13:41:39 nextcloud loolwsd[27937]: kit-28128-27940 2020-07-28 18:41:39.457465 [ kit_spare_004 ] ERR mknod(/opt/lool/child-roots/bVNdgNjfTOyQimHu//dev/random) failed. Mount must not use nodev flag. (EPERM: Operation not permitted)| kit/Kit.cpp:2581 Jul 28 13:43:23 nextcloud loolwsd[27937]: wsd-27937-28122 2020-07-28 18:43:23.860649 [ docbroker_003 ] ERR Doc [/index.php/apps/richdocuments/wopi/files/95175_ocjucjqh0oyn] is taking too long to load. Will kill process [28121]. per_document.limit_load_secs set to 100 secs.| wsd/DocumentBroker.cpp:334

Chadarius commented 4 years ago

So I think those nodev flag errors are because of my Proxmox server. I think I need to make that container privileged instead of unprivileged and that will go away.

joergmschulz commented 4 years ago

Just tried out the most recent libreoffice master from https://groupoffice.readthedocs.io/en/latest/install/extras/libreoffice-online.html. No change here. But, with the official CODE image it works completely correctly (4.2.6 / 6.2.21). So it is NOT a richdocuments issue, but some LO issue. You can close this one here, I'm afraid as nobody will give support to any unsupported selfcompiled LO versions.

ryba84 commented 3 years ago

This same problem with CODE 6.4.2-3 and Collabora Online 3.7.11. When creating new document it can't be opened. Closing and opening newly created file works normal. In CODE server logs:

Dec 29 06:34:55 ool loolwsd[1892]: wsd-01892-04026 2020-12-29 05:34:55.826687 [ docbroker_049 ] WRN link("/tmp/convert-to/tmp1892mbaaaa/callback:", "/opt/lool/child-roots/Rggh8NK1Vc17iTMW/tmp/user/docs/Rggh8NK1Vc17iTMW/callback:") failed. Will copy. Linking error: EXDEV Invalid cross-device link| wsd/Storage.cpp:344

Dec 29 06:34:56 ool loolwsd[1892]: kit-04027-01898 2020-12-29 05:34:56.131105 [ kitbroker_04a ] ERR Failed to load: file:///tmp/user/docs/85N20uhYIPKBFfIc/tyu.ods, error: Unsupported URL https://cloud.xxx.yyy.com/index.php/apps/richdocuments/wopi/template/198203?access_token=gyHhyhqsMIFwzGrmZfrPxq45RA8JPiwG: "type detection failed"| kit/Kit.cpp:1200

Dec 29 06:34:56 ool loolwsd[1892]: kit-04027-01898 2020-12-29 05:34:56.131234 [ kitbroker_04a ] ERR error: cmd=load kind=faileddocloading| ./common/Session.hpp:136

Dec 29 06:34:56 ool loolwsd[1892]: wsd-01892-04042 2020-12-29 05:34:56.131338 [ docbroker_04a ] WRN Document load failed: faileddocloading| wsd/ClientSession.cpp:1175

Dec 29 06:34:56 ool loolwsd[1892]: kit-04027-01898 2020-12-29 05:34:56.131489 [ kitbroker_04a ] ERR Failed to get LoKitDocument instance for [file:///tmp/user/docs/85N20uhYIPKBFfIc/tyu.ods].| kit/ChildSession.cpp:634

Dec 29 06:34:56 ool loolwsd[1892]: kit-04027-01898 2020-12-29 05:34:56.131530 [ kitbroker_04a ] WRN Document::ViewCallback. Session [-1] is no longer active to process [LOK_CALLBACK_ERROR] [{

Dec 29 06:34:56 ool loolwsd[1892]: "classification": "error",

Dec 29 06:34:56 ool loolwsd[1892]: "cmd": "load",

Dec 29 06:34:56 ool loolwsd[1892]: "kind": "network",

Dec 29 06:34:56 ool loolwsd[1892]: "code": "0x6c05(Error Area:Inet Class:Write Code:5)",

Dec 29 06:34:56 ool loolwsd[1892]: "message": ""

Dec 29 06:34:56 ool loolwsd[1892]: }

Dec 29 06:34:56 ool loolwsd[1892]: ] message to Master Session.| kit/Kit.cpp:1522

Dec 29 06:34:56 ool loolwsd[1892]: wsd-01892-04042 2020-12-29 05:34:56.220014 [ docbroker_04a ] WRN Client session [314] not found to forward message: o13983 disconnected:| wsd/DocumentBroker.cpp:2259

Dec 29 06:34:56 ool loolwsd[1892]: kit-04027-01898 2020-12-29 05:34:56.220101 [ kitbroker_04a ] WRN Skipping unload on incomplete view.| kit/ChildSession.cpp:106

Dec 29 06:34:58 ool loolwsd[1892]: wsd-01892-01897 2020-12-29 05:34:58.220948 [ prisoner_poll ] WRN Prisoner connection disconnected but without valid socket.| wsd/LOOLWSD.cpp:2072

Proxy ssl termination enabled in loolwsd.xml. Commenting out line 220 in apps/richdocuments/lib/Controller/WopiController.php work aroud problem.

DmDS commented 3 years ago

Proxy ssl termination enabled in loolwsd.xml. Commenting out line 220 in apps/richdocuments/lib/Controller/WopiController.php work aroud problem.

but you cant use templates with this workaround. the soution is to compile CODE with this option: with-webdav=serf

https://github.com/husisusi/officeonlin-install.sh/issues/188#issuecomment-726060015

nextcloud / richdocuments