Collabora says connected but doesn't work

Nextcloud version (eg, 20.0.5): 25.0.12
Operating system and version (eg, Ubuntu 20.04): Ubuntu 20.04
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.41 (Ubuntu)
PHP version (eg, 7.4): PHP 7.4.3-4ubuntu2.19 (cli) (built: Jun 27 2023 15:49:59)

The issue you are facing:

I have been trying (intermittently) for some time to get the Office integration working.
I’ve tried using the built in server which says its working but always returns a
Document loading failed. Failed to load Nectcloud Office - please try again later

Yesterday, I set up a Docker container with a standalone instance of CODE and have spent the past day banging my head off a wall trying to figure out why it STILL isn’t working, I get exactly the same error despite the office section of the admin settings telling me it’s connected.

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

Steps to replicate it:

  1. Install and setup standalone CODE server or Nextcloud CODE app
  2. Try to open a document
  3. Lose

The output of your Nextcloud log in Admin > Logging:


{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Mail\\BackgroundJob\\OutboxWorkerJob job with ID 7717 in 0 seconds","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 8496","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\FullTextSearch\\Cron\\Maintenance job with ID 8496","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\FullTextSearch\\Cron\\Maintenance job with ID 8496 in 0 seconds","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 9345","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 10007","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 10011","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob job with ID 10011","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"mail","method":"","url":"--","message":"No structure data to analyse.","userAgent":"--","version":"25.0.12.0","data":{"app":"mail"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Mail\\BackgroundJob\\PreviewEnhancementProcessingJob job with ID 10011 in 0 seconds","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 10012","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\Mail\\BackgroundJob\\IMipMessageJob job with ID 10012","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":1,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"mail","method":"","url":"--","message":"No iMIP messages to process.","userAgent":"--","version":"25.0.12.0","data":{"app":"mail"}}
{"reqId":"aJaEQwYUBRgj0gWjNMpA","level":0,"time":"October 08, 2023 14:45:01","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\Mail\\BackgroundJob\\IMipMessageJob job with ID 10012 in 0 seconds","userAgent":"--","version":"25.0.12.0","data":{"app":"cron"}}
{"reqId":"RDdQ8rWxCGuV0d0j893l","level":0,"time":"October 08, 2023 14:47:36","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/.well-known/webfinger","message":"1 well known handlers registered","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"nmnsVaydbk5JcR1Gccvz","level":0,"time":"October 08, 2023 14:47:36","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/.well-known/nodeinfo","message":"1 well known handlers registered","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"I283rkHKZZnn8QWkkCuf","level":1,"time":"October 08, 2023 14:47:36","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/settings/ajax/checksetup","message":"Deprecated event type for OCP\\IDBConnection::CHECK_MISSING_PRIMARY_KEYS: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"I283rkHKZZnn8QWkkCuf","level":1,"time":"October 08, 2023 14:47:37","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/settings/ajax/checksetup","message":"Deprecated event type for OCP\\IDBConnection::CHECK_MISSING_INDEXES: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"I283rkHKZZnn8QWkkCuf","level":1,"time":"October 08, 2023 14:47:37","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/settings/ajax/checksetup","message":"Deprecated event type for OCP\\IDBConnection::CHECK_MISSING_COLUMNS: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"w6ryyM708YK52Z08BwgB","level":0,"time":"October 08, 2023 14:50:22","remoteAddr":"192.168.0.1","user":"will","app":"logreader","method":"GET","url":"/index.php/settings/admin/logging","message":"Could not find resource file \"/apps/logreader/css/../js/logreader-main.css\"","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"logreader"}}
{"reqId":"VRCwaTkbJ8ISKKTqsPev","level":1,"time":"October 08, 2023 14:50:32","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/apps/files/","message":"Deprecated event type for \\OCP\\Collaboration\\Resources::loadAdditionalScripts: null","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"VRCwaTkbJ8ISKKTqsPev","level":1,"time":"October 08, 2023 14:50:32","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/apps/files/","message":"Deprecated event type for OCA\\Files::loadAdditionalScripts: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"PoLgCVNRMkylTxuAx8aQ","level":1,"time":"October 08, 2023 14:50:33","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/core/preview?fileId=52543&c=ffa3d4399016e6921084dadfdf7c698b&x=349&y=349&forceIcon=0&a=0","message":"Deprecated event type for OCP\\IPreview:PreviewRequested: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"DYIx1hP4Mb82rcnOad0h","level":1,"time":"October 08, 2023 14:50:35","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/apps/files/","message":"Deprecated event type for \\OCP\\Collaboration\\Resources::loadAdditionalScripts: null","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"DYIx1hP4Mb82rcnOad0h","level":1,"time":"October 08, 2023 14:50:35","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/apps/files/","message":"Deprecated event type for OCA\\Files::loadAdditionalScripts: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"mNOmDImOivWRnx0LPvOZ","level":1,"time":"October 08, 2023 14:50:38","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/core/preview?fileId=52543&c=ffa3d4399016e6921084dadfdf7c698b&x=349&y=349&forceIcon=0&a=0","message":"Deprecated event type for OCP\\IPreview:PreviewRequested: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"iG2r1FPmAl7IBuxMJgOB","level":0,"time":"October 08, 2023 14:50:39","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/.well-known/webfinger","message":"1 well known handlers registered","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"1XemfXOvFjRNl4awN1TG","level":0,"time":"October 08, 2023 14:50:39","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/.well-known/nodeinfo","message":"1 well known handlers registered","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"VTVZVzTFl2eSTHz6aFA2","level":1,"time":"October 08, 2023 14:50:40","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/settings/ajax/checksetup","message":"Deprecated event type for OCP\\IDBConnection::CHECK_MISSING_PRIMARY_KEYS: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"VTVZVzTFl2eSTHz6aFA2","level":1,"time":"October 08, 2023 14:50:40","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/settings/ajax/checksetup","message":"Deprecated event type for OCP\\IDBConnection::CHECK_MISSING_INDEXES: Symfony\\Component\\EventDispatcher\\GenericEvent is used","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":[]}
{"reqId":"VTVZVzTFl2eSTHz6aFA2","level":1,"time":"October 08, 2023 14:50:40","remoteAddr":"192.168.0.1","user":"will","app":"no app in context","method":"GET","url":"/index.php/settings/ajax/checksetup","message":"Deprecated event type for OCP\\IDBConnection::CHECK_MISSING_COLUMNS: Symfony\\Component\

I’m thinking the “Deprecated event type for \OCP\Collaboration\Resources::loadAdditionalScripts: null” might be important though Google isn’t throwing up any results?
This is a VERY old server, it was originally running Ubuntu 14.04 iirc and Nextcloud was actually installed over Owncloud back in the early days of NC so I’m convinced the problem is somewhere in my Nextcloud setup.

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

<?php
$CONFIG = array (
  'instanceid' => 'redacted',
  'passwordsalt' => 'redacted',
  'secret' => 'redacted',
  'trusted_domains' => 
  array (
    0 => '192.168.1.62',
    1 => 'ubuntuserver',
    2 => 'ubuntuserver.local.ftb',
    3 => 'nextcloud.ubuntuserver.local.ftb',
    4 => 'nextcloud.ubuntuserver.ftb',
    5 => '10.10.10.62',
    6 => 'redacted',
    7 => 'willcloud.mydomain.co.uk:4487',
    8 => 'willcloud.mydamain.co.uk:4488',
    9 => 'redacted:4488',
    10 => '10.10.20.62',
    11 => 'vin',
    12 => 'nextcloud.vin.ftb',
    13 => 'willcloud.mydamain.co.uk',
  ),
  'datadirectory' => '/willzpool/nextcloud/data',
  'overwrite.cli.url' => 'https://willcloud.mydomain.co.uk:4488',
  'dbtype' => 'mysql',
  'version' => '25.0.12.0',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'nextcloud',
  'dbpassword' => 'redacted',
  'logtimezone' => 'UTC',
  'default_phone_region' => 'GB',
  'installed' => true,
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'tls',
  'mail_from_address' => 'myeamil',
  'mail_domain' => 'gmail.com',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpauth' => 1,
  'mail_smtphost' => 'smtp.gmail.com',
  'mail_smtpport' => '587',
  'mail_smtpname' => 'myeamil@gmail.com',
  'mail_smtppassword' => 'redacted',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => 'localhost',
    'port' => 6379,
  ),
  'maintenance' => false,
  'theme' => '',
  'updater.release.channel' => 'stable',
  'allow_local_remote_servers' => 'true',
  'mysql.utf8mb4' => true,
  'log_type' => 'file',
  'logfile' => '/var/log/nextcloud.log',
  'logfilemode' => 416,
  'loglevel' => 0,
  'logdateformat' => 'F d, Y H:i:s',
  'app_install_overwrite' => 
  array (
    0 => 'calendar',
    1 => 'mail',
    2 => 'richdocuments',
  ),
  'twofactor_enforced' => 'false',
  'twofactor_enforced_groups' => 
  array (
  ),
  'twofactor_enforced_excluded_groups' => 
  array (
  ),
  'enable_previews' => true,
  'enabledPreviewProviders' => 
  array (
    0 => 'OC\\Preview\\Movie',
    1 => 'OC\\Preview\\PNG',
    2 => 'OC\\Preview\\JPEG',
    3 => 'OC\\Preview\\GIF',
    4 => 'OC\\Preview\\BMP',
    5 => 'OC\\Preview\\XBitmap',
    6 => 'OC\\Preview\\MP3',
    7 => 'OC\\Preview\\MP4',
    8 => 'OC\\Preview\\TXT',
    9 => 'OC\\Preview\\MarkDown',
    10 => 'OC\\Preview\\PDF',
  ),
);

The output of your Apache/nginx/system log in /var/log/____:




frk-3846058-3846058 2023-10-08 12:24:27.917342 +0100 [ forkit ] TST  UnitBase [uninit] (+0ms): Uninitializing unit-tests: SUCCESS| common/Unit.cpp:348
frk-3846058-3846058 2023-10-08 12:24:27.917394 +0100 [ forkit ] TST  UnitKit [~UnitBase] (+0ms): UnitKit: ~UnitBase: SUCCESS| common/Unit.cpp:407
kit-3846072-3846058 2023-10-08 12:24:27.925140 +0100 [ kit_spare_001 ] SIG   Forced-Termination signal received: SIGTERM
wsd-3845987-3845987 2023-10-08 12:24:27.925297 +0100 [ coolwsd ] SIG   Forced-Termination signal received: SIGTERM
sh: 1: /tmp/.mount_Collabqkpy7X/usr/bin/coolmount: not found
wsd-3845987-3845987 2023-10-08 12:24:27.928349 +0100 [ coolwsd ] TST  UnitBase [uninit] (+0ms): Uninitializing unit-tests: SUCCESS| common/Unit.cpp:348
wsd-3845987-3845987 2023-10-08 12:24:27.928363 +0100 [ coolwsd ] TST  UnitWSD [~UnitBase] (+0ms): UnitWSD: ~UnitBase: SUCCESS| common/Unit.cpp:407
wsd-3845987-3845987 2023-10-08 12:24:27.928383 +0100 [ coolwsd ] TST  UnitBase [uninit] (+0ms): Uninitializing unit-tests: SUCCESS| common/Unit.cpp:348
[Sun Oct 08 12:24:27.990830 2023] [mpm_prefork:notice] [pid 3844478] AH00169: caught SIGTERM, shutting down
[Sun Oct 08 12:24:28.025815 2023] [ssl:warn] [pid 3847048] AH01909: webmin.vin.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:24:28.025955 2023] [ssl:warn] [pid 3847048] AH01909: webmin.ubuntuserver.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:24:28.026087 2023] [ssl:warn] [pid 3847048] AH01909: plex.vin.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:24:28.026213 2023] [ssl:warn] [pid 3847048] AH01909: plex.ubuntuserver.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:24:28.045698 2023] [ssl:warn] [pid 3847049] AH01909: webmin.vin.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:24:28.045864 2023] [ssl:warn] [pid 3847049] AH01909: webmin.ubuntuserver.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:24:28.045987 2023] [ssl:warn] [pid 3847049] AH01909: plex.vin.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:24:28.046105 2023] [ssl:warn] [pid 3847049] AH01909: plex.ubuntuserver.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:24:28.049253 2023] [mpm_prefork:notice] [pid 3847049] AH00163: Apache/2.4.41 (Ubuntu) OpenSSL/1.1.1g configured -- resuming normal operations
[Sun Oct 08 12:24:28.049261 2023] [core:notice] [pid 3847049] AH00094: Command line: '/usr/sbin/apache2'
[Sun Oct 08 12:24:36.251769 2023] [php7:error] [pid 3847051] [client 10.10.10.68:47500] script '/var/www/html/index.php' not found or unable to stat
[Sun Oct 08 12:24:37.763562 2023] [php7:error] [pid 3847051] [client 10.10.10.68:47500] script '/var/www/html/index.php' not found or unable to stat
[Sun Oct 08 12:25:10.275552 2023] [mpm_prefork:error] [pid 3847049] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
[Sun Oct 08 12:31:33.171563 2023] [mpm_prefork:notice] [pid 3847049] AH00169: caught SIGTERM, shutting down
[Sun Oct 08 12:32:01.021922 2023] [ssl:warn] [pid 2168] AH01909: webmin.vin.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:32:01.022344 2023] [ssl:warn] [pid 2168] AH01909: webmin.ubuntuserver.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:32:01.022560 2023] [ssl:warn] [pid 2168] AH01909: plex.vin.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:32:01.022761 2023] [ssl:warn] [pid 2168] AH01909: plex.ubuntuserver.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:32:01.497434 2023] [ssl:warn] [pid 2492] AH01909: webmin.vin.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:32:01.497678 2023] [ssl:warn] [pid 2492] AH01909: webmin.ubuntuserver.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:32:01.497900 2023] [ssl:warn] [pid 2492] AH01909: plex.vin.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:32:01.498119 2023] [ssl:warn] [pid 2492] AH01909: plex.ubuntuserver.ftb:443:0 server certificate does NOT include an ID which matches the server name
[Sun Oct 08 12:32:01.503740 2023] [mpm_prefork:notice] [pid 2492] AH00163: Apache/2.4.41 (Ubuntu) OpenSSL/1.1.1g configured -- resuming normal operations
[Sun Oct 08 12:32:01.503752 2023] [core:notice] [pid 2492] AH00094: Command line: '/usr/sbin/apache2'

