Waiting for MySQL to start

Get Help CMS Installation
1

CMS

Version 2.3.4

Installation Method

Docker

Operating System

Debian

Issue

I can’t get the Xibo Docker installation to run.
It is a complete new installation.
See error messages below

docker ps - everything looks fine in my opinion

docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
31cd54b44467 xibosignage/xibo-cms:release-2.3.4 “/entrypoint.sh” 30 minutes ago Up 3 minutes 0.0.0.0:80->80/tcp xibo_cms-web_1
f2d4ea2eb7fc mysql:5.6 “docker-entrypoint.s…” 30 minutes ago Up 26 minutes 3306/tcp xibo_cms-db_1
75373b3eb0da ianw/quickchart “node --max-http-hea…” 30 minutes ago Up 30 minutes 3400/tcp xibo_cms-quickchart_1
435129d7a728 xibosignage/xibo-xmr:release-0.8 “/entrypoint.sh” 30 minutes ago Up 30 minutes 0.0.0.0:9505->9505/tcp, 50001/tcp xibo_cms-xmr_1

docker-compose ps
Name Command State Ports

xibo_cms-db_1 docker-entrypoint.sh mysqld Up 3306/tcp
xibo_cms-quickchart_1 node --max-http-header-siz … Up 3400/tcp
xibo_cms-web_1 /entrypoint.sh Up 0.0.0.0:80->80/tcp
xibo_cms-xmr_1 /entrypoint.sh Up 50001/tcp, 0.0.0.0:9505->9505/tcp

mysql password was set before installation

docker-compose Logs

