From nobody Sat Dec 23 01:22:05 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 4SxmcD2Fl4z54klJ for ; Sat, 23 Dec 2023 01:22:20 +0000 (UTC) (envelope-from gobble.wa@gmail.com) Received: from mail-oo1-xc31.google.com (mail-oo1-xc31.google.com [IPv6:2607:f8b0:4864:20::c31]) (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 4SxmcC4gQ7z4pwL for ; Sat, 23 Dec 2023 01:22:19 +0000 (UTC) (envelope-from gobble.wa@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20230601 header.b=BI3QkIF0; spf=pass (mx1.freebsd.org: domain of gobble.wa@gmail.com designates 2607:f8b0:4864:20::c31 as permitted sender) smtp.mailfrom=gobble.wa@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-oo1-xc31.google.com with SMTP id 006d021491bc7-5945ba54d54so57098eaf.3 for ; Fri, 22 Dec 2023 17:22:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1703294537; x=1703899337; darn=freebsd.org; h=content-transfer-encoding:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=0vREpfInisxXa5NNXblF35dx7m/JhzIVJh0UlTmJQOs=; b=BI3QkIF0ITr4z2X+qk1wuUU3OoAwN9BxLNuipPmVAMg6UnrdPztDykQuVv5iVMOl1G 7tbVvGujJpkwGkff9IU6lzDEAGSxIhxp+V8aJMptFKMoWpd08LIEiL92Nx6aRWkuKIqu OKaRUuNXK0Nr5eWbPA8qO2Lp4Kevklvw08jBl6bp5OZOyO/SzVKLob3KqxXAkpo4yIHx h7bf8IRBWvt/CUtSdjE/Vbiidn/4hPVtzf1g/JgqWnIb4x3PoQsEIpJ/4vrLwP/PFoGq jOlFdXUiQOPHLk+ChjsgvWwjEv2tiPQ9qdD64JKWc3ACZ6nfte2G6Fzpvk99oxz6a3mb gkCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1703294537; x=1703899337; h=content-transfer-encoding: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=0vREpfInisxXa5NNXblF35dx7m/JhzIVJh0UlTmJQOs=; b=plPZkB3y4BRoFnVTFW9OWOnjrbQ7aOwC5kZxq1PEt7J3P5bK9Aa4LIgcDcJU/J112C DjS638cBtGkqoNtV/umgjqBeos1prUF5oVw9bdqY79nmUYu1V1iCetKIiyJ04NB/7IUz CgQAERx/yoJ2CST91mQzmxpqyFuHlWj3npCtNM/X1r5oXVJLzfAbxZR2hywwGwL0fPGF Vs1ePPrtcQIBlAx+0ddrJ5tOBmfsn5YUzLqJ78GGQhQTG5ToTNI0d/vC9R39RIbRC+xY Qsx9jaeRMNQTCdbvf06/hmy/DmODBbwIEIedxPKb0GbDiG1PucToB534xW7XD4wQMAKE goHQ== X-Gm-Message-State: AOJu0YwPwE7Xoysb7KfL5TBdBFq0GemToja5MqWNLYPW/HYV+JEYFQV2 lN28Fl4s5VYPkvKpvUuMNpKkv09c7aJ7POrLJGFUAbJQSz1AHg== X-Google-Smtp-Source: AGHT+IHbhb2ndfKhDwXK6RbQR3CjZZd6ytuVrDFq11iImfDnZCE3zvuV/t0bH5Av9C6tRdZ+Rk0idZ3KV5q9c4qDYqQ= X-Received: by 2002:a05:6359:6697:b0:16f:ebce:8126 with SMTP id so23-20020a056359669700b0016febce8126mr1782382rwb.19.1703294537551; Fri, 22 Dec 2023 17:22:17 -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: Waitman Gobble Date: Fri, 22 Dec 2023 21:22:05 -0400 Message-ID: Subject: Re: MariaDB startup issue To: FreeBSD Questions List Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Spamd-Result: default: False [-3.18 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20230601]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36:c]; NEURAL_HAM_SHORT(-0.18)[-0.182]; MIME_GOOD(-0.10)[text/plain]; FROM_HAS_DN(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; PREVIOUSLY_DELIVERED(0.00)[questions@freebsd.org]; ARC_NA(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::c31:from]; DKIM_TRACE(0.00)[gmail.com:+]; TO_DN_ALL(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; TAGGED_FROM(0.00)[]; RCVD_COUNT_ONE(0.00)[1]; RCVD_TLS_LAST(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+]; MLMMJ_DEST(0.00)[questions@freebsd.org] X-Rspamd-Queue-Id: 4SxmcC4gQ7z4pwL X-Spamd-Bar: --- On Fri, Dec 22, 2023 at 9:18=E2=80=AFPM Paul Procacci = wrote: > > > > On Fri, Dec 22, 2023 at 8: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 >> \\ >> > > Try a symlink that takes /usr/local/etc/my.cnf and points it to /usr/loca= l/etc/mysql/conf.d/server.cnf > > ~Paul > > -- > __________________ > > :(){ :|:& };: oh, will that satisfy the -f check in the rc file? (ie it won't start if the file exists). I'm not sure if that will ignore symlinks but i will check it out. mysql_prestart() { local dir for dir in /etc /usr/local/etc /etc/mysql /var/db/mysql; do if [ -f "${dir}/my.cnf" ]; then echo "Please merge existing ${dir}/my.cnf file with /usr/local/etc/mysql/conf.d/server.cnf" # return 1 fi done commenting out return 1 solves it for me. starts and runs just fine. But i'm sure other people are using it and upgraded. So I obviously missed a note or something. --=20 Waitman Gobble \\