From owner-freebsd-questions@freebsd.org Sat Feb 1 22:35:03 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 1045A22ED8E for ; Sat, 1 Feb 2020 22:35:03 +0000 (UTC) (envelope-from freebsd@edvax.de) Received: from mout.kundenserver.de (mout.kundenserver.de [212.227.17.24]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "mout.kundenserver.de", Issuer "TeleSec ServerPass Class 2 CA" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 48986Y3XNsz49Pj for ; Sat, 1 Feb 2020 22:35:01 +0000 (UTC) (envelope-from freebsd@edvax.de) Received: from r56.edvax.de ([188.102.106.179]) by mrelayeu.kundenserver.de (mreue107 [212.227.15.183]) with ESMTPA (Nemesis) id 1N18MG-1jiWPS23GE-012XKc; Sat, 01 Feb 2020 23:34:56 +0100 Date: Sat, 1 Feb 2020 23:34:56 +0100 From: Polytropon To: Andreas X Cc: Paul Pathiakis , "freebsd-questions@freebsd.org" Subject: Re: No my.cnf file at all? Message-Id: <20200201233456.1e8fd8ed.freebsd@edvax.de> In-Reply-To: References: <1065217562.310518.1580586031261@mail.yahoo.com> <20200201211024.ac11b2d8.freebsd@edvax.de> Reply-To: Polytropon Organization: EDVAX X-Mailer: Sylpheed 3.1.1 (GTK+ 2.24.5; i386-portbld-freebsd8.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:2hryw3G2IKKItJdx9iCWrL1NFQ5IbkjlIc/BewNwUzPXvTpBPK8 YozTblUvqrlFdxQDbuEvl55TVRw+E0T3KkENGorreoJXpvx8bGzcgkocCjW21xTHYKeYT3f qL73nsVyNNC9T/lc4bteK3JGMk6zg5s5PyGOYKKvHqR+p8RuTVifP7k2CuP5dow2O9v8tCQ 3Qryx8F/yGZfVEHMW9JkA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:81hk3siFgbo=:0R3rSlyGPTtSINLUPefhwM vor/ET5EuoitgH6Jh9pf8WyM6f7O0wqe8lfUr99CWPmz3Pt4HCggHNX9VTRSD21vuyF36uZWU HzU5oTgUmk7SzruKp/G3jwD7Z1z+fwNvl9+VGdAp7aCiwBXoAHalqqRBk5rPXOQNHCp2YRwrN zny6n+ID5ogPesWeB7tEG06XCH1xU7ivpzOYW9WvrE45sm8cBUYBHWEvwKC5JpYP/KHkZ0mYT B6+0VZlL0HD/bdA/dTMmnnTBX1JZMB8mdW9PbkVceZqTGAxACfaFiZMh2o/0t5z9nmRsc/dKp RuXje/zhTRVYxu8dROYX/KbfqwuDbtY/wvP2dB3JnRzrwpeIQzLA6hXB4t8KmkXuWDddeYq+U UEY9PYr274atu5015O+o/oaHrC8Bgpxz2dENcyfGWQUM41QHwleBUc+KhiM7xophEB+zdarR1 rdfzGFLWyWrvLB2I3rRXp6eKKku/KV19QPWgOO0RPeLQ9qPfIkAH4fp7v91WRFAEQCWVbCEhY Q7xsaE9BJP98ZhfIvUpUq9s3ER/rgJHyCsXDUA9JZTm21ej6g+FysUTaygB+nCX56YHm/1QT6 MSYXS2JVnjreRa4Vu3vZefnJAQwme5NBBUUYEcHZjAnNEqoc4pXb0a9CUCBbibizoOC1Ulo0W ZPEfSAOCCPjjpvbTwXznm2KmI9DNAOmCO4rJ6DkqJNhwjdFsE/hl37cbo95jum2JrgcKzhUuZ Kdt/YMt6H/abZ2xOqV6CJad/wvXBu6ZGnLmImAjsg5Ov6gvskhTDuizvXQXbrjW9/ia7OL+VA sarejhDS4/rtcVaY8fXc4UNCEho6/Hw8n2oRW14yBCYpXdZAcJwf7qTPdnSRnRvyKEtxc3A X-Rspamd-Queue-Id: 48986Y3XNsz49Pj X-Spamd-Bar: +++++ Authentication-Results: mx1.freebsd.org; dkim=none; dmarc=none; spf=none (mx1.freebsd.org: domain of freebsd@edvax.de has no SPF policy when checking 212.227.17.24) smtp.mailfrom=freebsd@edvax.de X-Spamd-Result: default: False [5.10 / 15.00]; TO_DN_EQ_ADDR_SOME(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; HAS_REPLYTO(0.00)[freebsd@edvax.de]; TO_DN_SOME(0.00)[]; MV_CASE(0.50)[]; IP_SCORE(0.16)[ip: (-0.32), ipnet: 212.227.0.0/16(-1.12), asn: 8560(2.24), country: DE(-0.02)]; HAS_ORG_HEADER(0.00)[]; FREEMAIL_TO(0.00)[gmail.com]; RECEIVED_SPAMHAUS_PBL(0.00)[179.106.102.188.khpj7ygk5idzvmvt5x4ziurxhy.zen.dq.spamhaus.net : 127.0.0.11]; MIME_TRACE(0.00)[0:+]; R_DKIM_NA(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; SUBJECT_ENDS_QUESTION(1.00)[]; ASN(0.00)[asn:8560, ipnet:212.227.0.0/16, country:DE]; ARC_NA(0.00)[]; REPLYTO_EQ_FROM(0.00)[]; FROM_HAS_DN(0.00)[]; RCPT_COUNT_THREE(0.00)[3]; MIME_GOOD(-0.10)[text/plain]; DMARC_NA(0.00)[edvax.de]; AUTH_NA(1.00)[]; NEURAL_SPAM_MEDIUM(0.55)[0.547,0]; TO_MATCH_ENVRCPT_SOME(0.00)[]; NEURAL_SPAM_LONG(1.00)[1.000,0]; MID_CONTAINS_FROM(1.00)[]; RCVD_IN_DNSWL_NONE(0.00)[24.17.227.212.list.dnswl.org : 127.0.5.0]; R_SPF_NA(0.00)[]; FREEMAIL_CC(0.00)[yahoo.com]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_LAST(0.00)[] 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:35:03 -0000 On Sun, 2 Feb 2020 01:17:27 +0300, Andreas X wrote: > I installed via packages, not ports. It doesn't matter. If you compile a port, a package gets installed. So technically there's no difference, that's why termini technici like "the OS" and "from ports" are often used to distinguish between what is provided by FreeBSD (OS component) and what's 3rd party software (installed by user). :-) > 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. I definitely agree. Copypasta from discussion platforms is never a good foundation for production environments. ;-) It also seems that MariaDB's documentation, which I pointed to in my previous message, doesn't seem to match reality (or at least doesn't seem to match how MariaDB is installed and configured on FreeBSD). So in worst case, you can contact the maintainer of the MariaDB port and ask. The official documentation refers to 10.0.13 and above, which your version of 10.4 definitely matches. Allow me to repeat: Example Option Files Most MariaDB installations include a sample MariaDB option file called my-default.cnf. [...] In source distributions, the sample option files are usually found in the support-files directory, and in other distributions, the option files are usually found in the share/mysql directory that is relative to the MariaDB base installation directory. Source: https://mariadb.com/kb/en/configuring-mariadb-with-option-files/ So if this file isn't anywhere (!) to find, there is probably something wrong. > Any idea? If you can remember a _specific_ part of content that should be in my.cnf, you could search through all files (not just *.cnf) in /usr/local and see if something matches. Even though this is possible via find | xargs grep, it's probably much easier to use a tool like the Midnight Commander and its search function (M-?). Another idea: Go to /usr/ports and the MariaDB directory, run the following commands: # make fetch # make extract Without installing that version, search the newly created subtree for the file my-default.cnf (or any *.cnf), as the documentation says is should be there. If it's not, contact the port's maintainer as suggested above. -- Polytropon Magdeburg, Germany Happy FreeBSD user since 4.0 Andra moi ennepe, Mousa, ...