search

montera34 / pageonex

PageOneX. Analyzing front pages
http://pageonex.com
GNU Affero General Public License v3.0
54 stars 13 forks source link

ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (111) #240

Closed NoahAssam closed 2 years ago

NoahAssam commented 2 years ago

i downloaded docker, made a clone of pageonex, created a container. i am running through windows. following the steps of You can run pageonex locally using docker-compose and our generated images. I'm trying to run pageonex locally 


[+] Running 2/2Desktop\pageonexstuuf\pageonex-master>docker-compose up
 - Container pageonex-master-mysql-1  Created                                                                      0.3s
 - Container pageonex-master-app-1    Created                                                                      0.1s
Attaching to pageonex-master-app-1, pageonex-master-mysql-1
pageonex-master-mysql-1  | Warning: World-writable config file '/etc/mysql/conf.d/pageonex.cnf' is ignored
pageonex-master-mysql-1  | 2022-03-08 17:26:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
pageonex-master-mysql-1  | 2022-03-08 17:26:53 0 [Note] mysqld (mysqld 5.6.40) starting as process 1 ...
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] Plugin 'FEDERATED' is disabled.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: The InnoDB memory heap is disabled
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Memory barrier is not used
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Compressed tables use zlib 1.2.3
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Using Linux native AIO
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Using CPU crc32 instructions
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Completed initialization of buffer pool
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Highest supported file format is Barracuda.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: 128 rollback segment(s) are active.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Waiting for purge to start
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: 5.6.40 started; log sequence number 1626007
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] Server hostname (bind-address): '*'; port: 3306
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] IPv6 is available.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note]   - '::' resolves to '::';
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] Server socket created on IP: '::'.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 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.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Warning] 'proxies_priv' entry '@ root@8d2195861cd8' ignored in --skip-name-resolve mode.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] Event Scheduler: Loaded 0 events
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] mysqld: ready for connections.
pageonex-master-mysql-1  | Version: '5.6.40'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
pageonex-master-app-1    | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (111)
pageonex-master-app-1    | Mysql is unavailable - sleeping
pageonex-master-app-1    | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (111)
rporres commented 2 years ago

Most likely the error is in

pageonex-master-mysql-1 | Warning: World-writable config file '/etc/mysql/conf.d/pageonex.cnf' is ignored

Mysql is starting in the default port 3306 and we expect to be in the 13306 here

NoahAssam commented 2 years ago

i downloaded docker, made a clone of pageonex, created a container. i am running through windows. following the steps of You can run pageonex locally using docker-compose and our generated images. I'm trying to run pageonex locally


[+] Running 2/2Desktop\pageonexstuuf\pageonex-master>docker-compose up
 - Container pageonex-master-mysql-1  Created                                                                      0.3s
 - Container pageonex-master-app-1    Created                                                                      0.1s
Attaching to pageonex-master-app-1, pageonex-master-mysql-1
pageonex-master-mysql-1  | Warning: World-writable config file '/etc/mysql/conf.d/pageonex.cnf' is ignored
pageonex-master-mysql-1  | 2022-03-08 17:26:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
pageonex-master-mysql-1  | 2022-03-08 17:26:53 0 [Note] mysqld (mysqld 5.6.40) starting as process 1 ...
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] Plugin 'FEDERATED' is disabled.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: The InnoDB memory heap is disabled
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Memory barrier is not used
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Compressed tables use zlib 1.2.3
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Using Linux native AIO
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Using CPU crc32 instructions
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Completed initialization of buffer pool
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Highest supported file format is Barracuda.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: 128 rollback segment(s) are active.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: Waiting for purge to start
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] InnoDB: 5.6.40 started; log sequence number 1626007
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] Server hostname (bind-address): '*'; port: 3306
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] IPv6 is available.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note]   - '::' resolves to '::';
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] Server socket created on IP: '::'.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 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.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Warning] 'proxies_priv' entry '@ root@8d2195861cd8' ignored in --skip-name-resolve mode.
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] Event Scheduler: Loaded 0 events
pageonex-master-mysql-1  | 2022-03-08 17:26:53 1 [Note] mysqld: ready for connections.
pageonex-master-mysql-1  | Version: '5.6.40'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
pageonex-master-app-1    | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (111)
pageonex-master-app-1    | Mysql is unavailable - sleeping
pageonex-master-app-1    | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (111)

