Hi, ive tried to setup a new xibo instance.
I tried with custom ports, but for testing i rolled back to the default ports.
- fresh download, fresh install
Xibo is starting up, as it should but i cant connect to the cms.
xibo logs says:
Attaching to xibo-docker-1811_cms-web_1, xibo-docker-1811_cms-db_1, xibo-docker- 1811_cms-xmr_1
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | ERROR 1146 (42S02) at line 1: Table 'cms.version' doesn't exist
cms-web_1 | New install
cms-web_1 | Provisioning Database
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 | Importing ca-certs
cms-web_1 | cp: can't stat '/var/www/cms/ca-certs/*.pem': No such file or directory
cms-web_1 | cp: can't stat '/var/www/cms/ca-certs/*.crt': No such file or directory
cms-web_1 | WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping
cms-web_1 | Configuring Maintenance
cms-db_1 | Initializing database
cms-db_1 | 2018-10-27 09:12:06 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-10-27 09:12:06 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
cms-db_1 | 2018-10-27 09:12:06 0 [Note] /usr/sbin/mysqld (mysqld 5.6.41) starting as process 38 ...
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Database physically writes the file full: wait...
cms-db_1 | 2018-10-27 09:12:06 38 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
cms-db_1 | 2018-10-27 09:12:07 38 [Warning] InnoDB: New log files created, LSN=45781
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: Doublewrite buffer not found: creating new
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: Doublewrite buffer created
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-10-27 09:12:07 38 [Warning] InnoDB: Creating foreign key constraint system tables.
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: Foreign key constraint system tables created
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: Creating tablespace and datafile system tables.
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: Tablespace and datafile system tables created.
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-10-27 09:12:07 38 [Note] InnoDB: 5.6.41 started; log sequence number 0
cms-db_1 | 2018-10-27 09:12:10 38 [Note] Binlog end
cms-db_1 | 2018-10-27 09:12:10 38 [Note] InnoDB: FTS optimize thread exiting.
cms-db_1 | 2018-10-27 09:12:10 38 [Note] InnoDB: Starting shutdown...
cms-db_1 | 2018-10-27 09:12:11 38 [Note] InnoDB: Shutdown completed; log sequence number 1625977
cms-db_1 |
cms-db_1 |
cms-db_1 | 2018-10-27 09:12:11 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-10-27 09:12:11 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
cms-db_1 | 2018-10-27 09:12:11 0 [Note] /usr/sbin/mysqld (mysqld 5.6.41) starting as process 61 ...
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-10-27 09:12:11 61 [Note] InnoDB: 5.6.41 started; log sequence number 1625977
cms-db_1 | 2018-10-27 09:12:12 61 [Note] Binlog end
cms-db_1 | 2018-10-27 09:12:12 61 [Note] InnoDB: FTS optimize thread exiting.
cms-db_1 | 2018-10-27 09:12:12 61 [Note] InnoDB: Starting shutdown...
cms-db_1 | 2018-10-27 09:12:13 61 [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 9d05790469d2 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-10-27 09:12:14 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-10-27 09:12:14 0 [Note] mysqld (mysqld 5.6.41) starting as process 89 ...
cms-db_1 | 2018-10-27 09:12:14 89 [Note] Plugin 'FEDERATED' is disabled.
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-10-27 09:12:14 89 [Note] InnoDB: 5.6.41 started; log sequence number 1625987
cms-db_1 | 2018-10-27 09:12:14 89 [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: 64db9fb5-d9c8-11e8-a9a6-0242ac130003.
cms-db_1 | 2018-10-27 09:12:14 89 [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 | 2018-10-27 09:12:14 89 [Warning] 'user' entry 'root@9d05790469d2' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-10-27 09:12:14 89 [Warning] 'user' entry '@9d05790469d2' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-10-27 09:12:14 89 [Warning] 'proxies_priv' entry '@ root@9d05790469d2' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-10-27 09:12:14 89 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2018-10-27 09:12:14 89 [Note] mysqld: ready for connections.
cms-db_1 | Version: '5.6.41' 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: sohtohth7eiSie1ubah1Queijeet4soo
cms-db_1 | 2018-10-27 09:12:16 89 [Warning] 'proxies_priv' entry '@ root@9d05790469d2' 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-10-27 09:12:16 89 [Warning] 'proxies_priv' entry '@ root@9d05790469d2' ignored in --skip-name-resolve mode.
cms-db_1 |
cms-db_1 | 2018-10-27 09:12:16 89 [Note] mysqld: Normal shutdown
cms-db_1 |
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Giving 0 client threads a chance to die gracefully
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Event Scheduler: Purging the queue. 0 events
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down slave threads
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Forcefully disconnecting 0 remaining clients
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Binlog end
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'partition'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_FT_DELETED'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_METRICS'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_CMPMEM'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_CMP_RESET'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_CMP'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_LOCKS'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'INNODB_TRX'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] Shutting down plugin 'InnoDB'
cms-db_1 | 2018-10-27 09:12:16 89 [Note] InnoDB: FTS optimize thread exiting.
cms-db_1 | 2018-10-27 09:12:16 89 [Note] InnoDB: Starting shutdown...
cms-db_1 | 2018-10-27 09:12:18 89 [Note] InnoDB: Shutdown completed; log sequence number 1625997
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'BLACKHOLE'
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'ARCHIVE'
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'MRG_MYISAM'
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'MyISAM'
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'MEMORY'
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'CSV'
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'sha256_password'
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'mysql_old_password'
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'mysql_native_password'
cms-db_1 | 2018-10-27 09:12:18 89 [Note] Shutting down plugin 'binlog'
cms-db_1 | 2018-10-27 09:12:18 89 [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-10-27 09:12: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-10-27 09:12:18 0 [Note] mysqld (mysqld 5.6.41) starting as process 1 ...
cms-db_1 | 2018-10-27 09:12:18 1 [Note] Plugin 'FEDERATED' is disabled.
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Compressed tables use zlib 1.2.3
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2018-10-27 09:12:18 1 [Note] InnoDB: 5.6.41 started; log sequence number 1625997
cms-db_1 | 2018-10-27 09:12:18 1 [Note] Server hostname (bind-address): '*'; port: 3306
cms-db_1 | 2018-10-27 09:12:18 1 [Note] IPv6 is available.
cms-db_1 | 2018-10-27 09:12:18 1 [Note] - '::' resolves to '::';
cms-db_1 | 2018-10-27 09:12:18 1 [Note] Server socket created on IP: '::'.
cms-db_1 | 2018-10-27 09:12:18 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 | 2018-10-27 09:12:18 1 [Warning] 'proxies_priv' entry '@ root@9d05790469d2' ignored in --skip-name-resolve mode.
cms-db_1 | 2018-10-27 09:12:18 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2018-10-27 09:12:18 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: '5.6.41' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
i cant connect to server:80
so i checked iptables:
iptables says:
Chain DOCKER (2 references)
target prot opt source destination
ACCEPT tcp -- anywhere 172.19.0.2 tcp dpt:9505
ACCEPT tcp -- anywhere 172.19.0.4 tcp dpt:http
netstat says:
:~/xibo-docker-1.8.11# netstat -tulpn | grep docker
tcp6 0 0 :::80 :::* LISTEN 8401/docker-proxy
tcp6 0 0 :::9505 :::* LISTEN 8099/docker-proxy
root@ledvertise:~/xibo-docker-1.8.11#
but i can from localhost to 172.19.0.4 !
any sugestions ?