TrueNAS SCALE + Nextcloud + Collabora

stavros-k

Patron
Joined
Dec 26, 2020
Messages
231
Last thing ... I almost forgot ... I need to get DDNS working because the server is behind my home internet. I saw there is a ddns-updater app available which works with Cloudflare. I found the documentation here https://github.com/qdm12/ddns-updater#setup. Has anyone set this up before and are there any pointers/tips which would be good to know?

(BTW: when I am done with all this I intend to write up a shiny How-To :smile:)
We recently added cloudfrareddns app :) It should also have example docs in our website.

If you need more help, please contact us (TrueCharts) at our discord server.
As we don't visit this forums frequently
 

eab

Dabbler
Joined
Jul 4, 2022
Messages
12
We recently added cloudfrareddns app :) It should also have example docs in our website.

If you need more help, please contact us (TrueCharts) at our discord server.
As we don't visit this forums frequently
I guess you are referring to this? https://artifacthub.io/packages/helm/truecharts/cloudflareddns/0.0.1
I'm also assuming I need to add the https://library-charts.truecharts.org/ Catalog in TNS? If correct, what do I enter as the 'Preferred train' and 'Branch' for this Catalog?
 

stavros-k

Patron
Joined
Dec 26, 2020
Messages
231
I guess you are referring to this? https://artifacthub.io/packages/helm/truecharts/cloudflareddns/0.0.1
I'm also assuming I need to add the https://library-charts.truecharts.org/ Catalog in TNS? If correct, what do I enter as the 'Preferred train' and 'Branch' for this Catalog?

Please reach to our discord. Most of your questions are a search away there :)
 

indivision

Guru
Joined
Jan 4, 2013
Messages
806
Last thing ... I almost forgot ... I need to get DDNS working because the server is behind my home internet. I saw there is a ddns-updater app available which works with Cloudflare. I found the documentation here https://github.com/qdm12/ddns-updater#setup. Has anyone set this up before and are there any pointers/tips which would be good to know?

(BTW: when I am done with all this I intend to write up a shiny How-To :smile:)

Good to hear that you got the major components working.

There are many different ways to set up DDNS. Check to see if your router has this ability built in. Then, you can connect that to a service like dnsomatic.com to update one or more servers as needed.
 

rokyo

Dabbler
Joined
May 12, 2023
Messages
11
I'm not sure if I should open a new thread or use this one, since I have a similar problem as the original one reported here, just that I'm not using TrueCharts or external domains or anything fancy. I'm just trying to get the Collabora app to work with the NextCloud app on my TrueNAS Scale in my local LAN.

I have TrueNAS Scale 22.12.2 installed and from the apps section, I installed NextCloud 26.0.1_1.6.26 and Collabora 21.11.4.1.1_1.2.12 with default options. Now, when I click the "Web Portal" option on either one, I can login and everything is fine. But if I try to use the Collabora app as the Collabora server for the NextCloud app (via the admin settings -> NextCloud office) and simply put in the IP address that Collabora is available on, it says it's not able to connect. Do I need the entire certificate, Cloudflare, reverse proxy, etc stuff if I just want to use everything on my local LAN with plain old IP addresses to access everything? I read the threads at https://www.truenas.com/community/t...ollabora-integration.83889/page-2#post-652465 and https://www.truenas.com/community/resources/nextcloud-and-collabora-integration.140/ but both refer at several points to options and menus that no longer exist in the new version of SCALE that I'm using.

