Docker compose unable to start #579

softwarecrash · 2024-02-07T11:51:41Z

softwarecrash
Feb 7, 2024

the provided docker compose is as example unable to start

To Reproduce
Steps to reproduce the behavior:
copy the docker compose example from urlaubsverwaltung/zeiterfassung/blob/main/.examples/docker-compose/docker-compose.yml
compose....
get the following error on the log

??????????????????????????????????????????????????
???????????????????????????????????????????
???????
based on Spring Boot version 3.2.2
2024-02-07T11:48:09.732Z  INFO 1 --- [           main] d.focusshift.zeiterfassung.Application   : Starting Application v2.1.1 using Java 21.0.1 with PID 1 (/workspace/BOOT-INF/classes started by cnb in /workspace)
2024-02-07T11:48:09.736Z  INFO 1 --- [           main] d.focusshift.zeiterfassung.Application   : No active profile set, falling back to 1 default profile: "default"
2024-02-07T11:48:11.337Z  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-02-07T11:48:11.460Z  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 112 ms. Found 7 JPA repository interfaces.
2024-02-07T11:48:12.573Z  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port 8080 (http)
2024-02-07T11:48:12.587Z  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2024-02-07T11:48:12.588Z  INFO 1 --- [           main] o.apache.catalina.core.StandardEngine    : Starting Servlet engine: [Apache Tomcat/10.1.18]
2024-02-07T11:48:12.650Z  INFO 1 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2024-02-07T11:48:12.651Z  INFO 1 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2824 ms
2024-02-07T11:48:12.997Z  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2024-02-07T11:48:14.059Z ERROR 1 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.
org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:342) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:263) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.Driver.makeConnection(Driver.java:443) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.Driver.connect(Driver.java:297) ~[postgresql-42.6.0.jar:42.6.0]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-5.0.1.jar:na]
	at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:283) ~[liquibase-core-4.24.0.jar:na]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1820) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1769) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:312) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1231) ~[spring-context-6.1.3.jar:6.1.3]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:949) ~[spring-context-6.1.3.jar:6.1.3]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) ~[spring-context-6.1.3.jar:6.1.3]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) ~[spring-boot-3.2.2.jar:3.2.2]
	at de.focusshift.zeiterfassung.Application.main(Application.java:13) ~[classes/:2.1.1]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91) ~[workspace/:na]
	at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53) ~[workspace/:na]
	at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58) ~[workspace/:na]
Caused by: java.net.ConnectException: Connection refused
	at java.base/sun.nio.ch.Net.pollConnect(Native Method) ~[na:na]
	at java.base/sun.nio.ch.Net.pollConnectNow(Unknown Source) ~[na:na]
	at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(Unknown Source) ~[na:na]
	at java.base/sun.nio.ch.NioSocketImpl.connect(Unknown Source) ~[na:na]
	at java.base/java.net.SocksSocketImpl.connect(Unknown Source) ~[na:na]
	at java.base/java.net.Socket.connect(Unknown Source) ~[na:na]
	at org.postgresql.core.PGStream.createSocket(PGStream.java:243) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.core.PGStream.<init>(PGStream.java:98) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:132) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:258) ~[postgresql-42.6.0.jar:42.6.0]
	... 37 common frames omitted
2024-02-07T11:48:14.071Z  WARN 1 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2024-02-07T11:48:14.074Z  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2024-02-07T11:48:14.093Z  INFO 1 --- [           main] .s.b.a.l.ConditionEvaluationReportLogger : 
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2024-02-07T11:48:14.111Z ERROR 1 --- [           main] o.s.boot.SpringApplication               : Application run failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1773) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:312) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1231) ~[spring-context-6.1.3.jar:6.1.3]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:949) ~[spring-context-6.1.3.jar:6.1.3]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) ~[spring-context-6.1.3.jar:6.1.3]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) ~[spring-boot-3.2.2.jar:3.2.2]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) ~[spring-boot-3.2.2.jar:3.2.2]
	at de.focusshift.zeiterfassung.Application.main(Application.java:13) ~[classes/:2.1.1]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
	at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91) ~[workspace/:na]
	at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53) ~[workspace/:na]
	at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58) ~[workspace/:na]
Caused by: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:288) ~[liquibase-core-4.24.0.jar:na]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1820) ~[spring-beans-6.1.3.jar:6.1.3]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1769) ~[spring-beans-6.1.3.jar:6.1.3]
	... 23 common frames omitted
Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:342) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:263) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.Driver.makeConnection(Driver.java:443) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.Driver.connect(Driver.java:297) ~[postgresql-42.6.0.jar:42.6.0]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100) ~[HikariCP-5.0.1.jar:na]
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-5.0.1.jar:na]
	at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:283) ~[liquibase-core-4.24.0.jar:na]
	... 25 common frames omitted
