Getting socket errors and 502 errors on OL8.6

Hello everyone, I’ve got a problem with starting OnlyOffice on Oracle Linux Server 8.6, some help will be appreciated.
I’m using docker-versions of “Community server”, “Document server” and “Control
panel” + local MySQL-server, installed on the same host, but not in docker-container.

How the installation went (main steps):

  1. Intalled MySQL server (version 5.7.39) locally on host, created database “onlyoffice”, user “onlyoffice_user” with password “onlyoffice_pass”, granted privileges;

  2. Followed the steps by this guide

But I’ve missed step 2 (because I don’t need docker-containered MySQL), missed step 4 (I don’t need mail server now), and in step 6 I’ve done it this way:

sudo docker run --net onlyoffice -i -t -d --privileged --restart=always --name onlyoffice-community-server -p 80:80 -p 443:443 -p 5222:5222
-e MYSQL_SERVER_HOST=172.18.0.1
-e MYSQL_SERVER_PORT=“3306”
-e MYSQL_SERVER_DB_NAME=onlyoffice
-e MYSQL_SERVER_USER=onlyoffice_user
-e MYSQL_SERVER_PASS=onlyoffice_pass
-e DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server
-e CONTROL_PANEL_PORT_80_TCP=80
-e CONTROL_PANEL_PORT_80_TCP_ADDR=onlyoffice-control-panel
-v /app/onlyoffice/CommunityServer/letsencrypt:/etc/letsencrypt
-v /sys/fs/cgroup:/sys/fs/cgroup:rw
-v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data
-v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice
-v /app/onlyoffice/DocumentServer/data:/var/www/onlyoffice/DocumentServerData
onlyoffice/communityserver

Now, when I’m entering IP-address of my host in browser I get the following error:

Application Exception
# Runtime Error
## A runtime error has occurred
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed (for security reasons).
Details: To enable the details of this specific error message to be viewable, please create a tag within a “web.config” configuration file located in the root directory of the current web application. This tag should then have its “mode” attribute set to “Off”.
<system.web> </system.web>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the “defaultRedirect” attribute of the application’s configuration tag to point to a custom error page URL.
<system.web> </system.web>
Version Information: 6.8.0.123 (tarball Tue May 12 15:11:57 UTC 2020); ASP.NET Version: 4.0.30319.42000
Powered by [Mono]

Sometimes the situation changes and web-page shows:

Error 502. App Crash
The server was unable to complete your request.

instead of the runtime error above.

/app/onlyoffice/CommunityServer/logs/nginx.error.log contents:

*2022/11/30 10:21:17 [crit] 404#404: 1 connect() to unix:/var/run/onlyoffice/onlyoffice.socket failed (2: No such file or directory) while connecting to upstream, client: 10.0.119.189, server: , request: “GET /TenantLogo.ashx?logotype=3 HTTP/1.1”, upstream: “fastcgi://unix:/var/run/onlyoffice/onlyoffice.socket:”, host: “10.0.119.190”, referrer: “http://10.0.119.190/

If I do
sudo docker exec -i -t a55675c2c480 systemctl status monoserve
I get:

