\/config\/config.php<\/code>)<\/li>- If you move the folder<\/a>, you have to edit the database and root location paths in
\/config\/config.php<\/code><\/li>- Need to setup MySQL first. Avoid PostgreSQL option as it does not work out of the box.<\/li>
- Disable sqlite3 PHP extension<\/li>
- If installed on shared hosting, install without<\/strong> featured app because it will install CODE which is a can or worms.<\/li>
- Collabora Online is a can of worms. See below<\/li><\/ul>\n\n\n\n
\n\n\n\nCollabora Online (LibreOffice engine to edit documents live on web browsers) require special handling:<\/p>\n\n\n\n
- There’s a free community edition called CODE (Collabora Online Development Edition)<\/li>
- Do NOT install the BUILT-IN<\/strong> CODE server<\/span> Nextcloud App if you NextCloud is on a shared hosting because this will appear as a rogue app that slows Nextcloud to a crawl, exhausting entry processes (aka concurrent Apache requests), and still it’ll timeout opening a document. Probably malfunctioning due to some permission issues on shared hosting. <\/li><\/ul>\n\n\n\n
Ports that need to be opened (more accurately port-forwarded to the CODE server) for Collabora: <\/p>\n\n\n\n
- 443 (HTTPS)<\/li><\/ul>\n\n\n\n
Turns out port 80 (HTTP that starts with Univention administration interface) is not necessary. It just redirects to port 443 (HTTPS) if you forgot to type the URL starting with https<\/strong>:\/\/<\/code> (it’s http:\/\/<\/code> by default when you type in the address bar of your browser). <\/p>\n\n\n\nSince the URL of Collabora Online-server in NextCloud settings uses only HTTPS and a HTTP URL is going to be redirected to HTTPS anyway, don’t bother with forwarding Port 80 (HTTP) and enter https<\/strong>:\/\/<\/code> in the Collabora Online-server URL instead.<\/p>\n\n\n\nYou don’t need to forward 9980 (WOPI) either. Somebody mentioned it in Nextcloud forum but that’s not the cause. <\/p>\n\n\n\n
\n\n\n\nWell, the next part is the hairiest. Turns out even the Collabora server checks out with NextCloud, the documents won’t open (some weird error messages):<\/p>\n\n\n\n
The webpage at https:\/\/<Collabora Server>\/loleaflet\/23e6a73\/loleaflet.html?WOPISrc=https%3A%2F%2F<Collabora Server>%2Findex.php%2Fapps%2Frichdocuments%2Fwopi%2Ffiles%2F2180_octqxsu7tnwz&title=<Filename of document to edit>&lang=en&closebutton=1&revisionhistory=1 might be temporarily down or it may have moved permanently to a new web address.\n\nOf course, substitute <Collabora Server> and <Filename of document to edit> with your scenario.<\/code><\/pre>\n\n\n\nI tried going to https:\/\/<Collabora Server><\/code> and noticed this NET::ERR_CERT_AUTHORITY_INVALID<\/code> error:<\/p>\n\n\n\n![\"\"](\"https:\/\/wonghoi.humgar.com\/blog\/wp-content\/uploads\/2021\/03\/image-23.png\")
<\/figure>\n\n\n\nTurns out given my server do not have the SSL certificate installed yet (and I got around it by “Disable certificate verification” in Collabora Online setup), my users\/clients has to manually visit the Collabora (NOT NextCloud) server and click through the security warning to accept the Collabora site that do not have a valid SSL certificate. After that the Collabora Online works properly!<\/p>\n\n\n\n
In other words, if you run into certificate issues with Collabora server, NextCloud won’t tell you when it calls Collabora server (with REST API) to open the document, instead it’ll just appear as a fail HTTPS call without warning or giving you a chance to correct the certificate issue.<\/p>\n
<\/div>