GMOD / docker-apollo

:whale: Apollo 2.X Docker Image
GNU General Public License v3.0
10 stars 12 forks source link

Exceptions and Errors #27

Closed mictadlo closed 6 years ago

mictadlo commented 6 years ago

Hi, I set up docker-apollo inside a docker-compose.yml file:

apollo:
  image: quay.io/gmod/docker-apollo:latest
  restart: always
  ports:
    - "8888:8080"
  volumes:
    - ./data//jbrowse:/data
    - ./data/postgres-data:/var/lib/postgresql

While starting up I got the following Errors and Exceptions:

...

apollo_1          | WARNING: enabling "trust" authentication for local connections
apollo_1          | You can change this by editing pg_hba.conf or using the option -A, or
apollo_1          | --auth-local and --auth-host, the next time you run initdb.
apollo_1          | Starting PostgreSQL 9.6 database server: main.
apollo_1          | WEBAPOLLO_HOST_FLAG: 
apollo_1          | CHADO_HOST_FLAG: 
apollo_1          | Waiting for DB
apollo_1          | /var/run/postgresql:5432 - accepting connections
apollo_1          | Postgres is up, configuring database
apollo_1          | psql: FATAL:  Peer authentication failed for user "apollo-lqt"
apollo_1          | Apollo database not found, creating...
apollo_1          | CREATE ROLE
apollo_1          | GRANT
apollo_1          | Configuring Chado
apollo_1          | psql: FATAL:  Peer authentication failed for user "apollo"
apollo_1          | Chado database not found, creating...
apollo_1          | ERROR:  role "apollo" already exists
apollo_1          | GRANT
apollo_1          | Loading Chado

...

apollo_1          | CREATE EXTENSION
apollo_1          | psql:/chado.sql:49: ERROR:  must be owner of extension plpgsql
apollo_1          | SET

...

apollo_1          | ALTER TABLE
apollo_1          | SET
apollo_1          | psql:/chado.sql:2637928: ERROR:  function create_point(integer, bigint) does not exist
apollo_1          | LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
apollo_1          |                     ^
apollo_1          | HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
apollo_1          | QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
apollo_1          | CONTEXT:  SQL function "boxrange" during inlining
apollo_1          | CREATE INDEX

...

apollo_1          | Loaded Chado
apollo_1          | Restarting tomcat with /usr/local/tomcat/
apollo_1          | Jul 04, 2018 10:25:47 AM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
apollo_1          | Jul 04, 2018 10:25:47 AM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Catalina.stop: 
apollo_1          | java.net.ConnectException: Connection refused (Connection refused)
apollo_1          |     at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          |     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          |     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          |     at java.net.Socket.connect(Socket.java:589)
apollo_1          |     at java.net.Socket.connect(Socket.java:538)
apollo_1          |     at java.net.Socket.<init>(Socket.java:434)
apollo_1          |     at java.net.Socket.<init>(Socket.java:211)
apollo_1          |     at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
apollo_1          |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1          |     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1          |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1          |     at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1          |     at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
apollo_1          |     at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)
apollo_1          | 
apollo_1          | Tomcat started.

...

apollo_1          | Shiro Configured
apollo_1          | 2018-07-04 10:26:36,175 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table allele add constraint FK_ssx0gv6xbtu3tbwt6ekkmn4iw foreign key (variant_id) references feature
apollo_1          | 2018-07-04 10:26:36,179 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: constraint "fk_ssx0gv6xbtu3tbwt6ekkmn4iw" for relation "allele" already exists
apollo_1          | 2018-07-04 10:26:43,169 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add column cvterm_id int8 not null
apollo_1          | 2018-07-04 10:26:43,169 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" contains null values
apollo_1          | 2018-07-04 10:26:49,561 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add constraint FK_8twb5n8vjmldyy3eeyq7sppc3 foreign key (cvterm_id) references cvterm
apollo_1          | 2018-07-04 10:26:49,561 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" referenced in foreign key constraint does not exist
apollo_1          | Starting Quartz Scheduler in QuartzFactoryBean
apollo_1   

...

apollo_1          | 2018-07-04 10:27:47,437 [http-nio-8080-exec-6] WARN  apollo.PreferenceService  - No user present, so using the client token
apollo_1          | 2018-07-04 10:27:47,486 [http-nio-8080-exec-3] ERROR apollo.PermissionService  - Username not supplied so can not authenticate.
apollo_1          | 2018-07-04 10:27:47,495 [http-nio-8080-exec-3] ERROR apollo.PermissionService  - User null does not exist in the database.
apollo_1          | 2018-07-04 10:27:47,549 [http-nio-8080-exec-10] ERROR authenticator.UsernamePasswordAuthenticatorService  - Problem authenticating: java.lang.IllegalArgumentException: Method argumet (authentication token) cannot be null.
apollo_1          | 2018-07-04 10:27:47,550 [http-nio-8080-exec-10] WARN  apollo.PermissionService  - Failed to authenticate user
apollo_1          | 2018-07-04 10:27:47,550 [http-nio-8080-exec-10] ERROR apollo.UserController  - Failed to authenticate

What did I miss?

Thank you in advance.

Michal

nathandunn commented 6 years ago

Well, there is a bit of work to be done unfortunately.

If you don’t need any advanced features of Apollo you could use the apollo-only branch, which is probably more of what you were looking for.

Conversely, you could use that and update this: https://github.com/GMOD/docker-apollo/blob/apollo-only/Dockerfile#L22 https://github.com/GMOD/docker-apollo/blob/apollo-only/Dockerfile#L22

To 6189ff9e2973e1523ddcdbeee9d258c435c42a54

A few questions that would help me help you:

1 - why do you need to use docker compose? 2 - ultimately what are you trying to accomplish?

You might want to take a look at this: https://github.com/galaxy-genome-annotation/docker-galaxy-genome-annotation https://github.com/galaxy-genome-annotation/docker-galaxy-genome-annotation. (They integrate multiple things within galaxy, including Apollo).

Natban

On Jul 3, 2018, at 6:06 PM, Michał T. Lorenc notifications@github.com wrote:

Hi, I set up docker-apollo inside a docker-compose.yml file:

apollo: image: quay.io/gmod/docker-apollo:latest restart: always ports:

  • "8888:8080" volumes:
  • ./data//jbrowse:/data
  • ./data/postgres-data:/var/lib/postgresql While starting up I got the following Errors and Exceptions:

...

apollo_1 | WARNING: enabling "trust" authentication for local connections apollo_1 | You can change this by editing pg_hba.conf or using the option -A, or apollo_1 | --auth-local and --auth-host, the next time you run initdb. apollo_1 | Starting PostgreSQL 9.6 database server: main. apollo_1 | WEBAPOLLO_HOST_FLAG: apollo_1 | CHADO_HOST_FLAG: apollo_1 | Waiting for DB apollo_1 | /var/run/postgresql:5432 - accepting connections apollo_1 | Postgres is up, configuring database apollo_1 | psql: FATAL: Peer authentication failed for user "apollo-lqt" apollo_1 | Apollo database not found, creating... apollo_1 | CREATE ROLE apollo_1 | GRANT apollo_1 | Configuring Chado apollo_1 | psql: FATAL: Peer authentication failed for user "apollo" apollo_1 | Chado database not found, creating... apollo_1 | ERROR: role "apollo" already exists apollo_1 | GRANT apollo_1 | Loading Chado

...

apollo_1 | CREATE EXTENSION apollo_1 | psql:/chado.sql:49: ERROR: must be owner of extension plpgsql apollo_1 | SET

...

apollo_1 | ALTER TABLE apollo_1 | SET apollo_1 | psql:/chado.sql:2637928: ERROR: function create_point(integer, bigint) does not exist apollo_1 | LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000)) apollo_1 | ^ apollo_1 | HINT: No function matches the given name and argument types. You might need to add explicit type casts. apollo_1 | QUERY: SELECT box (create_point(0, $1), create_point($2,500000000)) apollo_1 | CONTEXT: SQL function "boxrange" during inlining apollo_1 | CREATE INDEX

...

apollo_1 | Loaded Chado apollo_1 | Restarting tomcat with /usr/local/tomcat/ apollo_1 | Jul 04, 2018 10:25:47 AM org.apache.catalina.startup.Catalina stopServer apollo_1 | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running. apollo_1 | Jul 04, 2018 10:25:47 AM org.apache.catalina.startup.Catalina stopServer apollo_1 | SEVERE: Catalina.stop: apollo_1 | java.net.ConnectException: Connection refused (Connection refused) apollo_1 | at java.net.PlainSocketImpl.socketConnect(Native Method) apollo_1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) apollo_1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) apollo_1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) apollo_1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) apollo_1 | at java.net.Socket.connect(Socket.java:589) apollo_1 | at java.net.Socket.connect(Socket.java:538) apollo_1 | at java.net.Socket.(Socket.java:434) apollo_1 | at java.net.Socket.(Socket.java:211) apollo_1 | at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497) apollo_1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) apollo_1 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) apollo_1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) apollo_1 | at java.lang.reflect.Method.invoke(Method.java:498) apollo_1 | at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406) apollo_1 | at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495) apollo_1 | apollo_1 | Tomcat started.

...

