No my.cnf file at all?

[Polytropon]

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, ...