monoserve.service - FastCGI Mono server

  • Loaded: loaded (/lib/systemd/system/monoserve.service; enabled; vendor preset: enabled)*
  • Active: active (running) since Wed 2022-11-30 10:28:20 UTC; 30s ago*
  • Process: 4292 ExecStartPre=/bin/bash -c test -e /var/run/onlyoffice || install -m 755 -o onlyoffice -g nginx -d /var/run/onlyoffice; rm -f /var/run/onlyoffice/onlyoffice.socket /var/www/onlyoffice/WebStudio/m*
    ono_crash /var/www/onlyoffice/WebStudio/core.; (code=exited, status=0/SUCCESS)
  • Main PID: 4294 (mono)*
  • Tasks: 35 (limit: 8826)*
  • CGroup: /docker/a55675c2c4801ee7a443abb7b78700954efb74c5b793fc40a6669de30d2804a9/system.slice/monoserve.service*
  •       └─4294 /usr/bin/mono /usr/lib/hyperfastcgi/4.0/HyperFastCgi.exe /config=/etc/hyperfastcgi/onlyoffice /logfile=/var/log/onlyoffice/onlyoffice.log /loglevels=Error*
    

Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: at ASC.Core.TenantManager.GetTenant (System.String domain) [0x0001f] in <289eba5fc2ef4c3a9bc560fddf6ec9c8>:0
Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: at ASC.Core.TenantManager.GetCurrentTenant (System.Boolean throwIfNotFound) [0x00047] in <289eba5fc2ef4c3a9bc560fddf6ec9c8>:0
Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: at ASC.Common.Logging.LogManager+<>c.b__0_0 () [0x00005] in <289eba5fc2ef4c3a9bc560fddf6ec9c8>:0
Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: at ASC.Common.Logging.LogNLog.Log (NLog.LogEventInfo theEvent) [0x00008] in <71cb3d721bb9413ea8360000a194c805>:0
Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: at ASC.Common.Logging.LogNLog.Log (NLog.LogLevel level, System.Object message) [0x00025] in <71cb3d721bb9413ea8360000a194c805>:0
Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: at ASC.Common.Logging.LogNLog.Error (System.Object message) [0x00000] in <71cb3d721bb9413ea8360000a194c805>:0
Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: at ASC.Api.ApiSetupHttpModule.Init (System.Web.HttpApplication context) [0x00053] in <1174082600f44859b26bb99bb8c52778>:0
Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: at System.Web.Configuration.HttpModulesSection.LoadModules (System.Web.HttpApplication app) [0x00047] in :0
Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: at System.Web.HttpApplication.InitOnce (System.Boolean full_init) [0x0008e] in :0
Nov 30 10:28:31 a55675c2c480 hyperfastcgi4[4294]: Please restart your app to unlock it

Missed the link on “this guide”, sorry. That’s how it should be:

How the installation went (main steps):

  1. Intalled MySQL server (version 5.7.39) locally on host, created database “onlyoffice”, user “onlyoffice_user” with password “onlyoffice_pass”, granted privileges;
  2. Followed the steps by this guide

Hello @Escapism
Is it possible to use MySQL v.8? We have updated this dependency with Community server v.12.1: https://github.com/ONLYOFFICE/CommunityServer/blob/master/CHANGELOG.md#general-portal-changes
If it doesn’t help, please provide us with whole Community server logs folder. It’s located here:
/app/onlyoffice/CommunityServer/logs/

Thank you for your reply, @Alexandre
It is surely possible to use MySQL v.8, I thought it was mandatory to use v. 5.7., but now I see it’s not, thanks to you :slight_smile:
Installed v. 8, restarted “Community server” container, but it’s still the same behavior - either “Runtime Error” or “Error 502” occurs.
I will send you /app/onlyoffice/CommunityServer/logs/ as a tar archive right now via PM.

Can’t send you a private message and can’t attach tar archive directly to this message, so I’ll just leave the link here.
Thanks a lot for helping me!

Could you please double-check your log folder? I didn’t find web.log or web.api.log files in the provided logs. something is going wrong, but these log files should be there.

Checked it once more - no web.log or web.api.log there, unfortunately.

sudo ls -l /app/onlyoffice/CommunityServer/logs/ result:

