No connection to database possible

Question

No connection to database possible

Closed this issue 4 months ago · 3 comments

Is there an existing issue for this?

I have searched the existing issues

Current Behavior

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 (see below). Does anyone have an idea what I can do?

Expected Behavior

No response

Steps To Reproduce

Run on a Synology NAS
Use the stack from down below

Environment

- OS:Linux Synology_BRK 4.4.2 x86_64 GNU/Linux synology_geminilake_220+
- How docker service was installed: docker was installed via the synology package manager

CPU architecture

x86-64

Docker creation

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:11.1
    command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW
    restart: unless-stopped
    
    environment:
      - MYSQL_ROOT_PASSWORD=lychee
      - MYSQL_PASSWORD=lychee
      - MYSQL_DATABASE=lychee
      - MYSQL_USER=lychee
      - MYSQL_ROOT_HOST= '172.25.0.2' # needs to be enclosed with quotes

Container logs

[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.  





This is the log of the mariadb container: 
7:cpuset:/docker/7f8b983eb391d5593ad666a0d325210c4beaf7ea1e6d2c149ab64dc7f373da9c
6:blkio:/docker/7f8b983eb391d5593ad666a0d325210c4beaf7ea1e6d2c149ab64dc7f373da9c
5:devices:/docker/7f8b983eb391d5593ad666a0d325210c4beaf7ea1e6d2c149ab64dc7f373da9c
4:memory:/docker/7f8b983eb391d5593ad666a0d325210c4beaf7ea1e6d2c149ab64dc7f373da9c
3:freezer:/docker/7f8b983eb391d5593ad666a0d325210c4beaf7ea1e6d2c149ab64dc7f373da9c
2:name=synomonitor:/system.slice/pkg-Docker-dockerd.service
1:name=systemd:/docker/7f8b983eb391d5593ad666a0d325210c4beaf7ea1e6d2c149ab64dc7f373da9c/memory.pressure not writable, functionality unavailable to MariaDB
2024-04-18 13:12:49+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-04-18 13:12:49+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.4+maria~ubu2204 started.
2024-04-18 13:12:49+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2024-04-18 13:12:49 0 [Note] Starting MariaDB 11.1.4-MariaDB-1:11.1.4+maria~ubu2204 source revision b6680e0101c1e3cde9f0d7496443db1277064e84 as process 1
2024-04-18 13:12:49 0 [Note] mariadbd: Aria engine: starting recovery
recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (0.3 seconds); tables to flush: 4 3 2 1 0 (0.3 seconds); 
2024-04-18 13:12:50 0 [Note] mariadbd: Aria engine: recovery done
2024-04-18 13:12:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-04-18 13:12:50 0 [Note] InnoDB: Number of transaction pools: 1
2024-04-18 13:12:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-04-18 13:12:50 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required)
2024-04-18 13:12:50 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2024-04-18 13:12:50 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-04-18 13:12:50 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-18 13:12:50 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-04-18 13:12:50 0 [Note] InnoDB: End of log at LSN=47629
2024-04-18 13:12:50 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-04-18 13:12:50 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-04-18 13:12:50 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-04-18 13:12:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-04-18 13:12:50 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-04-18 13:12:50 0 [Note] InnoDB: log sequence number 47629; transaction id 14
2024-04-18 13:12:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-18 13:12:50 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-04-18 13:12:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-04-18 13:12:50 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory
2024-04-18 13:12:50 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-04-18 13:12:50 0 [Note] Server socket created on IP: '::'.
2024-04-18 13:12:50 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2024-04-18 13:12:50 0 [Note] mariadbd: ready for connections.
Version: '11.1.4-MariaDB-1:11.1.4+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2024-04-18 13:13:01 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.3' (This connection closed normally without authentication)
2024-04-18 13:13:01 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.3' (This connection closed normally without authentication)

Answer 1 · 2024-04-18T13:16:28.000Z

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

Answer 2 · 2024-05-18T15:26:03.000Z

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

Answer 3 · 2024-08-16T15:33:40.000Z

This issue is locked due to inactivity