Date: Sat, 1 Feb 2020 23:34:56 +0100 From: Polytropon <freebsd@edvax.de> To: Andreas X <hamdi20193d@gmail.com> Cc: Paul Pathiakis <pathiaki2@yahoo.com>, "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org> Subject: Re: No my.cnf file at all? Message-ID: <20200201233456.1e8fd8ed.freebsd@edvax.de> In-Reply-To: <CAEW8WPsU7h486bMog6wefqdz4KmZkjV5iUHA_wgig8tdZGKQcQ@mail.gmail.com> References: <CAEW8WPtad9RVyRs1P6BfjYmKCXctQiaXAA0_o39F_tY4ANWS2A@mail.gmail.com> <1065217562.310518.1580586031261@mail.yahoo.com> <CAEW8WPtm1RGNtTjJ5sXCK%2Bk8QAe=xgSumh0DSh-kcUBLpBxcDg@mail.gmail.com> <20200201211024.ac11b2d8.freebsd@edvax.de> <CAEW8WPsU7h486bMog6wefqdz4KmZkjV5iUHA_wgig8tdZGKQcQ@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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, ...
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20200201233456.1e8fd8ed.freebsd>