Cloud Computing Insider Awards 2022: Vote for ONLYOFFICE
Vote for ONLYOFFICE

Workspace looping at starting page with mysqladmin ping error in docker logs

Community Server/Control Panel version: the latest version I think , can not login to confirm
Type of installation of Workspace (docker, deb/rpm, exe)
OS: ubuntu 20.04 with docker 20.10.12
Browser version: firefox 99.0(x64) , chrome 100.0.4896.75 (X64 )

I download the workspace-install.sh from
https://download.onlyoffice.com/install/workspace-install.sh

and follow this article to install workspace
https://helpcenter.onlyoffice.com/installation/workspace-install-docker.aspx

then I try to open the control panel with
http://workspace_server_ip_address

the page always loopinh between

The portal start up process might take some time, please wait..
We are working on it.
Please do not reload the page or shut down your computer.

and I docker logs keep looping

+ mysqladmin ping -h onlyoffice-mysql-server -P 3306 -u onlyoffice_user --password=onlyoffice_pass --silent
mysqladmin: [Warning] Using a password on the command line interface can be insecure.

and here is my docker status

chchang@ubuntu:~$ docker ps -a
CONTAINER ID   IMAGE                                    COMMAND                  CREATED          STATUS          PORTS                                                                                                                                                                                                                                                                                                 NAMES
3dd190319ef4   onlyoffice/communityserver:11.6.0.1620   "/app/run-community-…"   26 minutes ago   Up 26 minutes   0.0.0.0:80->80/tcp, :::80->80/tcp, 0.0.0.0:443->443/tcp, :::443->443/tcp, 3306/tcp, 5280/tcp, 9865-9866/tcp, 9871/tcp, 9882/tcp, 0.0.0.0:5222->5222/tcp, :::5222->5222/tcp, 9888/tcp                                                                                                                  onlyoffice-community-server
ef80f5a3736d   onlyoffice/controlpanel:3.0.3.410        "/var/www/onlyoffice…"   30 minutes ago   Up 30 minutes   80/tcp, 443/tcp                                                                                                                                                                                                                                                                                       onlyoffice-control-panel
73226cfcebe5   onlyoffice/mailserver:1.6.75             "/bin/sh -c 'export …"   30 minutes ago   Up 30 minutes   0.0.0.0:25->25/tcp, :::25->25/tcp, 0.0.0.0:143->143/tcp, :::143->143/tcp, 0.0.0.0:465->465/tcp, :::465->465/tcp, 0.0.0.0:587->587/tcp, :::587->587/tcp, 0.0.0.0:993->993/tcp, :::993->993/tcp, 0.0.0.0:995->995/tcp, :::995->995/tcp, 3306/tcp, 0.0.0.0:4190->4190/tcp, :::4190->4190/tcp, 8081/tcp   onlyoffice-mail-server
31c2c56cfc4e   onlyoffice/documentserver:7.0.1.37       "/app/ds/run-documen…"   32 minutes ago   Up 32 minutes   80/tcp, 443/tcp                                                                                                                                                                                                                                                                                       onlyoffice-document-server
108d789e5412   mysql:8.0                                "docker-entrypoint.s…"   37 minutes ago   Created                                                                                                                                                                                                                                                                                                               onlyoffice-mysql-server
chchang@ubuntu:~$ 

this is a fresh VM , and I follow all steps in the installation document. and I have no idea how to debug.
any suggestions to fix ??

Hello @chchang,

From your references I can see that the container with MySQL did not start.
I’d recommend to start with checking available disk space by executing df -h command and providing us with the results.
Also you can try to restart the container manually by running docker restart onlyoffice-mysql-server

Bug report



Port forwards appear to be different from the original post. Are they different enough to prevent this from moving beyond startup screen?
Disk space does not appear to be an issue.
Is this the expected behavior when the server is unable to connect to the database?
Mysql server appears to be running ok from the log data:
docker ps and log data:

docker ps -a
CONTAINER ID   IMAGE                                  COMMAND                  CREATED        STATUS              PORTS                                                                                                                            NAMES
21c9416a1f77   onlyoffice/communityserver:latest      "/app/run-community-…"   20 hours ago   Up 2 minutes        443/tcp, 3306/tcp, 5222/tcp, 5280/tcp, 9865-9866/tcp, 9871/tcp, 9882/tcp, 9888/tcp, 0.0.0.0:8888->80/tcp, 0.0.0.0:8222->88/tcp   onlyoffice-community-server
c8c90021a564   mysql:5.7                              "docker-entrypoint.s…"   20 hours ago   Up About a minute   0.0.0.0:3306->3306/tcp, 33060/tcp                                                                                                onlyoffice-mysql-server

Myql Log Data