apollo_1 | Shiro Configured apollo_1 | 2018-07-04 10:26:36,175 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: alter table allele add constraint FK_ssx0gv6xbtu3tbwt6ekkmn4iw foreign key (variant_id) references feature apollo_1 | 2018-07-04 10:26:36,179 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate - ERROR: constraint "fk_ssx0gv6xbtu3tbwt6ekkmn4iw" for relation "allele" already exists apollo_1 | 2018-07-04 10:26:43,169 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: alter table chadoprop add column cvterm_id int8 not null apollo_1 | 2018-07-04 10:26:43,169 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate - ERROR: column "cvterm_id" contains null values apollo_1 | 2018-07-04 10:26:49,561 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate - HHH000388: Unsuccessful: alter table chadoprop add constraint FK_8twb5n8vjmldyy3eeyq7sppc3 foreign key (cvterm_id) references cvterm apollo_1 | 2018-07-04 10:26:49,561 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate - ERROR: column "cvterm_id" referenced in foreign key constraint does not exist apollo_1 | Starting Quartz Scheduler in QuartzFactoryBean apollo_1

...

apollo_1 | 2018-07-04 10:27:47,437 [http-nio-8080-exec-6] WARN apollo.PreferenceService - No user present, so using the client token apollo_1 | 2018-07-04 10:27:47,486 [http-nio-8080-exec-3] ERROR apollo.PermissionService - Username not supplied so can not authenticate. apollo_1 | 2018-07-04 10:27:47,495 [http-nio-8080-exec-3] ERROR apollo.PermissionService - User null does not exist in the database. apollo_1 | 2018-07-04 10:27:47,549 [http-nio-8080-exec-10] ERROR authenticator.UsernamePasswordAuthenticatorService - Problem authenticating: java.lang.IllegalArgumentException: Method argumet (authentication token) cannot be null. apollo_1 | 2018-07-04 10:27:47,550 [http-nio-8080-exec-10] WARN apollo.PermissionService - Failed to authenticate user apollo_1 | 2018-07-04 10:27:47,550 [http-nio-8080-exec-10] ERROR apollo.UserController - Failed to authenticate What did I miss?

Thank you in advance.

Michal

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/GMOD/docker-apollo/issues/27, or mute the thread https://github.com/notifications/unsubscribe-auth/AAt2qjrW3vZPHelAnyyVW_VXBJHTHy6jks5uDBT_gaJpZM4VB0S7.

mictadlo commented 6 years ago

Hi, What do you mean by any advanced features of Apollo?

We try to set up a portal which contains blast server (sequenceserver), our own webpage, Apollo for annotation and jbrowse for displaying the data. Furthermore, we thinking to include more web tools.

Our current docker-compose.yml is:

phpapache:
    build: php-apache
    restart: always
    ports:
        - "8080:80"
    links:
        - db
    volumes:
        - ./html/:/var/www/html

db:
  image: mariadb
  restart: always
  environment:
    - MYSQL_ROOT_PASSWORD=xxxx
    - MYSQL_DATABASE=ben
    - MYSQL_USER=ben
    - MYSQL_PASSWORD=xxxx
  ports:
    - "3306:3306" 
  volumes:
    - ./mysql/:/docker-entrypoint-initdb.d 

phpmyadmin:
  image: phpmyadmin/phpmyadmin
  restart: always
  links:
    - db
  ports:
    - 8183:80
  environment:
    PMA_USER: root
    PMA_PASSWORD: xxx
    PMA_ARBITRARY: 1

sequenceserver:
  build: sequenceserver
  restart: always
  ports:
    - "4567:4567"
  volumes:
    - ./data/sequenceserver:/dbs

apollo:
  image: quay.io/gmod/docker-apollo:latest 
  restart: always
  ports:
    - "8888:8080"
  volumes:
    - ./data//jbrowse:/data 
    - ./data/postgres-data:/var/lib/postgresql

I assume apollo-only would work, too. Do you have any recommendations on how to set it up?

Thank you in advance,

Michal

nathandunn commented 6 years ago

By "advanced-features" I think I meant Chado export, but that's not really an advanced feature. Sorry for the red herring.

For doing what you are doing, I what look more closely at https://github.com/galaxy-genome-annotation/docker-galaxy-genome-annotation and use the apollo-only target with modifications (you should fork this project). If you look closely at the dockererized version of gmod/apollo:latest you can see it does a lot of configuraiton of database, etc. You can also configure Apollo to use BLAST (though may not be what you want) and you Apollo to show BLAST results in addition to JBrowse (they can both use the same directory).

mictadlo commented 6 years ago

I changed it to ENV WEBAPOLLO_VERSION 6189ff9e2973e1523ddcdbeee9d258c435c42a54 but I still got:

apollo_1          | Restarting tomcat with /usr/local/tomcat/
apollo_1          | Jul 08, 2018 8:51:22 PM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
apollo_1          | Jul 08, 2018 8:51:22 PM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Catalina.stop: 
apollo_1          | java.net.ConnectException: Connection refused (Connection refused)
apollo_1          |     at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          |     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          |     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          |     at java.net.Socket.connect(Socket.java:589)
apollo_1          |     at java.net.Socket.connect(Socket.java:538)
apollo_1          |     at java.net.Socket.<init>(Socket.java:434)
apollo_1          |     at java.net.Socket.<init>(Socket.java:211)
apollo_1          |     at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
apollo_1          |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1          |     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1          |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1          |     at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1          |     at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
apollo_1          |     at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)
apollo_1          | 
apollo_1          | Tomcat started.

What did I miss?

The docker-galaxy-genome-annotation looks nice.

Thank you in advance.

Michal

nathandunn commented 6 years ago

I updated the apollo-only target. If you can provide me with a repo to debug that would be great.

So, you should (in a few minutes from this post), be able to use:

apollo:
  image: quay.io/gmod/docker-apollo:apollo-only 
  restart: always
  ports:
    - "8888:8080"
  volumes:
    - ./data//jbrowse:/data 
    - ./data/postgres-data:/var/lib/postgresql

However, I would also explore, though they may be less up-to-date (though possibly sufficient for what you need):

If you're interested in joining that group, it might be a great forum to ask questions, as well.

mictadlo commented 6 years ago

I used this one.

nathandunn commented 6 years ago

@mictadlo That should be fine, but where did you use it? Where is it pulling the build from?

mictadlo commented 6 years ago

I clone it and modified locally.

nathandunn commented 6 years ago

I see. So, that is a different then the docker-compose file above?

If you could provide me with that either off-line or here, that would be ideal so that we are on the same page for building.

The difference is that the apollo-only branch builds only apollo whereas the master branch builds that plus postgresql, etc. Though, that being said, maybe you want the master branch anyway looking at your compose script. Either way, its hard for me to test without having your system.

However, if you are able to get on your running system and provide logs for both tomcat and postgresql, that would be helpful.

mictadlo commented 6 years ago

I think this looks the best because it has all built in.

However, I do not understand why it is required to have two of the same images:

jbrowse:
  image: erasche/jbrowse:1.12.0
  volumes_from:
      - "galaxy:ro"

jbrowse-graphql:
  image: erasche/jbrowse:1.12.0
  volumes:
      - "./jbgraphql:/data"

apollo-only casused the following problems some of them are related that I did not have postgresql in my docker-compose file:

Digest: sha256:c0c55e5c2dcff1f2b9c1ef33819af3eda274087d02f0a4843f4f576384a061ac
Status: Downloaded newer image for quay.io/gmod/docker-apollo:apollo-only
benthgenome_sequenceserver_1 is up-to-date
Recreating benthgenome_apollo_1
benthgenome_db_1 is up-to-date
benthgenome_phpmyadmin_1 is up-to-date
benthgenome_phpapache_1 is up-to-date
Attaching to benthgenome_sequenceserver_1, benthgenome_db_1, benthgenome_phpmyadmin_1, benthgenome_phpapache_1, benthgenome_apollo_1
apollo_1          | Stopping tomcat with /usr/local/tomcat/
apollo_1          | Jul 11, 2018 2:00:50 PM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
apollo_1          | Jul 11, 2018 2:00:50 PM org.apache.catalina.startup.Catalina stopServer
apollo_1          | SEVERE: Catalina.stop: 
apollo_1          | java.net.ConnectException: Connection refused (Connection refused)
apollo_1          |     at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          |     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          |     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          |     at java.net.Socket.connect(Socket.java:589)
apollo_1          |     at java.net.Socket.connect(Socket.java:538)
apollo_1          |     at java.net.Socket.<init>(Socket.java:434)
apollo_1          |     at java.net.Socket.<init>(Socket.java:211)
apollo_1          |     at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
apollo_1          |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1          |     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1          |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1          |     at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1          |     at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
apollo_1          |     at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)
apollo_1          | 
apollo_1          | Starting tomcat with /usr/local/tomcat/
...
apollo_1          | 11-Jul-2018 14:00:51.764 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.32
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jun 20 2018 19:50:35 UTC
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.32.0
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            3.10.0-862.3.2.el7.x86_64
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/lib/jvm/java-8-openjdk-amd64/jre
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_171-8u171-b11-1~deb9u1-b11
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
apollo_1          | 11-Jul-2018 14:00:51.766 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /usr/local/tomcat
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /usr/local/tomcat
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat//conf/logging.properties
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
apollo_1          | 11-Jul-2018 14:00:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat/
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat/
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat//temp
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.17] using APR version [1.5.2].
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
apollo_1          | 11-Jul-2018 14:00:51.768 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
apollo_1          | 11-Jul-2018 14:00:51.772 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.0f  25 May 2017]
apollo_1          | 11-Jul-2018 14:00:51.907 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
apollo_1          | 11-Jul-2018 14:00:51.927 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
apollo_1          | 11-Jul-2018 14:00:51.934 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
apollo_1          | 11-Jul-2018 14:00:51.936 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
apollo_1          | 11-Jul-2018 14:00:51.936 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1069 ms
apollo_1          | 11-Jul-2018 14:00:51.977 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
apollo_1          | 11-Jul-2018 14:00:51.978 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.32
apollo_1          | 11-Jul-2018 14:00:52.042 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/usr/local/tomcat/webapps/ROOT.war]
apollo_1          | 11-Jul-2018 14:01:06.004 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
apollo_1          | log4j:WARN No appenders could be found for logger (org.codehaus.groovy.grails.commons.cfg.ConfigurationHelper).
apollo_1          | log4j:WARN Please initialize the log4j system properly.
apollo_1          | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
apollo_1          | 
apollo_1          | Configuring Shiro ...
apollo_1          | 
apollo_1          | Shiro Configured
apollo_1          | 11-Jul-2018 14:01:17.396 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1          |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1          |     at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1          |     at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1          |     at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1          |     at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1          |     at org.postgresql.Driver.connect(Driver.java:272)
apollo_1          |     at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1          |     at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1          |     at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1          |     at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1          |     at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1          |     at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162)
apollo_1          |     at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.<init>(LazyConnectionDataSourceProxy.java:106)
apollo_1          |     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
apollo_1          |     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
apollo_1          |     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
apollo_1          |     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
apollo_1          |     at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147)
apollo_1          |     at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:267)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          |     at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1          |     at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          |     at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1          |     at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1          |     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1          |     at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1          |     at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1          |     at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1          |     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1          |     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1          |     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1          |     at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1          |     at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1          |     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1          |     at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1          |     at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1          |     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          |     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          |     at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1          |     at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          |     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          |     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          |     at java.net.Socket.connect(Socket.java:589)
apollo_1          |     at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1          |     at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1          |     ... 109 more
apollo_1          | 
apollo_1          | 11-Jul-2018 14:01:17.403 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1          |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1          |     at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1          |     at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1          |     at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1          |     at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1          |     at org.postgresql.Driver.connect(Driver.java:272)
apollo_1          |     at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1          |     at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1          |     at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1          |     at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1          |     at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1          |     at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          |     at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1          |     at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          |     at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1          |     at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1          |     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1          |     at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1          |     at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1          |     at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1          |     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1          |     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1          |     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1          |     at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1          |     at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1          |     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1          |     at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1          |     at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1          |     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          |     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          |     at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1          |     at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          |     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          |     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          |     at java.net.Socket.connect(Socket.java:589)
apollo_1          |     at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1          |     at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1          |     ... 101 more
apollo_1          | 
apollo_1          | 11-Jul-2018 14:01:17.901 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1          |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1          |     at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1          |     at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1          |     at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1          |     at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1          |     at org.postgresql.Driver.connect(Driver.java:272)
apollo_1          |     at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1          |     at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1          |     at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1          |     at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1          |     at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1          |     at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1          |     at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.java:403)
apollo_1          |     at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
apollo_1          |     at com.sun.proxy.$Proxy44.getMetaData(Unknown Source)
apollo_1          |     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1          |     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1          |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1          |     at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1          |     at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:240)
apollo_1          |     at com.sun.proxy.$Proxy44.getMetaData(Unknown Source)
apollo_1          |     at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:126)
apollo_1          |     at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
apollo_1          |     at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
apollo_1          |     at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
apollo_1          |     at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)
apollo_1          |     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)
apollo_1          |     at org.codehaus.groovy.grails.orm.hibernate.cfg.GrailsAnnotationConfiguration.buildSessionFactory(GrailsAnnotationConfiguration.java:372)
apollo_1          |     at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.doBuildSessionFactory(ConfigurableLocalSessionFactoryBean.java:479)
apollo_1          |     at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.buildSessionFactory(ConfigurableLocalSessionFactoryBean.java:473)
apollo_1          |     at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.afterPropertiesSet(ConfigurableLocalSessionFactoryBean.java:387)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1          |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1          |     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          |     at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1          |     at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1          |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1          |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1          |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1          |     at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1          |     at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1          |     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1          |     at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1          |     at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1          |     at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1          |     at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1          |     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1          |     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1          |     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1          |     at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1          |     at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1          |     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1          |     at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1          |     at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1          |     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          |     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          |     at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1          |     at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1          |     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1          |     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1          |     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1          |     at java.net.Socket.connect(Socket.java:589)
apollo_1          |     at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1          |     at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1          |     ... 97 more
apollo_1          | 
apollo_1          | 2018-07-11 14:01:17,927 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener  - Error initializing the application: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          |     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          |     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          |     at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          |     ... 5 more
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          |     ... 5 more
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          |     ... 5 more
apollo_1          | Caused by: java.lang.NullPointerException
apollo_1          |     ... 5 more
apollo_1          | 2018-07-11 14:01:17,929 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener  - Error initializing Grails: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          |     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1          |     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1          |     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1          |     at java.lang.Thread.run(Thread.java:748)
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          |     ... 5 more
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          |     ... 5 more
apollo_1          | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1          |     ... 5 more
apollo_1          | Caused by: java.lang.NullPointerException
apollo_1          |     ... 5 more
apollo_1          | 11-Jul-2018 14:01:17.930 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
apollo_1          | 11-Jul-2018 14:01:17.949 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [] startup failed due to previous errors
apollo_1          | 11-Jul-2018 14:01:17.969 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ROOT] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
apollo_1          | 11-Jul-2018 14:01:17.994 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/ROOT.war] has finished in [25,951] ms
apollo_1          | 11-Jul-2018 14:01:17.996 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
apollo_1          | 11-Jul-2018 14:01:18.010 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
apollo_1          | 11-Jul-2018 14:01:18.015 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 26078 ms

What did I miss?

Thank you in advance.

Michal

nathandunn commented 6 years ago

The error is because its trying to connect to a postgresql server and its either not there, or the connection credentials are misconfigured. These are typically passed is as variables in the example you gave.

My advice would be to fork their project and get it running and then add your pieces. I think it would be easier to have both postgresql and mysql running, at least for now, so you don't have to reconfigure it. If you have trouble, those guys are docker / configuration experts and very willing to help.

mictadlo commented 6 years ago

Thank you for your help. I did what you suggested https://github.com/galaxy-genome-annotation/dockerized-gmod-deployment/issues/8

mictadlo commented 6 years ago

Hi Nathan, I decided that I only need apollo and postgresql without chado. This is the new docker-compose.yml file:

apollo:
  image: quay.io/gmod/docker-apollo:apollo-only
  restart: always
  links:
    - apollo_db
  ports:
    - "8888:8080"
  environment:
    - WEBAPOLLO_DB_USERNAME=postgres
    - WEBAPOLLO_DB_PASSWORD=password
    - WEBAPOLLO_DB_DRIVER="org.postgresql.Driver"
    - WEBAPOLLO_DB_DIALECT="org.hibernate.dialect.PostgresPlusDialect"
    - WEBAPOLLO_DB_URI="jdbc:postgresql://db/postgres"
  volumes:
    - ./data/jbrowse:/data
    - ./data/postgres-data:/var/lib/postgresql

apollo_db:
  image: postgres:latest
  environment:
    - POSTGRES_PASSWORD=postgres

However, I have got the following Errors and Exceptions:

Attaching to docker-apollo-only_apollo_db_1, docker-apollo-only_apollo_1
apollo_db_1  | The files belonging to this database system will be owned by user "postgres".
apollo_db_1  | This user must also own the server process.
apollo_db_1  | 
apollo_db_1  | The database cluster will be initialized with locale "en_US.utf8".
apollo_db_1  | The default database encoding has accordingly been set to "UTF8".
apollo_db_1  | The default text search configuration will be set to "english".
apollo_db_1  | 
apollo_db_1  | Data page checksums are disabled.
apollo_db_1  | 
apollo_db_1  | fixing permissions on existing directory /var/lib/postgresql/data ... ok
apollo_db_1  | creating subdirectories ... ok
apollo_db_1  | selecting default max_connections ... 100
apollo_db_1  | selecting default shared_buffers ... 128MB
apollo_db_1  | selecting dynamic shared memory implementation ... posix
apollo_1     | Stopping tomcat with /usr/local/tomcat/
apollo_db_1  | creating configuration files ... ok
apollo_db_1  | running bootstrap script ... ok
apollo_1     | Jul 25, 2018 9:29:29 PM org.apache.catalina.startup.Catalina stopServer
apollo_1     | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
apollo_1     | Jul 25, 2018 9:29:29 PM org.apache.catalina.startup.Catalina stopServer
apollo_1     | SEVERE: Catalina.stop: 
apollo_1     | java.net.ConnectException: Connection refused (Connection refused)
apollo_1     |  at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1     |  at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1     |  at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1     |  at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1     |  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1     |  at java.net.Socket.connect(Socket.java:589)
apollo_1     |  at java.net.Socket.connect(Socket.java:538)
apollo_1     |  at java.net.Socket.<init>(Socket.java:434)
apollo_1     |  at java.net.Socket.<init>(Socket.java:211)
apollo_1     |  at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
apollo_1     |  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1     |  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1     |  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1     |  at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1     |  at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
apollo_1     |  at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)
apollo_1     | 
apollo_1     | Starting tomcat with /usr/local/tomcat/
apollo_1     | Tomcat started.
apollo_db_1  | performing post-bootstrap initialization ... ok
apollo_db_1  | syncing data to disk ... ok
apollo_db_1  | 
apollo_db_1  | WARNING: enabling "trust" authentication for local connections
apollo_db_1  | You can change this by editing pg_hba.conf or using the option -A, or
apollo_db_1  | --auth-local and --auth-host, the next time you run initdb.
apollo_db_1  | 
apollo_db_1  | Success. You can now start the database server using:
apollo_db_1  | 
apollo_db_1  |     pg_ctl -D /var/lib/postgresql/data -l logfile start
apollo_db_1  | 
apollo_db_1  | waiting for server to start....2018-07-25 21:29:31.478 UTC [38] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
apollo_db_1  | 2018-07-25 21:29:31.574 UTC [39] LOG:  database system was shut down at 2018-07-25 21:29:30 UTC
apollo_db_1  | 2018-07-25 21:29:31.647 UTC [38] LOG:  database system is ready to accept connections
apollo_db_1  |  done
apollo_db_1  | server started
apollo_db_1  | ALTER ROLE
apollo_db_1  | 
apollo_db_1  | 
apollo_db_1  | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
apollo_db_1  | 
apollo_db_1  | waiting for server to shut down....2018-07-25 21:29:32.400 UTC [38] LOG:  received fast shutdown request
apollo_db_1  | 2018-07-25 21:29:32.409 UTC [38] LOG:  aborting any active transactions
apollo_db_1  | 2018-07-25 21:29:32.418 UTC [38] LOG:  worker process: logical replication launcher (PID 45) exited with exit code 1
apollo_db_1  | 2018-07-25 21:29:32.420 UTC [40] LOG:  shutting down
apollo_db_1  | 2018-07-25 21:29:32.535 UTC [38] LOG:  database system is shut down
apollo_db_1  |  done
apollo_db_1  | server stopped
apollo_db_1  | 
apollo_db_1  | PostgreSQL init process complete; ready for start up.
apollo_db_1  | 
apollo_db_1  | 2018-07-25 21:29:32.653 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
apollo_db_1  | 2018-07-25 21:29:32.653 UTC [1] LOG:  listening on IPv6 address "::", port 5432
apollo_db_1  | 2018-07-25 21:29:32.690 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
apollo_db_1  | 2018-07-25 21:29:32.757 UTC [56] LOG:  database system was shut down at 2018-07-25 21:29:32 UTC
apollo_db_1  | 2018-07-25 21:29:32.784 UTC [1] LOG:  database system is ready to accept connections
apollo_1     | 25-Jul-2018 21:29:33.501 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.32
apollo_1     | 25-Jul-2018 21:29:33.505 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jun 20 2018 19:50:35 UTC
apollo_1     | 25-Jul-2018 21:29:33.505 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.32.0
apollo_1     | 25-Jul-2018 21:29:33.505 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
apollo_1     | 25-Jul-2018 21:29:33.506 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            4.9.87-linuxkit-aufs
apollo_1     | 25-Jul-2018 21:29:33.507 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
apollo_1     | 25-Jul-2018 21:29:33.507 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/lib/jvm/java-8-openjdk-amd64/jre
apollo_1     | 25-Jul-2018 21:29:33.508 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_171-8u171-b11-1~deb9u1-b11
apollo_1     | 25-Jul-2018 21:29:33.508 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
apollo_1     | 25-Jul-2018 21:29:33.509 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /usr/local/tomcat
apollo_1     | 25-Jul-2018 21:29:33.509 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /usr/local/tomcat
apollo_1     | 25-Jul-2018 21:29:33.510 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat//conf/logging.properties
apollo_1     | 25-Jul-2018 21:29:33.511 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
apollo_1     | 25-Jul-2018 21:29:33.511 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
apollo_1     | 25-Jul-2018 21:29:33.512 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
apollo_1     | 25-Jul-2018 21:29:33.512 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
apollo_1     | 25-Jul-2018 21:29:33.513 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
apollo_1     | 25-Jul-2018 21:29:33.513 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat/
apollo_1     | 25-Jul-2018 21:29:33.514 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat/
apollo_1     | 25-Jul-2018 21:29:33.515 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat//temp
apollo_1     | 25-Jul-2018 21:29:33.515 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.17] using APR version [1.5.2].
apollo_1     | 25-Jul-2018 21:29:33.516 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
apollo_1     | 25-Jul-2018 21:29:33.516 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
apollo_1     | 25-Jul-2018 21:29:33.561 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.0f  25 May 2017]
apollo_1     | 25-Jul-2018 21:29:34.115 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
apollo_1     | 25-Jul-2018 21:29:34.243 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
apollo_1     | 25-Jul-2018 21:29:34.281 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
apollo_1     | 25-Jul-2018 21:29:34.283 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
apollo_1     | 25-Jul-2018 21:29:34.286 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 3085 ms
apollo_1     | 25-Jul-2018 21:29:34.440 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
apollo_1     | 25-Jul-2018 21:29:34.440 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.32
apollo_1     | 25-Jul-2018 21:29:34.566 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/usr/local/tomcat/webapps/ROOT.war]
apollo_1     | 25-Jul-2018 21:30:02.932 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
apollo_1     | log4j:WARN No appenders could be found for logger (org.codehaus.groovy.grails.commons.cfg.ConfigurationHelper).
apollo_1     | log4j:WARN Please initialize the log4j system properly.
apollo_1     | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
apollo_1     | 
apollo_1     | Configuring Shiro ...
apollo_1     | 
apollo_1     | Shiro Configured
apollo_1     | 25-Jul-2018 21:30:46.187 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1     |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1     |  at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1     |  at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1     |  at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1     |  at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1     |  at org.postgresql.Driver.connect(Driver.java:272)
apollo_1     |  at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1     |  at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1     |  at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1     |  at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1     |  at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1     |  at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162)
apollo_1     |  at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.<init>(LazyConnectionDataSourceProxy.java:106)
apollo_1     |  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
apollo_1     |  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
apollo_1     |  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
apollo_1     |  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
apollo_1     |  at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147)
apollo_1     |  at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:267)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     |  at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1     |  at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     |  at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1     |  at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1     |  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1     |  at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1     |  at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1     |  at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1     |  at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1     |  at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1     |  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1     |  at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1     |  at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1     |  at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1     |  at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1     |  at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1     |  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     |  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     |  at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1     |  at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1     |  at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1     |  at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1     |  at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1     |  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1     |  at java.net.Socket.connect(Socket.java:589)
apollo_1     |  at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1     |  at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1     |  ... 109 more
apollo_1     | 
apollo_1     | 25-Jul-2018 21:30:46.223 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1     |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1     |  at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1     |  at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1     |  at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1     |  at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1     |  at org.postgresql.Driver.connect(Driver.java:272)
apollo_1     |  at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1     |  at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1     |  at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1     |  at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1     |  at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1     |  at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     |  at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1     |  at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     |  at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1     |  at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1     |  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1     |  at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1     |  at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1     |  at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1     |  at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1     |  at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1     |  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1     |  at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1     |  at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1     |  at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1     |  at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1     |  at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1     |  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     |  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     |  at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1     |  at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1     |  at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1     |  at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1     |  at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1     |  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1     |  at java.net.Socket.connect(Socket.java:589)
apollo_1     |  at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1     |  at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1     |  ... 101 more
apollo_1     | 
apollo_1     | 25-Jul-2018 21:30:47.890 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
apollo_1     |  org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
apollo_1     |  at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262)
apollo_1     |  at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52)
apollo_1     |  at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)
apollo_1     |  at org.postgresql.Driver.makeConnection(Driver.java:404)
apollo_1     |  at org.postgresql.Driver.connect(Driver.java:272)
apollo_1     |  at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
apollo_1     |  at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
apollo_1     |  at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:145)
apollo_1     |  at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
apollo_1     |  at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
apollo_1     |  at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
apollo_1     |  at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.java:403)
apollo_1     |  at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
apollo_1     |  at com.sun.proxy.$Proxy44.getMetaData(Unknown Source)
apollo_1     |  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apollo_1     |  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apollo_1     |  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apollo_1     |  at java.lang.reflect.Method.invoke(Method.java:498)
apollo_1     |  at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:240)
apollo_1     |  at com.sun.proxy.$Proxy44.getMetaData(Unknown Source)
apollo_1     |  at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:126)
apollo_1     |  at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
apollo_1     |  at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
apollo_1     |  at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
apollo_1     |  at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)
apollo_1     |  at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)
apollo_1     |  at org.codehaus.groovy.grails.orm.hibernate.cfg.GrailsAnnotationConfiguration.buildSessionFactory(GrailsAnnotationConfiguration.java:372)
apollo_1     |  at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.doBuildSessionFactory(ConfigurableLocalSessionFactoryBean.java:479)
apollo_1     |  at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.buildSessionFactory(ConfigurableLocalSessionFactoryBean.java:473)
apollo_1     |  at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.afterPropertiesSet(ConfigurableLocalSessionFactoryBean.java:387)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382)
apollo_1     |  at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)
apollo_1     |  at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     |  at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
apollo_1     |  at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
apollo_1     |  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
apollo_1     |  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
apollo_1     |  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
apollo_1     |  at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199)
apollo_1     |  at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616)
apollo_1     |  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168)
apollo_1     |  at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
apollo_1     |  at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126)
apollo_1     |  at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109)
apollo_1     |  at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
apollo_1     |  at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
apollo_1     |  at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
apollo_1     |  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
apollo_1     |  at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
apollo_1     |  at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
apollo_1     |  at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
apollo_1     |  at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
apollo_1     |  at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
apollo_1     |  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     |  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     |  at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: java.net.ConnectException: Connection refused (Connection refused)
apollo_1     |  at java.net.PlainSocketImpl.socketConnect(Native Method)
apollo_1     |  at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
apollo_1     |  at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
apollo_1     |  at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
apollo_1     |  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
apollo_1     |  at java.net.Socket.connect(Socket.java:589)
apollo_1     |  at org.postgresql.core.PGStream.<init>(PGStream.java:61)
apollo_1     |  at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
apollo_1     |  ... 97 more
apollo_1     | 
apollo_1     | 2018-07-25 21:30:47,946 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener  - Error initializing the application: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     |  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     |  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     |  at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     |  ... 5 more
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     |  ... 5 more
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     |  ... 5 more
apollo_1     | Caused by: java.lang.NullPointerException
apollo_1     |  ... 5 more
apollo_1     | 2018-07-25 21:30:47,950 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener  - Error initializing Grails: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     |  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
apollo_1     |  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
apollo_1     |  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
apollo_1     |  at java.lang.Thread.run(Thread.java:748)
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     |  ... 5 more
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     |  ... 5 more
apollo_1     | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException
apollo_1     |  ... 5 more
apollo_1     | Caused by: java.lang.NullPointerException
apollo_1     |  ... 5 more
apollo_1     | 25-Jul-2018 21:30:47.965 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
apollo_1     | 25-Jul-2018 21:30:48.040 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [] startup failed due to previous errors
apollo_1     | 25-Jul-2018 21:30:48.155 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ROOT] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
apollo_1     | 25-Jul-2018 21:30:48.226 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/ROOT.war] has finished in [73,658] ms
apollo_1     | 25-Jul-2018 21:30:48.238 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
apollo_1     | 25-Jul-2018 21:30:48.349 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
apollo_1     | 25-Jul-2018 21:30:48.354 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 74067 ms