Any chance I can use these two apps together without registering/making accounts at several different external sites (i.e. cloudflare, let's encrypt, etc)?
 

rokyo

Dabbler
Joined
May 12, 2023
Messages
11
Okay wow, I followed exactly this guide: https://www.youtube.com/watch?v=dpZurFVxh4c and the only thing that was missing for it to find the Collabora server was "https://" in front of the IP.... :D

In case anyone runs into this problem again in the future.

However, even though the Collabora server is now found in NextCloud -> admin settings -> NextCloud office with green checkmark and everything, creating or editing office documents still does not work. If I create a new presentation (like in the YouTube tutorial) or try to open the existing demo document under "Documents -> Welcome to NextCloud Hub.docx", only a completely blank screen is shown.

When I now go back to "administrator settings", the option "NextCloud office" now only reads "Office" (literaly minutes before it read "NextCloud office" and now shows a red X with the error message that "Collabora Online should use the same protocol as the server installation", I assume HTTPS?

If I just click "save" beside the field with the Collabora URL again at this point, the red X goes away, the green checkmark comes back and a message pops up that reads:

Collabora Online should use the same protocol as the server installation, check settings "ssl.enable" und "ssl.termination" of your Collabora Online Servers. (roughly translated from German).

Checkmark stays green, though, and editing/creating documents still gives the blank screen.
The Web Portal of the Collabora app shows zero activity.

Any ideas what I'm doing wrong? :-(
 

rokyo

Dabbler
Joined
May 12, 2023
Messages
11
Found the ssl.enable and ssl.termination options in the Collabora app setting, they are set to ssl.enable=false and ss.termination=true. If I change ssl.enable=true, Collabora app restarts and hangs with the error message: "Failed to initialize COOLWSD: File not found: /etc/coolwsd/ca-chain.cert.pem"
 

rokyo

Dabbler
Joined
May 12, 2023
Messages
11
The logs show this the moment I click on any document:

```
2023-05-13 07:40:19.840470+00:00172.16.0.1 - - [13/May/2023:07:40:19 +0000] "GET /status.php HTTP/1.1" 200 1843 "-" "kube-probe/1.25"
2023-05-13 07:40:19.841405+00:00172.16.0.1 - - [13/May/2023:07:40:19 +0000] "GET /status.php HTTP/1.1" 200 1843 "-" "kube-probe/1.25"
2023-05-13 07:40:19.858820+00:00192.168.0.192 - - [13/May/2023:07:40:19 +0000] "POST /apps/text/session/sync HTTP/1.1" 200 1558 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36"
2023-05-13 07:40:20.324963+00:00192.168.0.192 - - [13/May/2023:07:40:20 +0000] "PUT /ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json HTTP/1.1" 200 976 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36"
2023-05-13 07:40:21.267731+00:00192.168.0.192 - - [13/May/2023:07:40:21 +0000] "PROPFIND /remote.php/dav/files/admin/test2.odp HTTP/1.1" 207 1400 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36"
2023-05-13 07:40:21.589545+00:00192.168.0.192 - - [13/May/2023:07:40:21 +0000] "GET /apps/richdocuments/index?fileId=222&requesttoken=HA4Fd3FBBLW06Vf2bwJpehSdOCFUgAfRrnwA0iTbrVo%3D%3ASXpxHzYHXeXRnD2nCHVbOVr1cRQ%2Fz0SmxC94mhSRzxY%3D&path=%2Ftest2.odp HTTP/1.1" 200 12560 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36"
2023-05-13 07:40:22.434508+00:00192.168.0.192 - - [13/May/2023:07:40:22 +0000] "GET /apps/terms_of_service/terms HTTP/1.1" 200 2431 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36"
2023-05-13 07:40:23.161163+00:00192.168.0.192 - - [13/May/2023:07:40:23 +0000] "GET /cron.php HTTP/1.1" 200 916 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36"
2023-05-13 07:40:29.859683+00:00172.16.0.1 - - [13/May/2023:07:40:29 +0000] "GET /status.php HTTP/1.1" 200 1843 "-" "kube-probe/1.25"
2023-05-13 07:40:29.859765+00:00172.16.0.1 - - [13/May/2023:07:40:29 +0000] "GET /status.php HTTP/1.1" 200 1839 "-" "kube-probe/1.25"
2023-05-13 07:40:30.939043+00:00192.168.0.192 - - [13/May/2023:07:40:30 +0000] "POST /apps/text/session/push HTTP/1.1" 200 849 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36"
```

and the URL where the blank screen is then shown is `http://192.168.0.184:9001/apps/files/?dir=/&fileid=2`

Don't know, I don't see any errors in the logs, only relevant lines seem to be:

```
2023-05-13 07:40:21.267731+00:00192.168.0.192 - - [13/May/2023:07:40:21 +0000] "PROPFIND /remote.php/dav/files/admin/test2.odp HTTP/1.1" 207 1400 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36"
2023-05-13 07:40:21.589545+00:00192.168.0.192 - - [13/May/2023:07:40:21 +0000] "GET /apps/richdocuments/index?fileId=222&requesttoken=HA4Fd3FBBLW06Vf2bwJpehSdOCFUgAfRrnwA0iTbrVo%3D%3ASXpxHzYHXeXRnD2nCHVbOVr1cRQ%2Fz0SmxC94mhSRzxY%3D&path=%2Ftest2.odp HTTP/1.1" 200 12560 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36"
```
 

rokyo

Dabbler
Joined
May 12, 2023
Messages
11
There is an option to disable https verification on the Nextcloud admin settings.

Did you turn that on?
Also, did you enter the port of your Collabora server behind the IP in admin settings?

In "System Settings" -> "General" -> "GUI" you mean? That looks like this in my config:

GUI_settings.png


In the NextCloud -> Admin Settings -> Office dialog it reads:


In the Collabora app, it also says port 9980.

I tried without the Web Interface HTTP -> HTTPS Redirect, didn't change the behaviour :(
 

victort

Guru
Joined
Dec 31, 2021
Messages
973

victort

Guru
Joined
Dec 31, 2021
Messages
973
In the NextCloud setting inside the NextCloud app or in TrueNAS?
In the Nextcloud app.

It’s called Disable Certificate Verification (insecure)
 
Last edited:

rokyo

Dabbler
Joined
May 12, 2023
Messages
11
In the Nextcloud app.

It’s called Disable Certificate Verification (insecure)
I definitely remember that option in the "NextCloud -> Admin settings -> Office" settings under the field where I can input the IP of the Collabora server. That was activated, yes.

However, right now I can't even log in to Nextcloud because after clicking on "Web Portal" button in TrueNAS, the login page takes 3 minutes to load and then immediately displays error message "We have detected multiple invalid login attempts from your IP...." without even giving me the chance to input username and password. If I DO input username and password and click login again, the same thing happens (3 minutes of loading, then "multiple invalid login").

No idea why this is suddenly happening, didn't change anything since last login yesterday. :rolleyes:
 

victort

Guru
Joined
Dec 31, 2021
Messages
973
There are 2 apps in the Nextcloud App Store. One is called Office Online Integration, and the other is called Nextcloud Office.

Have you tried with both of these?
Which one are you currently using?
 

rokyo

Dabbler
Joined
May 12, 2023
Messages
11
Okay, I got it working by re-installing both Collabora and NextCloud in TrueNAS and wiping all datasets associated with the two. Now NextCloud finds the Collabora server and uses it and editing documents works fine. Only thing that is now no longer working is changing the admin password for Nextcloud for some reason. Weird stuff but the main thing now working!
 
Top