Nothing at all showing in the Apache2 error log. The access log is the only other active log and it’s empty

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

[richdocuments] Error: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'template_destination' in 'field list' at <<closure>>

 0. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1780
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
 1. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Connection.php line 1719
    Doctrine\DBAL\Connection->handleDriverException()
 2. /var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Statement.php line 193
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /var/www/html/nextcloud/lib/private/DB/PreparedStatement.php line 87
    Doctrine\DBAL\Statement->execute()
 4. /var/www/html/nextcloud/lib/public/AppFramework/Db/Mapper.php line 252
    OC\DB\PreparedStatement->execute()
 5. /var/www/html/nextcloud/lib/public/AppFramework/Db/Mapper.php line 127
    OCP\AppFramework\Db\Mapper->execute()
 6. /var/www/html/nextcloud/apps/richdocuments/lib/Db/WopiMapper.php line 96
    OCP\AppFramework\Db\Mapper->insert()
 7. /var/www/html/nextcloud/apps/richdocuments/lib/TokenManager.php line 204
    OCA\Richdocuments\Db\WopiMapper->generateFileToken()
 8. /var/www/html/nextcloud/apps/richdocuments/lib/Controller/DocumentController.php line 173
    OCA\Richdocuments\TokenManager->getToken("*** sensitive parameters replaced ***")
 9. /var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 225
    OCA\Richdocuments\Controller\DocumentController->index()
