MariaDB连接被拒绝(NGINX,MariaDB,php-fpm)SQLSTATE[HY000] [2002]连接被拒绝

huangapple go评论72阅读模式
英文:

MariaDB Connection refused (NGINX , MariaDB, php-fpm) SQLSTATE[HY000] [2002] Connection refused

问题

这是你的文档中的一部分内容:

"Getting SQLSTATE[HY000] [2002] Connection refused when sending query to MariaDB"
在发送查询到MariaDB时出现SQLSTATE[HY000] [2002]连接被拒绝的错误。

以下是你的docker-compose构建的链接:
https://github.com/bocasoftware/docker-compose

这是data.sql文件的链接(不在GitHub存储库中,因为文件太大,但它在我的构建中存在):
https://gitlab.com/x-team-blog/docker-compose-php/blob/master/docker/database/data.sql

这是你的文档树/布局:

myapp
├── docker
│ ├── app
│ │ └── Dockerfile
│ ├── db
│ │ ├── data.sql
│ │ └── Dockerfile
│ ├── docker-compose.yml
│ └── nginx
│ ├── conf.d
│ │ └── default.conf
│ ├── Dockerfile
│ ├── nginx.conf
│ └── sites
│ └── default.conf
└── src
├── html
└── index.php

这是你的index.php文件中的查询部分的代码:

<?php

$value = "World";

try {
    $db = new PDO('mysql:host=db;dbname=mydb;charset=utf8mb4', 'myuser', 'secret');

    $databaseTest = ($db->query('SELECT * FROM dockerSample'))->fetchAll(PDO::FETCH_OBJ);
} catch (Exception $e) {
    print $e->getMessage() . "\n";
}
print "OK\n";
?>

这是你的docker-compose.yml文件的一部分:

version: '3'

services:

  app:
    build:
      context: ./app
    volumes:
      - ../src:/var/www

  nginx:
    build:
      context: ./nginx
    volumes:
      - ../src:/var/www
      - ./nginx/nginx.conf:/etc/nginx/nginx.conf
      - ./nginx/sites/:/etc/nginx/sites-available
      - ./nginx/conf.d/:/etc/nginx/conf.d
    depends_on:
      - app
    ports:
      - "80:80"
      - "443:443"

  db:
    build:
      context: ./db
    ports:
      - "3306:3306"
    environment:
      - MYSQL_DATABASE=mydb
      - MYSQL_USER=myuser
      - MYSQL_PASSWORD=secret
      - MYSQL_ROOT_PASSWORD=docker
    volumes:
      - ./db/data.sql:/docker-entrypoint-initdb.d/data.sql

这是你的Docker容器的状态,使用docker ps命令查看:

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                                                NAMES
23ae6d48e413        docker_nginx        "nginx"                  About an hour ago   Up 13 minutes       0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp, 8080/tcp   docker_nginx_1
d84c3b348266        docker_app          "docker-php-entrypoi…"   About an hour ago   Up 13 minutes       9000/tcp                                             docker_app_1
5ba1e7d36f91        docker_db           "docker-entrypoint.s…"   About an hour ago   Up 13 minutes       3306/tcp                                             docker_db_1

这是你构建的Docker容器的日志信息。

英文:

Getting SQLSTATE[HY000] [2002] Connection refused when sending query to MariaDB

Below is the link to my docker-compose build

https://github.com/bocasoftware/docker-compose

--- IMPORTANT This is the data.sql file (NOT in the github repository file was too large but it is on my build):

https://gitlab.com/x-team-blog/docker-compose-php/blob/master/docker/database/data.sql

This is my document tree/layout:

myapp
├── docker
│&#160;&#160; ├── app
│&#160;&#160; │&#160;&#160; └── Dockerfile
│&#160;&#160; ├── db
│&#160;&#160; │&#160;&#160; ├── data.sql
│&#160;&#160; │&#160;&#160; └── Dockerfile
│&#160;&#160; ├── docker-compose.yml
│&#160;&#160; └── nginx
│&#160;&#160;     ├── conf.d
│&#160;&#160;     │&#160;&#160; └── default.conf
│&#160;&#160;     ├── Dockerfile
│&#160;&#160;     ├── nginx.conf
│&#160;&#160;     └── sites
│&#160;&#160;         └── default.conf
└── src
    ├── html
    └── index.php

