GNU bug report logs - #74960
mysql-service-type is not starting

Message received at submit <at> debbugs.gnu.org:

Received: (at submit) by debbugs.gnu.org; 19 Dec 2024 05:12:42 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Thu Dec 19 00:12:42 2024
Received: from localhost ([127.0.0.1]:36996 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1tO8pw-0000Cu-Un
	for submit <at> debbugs.gnu.org; Thu, 19 Dec 2024 00:12:42 -0500
Received: from lists.gnu.org ([209.51.188.17]:59374)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <dk@HIDDEN>) id 1tNy7p-0008NM-8Z
 for submit <at> debbugs.gnu.org; Wed, 18 Dec 2024 12:46:21 -0500
Received: from eggs.gnu.org ([2001:470:142:3::10])
 by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.90_1) (envelope-from <dk@HIDDEN>) id 1tNy7o-0003IG-RK
 for bug-guix@HIDDEN; Wed, 18 Dec 2024 12:46:20 -0500
Received: from mout-p-102.mailbox.org ([2001:67c:2050:0:465::102])
 by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_CHACHA20_POLY1305:256)
 (Exim 4.90_1) (envelope-from <dk@HIDDEN>) id 1tNy7m-0007rU-DJ
 for bug-guix@HIDDEN; Wed, 18 Dec 2024 12:46:20 -0500
Received: from smtp2.mailbox.org (smtp2.mailbox.org
 [IPv6:2001:67c:2050:b231:465::2])
 (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
 key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256)
 (No client certificate requested)
 by mout-p-102.mailbox.org (Postfix) with ESMTPS id 4YD1Lm74T3z9tV4
 for <bug-guix@HIDDEN>; Wed, 18 Dec 2024 18:46:08 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=junkeria.club;
 s=MBO0001; t=1734543969;
 h=from:from:reply-to:subject:subject:date:date:message-id:message-id:
 to:to:cc:mime-version:mime-version:content-type:content-type;
 bh=CHI0KRKGfwVUb9KUxdQpMEhJ9w0xoFUHzgZV1QNpPCk=;
 b=K4QCV5TwUVM9WqPRnGyZD+d9eL9WxKRcmC/BTt042PmdcaprTEsLjm4GiIEZEIBwE5fWLc
 2ggXEVgCIsRm224cVyXXK1/+xA5pSvz57QG5nANkXyE10vUEdLsGtW7Xo1LdegUhSlA6Ts
 altEk9qlN5kKIB7T6SgLprzyDGroSdep9k2ODfxx4l9coBbFFRTlRHGJNiGQq6BVusrF8D
 SWGn0WjeSKGItrnzXamyAgAsMXsu9ZQ6DosOxrSNqQ47NH/54fCRJdzZX7NaDpYQFDyTJS
 FqpASWzEO6RGk7yn5jzdD480gW593wM4kuQ7UAKlJFGWQ9Lx3mhGDJc3478SCQ==
Date: Wed, 18 Dec 2024 20:46:06 +0300
From: Dmitry <dk@HIDDEN>
To: bug-guix@HIDDEN
Subject: mysql-service-type is not starting
Message-ID: <6azr2lea2enq4vnnvbmptiyyc56ts2yh7c7lzxkcasasfuknj2@jb2dsmlzsynr>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
X-Rspamd-Queue-Id: 4YD1Lm74T3z9tV4
Received-SPF: pass client-ip=2001:67c:2050:0:465::102;
 envelope-from=dk@HIDDEN; helo=mout-p-102.mailbox.org
X-Spam_score_int: -27
X-Spam_score: -2.8
X-Spam_bar: --
X-Spam_report: (-2.8 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1,
 DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1,
 RCVD_IN_DNSWL_LOW=-0.7, SPF_HELO_NONE=0.001,
 SPF_PASS=-0.001 autolearn=ham autolearn_force=no
X-Spam_action: no action
X-Spam-Score: -1.4 (-)
X-Debbugs-Envelope-To: submit
X-Mailman-Approved-At: Thu, 19 Dec 2024 00:12:35 -0500
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -2.4 (--)

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.