Docker - Example without any proxy - solved

1

Hi all,

I want to run the docker compose example from:

my adaption results to:

services:
vikunja:
image: vikunja/vikunja
environment:
VIKUNJA_SERVICE_PUBLICURL: http://A.B.C.20
VIKUNJA_DATABASE_HOST: db
VIKUNJA_DATABASE_PASSWORD: test
VIKUNJA_DATABASE_TYPE: mysql
VIKUNJA_DATABASE_USER: vikunja
VIKUNJA_DATABASE_DATABASE: vikunja
VIKUNJA_SERVICE_JWTSECRET: test
ports:
- 3456:3456
volumes:
- /volume1/docker/vikunja/files:/app/vikunja/files
depends_on:
db:
condition: service_healthy
restart: unless-stopped
db:
image: mariadb:10
command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
environment:
MYSQL_ROOT_PASSWORD: test
MYSQL_USER: vikunja
MYSQL_PASSWORD: test
MYSQL_DATABASE: vikunja
volumes:
- /volume1/docker/vikunja/db:/var/lib/mysql
restart: unless-stopped
healthcheck:
test: [“CMD-SHELL”, “mysqladmin ping -h localhost -u $$MYSQL_USER --password=$$MYSQL_PASSWORD”]
interval: 2s
start_period: 30s

both volumes
/volume1/docker/vikunja/files
and
/volume1/docker/vikunja/db
got
chown 1000

e.g. chown 1000 /volume1/docker/vikunja/db via ssh connection.

the db and the vikunja container are healthy up and running.

But after a few seconds the port 3456 vanishes from the portainer view.
This also results into an anavailability to http://A.B.C.20:3456

grafik
grafik1841×148 24.9 KB

Any ideas?

2

on the screenshot I marked the wrong area. I meant the Port column → right

3

Provide both DB and Vikunja container logs

4

Hi, thanks for your response.
Sure here there are:
Vikunja Log:
2025-02-15T05:34:57Z: INFO :arrow_forward: 001 No config file found, using default or config from environment variables.
2025-02-15T05:34:57Z: INFO :arrow_forward: 002 Running migrations…
2025-02-15T05:34:57Z: CRITICAL :arrow_forward: 004 Migration failed: dial tcp 192.168.112.2:3306: connect: connection refused
2025-02-15T05:34:58Z: INFO :arrow_forward: 001 No config file found, using default or config from environment variables.
2025-02-15T05:34:58Z: INFO :arrow_forward: 002 Running migrations…
2025-02-15T05:34:59Z: INFO :arrow_forward: 0df Ran all migrations successfully.
2025-02-15T05:34:59Z: INFO :arrow_forward: 0e0 Mailer is disabled, not sending reminders per mail
2025-02-15T05:34:59Z: INFO :arrow_forward: 0e1 Mailer is disabled, not sending overdue per mail
2025-02-15T05:34:59Z: INFO :arrow_forward: 0e2 Vikunja version v0.24.6
⇨ http server started on [::]:3456

DB Log:
2025-02-15 05:34:57+00:00 [Note] [Entrypoint]: Stopping temporary server
2025-02-15 5:34:57 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
2025-02-15 5:34:57 0 [Note] InnoDB: FTS optimize thread exiting.
2025-02-15 5:34:57 0 [Note] InnoDB: Starting shutdown…
2025-02-15 5:34:57 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2025-02-15 5:34:57 0 [Note] InnoDB: Buffer pool(s) dump completed at 250215 5:34:57
2025-02-15 5:34:57 0 [Note] InnoDB: Removed temporary tablespace data file: “./ibtmp1”
2025-02-15 5:34:57 0 [Note] InnoDB: Shutdown completed; log sequence number 46996; transaction id 15
2025-02-15 5:34:57 0 [Note] mariadbd: Shutdown complete
2025-02-15 05:34:57+00:00 [Note] [Entrypoint]: Temporary server stopped
2025-02-15 05:34:57+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
2025-02-15 5:34:57 0 [Note] Starting MariaDB 10.11.11-MariaDB-ubu2204 source revision e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4 server_uid GEuAhM6y1TxZoEIFH0HygeebXb0= as process 1
2025-02-15 5:34:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2025-02-15 5:34:57 0 [Note] InnoDB: Number of transaction pools: 1
2025-02-15 5:34:57 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-02-15 5:34:57 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2025-02-15 5:34:57 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 1
2025-02-15 5:34:57 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2025-02-15 5:34:57 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2025-02-15 5:34:57 0 [Note] InnoDB: Completed initialization of buffer pool
2025-02-15 5:34:57 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2025-02-15 5:34:57 0 [Note] InnoDB: End of log at LSN=46996
2025-02-15 5:34:57 0 [Note] InnoDB: 128 rollback segments are active.
2025-02-15 5:34:57 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12.000MiB. Physically writing the file full; Please wait …
2025-02-15 5:34:57 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12.000MiB.
2025-02-15 5:34:57 0 [Note] InnoDB: log sequence number 46996; transaction id 14
2025-02-15 5:34:57 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2025-02-15 5:34:57 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-02-15 5:34:57 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
2025-02-15 5:34:58 0 [Note] Server socket created on IP: ‘0.0.0.0’.
2025-02-15 5:34:58 0 [Note] Server socket created on IP: ‘::’.
2025-02-15 5:34:58 0 [Note] InnoDB: Buffer pool(s) load completed at 250215 5:34:58
2025-02-15 5:34:58 0 [Note] mariadbd: ready for connections.
Version: ‘10.11.11-MariaDB-ubu2204’ socket: ‘/run/mysqld/mysqld.sock’ port: 3306 mariadb.org binary distribution
after
sudo chown 1000 /volume1/docker/vikunja/db
sudo chown 1000 /volume1/docker/vikunja/files
ls -l /volume1/docker/vikunja/
shows then
total 8
drwxrwxrwx 6 Marcel systemd-journal 4096 Feb 15 06:34 db
drwxrwxrwx 2 Marcel 1000 4096 Feb 14 21:47 files

id Marcel
shows:
uid=1000(Marcel) gid=10(admin) groups=10(admin),100(users),121(docker),133(ughomeusers)

5

nevermind
now it works
what I did in between:
shut down the stack
run
sudo chown 1000 /volume1/docker/vikunja/db
sudo chown 1000 /volume1/docker/vikunja/files
sudo chown 1000 /volume1/docker/vikunja

cleared the content of /volume1/docker/vikunja/db
restart the stack