To be completed by the original poster:
CMS Version
3.2
Installation Method
Docker
Operating System
Ubuntu 22.04.1 LTS
Issue
I went to update my docker install from 3.1.3 to 3.2 and when I run the docker-compose up -d command the cms_db container fails to start.
I’ve tried adding ‘command: --innodb_use_native_aio=0’ to docker-compose with no luck.
The results of docker-compose log
Attaching to xibo_cms-web_1, xibo_cms-xmr_1, xibo_cms-quickchart_1, xibo_cms-memcached_1, xibo_cms-db_1
e[32mcms-quickchart_1 |e[0m {"name":"quickchart","hostname":"5a380729f901","pid":1,"level":30,"msg":"Telemetry is enabled","time":"2022-09-18T17:45:32.045Z","v":0}
e[32mcms-quickchart_1 |e[0m Sun, 18 Sep 2022 17:45:32 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
e[32mcms-quickchart_1 |e[0m {"name":"quickchart","hostname":"5a380729f901","pid":1,"level":30,"msg":"Setting request timeout: 5000 ms","time":"2022-09-18T17:45:32.859Z","v":0}
e[32mcms-quickchart_1 |e[0m {"name":"quickchart","hostname":"5a380729f901","pid":1,"level":30,"msg":"NODE_ENV: production","time":"2022-09-18T17:45:32.859Z","v":0}
e[32mcms-quickchart_1 |e[0m {"name":"quickchart","hostname":"5a380729f901","pid":1,"level":30,"msg":"Listening on port 3400","time":"2022-09-18T17:45:32.859Z","v":0}
e[36mcms-web_1 |e[0m Waiting for MySQL to start - max 300 seconds
e[36mcms-web_1 |e[0m MySQL started
e[36mcms-web_1 |e[0m Configuring MySQL cnf file
e[36mcms-web_1 |e[0m Updating settings.php
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m New install
e[36mcms-web_1 |e[0m Provisioning Database
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m Phinx by CakePHP - https://phinx.org. 0.9.2
e[36mcms-web_1 |e[0m
e[36mcms-web_1 |e[0m using config file .varwwwcmsphinx.php
e[36mcms-web_1 |e[0m using config parser php
e[36mcms-web_1 |e[0m using migration paths
e[36mcms-web_1 |e[0m - /var/www/cms/db/migrations
e[36mcms-web_1 |e[0m warning no environment specified, defaulting to: production
e[36mcms-web_1 |e[0m using adapter mysql
e[36mcms-web_1 |e[0m using database cms
e[36mcms-web_1 |e[0m
e[36mcms-web_1 |e[0m In MysqlAdapter.php line 115:
e[36mcms-web_1 |e[0m
e[36mcms-web_1 |e[0m There was a problem connecting to the database: SQLSTATE[HY000] [2002] Conn
e[36mcms-web_1 |e[0m ection refused
e[36mcms-web_1 |e[0m
e[36mcms-web_1 |e[0m
e[36mcms-web_1 |e[0m migrate [-c|--configuration CONFIGURATION] [-p|--parser PARSER] [-e|--environment ENVIRONMENT] [-t|--target TARGET] [-d|--date DATE] [-x|--dry-run]
e[36mcms-web_1 |e[0m
e[36mcms-web_1 |e[0m Configuring Database Settings
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m Setting up Maintenance
e[36mcms-web_1 |e[0m Protected Maintenance
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m Importing ca-certs
e[36mcms-web_1 |e[0m cp: can't stat '/var/www/cms/ca-certs/*.pem': No such file or directory
e[36mcms-web_1 |e[0m cp: can't stat '/var/www/cms/ca-certs/*.crt': No such file or directory
e[36mcms-web_1 |e[0m WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping
e[36mcms-web_1 |e[0m Setting up Quickchart
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m Configuring Maintenance
e[36mcms-web_1 |e[0m Removing web/install/index.php from production container
e[36mcms-web_1 |e[0m ERROR 2002 (HY000): Can't connect to server on 'mysql' (115)
e[36mcms-web_1 |e[0m Starting cron
e[36mcms-web_1 |e[0m Starting webserver
e[36mcms-web_1 |e[0m AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 172.27.0.6. Set the 'ServerName' directive globally to suppress this message
e[36mcms-web_1 |e[0m 10.21.100.1 - - [18/Sep/2022:17:45:50 +0000] "GET / HTTP/1.1" 200 88 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Edg/105.0.1343.42"
e[36mcms-web_1 |e[0m 10.21.100.1 - - [18/Sep/2022:17:45:50 +0000] "GET /favicon.ico HTTP/1.1" 200 96 "http://10.21.100.7/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Edg/105.0.1343.42"
e[36mcms-web_1 |e[0m 10.21.100.51 - - [18/Sep/2022:17:47:11 +0000] "POST /xmds.php?v=6&method=reportFaults HTTP/1.1" 500 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)"
e[36mcms-web_1 |e[0m 10.21.100.50 - - [18/Sep/2022:17:47:33 +0000] "POST /xmds.php?v=6&method=registerDisplay HTTP/1.1" 500 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)"
e[36mcms-web_1 |e[0m 10.21.100.50 - - [18/Sep/2022:17:47:37 +0000] "POST /xmds.php?v=6&method=reportFaults HTTP/1.1" 500 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)"
e[36mcms-web_1 |e[0m 10.21.100.51 - - [18/Sep/2022:17:47:41 +0000] "POST /xmds.php?v=6&method=registerDisplay HTTP/1.1" 500 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)"
e[36mcms-web_1 |e[0m 10.21.100.50 - - [18/Sep/2022:17:47:47 +0000] "POST /xmds.php?v=6&method=reportFaults HTTP/1.1" 500 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)"
e[36mcms-web_1 |e[0m 10.21.100.50 - - [18/Sep/2022:17:47:52 +0000] "POST /xmds.php?v=6&method=registerDisplay HTTP/1.1" 500 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 4.0.30319.42000)"
e[31mcms-db_1 |e[0m 2022-09-18 17:45:31+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.39-1.el7 started.
e[31mcms-db_1 |e[0m 2022-09-18 17:45:32+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
e[31mcms-db_1 |e[0m 2022-09-18 17:45:32+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.39-1.el7 started.
e[31mcms-db_1 |e[0m '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.867262Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.869421Z 0 [Note] mysqld (mysqld 5.7.39) starting as process 1 ...
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.876644Z 0 [Note] InnoDB: PUNCH HOLE support available
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.876700Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.876711Z 0 [Note] InnoDB: Uses event mutexes
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.876725Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.876734Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.879377Z 0 [Note] InnoDB: Number of pools: 1
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.883443Z 0 [Note] InnoDB: Not using CPU crc32 instructions
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.886401Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.902260Z 0 [Note] InnoDB: Completed initialization of buffer pool
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.906743Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.930873Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.953759Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
e[31mcms-db_1 |e[0m 2022-09-18T17:45:32.954012Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.031412Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.032792Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.032825Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.033732Z 0 [Note] InnoDB: 5.7.39 started; log sequence number 1211719
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.034120Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.034803Z 0 [Note] Plugin 'FEDERATED' is disabled.
e[31mcms-db_1 |e[0m mysqld: Table 'mysql.plugin' doesn't exist
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.036532Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.037072Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220918 17:45:33
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.037620Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.039546Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.039756Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.039938Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.048972Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.049202Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.049298Z 0 [Warning] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.050087Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.050253Z 0 [Note] IPv6 is available.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.050286Z 0 [Note] - '::' resolves to '::';
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.050308Z 0 [Note] Server socket created on IP: '::'.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.054528Z 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.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.054881Z 0 [Warning] Failed to open optimizer cost constant tables
e[31mcms-db_1 |e[0m
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.055176Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.055302Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.055507Z 0 [ERROR] Aborting
e[31mcms-db_1 |e[0m
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.055696Z 0 [Note] Binlog end
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.055853Z 0 [Note] Shutting down plugin 'ngram'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.055954Z 0 [Note] Shutting down plugin 'partition'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.055996Z 0 [Note] Shutting down plugin 'BLACKHOLE'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056025Z 0 [Note] Shutting down plugin 'ARCHIVE'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056039Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056107Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056143Z 0 [Note] Shutting down plugin 'MyISAM'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056172Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056180Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056185Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056189Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056194Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056199Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056204Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056208Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056213Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056217Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056222Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056227Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056231Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056236Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056240Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056245Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056251Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056255Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056260Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056265Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056269Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056274Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056279Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056284Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056288Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056293Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056297Z 0 [Note] Shutting down plugin 'INNODB_CMP'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056302Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056306Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056311Z 0 [Note] Shutting down plugin 'INNODB_TRX'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056316Z 0 [Note] Shutting down plugin 'InnoDB'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056398Z 0 [Note] InnoDB: FTS optimize thread exiting.
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.056808Z 0 [Note] InnoDB: Starting shutdown...
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.157356Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
e[31mcms-db_1 |e[0m 2022-09-18T17:45:33.157775Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220918 17:45:33
e[31mcms-db_1 |e[0m 2022-09-18T17:45:34.470739Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1211738
e[31mcms-db_1 |e[0m 2022-09-18T17:45:34.472878Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
e[31mcms-db_1 |e[0m 2022-09-18T17:45:34.472957Z 0 [Note] Shutting down plugin 'MEMORY'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:34.472991Z 0 [Note] Shutting down plugin 'CSV'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:34.473039Z 0 [Note] Shutting down plugin 'sha256_password'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:34.473077Z 0 [Note] Shutting down plugin 'mysql_native_password'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:34.473249Z 0 [Note] Shutting down plugin 'binlog'
e[31mcms-db_1 |e[0m 2022-09-18T17:45:34.474673Z 0 [Note] mysqld: Shutdown complete
e[31mcms-db_1 |e[0m
e[31mcms-db_1 |e[0m 2022-09-18 17:45:35+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.39-1.el7 started.
e[31mcms-db_1 |e[0m 2022-09-18 17:45:35+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
e[31mcms-db_1 |e[0m 2022-09-18 17:45:35+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.39-1.el7 started.
contents of docker-compose
version: "2.1"
services:
cms-db:
image: mysql:5.7
command: --innodb_use_native_aio=0
volumes:
- "./shared/db:/var/lib/mysql:Z"
environment:
- MYSQL_DATABASE=cms
- MYSQL_USER=cms
- MYSQL_RANDOM_ROOT_PASSWORD=yes
mem_limit: 1g
env_file: config.env
restart: always
cms-xmr:
image: xibosignage/xibo-xmr:0.9
ports:
- "9505:9505"
restart: always
mem_limit: 256m
env_file: config.env
cms-web:
image: xibosignage/xibo-cms:release-3.2.0
volumes:
- "./shared/cms/custom:/var/www/cms/custom:Z"
- "./shared/backup:/var/www/backup:Z"
- "./shared/cms/web/theme/custom:/var/www/cms/web/theme/custom:Z"
- "./shared/cms/library:/var/www/cms/library:Z"
- "./shared/cms/web/userscripts:/var/www/cms/web/userscripts:Z"
- "./shared/cms/ca-certs:/var/www/cms/ca-certs:Z"
restart: always
links:
- cms-db:mysql
- cms-xmr:50001
environment:
- XMR_HOST=cms-xmr
- CMS_USE_MEMCACHED=true
- MEMCACHED_HOST=cms-memcached
env_file: config.env
ports:
- "80:80"
mem_limit: 1g
cms-memcached:
image: memcached:alpine
command: memcached -m 15
restart: always
mem_limit: 100M
cms-quickchart:
image: ianw/quickchart
restart: always
config.env
## CMS Configuration
## Please make a copy of this file as config.env, and then
## edit it to suit your environment
## The CMS brings its own MySQL server to store your
## data.
## On a new installation, we need to create a user account for the CMS to
## connect to that database with. What password should
## that account use? Enter a random password here.
## We recommend using a 16 character random upper/lower case
## and digits.
## You could for example use the random.org password generator
## here: https://www.random.org/passwords/?num=1&len=16&format=plain&rnd=new
##
## IMPORTANT: DO NOT USE SPECIAL CHARACTERS, SPACES etc. Please use only
## alpha-numeric (ie A-Z a-z 0-9) passwords of around 16 characters. The
## random generator linked above will give you something suitable.
##
## If you're upgrading an existing installation, be sure to use the correct
## password for the cms user account in the MySQL database (ie what you had in
## this variable previously).
MYSQL_PASSWORD=WcMg9evkhRquGPYy
## SMTP Server Configuration
## The CMS needs to be able to send email to you
## Please enter credentials for a suitable SMTP server
## Defaults will work for GMail - replacing your GMail username
## and password as appropriate. You will also need to enable access
## for less secure applications on your GMail account for this to
## work. See https://support.google.com/accounts/answer/6010255
## SMTP Server Hostname
CMS_SMTP_SERVER=smtp.gmail.com:587
## SMTP Username
CMS_SMTP_USERNAME=youraccount@gmail.com
## SMTP Password
CMS_SMTP_PASSWORD=yourpassword
## Use a TLS Connection YES/NO
CMS_SMTP_USE_TLS=YES
## Use a STARTTLS Connection YES/NO
CMS_SMTP_USE_STARTTLS=YES
## Rewrite domain (the domain your email will appear to come from)
CMS_SMTP_REWRITE_DOMAIN=gmail.com
## Hostname that we should identify ourself to the remote server as
CMS_SMTP_HOSTNAME=gmail.com
## Can the From line be overridden in the outbound email
## NB GMail will rewrite the From address anyway so it's not important
## for GMail - YES/NO
CMS_SMTP_FROM_LINE_OVERRIDE=YES
## Fix the from email address if your SMTP relay relies on
## a specific value - eg one.com
# CMS_SMTP_FROM=myemail@example.org
## It is sometimes necessary to configure the webserver running inside
## the container to know the DNS name by which you will normally
## access the CMS. For most installations this is unnecessary and can
## be left as default, however, if you know this, it won't hurt to
## set it
CMS_SERVER_NAME=cms.example.org
## Sometimes you want Xibo to run in a sub directory of the webserver
## rather than at the root. If so, specify it here. Comment it out to
## use the web root.
# CMS_ALIAS=/xibo
## Xibo comes with a 2GB limit for individual file uploads
## If you require larger files, uncomment the following and adjust as
## required
# CMS_PHP_POST_MAX_SIZE=4G
# CMS_PHP_UPLOAD_MAX_FILESIZE=4G
# CMS_PHP_MAX_EXECUTION_TIME=600
## Xibo can email various reports and charts. To do so a charting service
## is required. Xibo uses QuickChart.io, which has been provided as a container
## in the Docker Compose files.
## If needed, you can change the URL of the Quick Chart service to one you provide
## externally to Xibo's Docker Compose environment
# CMS_QUICK_CHART_URL=http://cms-quickchart:3400
## Xibo has a CRON based task runner built into the cms-web container. It is sometimes
# desirable to run this externally and to do so the internal task runner should be disabled
# by setting this to false. This setting is true by default.
# XTR_ENABLED=false
## Xibo uses a memcache server to act as a cache for resources downloaded from third parties,
# display schedules, required files, etc and for locking resources while they get updated.
# You can turn memcached off if you don't want to use it and Xibo will swap to a file cache in
# the library/cache folder
# CMS_USE_MEMCACHED=false
# In addition, if you wish you can provide an external or alternative memcached host and port
# MEMCACHED_HOST=cms-memcached
# MEMCACHED_PORT=11211
## Anonymous Usage Reporting
# Xibo has optional anonymous usage reporting which once per week makes a request to a server owned by
# Xibo Signage Ltd containing information about the type of installation and the number of displays
# We use this data to decide where best to focus our efforts and to improve the product
# A random 32 character key is generated the first time a report is sent. This key is completely random using
# random_bytes and cannot be tracked back to any particular environment.
# It will send: CMS version, install type (docker/custom), number of approved players, number of each player type
# This is defaulted to true, uncomment the below to disable it.
# CMS_USAGE_REPORT=false