在CI/CD管道中使用Docker运行SonarQube

Question

我正在尝试让SonarQube在一个EC2实例上通过Docker容器扫描应用程序。我花了一天的时间研究了SonarQube和Postgres文档，但没什么收获。

我发现最明智的指南是由SonarSource维护的docker-sonarqube project。更具体地说，我遵循的是SonarQube/Postgres guide using docker-compose。

我的docker-compose.yml文件看起来与SonarSource提供的文件相同：

sonarqube:
  build: "5.2"
  ports:
   - "9000:9000"
  links:
   - db
  environment:
   - SONARQUBE_JDBC_URL=jdbc:postgresql://db:5432/sonar
  volumes_from:
   - plugins

db:
  image: postgres
  volumes_from:
    - datadb
  environment:
   - POSTGRES_USER=sonar
   - POSTGRES_PASSWORD=sonar

datadb:
  image: postgres
  volumes:
    - /var/lib/postgresql
  command: /bin/true

plugins:
  build: "5.2"
  volumes:
   - /opt/sonarqube/extensions
   - /opt/sonarqube/lib/bundled-plugins
  command: /bin/true

docker ps -a收益率：

CONTAINER ID        IMAGE                       COMMAND                  CREATED             STATUS                           PORTS                    NAMES
2d003aef18f2        dockersonarqube_sonarqube   "./bin/run.sh"           47 seconds ago      Up 46 seconds                    0.0.0.0:9000->9000/tcp   dockersonarqube_sonarqube_1
c7d5043f4381        dockersonarqube_plugins     "./bin/run.sh /bin/tr"   48 seconds ago      Exited (0) 46 seconds ago                                 dockersonarqube_plugins_1
590c72b4a723        postgres                    "/docker-entrypoint.s"   48 seconds ago      Up 47 seconds                    5432/tcp                 dockersonarqube_db_1
c105e6aebe09        postgres                    "/docker-entrypoint.s"   49 seconds ago      Exited (0) 48 seconds ago                                 dockersonarqube_datadb_1

sonarqube_1容器的最新输出为：

sonarqube_1 | 2016.01.20 17:49:09 INFO  web[o.s.s.a.TomcatAccessLog] Web server is started
sonarqube_1 | 2016.01.20 17:49:09 INFO  web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
sonarqube_1 | 2016.01.20 17:49:09 INFO  app[o.s.p.m.Monitor] Process[web] is up

我真正关心的是来自db_1容器的最新输出：

PostgreSQL init process complete; ready for start up.

LOG:  database system was shut down at 2016-01-20 17:48:40 UTC
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
ERROR:  relation "schema_migrations" does not exist at character 21
STATEMENT:  select version from schema_migrations
ERROR:  relation "schema_migrations" does not exist at character 21
STATEMENT:  select version from schema_migrations
ERROR:  relation "schema_migrations" does not exist at character 21
STATEMENT:  select version from schema_migrations
ERROR:  relation "schema_info" does not exist at character 15
STATEMENT:  SELECT * FROM "schema_info"  LIMIT 1

导航到http://my.instance.ip:9000失败。我能够从同一台机器访问其他正在运行的容器的相应端口。

有人能帮我指出正确的方向吗？有没有其他更适合我的指南或文档？我也看到了文档中的问题，说明分析项目是从mvn sonar:sonar开始的，但现在我将推迟这一点。非常感谢您的提前！

Answer 1

Use this image我修改了此镜像以与RDS实例对话。

EC2(对接声纳)<==> RDS postgres