I’ve installed Xibo on Ubuntu from https://xibo.org.uk/manual/en/install_docker_linux.html and started it on default port:80
But the webinterface is still not reachable, i’ve also created an iptables rule incomming for all ports but i still get a time out.
with it set up like this it should be reachable on localhost or {ServerIpAddress}
Could you run the following command
docker-compose logs
and capture the output of that please?
Hi Peter,
here below. Now i can see that it is not able to connect to MySQL, how can i fix this?
root@thf-infweb01:/opt/Xibo# docker-compose logs
Attaching to xibo_cms-web_1, xibo_cms-xmr_1, xibo_cms-db_1
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (110 "Operation timed out")
cms-web_1 | New install
cms-web_1 | Provisioning Database
cms-web_1 | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (110 "Operation timed out")
cms-web_1 | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (110 "Operation timed out")
cms-web_1 | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (110 "Operation timed out")
cms-web_1 | Configuring Database Settings
cms-web_1 | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (110 "Operation timed out")
cms-web_1 | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (110 "Operation timed out")
cms-web_1 | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (110 "Operation timed out")
cms-db_1 | 2018-03-15 11:34:38 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 | 2018-03-15 11:34:38 0 [Note] mysqld (mysqld 5.6.39) starting as process 1 ...
cms-db_1 | 2018-03-15 11:34:38 1 [Note] Plugin 'FEDERATED' is disabled.
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Not using CPU crc32 instructions
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-03-15 11:34:38 1 [Note] InnoDB: 5.6.39 started; log sequence number 1626007
cms-db_1 | 2018-03-15 11:34:38 1 [Note] Server hostname (bind-address): '*'; port: 3306
cms-db_1 | 2018-03-15 11:34:38 1 [Note] IPv6 is available.
cms-db_1 | 2018-03-15 11:34:38 1 [Note] - '::' resolves to '::';
cms-db_1 | 2018-03-15 11:34:38 1 [Note] Server socket created on IP: '::'.
cms-db_1 | 2018-03-15 11:34:38 1 [Warning] 'proxies_priv' entry '@ root@a21c0c2f71c6' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-03-15 11:34:38 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2018-03-15 11:34:38 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: '5.6.39' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)meawhile i have removed all files and dropped the containers. afterwards i perfomred a fresh install from topic (Sudden Xibo SQL Error)
Now i get this logs but it is still not reachable via Port 80
root@thf-infweb01:/opt/Xibo# docker-compose logs
Attaching to xibo_cms-web_1, xibo_cms-xmr_1, xibo_cms-db_1
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-db_1 | Initializing database
cms-db_1 | 2018-03-15 12:23:12 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 | 2018-03-15 12:23:12 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
cms-db_1 | 2018-03-15 12:23:12 0 [Note] /usr/sbin/mysqld (mysqld 5.6.39) starting as process 33 ...
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Not using CPU crc32 instructions
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Database physically writes the file full: wait...
cms-db_1 | 2018-03-15 12:23:12 33 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
cms-db_1 | 2018-03-15 12:23:14 33 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
cms-db_1 | 2018-03-15 12:23:15 33 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
cms-db_1 | 2018-03-15 12:23:15 33 [Warning] InnoDB: New log files created, LSN=45781
cms-db_1 | 2018-03-15 12:23:15 33 [Note] InnoDB: Doublewrite buffer not found: creating new
cms-db_1 | 2018-03-15 12:23:15 33 [Note] InnoDB: Doublewrite buffer created
cms-db_1 | 2018-03-15 12:23:15 33 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-03-15 12:23:15 33 [Warning] InnoDB: Creating foreign key constraint system tables.
cms-db_1 | 2018-03-15 12:23:15 33 [Note] InnoDB: Foreign key constraint system tables created
cms-db_1 | 2018-03-15 12:23:15 33 [Note] InnoDB: Creating tablespace and datafile system tables.
cms-db_1 | 2018-03-15 12:23:15 33 [Note] InnoDB: Tablespace and datafile system tables created.
cms-db_1 | 2018-03-15 12:23:15 33 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-03-15 12:23:15 33 [Note] InnoDB: 5.6.39 started; log sequence number 0
cms-db_1 | 2018-03-15 12:23:17 33 [Note] Binlog end
cms-db_1 | 2018-03-15 12:23:17 33 [Note] InnoDB: FTS optimize thread exiting.
cms-db_1 | 2018-03-15 12:23:17 33 [Note] InnoDB: Starting shutdown...
cms-db_1 | 2018-03-15 12:23:18 33 [Note] InnoDB: Shutdown completed; log sequence number 1625977
cms-db_1 |
cms-db_1 |
cms-db_1 | 2018-03-15 12:23:18 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 | 2018-03-15 12:23:18 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
cms-db_1 | 2018-03-15 12:23:18 0 [Note] /usr/sbin/mysqld (mysqld 5.6.39) starting as process 56 ...
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Not using CPU crc32 instructions
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: 5.6.39 started; log sequence number 1625977
cms-db_1 | 2018-03-15 12:23:18 56 [Note] Binlog end
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: FTS optimize thread exiting.
cms-db_1 | 2018-03-15 12:23:18 56 [Note] InnoDB: Starting shutdown...
cms-db_1 | 2018-03-15 12:23:20 56 [Note] InnoDB: Shutdown completed; log sequence number 1625987
cms-db_1 |
cms-db_1 |
cms-db_1 |
cms-db_1 |
cms-db_1 | PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
cms-db_1 | To do so, start the server, then issue the following commands:
cms-db_1 |
cms-db_1 | /usr/bin/mysqladmin -u root password 'new-password'
cms-db_1 | /usr/bin/mysqladmin -u root -h 7338892b97f8 password 'new-password'
cms-db_1 |
cms-db_1 | Alternatively you can run:
cms-db_1 |
cms-db_1 | /usr/bin/mysql_secure_installation
cms-db_1 |
cms-db_1 | which will also give you the option of removing the test
cms-db_1 | databases and anonymous user created by default. This is
cms-db_1 | strongly recommended for production servers.
cms-db_1 |
cms-db_1 | See the manual for more instructions.
cms-db_1 |
cms-db_1 | Please report any problems at http://bugs.mysql.com/
cms-db_1 |
cms-db_1 | The latest information about MySQL is available on the web at
cms-db_1 |
cms-db_1 | http://www.mysql.com
cms-db_1 |
cms-db_1 | Support MySQL by buying support/licenses at http://shop.mysql.com
cms-db_1 |
cms-db_1 | Note: new default config file not created.
cms-db_1 | Please make sure your config file is current
cms-db_1 |
cms-db_1 | WARNING: Default config file /etc/mysql/my.cnf exists on the system
cms-db_1 | This file will be read by default by the MySQL server
cms-db_1 | If you do not want to use this, either remove it, or use the
cms-db_1 | --defaults-file argument to mysqld_safe when starting the server
cms-db_1 |
cms-db_1 | Database initialized
cms-db_1 | MySQL init process in progress...
cms-db_1 | 2018-03-15 12:23:21 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 | 2018-03-15 12:23:21 0 [Note] mysqld (mysqld 5.6.39) starting as process 84 ...
cms-db_1 | 2018-03-15 12:23:21 84 [Note] Plugin 'FEDERATED' is disabled.
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Not using CPU crc32 instructions
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-03-15 12:23:21 84 [Note] InnoDB: 5.6.39 started; log sequence number 1625987
cms-db_1 | 2018-03-15 12:23:21 84 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a6938ae6-284b-11e8-a448-0242ac120002.
cms-db_1 | 2018-03-15 12:23:21 84 [Warning] 'user' entry 'root@7338892b97f8' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-03-15 12:23:21 84 [Warning] 'user' entry '@7338892b97f8' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-03-15 12:23:21 84 [Warning] 'proxies_priv' entry '@ root@7338892b97f8' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-03-15 12:23:21 84 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2018-03-15 12:23:21 84 [Note] mysqld: ready for connections.
cms-db_1 | Version: '5.6.39' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL)
cms-db_1 | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
cms-db_1 | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
cms-db_1 | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
cms-db_1 | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
cms-db_1 | GENERATED ROOT PASSWORD: Ieme8aeP9Ii1chae1ao3ohlooNaemoe9
cms-db_1 | 2018-03-15 12:23:24 84 [Warning] 'proxies_priv' entry '@ root@7338892b97f8' ignored in --skip-name-resolve mode.
cms-db_1 | Warning: Using a password on the command line interface can be insecure.
cms-db_1 | Warning: Using a password on the command line interface can be insecure.
cms-db_1 | Warning: Using a password on the command line interface can be insecure.
cms-db_1 | Warning: Using a password on the command line interface can be insecure.
cms-db_1 | 2018-03-15 12:23:24 84 [Warning] 'proxies_priv' entry '@ root@7338892b97f8' ignored in --skip-name-resolve mode.
cms-db_1 |
cms-db_1 | 2018-03-15 12:23:24 84 [Note] mysqld: Normal shutdown
cms-db_1 |
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Giving 0 client threads a chance to die gracefully
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Event Scheduler: Purging the queue. 0 events
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down slave threads
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Forcefully disconnecting 0 remaining clients
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Binlog end
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'partition'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_FT_DELETED'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_METRICS'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_CMPMEM'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_CMP_RESET'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_CMP'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_LOCKS'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'INNODB_TRX'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] Shutting down plugin 'InnoDB'
cms-db_1 | 2018-03-15 12:23:24 84 [Note] InnoDB: FTS optimize thread exiting.
cms-db_1 | 2018-03-15 12:23:24 84 [Note] InnoDB: Starting shutdown...
cms-db_1 | 2018-03-15 12:23:25 84 [Note] InnoDB: Shutdown completed; log sequence number 1625997
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'BLACKHOLE'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'ARCHIVE'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'MRG_MYISAM'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'MyISAM'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'MEMORY'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'CSV'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'sha256_password'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'mysql_old_password'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'mysql_native_password'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] Shutting down plugin 'binlog'
cms-db_1 | 2018-03-15 12:23:25 84 [Note] mysqld: Shutdown complete
cms-db_1 |
cms-db_1 |
cms-db_1 | MySQL init process done. Ready for start up.
cms-db_1 |
cms-db_1 | 2018-03-15 12:23:25 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 | 2018-03-15 12:23:25 0 [Note] mysqld (mysqld 5.6.39) starting as process 1 ...
cms-db_1 | 2018-03-15 12:23:25 1 [Note] Plugin 'FEDERATED' is disabled.
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: Not using CPU crc32 instructions
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-03-15 12:23:25 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2018-03-15 12:23:26 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-03-15 12:23:26 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-03-15 12:23:26 1 [Note] InnoDB: 5.6.39 started; log sequence number 1625997
cms-db_1 | 2018-03-15 12:23:26 1 [Note] Server hostname (bind-address): '*'; port: 3306
cms-db_1 | 2018-03-15 12:23:26 1 [Note] IPv6 is available.
cms-db_1 | 2018-03-15 12:23:26 1 [Note] - '::' resolves to '::';
cms-db_1 | 2018-03-15 12:23:26 1 [Note] Server socket created on IP: '::'.
cms-db_1 | 2018-03-15 12:23:26 1 [Warning] 'proxies_priv' entry '@ root@7338892b97f8' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-03-15 12:23:26 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2018-03-15 12:23:26 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: '5.6.39' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
root@thf-infweb01:/opt/Xibo#I assume you did the changes to config.env file as per manual?
Did the up command create the /shared sub-folder for you?
Could you run
docker-compose down
and then
docker-compose up
^ without -d it will show yo what it is doing.
Do you have anything else installed there ie something that may be using the same ports as the default ports in Xibo docker?
At the first try i didn’t set any password after te first start i changed it and got this error.
At the second try i set the mysql password before first start, afterwards i run the docker-compose up -d and as you can see in the logs the mysql is running.
Its a fresh ubuntu without any webserver etc.
Following the log for docker-compose up
root@thf-infweb01:/opt/Xibo# docker-compose down
Stopping xibo_cms-web_1 ... done
Stopping xibo_cms-xmr_1 ... done
Stopping xibo_cms-db_1 ... done
Removing xibo_cms-web_1 ... done
Removing xibo_cms-xmr_1 ... done
Removing xibo_cms-db_1 ... done
Removing network xibo_default
root@thf-infweb01:/opt/Xibo# docker-co
docker-co: Befehl nicht gefunden.
root@thf-infweb01:/opt/Xibo# docker-compose up
Creating xibo_cms-db_1 ... done
Creating xibo_cms-xmr_1 ... done
Creating xibo_cms-db_1 ...
Creating xibo_cms-web_1 ... done
Attaching to xibo_cms-xmr_1, xibo_cms-db_1, xibo_cms-web_1
cms-db_1 | 2018-03-15 12:43: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 | 2018-03-15 12:43:16 0 [Note] mysqld (mysqld 5.6.39) starting as process 1 ...
cms-db_1 | 2018-03-15 12:43:16 1 [Note] Plugin 'FEDERATED' is disabled.
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Not using CPU crc32 instructions
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-03-15 12:43:16 1 [Note] InnoDB: 5.6.39 started; log sequence number 1626007
cms-db_1 | 2018-03-15 12:43:16 1 [Note] Server hostname (bind-address): '*'; port: 3306
cms-db_1 | 2018-03-15 12:43:16 1 [Note] IPv6 is available.
cms-db_1 | 2018-03-15 12:43:16 1 [Note] - '::' resolves to '::';
cms-db_1 | 2018-03-15 12:43:16 1 [Note] Server socket created on IP: '::'.
cms-db_1 | 2018-03-15 12:43:16 1 [Warning] 'proxies_priv' entry '@ root@7338892b97f8' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-03-15 12:43:16 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2018-03-15 12:43:16 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: '5.6.39' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | New install
cms-web_1 | Provisioning Database
cms-web_1 | ERROR 1146 (42S02) at line 1: Table 'cms.version' doesn't exist
cms-web_1 | Configuring Database Settings
cms-web_1 | Setting up Maintenance
cms-web_1 | Protected Maintenance
cms-web_1 | Updating settings.php
cms-web_1 | Configuring Maintenance
UPDATE
cms-web_1 | Removing web/install/index.php from production container
cms-web_1 | Running maintenance
cms-web_1 | Starting cron
cms-web_1 | Starting webserver
cms-web_1 | AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 172.18.0.4. Set the 'ServerName' directive globally to suppress this message
IP of the Host System is 192.168.4.22 and Hostname thf-infweb01
Aaah now the Webinterface is responding.
How can i stop it now and restart it in background?
That’s fine, it’s just a notice.
That is rather odd, although it seems that the db was created and web server started as well, is it still not reachable?
Aaah now the Webinterface is responding.
How can i stop it now and restart it in background?
I see, that’s good then, I assume /shared was created and you can upload a file to library and download it from it?
All should be left to do now is to set the XMR public address in CMS Settings and then start creating content, connecting players etc.
docker-compose stop
and
docker-compose start
Now its working fine, thank you!