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

Question

我试图在我们的一个am上运行乌拉斯对接设置。我听从了这的指引。当我执行文档的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

​

在码头上的集装箱是

​

~/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

由于上面的评论解决了这个问题，我将发布一个答案，以使这个问题更加引人注目。

您所面临的问题是由Vulas使用的.env文件中缺少或更改的用户造成的。在这条线，我们可以看到Postgres在创建数据库之前，检查POSTGRES_USER和POSTGRES_PASSWORD是否都已设置。我可以看到，在您的输出中，Postgres容器启动了，因此在.env文件的某个时候，设置了这些环境变量。可能您更改或删除了POSTGRES_USER。通过这样做，Vulas尝试用与创建数据库的用户不同的用户连接Postgres，从而无法初始化连接。

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