在jenkins中使用docker exec运行october artisan命令时拒绝连接

qij5mzcb  于 2021-06-15  发布在  Mysql
关注(0)|答案(2)|浏览(458)

我正试图用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
mysqldockerJenkinsdatabase-migrationoctobercms

2条答案

按热度按时间
ua4mk5z4

ua4mk5z41#

在安装应用程序的同时 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环境中产生问题。
您可以从这里查看参考资料：https://docs.docker.com/compose/startup-order/
如果有任何疑问，请评论。

赞(0）分享  回复(0）举报  2021-06-16
ckocjqey

ckocjqey2#

添加“sleep”命令对我有效。似乎在第二阶段（名为“docker”的阶段）开始时docker仍未构建。我以为当前一个阶段完全结束时，这个阶段就开始了。这是最终的Jenkins档案：

pipeline {
    agent any
        stages {
            stage('Docker') {
                steps {
                    script {
                        sh '''
                            chmod -R 777 storage
                            docker-compose up --build -d
                            sleep 30
                            docker exec dockerfilemaster_app_1 useradd jenkins
                            docker exec dockerfilemaster_app_1 chmod -R 777 /var/www
                            docker exec -u jenkins dockerfilemaster_app_1 composer install
                            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
                '''
        }
    }
}

我将“docker compose up”命令与其他docker命令放在一起，因为将该命令放在另一个阶段没有帮助。

赞(0）分享  回复(0）举报  2021-06-16
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com