итого 50032
drwxr-xr-x 2 103 104 4096 дек 5 09:03 Index
drwxr-xr-x 2 104 107 8192 дек 5 09:03 mail
-rw-r–r-- 1 104 107 12289163 дек 5 18:08 nginx.access.log
-rw-r–r-- 1 104 107 0 ноя 23 17:21 nginx.apisystem.access.log
-rw-r–r-- 1 104 107 0 ноя 23 17:21 nginx.apisystem.error.log
-rw-r–r-- 1 104 107 136717 дек 5 10:53 nginx.error.log
-rw-r–r-- 1 104 107 0 ноя 23 17:23 onlyofficeApiSystem.log
-rw-r–r-- 1 104 107 0 ноя 23 17:23 onlyoffice.log
-rw-r–r-- 1 104 107 0 ноя 30 09:44 svcAutoCleanUp.log
-rw-r–r-- 1 104 107 2203 ноя 24 03:11 svcBackup.11-23.0.zip
-rw-r–r-- 1 104 107 4674 ноя 25 03:14 svcBackup.11-24.0.zip
-rw-r–r-- 1 104 107 2992 ноя 26 03:14 svcBackup.11-25.0.zip
-rw-r–r-- 1 104 107 2983 ноя 27 03:14 svcBackup.11-26.0.zip
-rw-r–r-- 1 104 107 2981 ноя 28 03:14 svcBackup.11-27.0.zip
-rw-r–r-- 1 104 107 3044 ноя 29 03:10 svcBackup.11-28.0.zip
-rw-r–r-- 1 104 107 2998 ноя 30 03:10 svcBackup.11-29.0.zip
-rw-r–r-- 1 104 107 3060 дек 1 03:06 svcBackup.11-30.0.zip
-rw-r–r-- 1 104 107 2969 дек 2 03:06 svcBackup.12-01.0.zip
-rw-r–r-- 1 104 107 3049 дек 5 09:03 svcBackup.12-02.0.zip
-rw-r–r-- 1 104 107 90308 дек 5 18:03 svcBackup.log
-rw-r–r-- 1 104 107 6061 ноя 24 03:02 svcFeed.11-23.0.zip
-rw-r–r-- 1 104 107 13446 ноя 25 03:02 svcFeed.11-24.0.zip
-rw-r–r-- 1 104 107 12071 ноя 26 03:02 svcFeed.11-25.0.zip
-rw-r–r-- 1 104 107 12056 ноя 27 03:02 svcFeed.11-26.0.zip
-rw-r–r-- 1 104 107 12144 ноя 28 03:02 svcFeed.11-27.0.zip
-rw-r–r-- 1 104 107 12115 ноя 29 03:02 svcFeed.11-28.0.zip
-rw-r–r-- 1 104 107 12094 ноя 30 03:02 svcFeed.11-29.0.zip
-rw-r–r-- 1 104 107 11947 дек 1 03:00 svcFeed.11-30.0.zip
-rw-r–r-- 1 104 107 12135 дек 2 03:00 svcFeed.12-01.0.zip
-rw-r–r-- 1 104 107 9968 дек 5 09:03 svcFeed.12-02.0.zip
-rw-r–r-- 1 104 107 501641 дек 5 18:06 svcFeed.log
-rw-r–r-- 1 104 107 105268 ноя 24 03:00 svcIndexer.data.11-23.0.zip
-rw-r–r-- 1 104 107 259546 ноя 25 03:00 svcIndexer.data.11-24.0.zip
-rw-r–r-- 1 104 107 259907 ноя 26 03:00 svcIndexer.data.11-25.0.zip
-rw-r–r-- 1 104 107 259923 ноя 27 03:00 svcIndexer.data.11-26.0.zip
-rw-r–r-- 1 104 107 259814 ноя 28 03:00 svcIndexer.data.11-27.0.zip
-rw-r–r-- 1 104 107 259568 ноя 29 03:00 svcIndexer.data.11-28.0.zip
-rw-r–r-- 1 104 107 259789 ноя 30 03:00 svcIndexer.data.11-29.0.zip
-rw-r–r-- 1 104 107 615994 ноя 30 23:57 svcIndexer.data.11-30.0.zip
-rw-r–r-- 1 104 107 132781 дек 1 03:00 svcIndexer.data.11-30.1.zip
-rw-r–r-- 1 104 107 672733 дек 1 18:32 svcIndexer.data.12-01.0.zip
-rw-r–r-- 1 104 107 366953 дек 2 03:00 svcIndexer.data.12-01.1.zip
-rw-r–r-- 1 104 107 530003 дек 5 09:04 svcIndexer.data.12-02.0.zip
-rw-r–r-- 1 104 107 30545109 дек 5 18:07 svcIndexer.data.log
-rw-r–r-- 1 104 107 696 ноя 24 08:00 svcNotify.11-23.0.zip
-rw-r–r-- 1 104 107 229909 ноя 25 08:00 svcNotify.11-24.0.zip
-rw-r–r-- 1 104 107 1242 ноя 26 08:00 svcNotify.11-25.0.zip
-rw-r–r-- 1 104 107 1244 ноя 27 08:00 svcNotify.11-26.0.zip
-rw-r–r-- 1 104 107 1241 ноя 28 08:00 svcNotify.11-27.0.zip
-rw-r–r-- 1 104 107 2139 ноя 29 08:00 svcNotify.11-28.0.zip
-rw-r–r-- 1 104 107 1241 ноя 30 08:00 svcNotify.11-29.0.zip
-rw-r–r-- 1 104 107 2377 дек 1 08:00 svcNotify.11-30.0.zip
-rw-r–r-- 1 104 107 1244 дек 2 08:00 svcNotify.12-01.0.zip
-rw-r–r-- 1 104 107 28776 дек 5 09:03 svcNotify.12-02.0.zip
-rw-r–r-- 1 104 107 4204 дек 5 15:00 svcNotify.log
-rw-r–r-- 1 104 107 0 ноя 23 17:23 web.socketio.log.11-23
-rw-r–r-- 1 104 107 0 ноя 24 08:51 web.socketio.log.11-24
-rw-r–r-- 1 104 107 0 ноя 28 14:55 web.socketio.log.11-28
-rw-r–r-- 1 104 107 0 ноя 30 09:44 web.socketio.log.11-30
-rw-r–r-- 1 104 107 0 дек 2 13:47 web.socketio.log.12-02
-rw-r–r-- 1 104 107 0 дек 5 09:03 web.socketio.log.12-05
-rw-r–r-- 1 104 107 34928 ноя 24 03:00 web.sql.11-23.0.zip
-rw-r–r-- 1 104 107 79718 ноя 25 03:00 web.sql.11-24.0.zip
-rw-r–r-- 1 104 107 88690 ноя 26 03:00 web.sql.11-25.0.zip
-rw-r–r-- 1 104 107 88773 ноя 27 03:00 web.sql.11-26.0.zip
-rw-r–r-- 1 104 107 88843 ноя 28 03:00 web.sql.11-27.0.zip
-rw-r–r-- 1 104 107 88782 ноя 29 03:00 web.sql.11-28.0.zip
-rw-r–r-- 1 104 107 88595 ноя 30 03:00 web.sql.11-29.0.zip
-rw-r–r-- 1 104 107 86740 дек 1 03:00 web.sql.11-30.0.zip
-rw-r–r-- 1 104 107 88722 дек 2 03:00 web.sql.12-01.0.zip
-rw-r–r-- 1 104 107 60301 дек 5 09:04 web.sql.12-02.0.zip
-rw-r–r-- 1 104 107 994151 дек 5 18:08 web.sql.log
-rw-r–r-- 1 104 107 9244 ноя 24 03:00 web.sso.11-23.log.gz
-rw-r–r-- 1 104 107 22956 ноя 25 03:00 web.sso.11-24.log.gz
-rw-r–r-- 1 104 107 22742 ноя 26 03:00 web.sso.11-25.log.gz
-rw-r–r-- 1 104 107 22691 ноя 27 03:00 web.sso.11-26.log.gz
-rw-r–r-- 1 104 107 22649 ноя 28 03:00 web.sso.11-27.log.gz
-rw-r–r-- 1 104 107 22893 ноя 29 03:00 web.sso.11-28.log.gz
-rw-r–r-- 1 104 107 22823 ноя 30 03:00 web.sso.11-29.log.gz
-rw-r–r-- 1 104 107 22951 дек 1 03:00 web.sso.11-30.log.gz
-rw-r–r-- 1 104 107 22821 дек 2 03:00 web.sso.12-01.log.gz
-rw-r–r-- 1 104 107 722572 дек 2 19:28 web.sso.12-02.log
-rw-r–r-- 1 104 107 398384 дек 5 18:08 web.sso.12-05.log
-rw-r–r-- 1 104 107 0 ноя 23 17:21 web.thumbnails.log.11-23
-rw-r–r-- 1 104 107 0 ноя 24 08:51 web.thumbnails.log.11-24
-rw-r–r-- 1 104 107 0 ноя 28 14:55 web.thumbnails.log.11-28
-rw-r–r-- 1 104 107 0 ноя 30 09:43 web.thumbnails.log.11-30
-rw-r–r-- 1 104 107 0 дек 2 13:46 web.thumbnails.log.12-02
-rw-r–r-- 1 104 107 0 дек 5 09:02 web.thumbnails.log.12-05
-rw-r–r-- 1 104 107 0 ноя 23 17:23 web.urlshortener.log.11-23
-rw-r–r-- 1 104 107 0 ноя 24 08:51 web.urlshortener.log.11-24
-rw-r–r-- 1 104 107 0 ноя 28 14:55 web.urlshortener.log.11-28
-rw-r–r-- 1 104 107 0 ноя 30 09:44 web.urlshortener.log.11-30
-rw-r–r-- 1 104 107 0 дек 2 13:47 web.urlshortener.log.12-02
-rw-r–r-- 1 104 107 0 дек 5 09:02 web.urlshortener.log.12-05
-rw-r–r-- 1 104 107 0 ноя 23 17:23 web.webdav.log.11-23
-rw-r–r-- 1 104 107 0 ноя 24 08:51 web.webdav.log.11-24
-rw-r–r-- 1 104 107 0 ноя 28 14:56 web.webdav.log.11-28
-rw-r–r-- 1 104 107 0 ноя 30 09:44 web.webdav.log.11-30
-rw-r–r-- 1 104 107 0 дек 2 13:47 web.webdav.log.12-02
-rw-r–r-- 1 104 107 0 дек 5 09:03 web.webdav.log.12-05