What did I miss?

Thank you in advance.

Michal

nathandunn commented 6 years ago

Is there any reason to use docker-compose instead of just the original docker image?

Shouldn’t matter if chado loads or not.

Nathan

On Jul 25, 2018, at 2:45 PM, Michał T. Lorenc notifications@github.com wrote:

Hi Nathan, I decided that I only need apollo and postgresql without chado. This is the new docker-compose.yml file:

apollo: image: quay.io/gmod/docker-apollo:apollo-only restart: always links:

  • apollo_db ports:
  • "8888:8080" environment:
  • WEBAPOLLO_DB_USERNAME=postgres
  • WEBAPOLLO_DB_PASSWORD=password
  • WEBAPOLLO_DB_DRIVER="org.postgresql.Driver"
  • WEBAPOLLO_DB_DIALECT="org.hibernate.dialect.PostgresPlusDialect"
  • WEBAPOLLO_DB_URI="jdbc:postgresql://db/postgres" volumes:
  • ./data/jbrowse:/data
  • ./data/postgres-data:/var/lib/postgresql

apollo_db: image: postgres:latest environment:

  • POSTGRES_PASSWORD=postgres However, I have got the following Errors and Exceptions:

Attaching to docker-apollo-only_apollo_db_1, docker-apollo-only_apollo_1 apollo_db_1 | The files belonging to this database system will be owned by user "postgres". apollo_db_1 | This user must also own the server process. apollo_db_1 | apollo_db_1 | The database cluster will be initialized with locale "en_US.utf8". apollo_db_1 | The default database encoding has accordingly been set to "UTF8". apollo_db_1 | The default text search configuration will be set to "english". apollo_db_1 | apollo_db_1 | Data page checksums are disabled. apollo_db_1 | apollo_db_1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok apollo_db_1 | creating subdirectories ... ok apollo_db_1 | selecting default max_connections ... 100 apollo_db_1 | selecting default shared_buffers ... 128MB apollo_db_1 | selecting dynamic shared memory implementation ... posix apollo_1 | Stopping tomcat with /usr/local/tomcat/ apollo_db_1 | creating configuration files ... ok apollo_db_1 | running bootstrap script ... ok apollo_1 | Jul 25, 2018 9:29:29 PM org.apache.catalina.startup.Catalina stopServer apollo_1 | SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running. apollo_1 | Jul 25, 2018 9:29:29 PM org.apache.catalina.startup.Catalina stopServer apollo_1 | SEVERE: Catalina.stop: apollo_1 | java.net.ConnectException: Connection refused (Connection refused) apollo_1 | at java.net.PlainSocketImpl.socketConnect(Native Method) apollo_1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) apollo_1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) apollo_1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) apollo_1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) apollo_1 | at java.net.Socket.connect(Socket.java:589) apollo_1 | at java.net.Socket.connect(Socket.java:538) apollo_1 | at java.net.Socket.(Socket.java:434) apollo_1 | at java.net.Socket.(Socket.java:211) apollo_1 | at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497) apollo_1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) apollo_1 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) apollo_1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) apollo_1 | at java.lang.reflect.Method.invoke(Method.java:498) apollo_1 | at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406) apollo_1 | at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495) apollo_1 | apollo_1 | Starting tomcat with /usr/local/tomcat/ apollo_1 | Tomcat started. apollo_db_1 | performing post-bootstrap initialization ... ok apollo_db_1 | syncing data to disk ... ok apollo_db_1 | apollo_db_1 | WARNING: enabling "trust" authentication for local connections apollo_db_1 | You can change this by editing pg_hba.conf or using the option -A, or apollo_db_1 | --auth-local and --auth-host, the next time you run initdb. apollo_db_1 | apollo_db_1 | Success. You can now start the database server using: apollo_db_1 | apollo_db_1 | pg_ctl -D /var/lib/postgresql/data -l logfile start apollo_db_1 | apollo_db_1 | waiting for server to start....2018-07-25 21:29:31.478 UTC [38] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" apollo_db_1 | 2018-07-25 21:29:31.574 UTC [39] LOG: database system was shut down at 2018-07-25 21:29:30 UTC apollo_db_1 | 2018-07-25 21:29:31.647 UTC [38] LOG: database system is ready to accept connections apollo_db_1 | done apollo_db_1 | server started apollo_db_1 | ALTER ROLE apollo_db_1 | apollo_db_1 | apollo_db_1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/* apollo_db_1 | apollo_db_1 | waiting for server to shut down....2018-07-25 21:29:32.400 UTC [38] LOG: received fast shutdown request apollo_db_1 | 2018-07-25 21:29:32.409 UTC [38] LOG: aborting any active transactions apollo_db_1 | 2018-07-25 21:29:32.418 UTC [38] LOG: worker process: logical replication launcher (PID 45) exited with exit code 1 apollo_db_1 | 2018-07-25 21:29:32.420 UTC [40] LOG: shutting down apollo_db_1 | 2018-07-25 21:29:32.535 UTC [38] LOG: database system is shut down apollo_db_1 | done apollo_db_1 | server stopped apollo_db_1 | apollo_db_1 | PostgreSQL init process complete; ready for start up. apollo_db_1 | apollo_db_1 | 2018-07-25 21:29:32.653 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 apollo_db_1 | 2018-07-25 21:29:32.653 UTC [1] LOG: listening on IPv6 address "::", port 5432 apollo_db_1 | 2018-07-25 21:29:32.690 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" apollo_db_1 | 2018-07-25 21:29:32.757 UTC [56] LOG: database system was shut down at 2018-07-25 21:29:32 UTC apollo_db_1 | 2018-07-25 21:29:32.784 UTC [1] LOG: database system is ready to accept connections apollo_1 | 25-Jul-2018 21:29:33.501 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.32 apollo_1 | 25-Jul-2018 21:29:33.505 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jun 20 2018 19:50:35 UTC apollo_1 | 25-Jul-2018 21:29:33.505 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.32.0 apollo_1 | 25-Jul-2018 21:29:33.505 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux apollo_1 | 25-Jul-2018 21:29:33.506 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 4.9.87-linuxkit-aufs apollo_1 | 25-Jul-2018 21:29:33.507 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64 apollo_1 | 25-Jul-2018 21:29:33.507 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/lib/jvm/java-8-openjdk-amd64/jre apollo_1 | 25-Jul-2018 21:29:33.508 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_171-8u171-b11-1~deb9u1-b11 apollo_1 | 25-Jul-2018 21:29:33.508 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation apollo_1 | 25-Jul-2018 21:29:33.509 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /usr/local/tomcat apollo_1 | 25-Jul-2018 21:29:33.509 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /usr/local/tomcat apollo_1 | 25-Jul-2018 21:29:33.510 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat//conf/logging.properties apollo_1 | 25-Jul-2018 21:29:33.511 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager apollo_1 | 25-Jul-2018 21:29:33.511 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 apollo_1 | 25-Jul-2018 21:29:33.512 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources apollo_1 | 25-Jul-2018 21:29:33.512 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 apollo_1 | 25-Jul-2018 21:29:33.513 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs= apollo_1 | 25-Jul-2018 21:29:33.513 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat/ apollo_1 | 25-Jul-2018 21:29:33.514 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat/ apollo_1 | 25-Jul-2018 21:29:33.515 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat//temp apollo_1 | 25-Jul-2018 21:29:33.515 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.17] using APR version [1.5.2]. apollo_1 | 25-Jul-2018 21:29:33.516 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true]. apollo_1 | 25-Jul-2018 21:29:33.516 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] apollo_1 | 25-Jul-2018 21:29:33.561 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.0f 25 May 2017] apollo_1 | 25-Jul-2018 21:29:34.115 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"] apollo_1 | 25-Jul-2018 21:29:34.243 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read apollo_1 | 25-Jul-2018 21:29:34.281 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"] apollo_1 | 25-Jul-2018 21:29:34.283 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read apollo_1 | 25-Jul-2018 21:29:34.286 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 3085 ms apollo_1 | 25-Jul-2018 21:29:34.440 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] apollo_1 | 25-Jul-2018 21:29:34.440 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.32 apollo_1 | 25-Jul-2018 21:29:34.566 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/usr/local/tomcat/webapps/ROOT.war] apollo_1 | 25-Jul-2018 21:30:02.932 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. apollo_1 | log4j:WARN No appenders could be found for logger (org.codehaus.groovy.grails.commons.cfg.ConfigurationHelper). apollo_1 | log4j:WARN Please initialize the log4j system properly. apollo_1 | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. apollo_1 | apollo_1 | Configuring Shiro ... apollo_1 | apollo_1 | Shiro Configured apollo_1 | 25-Jul-2018 21:30:46.187 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. apollo_1 | org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. apollo_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262) apollo_1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52) apollo_1 | at org.postgresql.jdbc.PgConnection.(PgConnection.java:216) apollo_1 | at org.postgresql.Driver.makeConnection(Driver.java:404) apollo_1 | at org.postgresql.Driver.connect(Driver.java:272) apollo_1 | at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278) apollo_1 | at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:145) apollo_1 | at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116) apollo_1 | at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103) apollo_1 | at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127) apollo_1 | at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162) apollo_1 | at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.(LazyConnectionDataSourceProxy.java:106) apollo_1 | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) apollo_1 | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) apollo_1 | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) apollo_1 | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) apollo_1 | at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147) apollo_1 | at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:267) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) apollo_1 | at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74) apollo_1 | at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) apollo_1 | at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199) apollo_1 | at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616) apollo_1 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465) apollo_1 | at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156) apollo_1 | at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188) apollo_1 | at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168) apollo_1 | at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127) apollo_1 | at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126) apollo_1 | at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109) apollo_1 | at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) apollo_1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) apollo_1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) apollo_1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) apollo_1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) apollo_1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) apollo_1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) apollo_1 | at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985) apollo_1 | at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) apollo_1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) apollo_1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266) apollo_1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) apollo_1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) apollo_1 | at java.lang.Thread.run(Thread.java:748) apollo_1 | Caused by: java.net.ConnectException: Connection refused (Connection refused) apollo_1 | at java.net.PlainSocketImpl.socketConnect(Native Method) apollo_1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) apollo_1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) apollo_1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) apollo_1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) apollo_1 | at java.net.Socket.connect(Socket.java:589) apollo_1 | at org.postgresql.core.PGStream.(PGStream.java:61) apollo_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144) apollo_1 | ... 109 more apollo_1 | apollo_1 | 25-Jul-2018 21:30:46.223 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. apollo_1 | org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. apollo_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262) apollo_1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52) apollo_1 | at org.postgresql.jdbc.PgConnection.(PgConnection.java:216) apollo_1 | at org.postgresql.Driver.makeConnection(Driver.java:404) apollo_1 | at org.postgresql.Driver.connect(Driver.java:272) apollo_1 | at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278) apollo_1 | at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:145) apollo_1 | at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116) apollo_1 | at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103) apollo_1 | at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127) apollo_1 | at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:648) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) apollo_1 | at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74) apollo_1 | at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) apollo_1 | at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199) apollo_1 | at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616) apollo_1 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465) apollo_1 | at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156) apollo_1 | at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188) apollo_1 | at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168) apollo_1 | at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127) apollo_1 | at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126) apollo_1 | at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109) apollo_1 | at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) apollo_1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) apollo_1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) apollo_1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) apollo_1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) apollo_1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) apollo_1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) apollo_1 | at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985) apollo_1 | at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) apollo_1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) apollo_1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266) apollo_1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) apollo_1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) apollo_1 | at java.lang.Thread.run(Thread.java:748) apollo_1 | Caused by: java.net.ConnectException: Connection refused (Connection refused) apollo_1 | at java.net.PlainSocketImpl.socketConnect(Native Method) apollo_1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) apollo_1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) apollo_1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) apollo_1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) apollo_1 | at java.net.Socket.connect(Socket.java:589) apollo_1 | at org.postgresql.core.PGStream.(PGStream.java:61) apollo_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144) apollo_1 | ... 101 more apollo_1 | apollo_1 | 25-Jul-2018 21:30:47.890 SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. apollo_1 | org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. apollo_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262) apollo_1 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:52) apollo_1 | at org.postgresql.jdbc.PgConnection.(PgConnection.java:216) apollo_1 | at org.postgresql.Driver.makeConnection(Driver.java:404) apollo_1 | at org.postgresql.Driver.connect(Driver.java:272) apollo_1 | at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278) apollo_1 | at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:712) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:646) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468) apollo_1 | at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:145) apollo_1 | at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116) apollo_1 | at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103) apollo_1 | at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127) apollo_1 | at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.java:403) apollo_1 | at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376) apollo_1 | at com.sun.proxy.$Proxy44.getMetaData(Unknown Source) apollo_1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) apollo_1 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) apollo_1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) apollo_1 | at java.lang.reflect.Method.invoke(Method.java:498) apollo_1 | at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:240) apollo_1 | at com.sun.proxy.$Proxy44.getMetaData(Unknown Source) apollo_1 | at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:126) apollo_1 | at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111) apollo_1 | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234) apollo_1 | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206) apollo_1 | at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887) apollo_1 | at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845) apollo_1 | at org.codehaus.groovy.grails.orm.hibernate.cfg.GrailsAnnotationConfiguration.buildSessionFactory(GrailsAnnotationConfiguration.java:372) apollo_1 | at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.doBuildSessionFactory(ConfigurableLocalSessionFactoryBean.java:479) apollo_1 | at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.buildSessionFactory(ConfigurableLocalSessionFactoryBean.java:473) apollo_1 | at org.codehaus.groovy.grails.orm.hibernate.ConfigurableLocalSessionFactoryBean.afterPropertiesSet(ConfigurableLocalSessionFactoryBean.java:387) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:382) apollo_1 | at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634) apollo_1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1137) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1040) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) apollo_1 | at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74) apollo_1 | at org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1591) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1559) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) apollo_1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) apollo_1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) apollo_1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) apollo_1 | at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:199) apollo_1 | at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:616) apollo_1 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:465) apollo_1 | at org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156) apollo_1 | at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.initializeContext(GrailsRuntimeConfigurator.java:188) apollo_1 | at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:168) apollo_1 | at org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127) apollo_1 | at org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:126) apollo_1 | at org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener.initWebApplicationContext(GrailsContextLoaderListener.java:109) apollo_1 | at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) apollo_1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) apollo_1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) apollo_1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) apollo_1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) apollo_1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) apollo_1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) apollo_1 | at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985) apollo_1 | at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) apollo_1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) apollo_1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266) apollo_1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) apollo_1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) apollo_1 | at java.lang.Thread.run(Thread.java:748) apollo_1 | Caused by: java.net.ConnectException: Connection refused (Connection refused) apollo_1 | at java.net.PlainSocketImpl.socketConnect(Native Method) apollo_1 | at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) apollo_1 | at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) apollo_1 | at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) apollo_1 | at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) apollo_1 | at java.net.Socket.connect(Socket.java:589) apollo_1 | at org.postgresql.core.PGStream.(PGStream.java:61) apollo_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144) apollo_1 | ... 97 more apollo_1 | apollo_1 | 2018-07-25 21:30:47,946 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener - Error initializing the application: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) apollo_1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266) apollo_1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) apollo_1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) apollo_1 | at java.lang.Thread.run(Thread.java:748) apollo_1 | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | ... 5 more apollo_1 | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | ... 5 more apollo_1 | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | ... 5 more apollo_1 | Caused by: java.lang.NullPointerException apollo_1 | ... 5 more apollo_1 | 2018-07-25 21:30:47,950 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener - Error initializing Grails: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) apollo_1 | at java.util.concurrent.FutureTask.run(FutureTask.java:266) apollo_1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) apollo_1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) apollo_1 | at java.lang.Thread.run(Thread.java:748) apollo_1 | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean '$primaryTransactionManager' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | ... 5 more apollo_1 | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '$primaryTransactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | ... 5 more apollo_1 | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Invocation of init method failed; nested exception is java.lang.NullPointerException apollo_1 | ... 5 more apollo_1 | Caused by: java.lang.NullPointerException apollo_1 | ... 5 more apollo_1 | 25-Jul-2018 21:30:47.965 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file apollo_1 | 25-Jul-2018 21:30:48.040 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [] startup failed due to previous errors apollo_1 | 25-Jul-2018 21:30:48.155 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ROOT] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. apollo_1 | 25-Jul-2018 21:30:48.226 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/ROOT.war] has finished in [73,658] ms apollo_1 | 25-Jul-2018 21:30:48.238 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"] apollo_1 | 25-Jul-2018 21:30:48.349 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"] apollo_1 | 25-Jul-2018 21:30:48.354 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 74067 ms

