Error 500 by fresh installation (Docker/Postgres)

[EHRETic]

Hi there,

I've some difficulties installing Wallbag on my docker host. After "deployment", I get an error 500 by trying to connect to the URL.

Docker compose:

version: '3'
services:
  wallabag:
    container_name: wallabag
    image: wallabag/wallabag:latest

    restart: unless-stopped
    depends_on:
      - wallabag-postgres

    environment:
      SYMFONY__ENV__DATABASE_DRIVER: '${SYMFONY__ENV__DATABASE_DRIVER}'
      SYMFONY__ENV__DATABASE_HOST: '${SYMFONY__ENV__DATABASE_HOST}'
      SYMFONY__ENV__DATABASE_PORT: '${SYMFONY__ENV__DATABASE_PORT}'
      SYMFONY__ENV__DATABASE_NAME: '${SYMFONY__ENV__DATABASE_NAME}'
      SYMFONY__ENV__DATABASE_USER: '${SYMFONY__ENV__DATABASE_USER}'
      SYMFONY__ENV__DATABASE_PASSWORD: '${SYMFONY__ENV__DATABASE_PASSWORD}'
      SYMFONY__ENV__DATABASE_TABLE_PREFIX: '${SYMFONY__ENV__DATABASE_TABLE_PREFIX}'
      SYMFONY__ENV__MAILER_DSN: '${SYMFONY__ENV__MAILER_DSN}'
      SYMFONY__ENV__FROM_EMAIL: '${SYMFONY__ENV__FROM_EMAIL}'
      SYMFONY__ENV__DOMAIN_NAME: '${SYMFONY__ENV__DOMAIN_NAME}'
      SYMFONY__ENV__SERVER_NAME: '${SYMFONY__ENV__SERVER_NAME}'
      POPULATE_DATABASE: '${POPULATE_DATABASE}'
      POSTGRES_USER: '${POSTGRES_USER}'
      POSTGRES_PASSWORD: '${POSTGRES_PASSWORD}'

    volumes:
      - wallabag_images:/var/www/wallabag/web/assets/images

    networks:
      default:
        ipv4_address: 192.168.X.Z

    healthcheck:
      test: ["CMD", "wget" ,"--no-verbose", "--tries=1", "--spider", "http://localhost/api/info"]
      interval: 1m
      timeout: 3s

  wallabag-postgres:
    container_name: wallabag-postgres
    image: postgres:16.1-alpine

    restart: unless-stopped

    volumes: 
      - postgres:/var/lib/postgresql/data

    networks:
      default:
        ipv4_address: 192.168.X.Y

    environment:
      POSTGRES_USER: '${POSTGRES_USER}'
      POSTGRES_PASSWORD: '${POSTGRES_PASSWORD}'

volumes:
  wallabag_images:
  postgres:

networks:
  default:
    external: true
    name: docker_test

ENV file:

SYMFONY__ENV__DATABASE_DRIVER=pdo_pgsql
SYMFONY__ENV__DATABASE_HOST=192.168.X.Y
SYMFONY__ENV__DATABASE_PORT=5432
SYMFONY__ENV__DATABASE_NAME=wallabag
SYMFONY__ENV__DATABASE_USER=wallabag
SYMFONY__ENV__DATABASE_PASSWORD=xxx
SYMFONY__ENV__DATABASE_TABLE_PREFIX=wallabag_
SYMFONY__ENV__MAILER_DSN=smtp://mymailserver
SYMFONY__ENV__FROM_EMAIL=wallabag@mydomain.local
SYMFONY__ENV__DOMAIN_NAME=https://app-test.mydomain.local
SYMFONY__ENV__SERVER_NAME=Wallabag test instance
POSTGRES_USER=postgres
POSTGRES_PASSWORD=xxx
POPULATE_DATABASE=True

Logs when database already exists:

Starting wallabag ...
Waiting for database ...
WARN: Postgres database is already configured. Remove the environment variable with root password.
Installing dependencies from lock file
Verifying lock file contents can be installed on current platform.
Nothing to install, update or remove
Package guzzlehttp/ringphp is abandoned, you should avoid using it. No replacement was suggested.
Package guzzlehttp/streams is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/compiler is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/consistency is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/event is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/exception is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/file is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/iterator is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/math is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/protocol is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/regex is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/ruler is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/stream is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/ustring is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/visitor is abandoned, you should avoid using it. No replacement was suggested.
Package hoa/zformat is abandoned, you should avoid using it. No replacement was suggested.
Package lexik/form-filter-bundle is abandoned, you should avoid using it. Use spiriitlabs/form-filter-bundle instead.
Package php-http/guzzle5-adapter is abandoned, you should avoid using it. Use php-http/guzzle7-adapter instead.
Package php-http/message-factory is abandoned, you should avoid using it. Use psr/http-factory instead.
Package scheb/2fa-qr-code is abandoned, you should avoid using it. No replacement was suggested.
Package sensio/framework-extra-bundle is abandoned, you should avoid using it. Use Symfony instead.
Package symfony/debug is abandoned, you should avoid using it. Use symfony/error-handler instead.
Package symfony/inflector is abandoned, you should avoid using it. Use EnglishInflector from the String component instead.
Package true/punycode is abandoned, you should avoid using it. No replacement was suggested.
Package wallabag/php-mobi is abandoned, you should avoid using it. No replacement was suggested.
Package php-cs-fixer/diff is abandoned, you should avoid using it. No replacement was suggested.
Package symfony/web-server-bundle is abandoned, you should avoid using it. No replacement was suggested.
Generating optimized autoload files
Class SimpleHtmlDom\simple_html_dom_node located in ./vendor/mgargano/simplehtmldom/src/simple_html_dom.php does not comply with psr-0 autoloading standard. Skipping.
Class SimpleHtmlDom\simple_html_dom located in ./vendor/mgargano/simplehtmldom/src/simple_html_dom.php does not comply with psr-0 autoloading standard. Skipping.
100 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
> Incenteev\ParameterHandler\ScriptHandler::buildParameters
Updating the "app/config/parameters.yml" file
> bin/console cache:clear --no-warmup
 // Clearing the cache for the prod environment with debug                      
 // false                                                                       
 [OK] Cache for the "prod" environment (debug=false) was successfully cleared.  
> bin/console assets:install web --symlink --relative
 Trying to install assets as relative symbolic links.
 --- ------------------------ ------------------ 
      Bundle                   Method / Error    
 --- ------------------------ ------------------ 
  ✔   NelmioApiDocBundle       relative symlink  
  ✔   CraueConfigBundle        relative symlink  
  ✔   BabDevPagerfantaBundle   relative symlink  
  ✔   FOSJsRoutingBundle       relative symlink  
 --- ------------------------ ------------------ 
 [OK] All assets were successfully installed.                                   
wallabag is ready!

Logs when database doesn't exists:

Starting wallabag ...
Waiting for database ...
Configuring the Postgres database ...
ERROR:  syntax error at or near "-"
LINE 1: CREATE DATABASE wallabag;

Thing is, I have no tables in my database, despite wallbag user is owner of the database and I think "of course", this will result in the 500 error. api is available tough with the mentionned URL.

One thing: if I create the database after the initial start without, the logs will be exactly the same as above, so the DB is found. Remove root credentials doesn't help either.

Any clue where to start? Thx in advance! 😉

[tan-yong-sheng]

I faced similar problem as well... and the installation docs looks weird to me: https://doc.wallabag.org/en/developer/docker

For example, the step 2: Edit app/config/parameters.yml to replace database_* properties with commented ones (with values prefixed by env.). I checked and found I can't follow this step as there isn't any app/config/ folder existed.

I am working to self-host it with Docker and traefik reverse proxy.

[martin-juul]

If you ran into the same problem as me, you would see this as the first log entry:

WARN: Postgres database is already configured. Remove the environment variable with root password.

The issue is that the entrypoint only runs the database setup if it's the creator of the database. See https://github.com/wallabag/docker/blob/41430135535d5ee5a7fc1fbbda90323331827eb5/root/entrypoint.sh#L78

However it doesn't grant the necessary permissions, and the setup code is a bit ... Well it could be better.

How to get wallabag working with postgres

There's a flag POPULATE_DATABASE which we can disable, then we can go back to giving wallabag a role which has privileges on a database.

So my environment looks like this now:

      - POPULATE_DATABASE=false
      - SYMFONY__ENV__DATABASE_DRIVER=pdo_pgsql
      - SYMFONY__ENV__DATABASE_HOST=postgresql
      - SYMFONY__ENV__DATABASE_PORT=5432
      - SYMFONY__ENV__DATABASE_NAME=wallabag
      - SYMFONY__ENV__DATABASE_USER=wallabag
      - SYMFONY__ENV__DATABASE_PASSWORD=wallabag

Then we start the container and wait for it to finish starting up, afterwards jump into a shell:

docker exec -it wallabag sh

Now we can run the install script ourselves

php bin/console wallabag:install --env=prod -n

Since we ran that as root, we have to fix the permissions (otherwise you will get some nasty session errors)

chown -R nobody:nobody /var/www/wallabag

Then you should be able to hit your containers url or whatever you mapped it to and see

---

My database wouldn't close the hanging connections, to force drop it the syntax is as follows:

DROP DATABASE dbName WITH (FORCE)