LycheeOrg/Lychee-Docker

Connection refused

Closed this issue · 1 comments

CodeTriager commented

Hello everyone,
I'm using Lychee Docker on a vps and it works like a charm. I'm trying to install it on a Synology NAS but somehow my config won't work there. I installed docker and portainer and am trying to use the following stack:
`version: "2.1"
services:
lychee:
image: linuxserver/lychee
container_name: lychee
environment:
- PUID=1026
- PGID=100
- TZ=Europe/Berlin
- DB_HOST=db # Verwende den Service-Namen als Hostname
- DB_CONNECTION=mysql
- DB_USERNAME=lychee
- DB_PASSWORD=lychee
- DB_DATABASE=lychee
- DB_PORT=3306
- TRUSTED_PROXIES=*
volumes:
- /volume1/@docker/volumes/newstuff/_data:/config
- /volume1/@docker/volumes/pictures/_data:/pictures
ports:
- 8124:80
restart: unless-stopped

db:
image: mariadb
command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW
restart: unless-stopped

environment:
  - MYSQL_ROOT_PASSWORD=lyche
  - MYSQL_PASSWORD=lychee
  - MYSQL_DATABASE=lychee
  - MYSQL_USER=lychee
  - MYSQL_ROOT_HOST= '172.25.0.2' # needs to be enclosed with quotes

`
I get the following error in the lychee container:

`
[migrations] started
[migrations] 01-nginx-site-confs-default: skipped
[migrations] 02-default-location: skipped
[migrations] done
───────────────────────────────────────
██╗ ███████╗██╗ ██████╗
██║ ██╔════╝██║██╔═══██╗
██║ ███████╗██║██║ ██║
██║ ╚════██║██║██║ ██║
███████╗███████║██║╚██████╔╝
╚══════╝╚══════╝╚═╝ ╚═════╝
Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID: 1026
User GID: 100
───────────────────────────────────────
using keys found in /config/keys
Waiting for DB to be available
In Connection.php line 822:

SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select t
able_name as name, (data_length + index_length) as size, table_comment
as comment, engine as engine, table_collation as collation from infor
mation_schema.tables where table_schema = 'lychee' and table_type in ('BASE
TABLE', 'SYSTEM VERSIONED') order by table_name)

In Connector.php line 65:

SQLSTATE[HY000] [2002] Connection refused

[custom-init] No custom files found, skipping...
[ls.io-init] done.
INFO No scheduled commands are ready to run.
`

and this one in the mariadb:
`2024-04-08 16:36:35+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.4+mariaubu2204 started.
2024-04-08 16:36:37+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup/pu:/docker/05910ab044d9d0183c03915907735aa623381899d45812ed33eb725f233be1d0
8:cpuacct:/docker/05910ab044d9d0183c03915907735aa623381899d45812ed33eb725f233be1d0
7:cpuset:/docker/05910ab044d9d0183c03915907735aa623381899d45812ed33eb725f233be1d0
6:blkio:/docker/05910ab044d9d0183c03915907735aa623381899d45812ed33eb725f233be1d0
5:devices:/docker/05910ab044d9d0183c03915907735aa623381899d45812ed33eb725f233be1d0
4:memory:/docker/05910ab044d9d0183c03915907735aa623381899d45812ed33eb725f233be1d0
3:freezer:/docker/05910ab044d9d0183c03915907735aa623381899d45812ed33eb725f233be1d0
2:name=synomonitor:/system.slice/pkg-Docker-dockerd.service
1:name=systemd:/docker/05910ab044d9d0183c03915907735aa623381899d45812ed33eb725f233be1d0/memory.pressure not writable, functionality unavailable to MariaDB
2024-04-08 16:36:37+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-04-08 16:36:37+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.4+mariaubu2204 started.
2024-04-08 16:36:38+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
2024-04-08 16:36:38+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade or creating healthcheck users) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
2024-04-08 16:36:38 0 [Note] Starting MariaDB 11.1.4-MariaDB-1:11.1.4+mariaubu2204 source revision b6680e0101c1e3cde9f0d7496443db1277064e84 as process 1
2024-04-08 16:36:38 0 [Note] mariadbd: Aria engine: starting recovery
recovered pages: 0% 10% 21% 33% 44% 54% 67% 81% 91% 100% (0.1 seconds); tables to flush: 5 4 3 2 1 0 (1.0 seconds);
2024-04-08 16:36:39 0 [Note] mariadbd: Aria engine: recovery done
2024-04-08 16:36:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-04-08 16:36:39 0 [Note] InnoDB: Number of transaction pools: 1
2024-04-08 16:36:39 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-04-08 16:36:39 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required)
2024-04-08 16:36:39 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2024-04-08 16:36:39 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-04-08 16:36:39 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-08 16:36:39 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-04-08 16:36:39 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=18006
2024-04-08 16:36:39 0 [Note] InnoDB: End of log at LSN=47463
2024-04-08 16:36:39 0 [Note] InnoDB: To recover: 163 pages
2024-04-08 16:36:39 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-04-08 16:36:39 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-04-08 16:36:39 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-04-08 16:36:39 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-04-08 16:36:39 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-04-08 16:36:39 0 [Note] InnoDB: log sequence number 47463; transaction id 14
2024-04-08 16:36:39 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-04-08 16:36:39 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory
2024-04-08 16:36:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-08 16:36:39 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-04-08 16:36:39 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-04-08 16:36:39 0 [Note] Server socket created on IP: '::'.
2024-04-08 16:36:39 0 [Warning] 'user' entry 'root@de3bd52cb7c0' ignored in --skip-name-resolve mode.
2024-04-08 16:36:39 0 [Warning] 'proxies_priv' entry '@% root@de3bd52cb7c0' ignored in --skip-name-resolve mode.
2024-04-08 16:36:39 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2024-04-08 16:36:39 0 [Note] mariadbd: ready for connections.
Version: '11.1.4-MariaDB-1:11.1.4+mariaubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-04-08 16:37:01 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.3' (This connection closed normally without authentication)
2024-04-08 16:37:01 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.3' (This connection closed normally without authentication)

`

Does anyone have an idea what I can do?

d7415 commented

That's not our image, but it looks like you have a typo in

- MYSQL_ROOT_PASSWORD=lyche