Vulas 启动失败，后端出现异常

Question

我正在尝试运行 Vulas在我们的一个虚拟机上设置 docker。我关注了this指导。当我执行文档的 Run 阶段时，后端服务无法启动。我有以下异常，这对我没有任何解释。

#docker logs d04ea50241f7
2018-12-18 10:28:50.841 ERROR 9 --- [ost-startStop-1] o.a.tomcat.jdbc.pool.ConnectionPool      : Unable to create initial connections of pool.

org.postgresql.util.PSQLException: FATAL: role "root" does not exist
    at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:712) ~[postgresql-9.4.1208.jre7.jar!/:9.4.1208.jre7]
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213) ~[postgresql-9.4.1208.jre7.jar!/:9.4.1208.jre7]
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) ~[postgresql-9.4.1208.jre7.jar!/:9.4.1208.jre7]
    at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:215) ~[postgresql-9.4.1208.jre7.jar!/:9.4.1208.jre7]
    at org.postgresql.Driver.makeConnection(Driver.java:406) ~[postgresql-9.4.1208.jre7.jar!/:9.4.1208.jre7]
    at org.postgresql.Driver.connect(Driver.java:274) ~[postgresql-9.4.1208.jre7.jar!/:9.4.1208.jre7]
    at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:319) ~[tomcat-jdbc-8.5.32.jar!/:na]
    at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181]

2018-12-18 10:28:50.846 ERROR 9 --- [ost-startStop-1] o.s.b.c.embedded.tomcat.TomcatStarter    : Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error creating bean with name 'dispatcherServletRegistration' defined in class path resource [org/springframework/boot/autoconfigure/web/DispatcherServletAutoConfiguration$DispatcherServletRegistrationConfiguration.class]: Unsatisfied dependency expressed through method 'dispatcherServletRegistration' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'hubIntegrationController' defined in URL [jar:file:/vulas/rest-backend.jar!/BOOT-INF/classes!/com/sap/psr/vulas/backend/rest/HubIntegrationController.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'applicationRepositoryImpl': Unsatisfied dependency expressed through field 'appRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'applicationRepository': Cannot create inner bean '(inner bean)#5368a637' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#5368a637': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.exception.FlywaySqlException:
Unable to obtain database connection
------------------------------------
SQL State  : 28000
Error Code : 0
Message    : FATAL: role "root" does not exist

启动的docker容器是

~/vulas/vulnerability-assessment-tool# docker ps
CONTAINER ID        IMAGE                       COMMAND                  CREATED             STATUS              PORTS                                            NAMES
05a90996f80d        docker_haproxy              "/docker-entrypoint.…"   7 minutes ago       Up 7 minutes        0.0.0.0:8034->7070/tcp, 0.0.0.0:8033->8080/tcp   vulas-os-haproxy
2877eeb8db76        docker_patch-lib-analyzer   "/vulas/run.sh"          7 minutes ago       Up 7 minutes        8080/tcp                                         vulas-os-patch-lib-analyzer
7d05307d9149        docker_frontend-bugs        "catalina.sh run"        7 minutes ago       Up 7 minutes        8080/tcp                                         vulas-os-frontend-bugs
84311f182d98        docker_rest-lib-utils       "/bin/sh -c 'java -D…"   7 minutes ago       Up 7 minutes        8092/tcp                                         vulas-os-rest-lib-utils
a55cc03b8ee8        docker_frontend-apps        "catalina.sh run"        7 minutes ago       Up 7 minutes        8080/tcp                                         vulas-os-frontend-apps
45a7210170e7        docker_postgresql           "docker-entrypoint.s…"   7 minutes ago       Up 7 minutes        0.0.0.0:8032->5432/tcp                           vulas-os-postgresql

Answer 1

由于上面的评论解决了这个问题，我将发布一个答案以提高这个问题的可见度。

您遇到的问题是由 .env 中的用户丢失或更改引起的Vulas 使用的文件。在 this line我们可以看到 Postgres 在创建数据库之前检查是否设置了 POSTGRES_USER 和 POSTGRES_PASSWORD。我可以在您的输出中看到 Postgres 容器已启动，因此在 .env 文件中的某个时间点设置了这些环境变量。可能您更改或删除了 POSTGRES_USER。通过这样做，Vulas 尝试使用与创建数据库的用户不同的用户连接到 Postgres，因此无法初始化连接。

在第一次运行 Vulas 之前，必须修改 .env 文件。如果您需要将连接参数更改为数据库，则需要创建一个新参数。为了删除当前数据库并创建一个新数据库，请在 Vulas 存储库的 docker 文件夹中输入命令 docker-compose down -v。这将删除每个卷。