Caused by: java.net.ConnectException: Connection refused
	at java.base/sun.nio.ch.Net.pollConnect(Native Method) ~[na:na]
	at java.base/sun.nio.ch.Net.pollConnectNow(Unknown Source) ~[na:na]
	at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(Unknown Source) ~[na:na]
	at java.base/sun.nio.ch.NioSocketImpl.connect(Unknown Source) ~[na:na]
	at java.base/java.net.SocksSocketImpl.connect(Unknown Source) ~[na:na]
	at java.base/java.net.Socket.connect(Unknown Source) ~[na:na]
	at org.postgresql.core.PGStream.createSocket(PGStream.java:243) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.core.PGStream.<init>(PGStream.java:98) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:132) ~[postgresql-42.6.0.jar:42.6.0]
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:258) ~[postgresql-42.6.0.jar:42.6.0]
	... 37 common frames omitted
Native Memory Tracking:
Total: reserved=6164466694, committed=252992518
       malloc: 35716102 #198530
       mmap:   reserved=6128750592, committed=217276416
-                 Java Heap (reserved=5515509760, committed=109051904)
                            (mmap: reserved=5515509760, committed=109051904) 
 
-                     Class (reserved=118352204, committed=6547788)
                            (classes #9963)
                            (  instance classes #9281, array classes #682)
                            (malloc=911692 #26452) 
                            (mmap: reserved=117440512, committed=5636096) 
                            (  Metadata:   )
                            (    reserved=67108864, committed=36634624)
                            (    used=36327520)
                            (    waste=307104 =0.84%)
                            (  Class space:)
                            (    reserved=117440512, committed=5636096)
                            (    used=5363960)
                            (    waste=272136 =4.83%)
 
-                    Thread (reserved=16835936, committed=898400)
                            (thread #16)
                            (stack: reserved=16777216, committed=839680)
                            (malloc=36688 #124) 
                            (arena=22032 #38)
 
-                      Code (reserved=255099136, committed=18379008)
                            (malloc=1466624 #6454) 
                            (mmap: reserved=253632512, committed=16912384) 
 
-                        GC (reserved=150775219, committed=45180339)
                            (malloc=9315763 #4704) 
                            (mmap: reserved=141459456, committed=35864576) 
 
-                 GCCardSet (reserved=38624, committed=38624)
                            (malloc=38624 #164) 
 
-                  Compiler (reserved=1835584, committed=1835584)
                            (malloc=37920 #547) 
                            (arena=1797664 #13)
 
-                  Internal (reserved=600445, committed=600445)
                            (malloc=563581 #16176) 
                            (mmap: reserved=36864, committed=36864) 
 
-                    Symbol (reserved=16265552, committed=16265552)
                            (malloc=14915072 #130383) 
                            (arena=1350480 #1)
 
-    Native Memory Tracking (reserved=3224320, committed=3224320)
                            (malloc=47840 #836) 
                            (tracking overhead=3176480)
 
-        Shared class space (reserved=16777216, committed=12292096, readonly=0)
                            (mmap: reserved=16777216, committed=12292096) 
 
-               Arena Chunk (reserved=694664, committed=694664)
                            (malloc=694664 #160) 
 
-                   Tracing (reserved=337, committed=337)
                            (malloc=337 #9) 
 
-                Statistics (reserved=128, committed=128)
                            (malloc=128 #2) 
 
-                 Arguments (reserved=169, committed=169)
                            (malloc=169 #5) 
 
-                    Module (reserved=101792, committed=101792)
                            (malloc=101792 #2558) 
 
-                 Safepoint (reserved=8192, committed=8192)
                            (mmap: reserved=8192, committed=8192) 
 
-           Synchronization (reserved=1020208, committed=1020208)
                            (malloc=1020208 #9799) 
 
-            Serviceability (reserved=17152, committed=17152)
                            (malloc=17152 #9) 
 
-                 Metaspace (reserved=67305424, committed=36831184)
                            (malloc=196560 #121) 
                            (mmap: reserved=67108864, committed=36634624) 
 
-      String Deduplication (reserved=680, committed=680)
                            (malloc=680 #8) 
 
-           Object Monitors (reserved=3952, committed=3952)
                            (malloc=3952 #19)

can you please update the docker compose file, and/or add a how to prepare it to the readme.

honnel · 2024-02-09T12:43:52Z

honnel
Feb 9, 2024
Maintainer

@softwarecrash the log looks like you do not have any up and running database. Did the database start-up works correctly, are there any issues?

0 replies

softwarecrash · 2024-02-09T12:58:04Z

softwarecrash
Feb 9, 2024
Author

@honnel thanks, from the compose example the PostgreSQL is running so i can see from the logs

PostgreSQL Database directory appears to contain a database; Skipping initialization
2024-02-07 11:47:45.342 UTC [1] LOG:  starting PostgreSQL 16.1 (Debian 16.1-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-02-07 11:47:45.344 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-02-07 11:47:45.344 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-02-07 11:47:45.350 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-02-07 11:47:45.359 UTC [30] LOG:  database system was shut down at 2024-02-07 11:40:08 UTC
2024-02-07 11:47:45.367 UTC [1] LOG:  database system is ready to accept connections
2024-02-07 11:52:45.464 UTC [28] LOG:  checkpoint starting: time
2024-02-07 11:52:45.491 UTC [28] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.008 s, sync=0.002 s, total=0.029 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=0/1A050A0, redo lsn=0/1A05068

1 reply

honnel Apr 3, 2024
Maintainer

Looks like your database is up and running, but zeiterfassung application is not able to connect. Could you tell more about your setup?

EgeUmut · 2024-03-30T10:20:22Z

EgeUmut
Mar 30, 2024

@softwarecrash I have a similar problem. Did you fix it? If so, how?

2 replies

softwarecrash Mar 30, 2024
Author

Badly No solution

honnel Apr 3, 2024
Maintainer

@EgeUmut it's difficult to reproduce the problem, could you also provide more information about your environment?

Scorpoon · 2024-10-11T16:24:38Z

Scorpoon
Oct 11, 2024

I've got it.
I will post it later, have to go now because of a family schedule 😅

Short: I have changed a few important things in the compose file. Cost me only a day of trial and error...

0 replies

Scorpoon · 2024-10-12T11:43:01Z

Scorpoon
Oct 12, 2024

@softwarecrash I got it working by editing a few things in the compose file.

Your error message was Connection to localhost:5432 refused, when running in docker each service has its own IP (when you not declare it otherwise). In this case the web application tried to connect to the database via localhost:5432 but its on a total other ip...

The solution for you could be to hardcode the ip address into the variable SPRING_DATASOURCE_URL, which would be bad because the ip address can change.
Another solution would be to assign each service a fixed ip with macvlan, than the ip address will also be persistent. (can't help with that, maybe there are also other solutions like this)

Or just use the following compose file:
You only have to replace the variables I've inserted there (surrounded by {}).
Set SPRING_SECURITY_OAUTH2_CLIENT_REGISTRATION_DEFAULT_CLIENT-SECRET to anything, you have to replace it anyway with the generated secret from keycloak in a later step (or just leave it as "zeiterfassung-secret" like in the original, i wouldn't recommend that)

Another error in the compose file was the missing ZEITERFASSUNG_SECURITY_OIDC_CLAIM-MAPPERS_GROUP-CLAIM_ENABLED: true, without it the group claim from keycloak is not recognized correctly and permissions won't apply to the user.
Before spinning up, make sure to place the files master-realm.json & zeiterfassung-realm-realm.json into the /opt/zeiterfassung/keycloak/import directory on the docker host machine.

Changes in the compose file:

Added persisting files for postgres and introduced another postgres service for keycloak (also persistent), this way your data will not be lost after recreating the stack. (It can also be done with one postgres container, I wanted to have it separated).
Removed the network_mode: "host" and opened only the one needed port.
Commented out the mail stuff because I don't need it.
Added a health check to keycloak so that the "zeiterfassung" service starts when keycloak is ready.

Steps to get it running (hopefully 😆)
If you use something else then portainer I am not able to help you out.

Create a new stack with the new compose file
Replace variables, ideally replace it in a text editor with the search & replace function to avoid mistakes (some are used more than once in the file)
Adjust the ports if needed (only the left part: for example 8080:8080 to 8283:8080) and if changed make sure to replace all occurences of it in the right place in the compose file
Copy the 2 realm import files into /opt/zeiterfassung/keycloak/import
Spin up the containers & wait until all are healthy (hopefully)
Open the keycloak admin page at which is declared in the variable ZEITERFASSUNG_SECURITY_OIDC_SERVER-URL and login with the values from the variables KEYCLOAK_ADMIN & KEYCLOAK_ADMIN_PASSWORD
- Select the "zeiterfassung-realm" realm in the top left dropdown
- On the left, below "manage", click on "clients" and then on "zeiterfassung" in the right
- On the first tab "Settings", search for "Access settings" on the right & adjust the "Valid redirect URIs" to http://{REPLACE_HOST_DOMAIN_OR_IP}:8080, like http://IPorDomain:8080 (it has to be the port of "zeiterfassung"-service)
- Click save on the bottom of the page
- Select the "Credentials" tab, click on "Regenerate" to the right of "Client Secret" & copy the newly generated secret into the compose file where the variable {REPLACE_CLIENT_SECRET} is/was
- Click save on the bottom of the page
- Select "Users" on the left side
  - Click on "Add User"
  - Because I disabled the mail service check "Email verified" and fill in the required parts
  - Add the groups to the user (privileged has all rights, normal user can only insert their own times)
    - I've seen that later on you can edit the privileges in the web app itself, haven't tested it yet)
  - Click "Create" on the bottom
  - Select "Credentials" Tab on the top and set a password for the user (here you can choose temporary, then the user has to change its password on the first login)
    - "Credential Reset" won't work because we haven't set up mail delivery
Click on "Update the stack" in portainer & wait for all containers to be ready
Now you should be able to login with the previously created user at http://{REPLACE_HOST_DOMAIN_OR_IP}:8080 (it has to be the port of "zeiterfassung"-service)

I hope I have everything written down to get you started.

Compose file:

services:

  zeiterfassung:
    image: ghcr.io/urlaubsverwaltung/zeiterfassung/zeiterfassung:2.8.0
    #network_mode: "host"
    environment:
      SERVER_PORT: 8080
      # Database
      SPRING_DATASOURCE_URL: jdbc:postgresql://postgres:5432/zeiterfassung
      SPRING_DATASOURCE_USERNAME: {REPLACE_ZE_DB_USERNAME}
      SPRING_DATASOURCE_PASSWORD: {REPLACE_ZE_DB_PASSWORD}
      # Mail
      #ZEITERFASSUNG_MAIL_FROM: [email protected]
      #ZEITERFASSUNG_MAIL_FROMDISPLAYNAME: zeiterfassung
      #ZEITERFASSUNG_MAIL_REPLYTO: [email protected]
      #ZEITERFASSUNG_MAIL_REPLYTODISPLAYNAME: replyto
      #SPRING_MAIL_HOST: localhost
      #SPRING_MAIL_PORT: 1025
      # OpenID Connect identity provider
      SPRING_SECURITY_OAUTH2_CLIENT_REGISTRATION_DEFAULT_CLIENT-ID: zeiterfassung
      SPRING_SECURITY_OAUTH2_CLIENT_REGISTRATION_DEFAULT_CLIENT-SECRET: {REPLACE_CLIENT_SECRET} # client secret has to be generated in keycloak
      SPRING_SECURITY_OAUTH2_CLIENT_REGISTRATION_DEFAULT_CLIENT-NAME: zeiterfassung
      SPRING_SECURITY_OAUTH2_CLIENT_REGISTRATION_DEFAULT_PROVIDER: default
      SPRING_SECURITY_OAUTH2_CLIENT_REGISTRATION_DEFAULT_SCOPE: openid,profile,email,roles
      SPRING_SECURITY_OAUTH2_CLIENT_REGISTRATION_DEFAULT_AUTHORIZATION-GRANT-TYPE: authorization_code
      SPRING_SECURITY_OAUTH2_CLIENT_REGISTRATION_DEFAULT_REDIRECT-URI: http://{REPLACE_HOST_DOMAIN_OR_IP}:8080/login/oauth2/code/{registrationId}
      SPRING_SECURITY_OAUTH2_CLIENT_PROVIDER_DEFAULT_ISSUER-URI: http://{REPLACE_HOST_DOMAIN_OR_IP}:8090/realms/zeiterfassung-realm
      ZEITERFASSUNG_SECURITY_OIDC_SERVER-URL: http://{REPLACE_HOST_DOMAIN_OR_IP}:8090
      ZEITERFASSUNG_SECURITY_OIDC_LOGIN-FORM-URL: http://{REPLACE_HOST_DOMAIN_OR_IP}:8080/oauth2/authorization/default
      SPRING_AUTOCONFIGURE_EXCLUDE: org.springframework.boot.autoconfigure.amqp.RabbitAutoConfiguration
      ZEITERFASSUNG_SECURITY_OIDC_CLAIM-MAPPERS_GROUP-CLAIM_ENABLED: true
    ports:
      - '8080:8080'
    depends_on:
      keycloak:
        condition: service_healthy
      postgres:
        condition: service_healthy
#      mailhog:
#        condition: service_started

  postgres:
    image: postgres:16.1
#    ports:
#      - '5432:5432'
    environment:
      POSTGRES_DB: zeiterfassung
      POSTGRES_USER: {REPLACE_ZE_DB_USERNAME}
      POSTGRES_PASSWORD: {REPLACE_ZE_DB_PASSWORD}
    # persistence
    volumes:
      - /opt/zeiterfassung/db:/var/lib/postgresql/data:rw
    healthcheck:
      test: [ "CMD-SHELL", "pg_isready -d $${POSTGRES_DB} -U $${POSTGRES_USER}"]
      interval: 3s
      timeout: 1s
      retries: 5

  postgres_keycloak:
    image: postgres:16.1
    environment:
      POSTGRES_DB: keycloak
      POSTGRES_USER: {REPLACE_KEYCLOAK_DB_USERNAME}
      POSTGRES_PASSWORD: {REPLACE_KEYCLOAK_DB_PASSWORD}
#    ports:
#      - '5433:5432'
    # persistence
    volumes:
      - /opt/zeiterfassung/authdb:/var/lib/postgresql/data:rw
    healthcheck:
      test: [ "CMD-SHELL", "pg_isready -d $${POSTGRES_DB} -U $${POSTGRES_USER}"]
      interval: 3s
      timeout: 1s
      retries: 5

#  mailhog:
    #image: mailhog/mailhog:v1.0.1
    #container_name: zeiterfassung_mail
    #hostname: zeiterfassung_mail
    #ports:
    #  - '1025:1025'
    #  - '8025:8025'

  keycloak:
    image: quay.io/keycloak/keycloak:26.0.0
    command: ["start-dev", "--import-realm"]
    environment:
      KEYCLOAK_ADMIN: {REPLACE_KEYCLOAK_USERNAME}
      KEYCLOAK_ADMIN_PASSWORD: {REPLACE_KEYCLOAK_PASSWORD}
      KC_HTTP_PORT: 8090
      KC_HOSTNAME_STRICT: 'false'
      KC_HOSTNAME_STRICT_HTTPS: 'false'
      KC_CACHE: 'local'
      KC_HEALTH_ENABLED: true
      # Database
      KC_DB: postgres
      KC_DB_URL: jdbc:postgresql://postgres_keycloak:5432/keycloak
      KC_DB_USERNAME: {REPLACE_KEYCLOAK_DB_USERNAME}
      KC_DB_PASSWORD: {REPLACE_KEYCLOAK_DB_PASSWORD}
    depends_on:
      postgres_keycloak:
        condition: service_healthy
    ports:
      - '8090:8090'
    volumes:
      - /opt/zeiterfassung/keycloak/import:/opt/keycloak/data/import:ro
    healthcheck:
      test: ["CMD-SHELL", "exec 3<>/dev/tcp/127.0.0.1/9000;echo -e 'GET /health/ready HTTP/1.1\r\nhost: http://localhost\r\nConnection: close\r\n\r\n' >&3;if [ $? -eq 0 ]; then echo 'Healthcheck Successful';exit 0;else echo 'Healthcheck Failed';exit 1;fi;"]
      interval: 30s
      timeout: 10s
      retries: 3

1 reply

theunknownjedy Nov 25, 2024

I have followed your instructions and the system starts up so far. I can make the configuration under Keycloak, but then I get the error “too many redirects” when I log in. Do you have any idea where the error could be?

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Docker compose unable to start #579

{{title}}

Replies: 5 comments 4 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

Docker compose unable to start #579

softwarecrash Feb 7, 2024

Replies: 5 comments · 4 replies

honnel Feb 9, 2024 Maintainer

softwarecrash Feb 9, 2024 Author

honnel Apr 3, 2024 Maintainer

EgeUmut Mar 30, 2024

softwarecrash Mar 30, 2024 Author

honnel Apr 3, 2024 Maintainer

Scorpoon Oct 11, 2024

Scorpoon Oct 12, 2024

theunknownjedy Nov 25, 2024

softwarecrash
Feb 7, 2024

Replies: 5 comments 4 replies

honnel
Feb 9, 2024
Maintainer

softwarecrash
Feb 9, 2024
Author

honnel Apr 3, 2024
Maintainer

EgeUmut
Mar 30, 2024

softwarecrash Mar 30, 2024
Author

honnel Apr 3, 2024
Maintainer

Scorpoon
Oct 11, 2024

Scorpoon
Oct 12, 2024