mysql - 在 Jenkins 中使用 docker exec 运行 October artisan 命令时连接被拒绝

Question

我正在尝试使用 docker 命令通过 Jenkins 执行 OctoberCMS 迁移，但我在 Jenkins 控制台中遇到下一个错误:

+ docker exec -u jenkins dockerfilemaster_app_1 php artisan october:up
Migrating application and plugins...

[Illuminate\Database\QueryException]                                         
SQLSTATE[HY000] [2002] Connection refused (SQL: select * from 
information_s  
chema.tables where table_schema = databasename and table_name = 
migrations)                                                                          

[Doctrine\DBAL\Driver\PDOException]        
SQLSTATE[HY000] [2002] Connection refused  

[PDOException]                             
SQLSTATE[HY000] [2002] Connection refused

这是我正在使用的声明性 Jenkinsfile(“ping”命令用于确保数据库可访问):

pipeline {
    agent any
        stages {
            stage('Composer') {
                steps {
                    script {
                        sh '''
                            chmod -R 777 storage
                            composer install
                            docker-compose up --build -d
                            '''
                    }
                }
            }


            stage('Docker') {
                steps {
                    script {
                        sh '''
                            docker exec dockerfilemaster_app_1 useradd jenkins
                            docker exec -u jenkins dockerfilemaster_app_1 ping -c 2 database
                            docker exec -u jenkins dockerfilemaster_app_1 php artisan october:up
                            docker exec -u jenkins dockerfilemaster_app_1 php artisan october:down --force
                            '''
                    }
                }
            }
        }
    post {
        always {
            sh '''
                docker-compose down
                '''
        }
    }
}

但是，如果我使用 SSH 连接到 Jenkins 服务器，并执行相同的脚本，它会起作用:

docker-compose up --build -d
docker exec dockerfilemaster_app_1 useradd jenkins
docker exec -u jenkins dockerfilemaster_app_1 php artisan october:up

数据库配置:

'mysql' => [
            'driver'    => 'mysql',
            'host' => env('DB_HOST', 'database'),
            'port' => env('DB_PORT', 3306),
            'database' => env('DB_DATABASE', 'databasename'),
            'username' => env('DB_USERNAME', 'root'),
            'password' => env('DB_PASSWORD', 'secret'),
            'charset'   => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix'    => '',
        ],

docker-compose.yml 文件:

version: '2'
services:
    web:
        build:
            context: ./
            dockerfile: web.docker
        volumes:
            - ./:/var/www/public
        ports:
            - "8081:80"
        links:
            - app
    app:
        build:
            context: ./
            dockerfile: app.docker
        volumes:
            - ./:/var/www
        links:
            - database
        environment:
            - "DB_PORT=3306"
            - "DB_HOST=database"
    database:
        image: mysql:5.6
        environment:
            - "MYSQL_ROOT_PASSWORD=secret"
            - "MYSQL_DATABASE=databasename"
        ports:
            - "3306:3306"

我不明白为什么如果我在通过 SSH 连接的服务器上执行脚本可以工作，但如果 Jenkins 执行相同的脚本就不能工作。

这是整个 Jenkins 控制台输出:

Branch indexing
 > git rev-parse --is-inside-work-tree # timeout=10
Setting origin to https://gitlab.com/[...]
 > git config remote.origin.url https://gitlab.com/[...] # timeout=10
Fetching origin...
Fetching upstream changes from origin
 > git --version # timeout=10
 > git config --get remote.origin.url # timeout=10
using GIT_ASKPASS to set credentials 
 > git fetch --tags --progress origin +refs/heads/*:refs/remotes/origin/*
Seen branch in repository origin/develop
Seen branch in repository origin/master
Seen 2 remote branches
Obtained Jenkinsfile from e40e597c1a6bb87221f6c0844174534b5a5a4e15
Running in Durability level: MAX_SURVIVABILITY
[Pipeline] node
Running on Jenkins  in /var/lib/jenkins/workspace/docker-file_master
[Pipeline] {
[Pipeline] stage
[Pipeline] { (Declarative: Checkout SCM)
[Pipeline] checkout
 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url https://gitlab.com/[...] # timeout=10
Fetching without tags
Fetching upstream changes from https://gitlab.com/[...]
 > git --version # timeout=10
using GIT_ASKPASS to set credentials 
 > git fetch --no-tags --progress https://gitlab.com/[...] +refs/heads/*:refs/remotes/origin/*
Checking out Revision e40e597c1a6bb87221f6c0844174534b5a5a4e15 (master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f e40e597c1a6bb87221f6c0844174534b5a5a4e15
Commit message: "Testing with env"
 > git rev-list --no-walk 1b46891b6e4078d426f8a33dc5fc1f6b2a743f56 # timeout=10
[Pipeline] }
[Pipeline] // stage
[Pipeline] withEnv
[Pipeline] {
[Pipeline] stage
[Pipeline] { (Composer)
[Pipeline] script
[Pipeline] {
[Pipeline] sh
+ whoami
jenkins
+ chmod -R 777 storage
+ composer install
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Nothing to install or update
Generating autoload files
+ docker-compose up --build -d
Creating network "dockerfilemaster_default" with the default driver
Building app
Step 1/4 : FROM php:7.1-fpm
 ---> 894f8d826f6a
Step 2/4 : RUN apt-get update && apt-get install -y apt-utils mcrypt libmcrypt-dev mysql-client git zip unzip zlib1g-dev iputils-ping     && docker-php-ext-install pdo_mysql mysqli zip
 ---> Using cache
 ---> 0881c5505ea5
Step 3/4 : COPY --from=composer:latest /usr/bin/composer /usr/bin/composer
 ---> Using cache
 ---> d1f1d74f8b0f
Step 4/4 : WORKDIR /var/www
 ---> Using cache
 ---> 60aefdca48ba
Successfully built 60aefdca48ba
Successfully tagged dockerfilemaster_app:latest
Building web
Step 1/3 : FROM nginx:1.10
 ---> 0346349a1a64
Step 2/3 : ADD ./vhost.conf /etc/nginx/conf.d/default.conf
 ---> Using cache
 ---> 74cadd23348a
Step 3/3 : WORKDIR /var/www
 ---> Using cache
 ---> 4142e3e3d33a
Successfully built 4142e3e3d33a
Successfully tagged dockerfilemaster_web:latest
Creating dockerfilemaster_database_1
Creating dockerfilemaster_app_1
Creating dockerfilemaster_web_1
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Docker)
[Pipeline] script
[Pipeline] {
[Pipeline] sh
+ docker exec dockerfilemaster_app_1 useradd jenkins
+ docker exec -u jenkins dockerfilemaster_app_1 whoami
jenkins
+ docker exec -u jenkins dockerfilemaster_app_1 ping -c 2 database
PING database (172.26.0.2) 56(84) bytes of data.
64 bytes from dockerfilemaster_database_1.dockerfilemaster_default (172.26.0.2): icmp_seq=1 ttl=64 time=0.158 ms
64 bytes from dockerfilemaster_database_1.dockerfilemaster_default (172.26.0.2): icmp_seq=2 ttl=64 time=0.198 ms

--- database ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 999ms
rtt min/avg/max/mdev = 0.158/0.178/0.198/0.020 ms
+ docker exec -u jenkins dockerfilemaster_app_1 php artisan october:up
Migrating application and plugins...


  [Illuminate\Database\QueryException]                                         
  SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_s  
  chema.tables where table_schema = databasename and table_name = migratio  
  ns)                                                                          



  [Doctrine\DBAL\Driver\PDOException]        
  SQLSTATE[HY000] [2002] Connection refused  



  [PDOException]                             
  SQLSTATE[HY000] [2002] Connection refused  


[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Required)
Stage "Required" skipped due to earlier failure(s)
[Pipeline] parallel
[Pipeline] { (Branch: editorConfig)
[Pipeline] stage
[Pipeline] { (editorConfig)
Stage "editorConfig" skipped due to earlier failure(s)
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch editorConfig
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] sh
+ docker-compose down
Stopping dockerfilemaster_web_1 ... 
Stopping dockerfilemaster_app_1 ... 
Stopping dockerfilemaster_database_1 ... 
[3A[2K
Stopping dockerfilemaster_web_1 ... done
[3B[2A[2K
Stopping dockerfilemaster_app_1 ... done
[2B[1A[2K
Stopping dockerfilemaster_database_1 ... done
[1BRemoving dockerfilemaster_web_1 ... 
Removing dockerfilemaster_app_1 ... 
Removing dockerfilemaster_database_1 ... 
[2A[2K
Removing dockerfilemaster_app_1 ... done
[2B[3A[2K
Removing dockerfilemaster_web_1 ... done
[3B[1A[2K
Removing dockerfilemaster_database_1 ... done
[1BRemoving network dockerfilemaster_default
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] End of Pipeline
ERROR: script returned exit code 1
Finished: FAILURE

Answer 1

嗯，似乎当应用程序正在安装时 DB 实例无法启动，所以我们可以添加 depends_on。数据库在这种环境中总是会产生问题。

version: '2'
services:
    web:
        build:
            context: ./
            dockerfile: web.docker
        volumes:
            - ./:/var/www/public
        ports:
            - "8081:80"
        links:
            - app
        depends_on:     <= THIS       
            - "app"     <= N THIS
    app:
        build:
            context: ./
            dockerfile: app.docker
        volumes:
            - ./:/var/www
        links:
            - database
        depends_on:          <= THIS       
            - "database"     <= N THIS
        environment:
            - "DB_PORT=3306"
            - "DB_HOST=database"
    database:
        image: mysql:5.6
        environment:
            - "MYSQL_ROOT_PASSWORD=secret"
            - "MYSQL_DATABASE=databasename"
        ports:
            - "3306:3306"

也许它可以解决您的问题。如果 NOT，那么您需要检查下面引用中建议的工具，这些工具会对您有所帮助。因为他们还提到 DB 在 docker 环境中造成问题。

You can check reference from here : https://docs.docker.com/compose/startup-order/

如有疑问请评论。