I'm trying to change the port location of the Mysql from 3306 to 13306. i tried changing the location by opening the mysql and changing the location from within. id get an error when clicking on the file. i then started over completely and made a new clone using https://github.com/montera34/pageonex.git. now I'm not sure where to find the mysql. overall, I'm not sure how to change the port of the mysql from 3306 to 13306. I'm trying to change the location to solve the earlier problem of not being able to connect to the mysql server.

rporres commented 2 years ago

you don't need to change anything, the docker compose file already does it for you.

Can you post the logs of the docker-compose up when you use the last version of the repository?

NoahAssam commented 2 years ago 
C:\Users\pumab\Desktop\pageonexstuuf\pageonex-master>docker-compose logs
Attaching to pageonex-master_app_1, pageonex-master_mysql_1
mysql_1  | Warning: World-writable config file '/etc/mysql/conf.d/pageonex.cnf' is ignored
mysql_1  | 2022-03-15 22:34:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1  | 2022-03-15 22:34:08 0 [Note] mysqld (mysqld 5.6.40) starting as process 1 ...
mysql_1  | 2022-03-15 22:34:08 1 [Note] Plugin 'FEDERATED' is disabled.
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: The InnoDB memory heap is disabled
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Memory barrier is not used
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Compressed tables use zlib 1.2.3
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Using Linux native AIO
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Using CPU crc32 instructions
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Completed initialization of buffer pool
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: 128 rollback segment(s) are active.
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: Waiting for purge to start
mysql_1  | 2022-03-15 22:34:08 1 [Note] InnoDB: 5.6.40 started; log sequence number 1626047
mysql_1  | 2022-03-15 22:34:08 1 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1  | 2022-03-15 22:34:08 1 [Note] IPv6 is available.
mysql_1  | 2022-03-15 22:34:08 1 [Note]   - '::' resolves to '::';
mysql_1  | 2022-03-15 22:34:08 1 [Note] Server socket created on IP: '::'.
mysql_1  | 2022-03-15 22:34:08 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.
mysql_1  | 2022-03-15 22:34:08 1 [Warning] 'proxies_priv' entry '@ root@8d2195861cd8' ignored in --skip-name-resolve mode.
mysql_1  | 2022-03-15 22:34:08 1 [Note] Event Scheduler: Loaded 0 events
mysql_1  | 2022-03-15 22:34:08 1 [Note] mysqld: ready for connections.
mysql_1  | Version: '5.6.40'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
mysql_1  | 2022-03-15 22:34:24 1 [Note] mysqld: Normal shutdown
mysql_1  |
mysql_1  | 2022-03-15 22:34:24 1 [Note] Giving 0 client threads a chance to die gracefully
mysql_1  | 2022-03-15 22:34:24 1 [Note] Event Scheduler: Purging the queue. 0 events
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down slave threads
mysql_1  | 2022-03-15 22:34:24 1 [Note] Forcefully disconnecting 0 remaining clients
mysql_1  | 2022-03-15 22:34:24 1 [Note] Binlog end
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'partition'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_FT_DELETED'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_METRICS'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_CMPMEM'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_CMP_RESET'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_CMP'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_LOCKS'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'INNODB_TRX'
mysql_1  | 2022-03-15 22:34:24 1 [Note] Shutting down plugin 'InnoDB'
mysql_1  | 2022-03-15 22:34:24 1 [Note] InnoDB: FTS optimize thread exiting.
mysql_1  | 2022-03-15 22:34:24 1 [Note] InnoDB: Starting shutdown...
mysql_1  | 2022-03-15 22:34:26 1 [Note] InnoDB: Shutdown completed; log sequence number 1626057
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'BLACKHOLE'
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'ARCHIVE'
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'MRG_MYISAM'
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'MyISAM'
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'MEMORY'
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'CSV'
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'sha256_password'
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'mysql_old_password'
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'mysql_native_password'
mysql_1  | 2022-03-15 22:34:26 1 [Note] Shutting down plugin 'binlog'
mysql_1  | 2022-03-15 22:34:26 1 [Note] mysqld: Shutdown complete
mysql_1  |
mysql_1  | Warning: World-writable config file '/etc/mysql/conf.d/pageonex.cnf' is ignored
mysql_1  | 2022-03-15 22:43:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1  | 2022-03-15 22:43:18 0 [Note] mysqld (mysqld 5.6.40) starting as process 1 ...
mysql_1  | 2022-03-15 22:43:18 1 [Note] Plugin 'FEDERATED' is disabled.
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: The InnoDB memory heap is disabled
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Memory barrier is not used
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Compressed tables use zlib 1.2.3
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Using Linux native AIO
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Using CPU crc32 instructions
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Completed initialization of buffer pool
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: 128 rollback segment(s) are active.
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: Waiting for purge to start
mysql_1  | 2022-03-15 22:43:18 1 [Note] InnoDB: 5.6.40 started; log sequence number 1626057
mysql_1  | 2022-03-15 22:43:18 1 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1  | 2022-03-15 22:43:18 1 [Note] IPv6 is available.
mysql_1  | 2022-03-15 22:43:18 1 [Note]   - '::' resolves to '::';
mysql_1  | 2022-03-15 22:43:18 1 [Note] Server socket created on IP: '::'.
mysql_1  | 2022-03-15 22:43: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.
mysql_1  | 2022-03-15 22:43:18 1 [Warning] 'proxies_priv' entry '@ root@8d2195861cd8' ignored in --skip-name-resolve mode.
mysql_1  | 2022-03-15 22:43:18 1 [Note] Event Scheduler: Loaded 0 events
mysql_1  | 2022-03-15 22:43:18 1 [Note] mysqld: ready for connections.
mysql_1  | Version: '5.6.40'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
mysql_1  | 2022-03-15 22:43:33 1 [Note] mysqld: Normal shutdown
mysql_1  |
mysql_1  | 2022-03-15 22:43:33 1 [Note] Giving 0 client threads a chance to die gracefully
mysql_1  | 2022-03-15 22:43:33 1 [Note] Event Scheduler: Purging the queue. 0 events
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down slave threads
mysql_1  | 2022-03-15 22:43:33 1 [Note] Forcefully disconnecting 0 remaining clients
mysql_1  | 2022-03-15 22:43:33 1 [Note] Binlog end
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'partition'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_FT_DELETED'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_METRICS'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_CMPMEM'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_CMP_RESET'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_CMP'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_LOCKS'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'INNODB_TRX'
mysql_1  | 2022-03-15 22:43:33 1 [Note] Shutting down plugin 'InnoDB'
mysql_1  | 2022-03-15 22:43:33 1 [Note] InnoDB: FTS optimize thread exiting.
mysql_1  | 2022-03-15 22:43:33 1 [Note] InnoDB: Starting shutdown...
mysql_1  | 2022-03-15 22:43:34 1 [Note] InnoDB: Shutdown completed; log sequence number 1626067
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'BLACKHOLE'
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'ARCHIVE'
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'MRG_MYISAM'
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'MyISAM'
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'MEMORY'
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'CSV'
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'sha256_password'
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'mysql_old_password'
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'mysql_native_password'
mysql_1  | 2022-03-15 22:43:34 1 [Note] Shutting down plugin 'binlog'
mysql_1  | 2022-03-15 22:43:34 1 [Note] mysqld: Shutdown complete
mysql_1  |
mysql_1  | Warning: World-writable config file '/etc/mysql/conf.d/pageonex.cnf' is ignored
mysql_1  | 2022-03-15 22:59:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1  | 2022-03-15 22:59:58 0 [Note] mysqld (mysqld 5.6.40) starting as process 1 ...
mysql_1  | 2022-03-15 22:59:58 1 [Note] Plugin 'FEDERATED' is disabled.
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: The InnoDB memory heap is disabled
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Memory barrier is not used
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Compressed tables use zlib 1.2.3
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Using Linux native AIO
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Using CPU crc32 instructions
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Completed initialization of buffer pool
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: 128 rollback segment(s) are active.
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: Waiting for purge to start
mysql_1  | 2022-03-15 22:59:58 1 [Note] InnoDB: 5.6.40 started; log sequence number 1626067
mysql_1  | 2022-03-15 22:59:58 1 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1  | 2022-03-15 22:59:58 1 [Note] IPv6 is available.
mysql_1  | 2022-03-15 22:59:58 1 [Note]   - '::' resolves to '::';
mysql_1  | 2022-03-15 22:59:58 1 [Note] Server socket created on IP: '::'.
mysql_1  | 2022-03-15 22:59:58 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.
mysql_1  | 2022-03-15 22:59:58 1 [Warning] 'proxies_priv' entry '@ root@8d2195861cd8' ignored in --skip-name-resolve mode.
mysql_1  | 2022-03-15 22:59:58 1 [Note] Event Scheduler: Loaded 0 events
mysql_1  | 2022-03-15 22:59:58 1 [Note] mysqld: ready for connections.
mysql_1  | Version: '5.6.40'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
mysql_1  | 2022-03-15 23:00:17 1 [Note] mysqld: Normal shutdown
mysql_1  |
mysql_1  | 2022-03-15 23:00:17 1 [Note] Giving 0 client threads a chance to die gracefully
mysql_1  | 2022-03-15 23:00:17 1 [Note] Event Scheduler: Purging the queue. 0 events
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down slave threads
mysql_1  | 2022-03-15 23:00:17 1 [Note] Forcefully disconnecting 0 remaining clients
mysql_1  | 2022-03-15 23:00:17 1 [Note] Binlog end
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'partition'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_FT_DELETED'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_METRICS'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_CMPMEM'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_CMP_RESET'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_CMP'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_LOCKS'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'INNODB_TRX'
mysql_1  | 2022-03-15 23:00:17 1 [Note] Shutting down plugin 'InnoDB'
mysql_1  | 2022-03-15 23:00:17 1 [Note] InnoDB: FTS optimize thread exiting.
mysql_1  | 2022-03-15 23:00:17 1 [Note] InnoDB: Starting shutdown...
mysql_1  | 2022-03-15 23:00:18 1 [Note] InnoDB: Shutdown completed; log sequence number 1626077
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'BLACKHOLE'
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'ARCHIVE'
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'MRG_MYISAM'
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'MyISAM'
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'MEMORY'
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'CSV'
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'sha256_password'
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'mysql_old_password'
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'mysql_native_password'
mysql_1  | 2022-03-15 23:00:18 1 [Note] Shutting down plugin 'binlog'
mysql_1  | 2022-03-15 23:00:18 1 [Note] mysqld: Shutdown complete
mysql_1  |
app_1    | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (111)
app_1    | Mysql is unavailable - sleeping
app_1    | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (111)
app_1    | Mysql is unavailable - sleeping
app_1    | ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql' (111)
app_1    | Mysql is unavailable - sleeping
numeroteca commented 2 years ago

I've run docker-compose up in my Linux OS (Ubuntu 20.04) and I see a different outcome from this lines, where you see that the app is working and the Mysql activated:

mysql_1  | 2022-03-29 11:26:36 1 [Note] InnoDB: Completed initialization of buffer pool
app_1    | 1
app_1    | 1
mysql_1  | 2022-03-29 11:26:36 1 [Note] InnoDB: Highest supported file format is Barracuda.
app_1    | Mysql is up - executing command
mysql_1  | 2022-03-29 11:26:36 1 [Note] InnoDB: 128 rollback segment(s) are active.

Then later, when Mysql is called it uses port 13306 and it can ran the migration Invoke db:migrate:

mysql_1  | Version: '5.6.40'  socket: '/var/run/mysqld/mysqld.sock'  port: 13306  MySQL Community Server (GPL)
app_1    | ** Invoke db:migrate (first_time)
app_1    | ** Invoke environment (first_time)
app_1    | ** Execute environment

In my case it connects to port 13306, but in yours it does it to 3306. Could you check that your docker-compose.yml file points to 13306:13306 (line 13)?

What could be the cause of your app not starting earlier? @rporres ideas?

NoahAssam commented 2 years ago

the issue has been solved, was missing a file from the pageonex zip file