Mysql-Problem with Docker-installation

Seafile Server
1

I’m trying to setup a seafile server with the offical docker-compose.yml.
After starting the containers I found an error-message in seafile-mysql container:

[Warning] Access denied for user 'seafile'@'172.18.0.4' (using password: YES

I didn’t change the standard-password “db_dev”
It is also not possible to login in the mysql-container.
This is my docker-compose.yml:

services:
  db:
    image: mariadb:10.11
    container_name: seafile-mysql
    environment:
      - MYSQL_ROOT_PASSWORD=db_dev  # Requested, set the root's password of MySQL service.
      - MYSQL_LOG_CONSOLE=true
      - MARIADB_AUTO_UPGRADE=1
    volumes:
      - /opt/seafile-mysql/db:/var/lib/mysql  # Requested, specifies the path to MySQL data persistent store.
    networks:
      - seafile-net

  memcached:
    image: memcached:1.6.18
    container_name: seafile-memcached
    entrypoint: memcached -m 256
    networks:
      - seafile-net

#  elasticsearch:
#    image: elasticsearch:8.6.2
#    container_name: seafile-elasticsearch
#    environment:
#      - discovery.type=single-node
#      - bootstrap.memory_lock=true
#      - "ES_JAVA_OPTS=-Xms1g -Xmx1g"
#      - "xpack.security.enabled=false"
#    ulimits:
#      memlock:
#        soft: -1
#        hard: -1
#    mem_limit: 2g
#    volumes:
#      - /opt/seafile-elasticsearch/data:/usr/share/elasticsearch/data  # Requested, specifies the path to Elasticsearch data persistent store.
#    networks:
#      - seafile-net
          
  seafile:
    image: docker.seadrive.org/seafileltd/seafile-pro-mc:latest
    container_name: seafile
    ports:
      - "8075:80"
#     - "443:443"  # If https is enabled, cancel the comment.
    volumes:
      - /media/usbdrive/Seafile/seafile-data:/shared   # Requested, specifies the path to Seafile data persistent store.
    environment:
      - DB_HOST=db
      - DB_ROOT_PASSWD=db_dev  # Requested, the value should be root's password of MySQL service.
      - TIME_ZONE=Europe/Berlin # Optional, default is UTC. Should be uncomment and set to your local time zone.
      - SEAFILE_ADMIN_EMAIL=xy.z@test.de # Specifies Seafile admin user, default is 'me@example.com'
      - SEAFILE_ADMIN_PASSWORD=topsecret     # Specifies Seafile admin password, default is 'asecret'
      - SEAFILE_SERVER_LETSENCRYPT=false   # Whether to use https or not
      - SEAFILE_SERVER_HOSTNAME=192.168.178.75 # Specifies your host name if https is enabled
    depends_on:
      - db
      - memcached
      - elasticsearch
    networks:
      - seafile-net

networks:
  seafile-net:

How can I change the root-password?

2

The root password is only needed during initialization (The first time you run Seafile docker image). Later, a normal user seafile and its password is generated and stored in the configuration file.

Can you check the generated seafile and the password in the config files?

3

Thank you for your reply.
Wich config files do you mean?
Can you please specify them?

4

You can check seafile.conf for the generated Seafile user’s password. Here is the document on logs and their location: Seafile Community Installation - Seafile Admin Manual

5

I found some files with the user seafile and a generated password in /opt/seafile/conf.
I changed it in the following files:
ccnet.conf
seafevents.conf
seafile.conf
seahub_settings.py

The error is still the same.

6

I removed the whole installation and started from scratch.
Now, it works like a charm