Access denied for user

Hey,

when I try to run this compose file I’m getting every time permission denied errors for the databse and vakunja :confused:

services:
  vikunja:
    image: vikunja/vikunja
    environment:
      VIKUNJA_SERVICE_PUBLICURL: https://localhost
      VIKUNJA_DATABASE_HOST: db
      VIKUNJA_DATABASE_PASSWORD: test123
      VIKUNJA_DATABASE_TYPE: mysql
      VIKUNJA_DATABASE_USER: testUsr
      VIKUNJA_DATABASE_DATABASE: testDb
      VIKUNJA_SERVICE_JWTSECRET: dfgfdg2343244
    ports:
      - 3456:3456
    volumes:
      - ./files:/app/vikunja/files
    depends_on:
      db:
        condition: service_healthy
    restart: unless-stopped
  db:
    image: mariadb:10
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    environment:
      MYSQL_ROOT_PASSWORD: testRootPassword
      MYSQL_USER: testUsr
      MYSQL_PASSWORD: test123
      MYSQL_DATABASE: testUsr
    volumes:
      - ./db:/var/lib/mysql
    restart: unless-stopped
    healthcheck:
      test: ["CMD-SHELL", "mysqladmin ping -h localhost -u $$MYSQL_USER --password=$$MYSQL_PASSWORD"]
      interval: 2s
      start_period: 30s

This is the output from the db:

2025-01-21 13:48:20+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.10+maria~ubu2204 started.

2025-01-21 13:48:21+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB

2025-01-21 13:48:21+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’

2025-01-21 13:48:22+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.10+maria~ubu2204 started.

2025-01-21 13:48:23+00:00 [Note] [Entrypoint]: MariaDB upgrade not required

2025-01-21 13:48:23 0 [Note] Starting MariaDB 10.11.10-MariaDB-ubu2204 source revision 3d0fb150289716ca75cd64d62823cf715ee47646 server_uid LZ5pYRSfMNmPrIPsQAN9Z/SoloA= as process 1

2025-01-21 13:48:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2025-01-21 13:48:23 0 [Note] InnoDB: Number of transaction pools: 1

2025-01-21 13:48:23 0 [Note] InnoDB: Using ARMv8 crc32 instructions

2025-01-21 13:48:23 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 1

2025-01-21 13:48:23 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF

2025-01-21 13:48:23 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB

2025-01-21 13:48:23 0 [Note] InnoDB: Completed initialization of buffer pool

2025-01-21 13:48:23 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)

2025-01-21 13:48:23 0 [Note] InnoDB: End of log at LSN=119688

2025-01-21 13:48:23 0 [ERROR] InnoDB: The change buffer is corrupted or has been removed on upgrade to MariaDB 11.0 or later

2025-01-21 13:48:24 0 [Note] InnoDB: 128 rollback segments are active.

2025-01-21 13:48:24 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12.000MiB. Physically writing the file full; Please wait …

2025-01-21 13:48:24 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12.000MiB.

2025-01-21 13:48:24 0 [Note] InnoDB: log sequence number 119688; transaction id 14

2025-01-21 13:48:24 0 [Note] Plugin ‘FEEDBACK’ is disabled.

2025-01-21 13:48:24 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2025-01-21 13:48:24 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.

2025-01-21 13:48:24 0 [Note] InnoDB: Buffer pool(s) load completed at 250121 13:48:24

2025-01-21 13:48:24 0 [Note] Server socket created on IP: ‘0.0.0.0’.

2025-01-21 13:48:24 0 [Note] Server socket created on IP: ‘::’.

2025-01-21 13:48:24 0 [Note] mariadbd: ready for connections.

Version: ‘10.11.10-MariaDB-ubu2204’ socket: ‘/run/mysqld/mysqld.sock’ port: 3306 mariadb.org binary distribution

2025-01-21 13:48:25 3 [Warning] Access denied for user ‘testUsr’@‘localhost’ (using password: YES)

2025-01-21 13:48:27 4 [Warning] Access denied for user ‘testUsr’@‘localhost’ (using password: YES)

2025-01-21 13:48:28 5 [Warning] Access denied for user ‘testUsr’@‘172.20.0.3’ (using password: YES)

2025-01-21 13:48:30 6 [Warning] Access denied for user ‘testUsr’@‘localhost’ (using password: YES)

2025-01-21 13:48:31 7 [Warning] Access denied for user ‘testUsr’@‘172.20.0.3’ (using password: YES)

2025-01-21 13:48:32 8 [Warning] Access denied for user ‘testUsr’@‘localhost’ (using password: YES)

Can someone help me with this? :slight_smile:

There might be a typo here: I think “testUsr” should be “testDb” here.

Hey,
got it working, thank you :slight_smile:
By the way, is there an option to manage that user are not allowed to create projects and others are?

You can create a team (from the homepage > teams), grant that team the right permissions on a project (from the homepage > your project > three dots > share > shared with these teams > search for the right team and set permissions to read only), and assign the relevant users to that team.

Yeah that works fine, but the new users can also create projects etc.

It would be nice if you could invite users by e-mail and specify that they are not allowed to create projects etc. and only have the rights that have been assigned to them.

Maybe I’ll implement this myself and put a PR on Github :slight_smile:

This is somewhat planned as part of the Enterprise version.