2020年1月7日 00:13:15go评论96阅读模式

英文:

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

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

MariaDB连接被拒绝（NGINX，MariaDB，php-fpm）SQLSTATE[HY000] [2002]连接被拒绝

问题

答案1

登录失败，用户为 ‘sa’，位于 MS SQL Linux 容器中。

在Docker Compose中没有与MSSQL的连接

Rewrite "https://files.mydomain.com/files" to "https://files.mydomain.com"

一个 MariaDB 存储过程中检查表的参数被解释为表字段。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。