danielbrendel / hortusfox-web

Self-hosted collaborative plant management and tracking system for plant enthusiasts
https://www.hortusfox.com
MIT License
674 stars 34 forks source link

Installation on synology ds223 #259

Closed ImBetterThanNinja closed 1 month ago

ImBetterThanNinja commented 3 months ago

Hi, I'm trying to install on my NAS Synology DS223 (DSM7) using Docker (Container Manager). Installation seems to go ok, return code 0 and all that. Then, when it is run, all it says in app log is "waiting for database to be available". I left it overnight (over 580 attempts) and still nothing. Below I'm pasting database log:

Version: '11.5.2-MariaDB-ubu2404'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2024-08-19 16:32:21 0 [Note] mariadbd: ready for connections.
2024-08-19 16:32:21 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2024-08-19 16:32:20 0 [Note] Server socket created on IP: '::'.
2024-08-19 16:32:20 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-08-19 16:32:10 0 [Note] InnoDB: Buffer pool(s) load completed at 240819 16:32:10
2024-08-19 16:32:10 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-08-19 16:32:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-19 16:32:10 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-08-19 16:32:10 0 [Note] InnoDB: log sequence number 47661; transaction id 14
2024-08-19 16:32:10 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-08-19 16:32:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-08-19 16:32:10 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-08-19 16:32:10 0 [Note] InnoDB: Opened 3 undo tablespace
2024-08-19 16:32:10 0 [Note] InnoDB: End of log at LSN=47661
2024-08-19 16:32:09 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-08-19 16:32:09 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-19 16:32:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-08-19 16:32:09 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2024-08-19 16:32:09 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 0
2024-08-19 16:32:09 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
2024-08-19 16:32:09 0 [Note] InnoDB: Number of transaction pools: 1
2024-08-19 16:32:09 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-19 16:32:09 0 [Note] Starting MariaDB 11.5.2-MariaDB-ubu2404 source revision ea75a0b6009b0251e83193cd38c3974e36b65e06 server_uid LZ5pYRSfMNmPrIPsQAN9Z/SoloA= as process 1
2024-08-19 16:32:09+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2024-08-19 16:32:09+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.5.2+maria~ubu2404 started.
2024-08-19 16:32:09+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
1:name=systemd:/docker/cfa770f5874c3e8840fad759e6033daafd3c6eb2abc0c9619544782995a2f289/memory.pressure not writable, functionality unavailable to MariaDB
2:name=synomonitor:/system.slice/pkg-ContainerManager-dockerd.service
3:cpuacct:/docker/cfa770f5874c3e8840fad759e6033daafd3c6eb2abc0c9619544782995a2f289
4:freezer:/docker/cfa770f5874c3e8840fad759e6033daafd3c6eb2abc0c9619544782995a2f289
5:devices:/docker/cfa770f5874c3e8840fad759e6033daafd3c6eb2abc0c9619544782995a2f289
6:memory:/docker/cfa770f5874c3e8840fad759e6033daafd3c6eb2abc0c9619544782995a2f289
7:cpuset:/docker/cfa770f5874c3e8840fad759e6033daafd3c6eb2abc0c9619544782995a2f289
2024-08-19 16:32:09+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup/pu:/docker/cfa770f5874c3e8840fad759e6033daafd3c6eb2abc0c9619544782995a2f289
2024-08-19 16:32:07+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.5.2+maria~ubu2404 started.

Either I did something wrong or it is just too much for this hardware. I would really appreciate some suggestions on how to debug it and get running (if possible).

danielbrendel commented 3 months ago

Hi, the log does not show any incoming connections. Did you modify any settings in the docker-compose?

ImBetterThanNinja commented 3 months ago

I only changed admin credentials and passwords to mysql and database. I did the same on "normal" debian machine and it works fine there.

harbinger-boop commented 3 months ago

For what it's worth, I had the same problem on a DS918+ a few days ago. Haven't been able to work around it yet.

ImBetterThanNinja commented 2 months ago

Thanks! Good to know I'm not the only one. :)

danielbrendel commented 1 month ago

I only changed admin credentials and passwords to mysql and database. I did the same on "normal" debian machine and it works fine there.

Did you notice any differences between those two systems? This seems not to be a specific issue with HortusFox, but rather a configuration/system problem.

Or does it even work meanwhile? :-)

danielbrendel commented 1 month ago

Closed due to inactivity. If the problem persists, please contact me on discord or per support contact form.