From patchwork Sun Sep 20 15:06:59 2020 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: Peter Seiderer X-Patchwork-Id: 1367904 Return-Path: X-Original-To: incoming-buildroot@patchwork.ozlabs.org Delivered-To: patchwork-incoming-buildroot@bilbo.ozlabs.org Authentication-Results: ozlabs.org; spf=pass (sender SPF authorized) smtp.mailfrom=busybox.net (client-ip=140.211.166.137; helo=fraxinus.osuosl.org; envelope-from=buildroot-bounces@busybox.net; receiver=) Authentication-Results: ozlabs.org; dmarc=none (p=none dis=none) header.from=gmx.net Authentication-Results: ozlabs.org; dkim=fail reason="signature verification failed" (1024-bit key; secure) header.d=gmx.net header.i=@gmx.net header.a=rsa-sha256 header.s=badeba3b8450 header.b=D8Kbt+R1; dkim-atps=neutral Received: from fraxinus.osuosl.org (smtp4.osuosl.org [140.211.166.137]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ozlabs.org (Postfix) with ESMTPS id 4BvWBq2xLZz9sSW for ; Mon, 21 Sep 2020 01:07:15 +1000 (AEST) Received: from localhost (localhost [127.0.0.1]) by fraxinus.osuosl.org (Postfix) with ESMTP id E4E3585FAD; Sun, 20 Sep 2020 15:07:12 +0000 (UTC) X-Virus-Scanned: amavisd-new at osuosl.org Received: from fraxinus.osuosl.org ([127.0.0.1]) by localhost (.osuosl.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id l8RJfFJ94DnG; Sun, 20 Sep 2020 15:07:10 +0000 (UTC) Received: from ash.osuosl.org (ash.osuosl.org [140.211.166.34]) by fraxinus.osuosl.org (Postfix) with ESMTP id 7BB2F85F6A; Sun, 20 Sep 2020 15:07:10 +0000 (UTC) X-Original-To: buildroot@lists.busybox.net Delivered-To: buildroot@osuosl.org Received: from whitealder.osuosl.org (smtp1.osuosl.org [140.211.166.138]) by ash.osuosl.org (Postfix) with ESMTP id 325201BF94D for ; Sun, 20 Sep 2020 15:07:08 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by whitealder.osuosl.org (Postfix) with ESMTP id 2CD2D86974 for ; Sun, 20 Sep 2020 15:07:08 +0000 (UTC) X-Virus-Scanned: amavisd-new at osuosl.org Received: from whitealder.osuosl.org ([127.0.0.1]) by localhost (.osuosl.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id zDA01lxDgWqj for ; Sun, 20 Sep 2020 15:07:07 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mout.gmx.net (mout.gmx.net [212.227.17.22]) by whitealder.osuosl.org (Postfix) with ESMTPS id 7E79886929 for ; Sun, 20 Sep 2020 15:07:06 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1600614421; bh=kwE+vYDoxmfMxwc5kt/XVmdzvRV3FCrM2TT1DWnw1P4=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References; b=D8Kbt+R1OFRCdaXbtTdav20zSpyiT67iuzIZC3644pfNf1HI3pWSjVqk9c+nWTl6+ m2H5Zm5gHlxKxvNWGNa1BcGh1CofXr6OVwzgDDEH7eoY0xeJr1GOu4BQD2HoE7MIg3 6qa9X5hVlY2mroPAtvEOQzr1Ig0/D2jhJzkSMNOg= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from localhost.fritz.box ([62.216.209.59]) by mail.gmx.com (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MD9XF-1kAuG420sT-0097Qo; Sun, 20 Sep 2020 17:07:01 +0200 From: Peter Seiderer To: buildroot@busybox.net Date: Sun, 20 Sep 2020 17:06:59 +0200 Message-Id: <20200920150659.7562-3-ps.report@gmx.net> X-Mailer: git-send-email 2.28.0 In-Reply-To: <20200920150659.7562-1-ps.report@gmx.net> References: <20200920150659.7562-1-ps.report@gmx.net> MIME-Version: 1.0 X-Provags-ID: V03:K1:oX7V/odx4eJIvPmmmDXaoXoedhRjOxUNfmMbVK46IauP2Xtm7yw oGP6TrQxLevVyLL2MKArzbiSBmHxVMh5YeB1tUe5XGFYH53zB6YeoL93PD5oXwQ0EjGYtX3 hK+TGlttucQw0q2iVwp44/MFFM4I3U0B/E3VsU9c2DmHUe3eWEXdd+dUitMKRFj5G8q1mBB reGQdkscwETUcKxr+beig== X-UI-Out-Filterresults: notjunk:1;V03:K0:rwZZKdkYu1o=:WQxuXptzOV4RjxZkdD8+Rd cxBInpWWVhCW7lA9PcAZAuTS9Ln9+I3KSx202T+b6qIesPNGXVf2oT+KTY+wBtbkLhHdHBXoL BBlVmQmm5a84xO87a7k3SQMb+YErb7sAl5E/Qc9GInFW6xgKMEoiqFMi6V4pntHQejGIISm4I 5dTiDgW7fj6dQmL0GbLbptflVTRHZlf4/Nl1UnpJuA8ctv8ToBBmDXA7/OE1sGg0e/CXyd2QI pJ1zp/vQLei69u/GTHtzqfakz7twVhV+Y/RiDM33TTqX4eR0qr1MfFHvUV13UJ3zrpQCGHOD0 gFD/9VQeI0Dm8+gtVkJmWb0xbWvwogg+tR4QxtIkAP12tDHv1pKrORD1beJdarg1FgivQ8VLZ Fm6GCsj/p9luALW/aJk+AmKVjBD1dY6OrCakw1oT4IhwTTbgW9uUqaprZtDJ0dEQqV0ycwCBK 2MHafaEYAtEIDxfHzL3tVNX0sGelDDxb/Iaqa9T8+54ztEDGHcnUz73MJmut2lACxYneKdA41 qxnUgm94y0/0NMCMBU05mQ7jCgStVOCvltQO8sTQQCJnrwf9WKZ01Jc57ebLM9Wpw5jhaCe2r k4dEkbVTaVMkkibbRjXjzZu2SOKuud9V3pOyElv6NsEJqJJoTjt61RRjFrcCDHvOMWsJ/5OD/ YxKuju602jFrWXWJS8lXAz1p48xPe4bO3slyV2I08hqdv3cMDpgLMf+FfZiEMHs1gNKtDkYMl sn+yXhu3R25LID0UUEhKJRWzJvtGPFwnX7Fh94rLqjaajjfVunRilA9wiv5MBUYUNMbpL225b 2y7gapS9rP8JSSncMKjRHZYA7C4KqiPrIoggw+qTZJ9e/DNtrwDnjIIMCxc+NWtbbVY3EPH0w ScmO5YGH9Gf1Wp+J4xUFun2PlrTU/y/dh15B7Ux7q4D+wQZ6QAswOL2Fau+UuW/BbDczEgCE1 EpnGDIol3rNMssjHm+uRfaeI2UmdlbuvtTDbosysBaMEf2hAdhBvM5C+wQIqqT5zU3k8AcpKx l9OO5LhHBiYuq5CUSD3IHouzMSTVDrrEE+D++Vhe/HPHlS6PosIQLtnPzED1zaYROwnEn8TuT 3lvgglgDin4l2dWE82chqZXvW7bpiXALqri6UG77Azt0ZvD7D2+SYtdMOpwDRmLj1KqaaF8TQ GknXdgBwFJGYArX7vo9K0Ksyv9mmXE75vTS9OvcugqkEAcjnIKDUvZ0VX/sIfzWBADwOQ2V6N 8Txk+KnkvzIoSk1wCtFvVDnvYwjShgJmqinuSuw== Subject: [Buildroot] [PATCH v1 3/3] package/postgresql: set locale for initdb to C X-BeenThere: buildroot@busybox.net X-Mailman-Version: 2.1.29 Precedence: list List-Id: Discussion and development of buildroot List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: Romain Naour , Pascal de Bruijn , Pascal de Bruijn Errors-To: buildroot-bounces@busybox.net Sender: "buildroot" Postgresql systemd startup fails with: Starting PostgreSQL database server... [FAILED] Failed to start PostgreSQL database server. See 'systemctl status postgresql.service' for details. $ systemctl status postgresql.service | cat ● postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Sat 2020-09-12 12:16:35 UTC; 35s ago Process: 164 ExecStartPre=/bin/sh -c if [ ! -f /var/lib/pgsql/PG_VERSION ]; then /usr/bin/pg_ctl initdb -D /var/lib/pgsql; fi (code=exited, status=1/FAILURE) Sep 12 12:16:35 buildroot systemd[1]: Starting PostgreSQL database server... Sep 12 12:16:35 buildroot postgres[166]: The files belonging to this database system will be owned by user "postgres". Sep 12 12:16:35 buildroot postgres[166]: This user must also own the server process. Sep 12 12:16:35 buildroot postgres[166]: initdb: error: invalid locale settings; check LANG and LC_* environment variables Sep 12 12:16:35 buildroot systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE Sep 12 12:16:35 buildroot postgres[164]: pg_ctl: database system initialization failed Sep 12 12:16:35 buildroot systemd[1]: postgresql.service: Failed with result 'exit-code'. Sep 12 12:16:35 buildroot systemd[1]: Failed to start PostgreSQL database server. Fix it by setting a sane/always available locale=C in the startup files. A similare failure/fix was reported by Pascal de Bruijn ([1]), but with en_US.UTF-8 instead of C. [1] http://lists.busybox.net/pipermail/buildroot/2019-November/266700.html Signed-off-by: Peter Seiderer Reviewed-by: Arnout Vandecappelle (Essensium/Mind) --- Notes: - tested with the following defconfig BR2_aarch64=y BR2_cortex_a72=y BR2_ARM_FPU_VFPV4=y BR2_TOOLCHAIN_BUILDROOT_GLIBC=y BR2_PACKAGE_HOST_LINUX_HEADERS_CUSTOM_5_4=y BR2_TOOLCHAIN_BUILDROOT_CXX=y BR2_INIT_SYSTEMD=y BR2_SYSTEM_DHCP="eth0" BR2_SYSTEM_DEFAULT_PATH="/bin:/sbin:/usr/bin:/usr/sbin" BR2_ROOTFS_POST_BUILD_SCRIPT="board/raspberrypi4-64/post-build.sh" BR2_ROOTFS_POST_IMAGE_SCRIPT="board/raspberrypi4-64/post-image.sh" BR2_ROOTFS_POST_SCRIPT_ARGS="--add-miniuart-bt-overlay --aarch64" BR2_LINUX_KERNEL=y BR2_LINUX_KERNEL_CUSTOM_TARBALL=y BR2_LINUX_KERNEL_CUSTOM_TARBALL_LOCATION="$(call github,raspberrypi,linux,1c64f4bc22811d2d371b271daa3fb27895a8abdd)/linux-1c64f4bc22811d2d371b271daa3fb27895a8abdd.tar.gz" BR2_LINUX_KERNEL_DEFCONFIG="bcm2711" BR2_LINUX_KERNEL_DTS_SUPPORT=y BR2_LINUX_KERNEL_INTREE_DTS_NAME="broadcom/bcm2711-rpi-4-b" BR2_LINUX_KERNEL_NEEDS_HOST_OPENSSL=y BR2_PACKAGE_STRACE=y BR2_PACKAGE_RPI_FIRMWARE=y BR2_PACKAGE_RPI_FIRMWARE_VARIANT_PI4=y BR2_PACKAGE_POSTGRESQL=y BR2_TARGET_ROOTFS_EXT2=y BR2_TARGET_ROOTFS_EXT2_4=y BR2_TARGET_ROOTFS_EXT2_SIZE="256M" # BR2_TARGET_ROOTFS_TAR is not set BR2_PACKAGE_HOST_DOSFSTOOLS=y BR2_PACKAGE_HOST_GENIMAGE=y BR2_PACKAGE_HOST_MTOOLS=y --- package/postgresql/S50postgresql | 2 +- package/postgresql/postgresql.service | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/package/postgresql/S50postgresql b/package/postgresql/S50postgresql index 1ece4fca9e..c47880dfd8 100644 --- a/package/postgresql/S50postgresql +++ b/package/postgresql/S50postgresql @@ -7,7 +7,7 @@ umask 077 if [ ! -f /var/lib/pgsql/PG_VERSION ]; then echo "Initializing postgresql data base..." - su - postgres -c '/usr/bin/pg_ctl initdb -D /var/lib/pgsql' + su - postgres -c '/usr/bin/pg_ctl initdb -D /var/lib/pgsql -o --locale=C' echo "done" fi diff --git a/package/postgresql/postgresql.service b/package/postgresql/postgresql.service index 53e6f84f00..42d973255c 100644 --- a/package/postgresql/postgresql.service +++ b/package/postgresql/postgresql.service @@ -17,7 +17,7 @@ StandardError=syslog SyslogIdentifier=postgres PIDFile=/var/lib/pgsql/postmaster.pid -ExecStartPre=/bin/sh -c "if [ ! -f /var/lib/pgsql/PG_VERSION ]; then /usr/bin/pg_ctl initdb -D /var/lib/pgsql; fi" +ExecStartPre=/bin/sh -c "if [ ! -f /var/lib/pgsql/PG_VERSION ]; then /usr/bin/pg_ctl initdb -D /var/lib/pgsql -o --locale=C; fi" ExecStart=/usr/bin/postgres -D /var/lib/pgsql ExecReload=/usr/bin/kill -HUP $MAINPID KillMode=mixed