2022-09-21T11:57:20.020927Z 0 [Note] Event Scheduler: Loaded 0 events
2022-09-21T11:57:20.021354Z 0 [Note] mysqld: ready for connections.
Version: '5.7.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2022-09-21T12:01:31.620417Z 0 [Note] Giving 0 client threads a chance to die gracefully
2022-09-21T12:01:31.620478Z 0 [Note] Shutting down slave threads
2022-09-21T12:01:31.620497Z 0 [Note] Forcefully disconnecting 0 remaining clients
2022-09-21T12:01:31.620527Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-09-21T12:01:31.620656Z 0 [Note] Binlog end
2022-09-21T12:01:31.621429Z 0 [Note] Shutting down plugin 'ngram'
2022-09-21T12:01:31.621461Z 0 [Note] Shutting down plugin 'partition'
2022-09-21T12:01:31.621480Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-09-21T12:01:31.621501Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-09-21T12:01:31.621514Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-09-21T12:01:31.621562Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-09-21T12:01:31.621584Z 0 [Note] Shutting down plugin 'MyISAM'
2022-09-21T12:01:31.621608Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-09-21T12:01:31.621630Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-09-21T12:01:31.621647Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-09-21T12:01:31.621664Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-09-21T12:01:31.621675Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-09-21T12:01:31.621684Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-09-21T12:01:31.621694Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-09-21T12:01:31.621706Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-09-21T12:01:31.621728Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-09-21T12:01:31.621739Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-09-21T12:01:31.621749Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-09-21T12:01:31.621763Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-09-21T12:01:31.621773Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-09-21T12:01:31.621785Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-09-21T12:01:31.621798Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-09-21T12:01:31.621813Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-09-21T12:01:31.621826Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-09-21T12:01:31.621841Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-09-21T12:01:31.621857Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-09-21T12:01:31.621876Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-09-21T12:01:31.621887Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-09-21T12:01:31.621897Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-09-21T12:01:31.621910Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-09-21T12:01:31.621923Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-09-21T12:01:31.621940Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-09-21T12:01:31.621950Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-09-21T12:01:31.621961Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-09-21T12:01:31.621970Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-09-21T12:01:31.621985Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-09-21T12:01:31.621998Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-09-21T12:01:31.622007Z 0 [Note] Shutting down plugin 'InnoDB'
2022-09-21T12:01:31.622143Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-09-21T12:01:31.622321Z 0 [Note] InnoDB: Starting shutdown...
2022-09-21T12:01:31.722577Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-09-21T12:01:31.723171Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220921 12:01:31
2022-09-21T12:01:32.969979Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12141514
2022-09-21T12:01:32.972329Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-21T12:01:32.972390Z 0 [Note] Shutting down plugin 'MEMORY'
2022-09-21T12:01:32.972405Z 0 [Note] Shutting down plugin 'CSV'
2022-09-21T12:01:32.972414Z 0 [Note] Shutting down plugin 'sha256_password'
2022-09-21T12:01:32.972419Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-09-21T12:01:32.972630Z 0 [Note] Shutting down plugin 'binlog'
2022-09-21T12:01:32.975530Z 0 [Note] mysqld: Shutdown complete

2022-09-21 12:01:41+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.39-1.el7 started.
2022-09-21 12:01:42+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2022-09-21 12:01:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.39-1.el7 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2022-09-21T12:01:43.450680Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-21T12:01:43.452715Z 0 [Note] mysqld (mysqld 5.7.39) starting as process 1 ...
2022-09-21T12:01:43.457548Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-09-21T12:01:43.457589Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-21T12:01:43.457597Z 0 [Note] InnoDB: Uses event mutexes
2022-09-21T12:01:43.457604Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-21T12:01:43.457620Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-09-21T12:01:43.457629Z 0 [Note] InnoDB: Using Linux native AIO
2022-09-21T12:01:43.457995Z 0 [Note] InnoDB: Number of pools: 1
2022-09-21T12:01:43.467907Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-09-21T12:01:43.470236Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-21T12:01:43.483145Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-21T12:01:43.485660Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-09-21T12:01:43.636510Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-21T12:01:44.238419Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-21T12:01:44.238652Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-21T12:01:44.815209Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-21T12:01:44.816679Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-09-21T12:01:44.816701Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-09-21T12:01:44.817219Z 0 [Note] InnoDB: 5.7.39 started; log sequence number 12141514
2022-09-21T12:01:44.817385Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-09-21T12:01:44.819651Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-09-21T12:01:45.023418Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-09-21T12:01:45.023446Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-09-21T12:01:45.023455Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:01:45.023460Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:01:45.080757Z 0 [Warning] CA certificate ca.pem is self signed.
2022-09-21T12:01:45.080824Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-09-21T12:01:45.081327Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-09-21T12:01:45.081374Z 0 [Note] IPv6 is available.
2022-09-21T12:01:45.081395Z 0 [Note]   - '::' resolves to '::';
2022-09-21T12:01:45.081422Z 0 [Note] Server socket created on IP: '::'.
2022-09-21T12:01:45.243775Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2022-09-21T12:01:45.618210Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 12:01:45
2022-09-21T12:01:45.958780Z 0 [Note] Event Scheduler: Loaded 0 events
2022-09-21T12:01:45.959120Z 0 [Note] mysqld: ready for connections.
Version: '5.7.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)

onlyoffice Community server log data:

+ REDIS_SERVER_CACHEPORT=6379
+ REDIS_SERVER_PASSWORD=
+ REDIS_SERVER_SSL=false
+ REDIS_SERVER_DATABASE=0
+ REDIS_SERVER_CONNECT_TIMEOUT=5000
+ REDIS_SERVER_EXTERNAL=false
+ '[' ']'
+ '[' false == false ']'
+ '[' -e /etc/redis/redis.conf ']'
+ sed -i 's/bind .*/bind 127.0.0.1/g' /etc/redis/redis.conf
+ ELASTICSEARCH_SERVER_HOST=
+ ELASTICSEARCH_SERVER_HTTPPORT=9200
+ grep -q '<section name="elastic" type="ASC.ElasticSearch.Config.ElasticSection, ASC.ElasticSearch" />' /var/www/onlyoffice/WebStudio/Web.config
+ '[' ']'
+ '[' true == false ']'
+ service mysql stop
 * Stopping MySQL database server mysqld        
[ OK ]
+ systemctl disable mysql.service
Synchronizing state of mysql.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install disable mysql
+ mysql_check_connection
+ '[' ']'
+ mysqladmin ping -h onlyoffice-mysql-server -P 3306 -u onlyoffice_user --password=1234567B --silent
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
+ sleep 1

Hello @mstrstvns
Please point us to the guide which you used for installation. I see MySQL v.5.7, but we use 8.0 in the latest installations. Also I don’t see Control Panel container in your docker ps output result.