Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL connection error #14

Open
ElizabethCAllen opened this issue Oct 10, 2018 · 3 comments
Open

MySQL connection error #14

ElizabethCAllen opened this issue Oct 10, 2018 · 3 comments

Comments

@ElizabethCAllen
Copy link

When I try to start docker, and I cd into my presspack file and give the command "docker-compose up" it gives me errors.

Starting presspack_db_1 ... done Starting presspack_wordpress_1 ... done Starting presspack_phpmyadmin_1 ... done Attaching to presspack_db_1, presspack_wordpress_1, presspack_phpmyadmin_1 db_1 | 2018-10-10T01:29:33.760167Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). db_1 | 2018-10-10T01:29:33.765512Z 0 [Note] mysqld (mysqld 5.7.23) starting as process 1 ... db_1 | 2018-10-10T01:29:34.137489Z 0 [Note] InnoDB: PUNCH HOLE support available db_1 | 2018-10-10T01:29:34.139809Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins db_1 | 2018-10-10T01:29:34.141472Z 0 [Note] InnoDB: Uses event mutexes db_1 | 2018-10-10T01:29:34.143867Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier db_1 | 2018-10-10T01:29:34.144729Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 db_1 | 2018-10-10T01:29:34.145656Z 0 [Note] InnoDB: Using Linux native AIO db_1 | 2018-10-10T01:29:34.169431Z 0 [Note] InnoDB: Number of pools: 1 db_1 | 2018-10-10T01:29:34.690417Z 0 [Note] InnoDB: Using CPU crc32 instructions db_1 | 2018-10-10T01:29:34.769451Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M db_1 | 2018-10-10T01:29:35.078961Z 0 [Note] InnoDB: Completed initialization of buffer pool db_1 | 2018-10-10T01:29:35.301557Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). db_1 | 2018-10-10T01:29:35.418070Z 0 [Note] InnoDB: Highest supported file format is Barracuda. db_1 | 2018-10-10T01:29:35.992180Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2593926 db_1 | 2018-10-10T01:29:35.993621Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2593935 db_1 | 2018-10-10T01:29:35.995253Z 0 [Note] InnoDB: Database was not shutdown normally! db_1 | 2018-10-10T01:29:35.996587Z 0 [Note] InnoDB: Starting crash recovery. db_1 | 2018-10-10T01:29:37.924679Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" db_1 | 2018-10-10T01:29:37.926746Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables db_1 | 2018-10-10T01:29:37.927767Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... db_1 | 2018-10-10T01:29:46.125970Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. db_1 | 2018-10-10T01:29:46.169664Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. db_1 | 2018-10-10T01:29:46.169879Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. db_1 | 2018-10-10T01:29:46.175110Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10874ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) db_1 | 2018-10-10T01:29:46.190378Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2593935 db_1 | 2018-10-10T01:29:46.203756Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool db_1 | 2018-10-10T01:29:46.522393Z 0 [Note] Plugin 'FEDERATED' is disabled. db_1 | 2018-10-10T01:29:46.557444Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181010 1:29:46 db_1 | 2018-10-10T01:29:46.809208Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key db_1 | 2018-10-10T01:29:46.832497Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 db_1 | 2018-10-10T01:29:46.855514Z 0 [Note] IPv6 is available. db_1 | 2018-10-10T01:29:46.859956Z 0 [Note] - '::' resolves to '::'; db_1 | 2018-10-10T01:29:46.870716Z 0 [Note] Server socket created on IP: '::'. db_1 | 2018-10-10T01:29:47.390608Z 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. db_1 | 2018-10-10T01:29:47.454565Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. db_1 | 2018-10-10T01:29:47.455937Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. db_1 | 2018-10-10T01:29:47.457772Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. db_1 | 2018-10-10T01:29:47.463663Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. db_1 | 2018-10-10T01:29:47.465065Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. db_1 | 2018-10-10T01:29:47.470872Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. db_1 | 2018-10-10T01:29:47.521265Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. db_1 | 2018-10-10T01:29:47.522535Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. db_1 | 2018-10-10T01:29:47.994382Z 0 [Note] Event Scheduler: Loaded 0 events wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 phpmyadmin_1 | /usr/lib/python2.7/site-packages/supervisor/options.py:298: UserWarning: Supervisord is running as root and it is searching for its configuration file in default locations (including its current working directory); you probably want to specify a "-c" argument specifying an absolute path to a configuration file for improved security. phpmyadmin_1 | 'Supervisord is running as root and it is searching ' phpmyadmin_1 | 2018-10-10 01:29:55,562 CRIT Supervisor running as root (no user in config file) phpmyadmin_1 | 2018-10-10 01:29:55,566 INFO Included extra file "/etc/supervisor.d/nginx.ini" during parsing phpmyadmin_1 | 2018-10-10 01:29:55,567 INFO Included extra file "/etc/supervisor.d/php.ini" during parsing phpmyadmin_1 | Unlinking stale socket /run/supervisord.sock phpmyadmin_1 | 2018-10-10 01:29:56,246 INFO RPC interface 'supervisor' initialized phpmyadmin_1 | 2018-10-10 01:29:56,277 CRIT Server 'unix_http_server' running without any HTTP authentication checking phpmyadmin_1 | 2018-10-10 01:29:56,280 INFO supervisord started with pid 1 phpmyadmin_1 | 2018-10-10 01:29:57,290 INFO spawned: 'php-fpm' with pid 14 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 phpmyadmin_1 | 2018-10-10 01:29:57,309 INFO spawned: 'nginx' with pid 15 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server wordpress_1 | wordpress_1 | Warning: mysqli::__construct(): (HY000/1130): Host '172.20.0.3' is not allowed to connect to this MySQL server in Standard input code on line 22 wordpress_1 | wordpress_1 | MySQL Connection Error: (1130) Host '172.20.0.3' is not allowed to connect to this MySQL server presspack_wordpress_1 exited with code 1
@JosiahSlade
Copy link

Getting the same issue as well

@krystianjj
Copy link
Contributor

krystianjj commented Jan 23, 2019 •
edited
Loading

Is it docker running properly ? What OS you use?
I'm using win10 professional and everything working great.

@wilcho-vnz
Copy link

Try adding more environment values in wordpress services

`
version: "3"
services:
.
.
.

  wordpress:
    .
    .
    .
    environment:
      WORDPRESS_DB_HOST: db:3306
      DB_NAME: wordpress
      WORDPRESS_DB_USER: wordpress
      WORDPRESS_DB_PASSWORD: wordpress

`

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@wilcho-vnz @JosiahSlade @krystianjj @ElizabethCAllen