I would like to get Vikunja running on my Synology NAS with the help of “Portainer”. I’ve been trying for several days now, I’ve had to read through the docs completely several times, but I still can’t do it because I probably don’t know enough about Docker and co.
But again, this absolute path is wrong with almost 100% certainty, you’ll need to find that on the Synology. The same change then needs to be done for the Vikunja container as well.
The container is there. It may not be shown in Portainer, but it will certainly run on the box. It is reported to be unhealthy, so you’d need to access the container logs and figure out why.
With SSH i never really worked with it before… after i logged in, where do i have to navigate to run the commands? Do i have to navigate to a specific path? Or can i easily run it after i logged in to the terminal?
There isnt any container, i check it via putty with ur commands.
The shown mariadb is from bookstack_db as u can see and not for Vikunja, so the deployment created nothing.
I dont know why but the composer deployment now worked… i think with the free version for docker hub u only can get 100 pulls per 6hours i get the paid option for 7$ and now it worked… but i get the following logs from the vikunja-db-1 container:
2024-08-08 17:01:27 0 [Note] mariadbd: ready for connections.
Version: '10.11.8-MariaDB-ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-08-08 17:01:27 3 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:29 4 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:30 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:01:32 6 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:34 7 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:35 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:01:37 9 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:39 10 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:39 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:01:41 12 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:44 13 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:44 14 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:01:46 15 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:48 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:01:49 17 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:51 18 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:53 19 [Warning] Aborted connection 19 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:01:53 20 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:56 21 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:58 22 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:01:58 23 [Warning] Aborted connection 23 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:02:00 24 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:03 25 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:05 26 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:07 27 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:07 28 [Warning] Aborted connection 28 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:02:10 29 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:12 30 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:14 31 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:16 32 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:19 33 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:21 34 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:23 35 [Warning] Aborted connection 35 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:02:23 36 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:26 37 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:28 38 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:30 39 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:32 40 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:35 41 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:37 42 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:39 43 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:41 44 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:43 45 [Warning] Aborted connection 45 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:02:44 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
2024-08-08 17:02:44 0 [Note] InnoDB: FTS optimize thread exiting.
2024-08-08 17:02:44 0 [Note] InnoDB: Starting shutdown...
2024-08-08 17:02:44 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-08-08 17:02:44 0 [Note] InnoDB: Buffer pool(s) dump completed at 240808 17:02:44
2024-08-08 17:02:47 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-08-08 17:02:47 0 [Note] InnoDB: Shutdown completed; log sequence number 47012; transaction id 15
2024-08-08 17:02:48 0 [Note] mariadbd: Shutdown complete
2024-08-08 17:02:53+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.8+maria~ubu2204 started.
2024-08-08 17:02:53+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup/emory:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
6:freezer:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
5:devices:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
4:cpuset:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
3:cpuacct:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
2:cpu:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
1:blkio:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525/memory.pressure not writable, functionality unavailable to MariaDB
2024-08-08 17:02:53+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-08-08 17:02:53+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.8+maria~ubu2204 started.
2024-08-08 17:02:54+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
2024-08-08 17:02:54+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade or creating healthcheck users) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
2024-08-08 17:02:54 0 [Note] Starting MariaDB 10.11.8-MariaDB-ubu2204 source revision 3a069644682e336e445039e48baae9693f9a08ee as process 1
2024-08-08 17:02:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-08-08 17:02:54 0 [Note] InnoDB: Number of transaction pools: 1
2024-08-08 17:02:54 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-08-08 17:02:54 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required)
2024-08-08 17:02:54 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2024-08-08 17:02:54 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-08-08 17:02:54 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-08 17:02:54 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-08-08 17:02:54 0 [Note] InnoDB: End of log at LSN=47012
2024-08-08 17:02:54 0 [Note] InnoDB: 128 rollback segments are active.
2024-08-08 17:02:54 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-08-08 17:02:54 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-08-08 17:02:54 0 [Note] InnoDB: log sequence number 47012; transaction id 14
2024-08-08 17:02:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-08 17:02:54 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-08-08 17:02:54 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
2024-08-08 17:02:54 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-08-08 17:02:54 0 [Note] Server socket created on IP: '::'.
2024-08-08 17:02:54 0 [Warning] 'user' entry 'root@8094dc39947b' ignored in --skip-name-resolve mode.
2024-08-08 17:02:54 0 [Warning] 'proxies_priv' entry '@% root@8094dc39947b' ignored in --skip-name-resolve mode.
2024-08-08 17:02:54 0 [Note] mariadbd: ready for connections.
Version: '10.11.8-MariaDB-ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-08-08 17:02:54 0 [Note] InnoDB: Buffer pool(s) load completed at 240808 17:02:54
2024-08-08 17:02:55 3 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:57 4 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:58 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:03:00 6 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:03:02 7 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:03:02 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:03:04 9 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:03:07 10 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:03:07 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:03:09 12 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
The vikunja-vikunja-1 container logs says:
2024-08-08T19:49:53.987177455Z: INFO ▶ config/InitConfig 001 No config file found, using default or config from environment variables.
2024-08-08T19:49:53.987323855Z: INFO ▶ migration/Migrate 002 Running migrations…
2024-08-08T19:49:53.992705537Z: CRITICAL ▶ migration/Migrate 004 Migration failed: dial tcp 127.0.0.1:3306: connect: connection refused
2024-08-08T19:49:58.48921924Z: INFO ▶ config/InitConfig 001 No config file found, using default or config from environment variables.
2024-08-08T19:49:58.490006434Z: INFO ▶ migration/Migrate 002 Running migrations…
2024-08-08T19:49:58.490808686Z: CRITICAL ▶ migration/Migrate 004 Migration failed: dial tcp 127.0.0.1:3306: connect: connection refused
2024-08-08T19:50:02.939859104Z: INFO ▶ config/InitConfig 001 No config file found, using default or config from environment variables.
2024-08-08T19:50:02.940600357Z: INFO ▶ migration/Migrate 002 Running migrations…
2024-08-08T19:50:02.941428793Z: CRITICAL ▶ migration/Migrate 004 Migration failed: dial tcp 127.0.0.1:3306: connect: connection refused
How can i fix this?
Do i have to add something manually to my database via phpmyadmin?
Or did i have to change this in my composer file to anything else?
VIKUNJA_DATABASE_HOST: localhost
my current composer file, I have blacked out some data (passwords and domain) with “*”. Everything else is like i deploy my composer file.
@kolaente sorry for tagging u here, but I spent the whole evening looking at the problem with an IT specialist, but we couldn’t come up with a solution.
Maybe you notice something else here?
I hope it’s not a problem that I’ve tagged you here. I would be extremely grateful if you could also keep an eye on this alongside Wasabi.
You already had it set to the correct value, why did you change it to localhost? Localhost would require you to publish the port on the docker host, which is not necessary if you only want to access the service from other containers.
Apart from that, please keep in mind that this is a community forum. I understand personal projects are always time critical and always important, everyone here is doing that in their free time though. Keep that in mind please and do not tag people if they dared not to answer within three hours please
We were not sure what to do, and localhost seems legit to us. But both “db” and “localhost” value cause this error.
2024-08-08 17:02:53+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.8+maria~ubu2204 started.
2024-08-08 17:02:53+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup/emory:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
6:freezer:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
5:devices:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
4:cpuset:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
3:cpuacct:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
2:cpu:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525
1:blkio:/docker/446a558c3a2ee9b475210f84dcbbd6f534827415c30f4f1f1fa6ca62e96e1525/memory.pressure not writable, functionality unavailable to MariaDB
2024-08-08 17:02:53+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-08-08 17:02:53+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.8+maria~ubu2204 started.
2024-08-08 17:02:54+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
2024-08-08 17:02:54+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade or creating healthcheck users) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
2024-08-08 17:02:54 0 [Note] Starting MariaDB 10.11.8-MariaDB-ubu2204 source revision 3a069644682e336e445039e48baae9693f9a08ee as process 1
2024-08-08 17:02:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-08-08 17:02:54 0 [Note] InnoDB: Number of transaction pools: 1
2024-08-08 17:02:54 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-08-08 17:02:54 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required)
2024-08-08 17:02:54 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2024-08-08 17:02:54 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-08-08 17:02:54 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-08 17:02:54 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-08-08 17:02:54 0 [Note] InnoDB: End of log at LSN=47012
2024-08-08 17:02:54 0 [Note] InnoDB: 128 rollback segments are active.
2024-08-08 17:02:54 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-08-08 17:02:54 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-08-08 17:02:54 0 [Note] InnoDB: log sequence number 47012; transaction id 14
2024-08-08 17:02:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-08 17:02:54 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-08-08 17:02:54 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
2024-08-08 17:02:54 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-08-08 17:02:54 0 [Note] Server socket created on IP: '::'.
2024-08-08 17:02:54 0 [Warning] 'user' entry 'root@8094dc39947b' ignored in --skip-name-resolve mode.
2024-08-08 17:02:54 0 [Warning] 'proxies_priv' entry '@% root@8094dc39947b' ignored in --skip-name-resolve mode.
2024-08-08 17:02:54 0 [Note] mariadbd: ready for connections.
Version: '10.11.8-MariaDB-ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-08-08 17:02:54 0 [Note] InnoDB: Buffer pool(s) load completed at 240808 17:02:54
2024-08-08 17:02:55 3 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:57 4 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:02:58 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:03:00 6 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:03:02 7 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:03:02 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:03:04 9 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:03:07 10 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
2024-08-08 17:03:07 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: '192.168.112.3' (This connection closed normally without authentication)
2024-08-08 17:03:09 12 [Warning] Access denied for user 'vikunja'@'localhost' (using password: YES)
Of course I know that and I appreciate that, the tags were not meant in any malicious way. That’s why I express my gratitude to you in every post for trying to help me.
But of course I understand that.
Now back to the topic.
Any idea why it cause a connection refuse from vikunja user to the database?
I’m really despairing about it.
I change the DB Host back to “db”, here is my current composer file:
Your compose file works as is when executing it without any changes on my computer, so it’s not a generic problem of your compose project. I’m not familiar with Portainer as I prefer managing docker deployments either plainly using CLI or have K8s, neither am I really familiar with Docker on Synology.
As this seems to be something related to the environment, not the compose definition itself, I’m afraid you’ll need to look more there, but I won’t be able to help.
