Fresh install of AIO; Could not establish connection to the Collabora Online server. curl timeout for /hosting/discovery

[terminat0r]

Nextcloud version: Docker All in One 30
Operating system and version: Debian 12
Apache or nginx version: Apache/2.4.62
PHP version (eg, 8.3): 8.2.23

The issue you are facing:

My NextCloud instance mostly works except for Collabora
When I navigate to the Office settings in the NC admin
/settings/admin/richdocuments
I receive the following error:

I was able to determine that the issue is that the nextcloud-aio-nextcloud container can not reach 443 on the nextcloud-apache-nextcloud container if my domain name resolves to my public IP.

If I add the apache local ip to the nextcloud-aio-nextcloud /etc/hosts file, this works.

Then I still can’t access docs in Office since the nextcloud-aio-collabora container gives this error in the logs when I try to open a document
because it has the same issue as the nextcloud-aio-nextcloud container did.

wsd-00006-00025 2024-10-15 00:20:01.996684 +0000 [ remotefontconfig_poll ] WRN  #32: Timed out while requesting [GET cloud.tariqhamid.com/apps/richdocuments/settings/fonts.json] after 30027ms| net/HttpRequest.hpp:1704

I tried editing the /etc/hosts file in the nextcloud-aio-collaboara container to see if that resolves this, but I don’t have elevated privileges, and this is a workaround not a permanent solution anyway.

I am able to ping my domain and public IP from inside the containers. It seems to be an issue with routing external ip from the docker containers to the host and back to another the docker container. I’m not really sure how this networking works, or if I did anything incorrectly.

I’m hosting on Vultr and I opened the firewall ports as necessary. Perhaps it’s some default firewall setting in Debian?

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

1. Fresh install of Docker AIO on Debian 12
2. Navigate to Office settings in the admin
3. Click save and notice the error

The output of your Nextcloud log in Admin > Logging:

Warning	no app in context	
Link of notification is not an absolute URL and does not work in mobile and desktop clients [app: survey_client, subject: updated]

Oct 14, 2024, 11:15:42 PM	

Warning	no app in context	
Icon of notification is not an absolute URL and does not work in mobile and desktop clients [app: survey_client, subject: updated]

Oct 14, 2024, 11:13:27 PM	

Warning	no app in context	
Link of notification is not an absolute URL and does not work in mobile and desktop clients [app: survey_client, subject: updated]

Oct 14, 2024, 11:13:27 PM	

Error	core	
DriverException
An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR: column "cr.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "cr".*, "co"."calendardata", "c"."displayname", "c"."... ^
Error while running background job OCA\DAV\BackgroundJob\EventReminderJob (id: 9, arguments: null)

Oct 14, 2024, 11:12:11 PM	

Error	richdocuments	
ConnectException
cURL error 28: Connection timed out after 5002 milliseconds (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://cloud.tariqhamid.com/hosting/discovery
Failed to fetch discovery: cURL error 28: Connection timed out after 5002 milliseconds (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://cloud.tariqhamid.com/hosting/discovery

Oct 14, 2024, 11:02:21 PM	

Error	richdocuments	
ConnectException
cURL error 28: Connection timed out after 5002 milliseconds (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://cloud.tariqhamid.com/hosting/capabilities
Failed to fetch capabilities: cURL error 28: Connection timed out after 5002 milliseconds (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://cloud.tariqhamid.com/hosting/capabilities

Oct 14, 2024, 11:02:16 PM	

Error	core	
DriverException
An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR: column "cr.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "cr".*, "co"."calendardata", "c"."displayname", "c"."... ^
Error while running background job OCA\DAV\BackgroundJob\EventReminderJob (id: 9, arguments: null)

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

Unsure how to find this, but I haven’t changed anything from the default in Docker AIO

[szaimen]

Hi, can you follow How to debug problems with Collabora and/or Talk · nextcloud/all-in-one · Discussion #1358 · GitHub?

[terminat0r]

Thank you reading that issue’s discussion helped me figure out how to resolve my issue. The problem was with the firewall on my host machine. There seems to be a common problem when ufw is enabled along with the iptables rules docker adds.

I’m not exactly sure why but my host machine was blocking port connections between my hosts public IP and the docker bridge interface. Since I was able to ping my public ip from inside the docker containers, but not connect on other ports.

I was able to resolve this by adding this rule using ufw

ufw allow in on <docker bridge interface> to <host public ip>

Thanks for the help!