Cannot open .ods document

â„č Support 📄 Collabora
, ,
1

Nextcloud version 25.0.5
Operating system and version Ubuntu 22.04.2 LTS
Nextcloud installed via snap on Oracle free tier instance

Since a while (after a certain update) I am not able to open Collabora documents, only able to open markdown files.
Collabora Online - Built-in CODE Server (ARM64) is installed, but connection to Collabora Online server cannot be established.

2

hi @suzsolt welcome to the forum :handshake:

you are missing the required support template. Please fill this form out and edit into your post.

This will give us the technical info and logs needed to help you in case the machine in question in spitting out errors! Since you’ve provided zero technical details it is impossible to help you as-is. Thanks.

Please use the search - lot of issues have been discussed already

Please show what you tried and which problems you hit so far!

As far I remember Oracle free tier instance is not very powerful - IMHO you don’t have enough resources to run Nextcloud and Collabora on OCI free tier


3

hi @wwe ,

Collabora Online was working fine until an update after which I was not able to open documents anymore. I tried to install richdocumentscode_arm64 but it was already installed. I tried with the demo server and with that I was able to open documents.

System info

nextcloud 25.0.5snap2 34375 latest/stable nextcloud✓ -
snap 2.58.3
snapd 2.58.3
series 16
ubuntu 22.04
kernel 5.15.0-1032-oracle

Screenshots

ods
ods1920×1080 20.5 KB

Collabora_Online
Collabora_Online1920×990 170 KB

CODE
CODE1920×992 312 KB

Log

The output of your Nextcloud log in Admin > Logging:

Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T09:10:52+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T09:10:51+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T09:10:51+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T09:10:51+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T05:18:12+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T05:18:12+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T05:18:12+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T05:18:12+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T01:11:48+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T01:11:48+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T01:11:48+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-17T01:11:48+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T21:09:57+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T21:09:57+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T21:09:56+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T21:09:56+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T21:09:56+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T17:17:23+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T17:17:22+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T17:17:22+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T17:17:22+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T13:14:52+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T13:14:52+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T13:14:52+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T13:14:52+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T09:09:47+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T09:09:47+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T09:09:47+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T09:09:47+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T05:10:15+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T05:10:14+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T05:10:14+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T05:10:14+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T01:10:12+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T01:10:12+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T01:10:12+0200
Figyelmeztetés suspicious_login Could not predict suspiciousness: No models found 2023-04-16T01:10:12+0200

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