10. /var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 133
    OC\AppFramework\Http\Dispatcher->executeController()
11. /var/www/html/nextcloud/lib/private/AppFramework/App.php line 172
    OC\AppFramework\Http\Dispatcher->dispatch()
12. /var/www/html/nextcloud/lib/private/Route/Router.php line 298
    OC\AppFramework\App::main()
13. /var/www/html/nextcloud/lib/base.php line 1053
    OC\Route\Router->match()
14. /var/www/html/nextcloud/index.php line 36
    OC::handleRequest()

GET /index.php/apps/richdocuments/index?fileId=440847&requesttoken=2O5iAT0YaIWoJ84LiSqzb9MQe4OgOHh8kZQ0QdW6fOE%3D%3Ajt8sS1ozBdaba4Vuw0PcG7d6CtLrVDca%2FNJVDYSDJLA%3D&path=%2FWork%20Stuff%2FDocuments%2F9AS%2Ffull%20test%202023-10-06%2FMusterlist%20after%20evac.ods
from 192.168.0.1 by will at 2023-10-08T15:19:01+00:00

I have also tried connecting to both the Nextcloud and Collabora instances from a client, the NC server and the Collabora Docker container and from what I can see, they’re all working successfully.

Sorry for the long code boxes but I’d rather not leave anything out if it’s important.

