From nobody Sat Dec 23 01:24:18 2023 X-Original-To: questions@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4Sxmfn0PKJz54lMP for ; Sat, 23 Dec 2023 01:24:33 +0000 (UTC) (envelope-from paulbeard@gmail.com) Received: from mail-ej1-x62c.google.com (mail-ej1-x62c.google.com [IPv6:2a00:1450:4864:20::62c]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4Sxmfm2PXCz4qwF for ; Sat, 23 Dec 2023 01:24:32 +0000 (UTC) (envelope-from paulbeard@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20230601 header.b=YaaHMUL7; spf=pass (mx1.freebsd.org: domain of paulbeard@gmail.com designates 2a00:1450:4864:20::62c as permitted sender) smtp.mailfrom=paulbeard@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-ej1-x62c.google.com with SMTP id a640c23a62f3a-a2340c803c6so279007966b.0 for ; Fri, 22 Dec 2023 17:24:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1703294670; x=1703899470; darn=freebsd.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=WQ60PwLP6kmfiMH23EdciWlnWfabWmsvnIpEIYu+wUQ=; b=YaaHMUL7RN2DMYJisJpGZ7wXPmnC/vTK6rE6l8wspsRhEsdJhExOoTbYpRJVhUR5+H OlvfxW+epnMr0tYSfa1tCcfhejLyXGR5UDkjvlysec+6uLstQVHnfJLm9+nyhaa6eNS9 mAxlUuBInh5XnZhGJ+e001+m93oUCYZ2wiskx1Y3K5JDkWrAUcclCEEyzOch52WcsOsR Bx4fvRxd6a4N2fo0idUHeStIIloQQVI0yasvWEmvUYzqlZAInnn2gZMPx2TUDXm5phJX VFXanp0X/sErqNW6RMpsLQsOVmFaMzz8nPp7/cpR8T0SnKb7vu7Z33cxkaRCU9xehrfc 5/FQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1703294670; x=1703899470; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=WQ60PwLP6kmfiMH23EdciWlnWfabWmsvnIpEIYu+wUQ=; b=IFFsR6WFOLquXf5Yr3x0JRSSfIfBFIn20Umf8OdRTW8h0cFuGamJ04EUDefgMoiQ2z zESqfs6K3F0i+v642CUhGm0WNznZN7QK7hRJ7clhYjtL5YH56MfnjE8WvAXhxt0Dbi/f MxWYPeJ/rIxfXNKiuHxuarlSnaaLVABtmzAKSwsjHC4ho2yzxXVwXrQJHuvK7FZTklA0 Jzt5LVolVDrVP2mYHN9qXwGYr2PTFdEAtqZ8KK0l6UcFUwIIKEO1OtaicDPTjKSPcOZI HfWG5IsE7D43+8+cg8xfKm98TC3n9SGDxSlx0WGTOKPfCZQJBwnOWv5dyCVDUfJRWJC2 7PFg== X-Gm-Message-State: AOJu0YyylRbik7elbJh661Tx2iejL+Zpy7h0oJ28bbuAeaDWXJcXeywO 0DSb5NxnydzIMtS5EwuhxRHfjafRdlOy74Ag5QsGfAITukA= X-Google-Smtp-Source: AGHT+IGNZo6n6s0opGsFskkXwPgCaRCJl//jV7Qw5d3IrD2UyyAK95LrPkiK8CjGZF0MW0hpQ0xVVZIwSOc6Z8KC6UI= X-Received: by 2002:a17:906:51d1:b0:a26:9933:2f9f with SMTP id v17-20020a17090651d100b00a2699332f9fmr1317061ejk.16.1703294670104; Fri, 22 Dec 2023 17:24:30 -0800 (PST) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: paul beard Date: Fri, 22 Dec 2023 17:24:18 -0800 Message-ID: Subject: Re: MariaDB startup issue To: Waitman Gobble Cc: FreeBSD Questions List Content-Type: multipart/alternative; boundary="000000000000c26c48060d233164" X-Spamd-Result: default: False [-3.89 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.89)[-0.889]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_SPF_ALLOW(-0.20)[+ip6:2a00:1450:4000::/36]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20230601]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; FROM_HAS_DN(0.00)[]; ARC_NA(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; TAGGED_RCPT(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; TO_MATCH_ENVRCPT_SOME(0.00)[]; PREVIOUSLY_DELIVERED(0.00)[questions@freebsd.org]; RCVD_TLS_LAST(0.00)[]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; FREEMAIL_ENVFROM(0.00)[gmail.com]; DKIM_TRACE(0.00)[gmail.com:+]; TO_DN_ALL(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[2a00:1450:4864:20::62c:from]; RCPT_COUNT_TWO(0.00)[2]; FREEMAIL_TO(0.00)[gmail.com]; RCVD_COUNT_ONE(0.00)[1]; MIME_TRACE(0.00)[0:+,1:+,2:~]; FROM_EQ_ENVFROM(0.00)[]; MLMMJ_DEST(0.00)[questions@freebsd.org] X-Rspamd-Queue-Id: 4Sxmfm2PXCz4qwF X-Spamd-Bar: --- --000000000000c26c48060d233164 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable editing the RC script seems like the wrong answer. I have had this problem a few times. Does mysqld_safe run? The couple of issues I have had deal with the pid file being where the RC script doesn't expect it so stop/start/status don't work. Also, the ib* files in /var/db/mysql are often an issue. The logs usually point them out. On Fri, Dec 22, 2023 at 5:13=E2=80=AFPM Waitman Gobble wrote: > I upgraded a server from FreeBSD 13.2-RELEASE to FreeBSD 14.0-RELEASE > > During pkg upgrade it removed mariadb 10.4. I installed mariadb 10.6 > no biggie. Except I seem to be in a chicken and egg paradox. When I > start the message is: > > Please merge existing /usr/local/etc/my.cnf file with > /usr/local/etc/mysql/conf.d/server.cnf > > OK I did that. I renamed the file to /usr/local/etc/my.cnf.x > > service mysql-server start says it's starting but actually never > starts the server. no error in the logs I can find. I'm obviously > missing something? > > If I use the same command the rc script is executing (WITHOUT > '/usr/sbin/daemon' that the rc script uses) I see the error finally! > > /usr/local/bin/mariadbd-safe > --defaults-extra-file=3D/usr/local/etc/my.cnf --user=3Dmysql > --datadir=3D/var/db/mysql --pid-file=3D/var/db/mysql/mysql.pid > Could not open required defaults file: /usr/local/etc/my.cnf > Fatal error in defaults handling. Program aborted > > OK so i made a blank /usr/local/etc/my.cnf and get this message: > > Please merge existing /usr/local/etc/my.cnf file with > /usr/local/etc/mysql/conf.d/server.cnf > > So it's a loop. I guess I need to edit the rc script but i think i am > missing something? Any ideas? > > TIA and HH > > -- > Waitman Gobble > \\ > > --=20 Paul Beard / www.paulbeard.org/ --000000000000c26c48060d233164 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
editing the RC script seems like the=C2=A0wrong answer. I = have had this problem a few times. Does mysqld_safe run? The couple of issu= es=C2=A0I have had deal with the pid file being where the RC script doesn&#= 39;t expect it so stop/start/status don't work. Also, the ib* files in = /var/db/mysql are often an issue. The logs usually=C2=A0point them out.=C2= =A0

On Fri, Dec 22, 2023 at 5:13=E2=80=AFPM Waitman Gobble <gobble.wa@gmail.com> wrote:
I upgraded a server from FreeBSD 13.2-RELEASE to FreeBSD 14.0-R= ELEASE

During pkg upgrade it removed mariadb 10.4. I installed mariadb 10.6
no biggie. Except I seem to be in a chicken and egg paradox. When I
start the message is:

Please merge existing /usr/local/etc/my.cnf file with
/usr/local/etc/mysql/conf.d/server.cnf

OK I did that. I renamed the file to /usr/local/etc/my.cnf.x

service mysql-server start says it's starting but actually never
starts the server. no error in the logs I can find. I'm obviously
missing something?

If I use the same command the rc script is executing (WITHOUT
'/usr/sbin/daemon' that the rc script uses) I see the error finally= !

/usr/local/bin/mariadbd-safe
--defaults-extra-file=3D/usr/local/etc/my.cnf --user=3Dmysql
--datadir=3D/var/db/mysql --pid-file=3D/var/db/mysql/mysql.pid
Could not open required defaults file: /usr/local/etc/my.cnf
Fatal error in defaults handling. Program aborted

OK so i made a blank /usr/local/etc/my.cnf and get this message:

Please merge existing /usr/local/etc/my.cnf file with
/usr/local/etc/mysql/conf.d/server.cnf

So it's a loop. I guess I need to edit the rc script but i think i am missing something? Any ideas?

TIA and HH

--
Waitman Gobble
\\



--
Pa= ul Beard / www.paul= beard.org/
--000000000000c26c48060d233164--