Waiting for MySQL to start

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?

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

bash-5.0# echo $MYSQL_HOST $MYSQL_PORT
mysql 3306

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

@alex
another idea for me?

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.

The Xibo Community site uses cookies. What are cookies?