Client

15:27:44 [will@will-ryzen-manjaro ~]$ curl https://willcloud.mydomain.co.uk:4488/login
<!DOCTYPE html>
<html class="ng-csp" data-placeholder-focus="false" lang="en" data-locale="en" >
	<head
 data-requesttoken="4fiJfddrkel7i9hzooBKhiXc8vKd0SMFQL/c0U9Rb2M=:oo3+EJs70I42v+4xx8sew3KbtpT2pWcuEt6xkjcwWzU=">
		<meta charset="utf-8">
		<title>
			Login – WllCloud		</title>
		<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0">
				<meta name="apple-itunes-app" content="app-id=1125420102">
				<meta name="theme-color" content="#094213">
		<link rel="icon" href="/index.php/apps/theming/favicon?v=85288ac7">
		<link rel="apple-touch-icon" href="/index.php/apps/theming/icon?v=85288ac7">
		<link rel="mask-icon" sizes="any" href="/core/img/favicon-mask.svg" color="#094213">
		<link rel="manifest" href="/index.php/apps/theming/manifest?v=85288ac7">
		<link rel="stylesheet" href="/core/css/server.css?v=ca3ef3c8-24">
<link rel="stylesheet" href="/apps/files_rightclick/css/app.css?v=1bf6e69c-24">
<link rel="stylesheet" href="/apps/theming/css/default.css?v=47354877-24">
<link rel="stylesheet" href="/core/css/guest.css?v=ca3ef3c8-24">
		<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/index.php/core/js/oc.js?v=ca3ef3c8"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/dist/core-common.js?v=ca3ef3c8-24"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/dist/core-main.js?v=ca3ef3c8-24"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/dist/core-files_fileinfo.js?v=ca3ef3c8-24"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/dist/core-files_client.js?v=ca3ef3c8-24"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/index.php/js/core/merged-template-prepend.js?v=ca3ef3c8-24"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/dist/core-login.js?v=ca3ef3c8-24"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/dist/files_sharing-main.js?v=ca3ef3c8-24"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/apps/files_rightclick/js/script.js?v=ca3ef3c8-24"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/apps/files_rightclick/js/files.js?v=ca3ef3c8-24"></script>
<script nonce="NGZpSmZkZHJrZWw3aTloem9vQktoaVhjOHZLZDBTTUZRTC9jMFU5UmIyTT06b28zK0VKczcwSTQydis0eHg4c2V3M0tidHBUMnBXY3VFdDZ4a2pjd1d6VT0=" defer src="/apps/theming/js/theming.js?v=ca3ef3c8-24"></script>
		<meta property="og:title" content="WllCloud"/><meta property="og:description" content="ftb"/><meta property="og:site_name" content="WllCloud"/><meta property="og:url" content="https://willcloud.mydomain.co.uk:4488/"/><meta property="og:type" content="website"/><meta property="og:image" content="https://willcloud.mydomain.co.uk:4488/index.php/apps/theming/icon?v=85288ac7"/><link rel="stylesheet" media="" href="/index.php/apps/theming/theme/default.css?plain=1&amp;v=4d134bc0" class="theme"/><link rel="stylesheet" media="(prefers-color-scheme: light)" href="/index.php/apps/theming/theme/light.css?plain=1&amp;v=4d134bc0" class="theme"/><link rel="stylesheet" media="(prefers-color-scheme: dark)" href="/index.php/apps/theming/theme/dark.css?plain=1&amp;v=4d134bc0" class="theme"/><link rel="stylesheet" media="(prefers-contrast: more)" href="/index.php/apps/theming/theme/light-highcontrast.css?plain=1&amp;v=4d134bc0" class="theme"/><link rel="stylesheet" media="(prefers-color-scheme: dark) and (prefers-contrast: more)" href="/index.php/apps/theming/theme/dark-highcontrast.css?plain=1&amp;v=4d134bc0" class="theme"/><link rel="stylesheet" media="" href="/index.php/apps/theming/theme/light.css?plain=0&amp;v=4d134bc0" class="theme"/><link rel="stylesheet" media="" href="/index.php/apps/theming/theme/dark.css?plain=0&amp;v=4d134bc0" class="theme"/><link rel="stylesheet" media="" href="/index.php/apps/theming/theme/light-highcontrast.css?plain=0&amp;v=4d134bc0" class="theme"/><link rel="stylesheet" media="" href="/index.php/apps/theming/theme/dark-highcontrast.css?plain=0&amp;v=4d134bc0" class="theme"/><link rel="stylesheet" media="" href="/index.php/apps/theming/theme/opendyslexic.css?plain=0&amp;v=4d134bc0" class="theme"/><meta name="robots" content="noindex, nofollow"/>	</head>
	<body id="body-login">
		<noscript>
	<div id="nojavascript">
		<div>
			This application requires JavaScript for correct operation. Please <a href="https://www.enable-javascript.com/" target="_blank" rel="noreferrer noopener">enable JavaScript</a> and reload the page.		</div>
	</div>