What did I miss?

Thank you in advance.

Michal

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/GMOD/docker-apollo/issues/27#issuecomment-407906689, or mute the thread https://github.com/notifications/unsubscribe-auth/AAt2qrqmQmRTY7Ssyq0sHURXz7F5rA9zks5uKObcgaJpZM4VB0S7.

mictadlo commented 6 years ago

Do you mean quay.io/gmod/docker-apollo rather quay.io/gmod/docker-apollo:apollo-only?

nathandunn commented 6 years ago

Yes. It has everything baked in, and I've tested it already.

mictadlo commented 6 years ago

I still got some errors and I just wonder whether this is correct.

docker run -it -v /Users/lorencm/projects/docker-apollo-only/data/jbrowse:/data -v /Users/lorencm/projects/docker-apollo-only/data/postgres-data:/var/lib/postgresql -p 8888:8080 quay.io/gmod/docker-apollo:latest
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/9.6/main ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

psql: FATAL:  Peer authentication failed for user "apollo-lqt"
Apollo database not found, creating...
CREATE ROLE
GRANT
Configuring Chado
psql: FATAL:  Peer authentication failed for user "apollo"
Chado database not found, creating...
ERROR:  role "apollo" already exists
GRANT
Loading Chado

psql:/chado.sql:49: ERROR:  must be owner of extension plpgsql