root@mmz-xibo-01:/opt/xibo# docker-compose logs
Attaching to xibo_cms-web_1, xibo_cms-db_1, xibo_cms-quickchart_1, xibo_cms-xmr_1
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
cms-db_1 | 2020-06-17 08:49:16 0 [Note] mysqld (mysqld 5.6.48) starting as process 1 …
cms-db_1 | 2020-06-17 08:49:16 1 [Note] Plugin ‘FEDERATED’ is disabled.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2020-06-17 08:49:17 1 [Note] InnoDB: 5.6.48 started; log sequence number 1626017
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server hostname (bind-address): ‘’; port: 3306
cms-db_1 | 2020-06-17 08:49:17 1 [Note] IPv6 is available.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] - ‘::’ resolves to ‘::’;
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server socket created on IP: ‘::’.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] Insecure configuration for --pid-file: Location ‘/var/run/mysqld’ in the path is accessible to all OS users. Consider choosing a different directory.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] ‘proxies_priv’ entry ‘@ root@f2d4ea2eb7fc’ ignored in --skip-name-resolve mode.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2020-06-17 08:49:17 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: ‘5.6.48’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
cms-quickchart_1 | Stackdriver logging is disabled
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Loaded 6 keys from API keyfile”,“time”:“2020-06-17T08:49:17.762Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Telemetry is enabled”,“time”:“2020-06-17T08:49:17.879Z”,“v”:0}
cms-quickchart_1 | Wed, 17 Jun 2020 08:49:18 GMT body-parser deprecated undefined extended: provide extended option at index.js:40:17
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Setting request timeout: 1000 ms”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“NODE_ENV: production”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Listening on port 3400”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-web_1 | Waiting for MySQL to start - max 300 seconds
root@mmz-xibo-01:/opt/xibo# docker-compose logs
Attaching to xibo_cms-web_1, xibo_cms-db_1, xibo_cms-quickchart_1, xibo_cms-xmr_1
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
cms-db_1 | 2020-06-17 08:49:16 0 [Note] mysqld (mysqld 5.6.48) starting as process 1 …
cms-db_1 | 2020-06-17 08:49:16 1 [Note] Plugin ‘FEDERATED’ is disabled.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2020-06-17 08:49:17 1 [Note] InnoDB: 5.6.48 started; log sequence number 1626017
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server hostname (bind-address): '’; port: 3306
cms-db_1 | 2020-06-17 08:49:17 1 [Note] IPv6 is available.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] - ‘::’ resolves to ‘::’;
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server socket created on IP: ‘::’.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] Insecure configuration for --pid-file: Location ‘/var/run/mysqld’ in the path is accessible to all OS users. Consider choosing a different directory.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] ‘proxies_priv’ entry ‘@ root@f2d4ea2eb7fc’ ignored in --skip-name-resolve mode.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2020-06-17 08:49:17 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: ‘5.6.48’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
cms-quickchart_1 | Stackdriver logging is disabled
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Loaded 6 keys from API keyfile”,“time”:“2020-06-17T08:49:17.762Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Telemetry is enabled”,“time”:“2020-06-17T08:49:17.879Z”,“v”:0}
cms-quickchart_1 | Wed, 17 Jun 2020 08:49:18 GMT body-parser deprecated undefined extended: provide extended option at index.js:40:17
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Setting request timeout: 1000 ms”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“NODE_ENV: production”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Listening on port 3400”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-web_1 | Waiting for MySQL to start - max 300 seconds
root@mmz-xibo-01:/opt/xibo# docker-compose logs
Attaching to xibo_cms-web_1, xibo_cms-db_1, xibo_cms-quickchart_1, xibo_cms-xmr_1
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
cms-db_1 | 2020-06-17 08:49:16 0 [Note] mysqld (mysqld 5.6.48) starting as process 1 …
cms-db_1 | 2020-06-17 08:49:16 1 [Note] Plugin ‘FEDERATED’ is disabled.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2020-06-17 08:49:17 1 [Note] InnoDB: 5.6.48 started; log sequence number 1626017
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server hostname (bind-address): ‘’; port: 3306
cms-db_1 | 2020-06-17 08:49:17 1 [Note] IPv6 is available.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] - ‘::’ resolves to ‘::’;
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server socket created on IP: ‘::’.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] Insecure configuration for --pid-file: Location ‘/var/run/mysqld’ in the path is accessible to all OS users. Consider choosing a different directory.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] ‘proxies_priv’ entry ‘@ root@f2d4ea2eb7fc’ ignored in --skip-name-resolve mode.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2020-06-17 08:49:17 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: ‘5.6.48’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
cms-quickchart_1 | Stackdriver logging is disabled
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Loaded 6 keys from API keyfile”,“time”:“2020-06-17T08:49:17.762Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Telemetry is enabled”,“time”:“2020-06-17T08:49:17.879Z”,“v”:0}
cms-quickchart_1 | Wed, 17 Jun 2020 08:49:18 GMT body-parser deprecated undefined extended: provide extended option at index.js:40:17
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Setting request timeout: 1000 ms”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“NODE_ENV: production”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Listening on port 3400”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-web_1 | Waiting for MySQL to start - max 300 seconds
root@mmz-xibo-01:/opt/xibo# docker-compose logs
Attaching to xibo_cms-web_1, xibo_cms-db_1, xibo_cms-quickchart_1, xibo_cms-xmr_1
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
cms-db_1 | 2020-06-17 08:49:16 0 [Note] mysqld (mysqld 5.6.48) starting as process 1 …
cms-db_1 | 2020-06-17 08:49:16 1 [Note] Plugin ‘FEDERATED’ is disabled.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2020-06-17 08:49:17 1 [Note] InnoDB: 5.6.48 started; log sequence number 1626017
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server hostname (bind-address): '’; port: 3306
cms-db_1 | 2020-06-17 08:49:17 1 [Note] IPv6 is available.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] - ‘::’ resolves to ‘::’;
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server socket created on IP: ‘::’.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] Insecure configuration for --pid-file: Location ‘/var/run/mysqld’ in the path is accessible to all OS users. Consider choosing a different directory.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] ‘proxies_priv’ entry ‘@ root@f2d4ea2eb7fc’ ignored in --skip-name-resolve mode.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2020-06-17 08:49:17 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: ‘5.6.48’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
cms-quickchart_1 | Stackdriver logging is disabled
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Loaded 6 keys from API keyfile”,“time”:“2020-06-17T08:49:17.762Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Telemetry is enabled”,“time”:“2020-06-17T08:49:17.879Z”,“v”:0}
cms-quickchart_1 | Wed, 17 Jun 2020 08:49:18 GMT body-parser deprecated undefined extended: provide extended option at index.js:40:17
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Setting request timeout: 1000 ms”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“NODE_ENV: production”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Listening on port 3400”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-web_1 | Waiting for MySQL to start - max 300 seconds
root@mmz-xibo-01:/opt/xibo# docker-compose logs
Attaching to xibo_cms-web_1, xibo_cms-db_1, xibo_cms-quickchart_1, xibo_cms-xmr_1
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db_1 | 2020-06-17 08:49:16+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-06-17 08:49:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
cms-db_1 | 2020-06-17 08:49:16 0 [Note] mysqld (mysqld 5.6.48) starting as process 1 …
cms-db_1 | 2020-06-17 08:49:16 1 [Note] Plugin ‘FEDERATED’ is disabled.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2020-06-17 08:49:16 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2020-06-17 08:49:17 1 [Note] InnoDB: 5.6.48 started; log sequence number 1626017
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server hostname (bind-address): ‘*’; port: 3306
cms-db_1 | 2020-06-17 08:49:17 1 [Note] IPv6 is available.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] - ‘::’ resolves to ‘::’;
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Server socket created on IP: ‘::’.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] Insecure configuration for --pid-file: Location ‘/var/run/mysqld’ in the path is accessible to all OS users. Consider choosing a different directory.
cms-db_1 | 2020-06-17 08:49:17 1 [Warning] ‘proxies_priv’ entry ‘@ root@f2d4ea2eb7fc’ ignored in --skip-name-resolve mode.
cms-db_1 | 2020-06-17 08:49:17 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2020-06-17 08:49:17 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: ‘5.6.48’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
cms-quickchart_1 | Stackdriver logging is disabled
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Loaded 6 keys from API keyfile”,“time”:“2020-06-17T08:49:17.762Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Telemetry is enabled”,“time”:“2020-06-17T08:49:17.879Z”,“v”:0}
cms-quickchart_1 | Wed, 17 Jun 2020 08:49:18 GMT body-parser deprecated undefined extended: provide extended option at index.js:40:17
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Setting request timeout: 1000 ms”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“NODE_ENV: production”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“6a9ff673f3c2”,“pid”:1,“level”:30,“msg”:“Listening on port 3400”,“time”:“2020-06-17T08:49:18.460Z”,“v”:0}
cms-web_1 | Waiting for MySQL to start - max 300 seconds

what can I do?

2

I don’t see an obvious problem.

Could you check your config.env and make sure you’ve not accidentally set up a remote database server name or something like that?

It’ll try and connect to $MYSQL_HOST $MYSQL_PORT

So it would be worth going in to the cms-web container and running

echo $MYSQL_HOST $MYSQL_PORT and make sure those look sensible. They should be exactly mysql 3306

3

bash-5.0# echo $MYSQL_HOST $MYSQL_PORT
mysql 3306

in the config.env I have only entered the password for sure

4

@alex
another idea for me?

5

I suspect it’s something in your Docker networking not working properly. As far as I can see it’s all configured correctly from the Xibo side.

I would try restarting the Docker service.

If you do anything with iptables then you may well find that is interfering as Docker makes extensive use of iptables itself.

6

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.