</noscript>
					<input type="hidden" id="initial-state-core-loginUsername" value="IiI=">
					<input type="hidden" id="initial-state-core-loginAutocomplete" value="dHJ1ZQ==">
					<input type="hidden" id="initial-state-core-loginThrottleDelay" value="MA==">
					<input type="hidden" id="initial-state-core-loginResetPasswordLink" value="IiI=">
					<input type="hidden" id="initial-state-core-loginCanResetPassword" value="dHJ1ZQ==">
					<input type="hidden" id="initial-state-core-webauthn-available" value="dHJ1ZQ==">
					<input type="hidden" id="initial-state-core-hideLoginForm" value="ZmFsc2U=">
					<input type="hidden" id="initial-state-core-countAlternativeLogins" value="MA==">
					<input type="hidden" id="initial-state-core-alternativeLogins" value="W10=">
					<input type="hidden" id="initial-state-core-projects_enabled" value="ZmFsc2U=">
					<input type="hidden" id="initial-state-core-config" value="very long string ">
					<input type="hidden" id="initial-state-core-capabilities" value="very long string">
					<input type="hidden" id="initial-state-core-versionHash" value="ImNhM2VmM2M4Ig==">
					<input type="hidden" id="initial-state-theming-data" value="eyJuYW1lIjoiV2xsQ2xvdWQiLCJ1cmwiOiJodHRwczpcL1wvd2lsbGNsb3VkLndqc3lzdGVtcy5jby51azoyNDY3Iiwic2xvZ2FuIjoiZnRiIiwiY29sb3IiOiIjMDk0MjEzIiwiZGVmYXVsdENvbG9yIjoiIzA5NDIxMyIsImltcHJpbnRVcmwiOiIiLCJwcml2YWN5VXJsIjoiIiwiaW52ZXJ0ZWQiOmZhbHNlLCJjYWNoZUJ1c3RlciI6IjRkMTM0YmMwIiwiZW5hYmxlZFRoZW1lcyI6W119">
					<input type="hidden" id="initial-state-comments-maxAutoCompleteResults" value="MTA=">
				<div class="wrapper">
			<div class="v-align">
									<header role="banner">
						<div id="header">
							<div class="logo"></div>
						</div>
					</header>
								<main>
					<h1 class="hidden-visually">
						WllCloud					</h1>
					
<div>
	<div id="login"></div>
</div>
				</main>
			</div>
		</div>
		<footer role="contentinfo">
			<p class="info">
				<a href="https://willcloud.mydomain.co.uk:4488" target="_blank" rel="noreferrer noopener" class="entity-name">WllCloud</a> – ftb	</p>
		</footer>
	</body>
</html>




