Subject: mysql-service-type is not starting

From: Dmitry <[email-masked]>
Date: Wed, 18 Dec 2024 20:46:06 +0300

I'm trying to use a simple system with `mysql-service-type` with "guix system container", but I found out that `mysql-service-type` is not starting.

$> guix system container mysql-test-system.scm

system file: cat mysql-test-system.scm
(use-modules (gnu)
             (gnu services)
             (gnu services shepherd))

(use-service-modules databases)
(operating-system
  (locale "en_US.utf8")
  (timezone "Europe/Berlin")
  (host-name "example.org")
  (services (append %base-services
                    (list
                     (service mysql-service-type))))
  (bootloader (bootloader-configuration
               (bootloader grub-efi-bootloader)
               (targets (list "/boot/efi"))
               (keyboard-layout keyboard-layout)))
  (file-systems %base-file-systems))

ERROR: cat /var/log/mysqld.log
2024-12-18 18:01:51 chown: cannot access '/auth_pam_tool_dir/auth_pam_tool': No such file or directory
2024-12-18 18:01:51 Couldn't set an owner to '/auth_pam_tool_dir/auth_pam_tool'.
2024-12-18 18:01:51 It must be root, the PAM authentication plugin doesn't work otherwise..
2024-12-18 18:01:51
2024-12-18 18:01:51 chown: cannot access '/auth_pam_tool_dir': No such file or directory
2024-12-18 18:01:51 Cannot change ownership of the '/auth_pam_tool_dir' directory
2024-12-18 18:01:51 to the 'mysql' user. Check that you have the necessary permissions and try again.
2024-12-18 18:01:51
2024-12-18 18:01:51 Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
2024-12-18 18:01:51 2024-12-18 18:01:51 0 [ERROR] mariadbd: Can't create/write to file '/var/lib/mysql/aria_log_control' (Errcode: 13 "Permission denied")
2024-12-18 18:01:51 2024-12-18 18:01:51 0 [ERROR] mariadbd: Got error 'Can't create file' when trying to use aria control file '/var/lib/mysql/aria_log_control'
2024-12-18 18:01:51 2024-12-18 18:01:51 0 [ERROR] Plugin 'Aria' init function returned error.
2024-12-18 18:01:51 2024-12-18 18:01:51 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-12-18 18:01:51 2024-12-18 18:01:51 0 [ERROR] Failed to initialize plugins.
2024-12-18 18:01:51 2024-12-18 18:01:51 0 [ERROR] Aborting
2024-12-18 18:01:51 2024-12-18 18:01:51 0 [ERROR] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool.incomplete' for writing: Permission denied
2024-12-18 18:01:51 cat: write error: Broken pipe
2024-12-18 18:01:51 cat: write error: Broken pipe
2024-12-18 18:01:51
2024-12-18 18:01:51 Installation of system tables failed!  Examine the logs in
2024-12-18 18:01:51 /var/lib/mysql for more information.