From owner-freebsd-questions@freebsd.org Sat Feb 1 22:17:30 2020 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 1605C22E49B for ; Sat, 1 Feb 2020 22:17:30 +0000 (UTC) (envelope-from hamdi20193d@gmail.com) Received: from mail-vs1-xe35.google.com (mail-vs1-xe35.google.com [IPv6:2607:f8b0:4864:20::e35]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) server-signature RSA-PSS (4096 bits) client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1O1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4897kK2Bxtz48M0 for ; Sat, 1 Feb 2020 22:17:29 +0000 (UTC) (envelope-from hamdi20193d@gmail.com) Received: by mail-vs1-xe35.google.com with SMTP id k188so6628207vsc.8 for ; Sat, 01 Feb 2020 14:17:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=4WeHEq2Mvvo6NqPvCid5ppFqsfZaTWq1jwnOzJmenWc=; b=Fsjjz1v9ggofq6td7UhoNJcrVInNOd9YuyHZUBuaDSzs+hrqogjvzvde/Dj/PrJ16P AeWtn5DOy5/U4OFfWTkQ6ojWIGHPlKyQlyEz4xNB+ZDXG+DKsx8Bf29d+kYRi3b8LcY/ 0dfcc6curWPNjhdj0D8eRkuuLuQwg7FEInUNFpjkjNQAWHPKAbNheLsQAInBEbWAq9x0 xcZrYDnpRfrKaJrBIbZG8CMEfH49poJ5xIjinAB2tCJY9jyr+DhAXaqSLLXQ7tDq6XW9 8NotsN+xYwfoVPzYbHg3tv2YWFpVJ5BlG09YUpLpHLRKAUObN+SrLFKF9pliCUPQkJju AtNQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=4WeHEq2Mvvo6NqPvCid5ppFqsfZaTWq1jwnOzJmenWc=; b=CRFnfDe9c+qPf296VhnGMJdbbx3YxRqFtp6ZMolMbF0p1gQpqZxF7Q+EFi+QbOGOW6 3TLDHw9BDg2v9qvwu5Quoh6u9/9+57XYyuZuy4UuoNTezZZPHGSxg+3LhVdjaBm1KhBL cubJwdKuqEh2ZmxL8b1WfgLMBE0T2ONLLHOzpcJH1DfaLNyynKclmEPSGO1fsOxxgS5c 5bPJYPTSMFnkwB8BZ0kzyE/nb7SK13hQ//J1DI6gVgPghaw1WN7AiGcMHchOT9qzO7U8 UMDxSkS7Rqpg7Tv7eLmxNf7l6732iSkCURTcbmCebzTwWJ4jZ8rfPzUSG58EhuRSQdPb pmhw== X-Gm-Message-State: APjAAAUHSMw4New/hr1411MA//UKJY0/5MFCQH0oU7ha+i535GKjXodF GaMUD6tkBJNVDNr9KPzGmRcgCoV/X4ImRszt+80= X-Google-Smtp-Source: APXvYqzomJUGgQAvNN67rBx6JzKaZxKnepZdLtVXNbWulHuy9KZCsCWptA4qXd3DeTr9Vc3WXWblY8BpdePXLowAy5w= X-Received: by 2002:a67:6601:: with SMTP id a1mr10864237vsc.0.1580595448239; Sat, 01 Feb 2020 14:17:28 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ab0:71d4:0:0:0:0:0 with HTTP; Sat, 1 Feb 2020 14:17:27 -0800 (PST) In-Reply-To: <20200201211024.ac11b2d8.freebsd@edvax.de> References: <1065217562.310518.1580586031261@mail.yahoo.com> <20200201211024.ac11b2d8.freebsd@edvax.de> From: Andreas X Date: Sun, 2 Feb 2020 01:17:27 +0300 Message-ID: Subject: Re: No my.cnf file at all? To: Polytropon Cc: Paul Pathiakis , "freebsd-questions@freebsd.org" X-Rspamd-Queue-Id: 4897kK2Bxtz48M0 X-Spamd-Bar: / Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20161025 header.b=Fsjjz1v9; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of hamdi20193d@gmail.com designates 2607:f8b0:4864:20::e35 as permitted sender) smtp.mailfrom=hamdi20193d@gmail.com X-Spamd-Result: default: False [-1.00 / 15.00]; TO_DN_EQ_ADDR_SOME(0.00)[]; TO_DN_SOME(0.00)[]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36]; FREEMAIL_FROM(0.00)[gmail.com]; URI_COUNT_ODD(1.00)[3]; DKIM_TRACE(0.00)[gmail.com:+]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; SUBJECT_ENDS_QUESTION(1.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; DWL_DNSWL_NONE(0.00)[gmail.com.dwl.dnswl.org : 127.0.5.0]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000,0]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20161025]; FROM_HAS_DN(0.00)[]; RCPT_COUNT_THREE(0.00)[3]; NEURAL_HAM_LONG(-1.00)[-1.000,0]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; IP_SCORE_FREEMAIL(0.00)[]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[5.3.e.0.0.0.0.0.0.0.0.0.0.0.0.0.0.2.0.0.4.6.8.4.0.b.8.f.7.0.6.2.list.dnswl.org : 127.0.5.0]; IP_SCORE(0.00)[ip: (-8.88), ipnet: 2607:f8b0::/32(-2.00), asn: 15169(-1.76), country: US(-0.05)]; RCVD_COUNT_TWO(0.00)[2]; FREEMAIL_CC(0.00)[yahoo.com]; RCVD_TLS_ALL(0.00)[] Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.29 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 01 Feb 2020 22:17:30 -0000 Hi again, I installed via packages, not ports. And as I stated earlier, I searched for ANY file, any directory with extension .cnf, it is unbelieveable but it seems they removed it. Mariadb 10.4, FreeBSD 12.1. I need to optimize, configure and customize my MariaDB installation, that's why I need that file. Creating a local my own my.cnf file from randomly-grabbed sample config files over the Internet would be horrible. A lot of different variables such as datadir, socket path, etc, would be a huge mess. Any idea? 1 =C5=9Eubat 2020 Cumartesi tarihinde Polytropon yazd=C4= =B1: > On Sat, 1 Feb 2020 23:02:44 +0300, Andreas X wrote: > > Hi Paul, > > > > I did such search not only in /usr/local, but entire server. No, it see= ms > > they removed adding any .cnf file on the latest mariadb-server release. > > > > Could someone verify that please? > > The search for my.cnf or my.cnf.sample does not lead to any results > because MariaDB has a different naming convention (i. e., not the > ".sample" suffix everyone else uses). > > Try this: > > # find /usr/local -name my-default.cnf > > As you have installed it as a port (and it doesn't belong to the > FreeBSD OS), the location beneath /usr/local is correct. I don't > know if the sample file is already in /usr/local/etc or maybe > /usr/local/etc/mysql, maybe you'll find it in /usr/local/share > somewhere. > > Your actual configuration file /usr/local/etc/my.cnf can then be > created with the my-default.cnf template file. > > More information here: > > https://mariadb.com/kb/en/configuring-mariadb-with-option-files/ > > > > -- > Polytropon > Magdeburg, Germany > Happy FreeBSD user since 4.0 > Andra moi ennepe, Mousa, ... >