15:24:48 [will@will-ryzen-manjaro ~]$ curl https://office.mydomain.co.uk:4488/hosting/discovery
<wopi-discovery>
    <net-zone name="external-http">

        <!-- Writer documents -->
        <app favIconUrl="https://office.mydomain.co.uk:4488/browser/0b27e85/images/x-office-document.svg" name="writer">
            <action default="true" ext="sxw" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="odt" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="fodt" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- Text template documents -->
            <action default="true" ext="stw" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="ott" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- MS Word -->
            <action default="true" ext="doc" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="dot" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- OOXML wordprocessing -->
            <action default="true" ext="docx" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="docm" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="dotx" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="dotm" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- Others -->
            <action default="true" ext="wpd" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="pdb" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="hwp" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="wps" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="wri" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="lrf" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="mw" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="rtf" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="txt" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="fb2" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="cwk" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="pages" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="abw" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="602" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <app name="writer-global">
            <!-- Text master documents -->
            <action default="true" ext="sxg" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="odm" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- Writer master document templates -->
            <action default="true" ext="otm" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <app name="writer-web">
            <action default="true" ext="oth" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Calc documents -->
        <app favIconUrl="https://office.mydomain.co.uk:4488/browser/0b27e85/images/x-office-spreadsheet.svg" name="calc">
            <action default="true" ext="sxc" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="ods" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="fods" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- Spreadsheet template documents -->
            <action default="true" ext="stc" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="ots" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- MS Excel -->
            <action default="true" ext="xls" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="xla" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- OOXML spreadsheet -->
            <action default="true" ext="xltx" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="xltm" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="xlsx" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="xlsb" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="xlsm" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- Others -->
            <action default="true" ext="dif" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="slk" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="csv" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="dbf" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="wk1" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="gnumeric" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="numbers" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Impress documents -->
        <app favIconUrl="https://office.mydomain.co.uk:4488/browser/0b27e85/images/x-office-presentation.svg" name="impress">
            <action default="true" ext="sxi" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="odp" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="fodp" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- Presentation template documents -->
            <action default="true" ext="sti" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="otp" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- MS PowerPoint -->
            <action default="true" ext="ppt" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="pot" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- OOXML presentation -->
            <action default="true" ext="pptx" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="pptm" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="potx" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="potm" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="ppsx" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- Others -->
            <action default="true" ext="cgm" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="key" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Draw documents -->
        <app name="draw">
            <action default="true" ext="sxd" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="odg" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="fodg" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- Drawing template documents -->
            <action default="true" ext="std" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="otg" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <!-- Others -->
            <action ext="svg" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="dxf" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="emf" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="wmf" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="cdr" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="vsd" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="vsdx" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="vss" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="pub" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="p65" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="wpg" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action default="true" ext="fh" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action ext="bmp" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action ext="png" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action ext="gif" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action ext="tiff" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action ext="jpg" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action ext="jpeg" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
            <action ext="pdf" name="view_comment" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Math documents -->
        <!-- In fact Math documents are not supported at all.
             See: https://bugs.documentfoundation.org/show_bug.cgi?id=97006
        <app name="math">
            <action name="view" default="true" ext="sxm"/>
            <action name="edit" default="true" ext="odf"/>
        </app>
        -->

        <!-- Legacy MIME-type actions (compatibility) -->

        <app name="image/svg+xml">
            <action ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-powerpoint">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-excel">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Writer documents -->
        <app name="application/vnd.sun.xml.writer">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text-flat-xml">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Calc documents -->
        <app name="application/vnd.sun.xml.calc">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.spreadsheet">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.spreadsheet-flat-xml">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Impress documents -->
        <app name="application/vnd.sun.xml.impress">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.presentation">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.presentation-flat-xml">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Draw documents -->
        <app name="application/vnd.sun.xml.draw">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.graphics">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.graphics-flat-xml">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Chart documents -->
        <app name="application/vnd.oasis.opendocument.chart">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Text master documents -->
        <app name="application/vnd.sun.xml.writer.global">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text-master">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Math documents -->
        <!-- In fact Math documents are not supported at all.
             See: https://bugs.documentfoundation.org/show_bug.cgi?id=97006
        <app name="application/vnd.sun.xml.math">
            <action name="view" default="true" ext=""/>
        </app>
        <app name="application/vnd.oasis.opendocument.formula">
            <action name="edit" default="true" ext=""/>
        </app>
        -->
        <!-- Text template documents -->
        <app name="application/vnd.sun.xml.writer.template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text-template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Writer master document templates -->
        <app name="application/vnd.oasis.opendocument.text-master-template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Spreadsheet template documents -->
        <app name="application/vnd.sun.xml.calc.template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.spreadsheet-template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Presentation template documents -->
        <app name="application/vnd.sun.xml.impress.template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.presentation-template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Drawing template documents -->
        <app name="application/vnd.sun.xml.draw.template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.graphics-template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- MS Word -->
        <app name="application/msword">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/msword">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- MS Excel -->
        <app name="application/vnd.ms-excel">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- MS PowerPoint -->
        <app name="application/vnd.ms-powerpoint">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- OOXML wordprocessing -->
        <app name="application/vnd.openxmlformats-officedocument.wordprocessingml.document">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-word.document.macroEnabled.12">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.openxmlformats-officedocument.wordprocessingml.template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-word.template.macroEnabled.12">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- OOXML spreadsheet -->
        <app name="application/vnd.openxmlformats-officedocument.spreadsheetml.template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-excel.template.macroEnabled.12">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-excel.sheet.binary.macroEnabled.12">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-excel.sheet.macroEnabled.12">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- OOXML presentation -->
        <app name="application/vnd.openxmlformats-officedocument.presentationml.presentation">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-powerpoint.presentation.macroEnabled.12">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.openxmlformats-officedocument.presentationml.template">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-powerpoint.template.macroEnabled.12">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- Others -->
        <app name="application/vnd.wordperfect">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-aportisdoc">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-hwp">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-works">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-mswrite">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-dif-document">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="text/spreadsheet">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="text/csv">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-dbase">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.lotus-1-2-3">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/cgm">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/vnd.dxf">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/x-emf">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/x-wmf">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/coreldraw">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.visio2013">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.visio">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.ms-visio.drawing">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-mspublisher">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-sony-bbeb">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-gnumeric">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/macwriteii">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-iwork-numbers-sffnumbers">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.oasis.opendocument.text-web">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-pagemaker">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="text/rtf">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="text/plain">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-fictionbook+xml">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/clarisworks">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/x-wpg">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-iwork-pages-sffpages">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.openxmlformats-officedocument.presentationml.slideshow">
            <action default="true" ext="" name="edit" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-iwork-keynote-sffkey">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-abiword">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/x-freehand">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/vnd.sun.xml.chart">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/x-t602">
            <action default="true" ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/bmp">
            <action ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/png">
            <action ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/gif">
            <action ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/tiff">
            <action ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/jpg">
            <action ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="image/jpeg">
            <action ext="" name="view" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>
        <app name="application/pdf">
            <action ext="" name="view_comment" urlsrc="https://office.mydomain.co.uk:4488/browser/0b27e85/cool.html?"/>
        </app>

        <!-- End of legacy MIME-type actions -->

        <app name="Capabilities">
            <action ext="" name="getinfo" urlsrc="https://office.mydomain.co.uk:4488/hosting/capabilities"/>
        </app>
    </net-zone>