Please clarify if 172.18.0.1 is your MySQL server. It looks like Community server can’t connect to MySQL.
One more thing:

-e MYSQL_SERVER_PORT=“3306”

Please try to change it to -e MYSQL_SERVER_PORT=3306
If it doesn’t help, please provide us with Community server container logs (docker logs onlyoffice-community-server command).

Tried it this way:
-e MYSQL_SERVER_PORT=3306
but the result is still the same.

172.18.0.1 is IP-address of bridge on my host machine (where MySQL server and docker is installed) in docker network.

sudo ip addr on host machine shows:

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp1s0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000
link/ether 52:54:00:44:cb:4c brd ff:ff:ff:ff:ff:ff
inet 10.0.119.190/24 brd 10.0.119.255 scope global noprefixroute enp1s0
valid_lft forever preferred_lft forever
inet6 2a00:1020:100:1977:3885:825e:e6f3:be25/128 scope global dynamic noprefixroute
valid_lft 160892sec preferred_lft 74492sec
inet6 2a00:1020:100:1977:5054:ff:fe44:cb4c/64 scope global dynamic noprefixroute
valid_lft 2591938sec preferred_lft 604738sec
inet6 fe80::5054:ff:fe44:cb4c/64 scope link noprefixroute
valid_lft forever preferred_lft forever
3: docker0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default
link/ether 02:42:32:4f:df:b6 brd ff:ff:ff:ff:ff:ff
inet 172.17.0.1/16 brd 172.17.255.255 scope global docker0
valid_lft forever preferred_lft forever
4: br-be7a9bb1ab64: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP group default
link/ether 02:42:18:c3:2e:f4 brd ff:ff:ff:ff:ff:ff
inet 172.18.0.1/16 brd 172.18.255.255 scope global br-be7a9bb1ab64
valid_lft forever preferred_lft forever
inet6 fe80::42:18ff:fec3:2ef4/64 scope link
valid_lft forever preferred_lft forever
16: vethf12c11e@if15: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue master br-be7a9bb1ab64 state UP group default
link/ether 32:23:b4:79:17:15 brd ff:ff:ff:ff:ff:ff link-netnsid 0
inet6 fe80::3023:b4ff:fe79:1715/64 scope link
valid_lft forever preferred_lft forever
18: veth3f3b5d4@if17: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue master br-be7a9bb1ab64 state UP group default
link/ether 3e:08:00:87:7b:73 brd ff:ff:ff:ff:ff:ff link-netnsid 1
inet6 fe80::3c08:ff:fe87:7b73/64 scope link
valid_lft forever preferred_lft forever
26: veth4aa35e9@if25: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue master br-be7a9bb1ab64 state UP group default
link/ether 26:42:98:fa:c2:db brd ff:ff:ff:ff:ff:ff link-netnsid 2
inet6 fe80::2442:98ff:fefa:c2db/64 scope link