SET
psql:/chado.sql:2637928: ERROR:  function create_point(integer, bigint) does not exist
LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
              ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
CONTEXT:  SQL function "boxrange" during inlining

Loaded Chado
Restarting tomcat with /usr/local/tomcat/
Using CATALINA_BASE:   /usr/local/tomcat/
Using CATALINA_HOME:   /usr/local/tomcat/
Using CATALINA_TMPDIR: /usr/local/tomcat//temp
Using JRE_HOME:        /docker-java-home/jre
Using CLASSPATH:       /usr/local/tomcat//bin/bootstrap.jar:/usr/local/tomcat//bin/tomcat-juli.jar
Jul 26, 2018 12:02:15 AM org.apache.catalina.startup.Catalina stopServer
SEVERE: Could not contact [localhost:[8005]]. Tomcat may not be running.
Jul 26, 2018 12:02:15 AM org.apache.catalina.startup.Catalina stopServer
SEVERE: Catalina.stop: 
java.net.ConnectException: Connection refused (Connection refused)
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
    at java.net.Socket.connect(Socket.java:589)
    at java.net.Socket.connect(Socket.java:538)
    at java.net.Socket.<init>(Socket.java:434)
    at java.net.Socket.<init>(Socket.java:211)
    at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:497)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:406)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495)

Using CATALINA_BASE:   /usr/local/tomcat/
Using CATALINA_HOME:   /usr/local/tomcat/
Using CATALINA_TMPDIR: /usr/local/tomcat//temp
Using JRE_HOME:        /docker-java-home/jre
Using CLASSPATH:       /usr/local/tomcat//bin/bootstrap.jar:/usr/local/tomcat//bin/tomcat-juli.jar
Tomcat started.
26-Jul-2018 00:02:17.412 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.31
26-Jul-2018 00:02:17.414 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Apr 27 2018 20:24:25 UTC
26-Jul-2018 00:02:17.414 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.31.0
26-Jul-2018 00:02:17.414 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            4.9.87-linuxkit-aufs
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/lib/jvm/java-8-openjdk-amd64/jre
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_171-8u171-b11-1~deb9u1-b11
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /usr/local/tomcat
26-Jul-2018 00:02:17.415 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /usr/local/tomcat
26-Jul-2018 00:02:17.418 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat//conf/logging.properties
26-Jul-2018 00:02:17.418 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat/
26-Jul-2018 00:02:17.419 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat/
26-Jul-2018 00:02:17.420 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat//temp
26-Jul-2018 00:02:17.420 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.16] using APR version [1.5.2].
26-Jul-2018 00:02:17.420 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
26-Jul-2018 00:02:17.420 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
26-Jul-2018 00:02:17.425 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.0f  25 May 2017]
26-Jul-2018 00:02:17.998 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
26-Jul-2018 00:02:18.122 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
26-Jul-2018 00:02:18.149 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
26-Jul-2018 00:02:18.152 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
26-Jul-2018 00:02:18.153 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 2120 ms
26-Jul-2018 00:02:18.273 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
26-Jul-2018 00:02:18.273 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.31
26-Jul-2018 00:02:18.377 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/usr/local/tomcat/webapps/ROOT.war]
26-Jul-2018 00:02:33.245 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
log4j:WARN No appenders could be found for logger (org.codehaus.groovy.grails.commons.cfg.ConfigurationHelper).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

Configuring Shiro ...

Shiro Configured
2018-07-26 00:03:09,920 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table allele add constraint FK_ssx0gv6xbtu3tbwt6ekkmn4iw foreign key (variant_id) references feature
2018-07-26 00:03:09,922 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: constraint "fk_ssx0gv6xbtu3tbwt6ekkmn4iw" for relation "allele" already exists
2018-07-26 00:03:25,137 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add column cvterm_id int8 not null
2018-07-26 00:03:25,137 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" contains null values
2018-07-26 00:03:39,307 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add constraint FK_8twb5n8vjmldyy3eeyq7sppc3 foreign key (cvterm_id) references cvterm
2018-07-26 00:03:39,307 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" referenced in foreign key constraint does not exist
Starting Quartz Scheduler in QuartzFactoryBean
26-Jul-2018 00:04:20.601 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/ROOT.war] has finished in [122,221] ms
26-Jul-2018 00:04:22.327 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
26-Jul-2018 00:04:22.342 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
26-Jul-2018 00:04:22.346 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 124192 ms

Thank you in advance,

Michal

nathandunn commented 6 years ago
  1. I would initially try doing it without the database mount (obviously there will be problems persisting after the container goes down). If that works then I would

  2. I would clear out the database volume you are mounting (for now, backing up what is there.). That might work (if the directory exists). If it does not, try doing a pg_init on the mounted directory (from within the container or externally) and make sure its the same version. It looks like 9.6.

If those steps don't work, I can create a container without Chado, but this has worked in the past for me. My guess is that the older containers might be causing problems.

mictadlo commented 6 years ago

I clean up the volumes and started again docker with apollo but I got the same error. I do not know how can I remove from your docker image the database mount.

nathandunn commented 6 years ago
nathandunn commented 6 years ago

and then run:

nathandunn commented 6 years ago

I am running this on a mac:

docker -v
Docker version 18.06.0-ce, build 0ffa825
mictadlo commented 6 years ago

I followed your instructions and I get the same errors with docker -v Docker version 18.03.1-ce, build 9ee9f40

What did I miss?

nathandunn commented 6 years ago

You ran all 4 of those instructions as typed and you still got:

psql:/chado.sql:49: ERROR:  must be owner of extension plpgsql

SET
psql:/chado.sql:2637928: ERROR:  function create_point(integer, bigint) does not exist
LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
              ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
CONTEXT:  SQL function "boxrange" during inlining

?

mictadlo commented 6 years ago

Yes, I still get the same errors. Do you get them, too?

nathandunn commented 6 years ago

Nope. Are you running on a Mac?

Can you build and run locally or try it on another system?

Nathan

On Jul 26, 2018, at 4:16 PM, Michał T. Lorenc notifications@github.com wrote:

Yes, I still get the same errors. Do you get them, too?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

mictadlo commented 6 years ago

Yes, I am using a Mac and I tried in on Centos 7. Both provide me with same error.

nathandunn commented 6 years ago

Okay. I’ll try running it on a few different machines. I may have defined something locally that I forgot about.

On Jul 26, 2018, at 4:52 PM, Michał T. Lorenc notifications@github.com wrote:

Yes, I am using a Mac and I tried in on Centos 7. Both provide me with same error.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/GMOD/docker-apollo/issues/27#issuecomment-408269583, or mute the thread https://github.com/notifications/unsubscribe-auth/AAt2qk-zxMIHIfcLshbK5-Z_SFIyuoGDks5uKlZVgaJpZM4VB0S7.

nathandunn commented 6 years ago

Okay @mictadlo seeing the same error. Will try to get a fix.

nathandunn commented 6 years ago

@mictadlo If you do use apollo-only, you have to set the environmental variables accordingly, which means setting up an external postgresql server via docker-compose.

https://github.com/GMOD/docker-apollo/blob/apollo-only/apollo-config.groovy

I haven't tested it yet, but am still working on bringing up the default image.

nathandunn commented 6 years ago

@mictadlo I'm pushing another fix on latest:

https://github.com/GMOD/docker-apollo/commit/5ad4368c0273c35f8f752de88e40bc0a38912c88

Looked like there were some issues with tomcat8

nathandunn commented 6 years ago

Re-open if it doesn't fix it, though.

nathandunn commented 6 years ago

I'll retest the build as well

mictadlo commented 6 years ago

Hi Nathan, I ran the following commands and I still got the errors.

docker kill $(docker ps -q)
docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
docker run -it -p 8888:8080 gmod/apollo:latest

Did I miss anything?

Thank you in advance,

Michal

nathandunn commented 6 years ago

docker pull gmod/apollo

Or

docker pull gmod/apollo:latest

It should hopefully bring back the newest image.

Nathan

On Jul 29, 2018, at 5:09 PM, Michał T. Lorenc notifications@github.com wrote:

Hi Nathan, I ran the following commands and I still got the errors.

docker kill $(docker ps -q) docker rm $(docker ps -a -q) docker rmi $(docker images -q) docker run -it -p 8888:8080 gmod/apollo:latest Did I miss anything?

Thank you in advance,

Michal

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/GMOD/docker-apollo/issues/27#issuecomment-408716018, or mute the thread https://github.com/notifications/unsubscribe-auth/AAt2qiBrvswPdDKUQZLvfwmKJMpxh2qLks5uLk6sgaJpZM4VB0S7.

nathandunn commented 6 years ago

though, if you remove the local images, it should try to fetch the newest, so not sure what's up. I haven't tested with the remotely built images.

mictadlo commented 6 years ago

I tried those commands and still, I have the same errors:

docker kill $(docker ps -q)
docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
docker pull gmod/apollo:latest
docker run -it -p 8888:8080 gmod/apollo:latest
nathandunn commented 6 years ago

Just ran this on a a new machine that didn't have docker installed on it before. Is that something you could try (or run it within virtualbox, etc.?).

Here is my output (feel free to post all of yours here as well):

docker run -it -p 8888:8080 gmod/apollo:latest

Unable to find image 'gmod/apollo:latest' locally
latest: Pulling from gmod/apollo
55cbf04beb70: Pull complete 
1607093a898c: Extracting [=>                                                 ]  393.2kB/10.74MB
1607093a898c: Extracting [============================================>      ]  9.568MB/10.74MB
1607093a898c: Pull complete 
9a8ea045c926: Pull complete 
1290813abd9d: Pull complete 
8a6b982ad6d7: Pull complete 
abb029e68402: Pull complete 
8cd067dc06dc: Pull complete 
1b9ce2097b98: Pull complete 
d6db5874b692: Pull complete 
25b4aa3d52c5: Pull complete 
53ec227dabf0: Pull complete 
242938ace8b4: Pull complete 
cccfd5ca2886: Pull complete 
556c79d510d8: Pull complete 
088e36d94df4: Pull complete 
84ed40888353: Pull complete 
58bf9a9c111f: Pull complete 
f819b75fffce: Pull complete 
9c19d2ce2392: Pull complete 
c1bc0e0ba881: Pull complete 
03a98c5440c6: Pull complete 
0c0563c5fac0: Pull complete 
9b44a5f2ff85: Pull complete 
25edebefcde4: Pull complete 
271da51aeefa: Pull complete 
dfd59686cdb4: Pull complete 
32e06ebc8b95: Pull complete 
Digest: sha256:630edc1f651e566f755ce623bd8dcd4e95cca276e5d23ec9b319a4cd58eaca40
Status: Downloaded newer image for gmod/apollo:latest

[ ok ] Starting PostgreSQL 9.6 database server: main.
WEBAPOLLO_HOST_FLAG: 
CHADO_HOST_FLAG: 
Waiting for DB
/var/run/postgresql:5432 - accepting connections
Postgres is up, configuring database
psql: FATAL:  Peer authentication failed for user "apollo-lqt"
Apollo database not found, creating...
CREATE ROLE
GRANT
Configuring Chado
psql: FATAL:  Peer authentication failed for user "apollo"
Chado database not found, creating...
ERROR:  role "apollo" already exists
GRANT
Loading Chado
SET
SET
SET
SET
SET
SET
SET
SET
CREATE SCHEMA
CREATE SCHEMA
CREATE SCHEMA
CREATE EXTENSION
psql:/chado.sql:49: ERROR:  must be owner of extension plpgsql
SET
CREATE TYPE

...

ALTER TABLE
ALTER TABLE
Loaded Chado
Restarting tomcat with /var/lib/tomcat8
[FAIL] Starting Tomcat servlet engine: tomcat8 failed!
30-Jul-2018 05:22:31.495 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/share/tomcat8
30-Jul-2018 05:22:31.495 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/tmp/tomcat8-tomcat8-tmp
30-Jul-2018 05:22:31.496 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib
30-Jul-2018 05:22:31.576 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
30-Jul-2018 05:22:31.589 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
30-Jul-2018 05:22:31.591 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 473 ms
30-Jul-2018 05:22:31.614 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
30-Jul-2018 05:22:31.614 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.14 (Debian)
30-Jul-2018 05:22:31.624 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
30-Jul-2018 05:22:31.654 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 63 ms
30-Jul-2018 05:22:41.639 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive /var/lib/tomcat8/webapps/ROOT.war
30-Jul-2018 05:22:54.853 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
log4j:WARN No appenders could be found for logger (org.codehaus.groovy.grails.commons.cfg.ConfigurationHelper).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

Configuring Shiro ...

Shiro Configured
2018-07-30 05:23:19,773 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table allele add constraint FK_ssx0gv6xbtu3tbwt6ekkmn4iw foreign key (variant_id) references feature
2018-07-30 05:23:19,774 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: constraint "fk_ssx0gv6xbtu3tbwt6ekkmn4iw" for relation "allele" already exists

2018-07-30 05:23:24,786 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add column cvterm_id int8 not null
2018-07-30 05:23:24,787 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" contains null values
2018-07-30 05:23:27,335 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table chadoprop add constraint FK_8twb5n8vjmldyy3eeyq7sppc3 foreign key (cvterm_id) references cvterm
2018-07-30 05:23:27,335 [localhost-startStop-1] ERROR hbm2ddl.SchemaUpdate  - ERROR: column "cvterm_id" referenced in foreign key constraint does not exist
Starting Quartz Scheduler in QuartzFactoryBean
30-Jul-2018 05:23:41.383 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive /var/lib/tomcat8/webapps/ROOT.war has finished in 59,744 ms
mictadlo commented 6 years ago

I'm confused your output has psql:/chado.sql:49: ERROR: must be owner of extension plpgsql and may the other one too.

nathandunn commented 6 years ago

@mictadlo Tomcat should be fixed (which was the prior problem). Its possible that chado is still not functioning properly, but I want to make sure this works for you, first.

If, after running docker run -it -p 8888:8080 gmod/apollo:latest if you can't connect to http://localhost:8888/ let me know and paste the entire output.

mictadlo commented 6 years ago

Apollo starts at http://localhost:8888/, but what it is about the above errors.

nathandunn commented 6 years ago

I can fix the above errors later (I’ll issue another ticket) as I have other things to work on.

Just to confirm, this allows you to start moving forward with Docker and Apollo, or do you need Chado, as well?

Nathan

On Jul 30, 2018, at 2:38 PM, Michał T. Lorenc notifications@github.com wrote:

Apollo starts at http://localhost:8888/ http://localhost:8888/, but what it is about the above errors.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/GMOD/docker-apollo/issues/27#issuecomment-409020323, or mute the thread https://github.com/notifications/unsubscribe-auth/AAt2qkY09w6qbbIuxAQUZRRGzj36h-3Zks5uL3zGgaJpZM4VB0S7.

mictadlo commented 6 years ago

No, at the moment I do no need Chado. Will the above error effect Apollo?

nathandunn commented 6 years ago

It shouldn’t affect Apollo, but let me know if it does.

If you can add an organism and annotate it is working.

Nathan

On Jul 30, 2018, at 3:18 PM, Michał T. Lorenc notifications@github.com wrote:

No, at the moment I do no need Chado. Will the above error effect Apollo?

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub, or mute the thread.

mictadlo commented 6 years ago

OK, When do you think you would have time to fix chado?

nathandunn commented 6 years ago

Oh, you do need Chado then?

Sure, I will take a look at it by the end of this week.

Nathan

On Jul 30, 2018, at 4:29 PM, Michał T. Lorenc notifications@github.com wrote:

OK, When do you think you would have time to fix chado?

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/GMOD/docker-apollo/issues/27#issuecomment-409044928, or mute the thread https://github.com/notifications/unsubscribe-auth/AAt2qoSbYnfyxMLWRwSxbf0LMlr2Jacbks5uL5bhgaJpZM4VB0S7.

nathandunn commented 6 years ago

@mictadlo I think that chado should be working now that I look at it more closely. The error that you are seeing is generated on the COMMENT line, but it still continues with the load:

screen shot 2018-08-02 at 2 43 21 pm

And when I run this docker image it comes up indicating that it has a working chado database connected:

screen shot 2018-08-02 at 2 40 28 pm

Let me know if a chado export doesn't work for you.

Also, if you have could provide me some additional context of what you are trying to do either here or off-line, I might be better able to provide you with advice as there are a lot of folks that've done this integration.

nathandunn commented 6 years ago

Re-open if you need to.