Here is my index.php which has the query:

&lt;?php

$value = &quot;World&quot;;

try {
$db = new PDO(&#39;mysql:host=db;dbname=mydb;charset=utf8mb4&#39;, &#39;myuser&#39;, &#39;secret&#39;);

$databaseTest = ($db-&gt;query(&#39;SELECT * FROM dockerSample&#39;))- 
&gt;fetchAll(PDO::FETCH_OBJ);
} catch (Exception $e) {
print $e-&gt;getMessage() . &quot;\n&quot;;
}
print &quot;OK\n&quot;;
?&gt;

&lt;html&gt;
    &lt;body&gt;
        &lt;h1&gt;Hello, &lt;?= $value ?&gt;!&lt;/h1&gt;

        &lt;?php foreach($databaseTest as $row): ?&gt;
            &lt;p&gt;Hello, &lt;?= $row-&gt;name ?&gt;&lt;/p&gt;
        &lt;?php endforeach; ?&gt;
    &lt;/body&gt;
&lt;/html&gt;

Here is my docker-compose.yml:

version: '3'

services:

  app:
   build:
     context: ./app
   volumes:
      - ../src:/var/www


  nginx:
   build:
     context: ./nginx
   volumes:
      - ../src:/var/www
      - ./nginx/nginx.conf:/etc/nginx/nginx.conf
      - ./nginx/sites/:/etc/nginx/sites-available
      - ./nginx/conf.d/:/etc/nginx/conf.d
   depends_on:
      - app
   ports:
      - &quot;80:80&quot;
      - &quot;443:443&quot;


  db:
   build:
     context: ./db
   ports:
      - &quot;3306:3306&quot;
   environment:
      - MYSQL_DATABASE=mydb
      - MYSQL_USER=myuser
      - MYSQL_PASSWORD=secret
      - MYSQL_ROOT_PASSWORD=docker
   volumes:
      - ./db/data.sql:/docker-entrypoint-initdb.d/data.sql

I do not understand what is going on. It seems I am reaching MariaDB but it's refusing my connection despite checking ports, user and password and pruning volumes, removing containers, deleting images and building them again from scratch.

docker ps:

 	CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                                                NAMES
23ae6d48e413        docker_nginx        &quot;nginx&quot;                  About an hour ago   Up 13 minutes       0.0.0.0:80-&gt;80/tcp, 0.0.0.0:443-&gt;443/tcp, 8080/tcp   docker_nginx_1
d84c3b348266        docker_app          &quot;docker-php-entrypoi…&quot;   About an hour ago   Up 13 minutes       9000/tcp                                             docker_app_1
5ba1e7d36f91        docker_db           &quot;docker-entrypoint.s…&quot;   About an hour ago   Up 13 minutes       3306/tcp                                             docker_db_1

Build logs:

	Building db
Step 1/3 : FROM mariadb:latest
 ---&gt; 2f11cf2ec189
Step 2/3 : CMD [&quot;mysqld&quot;]
 ---&gt; Using cache
 ---&gt; 9f5dd0c62210
Step 3/3 : EXPOSE 3306
 ---&gt; Using cache
 ---&gt; fe82aa37cc8d
Successfully built fe82aa37cc8d
Successfully tagged docker_db:latest
Building app
Step 1/4 : FROM php:fpm-alpine
 ---&gt; aac18a94faf7
Step 2/4 : RUN docker-php-ext-install pdo_mysql
 ---&gt; Using cache
 ---&gt; 886e00ce8edc
Step 3/4 : CMD [&quot;php-fpm&quot;]
 ---&gt; Using cache
 ---&gt; 90bf05e46cc5
Step 4/4 : EXPOSE 9000
 ---&gt; Using cache
 ---&gt; 2e9cb9be36b7
Successfully built 2e9cb9be36b7
Successfully tagged docker_app:latest
Building nginx
Step 1/3 : FROM nginx:alpine
 ---&gt; a624d888d69f
Step 2/3 : CMD [&quot;nginx&quot;]
 ---&gt; Using cache
 ---&gt; 767651bd1614
Step 3/3 : EXPOSE 8080 443
 ---&gt; Using cache
 ---&gt; 6fc1df24d4e4
Successfully built 6fc1df24d4e4
Successfully tagged docker_nginx:latest
Starting docker_db_1 ... 
Starting docker_db_1 ... done
Starting docker_app_1 ... 
Starting docker_app_1 ... done
Starting docker_nginx_1 ... 
Starting docker_nginx_1 ... done
Attaching to docker_db_1, docker_app_1, docker_nginx_1
db_1     | 2020-01-06 18:17:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.4.11+maria~bionic started.
app_1    | [06-Jan-2020 18:17:44] NOTICE: fpm is running, pid 1
db_1     | 2020-01-06 18:17:43+00:00 [Note] [Entrypoint]: Switching to dedicated user &#39;mysql&#39;
db_1     | 2020-01-06 18:17:43+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.4.11+maria~bionic started.
app_1    | [06-Jan-2020 18:17:44] NOTICE: ready to handle connections
db_1     | 2020-01-06 18:17:43 0 [Note] mysqld (mysqld 10.4.11-MariaDB-1:10.4.11+maria~bionic) starting as process 1 ...
db_1     | 2020-01-06 18:17:43 0 [Note] InnoDB: Using Linux native AIO
db_1     | 2020-01-06 18:17:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1     | 2020-01-06 18:17:43 0 [Note] InnoDB: Uses event mutexes
db_1     | 2020-01-06 18:17:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
db_1     | 2020-01-06 18:17:43 0 [Note] InnoDB: Number of pools: 1
db_1     | 2020-01-06 18:17:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
db_1     | 2020-01-06 18:17:43 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
db_1     | 2020-01-06 18:17:43 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db_1     | 2020-01-06 18:17:43 0 [Note] InnoDB: Completed initialization of buffer pool
db_1     | 2020-01-06 18:17:43 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     | 2020-01-06 18:17:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db_1     | 2020-01-06 18:17:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1     | 2020-01-06 18:17:44 0 [Note] InnoDB: Setting file &#39;./ibtmp1&#39; size to 12 MB. Physically writing the file full; Please wait ...
db_1     | 2020-01-06 18:17:44 0 [Note] InnoDB: File &#39;./ibtmp1&#39; size is now 12 MB.
db_1     | 2020-01-06 18:17:44 0 [Note] InnoDB: 10.4.11 started; log sequence number 6837896; transaction id 7512
db_1     | 2020-01-06 18:17:44 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1     | 2020-01-06 18:17:44 0 [Note] Plugin &#39;FEEDBACK&#39; is disabled.
db_1     | 2020-01-06 18:17:44 0 [Note] Server socket created on IP: &#39;::&#39;.
db_1     | 2020-01-06 18:17:44 0 [Warning] &#39;user&#39; entry &#39;root@5ba1e7d36f91&#39; ignored in --skip-name-resolve mode.
db_1     | 2020-01-06 18:17:44 0 [Warning] &#39;user&#39; entry &#39;@5ba1e7d36f91&#39; ignored in --skip-name-resolve mode.
db_1     | 2020-01-06 18:17:44 0 [Warning] &#39;proxies_priv&#39; entry &#39;@% root@5ba1e7d36f91&#39; ignored in --skip-name-resolve mode.
db_1     | 2020-01-06 18:17:44 0 [Note] Reading of all Master_info entries succeeded
db_1     | 2020-01-06 18:17:44 0 [Note] Added new Master_info &#39;&#39; to hash table
db_1     | 2020-01-06 18:17:44 0 [Note] mysqld: ready for connections.
db_1     | Version: &#39;10.4.11-MariaDB-1:10.4.11+maria~bionic&#39;  socket: &#39;/var/run/mysqld/mysqld.sock&#39;  port: 3306  mariadb.org binary distribution
db_1     | 2020-01-06 18:17:45 0 [Note] InnoDB: Buffer pool(s) load completed at 200106 18:17:45

答案1

得分: 1

add

depends_on:
      - db

for app

英文:

add

depends_on:
      - db

for app

huangapple
  • 本文由 发表于 2020年1月7日 00:13:15
  • 转载请务必保留本文链接:https://go.coder-hub.com/59615391.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定