Should I use 172.17.0.1 instead? It seems kinda weird to me, because if i do
sudo docker exec -it onlyoffice-community-server ip addr it shows:

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
25: eth0@if26: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP group default
link/ether 02:42:ac:12:00:04 brd ff:ff:ff:ff:ff:ff link-netnsid 0
inet 172.18.0.4/16 brd 172.18.255.255 scope global eth0
valid_lft forever preferred_lft forever

Also, if I do
sudo docker exec -it onlyoffice-community-server mysql -h 172.18.0.1 -u onlyoffice_user --password=onlyoffice_pass -P 3306
it succesfully connects to MySQL:

mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6996
Server version: 8.0.30 Source distribution

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

There I can do show databases;, for example, and get:

±-------------------+
| Database |
±-------------------+
| information_schema |
| onlyoffice |
| performance_schema |
±-------------------+
3 rows in set (0.03 sec)

Community server container logs download link.

Hello @Escapism
Please go to the host and run docker inspect ID_of_MySQL_container. Please check address of container in the output result. Will it be the same as you have set up?

Hello, @Alexandre
Beg your pardon for the late reply.
Once again - MySQL is runned not in docker container :slight_smile:

I’ve got a host machine, let’s call it srv-onlyoffice
On this machine I’ve got locally installed MySQL server (v. 8) + 3 docker containers (community server, document server and control panel).

