Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Docker-compose tutorial updates? #417

Open
esseti opened this issue May 4, 2022 · 2 comments
Open

Docker-compose tutorial updates? #417

esseti opened this issue May 4, 2022 · 2 comments

Comments

@esseti
Copy link

esseti commented May 4, 2022

I'm trying to test out Cachet with docker-compose following this link: https://docs.cachethq.io/docs/get-started-with-docker

so far:

  • last version of cachet (2.3.18) not working since the command called :install does not exists
  • using the version as is in the guide i get this error
cachet_1    | Initializing Cachet database ...
postgres_1  | 2022-05-04 14:46:20.192 UTC [62] ERROR:  relation "chq_settings" does not exist at character 29
postgres_1  | 2022-05-04 14:46:20.192 UTC [62] STATEMENT:  select "name", "value" from "chq_settings"
cachet_1    | PHP Fatal error:  Uncaught ErrorException: count(): Parameter must be an array or an object that implements Countable in /var/www/html/vendor/graham-campbell/exceptions/src/ExceptionIdentifier.php:51
cachet_1    | Stack trace:
cachet_1    | #0 [internal function]: Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(2, 'count(): Parame...', '/var/www/html/v...', 51, Array)
cachet_1    | #1 /var/www/html/vendor/graham-campbell/exceptions/src/ExceptionIdentifier.php(51): count(NULL)
cachet_1    | #2 /var/www/html/vendor/graham-campbell/exceptions/src/ExceptionHandlerTrait.php(47): GrahamCampbell\Exceptions\ExceptionIdentifier->identify(Object(ErrorException))
cachet_1    | #3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(79): GrahamCampbell\Exceptions\ExceptionHandler->report(Object(ErrorException))
cachet_1    | #4 [internal function]: Illuminate\Foundation\Bootstrap\HandleExceptions->handleException(Object(ErrorException))
cachet_1    | #5 {main}
cachet_1    |   thrown in /var/www/html/vendor/graham-campbell/exceptions/src/ExceptionIdentifier.php on line 51
cachet_1    | PHP Fatal error:  Uncaught ErrorException: count(): Parameter must be an array or an object that implements Countable in /var/www/html/vendor/graham-campbell/exceptions/src/ExceptionIdentifier.php:51
cachet_1    | Stack trace:
cachet_1    | #0 [internal function]: Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(2, 'count(): Parame...', '/var/www/html/v...', 51, Array)
cachet_1    | #1 /var/www/html/vendor/graham-campbell/exceptions/src/ExceptionIdentifier.php(51): count(NULL)
cachet_1    | #2 /var/www/html/vendor/graham-campbell/exceptions/src/ExceptionHandlerTrait.php(47): GrahamCampbell\Exceptions\ExceptionIdentifier->identify(Object(Symfony\Component\Debug\Exception\FatalErrorException))
cachet_1    | #3 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(79): GrahamCampbell\Exceptions\ExceptionHandler->report(Object(Symfony\Component\Debug\Exception\FatalErrorException))
cachet_1    | #4 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(118): Illuminate\Foundation\Bootstrap\HandleExceptions->handleExcep in /var/www/html/vendor/graham-campbell/exceptions/src/ExceptionIdentifier.php on line 51
cachet-docker_cachet_1 exited with code 255

anyone that has an update guide for deploying cachet? is the project mantained?

@esseti
Copy link
Author

esseti commented May 5, 2022

Problem:

  • what's the setup correct to avoid re-doing all the setup everytime i do a docker-compose down/up? it restart from begining everytime
  • i've found no solution to send email. it seems that env values are not stored/read when trying to setup the email.

@esseti
Copy link
Author

esseti commented May 5, 2022

I was able to make it start and work.
docker-compose for postgres + cachet
OS bgubx and certbot for serving and https

docker-compose.yml

(fix missing data or remove stuff)

version: "3"

services:
  postgres:
    image: postgres:12-alpine
    volumes:
      - dbdata:/var/lib/postgresql/data
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
    restart: always
  cachet:
    image: cachethq/docker:latest
    ports:
      - 8000:8000
    links:
      - postgres:postgres
    environment:
      - DB_DRIVER=pgsql
      - DB_HOST=postgres
      - DB_PORT=5432
      - DB_DATABASE=postgres
      - DB_USERNAME=postgres
      - DB_PASSWORD=postgres
      - DB_PREFIX=chq_
      - APP_LOG=errorlog
      - APP_ENV=${APP_ENV:-production}
      - APP_DEBUG=false
      - DEBUG=false
      - APP_KEY=<YOURKEY>
      # this is the domain
      - MAIL_USERNAME=<DOMAIN IN MAILGUN>
      - MAIL_DRIVER=mailgun
      - MAIL_HOST=smtp.mailgun.org
      - MAIL_PORT=587
      # this is the api Key
      - MAIL_PASSWORD=<APIKEY>
      - MAIL_ADDRESS=<EMAIL ADDRESS>
      - MAIL_ENCRYPTION=tls

    depends_on:
      - postgres
    restart: on-failure

# persistent storage
volumes:
  dbdata:

with this you have the system exposed to localhost:8000

cachet.conf (put in /sites-enabled)

server {
  listen 80;
  # the servername
  server_name <YOUR DOMAIN>;
  location / {
    proxy_pass http://localhost:8000/;
    proxy_set_header Host $host;
    proxy_set_header X-Real-IP $remote_addr;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header X-Forwarded-Proto $scheme;
  }
}

with this you have it exposed to :80

for SSL use certbot (https://certbot.eff.org/ -> select nginx and your operating system for instruction)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant