open-with-web endpoint doesn't open .odt file in the OnlyOffice

[ScharfViktor]

related:

• fix: resolving external URLs via file ID #9833
• [full-ci] url stability. open file through Collabora #10420
• e2e tests for url stability #9897

Steps:

• Make sure you have OnlyOffice and collabora(not running to me) running

• create .odt and .docs file

• open .docs file in OnlyOffice
  paste to url https://host.docker.internal:9200/external/open-with-web?appName=OnlyOffice&fileId=docsFileUuid -works

• open .odt file in OnlyOffice
  paste to url https://host.docker.internal:9200/external/open-with-web?appName=OnlyOffice&fileId=odtFileUuid

Actual: 500 error message: "wopi: neither edit nor view app url found"

wopiLog:

2024-01-30 12:19:29 {"time": "2024-01-30T11:19:29.286", "host": "153ef3529af0", "level": "ERROR", "process": "wopiserver", "module": "cs3iface", "msg": "Exception when uploading file to Reva", "reason": "HTTPSConnectionPool(host='host.docker.internal', port=9200): Max retries exceeded with url: /data (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate (_ssl.c:1007)')))"}
2024-01-30 12:19:29 {"time": "2024-01-30T11:19:29.294", "host": "153ef3529af0", "level": "ERROR", "process": "wopiserver", "module": "wopiutils", "msg": "Error writing file, a copy was stored locally for later recovery", "filename": "d7f16774-d0b8-4020-a2f7-afeddab6903e/New file.docx", "recoveredpath": "/var/spool/wopirecovery/20240130T111929_editedby_d7f16774-d0b8-4020-a2f7-afeddab6903e_origat_d7f16774-d0b8-4020-a2f7-afeddab6903e_New_file.docx", "token": "NwCzVZToMiLsKuhuABZM", "error": "HTTPSConnectionPool(host='host.docker.internal', port=9200): Max retries exceeded with url: /data (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate (_ssl.c:1007)')))"}

testing with wopi https://github.com/owncloud/ocis/blob/master/deployments/examples/ocis_wopi/docker-compose.yml

using web I can open .odt file using collabora or onlyOffice
but I cannot choose fileEditor if I open via link and use param appName=fileEditor

.odt file opens via Collabora even if I set appName=OnlyOffice
.docx file opens via OnlyOffice even if I set appName=collabora

Screen.Recording.2024-01-30.at.12.36.58.mov

cc @JammingBen

[JammingBen]

I think that #11113 fixes this (and owncloud/ocis#9495 will eventually fix it on the server side). Feel free to reopen if the issue persists.