Coolify Support

[Flowko]

First, thanks for this amazing product.

i would like to be able to self host it through coolify, but im having some issues, i would like some help to figure out how the docker compose file should look like, currently i have it like this:

services:
  tolgee:
    image: 'tolgee/tolgee:latest'
    environment:
      - SERVICE_FQDN_TOLGEE_8085
      - SPRING_DATASOURCE_USERNAME=$SERVICE_USER_POSTGRES
      - SPRING_DATASOURCE_PASSWORD=$SERVICE_PASSWORD_POSTGRES
      - 'SPRING_DATASOURCE_DB=${POSTGRES_DB:-tolgee}'
      - SPRING_DATASOURCE_HOST=postgres
      - 'SPRING_DATASOURCE_URL=postgres://$SERVICE_USER_POSTGRES:$SERVICE_PASSWORD_POSTGRES@postgresql:5432/$POSTGRES_DB'
      - 'TOLGEE_AUTHENTICATION_INITIAL_USERNAME=${TOLGEE_AUTHENTICATION_INITIAL_USERNAME}'
      - 'TOLGEE_AUTHENTICATION_JWT_SECRET=${TOLGEE_AUTHENTICATION_JWT_SECRET}'
      - 'TOLGEE_MACHINE_TRANSLATION_GOOGLE_API_KEY=${TOLGEE_MACHINE_TRANSLATION_GOOGLE_API_KEY}'
      - 'TOLGEE_SMTP_AUTH=${TOLGEE_SMTP_AUTH}'
      - 'TOLGEE_SMTP_FROM=${TOLGEE_SMTP_FROM}'
      - 'TOLGEE_SMTP_HOST=${TOLGEE_SMTP_HOST}'
      - 'TOLGEE_SMTP_AUTH=${TOLGEE_SMTP_AUTH}'
      - 'TOLGEE_SMTP_PASSWORD=${TOLGEE_SMTP_PASSWORD}'
      - 'TOLGEE_SMTP_SSL_ENABLED=${TOLGEE_SMTP_SSL_ENABLED}'
      - 'TOLGEE_SMTP_USERNAME=${TOLGEE_SMTP_USERNAME}'
      - 'TOLGEE_SMTP_SSL_ENABLED=${TOLGEE_SMTP_SSL_ENABLED}'
    depends_on:
      postgresql:
        condition: service_healthy
    healthcheck:
      test:
        - NONE
  postgresql:
    image: 'postgres:13'
    volumes:
      - 'postgresql-data:/var/lib/postgresql/data'
    environment:
      - POSTGRES_USER=$SERVICE_USER_POSTGRES
      - POSTGRES_PASSWORD=$SERVICE_PASSWORD_POSTGRES
      - 'POSTGRES_DB=${POSTGRES_DB:-tolgee}'
    healthcheck:
      test:
        - CMD-SHELL
        - 'pg_isready -U $${POSTGRES_USER} -d $${POSTGRES_DB}'
      interval: 5s
      timeout: 20s
      retries: 10

the envirements variables im passing:

POSTGRES_DB=tolgee
SERVICE_FQDN_TOLGEE_8085=http://tolgee.website.me:8085
SERVICE_PASSWORD_POSTGRES=XXXXXXXXXXXXXXXXXXXXXX
SERVICE_USER_POSTGRES=H5xp2ihe3XgH41WO
TOLGEE_AUTHENTICATION_INITIAL_USERNAME=admin
TOLGEE_AUTHENTICATION_JWT_SECRET=AsNZ8QmRWymCbXhNf50ou23cJ9WJZawQ
TOLGEE_MACHINE_TRANSLATION_GOOGLE_API_KEY=
TOLGEE_SMTP_AUTH=false
TOLGEE_SMTP_FROM=
TOLGEE_SMTP_HOST=
TOLGEE_SMTP_PASSWORD=
TOLGEE_SMTP_SSL_ENABLED=false
TOLGEE_SMTP_USERNAME=

i get these errors:

2024-04-07T14:09:11.635268768Z 2024-04-07T14:09:11.634Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'cacheConfiguration' of type [io.tolgee.configuration.CacheConfiguration$$SpringCGLIB$$0] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-04-07T14:09:11.984081399Z 2024-04-07T14:09:11.983Z  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2024-04-07T14:09:11.992837171Z 2024-04-07T14:09:11.992Z  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2024-04-07T14:09:11.992935635Z 2024-04-07T14:09:11.992Z  INFO 1 --- [           main] o.apache.catalina.core.StandardEngine    : Starting Servlet engine: [Apache Tomcat/10.1.15]
2024-04-07T14:09:12.088774519Z 2024-04-07T14:09:12.088Z  INFO 1 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2024-04-07T14:09:12.090017542Z 2024-04-07T14:09:12.089Z  INFO 1 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 4225 ms
2024-04-07T14:09:12.172427297Z 2024-04-07T14:09:12.172Z  INFO 1 --- [           main] i.t.p.PostgresEmbeddedRunner             : Starting embedded Postgres DB...
2024-04-07T14:09:12.197776718Z 2024-04-07T14:09:12.197Z  INFO 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: The files belonging to this database system will be owned by user "postgres".
2024-04-07T14:09:12.564667682Z 2024-04-07T14:09:12.564Z ERROR 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: sh: locale: not found
2024-04-07T14:09:12.564887142Z 2024-04-07T14:09:12.564Z  INFO 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: The database cluster will be initialized with locale "en_US.utf8".
2024-04-07T14:09:12.564931796Z 2024-04-07T14:09:12.564Z ERROR 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: 2024-04-07 14:09:12.564 UTC [64] WARNING:  no usable system locales were found
2024-04-07T14:09:12.941485324Z 2024-04-07T14:09:12.941Z  INFO 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: ok
2024-04-07T14:09:13.042125147Z 2024-04-07T14:09:13.041Z ERROR 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: initdb: warning: enabling "trust" authentication for local connections
2024-04-07T14:09:13.042420829Z 2024-04-07T14:09:13.042Z  INFO 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: ok
2024-04-07T14:09:13.309963422Z 2024-04-07T14:09:13.309Z ERROR 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: 2024-04-07 14:09:13.309 UTC [37] LOG:  starting PostgreSQL 13.12 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit
2024-04-07T14:09:13.310009488Z 2024-04-07T14:09:13.309Z  INFO 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: waiting for server to start....2024-04-07 14:09:13.092 UTC [70] LOG:  starting PostgreSQL 13.12 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit
2024-04-07T14:09:13.310072145Z 2024-04-07T14:09:13.309Z ERROR 1 --- [       Thread-1] i.t.p.PostgresEmbeddedRunner             : Postgres: 2024-04-07 14:09:13.309 UTC [37] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-04-07T14:09:13.321912348Z 2024-04-07T14:09:13.320Z  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2024-04-07T14:09:13.432783016Z 2024-04-07T14:09:13.432Z  INFO 1 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@9a4bb97
2024-04-07T14:09:13.434298957Z 2024-04-07T14:09:13.434Z  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2024-04-07T14:09:13.490560419Z 2024-04-07T14:09:13.490Z  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-2 - Starting...
2024-04-07T14:09:14.498343913Z 2024-04-07T14:09:14.493Z ERROR 1 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-2 - Exception during pool initialization.
2024-04-07T14:09:14.498372857Z 
2024-04-07T14:09:14.498375902Z org.postgresql.util.PSQLException: FATAL: role "H5xp2ihe3XgH41WO" does not exist
2024-04-07T14:09:14.498378337Z 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) ~[postgresql-42.6.0.jar:42.6.0]
2024-04-07T14:09:14.498381102Z 	at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2825) ~[postgresql-42.6.0.jar:42.6.0]
2024-04-07T14:09:14.498383306Z 	at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:175) ~[postgresql-42.6.0.jar:42.6.0]
2024-04-07T14:09:14.498385671Z 	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:313) ~[postgresql-42.6.0.jar:42.6.0]
2024-04-07T14:09:14.498387755Z 	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) ~[postgresql-42.6.0.jar:42.6.0]
2024-04-07T14:09:14.498389839Z 	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:263) ~[postgresql-42.6.0.jar:42.6.0]
2024-04-07T14:09:14.498402923Z 	at org.postgresql.Driver.makeConnection(Driver.java:443) ~[postgresql-42.6.0.jar:42.6.0]
2024-04-07T14:09:14.498405036Z 	at org.postgresql.Driver.connect(Driver.java:297) ~[postgresql-42.6.0.jar:42.6.0]
2024-04-07T14:09:14.498407611Z 	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:na]
2024-04-07T14:09:14.498409775Z 	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:na]
2024-04-07T14:09:14.498411759Z 	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:na]
2024-04-07T14:09:14.498413713Z 	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:na]
2024-04-07T14:09:14.498415756Z 	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-5.0.1.jar:na]
2024-04-07T14:09:14.498417750Z 	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100) ~[HikariCP-5.0.1.jar:na]
2024-04-07T14:09:14.498419834Z 	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-5.0.1.jar:na]
2024-04-07T14:09:14.498421868Z 	at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:281) ~[liquibase-core-4.20.0.jar:na]

meanwhile ill be digging to resolve this, but if u have any ideas please share, thank you!

[Flowko]

coolify added tolgee to their servicers to host with one click

[JanCizmar]

Nice! Is there any public page informing about this we can share on socials and our blog?

[Flowko]

@JanCizmar
coollabsio/coolify#1909
and
https://github.com/coollabsio/coolify/releases/tag/v4.0.0-beta.260