<proof-key exponent="AQAB" modulus="very long string"/></wopi-discovery>



Apparently I was way over the 64000 character limit but trust me, the NC server and Collabora container outputs are the same as the client’s

Sorry, I should have added.

Collabora is running behind a reverse proxy with a letsencrypt certificate, everything I can see looks ok, I’m not getting any certificate errors, only the “Document loading failed. Failed to load Nectcloud Office - please try again later” error.

Also, regarding the deprecated event type/invalid field name errors, I do run the “add missing indices” command any time the admin>overview page asks me to.
It is giving me a warning about my PHP version but that’s because I’m still running Ubuntu 20.04. I plan on upgrading to 24.04 next year but I’m not convinced that’s the issue anyway since I’ve never been able to get Collabora working in any way, shape or form.

16:54:03 [will@will-ryzen-manjaro ~]$ curl -v https://office.mydomain.co.uk:4488/hosting/discovery
*   Trying redacted:4488...
* Connected to office.mydomain.co.uk (redacted) port 4488
* ALPN: curl offers h2,http/1.1
* TLSv1.3 (OUT), TLS handshake, Client hello (1):
*  CAfile: /etc/ssl/certs/ca-certificates.crt
*  CApath: none
* TLSv1.3 (IN), TLS handshake, Server hello (2):
* TLSv1.3 (IN), TLS handshake, Encrypted Extensions (8):
* TLSv1.3 (IN), TLS handshake, Certificate (11):
* TLSv1.3 (IN), TLS handshake, CERT verify (15):
* TLSv1.3 (IN), TLS handshake, Finished (20):
* TLSv1.3 (OUT), TLS change cipher, Change cipher spec (1):
* TLSv1.3 (OUT), TLS handshake, Finished (20):
* SSL connection using TLSv1.3 / TLS_AES_256_GCM_SHA384
* ALPN: server accepted http/1.1
* Server certificate:
*  subject: CN=office.mydomain.co.uk
*  start date: Oct  7 19:07:52 2023 GMT
*  expire date: Jan  5 19:07:51 2024 GMT
*  subjectAltName: host "office.mydomain.co.uk" matched cert's "office.mydomain.co.uk"
*  issuer: C=US; O=Let's Encrypt; CN=R3
*  SSL certificate verify ok.
* using HTTP/1.1
> GET /hosting/discovery HTTP/1.1
> Host: office.mydomain.co.uk:2467
> User-Agent: curl/8.3.0
> Accept: */*
> 
* TLSv1.3 (IN), TLS handshake, Newsession Ticket (4):
* TLSv1.3 (IN), TLS handshake, Newsession Ticket (4):
* old SSL session ID is stale, removing
< HTTP/1.1 200 OK
< Date: Sun, 08 Oct 2023 15:54:12
< Server: COOLWSD HTTP Server 23.05.4.2
< Content-Length: 33126
< Content-Type: text/xml
< Last-Modified: Sun, 08 Oct 2023 15:54:12
< X-Content-Type-Options: nosniff
< Vary: Accept-Encoding

I found a guide here that outlined how to clear all the richdocuments data and I’ve followed it to remove the app and the database tables

drop table oc_richdocuments_direct;
drop table oc_richdocuments_wopi;
drop table oc_richdocuments_assets;
delete from oc_migrations where app='richdocuments';

The time period says the app is called Collabora Online but I’m assuming the same should hold true for Nextcloud Office.

After reinstalling the app, the Admin page still seemed to remember my server details though so maybe I’m missing something when trying to delete everything related to the app to do a fresh install?

Regardless, here’s the log after removing the data and reinstalling. I also set up the full text search to get rid of the errors I was seeing there in case it was related, but I’m still faced with the same error.

{"reqId":"szyhK4puW5FtxLUaa7lA","level":0,"time":"October 08, 2023 17:48:22","remoteAddr":"10.100.10.68","user":"will","app":"fulltextsearch","method":"GET","url":"/index.php/settings/admin/logging","message":"Could not determine if provider with id 'files' was properly indexed because the corresponding provider-option could not be found. Make sure the initial indexing process has been completed successfully.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"fulltextsearch","level":"0"}}
{"reqId":"szyhK4puW5FtxLUaa7lA","level":0,"time":"October 08, 2023 17:48:22","remoteAddr":"10.100.10.68","user":"will","app":"logreader","method":"GET","url":"/index.php/settings/admin/logging","message":"Could not find resource file \"/apps/logreader/css/../js/logreader-main.css\"","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"logreader"}}
{"reqId":"CcdhTooK5RzQWcVUa33r","level":0,"time":"October 08, 2023 17:53:02","remoteAddr":"10.100.10.68","user":"--","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/addressbooks/users/willwork/contacts/","message":"Token is not valid: Token does not exist: token does not exist","userAgent":"Evolution/3.48.4","version":"25.0.12.0","exception":{"Exception":"OC\\Authentication\\Exceptions\\InvalidTokenException","Message":"Token does not exist: token does not exist","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/Authentication/Token/Manager.php","line":133,"function":"getToken","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/User/Session.php","line":529,"function":"getToken","class":"OC\\Authentication\\Token\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/User/Session.php","line":438,"function":"isTokenPassword","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php","line":116,"function":"logClientIn","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Backend/AbstractBasic.php","line":103,"function":"validateUserPass","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php","line":235,"function":"check","class":"Sabre\\DAV\\Auth\\Backend\\AbstractBasic","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php","line":142,"function":"auth","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":180,"function":"check","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":135,"function":"check","class":"Sabre\\DAV\\Auth\\Plugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"beforeMethod","class":"Sabre\\DAV\\Auth\\Plugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":456,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":361,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":172,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","Line":128,"Previous":{"Exception":"OCP\\AppFramework\\Db\\DoesNotExistException","Message":"token does not exist","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","line":119,"function":"getToken","class":"OC\\Authentication\\Token\\PublicKeyTokenMapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Authentication/Token/Manager.php","line":133,"function":"getToken","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/User/Session.php","line":529,"function":"getToken","class":"OC\\Authentication\\Token\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/User/Session.php","line":438,"function":"isTokenPassword","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php","line":116,"function":"logClientIn","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Backend/AbstractBasic.php","line":103,"function":"validateUserPass","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php","line":235,"function":"check","class":"Sabre\\DAV\\Auth\\Backend\\AbstractBasic","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Auth.php","line":142,"function":"auth","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":180,"function":"check","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":135,"function":"check","class":"Sabre\\DAV\\Auth\\Plugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"beforeMethod","class":"Sabre\\DAV\\Auth\\Plugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":456,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":361,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":172,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/Authentication/Token/PublicKeyTokenMapper.php","Line":89},"message":"Token is not valid: Token does not exist: token does not exist","exception":{},"CustomMessage":"Token is not valid: Token does not exist: token does not exist"}}
{"reqId":"oymsmyU6NAZh65zT8Pz9","level":0,"time":"October 08, 2023 17:54:55","remoteAddr":"10.100.10.68","user":"will","app":"fulltextsearch","method":"GET","url":"/index.php/settings/admin/logging","message":"Could not determine if provider with id 'files' was properly indexed because the corresponding provider-option could not be found. Make sure the initial indexing process has been completed successfully.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"fulltextsearch","level":"0"}}
{"reqId":"oymsmyU6NAZh65zT8Pz9","level":0,"time":"October 08, 2023 17:54:55","remoteAddr":"10.100.10.68","user":"will","app":"logreader","method":"GET","url":"/index.php/settings/admin/logging","message":"Could not find resource file \"/apps/logreader/css/../js/logreader-main.css\"","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"logreader"}}
{"reqId":"pE9XP2T7c26zOXhkDdpP","level":0,"time":"October 08, 2023 17:54:59","remoteAddr":"10.100.10.68","user":"will","app":"fulltextsearch","method":"GET","url":"/index.php/apps/richdocuments/index?fileId=38140&requesttoken=3JjfkZHWA3sRAG54VtLu3AnTw5S%2FtLn2buUQy0ee5Kc%3D%3AiqmR2%2Fb9bigiTCUdHLuBqG25ssX02PaQA6NxhxanvPY%3D&path=%2Fwibur2edited.ods","message":"Could not determine if provider with id 'files' was properly indexed because the corresponding provider-option could not be found. Make sure the initial indexing process has been completed successfully.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"fulltextsearch","level":"0"}}
{"reqId":"llAQyd04WeJLgapY4yAz","level":0,"time":"October 08, 2023 17:55:24","remoteAddr":"10.100.10.68","user":"will","app":"fulltextsearch","method":"GET","url":"/index.php/settings/admin/logging","message":"Could not determine if provider with id 'files' was properly indexed because the corresponding provider-option could not be found. Make sure the initial indexing process has been completed successfully.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"fulltextsearch","level":"0"}}
{"reqId":"llAQyd04WeJLgapY4yAz","level":0,"time":"October 08, 2023 17:55:24","remoteAddr":"10.100.10.68","user":"will","app":"logreader","method":"GET","url":"/index.php/settings/admin/logging","message":"Could not find resource file \"/apps/logreader/css/../js/logreader-main.css\"","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"logreader"}}
{"reqId":"NqViqc3FnmCxzk2LKfY5","level":0,"time":"October 08, 2023 17:55:35","remoteAddr":"10.100.10.68","user":"will","app":"fulltextsearch","method":"GET","url":"/index.php/settings/admin/logging","message":"Could not determine if provider with id 'files' was properly indexed because the corresponding provider-option could not be found. Make sure the initial indexing process has been completed successfully.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"fulltextsearch","level":"0"}}
{"reqId":"NqViqc3FnmCxzk2LKfY5","level":0,"time":"October 08, 2023 17:55:35","remoteAddr":"10.100.10.68","user":"will","app":"logreader","method":"GET","url":"/index.php/settings/admin/logging","message":"Could not find resource file \"/apps/logreader/css/../js/logreader-main.css\"","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0","version":"25.0.12.0","data":{"app":"logreader"}}

OK, now I feel like an idiot.

Turns out that because I’m accessing Nextcloud on a non standard port, I had to use

sudo docker run -t -d -p 127.0.0.1:9980:9980 -e 'domain=willcloud\\.mydomain\\.co\\.uk:4488' -e 'username=will' -e 'password=supersecretpassword.'  --restart always --name will-office collabora/code

Those 5 characters have cost me around 12 hours, I hope this can help someone else!