Hello @Escapism

There I can do show databases;, for example, and get:

±-------------------+
| Database |
±-------------------+
| information_schema |
| onlyoffice |
| performance_schema |

Could you please check out onlyoffice database? Is there webstudio_settings table? Please show us its contents.

@Alexandre
No, unfortunately there’s no such table.
Cheking tables in onlyoffice:

sudo docker exec -it onlyoffice-community-server mysql -h 172.18.0.1 -u onlyoffice_user --password=onlyoffice_pass -P 3306

mysql > show databases;

±-------------------+
| Database |
±-------------------+
| information_schema |
| onlyoffice |
| performance_schema |
±-------------------+
3 rows in set (0.40 sec)

mysql> show tables from onlyoffice;

±---------------------------------------------+
| Tables_in_onlyoffice |
±---------------------------------------------+
| account_links |
| audit_events |
| backup_backup |
| backup_schedule |
| blogs_comments |
| blogs_posts |
| blogs_reviewposts |
| blogs_tags |
| bookmarking_bookmark |
| bookmarking_bookmarktag |
| bookmarking_comment |
| bookmarking_tag |
| bookmarking_userbookmark |
| bookmarking_userbookmarktag |
| calendar_calendar_item |
| calendar_calendar_user |
| calendar_calendars |
| calendar_event_history |
| calendar_event_item |
| calendar_event_user |
| calendar_events |
| calendar_notifications |
| calendar_todos |
| core_acl |
| core_group |
| core_settings |
| core_subscription |
| core_subscriptionmethod |
| core_user |
| core_userdav |
| core_usergroup |
| core_userphoto |
| core_usersecurity |
| crm_case |
| crm_contact |
| crm_contact_info |
| crm_currency_info |
| crm_currency_rate |
| crm_deal |
| crm_deal_milestone |
| crm_entity_contact |
| crm_entity_tag |
| crm_field_description |
| crm_field_value |
| crm_invoice |
| crm_invoice_item |
| crm_invoice_line |
| crm_invoice_tax |
| crm_list_item |
| crm_organisation_logo |
| crm_projects |
| crm_relationship_event |
| crm_report_file |
| crm_tag |
| crm_task |
| crm_task_template |
| crm_task_template_container |
| crm_task_template_task |
| crm_voip_calls |
| crm_voip_number |
| dbip_location |
| dbsync_last |
| events_comment |
| events_feed |
| events_poll |
| events_pollanswer |
| events_pollvariant |
| events_reader |
| feed_aggregate |
| feed_last |
| feed_readed |
| feed_users |
| files_bunch_objects |
| files_converts |
| files_file |
| files_folder |
| files_folder_tree |
| files_link |
| files_properties |
| files_security |
| files_tag |
| files_tag_link |
| files_thirdparty_account |
| files_thirdparty_app |
| files_thirdparty_id_mapping |
| firebase_users |
| forum_answer |
| forum_answer_variant |
| forum_attachment |
| forum_category |
| forum_lastvisit |
| forum_post |
| forum_question |
| forum_tag |
| forum_thread |
| forum_topic |
| forum_topic_tag |
| forum_topicwatch |
| forum_variant |
| install_registration |
| jabber_archive |
| jabber_archive_switch |
| jabber_clear |
| jabber_offactivity |
| jabber_offmessage |
| jabber_offpresence |
| jabber_private |
| jabber_push |
| jabber_room |
| jabber_room_history |
| jabber_roster |
| jabber_vcard |
| login_events |
| mail_alerts |
| mail_attachment |
| mail_chain |
| mail_chain_x_crm_entity |
| mail_contact_info |
| mail_contacts |
| mail_display_images |
| mail_filter |
| mail_folder |
| mail_folder_counters |
| mail_imap_flags |
| mail_imap_special_mailbox |
| mail_mail |
| mail_mailbox |
| mail_mailbox_autoreply |
| mail_mailbox_autoreply_history |
| mail_mailbox_domain |
| mail_mailbox_provider |
| mail_mailbox_server |
| mail_mailbox_signature |
| mail_pop_unordered_domain |
| mail_server_address |
| mail_server_dns |
| mail_server_domain |
| mail_server_mail_group |
| mail_server_mail_group_x_mail_server_address |
| mail_server_server |
| mail_server_server_type |
| mail_server_server_x_tenant |
| mail_tag |
| mail_tag_addresses |
| mail_tag_mail |
| mail_user_folder |
| mail_user_folder_tree |
| mail_user_folder_x_mail |
| mobile_app_install |
| notify_info |
| notify_promotion_watch |
| notify_queue |
| notify_tip_watch |
| projects_comments |
| projects_following_project_participant |
| projects_messages |
| projects_milestones |
| projects_project_participant |
| projects_project_tag |
| projects_projects |
| projects_report_template |
| projects_reports |
| projects_status |
| projects_subtasks |
| projects_tags |
| projects_tasks |
| projects_tasks_links |
| projects_tasks_order |
| projects_tasks_recurrence |
| projects_tasks_responsible |
| projects_templates |
| projects_time_tracking |
| res_authors |
| res_authorsfile |
| res_authorslang |
| res_cultures |
| res_data |
±---------------------------------------------+
177 rows in set (0.43 sec)

Hello @Escapism
There’re a lot of missed tables in the provided output result.
Please try to run onlyoffice.sql and onlyoffice.data.sql scripts manually. They’re located in Community server container ( /var/www/onlyoffice/Sql/)
Example of the command: docker exec -it onlyoffice-community-server mysql -u root -pmy-secret-pw -h onlyoffice-mysql-server -D onlyoffice onlyoffice < /var/www/onlyoffice/Sql/onlyoffice.sql

Also please clarify if you ran these steps to set up MySQL DB: https://github.com/ONLYOFFICE/Docker-CommunityServer#installing-mysql

Hello @Alexandre
The problem was that I forgot to add following to MySQL config:

sql_mode = ‘NO_ENGINE_SUBSTITUTION’
max_connections = 1000
max_allowed_packet = 1048576000
group_concat_max_len = 2048"

Now the portal started!
Thanks a lot for your help!!! :slight_smile:

I wish you a Merry Christmas and a happy New Year! :blush:

Hello @Escapism
We are glad that the issue is solved.
Please feel free to contact us if you face any issues.