$CONFIG = array (

‘apps_paths’ =>

array (

0 =>

array (

  'path' => '/snap/nextcloud/current/htdocs/apps',

  'url' => '/apps',

  'writable' => false,

),

1 =>

array (

  'path' => '/var/snap/nextcloud/current/nextcloud/extra-apps',

  'url' => '/extra-apps',

  'writable' => true,

),

),

‘supportedDatabases’ =>

array (

0 => 'mysql',

),

‘memcache.locking’ => ‘\OC\Memcache\Redis’,

‘memcache.local’ => ‘\OC\Memcache\Redis’,

‘redis’ =>

array (

'host' => '/tmp/sockets/redis.sock',

'port' => 0,

),

‘log_type’ => ‘file’,

‘logfile’ => ‘/var/snap/nextcloud/current/logs/nextcloud.log’,

‘logfilemode’ => 416,

‘instanceid’ => ‘REMOVED SENSITIVE VALUE’,

‘passwordsalt’ => ‘REMOVED SENSITIVE VALUE’,

‘secret’ => ‘REMOVED SENSITIVE VALUE’,

‘trusted_domains’ =>

array (

0 => '***REMOVED SENSITIVE VALUE***',

),

‘datadirectory’ => ‘REMOVED SENSITIVE VALUE’,

‘dbtype’ => ‘mysql’,

‘version’ => ‘25.0.5.1’,

‘overwrite.cli.url’ => ‘REMOVED SENSITIVE VALUE’,

‘dbname’ => ‘REMOVED SENSITIVE VALUE’,

‘dbhost’ => ‘localhost:/tmp/sockets/mysql.sock’,

‘dbport’ => ‘’,

‘dbtableprefix’ => ‘oc_’,

‘mysql.utf8mb4’ => true,

‘dbuser’ => ‘REMOVED SENSITIVE VALUE’,

‘dbpassword’ => ‘REMOVED SENSITIVE VALUE’,

‘installed’ => true,

‘maintenance’ => false,

‘loglevel’ => 2,

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

[Sun Apr 16 00:00:02.345138 2023] [ssl:warn] [pid 2785:tid 281472898655296] AH01909: 127.0.1.1:443:0 server certificate does NOT include an ID which matches>
[Sun Apr 16 00:00:02.345448 2023] [lbmethod_heartbeat:notice] [pid 2785:tid 281472898655296] AH02282: No slotmem from mod_heartmonitor
[Sun Apr 16 00:00:02.345633 2023] [mpm_event:notice] [pid 2785:tid 281472898655296] AH00489: Apache/2.4.57 (Unix) OpenSSL/1.1.1 configured – resuming norma>
[Sun Apr 16 00:00:02.345642 2023] [core:notice] [pid 2785:tid 281472898655296] AH00094: Command line: 'httpd -d /snap/nextcloud/34375 -D EnableHTTPS -D Enab>
[Sun Apr 16 00:00:02.630864 2023] [mpm_event:notice] [pid 2785:tid 281472898655296] AH00493: SIGUSR1 received. Doing graceful restart
[Sun Apr 16 00:00:02.631712 2023] [unixd:alert] [pid 187406:tid 281472898655296] AH02155: getpwuid: couldn’t determine user name from uid 4294967295, you pr>
[Sun Apr 16 00:00:02.631780 2023] [unixd:alert] [pid 187407:tid 281472898655296] AH02155: getpwuid: couldn’t determine user name from uid 4294967295, you pr>
AH00558: httpd: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1. Set the ‘ServerName’ directive globally to suppress >
[Sun Apr 16 00:00:02.633800 2023] [ssl:warn] [pid 2785:tid 281472898655296] AH01909: 127.0.1.1:443:0 server certificate does NOT include an ID which matches>
[Sun Apr 16 00:00:02.633911 2023] [unixd:alert] [pid 187408:tid 281472898655296] AH02155: getpwuid: couldn’t determine user name from uid 4294967295, you pr>
[Sun Apr 16 00:00:02.633982 2023] [lbmethod_heartbeat:notice] [pid 2785:tid 281472898655296] AH02282: No slotmem from mod_heartmonitor
[Sun Apr 16 00:00:02.634165 2023] [mpm_event:notice] [pid 2785:tid 281472898655296] AH00489: Apache/2.4.57 (Unix) OpenSSL/1.1.1 configured – resuming norma>
[Sun Apr 16 00:00:02.634172 2023] [core:notice] [pid 2785:tid 281472898655296] AH00094: Command line: 'httpd -d /snap/nextcloud/34375 -D EnableHTTPS -D Enab>
[Sun Apr 16 00:00:02.635985 2023] [unixd:alert] [pid 187465:tid 281472898655296] AH02155: getpwuid: couldn’t determine user name from uid 4294967295, you pr>
[Sun Apr 16 00:00:02.636392 2023] [unixd:alert] [pid 187466:tid 281472898655296] AH02155: getpwuid: couldn’t determine user name from uid 4294967295, you pr>
[Sun Apr 16 00:00:02.638614 2023] [unixd:alert] [pid 187464:tid 281472898655296] AH02155: getpwuid: couldn’t determine user name from uid 4294967295, you pr>
[Sun Apr 16 01:10:12.020826 2023] [unixd:alert] [pid 193956:tid 281472898655296] AH02155: getpwuid: couldn’t determine user name from uid 4294967295, you pr>
[Mon Apr 17 07:05:52.350939 2023] [proxy_fcgi:error] [pid 193956:tid 281472292352400] [client 178.79.139.171:43300] AH01071: Got error 'Primary script unkno>
[Mon Apr 17 07:05:55.848107 2023] [proxy_fcgi:error] [pid 193956:tid 281472124563856] [client 178.79.139.171:46516] AH01071: Got error 'Primary script unkno>
[Mon Apr 17 07:05:57.890418 2023] [proxy_fcgi:error] [pid 187465:tid 281472711758224] [client 178.79.139.171:48220] AH01071: Got error 'Primary script unkno>
[Mon Apr 17 07:05:58.707348 2023] [proxy_fcgi:error] [pid 193956:tid 281472880349584] [client 178.79.139.171:48908] AH01071: Got error 'Primary script unkno>

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.

{“reqId”:“ZokbGdSvUhxWMKxiQaGH”,“level”:2,“time”:“2023-04-15T23:10:12+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“6GN298dXDRRXjpR7uFw1”,“level”:2,“time”:“2023-04-15T23:10:12+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“ypJ5PCjxL4ahSOeNgqtR”,“level”:2,“time”:“2023-04-15T23:10:12+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“HmkaDCRVS0o6e0xziRcX”,“level”:2,“time”:“2023-04-15T23:10:12+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“bogwXmrt79Tun8VR5rtf”,“level”:2,“time”:“2023-04-16T03:10:14+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“lGOoWIv48oD56ij4o3W9”,“level”:2,“time”:“2023-04-16T03:10:14+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“NpNUvpAzp7NcOYlYjEJt”,“level”:2,“time”:“2023-04-16T03:10:14+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“WBkZCk1EOp9TJTW5WmF6”,“level”:2,“time”:“2023-04-16T03:10:15+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“HuSgEZSSLayV0pSdac91”,“level”:2,“time”:“2023-04-16T07:09:47+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“hBiolQ36JtmzJuRZGsvC”,“level”:2,“time”:“2023-04-16T07:09:47+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“VvRuoFBHR2KvDSNSD3mj”,“level”:2,“time”:“2023-04-16T07:09:47+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“eMDxgrHWrWNVsCa3UKoO”,“level”:2,“time”:“2023-04-16T07:09:47+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“nfZtXbpgGIgdk1bSXq1l”,“level”:2,“time”:“2023-04-16T11:14:52+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“4bJTz0rwSjkj2jwXx3bx”,“level”:2,“time”:“2023-04-16T11:14:52+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“MOvVv9dElXhVShRvopAK”,“level”:2,“time”:“2023-04-16T11:14:52+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“jRA5R2bUDrAAWh0U1A8x”,“level”:2,“time”:“2023-04-16T11:14:52+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“jGeGJlWk8wwQJf00ITtY”,“level”:2,“time”:“2023-04-16T15:17:22+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“H3JuaMQ5281ekGji3ubb”,“level”:2,“time”:“2023-04-16T15:17:22+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“DL0LnN7lRz6fgwmFiLiU”,“level”:2,“time”:“2023-04-16T15:17:22+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“OqZO1niLmVyDcogZeIrz”,“level”:2,“time”:“2023-04-16T15:17:23+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“cqGhdgRFJlDvESKS4jYm”,“level”:2,“time”:“2023-04-16T19:09:56+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“CJyh2drvP4hnAvhFDUqy”,“level”:2,“time”:“2023-04-16T19:09:56+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“qYc7uv7XQJV2mAXTXPG3”,“level”:2,“time”:“2023-04-16T19:09:56+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“ycIZy3mjPdpmE2p8tCls”,“level”:2,“time”:“2023-04-16T19:09:57+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“XG8yPJD2dKE6EFrSoTMs”,“level”:2,“time”:“2023-04-16T19:09:57+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“0rdTHOKbmxDHgiIFVeTP”,“level”:2,“time”:“2023-04-16T23:11:48+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“EhCvb6N4IiJkQHozqBnk”,“level”:2,“time”:“2023-04-16T23:11:48+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“Nb923xtKPkHlgotAM3Ty”,“level”:2,“time”:“2023-04-16T23:11:48+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“j09oboUABOIQGjJNywXZ”,“level”:2,“time”:“2023-04-16T23:11:48+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“RFl3aRbG8d1GaSHwIsBW”,“level”:2,“time”:“2023-04-17T03:18:12+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“HA8LC8MPOOeEBkLRI1rY”,“level”:2,“time”:“2023-04-17T03:18:12+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“05hykMCUMqei4w2ImOOT”,“level”:2,“time”:“2023-04-17T03:18:12+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“r0rF2GelOy74aMBUMUEt”,“level”:2,“time”:“2023-04-17T03:18:12+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“5PV06MNgKROE6g8hevIg”,“level”:2,“time”:“2023-04-17T07:10:51+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“OcQk3OTUjeImhE11wJFu”,“level”:2,“time”:“2023-04-17T07:10:51+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“8eVXlk5Og8bV5mt8woQc”,“level”:2,“time”:“2023-04-17T07:10:51+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

{“reqId”:“mOXRxOPUD6RYGfBYnxK0”,“level”:2,“time”:“2023-04-17T07:10:52+00:00”,“remoteAddr”:“91.83.3.232”,“user”:“deleteduserid”,“app”:“suspicious_login”,“method”:">

4

as I stated above OCI free tier is very limited in term of resources. The specs are far below modern RasPi variants


2 AMD based Compute VMs with 1/8 OCPU** and 1 GB memory each

I would assume this is the root cause for the problem

5

Hi wwe,

I use the Ampere A1 compute with 4 CPUs and 24GB of RAM. I don’t think this would be the issue as I was able to use collabora online before. Searching through the open issues I see many users are facing the exactly same issue.

6

you specs don’t really match OCI free tier


if you already find lot of discussions regarding the issue why don’t you reference them here and check if other found a solution?